17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

EDITDISTANCE measures the similarity between two strings. A low number of deletions, insertions, substitutions or transpositions implies a high similarity. The insertions, deletions, substitutions, and transpositions are based on the Damerau-Levenshtein Distance algorithm with modifications for costed operations.

If either string1 or string2 is NULL, the function returns NULL.