Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “reinvestigatinga” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

35 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
reinvestigating2071911reinvestigating_
investigating1853343__investigating_
reinvestigation1962183reinvestigati_on
reinvestigate1762054reinvestigat___e
reinvestigated1961734reinvestigat__ed
reinvestigates1861864reinvestigat__es
instigating1347155__in__stigating_
investigation1754085__investigati_on
investigational1961935__investigational
investigations1853725__investigations
investigative2062635__investigati_ve
reestimating1545935re___estimating_
reinitiating1345765rein__iti_ating_
reinstating1248115rein__st__ating_
reinstituting1453075rein__stituting_
reinvesting1545325reinves____ting_
coinvestigator2091466coinvestigat__or
coinvestigators21101386coinvestigat_ors
investigate15104306__investigat___e
investigated17113916__investigat__ed
investigates16104216__investigat__es
investigator1652766__investigat__or
investigators1752466__investigat_ors
investigatory2062236__investigat_ory
misestimating1853566_mi_sestimating_
predestinating1854276pre__destinating_
reinfestation1664256reinfest__ati_on
reinfestations1793886reinfest__ations
reinnervating1752926reinne__rvating_
reintegrating1554616reinte__grating_
reinventing1545256reinve____nting_
reinvigorating1962136reinv_igorating_
reinviting1446216reinv___i__ting_
renegotiating1552246re_negoti_ating_
repristinating1783066re_pristinating_

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691658740.0931921408.6
2DLD Change Limit65874354.92313380.9
3Display Results35350.0301166.7
 (SQL Overall)178691355.04635412.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.