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

305 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
althea93819(None) 
althaea1044351althaea
altheas1038221altheas
aether94213672aether
allheal1044552allheal
aloha8513612aloh_a
alpha1049652alph_a
alter54828502alt_er
althaeas1144212althaeas
altho86312602alth_o
anthem113410342anthem
anther93715062anther
asthma11126562asthma
lathe85626712lathe_
lathed104718452lathed
lather95124352lather
lathes95127492lathes
maltha1137502malth_a
aahed917816443a_ahed
ache96829823a_che_
ached119227833a_ched
aches106132293a_ches
acta69524803act__a
acted88521733act_ed
aethers103614943aethers
after85719793aft_er
aftosa996573aftosa
agha87417303a_gh_a
aha611246643a__h_a
ahead96817053a__head
ahed89536253a__hed
ahem97225363a__hem
airhead1136993airhead
airthed11328303airthed
aitches123014363aitches
ala312463603al___a
alae45643753al_ae_
alameda1035493alameda
alane56135613alane_
alaska1036713alaska
alate55340323alate_
alated75625143alated
alates64833963alates
alba68328333al__ba
albata839333albata
alchemy1743113alchemy
alder65421913al_der
ale36572343al__e_
alec66430063al__ec
alee46652323al__ee
alef76340693al__ef
ales47067103al__es
alexia132910463alexia
alfa77624273al__fa
alga57927603al__ga
algae65319623algae_
alien56425583al_ien
alike95523963alike_
aline57243153aline_
alined75221403alined
aliner65621983aliner
alines65735223alines
aliped95414283aliped
alive85722513alive_
aliya83713483al_iya
alkie95520033alkie_
alkies104518093alkies
allee54932123al_lee
allees64521483allees
alley85721673al_ley
allheals1143913allheals
allied74217153allied
allies63827673allies
alma66333023al__ma
alme65832163al_me_
almeh106214553al_meh
almehs11619493almehs
almes75126543al_mes
almner85710723almner
alodia71112453alodia
aloe45540193al_oe_
aloes54933673al_oes
alohas9411703alohas
alone55732963alone_
alpaca1047383alpaca
alphas1139513alphas
alphyl1484083alphyl
alt36467963alt___
altar55520643alt_ar
altars64518153altars
altered83215733altered
alterer72713993alterer
alters64924223alters
althorn1047763althorn
alto47831263alt__o
altos55822953alt_os
alts46639903alt__s
aludel747853aludel
alula5317093al_ula
alulae6312743alulae
alumna857343alumna
anathema1344583anathema
another10289153another
anta46839583ant__a
antae56828293antae_
antbear935063antbear
ante46538903ant_e_
anted66328243ant_ed
anteed75616113anteed
antes56334323ant_es
anthelia1149113anthelia
anthemia1349193anthemia
anthems12309423anthems
antheral1149393antheral
anthers103715203anthers
anthrax1757153anthrax
antler64615553antler
antra56521923ant_ra
antre55224523antre_
antres65021003antres
aphtha1444483aphtha
aphthae1544703aphthae
apnea73413413a_pnea
apnoea867093apnoea
apothem1444633apothem
apter76120203apt_er
archaea12137613archaea
archean1269123archean
arched125717323arched
archer115016243archer
arches114822043arches
area45843393a__rea
artel56122743art_el
artier63419733artier
asea46327183a__sea
ashed97829773a_shed
ashen87818673a_shen
ashes86230613a_shes
aster55434893ast_er
asthenia1167713asthenia
astheny1345293astheny
asthmas12117363asthmas
ate37059243a_t_e_
ates45047923a_t_es
atma68121773a_t_ma
atria56022333a_tria
author939763author
autoed7712823autoed
azalea1537003azalea
baldhead1544273baldhead
barathea1345273barathea
bathe105822883bathe_
bathed125518743bathed
bather115322513bather
bathes116524833bathes
bethel1169643bethel
blather125314203blather
blether12459913blether
blithe115810863blithe_
blither124812173blither
bohea105013733_bohea
bolthead1445903bolthead
bother115218063bother
cathead1338753cathead
cither114616683cither
clothe114712993clothe_
clothed134010283clothed
clothes124513813clothes
dither104417683dither
earthed1139923earthed
earthen1039253earthen
earthpea1343423earthpea
either94517423either
elodea738673elodea
ether84518773_ether
faithed1437163faithed
falter94519053falt_er
farther1348343farther
fathead1437863fathead
father125116713father
flathead1535803flathead
flea75628493fl__ea
galatea839943galatea
galea64722933gal__ea
gastrea847223gastrea
gather104115853gather
gilthead1343323gilthead
halted105019603halt_ed
halter94420883halt_er
hither124417253hither
hothead14349293hothead
ilea45931463il__ea
ither84617603_ither
kithe125917453kithe_
kithed144613013kithed
kithes135016653kithes
kythe15509673kythe_
kythed17407313kythed
kythes16499133kythes
laches116528343laches
lashed105625213lashed
lasher94824533lasher
lashes94831003lashes
latched133914063latched
latches123320123latches
latchet123117903latchet
late47560483lat_e_
lated65240673lat_ed
lateen64014863lateen
laten54328343lat_en
later54843923lat_er
latex124717113lat_ex
lath76640383lath__
lathers104321883lathers
lathery133911123lathery
lathi85417203lath_i
lathier10310833lathier
lathis95516173lathis
laths86022403lath_s
lathy115215063lath_y
latina65621143latina
latke94817093latke_
latkes104715873latkes
latria62313583latria
latte55426303latte_
latten65018203latten
latter65027893latter
lattes65324203lattes
lea37660183_l__ea
lehua837953_lehua
lethe85717303lethe_
lethean1037093lethean
lethes94818083lethes
lithe84922013lithe_
lither94520953lither
lithia939333lithia
lutea54819073_lutea
lycea10418943_lycea
malted94819853malt_ed
malthas1237913malthas
maltier93015483maltier
maltreat1048643maltreat
masthead1435883masthead
mither114218563mither
mother113718643mother
narthex1734263narthex
nether94014163nether
nother93815963nother
olea46532723ol__ea
ootheca1244003ootheca
other84219103_other
outhear10910603outhear
palea75028663pal__ea
palter84423263palt_er
panther12611443panther
pithead13419593pithead
pithed124615613pithed
plea66830603pl__ea
pothead133810393pothead
pother113818853pother
ralphed1334363ralphed
rathe85821923rathe_
rather94319733rather
rhea75017433__rhea
saithe94713913saithe_
salted74121203salt_ed
salter64325083salt_er
saltie63422423saltie_
saltier74318633saltier
salties73725773salties
shea76031573__shea
slather103816063slather
slither104112983slither
tea37353323__t_ea
tether93716103tether
thae76825563__thae
the67436053__the_
theca103311453__theca
thee78039063__thee
them97427043__them
then78429693__then
theta83414573__theta
thew108226233__thew
they107223753__they
tithe85319703tithe_
tithed104115593tithed
tither94920283tither
tithes94720213tithes
toea46732333__toea
tother94117143tother
tythe115210453tythe_
tythed13457503tythed
tythes12419703tythes
ultima836313ultima
ultra539363ult_ra
waltzed2033493waltzed
waltzer1934383waltzer
waltzes1935953waltzes
wether123315393wether
withe115220233withe_
withed134416233withed
wither124321353wither
withes124620843withes
wuther124511613wuther
zither183813083zither

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 Filter1786911127160.263679433.5
2DLD Change Limit1127163057.33015377.4
3Display Results3053050.1402178.6
 (SQL Overall)1786913057.73323107.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.