The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer. All content provided on this blog is for informational purposes only. The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information. This policy is subject to change at any time. The owner is not an attorney, and nothing posted on this site should be construed as legal advice. Litigation Support Tip of the Night does not provide confirmation that any e-discovery technique or conduct is compliant with legal, regulatory, contractual or ethical requirements.
Ranks NL has posted stop word lists in several different languages here: https://www.ranks.nl/stopwords. There are multiple lists in English, including that used by MySQL. Ranks NL is recommended by Relativity for use in a conceptual index. See this guide to Analytics indexes.
Stop words lists are included for many foreign languages.
When most people run a search in a document database, they use a proximity search, looking for a first name within 2 or 3 words of their last name. For example, using dtSearch on might structure a search like this:
john w/3 smith
Searching for someone's last name may work if it's an unusual surname, but running a general search for a name like Smith will return many false positives that will have to be sifted through. The proximity search will exclude documents where the person in question is only referred to by their last name. What if there is an email in which someone says, "It was that damn Smith who masterminded the fraud!". You wouldn't want to miss that message.
A good approach is to go through search results and find what other individuals (or objects) share the same name as the person who your search is focused on.
In a Relativity dtSearch like this, you can use the NOT operator before the 'w/' proximity operator to search for a last name when it does not appear near certain first names.
This search will find a document like this one, which happens to mention a John Smith, but more importantly refers to the Connie Smith that is the subject of the search. Documents which only refer to John Smith will be excluded from the results.
The wonderful folks at Nirsoft have another great free application that will make your job easier.
SearchMyFiles can be downloaded here. As you can see it allows you to run Boolean searches for files of a set size, that were created or modified in a particular time range.
Its duplicate search mode can also be used to search for duplicate file names with identical content, or only duplicate names with non-identical content.