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

328 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
amassed1038863(None) 
amasser9418731amasser
amasses93912851amasses
massed94421321_massed
abased96514992aba_sed
abashed1357662abashed
admasses1135412admasses
amass77119682amass__
amassers10337842amassers
amazed18519312ama_zed
amused94412512am_used
badassed1244272badassed
biassed10418702biassed
brassed103612372brassed
camasses12388972camasses
chassed134712132chassed
classed104113652classed
damasked1643752damasked
gassed85217632_gassed
glassed93710432glassed
grassed93812792grassed
harassed1237112harassed
mashed125325042_mashed
masked134316522_masked
masse75125292_masse_
masses85028712_masses
masted94025802_masted
messed95018182_messed
missed94423602_missed
mossed94818892_mossed
mussed94418902_mussed
passed94320942_passed
sassed76116172_sassed
smashed133711222smashed
unamassed1244242unamassed
aahed917816443a_a_hed
abase76023483aba_se_
abaser86414343aba_ser
abases85720773aba_ses
abashes12510373abashes
abated95918453aba_ted
abused95614273a_bused
abysses1234863abysses
accessed1385403accessed
accused12368423accused
adapted1135843adapted
admass957143admass__
advised12136043advised
agisted938203agisted
airshed11258533airshed
aisled74516183a_isled
alarmed1037733alarmed
alated75625143ala_ted
allseed835953allseed
amahs107819063amahs__
amas67746293ama_s__
amassing1138003amassing
amassment1346413amassment
amaze166016603ama_ze_
amazes175613473ama_zes
ambled115116373am_bled
ambushed1644463ambushed
amended11328313amended
amerced1256523amerced
amiss75823073amiss__
amped104820513am__ped
amuse75920833am_use_
amuser84712623am_user
amuses85117943am_uses
analysed12166913analysed
aniseed839403aniseed
ansated84214003ansated
apposed1247853apposed
aroused84914343aroused
arrased8149863arrased
ashed97829773__ashed
asked106919313__asked
assayed1135593assayed
asses55629283__asses
assessed945023assessed
asset55932263__asset
availed1135973availed
avgasses1284193avgasses
avulsed1133833avulsed
awaited1146963awaited
awaked14579203awa_ked
awarded1236223awarded
axised14438963a_xised
axseed1456993a_xseed
badasses1136173badasses
bagasse1035143bagasse_
bagasses1136313bagasses
based85331583_ba_sed
bashed126225703_bashed
basked135218603_basked
basses85428303_basses
basset85225383_basset
basted95227233_basted
biased94012223bia_sed
biasses94911653biasses
blasted104213473blasted
blessed10319493blessed
blissed10388373blissed
boasted104113743boasted
bossed94816533_bossed
braised104014803braised
brasses93818353brasses
bussed94717053_bussed
bypassed1642713bypassed
camailed1336553camailed
camases114216343cama_ses
camass104114183camass__
campused1535253campused
canvassed15274033canvassed
caressed1139163caressed
cased86032413_ca_sed
cashed125124353_cashed
casked134815513_casked
caused95117043_caused
ceased94920783cea_sed
cessed94615613_cessed
chased125019293cha_sed
chasmed154710173chasmed
chasse115114603chasse_
chasses124017503chasses
clashed133614013clashed
clasped123610443clasped
classer93614613classer
classes94717943classes
coasted104015953coasted
compassed1645543compassed
crashed134214203crashed
crasser94114333crasser
crossed105313893crossed
cussed94917123_cussed
damaged1257453dama_ged
dashed115920563_dashed
deashed123411303deashed
degassed11275963degassed
demasted1238763demasted
dissed85220183_dissed
dossed84516633_dossed
dressed93511873dressed
eased65430403_ea_sed
elapsed1056103elapsed
emailed10359213emailed
embossed1344693embossed
emersed10138513emersed
erased74816753era_sed
eyasses10388023eyasses
famished1766023famished
fashed136720253_fashed
fasted105320953_fasted
feased105718713fea_sed
feasted11310843feasted
fessed104515063_fessed
flashed144112183flashed
flossed11388533flossed
frasses104314513frasses
fussed104613803_fussed
gamashes1456943gamashes
gashed116321973_gashed
gasped104814293_gasped
gasser75017773_gasser
gasses75724783_gasses
gasted84821583_gasted
glasses84414273glasses
glossed94410073glossed
gnashed12317523gnashed
grasped11409063grasped
grasses84117343grasses
grossed93812253grossed
guessed9176603guessed
harasser1137033harasser
harasses11311033harasses
hashed136021943_hashed
hasped125014443_hasped
hassel95614213_hassel
hassled11358303_hassled
hasted105125283_hasted
hearsed113811403hearsed
hissed104114453_hissed
imaged1097763ima_ged
impasse11246463impasse_
impasses12257523impasses
impasted13297553impasted
imposed123110293imposed
jassid1467223_jassid
jessed144112303_jessed
kavasses1544303kavasses
kissed114412853_kissed
kvasses14365503kvasses
lambasted14103253lambasted
lapsed94712583_lapsed
lased65132343_la_sed
lashed105625213_lashed
lasses64827593_lasses
lassoed8408743_lassoed
lasted74323603_lasted
leased74722883lea_sed
leashed113211163leashed
liaised837113liaised
maced108528693_ma_ced
macled116718113_macled
madded113513553_madded
mailed95326753_mailed
maimed114812663_maimed
malfed12369763_malfed
malled94626113_malled
malted94819863_malted
maned86634103_ma_ned
manned94418643_manned
manse75528233_manse_
manses84225513_manses
mapped134015883_mapped
marked133921623_marked
marled95523163_marled
marred95421043_marred
marse76231153_marse_
marses84827113_marses
marted94425213_marted
maser75029973_ma_ser
masher114123203_masher
mashes115030003_mashes
masjid16187323_masjid
maskeg13388693_maskeg
masker124416103_masker
masoned1039803_masoned
mass66044943_mass__
massa75518923_mass_a
massaged1236753_massaged
massas85116463_massas
massedly1444303_massedly
masseur935703_masseur
massier93615223_massier
massif11412533_massif
massy104518963_mass_y
master84831343_master
mated85537783_ma_ted
matted94521413_matted
mauled94817823_mauled
mawed115824743_ma_wed
maxed155821193_ma_xed
mayed115522403_ma_yed
mazed175523873_ma_zed
measled10339303measled
mensed93916543_mensed
meshed124415933_meshed
messes84924343_messes
misfed124113023_misfed
misled94719313_misled
missel85216523_missel
missend104411373_missend
misses85130873_misses
misset85028153_misset
misted93625823_misted
misused104111283_misused
moshed124517493_moshed
mosser84618273_mosser
mosses85527683_mosses
moused94423303_moused
moussed10338913moussed
mused85524583_m_used
mushed124420843_mushed
mussel83412903_mussel
musses84624783_musses
musted93321073_musted
parsed96323893_parsed
pashed125923143_pashed
passe75525693_passe_
passee84522023_passee
passel85117003_passel
passer84721033_passer
passes86030473_passes
pasted94426903_pasted
paused95114963_paused
phased124011973pha_sed
pissed94816933_pissed
plashed133712643plashed
praised104214813praised
pressed103317313pressed
prissed103311263prissed
quashed20207973quashed
quasses16209503quasses
raised76120333_raised
rased65033933_ra_sed
rasped94715203_rasped
rassled83310453_rassled
repassed11229273repassed
roasted83912663roasted
sashed105622943_sashed
sasses64124393_sasses
slashed114114853slashed
smacked163710993smacked
smarted105012613smarted
smasher123911023smasher
smashes123914613smashes
smushed13368233smushed
spasmed12296993spasmed
stashed113812493stashed
sussed75015533_sussed
swashed144311363swashed
tasked114714643_tasked
tasse54821843_tasse_
tassel66014773_tassel
tasses64826763_tasses
tasset65925313_tasset
tasted74123973_tasted
tawsed10499743_tawsed
teased74721153tea_sed
toasted84011923toasted
tossed74215223_tossed
trashed113514703trashed
trasses74819323trasses
tressed83714253tressed
trussed84010013trussed
unasked122010023unasked
unmasked15267143unmasked
vamoosed1443923vamoosed
vamosed1335923vam_osed
washed135521503_washed
wasted104423023_wasted
wissed104114643_wissed
wrasse9398773wrasse_
wrasses103812593wrasses
wrassled12325383wrassled
yeasted1138503yeasted
yessed104511163_yessed

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.1531167915.0
2DLD Change Limit1340273286.08022043.9
3Display Results3283280.1262603.2
 (SQL Overall)1786913286.35928100.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.