A client in the jewelry business with hundreds of similar sounding item descriptions needs to find the item number when the tag has fallen off the piece. A typical item description would include the words "turquoise diamond necklace".

In ACCPAC IC, using the F6 key and typing in "diam turq neck" would successfully and quickly match the item even though the words are in the wrong order.

How can they use Adagio to efficiently find the item. "Contains" and "sounds like" are not successful. I have fooled around with GridView and Crystal Reports without success. Using any of the words individually produces tens of items to wade through.

I want to get the client off of ACCPAC, but I need a decent alternative.