Functions/Database & utility/mismatches
Database & utility Scalar

mismatches()

The number of positions with different characters for 2 strings of equal length. Different case is considered different

Alias of hamming()

Arguments & returns

mismatches(str1, str2)

Scalar
Overload link str1str2 Returns
#01 VARCHARVARCHAR BIGINT

Example

mismatches example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Catalog examples

SELECT
  hamming('duck', 'luck');