NGRAM_SEARCH

Returns a similarity score between two strings based on n-gram matching.

Analyze Syntax

func.ngram_search(<str1>, <str2>, <n>)

Analyze Examples

func.ngram_search('StarRocks', 'Starrocks', 4)

┌─────┐
 0.5  
└─────┘

SQL Syntax

NGRAM_SEARCH(<str1>, <str2>, <n>)

SQL Examples

SELECT NGRAM_SEARCH('StarRocks', 'Starrocks', 4);

┌─────┐
 0.5  
└─────┘