Fuzzy Matching
Similarity scoring, approximate matching, fuzzy search and lookup
| Function | What it does |
|---|---|
fuzzy.BestMatch | Find closest match from candidates list. Optional threshold: returns empty string if best score is below it |
fuzzy.BestMatchWithScore | Find closest match with score and index. Optional threshold: returns empty match and index -1 if best score is |
fuzzy.Contains | Fuzzy substring search using sliding window (default threshold 0.8) |
fuzzy.FindAllMatches | Find all candidates above similarity threshold |
fuzzy.IsMatch | Check if similarity meets threshold (default 0.8) |
fuzzy.LookupMatch | Fuzzy VLOOKUP: find best match in searchCol, return value from returnCol. Optional threshold: returns nil if b |
fuzzy.Similarity | Normalized similarity score 0.0-1.0 (1.0 = identical) |