StringSimilarity Function | Teradata Vantage - 17.05 - StringSimilarity (SQL Engine) - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

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™ - Advanced SQL 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.