Storing in a text column and using the Full Text Search engine does quite well. However depending on the amount of data building the Full Text index can take awhile so keep that in mind. See BOL for more info.