Search Query Success Tip [Free Resource]

Have you ever gotten frustrated running search queries against a database and it won't find what you're looking for? One reason for the lack of success could be that you are not aware of the “stop words” (also called “noise words”) in your particular database system.

Over the years, I have had frustrated paralegals and attorneys ask for my help with database searches. Most of time, the issue is that they are trying to include “stop words” in their search query.

“Stop words” are words that do not contain important significance or that have very little meaning. Examples of common stop words:

and
the
a
an

An example of a problematic search query would be if you want to search for “President of the United States”. The query contains two stop words (of, the). Instead, I would search for (president w/3 “united states”). Using w/3 is a common proximity search technique that would find the terms within three words of each other.

You could also search for (president AND “united states”). The AND in this instance is a “boolean search operator”, not a search term. This query would find documents that contain both terms, even if they are not in close proximity to each other, which may not be what you want.

In a previous article entitled An Index Disguised as a List, I mentioned a “database index”. When a database index is created, “stop words” are typically excluded from the index. This means we can't search for words that are not there.

There are many variables when it comes to “stop words”.  The default list of “stop words” is not consistent across all database systems. In fact, some database systems do not use “stop words” as a default. In addition, some database systems will ignore “stop words” altogether, while other database systems will yield zero hits.

Most database search engines will include a default list of “stop words”. This default list can then be customized by the service provider, by the client, by the matter, or by personal preferences.

My advice is to find out what the “stop words” are before running any searches. If there are words in the “stop words list” that you know are pertinent to the case, which means the legal team will expect to be able to search for them, those words can be removed.

FYI, I pulled together a free resource for you that contains the default stop words lists for several of the popular database search engines we use in the legal industry. If you're interested, click the image below.

    I am very passionate about helping legal professionals succeed. I even quit my day job to devote more time to mentoring! I want to encourage you to subscribe and join the LitSuppGuru community. I share humorous, informative, and time-sensitive emails above and beyond what appears on this site.

    Please note: I reserve the right to delete comments that are salesy, offensive or off-topic.

    • mgolab

      An excellent tip Amy, and one that can at times be forgotten when things get a bit tense at times. Another of my favourite features is when the search provides you with a word wheel where you are able to enter a search term and see variants of the term in the index before searching. Alas this feature has been dropped from Ringtail.

      • Thanks Matthew, I agree that the word wheel is effective. I used to use Google’s version until it went missing. It was very helpful.

    • jose sandoval

      Thank you for such a brief and valuable article.

      • Hey Jose,
        Good to hear from you. Glad to hear you found the content helpful. Take care,Amy