1.1 - 8.10 - StringSimilarity_MLE Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)
Specify pairs of input table columns that contain strings to compare (column1 and column2), how to compare them (comparison_type), and (optionally) a constant and the name of the output column for their similarity (output_column). The similarity is a value in the range [0, 1].
For comparison_type, use one of these values:
comparison_type Description
'jaro' Jaro distance.
'jaro_winkler' Jaro-Winkler distance: 1 for an exact match, 0 otherwise.
'n-gram' N-gram similarity. If you specify this comparison type, you can specify the value of N with constant. Default: N = 2
'LD' Levenshtein distance: Number of edits needed to transform one string into the other. Edits are insertions, deletions, or substitutions of individual characters.
You can specify a different comparison_type for every pair of columns.
Default: output_column is 'sim_i', where i is the sequence number of the column pair.
[Optional] Specify whether string comparison is case-sensitive. You can specify either one value for all pairs or one value for each pair. If you specify one value for each pair, the ith value applies to the ith pair.
Default: 'false'
[Optional] Specify the names of input table columns to copy to the output table.