After some more research it appears that the closest thing I could do is use FullText Indexing and a reference/lookup table...other than that it appears that this isn't a common problem with an existing solution.