Look in to Full Text Indexing. Its like an add-on for MSSQL Server. Its a seperate(?) service that indexes your database which you can programmaticaly access later. I am over simplifying it here. Just search for it and you will find plenty of resources.