Can computer really understand what you want rather than simply give you what you asked it for?This post is to show the functionality of the FREETEXT (Transact-SQL) in Sql Sever;
The FreeText predicate attempts to do just that – understand the meaning of a phrase or sentence. It does this by breaking a phrase into individual words and then using the full-text indexing thesaurus to match all forms of these words, applying language rules. It may choose to return text that only contains forms of some of these words. As each row is considered for selection, an algorithm the calculates a relative ranking value, used to qualify each record against that matching phrase.[1]
Is a predicate used in a WHERE clause to search columns containing character-based data types for values that match the meaning and not just the exact wording of the words in the search condition. When FREETEXT is used, the full-text query engine internally performs the following actions on the freetext_string, assigns each term a weight, and then finds the matches.[2]
* Separates the string into individual words based on word boundaries (word-breaking).
* Generates inflectional forms of the words (stemming).
* Identifies a list of expansions or replacements for the terms based on matches in the thesaurus.
Reference 1: Beginning Transact SQL with SQL-Server 2000 and 2005 by Paul Turley and Dan Wood
Reference 2 : MSDN Microsoft
