Text & patterns Scalar

jaro_winkler_similarity()

The Jaro-Winkler similarity between two strings. Different case is considered different. Returns a number between 0 and 1

Arguments & returns

2 overloads

Scalar

Overload link	`str1`	`str2`	Returns
#01	`VARCHAR`	`VARCHAR`	`DOUBLE`

Scalar

Overload link	`str1`	`str2`	`score_cutoff`	Returns
#02	`VARCHAR`	`VARCHAR`	`DOUBLE`	`DOUBLE`

SELECT jaro_winkler_similarity('duck', 'duckdb');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT
  jaro_winkler_similarity('duck', 'duckdb', 0.5);

JAROWINKLER_SIMILARITY('hello', 'world')

In DuckDB

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