Functions/Text & patterns/jaro_similarity
Text & patterns Scalar

jaro_similarity()

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

Arguments & returns

2 overloads

jaro_similarity(str1, str2)

Scalar
Overload link str1str2 Returns
#01 VARCHARVARCHAR DOUBLE

jaro_similarity(str1, str2, score_cutoff)

Scalar
Overload link str1str2score_cutoff Returns
#02 VARCHARVARCHARDOUBLE DOUBLE

Example

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

Engine example · Run to view results.

Catalog examples

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