Skip to main content
System StatusContact Support
VersionOne Community

Stop Words List

Editions

This feature is available in all editions.

editions-all.png

On-Demand (V1 Hosted) Installations

On-Demand (or versions hosted by VersionOne) are configured to ignore stop words in search results (see the Stop Words List Sample below). This means that you will not see matches when a specific set of terms is used, but they will not prevent other terms in the query from matching. 

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

The VersionOne 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 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

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

On-Premise (Local) Installations

If VersionOne 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

  • Was this article helpful?