Skip to content
DuckDB Extensions All extensions RapidFuzz

Osa functions in the RapidFuzz DuckDB extension

Function category

Osa

4 functions

Optimal String Alignment (a.k.a. restricted Damerau-Levenshtein) — counts adjacent transpositions as a single edit.

rapidfuzz_osa_distance

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

Optimal string alignment — Levenshtein with adjacent transpositions counted as one edit. Raw count of edits required.

Related functions

rapidfuzz_osa_normalized_distance

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

Optimal string alignment — Levenshtein with adjacent transpositions counted as one edit. Edit distance scaled to [0, 1] — 0 means identical.

Related functions

rapidfuzz_osa_normalized_similarity

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

Optimal string alignment — Levenshtein with adjacent transpositions counted as one edit. Similarity scaled to [0, 1] — 1 means identical.

Related functions

rapidfuzz_osa_similarity

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

Optimal string alignment — Levenshtein with adjacent transpositions counted as one edit. Raw count of matches.

Related functions