How to index small words (3 letters) using full-text SQL search?

Question

I have a Incidentsingle row table that has a value 'out of office'in a column Description.

However, the following query does not return this string.

SELECT * FROM Incident
WHERE CONTAINS( (Incident.Description), '"out*"' )

The word "output" is missing from the noise file (I completely cleared the noise file and rebuilt the index).

Is this because small words are not indexed in full-text SQL searches? Are there any settings for this? Is there a command that I can run to determine exactly which noise file was used to create the index?

Note. I am working on SQL 2005.

Answer 1

, , SQL Server .

, , ...

---

• 'out'
• % out%
• select ,
• 'out'
• FullText SQL Server
• , " ALTER FULLTEXT [NameOfMyCatalog] REBUILD"
• ( )
• select ,

---

, ...

Answer 2

, , , .