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

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

114 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
exenterated196479(None) 
exenterate1795681exenterate_
exenterates1885371exenterates
exonerated18106002exon_erated
degenerated1445743degen_erated
deuterated1247533_deuterated
entreated10310973__entreated
eventuated14103713event_uated
exaggerated2153763exaggerated
exasperated2153313exasperated
execrated1938353exe__crated
exenterating2054213exenterating
exenteration1955293exenteration
exonerate16107733exon_erate_
exonerates17107343exon_erates
expectorated2452323expectorated
exuberated2044493ex_uberated
generated11310203_gen_erated
penetrated1347303_penetrated
regenerated1346903regen_erated
reiterated11410153_reiterated
venerated1339953_ven_erated
adulterated1353504adulterated
alliterated1294704alliterated
antedated1146704__antedated
centered112513524_center__ed
coelenterate1452704coelenterate_
coelenterates1552854coelenterates
counteracted1747364counteracted
crenelated1375364cren_elated
deaerated11311114_de_aerated
decelerated1545924dece_lerated
decentered1445324decenter__ed
degenerate1246834degen_erate_
degenerates1346454degen_erates
denervated1545114_den_ervated
denigrated1366974_denigrated
denitrated1298034_denitrated
dentated10411704_dent__ated
deuterate1049514_deuterate_
deuterates1149084_deuterates
edentate947704edent__ate_
edentates1046954edent__ates
electorate1247604electorate_
electorates1347474electorates
emeerate10410104eme__erate_
emeerates1149374eme__erates
emendated1344664emen__dated
enervated1347314__en_ervated
entered82718884__enter__ed
enumerated13125784e_numerated
estreated1039564__estreated
eventuate12104774event_uate_
eventuates1394184event_uates
eviscerated1752524eviscerated
exacerbated23122704ex_acerbated
exaggerate1954334exaggerate_
exaggerates2054134exaggerates
exasperate1954024exasperate_
exasperates2053784exasperates
excerpted2153874ex__cerpted
execrate1739654exe__crate_
execrates1839564exe__crates
exenterations2054484exenterations
exerted152210054ex___er_ted
exhilarated2251744exhilarated
expatiated2044204expat_iated
expatriated2153084expatriated
expectorate2253314expectorate_
expectorates2353004expectorates
experted1838054ex__per_ted
exserted1636214ex__ser_ted
extenuated1843754ex__tenuated
extirpated2043124ex__tirpated
extorted1636234ex__tor_ted
extracted1946724ex__t_racted
extubated1944134ex__tubated
exuberate1845624ex_uberate_
exuberates1945284ex_uberates
federated1438424_fe_derated
fenestrated1554244fenest_rated
generate9312904_gen_erate_
generates10312714_gen_erates
integrated1289294__integrated
intenerated1247014inten_erated
interacted13411214__interacted
intreated10312664__intreated
iterated91213824___iterated
itinerated11124934itin_erated
obliterated1453824obliterated
openhearted1752194openhearted
overtreated1547414overtreated
penetrate1149234_penetrate_
penetrates1248724_penetrates
pretreated1347624pre_treated
redintegrated1662884redintegrated
reentered1038574reenter__ed
regenerate1147964regen_erate_
regenerates1247474regen_erates
reintegrated1474494reintegrated
reiterate9412934_reiterate_
reiterates10412004_reiterates
remunerated1475354remun_erated
reoperated1348154_reoperated
retreated10312624_re_treated
reverberated1853244reverberated
tentered96412104_tenter__ed
unentered1037574unenter__ed
unintegrated1453304unintegrated
untreated10312904__untreated
venenated1345904_ven_enated
venerate11312904_ven_erate_
venerates12312264_ven_erates
ventilated1446364_ventilated

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191148.28017973.3
3Display Results1141140.0631809.5
 (SQL Overall)1786911148.76620384.6
 
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.