NGRAM Function | VantageCloud Lake - NGRAM - Teradata Vantage

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.

NGRAM is an embedded services system function.

To activate and invoke embedded services functions, see Embedded Services System Functions.

• NGRAM Function Syntax
• NGRAM Argument Types and Rules
• NGRAM Result Type
• NGRAM Usage Notes
• NGRAM Function Examples

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.