I had a client that wanted to be able to search the admin categories / products page using multiple keywords in the search box. As an example, they wanted to be able to search for “ces wing” and have that return products including “Cessna 170 Left Wing Tip” just as easily as “Wing Elevator for Cessna 170.”
It’s essentially a multiple wildcard array for keyword bits as opposed to a single wildcard for the entire search.
It’s also very easy to install! Just modify one file and a couple of lines at that:
http://addons.oscommerce.com/info/9310