StringSimilarity Function Example | Teradata Vantage - StringSimilarity Example: Specify Column Ranges - Teradata® Database

Input

The input table is strsimilarity_input, as in StringSimilarity Example: Specify Column Names.

SQL Call

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

Output