3 Replies Latest reply: Nov 9, 2011 8:40 AM by JR "Bob" Dobbs RSS

    Find Similar String

    Phinehas1234 Community Member

      Hi,

       

          I encounter a problem on searching similar string. Now, I have a list of company list and allow user to add / modify the company information. But, when user adds a new company, they may input duplicated company name.

       

          E.g. the company name is "The ABC Company Ltd.". User may input a new company name "The ABCD Company Ltd." or "ABC Company Ltd." or "The ABC Company Limited.".

       

          In fact, user want to find "The ABC Company Ltd.". Therefore, is there any method of search similar string? At least, the system can search the similar string and request user to confim the new company name before adding it.

       

          As I know, there is a method using SQL soundex. But, can it find out most of the similar cases? Or, is there any other methods to do it?