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

327 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
psalmed123450(None) 
palmed114314641p_almed
calmed114816382_calmed
paled85538722p_al_ed
palled94625162p_alled
palmer105816542p_almer
palped114513642p_alped
pealed95322802peal_ed
psalm949272psalm__
psalmic1345332psalmic
psalmody1642092psalmody
psalms1045672psalm_s
psalter9247812psalter
salted74121202_salted
salved103916422_salved
spalled103113132spalled
spammed14348522spammed
spasmed12296992spasmed
aimed85626053__aimed
alarmed1037733alarmed
alme65832163__alme_
almeh106214553__almeh
almes75126543__almes
almud84012183__almud
appalled1344813appalled
armed86324433__armed
ashamed1336243ashamed
assumed1065293assumed
balded105417513_balded
baled85436443_bal_ed
balked135219413_balked
balled94926893_balled
bammed133913243_bammed
beamed115720733bea_med
becalmed1534813becalmed
blamed116017953bla_med
calked134617403_calked
called94126733_called
calmer105216933_calmer
calved125215453_calved
chalked17449863chalked
charmed154714253charmed
chasmed154710173chasmed
claimed12298833claimed
clammed14369963clammed
coaled95022713coal_ed
crammed143710123crammed
culmed114610593_culmed
dammed124214793_dammed
desalted1038313desalted
dialed84716453dial_ed
dialled9510133dialled
disarmed1238643disarmed
drammed13378073drammed
embalmed1544263embalmed
exalted1537393exalted
famed115928343_fa_med
farmed125117653_farmed
filmed124610363_filmed
flamed124618973fla_med
flammed15377413flammed
foaled104515963foal_ed
foamed126014403foa_med
framed125116523fra_med
galled84622863_galled
gamed95126393_ga_med
gammed124216163_gammed
gaumed104610323_gaumed
goaled85014363goal_ed
haled95335823_hal_ed
haloed104717603_haloed
halted105019603_halted
halved134813903_halved
hammed144116973_hammed
harmed125218833_harmed
healed105121443heal_ed
helmed124513693_helmed
imbalmed1543293imbalmed
inarmed10268673inarmed
isled64615993is_l_ed
jammed183811503_jammed
lalled74218753_lalled
lamed85235293_la_med
lammed113915623_lammed
loamed94414613loa_med
maimed114812663_maimed
malfed12369763_malfed
malled94626113_malled
malted94819863_malted
melamed1249633melamed
misaimed1338093misaimed
naled65525053_nal_ed
named85223063_na_med
napalmed1342503napalmed
paced106931683p_a_ced
packed154822603p_acked
padded114113503p_added
paged95926783p_a_ged
paiked135113433p_aiked
pained95622853p_ained
paired95017523p_aired
palaced124110773p_alaced
pale66055013p_al_e_
palea75028663p_al_ea
paler75436933p_al_er
pales75753803p_al_es
palet74650803p_al_et
palier85023563p_alier
pallet84232653p_allet
pallid93915283p_allid
palm85331363p_alm__
palmar104113463p_almar
palmated132511003p_almated
palmers113513623p_almers
palmier113312173p_almier
palms94921753p_alm_s
palmy126016733p_alm_y
palsied102911303p_alsied
palter84423263p_alter
paned85437183p_a_ned
panged104722333p_anged
panned94123433p_anned
panted95024823p_anted
pared86946763p_a_red
parged104922043p_arged
parked134425143p_arked
parled94626283p_arled
parred95024073p_arred
parsed96323893p_arsed
parted94228683p_arted
pashed125923143p_ashed
passed94320943p_assed
pasted94426903p_asted
pated85237843p_a_ted
patted94724683p_atted
paused95114963p_aused
paved115525263p_a_ved
paveed12438893p_aveed
pawed115725613p_a_wed
pawned124513283p_awned
payed115925933p_a_yed
peaced115818913pea_ced
peached154315883peached
peaked136117403pea_ked
pearled10411543pearled
pedaled113711883pedal_ed
pedalled1246923pedalled
peeled94119703peel_ed
pelmet103419243p_elmet
pelted94617753p_elted
peplumed1543033peplumed
permed115217343p_ermed
pestled102711433pestl_ed
petaled103614143petal_ed
petalled1138693petalled
phased124011973pha_sed
phasmid15267603phasmid
piaffed1693753piaffed
piled85232993p_il_ed
pilled94222753p_illed
placed114318003pla_ced
plagued11307473plagued
plaided11409643plaided
plained103812233plained
plaited103713893plaited
planed94420913pla_ned
planked143512283planked
planned103810153planned
planted103516123planted
plashed133712643plashed
plasmid12239553plasmid
plated95225773pla_ted
platted103614263platted
played124815033pla_yed
pled75231433p__l_ed
plied85118593p__lied
plumed114412883p_lumed
poached154212403poached
poled84934843p_ol_ed
polled94022003p_olled
pooled94619813pool_ed
praised104214813praised
pranced123714043pranced
pranged114512553pranged
pranked143712093pranked
prated94924923pra_ted
prawned1346743prawned
prayed124815433pra_yed
prearmed1397993prearmed
premed114617753p_remed
prilled104712993prilled
primed115118913p_rimed
primmed14388853primmed
psalming1375473psalming
psalmist1276353psalmist
psalmodic1652433psalmodic
psalters10227713psalters
psaltery13224733psaltery
psaltry12213803psaltry
psammon1342543psammon
pshawed16103033pshawed
psyched1843913psyched
psyllid1344523psyllid
puled84926523p_ul_ed
pulled94322193p_ulled
pulped114612533p_ulped
pulsed94013723p_ulsed
purled94520743purl_ed
rammed113117303_rammed
reamed94326123rea_med
rearmed103912823rearmed
roamed95215093roa_med
sabbed114518083_sabbed
sabed86526813_sa_bed
sabred95916533_sabred
sacked135525213_sacked
sacred94917103_sacred
sagged94120013_sagged
sailed74327763_sailed
sained75424243_sained
salaamed1134623_salaamed
salad65321833_sal_ad
sale44959703_sal_e_
salep77022953_sal_ep
sales56055593_sal_es
sallet63734543_sallet
sallied83316953_sallied
salmi7815863_salm_i
salmis8514273_salmis
salmon84614183_salmon
salpid9510883_salpid
salter64325083_salter
saluted84511713_saluted
salve85022133_salve_
salver94617753_salver
salves94221763_salves
salvoed11307063_salvoed
same65245643_sa_me_
samek114915273_sa_mek
samlet84126563_samlet
sanded84920613_sanded
saned65636273_sa_ned
sapped114422013_sapped
sashed105622943_sashed
sassed76116173_sassed
sated66238533_sa_ted
sauced93913303_sauced
sauted74119603_sauted
saved95127113_sa_ved
sawed95628403_sa_wed
sayed96127143_sa_yed
scalded11409763scalded
scaled94822443scal_ed
scalped124411993scalped
scammed14479543scammed
sealed74328363seal_ed
seamed94823883_seamed
seemed95117613_seemed
selfed10310913_selfed
shaled105023953shal_ed
shamed125120213_shamed
shammed153911423shammed
silked114314813_silked
siloed74615303_siloed
silted74020013_silted
slaked114318273_slaked
slalomed1134283slalomed
slammed123511103slammed
slated75028313_slated
slaved104017043_slaved
slayed104716223_slayed
sled55334373_s_l_ed
slimed94915123_slimed
slued64220513_s_lued
soled65835173_sol_ed
soloed74515743_soloed
solved105312933_solved
spaced114517253spa_ced
spaded103816753spa_ded
spaed85522273spa__ed
spale74929213spal_e_
spales84728103spal_es
spaller92713473spaller
spammer133410433spammer
spanked143111733spanked
spanned104111223spanned
spared95427493spa_red
sparged113512763sparged
sparked143513143sparked
sparred104512863sparred
spathed134013183spathed
spatted104014143spatted
spawned13316803spawned
spayed124213613spa_yed
spelled103714733spelled
spiled94621993spil_ed
spilled103613623spilled
splayed13357813splayed
spumed114711543_spumed
staled74728103stal_ed
stalked123811173stalked
stalled83515683stalled
sulked114314703_sulked
summed114014043_summed
swarmed1367483swarmed
talced93811003_talced
talked114015403_talked
tamed85528513_ta_med
teamed95418593tea_med
trammed123810713trammed
unaimed102812493unaimed
unarmed101811923unarmed
unsalted9510923unsalted
upscaled13144873upscal_ed
uptalked1533053uptalked
valued104011153_valued
valved136711043_valved
vealed103916323veal_ed
vialed105112593vial_ed
vialled1156843vialled
waled94330993_wal_ed
walked145313783_walked
walled104021293_walled
warmed124516893_warmed
whaled134612033whal_ed
whammed18345133whammed
whelmed16375153whelmed

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273276.89019452.4
3Display Results3273270.1102972.7
 (SQL Overall)1786913277.14025026.8
 
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.