4 Replies Latest reply: Apr 3, 2013 8:10 AM by Rupert Cavendish RSS

    Fuzzy Search in Scripts

    Rupert Cavendish

      I am looking to define a true fuzzy search in scripting form so that it would find the most likely result from an input:

       

      Input:

       

      Blk

      Black

      Bk

      White

      Blu

      B

      Pk

       

      Lookup Table:

       

      Black

      White

      Blue

      Pink

      Orange

       

      Result:

       

      InputResult
      BlkBlack
      BlackBlack
      BkBlack
      WhiteWhite
      BluBlue
      BBlue or Black
      PkPink

      as can be seen, this example cannot use wildcards, but must use fuzzy logic. Under ideal circumstances, there would be a factor that would say how close the match was - I know this bit is asking a lot!

       

      I have thousands of records that I wish to match in this way .........

       

      Thanks in advance.