Similarity Scoring
SIMILARITY
Returns a 0-1 fuzzy similarity score between two values.
Syntax
=SIMILARITY(left, right, [method], [case_sensitive])Parameters
NameTypeDescription
Name
leftTypetext, number, date, or range
DescriptionFirst value or range to compare.
Name
rightTypetext, number, date, or range
DescriptionSecond value or range to compare.
Name
method?Typetext
DescriptionMatching method. Defaults to "jaro_winkler"; use "token_sort" for reordered labels.
Name
case_sensitive?Typeboolean
DescriptionTRUE preserves case. Defaults to FALSE.
Returns
A score from 0 to 1. Matching ranges spill pairwise scores; one scalar against a range maps across the range.
Example
=SIMILARITY("Jilian", "Jillian")Result: 0.971429
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.