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

467 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
alarmed103774(None) 
alarumed1143321alarumed
alameda1035492ala_meda
alarm76621422alarm__
alarmedly1542442alarmedly
alarms85913052alarm_s
alated75625152ala_ted
alerted82512222alerted
armed86324432__armed
awarded1236222awarded
blamed116017952bla_med
blared95018242blar_ed
charmed154714252charmed
claimed12298832claimed
clammed14369962clammed
farmed125117652_farmed
flamed124618972fla_med
flammed15377412flammed
flared105317602flar_ed
glared84715202glar_ed
harmed125218832_harmed
inarmed10268672inarmed
lamed85235292_la_med
lammed113915622_lammed
larded84319092_larded
larked114519472_larked
rearmed103912822rearmed
salaamed1134622salaamed
salaried9311032salaried
slammed123511102slammed
swarmed1367482swarmed
unalarmed1244632unalarmed
unarmed101811922unarmed
warmed124516892_warmed
aahed917816443a_a_hed
abased96514993aba_sed
abashed1357663abashed
abated95918453aba_ted
ablated102513443abla_ted
aborted10310423aborted
abraded1138643abraded
acarid95017073acar_id
acaroid103512313acaroid
acclaimed1643243acclaimed
accrued1233823accrued
acorned10238283acorned
acred87126353a_cr_ed
adapted1135843adapted
adeemed1145393adeemed
adored84714243ador_ed
adorned9256893adorned
aerated85322373aerated
aeried74221873a_eried
afeared1176833afear_ed
affirmed1743213affirmed
aflame1138723afla_me_
agamid103710693aga_mid
aglare7312433aglar_e_
agreed84712503a_greed
aimed85626053__aimed
aired66032923a_ir_ed
airmen82612353a_irmen
airted74214503a_irted
alae45643753ala__e_
alamedas1145443ala_medas
alamo7418143ala_m_o
alamode1038163ala_mode
alamos8415003ala_mos
aland65526413ala__nd
alane56135613ala_ne_
alar46340073alar___
alarming1138583alarming
alarmism1245853alarmism
alarmist1049123alarmist
alarum85411983alar_um
alarums9408923alarums
alary86123443alar__y
alate55340333ala_te_
alates64833973ala_tes
albumen1135243albumen
alcoved1375623alcoved
aldermen1145043aldermen
alerter72111513alerter
alfredo1142483alfr_edo
alibied1038143alibied
aliened81011743aliened
aligned9128553aligned
alined75221403al_ined
aliped95414283al_iped
allayed11138063allayed
alleged9389323alleged
allied74217153al_lied
allowed111610083allowed
alloyed11158033alloyed
allseed835953allseed
alluded9327093alluded
allured8299173allured
alme65832163al__me_
almeh106214553al__meh
almes75126543al__mes
almsmen1144583almsmen
almud84012183al__mud
altered83215743altered
amassed10388633amassed
amazed18519313ama_zed
amerced1256523amerced
aneared8512743anear_ed
arame75026623ara_me_
arames84622573ara_mes
aramid93315613ara_mid
arced88224163__arced
armer76924443__armer
armet76739453__armet
arrased8149863arrased
arrayed11117153arrayed
ascared10399523ascar_ed
ashamed1336243ashamed
ashlared1253933ashlar_ed
assumed1065293assumed
aurated83817793aurated
availed1135973availed
averred11237593averred
averted112211613averted
awaited1146963awaited
awaked14579203awa_ked
award97118043awar__d
awardee1137563awardee
awarder1135893awarder
aware86420023awar_e_
balanced1356513balanced
balsamed1344543balsamed
bammed133913243_bammed
barbed115121313_barbed
barded105426423_barded
bared85144483_bar_ed
barfed125416383_barfed
barged105822643_barged
barked135027313_barked
barmen105418533_barmen
barned95623583_barned
barred95725793_barred
beamed115720733bea_med
bearded114212133bearded
bermed115217723_bermed
blabbed11357813blabbed
blacked163613373blacked
bladed104717763bla_ded
blame95625493bla_me_
blamer104417143bla_mer
blames105121863bla_mes
blanked144011223blanked
blare75826233blar_e_
blares85021633blar_es
blarney12174763blarney
blasted104213473blasted
blatted104812713blatted
blawed124713893bla_wed
blazed184314713bla_zed
bleared104211253blear_ed
bloomed12439433bloomed
blumed114313643bl_umed
blurbed12337613blurbed
blurred10427803blurred
blurted10399783blurted
boarded113910503boarded
calmed114816383_calmed
carded105424903_carded
cared86050093_car_ed
caried94528693_caried
carked134024823_carked
carmen104019343_carmen
caromed123713623_caromed
carped115923763_carped
carted98631443_carted
carved124320853_carved
chared125423693char_ed
charged144614023charged
charked174814013charked
charmer144913663charmer
charred134614483charred
charted135116853charted
chasmed154710173chasmed
chirmed15379733chirmed
clacked164113603clacked
cladded12356923cladded
clagged12749233clagged
claimer11279883claimer
clammer134211793clammer
clamped144012043clamped
clanged114212653clanged
clanked143812253clanked
clapped143511173clapped
claret84026573clar_et
claries93422203claries
claroes93113733claroes
clashed133614013clashed
clasped123610443clasped
classed104113653classed
clawed125115073cla_wed
clayed125013043cla_yed
cleared103612463clear_ed
clerked14326653clerked
crammed143710123crammed
dammed124214793_dammed
dared75935013_dar_ed
darked123919633_darked
darned85018483_darned
darted84620923_darted
disarmed1238643disarmed
drammed13378073drammed
dwarfed1533483dwarfed
eared65139503_ear_ed
earned74818333_earned
elapsed1056113elapsed
elated74725823ela_ted
enlarged1035413enlarged
famed115928343_fa_med
farced125216533_farced
farded114518953_farded
fared95842343_far_ed
farmer115017373_farmer
farted105121783_farted
feared106320433fear_ed
firmed125411883_firmed
flacked173711583flacked
flagged13459633flagged
flagmen13226913flagmen
flailed1137303flailed
flaked144715653fla_ked
flame105124443fla_me_
flamen115215993fla_men
flamer114919123fla_mer
flames114723693fla_mes
flanged123810843flanged
flanked153710643flanked
flapped15328253flapped
flare84823633flar_e_
flares94521703flar_es
flashed144112183flashed
flatbed13397983flatbed
flatted114012943flatted
flawed134712723fla_wed
flayed134414053fla_yed
flirted11428673flirted
flumed124915263fl_umed
foamed126014403foa_med
formed125021173_formed
framed125116523fra_med
gamed95126393_ga_med
gammed124216163_gammed
garbed104815663_garbed
garred85217413_garred
gaumed104610323_gaumed
geared85317743gear_ed
glaceed1136203glaceed
gladded11357453gladded
glaired9387753glaired
glaived12375973glaived
glanced11439233glanced
glare65222963glar_e_
glares75518873glar_es
glarier84112213glarier
glassed93710433glassed
glazed174711773gla_zed
gleamed11327933gleamed
glimed105312283gl_imed
glommed13265443glommed
gloomed11337413gloomed
gloried9169523gloried
gnarled9287723gnarled
gnarred9327013gnarred
gormed105013833_gormed
guarded1036153guarded
hammed144116973_hammed
hared95742183_har_ed
harked145422553_harked
harmer114719553_harmer
harped124418403_harped
hazarded2243643hazarded
hearsed113811413hearsed
hearted113314023hearted
hoarded12368343hoarded
illumed10285863illumed
jammed183811503_jammed
jarred144613253_jarred
knarred12266003knarred
laced87132643_la_ced
lacked135324653_lacked
laded74232613_la_ded
ladled85013483_ladled
lagged95520133_lagged
laired75216813_laired
laked105731123_la_ked
lalled74218753_lalled
lambed115614783_lambed
lame66849293_la_me_
lamedh12476363_la_medh
lameds94812033_la_meds
lamer75233703_la_mer
lames75445543_la_mes
lamped114017543_lamped
lanced93717723_lanced
landed84619243_landed
lapped114320033_lapped
lapsed94712583_lapsed
lard56742003_lar__d
larder73720973_larder
laree56036293_lar_ee
larees65323113_larees
lares54852633_lar_es
large65325463_large_
larger74417513_larger
larges74824233_larges
larker104519243_larker
lased65132343_la_sed
lashed105625213_lashed
lasted74323603_lasted
lated65240673_la_ted
lathed104718463_lathed
lauded83812153_lauded
laved95028593_la_ved
lawed96028323_la_wed
lawmen11308593_lawmen
layed95127383_la_yed
laymen113010843_laymen
lazed154925843_la_zed
lazied164610653_lazied
learned8329303learned
limed85426803_l_imed
loamed94414613_loamed
loomed94616763_loomed
lorded84916733_lorded
lured65427493_lur_ed
lurked114511973_lurked
maimed114812663_maimed
malarkey1743413malarkey
malformed1742383malformed
marked133921623_marked
marled95523163_marled
marred95421043_marred
marted94425213_marted
melamed1249633mela_med
named85223063_na_med
napalmed1342503napalmed
narked114116743_narked
neared75119813near_ed
normed95014543_normed
oared65030653_oar_ed
palaced124110783pala_ced
palmed114314643_palmed
pared86946763_par_ed
parged104922043_parged
parked134425143_parked
parled94626293_parled
parred95024073_parred
parsed96323893_parsed
parted94228683_parted
pearled10411553pearled
permed115217353_permed
placed114318003pla_ced
plagued11307473plagued
plaided11409643plaided
plained103812233plained
plaited103713893plaited
planed94420913pla_ned
planked143512283planked
planned103810153planned
planted103516123planted
plashed133712643plashed
plasmid12239553plasmid
plated95225773pla_ted
platted103614263platted
played124815033pla_yed
plumed114412883pl_umed
prearmed1397993prearmed
psalmed1234503psalmed
rammed113117303_rammed
rared65738323_rar_ed
reamed94326123rea_med
reared75930013rear_ed
rewarmed14257433rewarmed
roamed95215093roa_med
roared75015393roar_ed
safaried1236253safaried
salaries8319593salaries
salarymen1472693salarymen
scammed14479543scammed
scared95227293scar_ed
scarfed134711183scarfed
scarped124314403scarped
scarred104512633scarred
scarted104816123scarted
seamed94823883sea_med
seared75232843sear_ed
shamed125120213sha_med
shammed153911423shammed
shared105829063shar_ed
sharked153613913sharked
sharped134112053sharped
slabbed12409503slabbed
slacked143815453slacked
slagged104312773slagged
slaked114318273sla_ked
slalomed1134283slalomed
slammer113913033slammer
slanged94112853slanged
slanted83514743slanted
slapped123511853slapped
slashed114114853slashed
slated75028313sla_ted
slatted84015183slatted
slaved104017043sla_ved
slayed104716223sla_yed
slimed94915123sl_imed
slimmed12368473slimmed
slummed12359273slummed
slurped10368753slurped
slurred8359193slurred
smarted105012613smarted
snared74824553snar_ed
snarfed11378753snarfed
snarled83612363snarled
soared74324293soar_ed
spammed14348523spammed
spared95427493spar_ed
sparged113512763sparged
sparked143513143sparked
sparred104512863sparred
spasmed12296993spasmed
stared75429873star_ed
starred85013453starred
started84217323started
starved114911573starved
stormed1039043stormed
swarded1238153swarded
swarmer1247803swarmer
tabarded1234743tabarded
tamed85528513_ta_med
tared69340053_tar_ed
tarred74720283_tarred
tarted74923373_tarted
teamed95418593tea_med
teared75722153tear_ed
termed94816703_termed
tiaraed837053tiaraed
trammed123810713trammed
unaimed102812493unaimed
unharmed1438093unharmed
unwarmed1437303unwarmed
valanced1475463valanced
varied104817863_varied
varved134110603_varved
warded115021043_warded
wared96339873_war_ed
warked144421213_warked
warmer113816733_warmer
warned104018913_warned
warped124816413_warped
warred104019843_warred
warted104223233_warted
wearied112911813wearied
whammed18345133whammed
wharfed1734413wharfed
wormed124314303_wormed
yarded114714023_yarded
yarned105514023_yarned
yearned11327373yearned

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 Filter1786911340270.420425454.8
2DLD Change Limit1340274676.20321606.8
3Display Results4674670.1562993.6
 (SQL Overall)1786914676.77926359.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.