16.20 - StringSimilarity - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
July 2019
Content Type
Programming Reference
Publication ID
English (United States)

The StringSimilarity function calculates the similarity between two strings, using the specified comparison method. The similarity is a value in the range [0, 1].

  • This function requires the UTF8 client character set.
  • This function does not support Pass Through Characters (PTCs).

    For information about PTCs, see Teradata Vantage™ NewSQL Engine International Character Set Support, B035-1125.

  • When comparing strings, the function assumes that they are in the same Unicode script in Normalization Form C (NFC).
  • When used with this function, the ORDER BY clause supports only ASCII collation.