HAMMING_DISTANCE

All functions > STRING > HAMMING_DISTANCE

Returns the Hamming distance between two strings of equal length.

Signatures

Returns: Number of positions at which the corresponding characters differ

HAMMING_DISTANCE(string1: VARCHAR, string2: VARCHAR) → BIGINT

Notes

• Both strings must be of equal length
• Case-sensitive comparison
• Returns the count of differing positions
• Useful for comparing binary strings or DNA sequences

Examples

SELECT
    f1 := HAMMING_DISTANCE('karolin', 'kathrin'),  -- 3 characters differ
    f2 := HAMMING_DISTANCE('karolin', 'kerstin'),  -- 3 characters differ
    f3 := HAMMING_DISTANCE('1011101', '1001001'),  -- 2 bits differ
    f4 := HAMMING_DISTANCE('ABC', 'ABC'),  -- Identical strings
    f5 := HAMMING_DISTANCE('abc', 'ABC')  -- Case-sensitive
;