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 “entreated” 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.

125 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
entreated1031097(None) 
estreated1039561estreated
intreated10312661intreated
untreated10312901untreated
enervated1347312enervated
entreat7315262entreat__
entreaties1048112entreaties
entreats839772entreat_s
entreaty1146172entreat_y
entrusted1065942entrusted
enwreathed1752312enwreathed
retreated10312622retreated
treated83618702__treated
uncreated12312302uncreated
untreaded1137982untreaded
anteater8311603ant_eater
antedated1146703antedated
citrated112712253citr_ated
cocreated142710093cocreated
created104323453__created
denervated1545113denervated
denitrated1298033denitr_ated
dentated10411703dent__ated
deuterated1247533deuterated
elutriated1144553elutriated
encrusted12125003encrusted
encrypted1743183encrypted
endeared1038053en_deared
enervate1148463enervate_
enervates1248723enervates
enframed1466263enfr_amed
engrafted1443733engrafted
engraved1335813engr_aved
enraged93511783en_r_aged
enrooted977423en_rooted
ensheathed17162983ensheathed
entente7412953ent_ente_
ententes8312773ent_entes
entered82718883ent_e_red
entrained1089413entrained
entranced1247393entranced
entrapped1484873entrapped
entreating11811553entreating
entreatment13115643entreatment
entrecote1144483entrecote_
entrecotes1244333entrecotes
entree61817883entre__e_
entrees71813773entre__es
entremets1147143entremets
entrenched1643633entrenched
entwisted1343803entwisted
enucleated1345123enucleated
enumerated13125783enumerated
enwreathe1552863enwreathe
enwreathes1662663enwreathes
erected103213993e__rected
escheated1546273escheated
estated83715573est__ated
estimated12109443estimated
estivated13108323estivated
estrayed1236393estr_ayed
estreat7314813estreat__
estreats839423estreat_s
excreted1846153excre_ted
exenterated1964793exenterated
extirpated2043123extirpated
extracted1946723extracted
extricated2067083extricated
extubated1944133extubated
floreated1346573floreated
generated11310203gener_ated
inbreathed1642783inbreathed
increased1245533increased
increate10312203increate_
interacted13411213interacted
interested11410333interested
intimated121010893intimated
intonated1048303intonated
intreat7416303intreat__
intreats8311543intreat_s
intrusted1076903intrusted
intubated1246453intubated
iterated91213823_iterated
laureated1096153laureated
maltreated13125143maltreated
menstruated1473743menstruated
mistreated1348423mistreated
narrated9310323_narrated
nitrated92213153nitr_ated
outrated92219313outr_ated
overtreated1547413overtreated
patriated1238533patriated
penetrated1347303penetr_ated
pretreated1347623pretreated
recreated12412533recreated
reiterated11410153reiterated
retreaded1137053retreaded
retreater9310203retreater
streaked13228453_streaked
streamed11258903_streamed
striated93414153_striated
teated74924023__t_eated
threated1259203_threated
titrated92611683titr_ated
treaded95014283__treaded
treater74219833__treater
uncrated11416313uncr_ated
uncreate10311353uncreate_
uncreates11310433uncreates
undreamed1336973undreamed
ungreased1136333ungreased
unheated121514553un_heated
unrated82621553un_r_ated
unrelated10310433un_related
unrented92413923un_rented
unrested91914513un_rested
unseated91317683un_seated
untented92613413unt_ented
untested92612413unt_ested
unthreaded1543533unthreaded
untraced112413243untr_aced
untread857413untrea__d
unwreathed1763683unwreathed
venerated1339953vener_ated
ventilated1446363ventilated

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.436409841.7
2DLD Change Limit1486411257.29620372.9
3Display Results1251250.0631984.1
 (SQL Overall)1786911257.79522923.8
 
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.