I need some advise on a search soultion.

The user will put a specifc description of an item in the database(memo field).
Example: BASEFRAME OFFSET F/R DBL 40.6
Example: BASEFRAME F/R DBL 40.6
Example: BASEFRAME F/R TPL 40.6

Now I need to set up a search function that the user can type any part of the description or some combination and get the results.

Any ideas?