Skip to content
DuckDB Extensions All extensions RapidFuzz

Jaro functions in the RapidFuzz DuckDB extension

Function category

Jaro

4 functions

Jaro similarity — match-and-transposition based. Good for short strings and typos.

rapidfuzz_jaro_distance

Scalar function Jaro
Signature
rapidfuzz_jaro_distance(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
Argument col0 Type VARCHAR Mode Positional Description
Argument col1 Type VARCHAR Mode Positional Description
Description

Jaro similarity — character matches and transpositions. Good for short strings and typos. Raw count of edits required.

Related functions

rapidfuzz_jaro_normalized_distance

Scalar function Jaro
Signature
rapidfuzz_jaro_normalized_distance(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
Argument col0 Type VARCHAR Mode Positional Description
Argument col1 Type VARCHAR Mode Positional Description
Description

Jaro similarity — character matches and transpositions. Good for short strings and typos. Edit distance scaled to [0, 1] — 0 means identical.

Related functions

rapidfuzz_jaro_normalized_similarity

Scalar function Jaro
Signature
rapidfuzz_jaro_normalized_similarity(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
Argument col0 Type VARCHAR Mode Positional Description
Argument col1 Type VARCHAR Mode Positional Description
Description

Jaro similarity — character matches and transpositions. Good for short strings and typos. Similarity scaled to [0, 1] — 1 means identical.

Related functions

rapidfuzz_jaro_similarity

Scalar function Jaro
Signature
rapidfuzz_jaro_similarity(col0: VARCHAR, col1: VARCHAR) → DOUBLE
Arguments (Positional)
Argument col0 Type VARCHAR Mode Positional Description
Argument col1 Type VARCHAR Mode Positional Description
Description

Jaro similarity — character matches and transpositions. Good for short strings and typos. Raw count of matches.

Related functions