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

293 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
anthem11341034(None) 
anthems12309421anthems
anther93715061anther
aether94213672aether
ahem97225362a__hem
althea938202althea
anadem939182anadem
anathema1344582anathema
another10289152another
antae56828292antae_
ante46538902ant_e_
anted66328242ant_ed
anteed75616112anteed
antes56334322ant_es
anthemed1446952anthemed
anthemia1349192anthemia
anthemic15410322anthemic
anthers103715202anthers
antler64615552antler
antre55224522antre_
antres65021002antres
antrum8611312antrum
apothem1444642apothem
exanthem2043112exanthem
panther12611442panther
them97427042__them
aahed917816443a_ahed
abohm1247973aboh_m
ache96829823a_che_
ached119227833a_ched
aches106132293a_ches
acted88521733act_ed
adeem8311803a_deem
aethers103614943aethers
after85719793aft_er
ahed89536253a__hed
airthed11328303airthed
aitches123014363aitches
alchemy1743113alchemy
alter54828503alt_er
althaea1044353althaea
altheas1038223altheas
altho86312603alth_o
anadems1036143anadems
anathemas1444883anathemas
ancho104515303anch_o
anchor113911973anchor
anchos114214893anchos
ane37866953an__e_
anele55628833anele_
aneled74719283aneled
aneles64626293aneles
anes45255933an__es
anethol1045383anethol
anew76623133an__ew
angel65019563an_gel
anger66225873an_ger
angle64528873angle_
angled84219093angled
angler74017863angler
angles74426703angles
anile54634463anile_
anime75423203anime_
animes84719593animes
anise55129703anise_
anises64826693anises
ankh111114413ankh__
ankhs12116723ankh_s
ankle95220253ankle_
ankled114313483ankled
ankles104818383ankles
anklet105618733anklet
annex12310883an_nex
anode65021043anode_
anodes74418763anodes
anole55330383anole_
anoles64827433anoles
anonym1136383anonym
ansae55720973ansae_
answer936893answer
ant37270793ant___
anta46839583ant__a
antas55432033ant_as
antbear935063antbear
anthelia1149113anthelia
anthelix1845923anthelix
antheming1587293antheming
anthemion1445403anthemion
antheral1149393antheral
antherid12611093antherid
antheses11311473antheses
anthesis11312503anthesis
anthill1048203anthill
anthoid11313313anthoid
anthrax1757153anthrax
anti45536363ant__i
antiar6317173antiar
antic75728863ant_ic
antick124814583antick
antics84621453antics
antigen8311123antigen
antihero1147663antihero
antijam1648283antijam
anting75827023anting
antired82316193antired
antis55033313ant_is
antisex1439693antisex
antlers74014743antlers
antonym1246513antonym
antra56521923ant_ra
antral65719413antral
antrums969173antrums
ants47243473ant__s
antsier7410773antsier
antsy85712793ant_sy
anuses66218773anuses
anyhow1544103anyhow
anytime1246043anytime
apothegm1652123apothegm
apothems1544223apothems
apter76120203apt_er
arched125717323arched
archer115016243archer
arches114822043arches
artel56122743art_el
artier63419733artier
ashed97829773a_shed
ashen87818673a_shen
ashes86230613a_shes
aster55434893ast_er
astheny1345293astheny
asthma11126563asthma
ate37059243a_t_e_
ates45047923a_t_es
atheism1248523a_theism
atom67824523a_t_om
auntie64317703auntie_
aunties73920073aunties
author939763author
autism83815333autism
autoed7712823autoed
banshee121212453banshee
bantam10314063bant_am
banter84825333bant_er
banties94324763banties
bathe105822883bathe_
bathed125518743bathed
bather115322513bather
bathes116524833bathes
bethel1169643bethel
bother115218063bother
canted94825783cant_ed
canteen9411083canteen
canter85230113cant_er
canthal12410053canthal
canthi11310973canth_i
canthus1248713canthus
cantle84522153cantle_
cantles94721413cantles
cither114616683cither
dither104417683dither
earthed1139923earthed
earthen1039253earthen
either94517423either
enter54726383ent_er
entree61817883entree
esteem838813esteem
ether84518773_ether
exanthema2152583exanthema
exanthems2142763exanthems
faithed1437163faithed
fantasm1236593fantasm
fantom112110803fant_om
farther1348343farther
father125116713father
fathom1437473fathom
gantlet83616243gantlet
gather104115853gather
hanted104124313hant_ed
hantle94318203hantle_
hantles104117513hantles
hem86148733___hem
hither124417253hither
inched124514483inched
incher114114033incher
inches114419673inches
inter55028493int_er
intime81014273intime
item65620383_it_em
ither84617603_ither
kithe125917453kithe_
kithed144613013kithed
kithes135016653kithes
kythe15509673kythe_
kythed17407313kythed
kythes16499133kythes
lathe85626713lathe_
lathed104718453lathed
lather95124353lather
lathes95127493lathes
lethe85717303lethe_
lethes94818083lethes
lithe84922013lithe_
lither94520953lither
maihem1366213maihem
manche133515103manche_
manches143818623manches
manchet143317783manchet
mantel84317973mant_el
mantes84430783mant_es
mantle84420923mantle_
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
mantram114011603mantram
mayhem1644923mayhem
mither114218563mither
mother113718643mother
naches114622413naches
narthex1734263narthex
nates55238333nat_es
natter64420743natter
neem67328083_n_eem
nether94014163nether
nother93815963nother
nth66320593_nth__
other84219103_other
panted95024823pant_ed
pantheism1645653pantheism
pantheon1346313pantheon
panthers13510783panthers
pantie84326473pantie_
panties94230933panties
pantoum1138703pantoum
pithed124615613pithed
pother113818853pother
ranched133113603ranched
rancher123013633rancher
ranches123620113ranches
ranted74324703rant_ed
ranter63826823rant_er
rathe85821923rathe_
rather94319743rather
rehem103815353_rehem
retem74221953ret_em
sachem134012223sachem
saithe94713913saithe_
satem76021463sat_em
snathe94415113snathe_
snathes104816493snathes
stem610628253_st_em
tandem9311403tan_dem
tantrum946683tantrum
teem66132603__teem
tether93716103tether
the67436053__the_
thee78039063__thee
theme105921733__theme
then78429693__then
therm106018023__therm
thew108226233__thew
they107223753__they
tithe85319703tithe_
tithed104115593tithed
tither94920283tither
tithes94720213tithes
totem74819373tot_em
tother94117143tother
tythe115210453tythe_
tythed13457503tythed
tythes12419703tythes
unhelm1136863un_helm
unshed10313773unshed
untame82513603untame
untie54425493untie_
untied73720813untied
unties64326923unties
untrim8310683untrim
wanted104319723want_ed
wanter94423053want_er
wether123315393wether
withe115220233withe_
withed134416233withed
wither124321353wither
withes124620843withes
wuther124511613wuther
xanthan1736013xanthan
xanthein1845013xanthein
xanthene1855553xanthene
xanthic1945863xanthic
xanthin1747043xanthin
xanthoma2043973xanthoma
zither183813083zither

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162935.61020092.0
3Display Results2932930.1102663.6
 (SQL Overall)1786912936.11029245.7
 
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.