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

249 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
antes5633432(None) 
anes45255931an_es
antas55432031antas
ante46538901ante_
anted66328241anted
antis55033311antis
antres65021001antres
ants47243471ant_s
ates45047921a_tes
mantes84430781mantes
nates55238331nates
abates85825032abates
abbes96723522abbes
abets75621672abets
ables75935542ables
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acres76327762acres
acted88521732acted
acts66929862act_s
acutes83917722acutes
adzes155913802adzes
aedes64625152aedes
after85719792after
afters94717072afters
agates76121342agates
ages55844592a_ges
agnates82813192agnates
agues64919052agues
aides65336602aides
aits46355532ait_s
akees96119242akees
alates64833962alates
ales47067102a_les
almes75126542almes
aloes54933672aloes
alter54828502alter
alters64924222alters
altos55822952altos
alts46639902alt_s
amies76837692amies
anas46649862an_as
ands57833612an_ds
ane37866952an_e_
aneles64626292aneles
anew76623132an_ew
angas65827982angas
angel65019562angel
angels74416172angels
anger66225872anger
angers75222542angers
angles74426702angles
anils56326722anils
animes84719592animes
anis45746462an_is
anise55129702anise
anises64826692anises
ankhs12116722ankhs
ankles104818382ankles
ankus91410682ankus
anlas55626932anlas
annas55824882annas
annates72415422annates
annex12310882annex
anoas57226492anoas
anodes74418762anodes
anoles64827432anoles
ant37270792ant__
anta46839582ant_a
antae56828292antae
anteed75616112anteed
anthem113410342anthem
anthems12309422anthems
anther93715062anther
anthers103715202anthers
anti45536362ant_i
antic75728862antic
antics84621452antics
antler64615552antler
antlers74014742antlers
antra56521922antra
antre55224522antre
antsy85712792antsy
anus47131112an_us
anuses66218772anuses
apes66047432a_pes
apres75426402apres
apses76823912apses
apter76120202apter
aptest82917512aptest
ares45871022a_res
aretes64425352aretes
arles56735742arles
arses55733872arses
artel56122742artel
artels66216232artels
arts49650262art_s
ashes86230612ashes
asses55629282asses
aster55434892aster
asters65631602asters
ate37059242a_te_
attest62618612attest
aunties73920072aunties
aunts55227632aunt_s
aures55137092aures
autos56523322autos
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axites134913832axites
axles125219472axles
ayes76543512a_yes
azotes154312222azotes
banes74945582ban_es
banter84825332banter
banters94623112banters
banties94324762banties
bastes85330382bastes
bates75846342bates
bites75641172bites
butes714535872butes
bytes105217492bytes
canes75350372can_es
canoes84725882canoes
canted94825782canted
canter85230112canter
canters94827732canters
cantles94721412cantles
cantos84826972cantos
cants77036942cant_s
cantus85117762cantus
cartes86239472cartes
castes85631862castes
cates75951892cates
cetes75731102cetes
cites74435592cites
contes84432912contes
cotes76347842cotes
cutes79438322cutes
dances95120652dances
dates65639152dates
dites66339152dites
dotes65836692dotes
enates64026432enates
enter54726382enter
enters64425642enters
fanes84639892fan_es
fates85139232fates
fetes85630142fetes
gates65939512gates
gentes75324162gentes
gites65630182gites
hances115621282hances
hanses95022632hanses
hanted104124312hanted
hantles104117512hantles
hants86335402hant_s
hastes95727072hastes
hates86742572hates
inter55028492inter
inters64328052inters
intis55121642intis
janes124928122jan_es
jetes124922842jetes
jutes125125132jutes
kanes95529372kan_es
kentes105118652kentes
kites95432542kites
knees95114872knees
kytes125012912kytes
lances84824102lances
lanes54946792lan_es
lattes65324202lattes
lutes55836662lutes
manes76648962man_es
manges94628942manges
manses84225512manses
mantas85725362mantas
mantel84317972mantel
mantels94515042mantels
mantis83926032mantis
mantles94820702mantles
mates75251362mates
mattes85624532mattes
metes74736212metes
mites75141802mites
montes84226932montes
motes75944002motes
mutes75033782mutes
nabes75427092nabes
names74833362names
nances83618642nances
napes74828462napes
nares55544152nares
naves87030382naves
nets45941532_nets
nites55736342nites
noes45845392_noes
notes55034582notes
ones46146532on_es
panes76148692pan_es
pannes85522852pannes
panted95024822panted
panties94230932panties
pantos85222742pantos
pants76536922pant_s
pastes85233912pastes
pates76047892pates
pontes83627852pontes
rances84625442rances
ranees64623962ranees
ranges73826922ranges
ranted74324702ranted
ranter63826822ranter
ranters73323642ranters
rants55935342rant_s
rates55352012rates
rentes65431192rentes
rites54442552rites
rotes56143902rotes
sanes55649072san_es
sanies63031952sanies
santos64421832santos
sates54949322sates
sautes63924912sautes
sites56045432sites
snyes85012752snyes
tastes64126422tastes
tates55444982tates
totes55139682totes
unites65024852unites
unties64326922unties
utes45930882_utes
vanes85130972van_es
votes84627082votes
wanes85040882wan_es
wanted104319722wanted
wanter94423052wanter
wanters104420092wanters
wants87932212want_s
wastes96224882wastes
wites85536962wites
wytes114113432wytes
yentes95517602yentes
zanies153219672zanies

Search took 3 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 Limit538002491.62633087.3
3Display Results2492490.0633952.4
 (SQL Overall)1786912491.99989390.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.