Text & patterns Scalar

jaro_similarity()

The Jaro 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_similarity(s1, s2)`

Scalar

Overload link	`s1`	`s2`	Returns
#01	`VARCHAR`	`VARCHAR`	`DOUBLE`

`jaro_similarity(s1, s2, score_cutoff)`

Scalar

Overload link	`s1`	`s2`	`score_cutoff`	Returns
#02	`VARCHAR`	`VARCHAR`	`DOUBLE`	`DOUBLE`

Example

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3