16.20 - NGRAM - Teradata Vantage NewSQL Engine

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

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Purpose

Returns the number of n-gram matches between string1 and string2.

A high number of matching n-gram patterns implies a high similarity between the two strings.

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
string1
A character string or string expression.
If string1 is NULL, NULL is returned.
string2
A character string or string expression.
If string2 is NULL, NULL is returned.
length
The value ninn-gram, which is the comparison length.
position
Specifies that the n-gram is a positional n-gram match.