so even if he spelt it wrong, or put a space between the words even though there isnt it would still bring back something in that liking.
This is tricky.
I suppose it could be done in SQL but I would prefer using code.
If it was spelt wrong you would need a lookup table for common mispellings or
break up the word into chunks and look for partial matches.
Spaces again could be broken into chunks to look for each seperated word or the whole word with spaces removed.
I wrote a similar bespoke program a couple of years ago.
I shudder to think how un-sophisticated that probably looks now