I need to do a keyword search on various fields in a database. However, I'm not getting my keywords from a textbox but from a string. A user enters a question or sentence, and I need to find other records that may be related.

Problem 1) I figure to get the keywords, I would split the string on spaces, but I don't want to search for all the words, especially not the more common ones (like the, a, an, but, etc.) Could I do this with a text file of common words, or maybe a table of common words in the database?

Problem 2) Assuming I have the keywords, how would I do the search? I can't assume that the keywords will always be in the same order...

Any help would be appreciated. Code would be ok, but I'm looking more just for the general logic that I would need for such a project. Thanks.