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

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

107 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
hesitated137778(None) 
hesitate1169971hesitate_
hesitater1276921hesitater
hesitates1269791hesitates
estated83715572_es_tated
gestated102910572ges_tated
hebetated1544662hebetated
hesitaters1374852hesitaters
hesitator1286022hesitator
levitated1346412levitated
meditated1348082meditated
resinated10413282resinated
resituated1147322resituated
restated93120182res_tated
vesicated15117652vesicated
aestivated14106293aestivated
agitated1038413_agitated
befitted14305723befit_ted
besotted1135843besot_ted
capitated14159043capitated
cavitated15177353cavitated
cogitated1346323cogitated
crepitated1584743crepitated
cristated1247423cristated
decimated1548953decimated
dedicated14310253dedicated
demitted12288773demit_ted
denitrated1298033denitrated
dentated10411703de_ntated
depilated1339653depilated
desiccated1644993desiccated
designated1345933designated
desisted1039783desi_sted
desolated1139653desolated
destituted1255253destituted
deviated13311043devi_ated
digitated1286963digitated
emitted103010853_emit_ted
epilated11310753_epilated
estate64719763_es_tate_
estates74520183_es_tates
estimated12109443_estimated
estivated13108323_estivated
festinated1447533festinated
geminated1338553geminated
gestate83614073ges_tate_
gestates93213733ges_tates
habituated1643053habituated
hastate10313913has_tate_
heated104525593he___ated
hebetate1347053hebetate_
hebetates1446433hebetates
heisted113210653he_i_sted
heritage1246533heritage_
heritages1346713heritages
herniated1346013herniated
hesitance1445553hesitance
hesitances1545543hesitances
hesitancy1743543hesitancy
hesitant1149083hesita_nt
hesitantly1653003hesitantly
hesitating1448003hesitating
hesitation1349633hesitation
hesitators1385853hesitators
imitated1138263_imitated
instated91613343ins_tated
irritated1076133irritated
levigated1445643levigated
levitate1137933levitate_
levitates1247863levitates
mediated123011873medi_ated
medicated15410073medicated
meditate11310623meditate_
meditates1239813meditates
militated1248803militated
misstated1278973misstated
pepsinated1545233pepsinated
redictated1447483redictated
refitted12309413refit_ted
remitted113312073remit_ted
reseated93220263res_eated
resifted12310153resi_fted
resighted1436523resighted
resinate8316773resinate_
resinates9314763resinates
resisted9312693resi_sted
resited85122423resi__ted
resituate948613resituate_
resituates1047753resituates
reslated93517523res_lated
resonated10510613resonated
restaged103011863res_taged
restarted10410053res_tarted
restate73824883res_tate_
restates83423433res_tates
restituted1156533restituted
sanitated1068993sanitated
seriated92717023seri_ated
situated938033__situated
stated75427833__s_tated
testate73916233tes_tate_
testates83615453tes_tates
unstated91615813uns_tated
vegetated1445083vegetated
veritates12310973veritates
vesicate131210053vesicate_
vesicates14119033vesicates

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411077.40620070.3
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.87522690.9
 
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.