SQL Server 2008 Full-Text Search: Internals and Enhancements
SQL Server Technical Article
Writer: Fernando Azpeitia Lopez, Microsoft Corp.
Published: July 2008
Database systems must go beyond the traditional realm of relational data by covering an increasing amount and variety of unstructured and semistructured information, be it speech, documents, XML, bioinformatics, chemical, or multimedia. Search is a key technology capable of working with vast amounts of data: it is scalable, low-latency, and very user-friendly. It is just what is needed to make a database the best place to store all types of data.
SQL Server 2008 introduces a new Full-Text Engine that is integrated into the relational database. Full-text search is now as fully integrated as any other database service. The main goal for full-text search in SQL Server 2008 was to introduce a new integrated Search platform. In addition to the improvements and gains that come with this integration, this platform provides a strong base for delivering, in the near future, innovative new features and capabilities that combine the strengths of searching and querying.
Read white paper SQL Server 2008 Full-Text Search: Internals and Enhancements
Abstract courtesy : Microsoft
Reference: Pinal Dave (https://blog.sqlauthority.com)
Kindly confirm one thing.
Is it possible to search by giving half part of the word like ‘youn’ instead of giving ‘young’ by some how using full text search.