Search for Homophones

Out of curiosity - has anyone implemented Search capabilities in Appian for Homophones?

E. g. searching for a user in a database field for names, typing in 'Fill', Appian will search also for 'Phil'.

Thanks

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Lead Developer

    Did you consider the soundex algorithm? You could create a dictionary of all your words + soundex value and where it is used. This "can" be done in MariaDB.

    Or just use a search engine like Azure Search etc. You can tell it to use a Levenshtein distance of choice. Levenshtein calculates the number of character mutations required to get from one word to the other.

Reply
  • +1
    Certified Lead Developer

    Did you consider the soundex algorithm? You could create a dictionary of all your words + soundex value and where it is used. This "can" be done in MariaDB.

    Or just use a search engine like Azure Search etc. You can tell it to use a Levenshtein distance of choice. Levenshtein calculates the number of character mutations required to get from one word to the other.

Children