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

357 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
almond9141043(None) 
almonds10127951almonds
almondy13144481almondy
aland65526412al_and
algoid83011472algoid
alimony1236012alimony
allod64418382allo_d
almoner949382almoner
almonry12104732almonry
almost81014432almost
almud84012182alm_ud
alone55732962al_one
along65419492al_ong
aloud65018072al_oud
amend85717752a_mend
ammono1047372ammono
among85813302a_mong
blond85618372bl_ond
salmon84614182salmon_
salmonid1147632salmonid
salmons93713262salmons
aboon74918703aboon_
abound9239863abound
abroad9310943abroad
abscond1244503abscond
accord1178843accord
acold86214933a_cold
addend9458453addend
adman84517903adman_
admen84516183admen_
aeon45634613a_eon_
aeons57624653a_eons
afford1346493afford
agon56531883a_gon_
agone65924553a_gone
agons66423783a_gons
agony96415653a_gony
aground9216183aground
ahold94714253a_hold
ailment9314233ailment
aimed85626053aim_ed
aiming94320843aiming
alamo7418143alamo__
alamode1038153alamode
alamos8415003alamo_s
alan46844083al_an_
alands75418373al_ands
alane56135613al_ane
alang66023513al_ang
alans55636173al_ans
alant55742293al_ant
alated75625143alated
albino839933albino
alcid85817973al_cid
alcove1178083alcove
alcoved1375613alcoved
aldol61212333aldo_l
aldols7109713aldols
aldose7311093aldose
algid75415583al_gid
algin65718763algin_
algins74816433algins
algor6513053algo_r
algors7312553algors
alidad838883alidad
alien56425583alien_
aliened81011743aliened
aliens65619213aliens
align65016503align_
aligned9128553aligned
aligns75312953aligns
aliment9316703aliment
alimonied1284843alimonied
aline57243153al_ine
alined75221403alined
aliped95414283aliped
aliunde835003aliunde
alkane104313323alkane
alkene104114003alkene
alkine104916803alkine
alkoxy2033343alkoxy
alkyd13537093al_kyd
alkyne13436863alkyne
allied74217153allied
allods73615083allods
allonge837023allonge
allonym1244733allonym
allot54933873allo_t
allots64019173allots
allow85420663allo_w
allowed111610083allowed
allows94517683allows
alloy85519973allo_y
alloyed11158033alloyed
alloys94014563alloys
alma66333023alm__a
almah106917253alm_ah
almahs118611613almahs
almanac1156033almanac
almas76629773alm_as
alme65832163alm__e
almeh106214553alm_eh
almehs11619493almehs
almes75126543alm_es
almner85710723almner
almoners1068133almoners
alms65834923alm__s
almuce10348213almuce
almude9399933almude
almuds9378773almuds
almug8429303alm_ug
almugs9396423almugs
aloe45540193al_o_e
aloes54933673al_oes
aloft8423433al_oft
aloha8513613al_oha
aloin55227423al_oin
aloins65022203aloins
aloof83521573al_oof
alow75328593al_o_w
alpine84417373alpine
also46423443also__
alto47831263alto__
altos55822953alto_s
alumin8513543alumin_
alumina9510053alumina
alumine9412693alumine
alumins9512983alumins
alumna857343alumna
alumni856753alumni
alvine94614583alvine
amen66733153a_men_
amends94713283a_mends
amens75624843a_mens
ament76036543a_ment
amid77036353a_m_id
amin66042253a_min_
amine75835383a_mine
amino75425503a_mino
amins75534323a_mins
ammine10314493ammine
ammino1069883ammino
ammo85520133ammo__
ammonal1137023ammonal
ammonia1148693ammonia
ammonic1349163ammonic
ammonoid13104803ammonoid
ammos94815823ammo_s
amok10217403a_mo_k
amoks11413553a_moks
amole75724593a_mole
amort75832203a_mort
amount8414483a_mount
amour75014853a_mour
amped104820513a_mped
ancon75718233ancon_
ancone83916953ancone
and47244173a___nd
anemone9119453anemone
anion55028813anion_
anions64123033anions
annona648873annona
anon46134853a_non_
anyon85615223anyon_
anyone94612733anyone
anyons94513503anyons
apod78123183a_po_d
append1138273append
apron7318833apron_
aproned10311503aproned
aprons8316993aprons
argon65520593argon_
argons75018203argons
armband1265983armband
armed86324433arm_ed
arming94719803arming
armload1044293armload
armor75118053armo_r
armored102610473armored
armors85017813armors
armory114211473armory
armour84411853armour
aroid65428343a_roid
around72712413around
arson55118833arson_
arsons63917213arsons
ascend9429733ascend
astony9510523astony
astound845503astound
atman75520143atman_
atmans84413963atmans
atone56527983a_tone
atoned75417543a_toned
atony87218853a_tony
attend7258973attend
augend837633augend
autoed7712823autoed
avion84218343avion_
avions94114393avions
avoid95516683a_void
awmous1157713awmous
axion1211316913axion_
axions134713483axions
axman144813183axman_
axmen145112273axmen_
axon115524303a_xon_
axone125918473a_xone
axons125517933a_xons
azlon144312873azlon_
azlons154110423azlons
azon135725053a_zon_
azons146518253a_zons
balcony1435853balcony
ballon84117493ballon_
ballons93916963ballons
bausond1044493bausond
beyond1237073beyond
bland85320453bl_and
blend85317453bl_end
blind86319323bl_ind
blonde94813293bl_onde
blonds95213343bl_onds
blood85319523bl_ood
bond75334363__bond
calmed114816383calm_ed
calming123915973calming
calzone1848623calzone
clod76124613cl_o_d
clon66232483cl_on_
clone75728163cl_one
cloned94518803cl_oned
clonk114417443cl_onk
clons75228133cl_ons
cloud86716423cl_oud
cymoid1459473cymoid
daemon9279593daemon_
daemons10269233daemons
daimon9259713daimon_
daimons10249323daimons
dalton7311273dalton_
daltons8310403daltons
demand104314253demand
demoed103713443demoed
demon86520313demon_
demons94917723demons
diamond1186113diamond
dromond1135473dromond
eland65820393el_and
emend86214893_emend
falcon11310293falcon_
falcons1239123falcons
flong95815683fl_ong
flood95215603fl_ood
fond86330953__fond
frond95316343_frond
gallon73715813gallon_
gallons83015953gallons
gammon1138903gammon_
gammoned1444993gammoned
gammons1237973gammons
gland75217713gl_and
gluon6311223gluon_
gluons738503gluons
haemoid1337203haemoid
halloed113314913halloed
haloed104717603hal_oed
haloid104317763hal_oid
halon86124863hal_on_
halons95720713hal_ons
harmony1538173harmony
hemoid12313513hemoid
jomon14610083jomon_
kalong1177703kal_ong
kimono12105413kimono
klong105310403kl_ong
lagend838743lagend
lalland83810183lalland
lambed115614783lambed
lamed85235293lam_ed
lament85024943lament
lamina84920443lamina
laming94528363laming
lammed113915623lammed
lampad114510033lampad
lamped114017543lamped
land56337313_l_and
lemon75618183lemon_
lemons84415053lemons
lemony11419553lemony
lend56233673_l_end
leone55018823_leone
lion46334443_lion_
lions55923213_lions
load56730603_l_oad
loid55531493_l_oid
lone45849133_l_one
long56933343_l_ong
looed64626133_looed
loon47344793_loon_
loons55731723_loons
loony86918963_loony
lord55032083_l_ord
loud55228043_l_oud
mammon939643mammon_
mammons1048513mammons
mend75334033__mend
mind75434383__mind
mod69054403__mo_d
mold76034333__mold
mon57561583__mon_
monad85519473__monad
monde85723143__monde
mondo85721233__mondo
monk105928523__monk
mono66036723__mono
mons68152263__mons
mony96830013__mony
mood76332063__mood
mound83918313__mound
osmund933803osmund
palimony1544303palimony
palmed114314643palm_ed
palming123914013palming
plafond1344183plafond
pleon74216383pleon_
pleons84213343pleons
plod76723273pl_o_d
plonk114613983pl_onk
pond75530493__pond
ramona8412413ramona
remand95618963remand
remend95216553remend
remind94819793remind
remold93412973remold
salmonids1245543salmonids
salmonoid1243883salmonoid
salon55228553sal_on_
salons63823693sal_ons
saloon64418023saloon_
saloons74415323saloons
salvoed11307063salvoed
second9411153second
simony1137903simony
sloid64619713sl_oid
slojd13378843sl_ojd
sloyd9409683sl_oyd
somoni8310743somoni
talion6317713talion_
talions7314113talions
talon55824113tal_on_
taloned8310223tal_oned
talons64019443tal_ons
towmond1394203towmond
unfond10149113unfond
unmold9148313unmold
valgoid1255213valgoid
yond86122313__yond

Search took 6 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.1401276364.3
2DLD Change Limit1127163575.72019705.6
3Display Results3573570.1262833.3
 (SQL Overall)1786913575.98629851.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.