StringSimilarity Example 2: Compare src_text2 to tar_text - Teradata Vantage

Input

• Input table: strsimilarity_input, as in StringSimilarity Example 1: Compare src_text1 to tar_text

SQL Call

SELECT * FROM StringSimilarity (
  ON strsimilarity_input PARTITION BY ANY
  USING
  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')
) AS dt ORDER BY id;

Output