SELECT * FROM StringSimilarity ( ON strsimilarity_input PARTITION BY ANY ComparisonColumnPairs ('jaro (src_text1 , tar_text ) AS jaro1_sim', 'LD (src_text1 , tar_text, 2) AS ld1_sim', 'n_gram (src_text1 , tar_text, 2) AS ngram1_sim', 'jaro_winkler (src_text1 , tar_text, 2) AS jw1_sim' ) CaseSensitive ('true') Accumulate ('id', 'src_text1', 'tar_text') ) ORDER BY id;