Is there a built in function for fuzzy match in Appian?
Discussion posts and replies are publicly visible
No built-in function dedicated exclusively to fuzzy matchingPlugin Provides the levenshtein() for edit-based similarity.Use soundex() for phonetic matches.Use regex for pattern-based partial matching (regexmatch()).You can use includes operator for record field search.If you could help more what exactly you are looking for with example could help better.
Thank you, Shubham — that was helpful. I'm looking to capture variations in search terms, such as matching 'Street' when someone searches for 'St', 'Drive' for 'Dr', or 'Junior' for 'Jr'. Additionally, I want to account for nicknames, like matching 'Benedict' when searching for 'Ben', or 'Meghan' when searching for 'Maggy'. However, I want to ensure that we avoid capturing unrelated or incorrect matches that simply follow similar patterns, so we maintain accuracy and avoid false positives.
Have you tried using includes operator while filtering over record? This also works as fuzzy search try it once.