SELECT * FROM StringSimilarity ( ON strsimilarity_input PARTITION BY ANY ComparisonColumnPairs ('jaro (src_text2, tar_text) AS jaro2_sim', 'LD (src_text2, tar_text, 2) AS ld2_sim', 'n_gram (src_text2, tar_text, 2) AS ngram2_sim', 'jaro_winkler (src_text2, tar_text, 2) AS jw2_sim' ) CaseSensitive ('true') Accumulate ('id', 'src_text2', 'tar_text') ) ORDER BY id;