Skip to content
DuckDB Extensions All extensions RapidFuzz

Hamming functions in the RapidFuzz DuckDB extension

Function category

Hamming

4 functions

Position-by-position character match count. Only meaningful when both strings have the same length.

rapidfuzz_hamming_distance

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

Number of differing positions between two equal-length strings. Raw count of edits required.

Related functions

rapidfuzz_hamming_normalized_distance

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

Number of differing positions between two equal-length strings. Edit distance scaled to [0, 1] — 0 means identical.

Related functions

rapidfuzz_hamming_normalized_similarity

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

Number of differing positions between two equal-length strings. Similarity scaled to [0, 1] — 1 means identical.

Related functions

rapidfuzz_hamming_similarity

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

Number of differing positions between two equal-length strings. Raw count of matches.

Related functions