Full-Text Search
Microsoft SQL Server 2005 contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.
Full-Text Search Concepts Provides an overview to the concepts related to Full-Text Search.
Full-Text Search Administrator InfoCenter Focuses on quickly familiarizing a database administrator with the tasks of maintenance and optimization related to Full-Text Search.
Full-Text Search Developer InfoCenter Focuses on quickly familiarizing a developer with concepts important for developing applications related to Full-Text Search.