Skip to content
DuckDB Extensions All extensions RapidFuzz

Postfix functions in the RapidFuzz DuckDB extension

Function category

Postfix

4 functions

Edit distance / similarity considering only the matching suffix portion.

rapidfuzz_postfix_distance

Scalar function Postfix
Signature
rapidfuzz_postfix_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 suffixes. Raw count of edits required.

Related functions

rapidfuzz_postfix_normalized_distance

Scalar function Postfix
Signature
rapidfuzz_postfix_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 suffixes. Edit distance scaled to [0, 1] — 0 means identical.

Related functions

rapidfuzz_postfix_normalized_similarity

Scalar function Postfix
Signature
rapidfuzz_postfix_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 suffixes. Similarity scaled to [0, 1] — 1 means identical.

Related functions

rapidfuzz_postfix_similarity

Scalar function Postfix
Signature
rapidfuzz_postfix_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 suffixes. Raw count of matches.

Related functions