Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Looks for best match of a text in a list of texts.

Component Version macOS Windows Linux Server iOS SDK
List 5.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "QuickList.BestMatch"; ListRef; SearchText { ; Flags } )   More


Parameter Description Example Flags
ListRef The reference to the list returned from QuickList.New function. $List
SearchText The text to search. "Hello"
Flags Available in MBS FileMaker Plugin 14.0 or newer.
Pass 0 to use Levenshtein distance.
Pass 1 to use Jaro-Winkler distance.
Add 2 to return list of top 5 entries.
0 Optional


Returns best match, empty or error.


Looks for best match of a text in a list of texts.
If not found, returns empty result, so FileMaker function isEmpty() will tell you if it's empty (instead of just having no text).
Uses internally the Text.LevenshteinDistance function to compare all items and look for best match.
If no entry matches over 50%, this may return empty text.

See also

Release notes

Blog Entries

This function checks for a license.

Created 11st December 2014, last changed 10th November 2023

QuickList.AndColumn - QuickList.CSVSplit