Search Stop Words List
This article explains the search stop word list supported in Agility.
On-Demand (V1 Hosted) Installations
Systems hosted by Digital.ai Agility all use the default SQL Stop Word lists.
The Digital.ai Agility Full Text Search (FTS) also uses a Stop Word list to prevent the search index from being overcrowded by overly common terms. FTS indexes stop words, so any queries that require a stop word will not show any results.
Because the Stop Words list includes single character terms, be sure to exclude single character terms from your search query. This includes any standalone letters or numbers.
Examples
Below are some sample of search queries that return no results. In each case, the stop word is highlighted.
| Query | Reason for No Results |
| Sprint | single-character term |
| Book | single-character term |
| Page 18 42 | stop word |
| 1.2.3 ABC | three single-character terms - treated as 1 AND 2 AND 3 AND ABC |
The content in this article applies to On-premise Digital.ai Agility instances only. If you are an On-Demand (V1 Hosted) customer, see On-Demand (V1 Hosted) System Maintenance.
On-Premise (Local) Installations
If Digital.ai 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 Word List on your SQL Server version. For more information, refer to: http://msdn.microsoft.com/en-us/library/ms142551.aspx.
Stop Words List Sample
As a reference, here are the contents of the English Stop Word list for SQL 2005. Note that Stop Word lists are language-specific.
| 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 about after all also an and another any are as at be $ because been before being between both but by came can come could did do does each else for from get got has had he have | her here him himself his how if in into is it its just like make many me might more most much must my never no now of on only or other our out over re said same see should since | so some still such take than that the their them then there these they this those through to too under up use very want was way we well were what when where which while who will with would you your |
|---|