Enabling Full-Text Search for an English Query Model

Enable Microsoft Search service and the full-text search feature to support faster, more powerful, and more flexible searches of structured and unstructured textual data in SQL databases.

Using full-text search, users' questions can:

• Retrieve more information because the full-text searches can be for: inflections (alternate tenses and singular and plural forms); automatic combinations of successive words into search phrases; prefix stemming to search for various derived phrases; and proximity searching for words that occur near one another.
  
  
• Work much faster because they take advantage of the full-text indexes that are maintained in the database.
  
  
• Return documents that match or partially match the queries in order or relevance.

For example, using full-text search, the question "What movies released last year were about a big asteroid threatening to crash into Earth" generates the full-text FREETEXTTABLE() function. This function searches for many words and phrases (big, asteroid, threatening, crash, Earth,), all of the tenses of the verbs, singulars and plurals of the nouns, and phrases such as big asteroid.

To enable full-text searching

Model Editor

See Also

Creating a Mixed English Query Model

Creating an English Query Model

Defining Entities in an English Query Model

Enabling Analysis Services for an English Query Model

Expanding an English Query Model

Testing an English Query Model