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

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

203 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
enter5472638(None) 
center84421411center
eater54639841eater
ender64325861ender
entera64216831entera
enters64425641enters
ester54727711ester
inter55028491inter
renter64527411renter
tenter64623931tenter
venter94218721venter
after85719792after
alter54828502alter
anger66225872anger
ante46538902ante_
anted66328242anted
antes56334322antes
anther93715062anther
antler64615552antler
antre55224522antre
apter76120202apter
aster55434892aster
banter84825332banter
beater84729392beater
belter84720962belter
bender95223302bender
better84723702better
biter75030032biter
bunter85020382bunter
canter85230112canter
cater74840722cater
censer84516582censer
centers94420602centers
centner946852centner
centre84316642centre
citer74827332citer
cuter74728232cuter
dater65332312dater
defter104215922defter
denier74420692denier
denser74115192denser
dented84120512dented
deter65028042deter
dexter143810892dexter
doter65428622doter
eager65526972eager
easter65027982easter
eaten55323052eaten
eaters65535952eaters
eatery95316352eatery
edger75215952edger
eger55923572e_ger
egger74414412egger
eider64624742eider
either94517422either
elater64724202elater
elder64020022elder
elver85216242elver
ember95516802ember
emeer74815362emeer
emmer94314462emmer
emoter85415192emoter
enate54428152enate_
enates64026432enates
endear74110012endear
ended74421262ended
enders74324052enders
enserf9310762enserf
enteral73516442enteral
entered82718882entered
enterer72015632enterer
enteric9314212enteric
enteron7313332enteron
entia5318202entia
enticer91510422enticer
entire61617702entire
entree61817882entree
entry82414262entry
enure53520222enure
envier939672envier
esker94412982esker
esters64627732esters
ether84518772ether
ever77027692e_ver
ewer77523982e_wer
extern1348472extern
eyer76127282e_yer
feater95224052feater
fencer114613532fencer
fender103718722fender
fester94723512fester
fetter94120382fetter
gater64533652gater
gender83517932gender
gentes75324162gentes
gentler8378952gentler
getter74117612getter
hater85034752hater
heater94828302heater
hefter124313922hefter
hented104218752hented
hinter94021302hinter
hunter94817772hunter
infer84215032infer
inker94421092inker
inner54920632inner
intern64016542intern
inters64328052inters
jester134319152jester
kelter103214382kelter
kente95821072kente_
kentes105118652kentes
kiter95523212kiter
later54843922later
lefter93613432lefter
lender73921272lender
lenten6312882lenten
letter63722582letter
linter64625342linter
liter54736342liter
mater74438862mater
meeter83616502meeter
melter83520112melter
mender93520792mender
mentee84121292mentee
mentor8414362mentor
meter75130322meter
minter84425102minter
miter75734792miter
muter74525542muter
neater64424312neater
nester64124182nester
nether94014162nether
netter63722022netter
neuter63713792neuter
never86218642never
newer85717462newer
niter55028972niter
noter55025642noter
oater55433732oater
ofter84116872ofter
otter54423972otter
outer55633302outer
oxter123414092oxter
pater74740722pater
pelter83321622pelter
penner84616662penner
penster92811952penster
perter84422282perter
pester84827592pester
peter74427592peter
petter83924772petter
pewter114013672pewter
punter84320022punter
ranter63826822ranter
rater54943282rater
reenter73217792reenter
reinter73116842reinter
render74024142render
rente54733782rente_
rented74426592rented
renters74224812renters
rentes65431192rentes
rentier73618222rentier
rester63832432rester
seater64534162seater
sender73824412sender
sente56432882sente_
setter64023722setter
sinter63625922sinter
sneer54919952sneer
tater54138612tater
teeter65420312teeter
tender74121842tender
tenner64117102tenner
tenser64919432tenser
tented74221002tented
tenters73921102tenters
tentier73815922tentier
tester64227152tester
tetter64322452tetter
tinter63923642tinter
titer55430612titer
toter55932132toter
under64624212under
uniter64619142uniter
utter54218762utter
vender103418422vender
veneer94511692veneer
vented104617922vented
venters103717732venters
vetter93417642vetter
voter85121052voter
wanter94423052wanter
water84733312water
welter93417382welter
wester94222892wester
wetter93919442wetter
winter94222802winter
yente86220042yente_
yentes95517602yentes
yester93417982yester
zester153617792zester

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538002031.39038705.0
3Display Results2032030.0633222.2
 (SQL Overall)1786912031.763101356.2
 
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.