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

509 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
spasmed1229699(None) 
spammed14348521spammed
chasmed154710172chasmed
palmed114314642_palmed
pashed125923142_pashed
passed94320942_passed
pasted94426902_pasted
psalmed1234502psalmed
sashed105622942s_ashed
sassed76116172s_assed
scammed14479542scammed
seamed94823882sea_med
shamed125120212sha_med
shammed153911422shammed
slammed123511102slammed
slashed114114852slashed
smashed133711222smashed
spaced114517252spa_ced
spaded103816752spa_ded
spaed85522272spa__ed
spalled103113122spalled
spammer133410432spammer
spanked143111722spanked
spanned104111222spanned
spared95427482spa_red
sparged113512752sparged
sparked143513132sparked
sparred104512852sparred
spasm94514172spasm__
spasms10418972spasm_s
spathed134013182spathed
spatted104014142spatted
spawned13316802spawned
spayed124213612spa_yed
splashed1435592splashed
spumed114711542sp_umed
stashed113812482stashed
swarmed1367482swarmed
swashed144311362swashed
abased96514993abas_ed
abashed1357663abashed
aimed85626053__aimed
alarmed1037733alarmed
amassed10388623amassed
armed86324433__armed
ashamed1336243asha_med
ashed97829773__ashed
asked106919313__asked
bammed133913243_bammed
based85331583_bas_ed
bashed126225703_bashed
basked135218603_basked
basted95227233_basted
beamed115720733bea_med
biased94012223bias_ed
biassed10418703biassed
blamed116017953bla_med
blasted104213473blasted
boasted104113743boasted
brassed103612373brassed
bypassed1642713bypassed
calmed114816383_calmed
cased86032413_cas_ed
cashed125124353_cashed
casked134815513_casked
ceased94920783ceas_ed
charmed154714243charmed
chased125019293chas_ed
chassed134712133chassed
claimed12298833claimed
clammed14369963clammed
clashed133614013clashed
clasped123610443clasped
classed104113653classed
coasted104015943coasted
crammed143710123crammed
crashed134214203crashed
dammed124214793_dammed
dashed115920563_dashed
deashed123411303deashed
drammed13378073drammed
eased65430403_eas_ed
erased74816753eras_ed
famed115928343_fa_med
farmed125117653_farmed
fashed136720253_fashed
fasted105320953_fasted
feased105718713feas_ed
feasted11310843feasted
flamed124618973fla_med
flammed15377413flammed
flashed144112183flashed
foamed126014403foa_med
framed125116523fra_med
gamed95126393_ga_med
gammed124216163_gammed
gashed116321973_gashed
gasmen93111563_gasmen
gasped104814293_gasped
gassed85217633_gassed
gasted84821583_gasted
gaumed104610323_gaumed
glassed93710433glassed
gnashed12317523gnashed
grasped11409063grasped
grassed93812793grassed
hammed144116973_hammed
harmed125218833_harmed
hashed136021943_hashed
hasped125014443_hasped
hasted105125283_hasted
impasted13297553impasted
inarmed10268673inarmed
jammed183811503_jammed
lamed85235293_la_med
lammed113915623_lammed
lapsed94712583laps_ed
lased65132343_las_ed
lashed105625213_lashed
lasted74323603_lasted
leased74722883leas_ed
leashed113211163leashed
loamed94414613loa_med
maimed114812663_maimed
mashed125325043_mashed
masked134316523_masked
massed94421323_massed
masted94025803_masted
measled10339303measled
named85223063_na_med
napalmed1342503napalmed
opaqued1942193opaqued
orgasmed1242933orgasmed
paced106931683_pa_ced
packed154822603_packed
padded114113503_padded
paged95926783_pa_ged
paiked135113433_paiked
pained95622853_pained
paired95017523_paired
paled85538723_pa_led
palled94625163_palled
palmer105816543_palmer
palped114513643_palped
palsied102911303_palsied
paned85437183_pa_ned
panged104722333_panged
panned94123433_panned
panted95024823_panted
pared86946763_pa_red
parged104922033_parged
parked134425133_parked
parled94626273_parled
parred95024073_parred
parsed96323893_parsed
parted94228683_parted
pase65346863_pas_e_
paseo77022513_pas_eo
pases75346503_pas_es
pashes115828393_pashes
passe75525693_passe_
passee84522023_passee
passel85117003_passel
passer84721033_passer
passes86030473_passes
paste74932953_paste_
pastel85918713_pastel
paster85734373_paster
pastes85233913_pastes
pated85237843_pa_ted
patted94724683_patted
paused95114963_paused
paved115525263_pa_ved
paveed12438893_paveed
pawed115725613_pa_wed
pawned124513283_pawned
payed115925933_pa_yed
permed115217343_permed
phased124011973phas_ed
phasmid15267603phasmid
pished124817063_pished
pissed94816933_pissed
plashed133712643plashed
plasmid12239553plasmid
plumed114412883_plumed
posed85828413_pos_ed
posted93722493_posted
premed114617753_premed
primed115118913_primed
pushed125017463_pushed
quashed20207973quashed
rammed113117303_rammed
rased65033933_ras_ed
rasped94715203_rasped
reamed94326123rea_med
rearmed103912823rearmed
repassed11229273repassed
repasted112611533repasted
roamed95215093roa_med
roasted83912663roasted
sabbed114518083s_abbed
sabed86526813s_a_bed
sabred95916533s_abred
sacked135525213s_acked
sacred94917103s_acred
sagged94120003s_agged
sailed74327763s_ailed
sained75424243s_ained
salaamed1134623salaamed
salted74121203s_alted
salved103916423s_alved
same65245643s_a_me_
samek114915273s_a_mek
sanded84920613s_anded
saned65636273s_a_ned
sapped114422013s_apped
sashes94728483s_ashes
sasses64124393s_asses
sated66238533s_a_ted
sauced93913303s_auced
sauted74119603s_auted
saved95127113s_a_ved
sawed95628403s_a_wed
sayed96127143s_a_yed
scabbed14408223scabbed
scalded11409763scalded
scaled94822443sca_led
scalped124411993scalped
scammer133611973scammer
scamped144711963scamped
scanned104110893scanned
scanted104114393scanted
scaped115519553sca_ped
scared95227293sca_red
scarfed134711183scarfed
scarped124314393scarped
scarred104512633scarred
scarted104816123scarted
scathed134012643scathed
scatted103512773scatted
schemed1577753schemed
scrammed1555003scrammed
scummed14347913scummed
seabed95017693sea_bed
sealed74328363sea_led
seamen84518563sea_men
seamer84223613sea_mer
seared75232843sea_red
seaside839693seaside
seasoned948113seasoned
seated75131053sea_ted
seaweed11108813seaweed
seemed95117613s_eemed
seised74218123seis_ed
sensed73918163sens_ed
sepaled10510593sepa_led
sepalled1156903sepalled
sesame8311013sesame_
sesames9310743sesames
shacked174015393shacked
shaded114518873sha_ded
shafted14288803shafted
shagged134210123shagged
shaled105023953sha_led
shame105726703sha_me_
shames114726223sha_mes
shammer144613143shammer
shammes144312833shammes
shammied16265543shammied
shanked153212123shanked
shaped125020103sha_ped
shared105829063sha_red
sharked153613903sharked
sharped134112043sharped
shauled1148793shauled
shaved135118383sha_ved
shawed134817233sha_wed
shawled1437773shawled
shimmed15338583shimmed
shushed14348493shushed
skanked11338103skanked
skated114414873ska_ted
skimmed16306053skimmed
slabbed12409503slabbed
slacked143815453slacked
slagged104312763slagged
slaked114318273sla_ked
slalomed1134283slalomed
slammer113913033slammer
slanged94112853slanged
slanted83514743slanted
slapped123511843slapped
slasher104515323slasher
slashes103619103slashes
slated75028313sla_ted
slatted84015183slatted
slaved104017043sla_ved
slayed104716223sla_yed
slimed94915123s_limed
slimmed12368473slimmed
sloshed11329823sloshed
slummed12359273slummed
slushed113611243slushed
smacked163710993smacked
smarted105012613smarted
smasher123911013smasher
smashes123914613smashes
smushed13368233smushed
snacked144013113snacked
snafued1134933snafued
snagged104010663snagged
snailed83811923snailed
snaked115017593sna_ked
snapped124611203snapped
snared74824553sna_red
snarfed11378753snarfed
snarled83612353snarled
snashes105214753snashes
snawed104813733sna_wed
soaked114717593soa_ked
soaped95817973soa_ped
soared74324293soa_red
soused74822983sous_ed
space95325673spa_ce_
spacemen1445413spacemen
spacer104917793spa_cer
spaces104722633spa_ces
spacey136212533spa_cey
spacier114011633spacier
spackled17297793spackled
spade84423323spa_de_
spader94317133spa_der
spades94222583spa_des
spae65034323spa__e_
spaes76029973spa__es
spahee11313443spa_hee
spahees1238263spahees
spake114322743spa_ke_
spale74929213spa_le_
spales84728103spa_les
spaller92713473spaller
spam85930043spa_m__
spammers14378693spammers
spams94922193spa_m_s
spancel1147363spancel
spandex1735833spandex
spangled1236143spangled
spaniel948923spaniel
spanker133612353spanker
spanner94312563spanner
spare75135563spa_re_
sparer84524963spa_rer
spares84834553spa_res
sparge94216043sparge_
sparger103613073sparger
sparges104016333sparges
sparid94016933spa_rid
sparker133914353sparker
sparkled15317723sparkled
sparoid102311533sparoid
sparse84516343sparse_
sparser94311483sparser
spas67036723spas___
spasming13227203spasming
spasmodic1652003spasmodic
spastic11310373spastic
spate74731583spa_te_
spates85028173spa_tes
spathe115115693spathe_
spathes125116533spathes
spatter94016523spatter
spavie113611383spavie_
spavies123012943spavies
spaviet123011923spaviet
spavined1434333spavined
spawner12347363spawner
spazzes1735263spazzes
speaned103411523speaned
speared104314423speared
spearmen1234853spearmen
specced14266703specced
specked16329013specked
sped76031493sp___ed
speed85526623sp__eed
speeded113310423speeded
speeled103712453speeled
speered103614813speered
speiled104412123speiled
speired103811103speired
spelled103714733spelled
spewed125512333sp_ewed
sphered133512313sphered
spiced115218313sp_iced
spied85427713sp__ied
spieled104811883spieled
spiered104412463spiered
spiffed16257103spiffed
spiked134915553sp_iked
spiled94621993sp_iled
spilled103613623spilled
spined95423943sp_ined
spired94921863sp_ired
spirted103913073spirted
spited94820443sp_ited
spitted103912703spitted
splasher1335653splasher
splashes1337503splashes
splatted11356743splatted
splayed13357813splayed
spliced124310593spliced
splined105013113splined
sploshed1434323sploshed
spoiled104811353spoiled
spoked134413893sp_oked
sponged1137953sponged
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spoored104411293spoored
spored94821793sp_ored
sported104015433sported
spotted103713133spotted
spoused10349653spoused
spouted103412263spouted
sprained1138433sprained
sprawled1434513sprawled
sprayed13398903sprayed
spruced12307523spruced
spudded12235903spudded
spued84918473sp__ued
spume95817313sp_ume_
spumes1021314883sp_umes
spunked14307783spunked
spurned10339263spurned
spurred103610613spurred
spurted103111973spurted
squashed21215983squashed
stabbed123510373stabbed
stabled103514953stabled
stacked143416123stacked
staffed14298283staffed
staged84521563sta_ged
stagged104212073stagged
stained84215343stained
staked114621943sta_ked
staled74728103sta_led
stalked123811173stalked
stalled83515683stalled
stamen84115943sta_men
stammel11607533stammel
stammer116013343stammer
stamped124812813stamped
staned74824643sta_ned
stanged94113843stanged
stapled103613693stapled
stared75429873sta_red
starred85013453starred
started84217323started
starved114911573starved
stases64225563stas_es
stashes103916163stashes
stated75427833sta_ted
statued8459893statued
staved103918053sta_ved
stayed104817273sta_yed
steamed103712143steamed
stemmed12278153stemmed
stormed1039043stormed
stummed12348553stummed
subsumed1344923subsumed
sudsed83911373suds_ed
summed114014043s_ummed
surpassed1244133surpassed
sussed75015533s_ussed
swabbed15367403swabbed
swacked173110523swacked
swaged114212253swa_ged
swagged13419143swagged
swagmen1334973swagmen
swamped15498443swamped
swanked15359543swanked
swanned11358173swanned
swapped15429143swapped
swarded1238153swarded
swarmer1247803swarmer
swasher134011503swasher
swashes134714403swashes
swathed144611933swathed
swatted114110693swatted
swayed133510263swa_yed
swished14418843swished
tamed85528513_ta_med
tasked114714643_tasked
tasted74123973_tasted
teamed95418593tea_med
teased74721153teas_ed
toasted84011923toasted
trammed123810713trammed
trashed113514693trashed
unaimed102812493unaimed
unarmed101811923unarmed
unasked122010023unasked
upases84112903upas_es
warmed124516893_warmed
washed135521503_washed
wasted104423023_wasted
whammed18345133whammed
yeasted1138503yeasted

Search took 9 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.1731032896.0
2DLD Change Limit1340275098.12316499.7
3Display Results5095090.2502036.0
 (SQL Overall)1786915098.54620909.3
 
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.