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 “investigators” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
investigators175246(None) 
investigator1652761investigator_
investigatory2062231investigatory
coinvestigators21101382coinvestigators
instigators1245922in__stigators
investigates16104212investigat_es
investigations1853722investigations
coinvestigator2091463coinvestigator_
instigator1146413in__stigator_
investigate15104303investigat__e
investigated17113913investigat_ed
investigating1853343investigating
investigation1754083investigation
investigative2062633investigative
castigators1445544__castigators
estimators1247024___estimators
estivators1345924___estivators
initiators10127314in__iti_ators
inseminators1453764inse_minators
inspirators1345554in__spirators
instigates1148424in__stigat_es
instigations1348244in__stigations
institutors1153214in__stitutors
interrogators1454284interrogators
invalidators1652864inv_alidators
investigational1961934investigational
investiture1472544investi__ture
investitures1572594investi__tures
investors12227724inves____tors
invigilators1653184inv_igilators
reinvestigates1861864reinvestigat_es
ventilators14105064__ventilators
avigators13177095_av___igators
castigator1345765__castigator_
designators1344305__des_ignators
devastators1552925devast__ators
estimator1147425___estimator_
estivator1246295___estivator_
hesitators1385855__hes_itators
illustrators1252005illust_rators
indagators1244155in___dagators
indicators1348615in___dicators
indoctrinators1761525indoctrinators
infestations1546625infest__ations
infiltrators1552745infilt_rators
ingestions1197595ingesti___ons
ingratiatory1662485ingrati_atory
inheritors1345635inhe_ri__tors
initiator998115in__iti_ator_
initiatory13125815in__iti_atory
inseminator1354245inse_minator_
insinuators1154145in__sinuators
inspirator1245775in__spirator_
inspiratory1654415in__spiratory
inspissators14111825in__spissators
instigate1048615in__stigat__e
instigated1247695in__stigat_ed
instigating1347155in__stigating
instigation1249245in__stigation
instigative1555125in__stigative
instituters1153225in__stituters
institutor1053675in__stitutor_
instructors1355385in__structors
insulators1047265in__s_ulators
integrators1246525inte__grators
interdictors1554455interdi_ctors
interpolators1554855interpolators
interrogator1355005interrogator_
interrogatory1773645interrogatory
intestates10159435intest__at_es
intimaters1297855in___timaters
intimidators1554165in_timidators
invalidator1553195inv_alidator_
inveighers1742025inve__ig_hers
inveiglers1442045inve__ig_lers
inventions1348315inventi___ons
inventors12288255inve____ntors
invertors12239795inve____rtors
investments1665905investment__s
investor11247415inves____tor_
invigilator1553605inv_igilator_
invigorators1653145inv_igorators
invitatory1644785inv___itatory
irrigators1145635i___rrigators
litigators1145385___litigators
masticators1546325__masticators
mitigators1345375___mitigators
navigators1464825_n__avigators
negators92411175_n_e___gators
negotiators1253165_negoti_ators
potentiators1453225potenti_ators
predestinators1762505predestinators
reinvestigate1762055reinvestigat__e
reinvestigated1961735reinvestigat_ed
reinvestigating2071915reinvestigating
reinvestigation1962185reinvestigation
respirators1375445__respirators
rusticators1344945__rusticators
testators947335__test__ators
ventilator13115115__ventilator_
ventilatory17114125__ventilatory
vitiators1246925__v_iti_ators

Search took 10 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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901029.64312941.0
3Display Results1021020.0601700.0
 (SQL Overall)1786911029.84318154.1
 
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.