Skip to content
DuckDB Extensions All extensions RapidFuzz

Prefix functions in the RapidFuzz DuckDB extension

Function category

Prefix

4 functions

Edit distance / similarity considering only the matching prefix portion of the strings.

rapidfuzz_prefix_distance

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

Edit distance considering only matching prefixes. Raw count of edits required.

Related functions

rapidfuzz_prefix_normalized_distance

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

Edit distance considering only matching prefixes. Edit distance scaled to [0, 1] — 0 means identical.

Related functions

rapidfuzz_prefix_normalized_similarity

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

Edit distance considering only matching prefixes. Similarity scaled to [0, 1] — 1 means identical.

Related functions

rapidfuzz_prefix_similarity

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

Edit distance considering only matching prefixes. Raw count of matches.

Related functions