Is there a built in function for fuzzy match in Appian?
Discussion posts and replies are publicly visible
Check this plugin community.appian.com/.../levenshtein
The new smart search feature support fuzzy search.
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.
Thank you for introducing Smart Services. I looked into it, and it seems well-suited for handling requirements like searching nicknames, abbreviations, and fuzzy matches. However, I noticed that it only supports record types, which we are not currently using.
Our design involves making API calls through the integration layer, manipulating the data in ER, and then mapping it to the interface. Given this architecture, how would you recommend implementing Smart Search within our setup?
Thank you for your prompt response. We are investigating the challenges that we might come across installing the plugin.
Then, your API would have to implement such search capabilities.
Did you consider to use service backed synced records?
Have you tried using includes operator while filtering over record? This also works as fuzzy search try it once.
Hi Stefan Helzle ,I am not able to see Smart search within the record type. This is what I see:This is what the document says:docs.appian.com/.../records-smart-search.html
Smart Search feature available from 25.2 version of appian.