Skip to content
DuckDB Extensions All extensions RapidFuzz

Jaro Winkler functions in the RapidFuzz DuckDB extension

Function category

Jaro Winkler

4 functions

Jaro-Winkler — Jaro with extra weight on a shared prefix. Strong default for human names.

rapidfuzz_jaro_winkler_distance

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

Jaro-Winkler — Jaro with extra weight on common prefixes. Strong default for names. Raw count of edits required.

Related functions

rapidfuzz_jaro_winkler_normalized_distance

Scalar function Jaro Winkler
Signature
rapidfuzz_jaro_winkler_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-Winkler — Jaro with extra weight on common prefixes. Strong default for names. Edit distance scaled to [0, 1] — 0 means identical.

Related functions

rapidfuzz_jaro_winkler_normalized_similarity

Scalar function Jaro Winkler
Signature
rapidfuzz_jaro_winkler_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-Winkler — Jaro with extra weight on common prefixes. Strong default for names. Similarity scaled to [0, 1] — 1 means identical.

Related functions

rapidfuzz_jaro_winkler_similarity

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

Jaro-Winkler — Jaro with extra weight on common prefixes. Strong default for names. Raw count of matches.

Related functions