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

148 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
enterons831415(None) 
enteron7313341enteron_
deuterons1046782deuterons
enterers82214152enterers
enterics10312852enterics
entering91920052entering
enters64425642enter__s
enthrone111110112enthrone
enthrones12910072enthrones
environs1144672environs
externs1438232exter_ns
interns73116772inter_ns
introns73515022int_rons
ailerons849853ailerons
andirons948423andirons
anserous8410543anserous
anteroom101010103anteroom
anterooms11119603anterooms
antlions839193antlions
apterous10410463apterous
benthons1337973bent_hons
caterans10313223caterans
centering122915143centering
centerings13247663centerings
centers94420603center__s
centurions1255513centurions
citrons92913223cit_rons
dendrons1047393den_drons
deuteron946003deuteron_
dexterous1745553dexterous
eateries8324313eateries
eaters65535953eater__s
echelons1385543echelons
eftsoons1142613eftsoons
elaterins9410033elaterins
elevons1067573e_levons
emerods10137653e_merods
emperors1256123emperors
enations83316903enations
enders74324053ender__s
endrins8312163en_drins
enduros8298153enduro_s
engross837123en_gross
enneagons1042133enneagons
enrols61213383en__rols
enserfs1035483enser_fs
entellus845173entellus
ententes8312773ententes
enter54726383enter___
entera64216833enter__a
enteral73516443enter_al
entered82718883enter_ed
enterer72015633enter_er
enteric9314213enter_ic
enteritis9411303enteritis
entertains1047623entertains
enthrals11278903enthrals
enthroned1396883enthroned
entires71517783entir_es
entozoans1843393entozoans
entrains8312963entrains
entrant7318873ent_rant
entrants8311753ent_rants
entraps9109763ent_raps
entreats839773entreats
entrees71813773ent_rees
entrepots1144253entrepots
entresols944023entresols
entries71523163ent_ries
entropy1247353ent_ropy
envelops1343493envelops
envenoms1343853envenoms
environ1044763environ_
enviros1034913enviro_s
erigerons1044903erigerons
erythrons1554963erythrons
esters64627733ester__s
estrins7315853est_rins
estrone7413953est_rone
estrones8313323est_rones
estrous7712533est_rous
etalons739073e_talons
eterne6311723e_ter_ne
ethions1038483e_thions
etymons1244153e_tymons
eudemons1164863eudemons
exteriors1647323exteriors
extern1348473exter_n_
externe1438573exter_ne
externes1539833externes
fencerows1742243fencerows
fenthions1544233fenthions
fenurons1174963fen_urons
generous939773gen_erous
herons94820543__herons
heteros10312683hetero_s
hyperons1649203hyperons
infernos1145903infernos
intercoms1349333intercoms
interims101013073interims
interiors9513563interiors
interjoins1747953interjoins
interloans1048263interloans
intermont11513573intermont
intern64016543inter_n_
interne73218153inter_ne
internes82721233internes
inters64328053inter__s
interzone1849363interzone
inthrone1179473inthrone
inthrones1299673inthrones
intron64215023int_ron_
intros64215773int_ro_s
inturns73210133intur_ns
kenotrons1344523kenotrons
lanterns838303lanter_ns
lecterns1035943lecter_ns
longerons1045893longerons
matrons93517633mat_rons
mentions10312893ment_ions
monteros1039453montero_s
natrons73215663_natrons
neons55818683_n_e_ons
nephrons1346853nephrons
nerols6914883_n_erols
neurons7410443_neurons
neutrons838293neutrons
onerous7312973on_erous
operons91411743_operons
patrons93818103pat_rons
penstemons1452363penstemons
pentagons1246153pentagons
pterins9812993_pterins
renters74224813renter__s
santeros8311193santero_s
sterns64616763_ster_ns
sterols7313443_sterols
tenons62916603__tenons
tentering102313203tentering
tenters73921103tenter__s
terns55226873__ter_ns
unpersons1146853unpersons
unthrone11128183unthrone
unthrones1297383unthrones
venters103717733venter__s
venturous1245583venturous
veterans1148853veterans
westerns11328963wester_ns

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621487.23620199.3
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.71623158.5
 
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.