Wanted a search function that would query my product summary table, basically a long string of the colors, description, sizes, and other information for a product, and have it return a result. Guess what? Its SLOWWWWWWWWWWWWWWWWWWWW! :) Not surprised by that. So what I am looking for is some advice to speed it up, and possibly add in some smarts. Here is the query. select * from search_string where lower(searchstring) like '%"+searchTerm+"%' searchTerm can be red, which returns all items with red, and large and so forth. however mispelling a name by 1 letter, like leaving off a "n" out of "Conner" will cause you to get no results. any thoughts or help.