Running a dtSearch

Use dtSearch to complete stemming, fuzzy, and proximity searches on the information included in your dtSearch index.

Considerations

Consider the following before running a dtSearch.

• You can enter search terms on multiple lines.
  • For example, by pressing Enter.
  • The hard return will not be treated as an AND/OR operator.
• dtSearch indexes are case insensitive by default.
  • All characters in a dtSearch index are normalized to lowercase.
  • For example, if your exact phrase search is an acronym like ACT, you must build a case-sensitive dtSearch index.
• The maximum number of search terms is 65,000 characters.
  • Words longer than 32 characters are truncated during indexing.
  • For more information, see Searching for words longer than 32 characters.
• We recommend avoiding wildcards in your search terms.
  • Wildcards can slow searches.
  • Wildcards can return more documents than intended.
  • Leading wildcards should not be used. For example *ing.
• We recommend limiting proximity operators.
  • Large numbers of proximity operators within a single query can cause slower performance. For example, w/ or PRE/).
  • Nesting proximity operators can also cause performance problems. For example, dog w/5 (cat w/2 bird),
  • Queries can be difficult to read and understand.
• We recommend running multiple queries that return small numbers of documents.
  • We recommend writing specific search terms.
  • Avoid using one broad query.

Running a dtSearch in the search panel

To run a dtSearch in the Search panel from the Documents list in Relativity:

1. Navigate to the search panel.
2. Click Add Condition.
3. Select (Index Search) from the Add Condition drop-down list.
   The (Index Search) window opens.
   
   
4. Select the name of your dtSearch index from the Index drop-down list.
5. Enter terms for the search in the Search Terms box. See examples of search strings and their results in the table below.

Note: Press Enter to enter search terms on multiple lines. The hard return will not be treated as an AND / OR operator.

Note: Your total number of search terms cannot exceed 65,000 characters.

6. Optionally, you can:
   • Fuzziness Level—access fuzziness for key terms by selecting the desired level from the list.
   • Enable Stemming—access stemming for key terms by selecting the box.
   • Sort by Rank—click the box to sort the results in order of the most relevance to your search terms. The most relevant documents are listed at the top of the results set, with the least relevant documents, or the documents with the smallest number of keywords, is at the end of the list.

7. If needed, repeat the above steps to add any additional search conditions.
8. Click Apply.
   The search terms populate in the Search builder.
9. Click Run Search. To stop a long running search, click Cancel.

Running a dtSearch in the Search Browser

To run a dtSearch in the Search browser:

1. Click to access the Search browser from the Documents List.
2. Click New Search.
3. Enter required fields in the Information card.
4. Click Add Condition.
5. Select (Index Search) from the Add Condition drop-down list.
   The (Index Search) window opens.

6. Select the name of your dtSearch index from the Index drop-down list.
7. Enter terms for the search in the Search Terms box. See examples of search strings and their results in the table below.

Note: Press Enter to enter search terms on multiple lines. The hard return will not be treated as an AND / OR operator.

Note: Your total number of search terms cannot exceed 65,000 characters.

8. Optionally, you can:
   • Fuzziness Level—access fuzziness for key terms by selecting the desired level from the list.
   • Enable Stemming—access stemming for key terms by selecting the box.
   • Sort by Rank—click the box to sort the results in order of the most relevance to your search terms. The most relevant documents are listed at the top of the results set, with the least relevant documents, or the documents with the smallest number of keywords, is at the end of the list.

9. If needed, repeat the above steps to add any additional search conditions.
10. Click Apply.
    The search terms populate in the Search builder.
11. Click Save or Save As.
12. Select the name of the dtSearch in the Search Browser.
13. Click Run Search. To stop a long running search, click Cancel.

Search string examples and expected results

The following table shows search string examples and their expected results. For more information, see Using dtSearch syntax options.

Search String	Returns Documents With...
apple pear	The exact phrase apple pear
"apple pear"	The exact phrase apple pear
apple AND pear	The word apple and the word pear
(apple and pear) AndAny (grape or banana)	Any document that contains apple and pear, with grape and banana also being counted as hits. Grape and banana aren't evaluated as conditions. They're simply added to the search results as optional terms to be highlighted if they appear in the document.
apple OR pear	Either apple or pear
apple W/5 pear	Apple appears within 5 words of pear
apple PRE/5 pear	Apple appears within 5 words before pear Note: Relativity does not use the POST operator. However, you can mimic this functionality by reversing the order of the terms, and using the PRE operator.
apple NOT W/5 pear	Apple does not appear within 5 words of pear
apple AND NOT pear	Apple appears but pear does not.
apple W/5 xfirstword	Apple appears in the first 6 words of the document.
apple w/5 xlastword	Apple appears in the last 6 words of the document.

Searching for words longer than 32 characters

When a word has more than 32 characters (none of which are whitespace, characters in the CJKRanges section, or symbols configured as spaces), dtSearch truncates the word and only indexes the first 32 characters. As a result, if you run a search on the first 32 characters, the search returns any words with 33 or more characters that contain the search term as the first 32 characters.

If you attempt to run a search with a string of 33 characters or more, dtSearch does not return any results because it does not truncate the query, and as we’ve seen, no word is longer than 32 characters. See below examples for reference.

Search	Length (in characters)	Returned results
supercalifragilisticexpialido	29	supercalifragilisticexpialido
supercalifragilisticexpialidoc	30	supercalifragilisticexpialidoc
supercalifragilisticexpialidoci	31	supercalifragilisticexpialidoci
supercalifragilisticexpialidocio	32	supercalifragilisticexpialidocio supercalifragilisticexpialidociou supercalifragilisticexpialidocious
supercalifragilisticexpialidociou	33	NO RESULTS
supercalifragilisticexpialidocious	34	NO RESULTS