Great question, thanks.
I really like full-text indexing, but have only had a chance to use it a couple of time in production.
Still managed to get it wrong though, due to an "epic fail" in reading comprehension (I clicked 3 answers instead of 2 after forgetting which two words I was supposed to be looking at).