v.19.4New Features

N-gram Distance Was Added for Fuzzy String Comparison

Official CH changelog text
N-gram distance was added for fuzzy string comparison. It is similar to q-gram metrics in R language. #4466 (Danila Kutenin)
Added N-gram distance function for fuzzy string comparison, similar to q-gram metrics found in R.

Why it matters

This feature enables more effective fuzzy string comparison by measuring similarity based on N-grams, helping users perform approximate matching and improve search and data cleaning tasks involving text data.

How to use it

Use the new N-gram distance function in SQL queries to compare strings based on their N-gram similarity. Integrate it wherever fuzzy string comparison is needed for ranking or filtering results.

Related resources

PreviousNext