DuckDB function jaccard

The Jaccard similarity between two strings. Characters of different cases (e.g., a and A) are considered different. Returns a number between 0 and 1.

Usage

jaccard(s1 = VARCHAR, s2 = VARCHAR)

Arguments

s1

VARCHAR

s2

VARCHAR

Value

DOUBLE

SQL examples

jaccard('duck', 'luck')

See also

Other text_similarity: damerau_levenshtein(), hamming(), jaro_similarity(), jaro_winkler_similarity(), levenshtein()