There are ways to do *something*, that's not an issue. The problem is in doing something worthwhile, trustworthy and practical.

It would be trivial to split your search string into individual words and then return all of the cells that match any one of the words, but that would be useless over a large data set because, say, searching on "Dr" would match "Dr Notthe Manwewant" but wouldn't match "Doctor Lossen".

Big companies invest millions of dollars and thousands of person-hours into developing software to do this sort of thing (have a look at IBM SPSS text analyticals, for example), so you're unlikely to get a useful solution from a free forum, sorry.

Your real choices are:

1. Pay however many thousand dollars for software to do this, or
2. Sanitize your data collection/input, or
3. Employ a team of low-paid workers to do this manually.

Sorry if that's not what you want to hear, but it's how it is.