v.23.9New Feature

Add String Distance Functions: byteHammingDistance, editDistance

Official CH changelog text
Add several string distance functions, including byteHammingDistance, editDistance. #54935 (flynn).
Introduces several new string distance functions, including byteHammingDistance and editDistance, to measure differences between strings.

Why it matters

These functions provide efficient ways to calculate the similarity or difference between strings, which is useful for tasks like data deduplication, fuzzy matching, error detection, and approximate string comparisons within ClickHouse.

How to use it

Use the new functions directly in your SQL queries. For example, you can call byteHammingDistance(string1, string2) or editDistance(string1, string2) to compute the distance between two strings.

Related resources

PreviousNext