Functions/Text & patterns/jaro_winkler_similarity
Text & patterns Scalar

jaro_winkler_similarity()

The Jaro-Winkler similarity between two strings. Characters of different cases (e.g., a and A) are considered different. Returns a number between 0 and 1. For similarity < score_cutoff, 0 is returned instead. score_cutoff defaults to 0.

Arguments & returns

2 overloads

jaro_winkler_similarity(s1, s2)

Scalar
Overload link s1s2 Returns
#01 VARCHARVARCHAR DOUBLE

jaro_winkler_similarity(s1, s2, score_cutoff)

Scalar
Overload link s1s2score_cutoff Returns
#02 VARCHARVARCHARDOUBLE DOUBLE

Example

jaro_winkler_similarity example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Snowflakejarowinkler_similarity()

JAROWINKLER_SIMILARITY('hello', 'world')
In DuckDB
CAST(JARO_WINKLER_SIMILARITY(UPPER('hello'), UPPER('world')) * 100 AS INT)

SQLGlot example ↗