FUZZYMATCH

Similarity Scoring

JARO_WINKLER

Returns the Jaro-Winkler similarity score between two values.

Syntax

=JARO_WINKLER(left, right, [case_sensitive])

Parameters

Nameleft
Typetext, number, date, or range
DescriptionFirst value or range to compare.
Nameright
Typetext, number, date, or range
DescriptionSecond value or range to compare.
Namecase_sensitive?
Typeboolean
DescriptionTRUE preserves case. Defaults to FALSE.

Returns

A score from 0 to 1. Matching ranges spill pairwise scores.

Example

=JARO_WINKLER("Martha", "Marhta")

Result: 0.961111

Notes

SIMILARITY uses "jaro_winkler" by default because it works well for names and short labels.

Supported methods are "jaro_winkler", "jaro", "levenshtein", "token_sort", and "token_set".

Text is compared case-insensitively by default, with whitespace collapsed and diacritics normalized.

    xs