Skip to main content

Fuzzy Matching

Similarity scoring, approximate matching, fuzzy search and lookup

FunctionWhat it does
fuzzy.BestMatchFind closest match from candidates list. Optional threshold: returns empty string if best score is below it
fuzzy.BestMatchWithScoreFind closest match with score and index. Optional threshold: returns empty match and index -1 if best score is
fuzzy.ContainsFuzzy substring search using sliding window (default threshold 0.8)
fuzzy.FindAllMatchesFind all candidates above similarity threshold
fuzzy.IsMatchCheck if similarity meets threshold (default 0.8)
fuzzy.LookupMatchFuzzy VLOOKUP: find best match in searchCol, return value from returnCol. Optional threshold: returns nil if b
fuzzy.SimilarityNormalized similarity score 0.0-1.0 (1.0 = identical)