Search Stop Words
Stop words are common words excluded from the search index to prevent overcrowding by overly common terms. This includes single character terms like standalone letters or numbers.
If searches for single characters or common words fail, refer to this list to refine your query.
On-Demand (hosted) installations
Systems hosted by Digital.ai Agility use the default SQL Stop Word lists. The Full Text Search (FTS) indexes stop words, so queries requiring a stop word will not show results.
Because the stop words list includes single character terms, exclude single character terms from your search query, including standalone letters or numbers.
Search queries that return no results
| Query | Reason for No Results |
|---|---|
| Iteration 1 | single-character term |
| Book A | single-character term |
| Page 18 of 42 | stop word "of" |
| 1.2.3 ABC | three single-character terms - treated as 1 AND 2 AND 3 AND ABC |
On-premise (local) installations
If Agility is installed on your local machines, you can alter the stop words list to suit your needs. Refer to your SQL Server documentation for instructions on altering the stop words list for your SQL Server version.
For more information, see Configure Full-Text Search on SQL Server.
Stop words list
The following table shows the English stop words list for SQL Server 2005. Stop words lists are language-specific.
Numbers and letters
1 2 3 4 5 6 7 8 9 0
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Common words
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| about | her | so |
| after | here | some |
| all | him | still |
| also | himself | such |
| an | his | take |
| and | how | than |
| another | if | that |
| any | in | the |
| are | into | their |
| as | is | them |
| at | it | then |
| be | its | there |
| because | just | these |
| been | like | they |
| before | make | this |
| being | many | those |
| between | me | through |
| both | might | to |
| but | more | too |
| by | most | under |
| came | much | up |
| can | must | use |
| come | my | very |
| could | never | want |
| did | no | was |
| do | now | way |
| does | of | we |
| each | on | well |
| else | only | were |
| for | or | what |
| from | other | when |
| get | our | where |
| got | out | which |
| has | over | while |
| had | re | who |
| he | said | will |
| have | same | with |
| see | would | |
| should | you | |
| since | your |
Related Topics
- Search Agility - Search methods and options
- Advanced Search Operators and Boolean Characters - Search syntax and operators