The Comments table has been full text search enabled. This allow fast search of information within post and replies.
There a 3 columns with a Full Text Search index:
Let say I want to know if anyone mentioned me in a post or comment, the following simple query will do the trick
SELECT author, title, body, url FROM Comments WHERE author <> 'arcange' CONTAINS(body, 'arcange')