Agility Search Stop Words List

Josiah Bernard

March 23, 2022 11:36

On-Demand (V1 Hosted) Installations

Systems hosted by Digital.ai all use the default SQL Stop Word lists.

The 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 samples of search queries that return no results. In each case, the stop word is highlighted.

Query	Reason for No Results
Sprint 1	single-character term
A Book	single-character term
Page 18 of 42	stop word
1.2.3 ABC	three single-character terms - treated as 1 AND 2 AND 3 AND ABC

Note

The content in this article applies to On-premise Agility instances only. If you are an On-Demand (Agility Hosted) customer, see On-Demand (Agility Hosted) System Maintenance.

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 Word List on your SQL Server version. For more information, please see http://msdn.microsoft.com/en-us/library/ms142551.aspx.

Stop Words List Samples

As a reference, below are the contents of the English Stop Wordlist 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