Skip to main content
sanjuktab2257
sanjuktab2257
July 10, 2025
Question

Fuzzy match in Appian

  • July 10, 2025
  • 15 replies
  • 0 views

Is there a built in function for fuzzy match in Appian?

    15 replies

    J
    jesush905075
    July 10, 2025

    Check this plugin community.appian.com/.../levenshtein

      sanjuktab2257
      sanjuktab2257Author
      July 11, 2025

      Thank you for your prompt response. We are investigating the challenges that we might come across installing the plugin.

      stefanhelzle0001
      stefanhelzle0001
      July 10, 2025

      The new smart search feature support fuzzy search.

        sanjuktab2257
        sanjuktab2257Author
        July 11, 2025

        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?

        stefanhelzle0001
        stefanhelzle0001
        July 11, 2025

        Then, your API would have to implement such search capabilities.

        Did you consider to use service backed synced records?

        shubhama926776
        shubhama926776
        July 10, 2025

        No built-in function dedicated exclusively to fuzzy matching
        Plugin 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.

          sanjuktab2257
          sanjuktab2257Author
          July 11, 2025

          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.

          shubhama926776
          shubhama926776
          July 11, 2025

          Have you tried using includes operator while filtering over record? This also works as fuzzy search try it once.

          Terms & ConditionsAccessibility statement