Searching a db

Hey all, I am looking for a way to search a MySQL DB based on a users input string. The string would be searched on particular fields in my DB, which is already setup. The problem I am having is that I want to be able to return strings that match all *or* part of their string. Right now it only returns exact (case-insensitive) matches. But I want to be able to return partial matches as well. I have the relevancy calculation worked out but I'm not sure how to go about gathering the partial matches. i.e. User inputs: Christmas Output would be something like: Christmas (100%) Christian (67%) Christy (67%) Chandelier (20%) Anything below 10% will not be displayed. I am using a class I found at phpclasses.org called better_field_search. I am looking to modify it to fit my needs but I'm not sure how to go about it. If anyone has done anything similar, I would greatly appreciate any help or direction provided. -- Joshua E Minnie Advantage Computer Services, LLC Senior Project Manager josh@acsurf.net Phone: 269.276.9690 Fax: 269.342.8750 "Don't work for recognition, but always do work worthy of recognition."