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

502 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
amasses9391285(None) 
admasses1135411admasses
amassed10388631amassed
amasser9418731amasser
amassers10337841amassers
camasses12388971camasses
masses85028711_masses
abases85720772aba_ses
abashes12510372abashes
abysses1234862abysses
amass77119682ama_s_s
amazes175613472ama_zes
amuses85117942am_uses
asses55629282__asses
avgasses1284192avgasses
badasses1136172badasses
bagasses1136312bagasses
basses85428302_basses
biasses94911652biasses
brasses93818352brasses
camases114216342cama_ses
chasses124017502chasses
classes94717942classes
eyasses10388022eyasses
frasses104314512frasses
gamashes1456952gamashes
gasses75724782_gasses
glasses84414272glasses
grasses84117342grasses
harasses11311032harasses
impasses12257522impasses
kavasses1544302kavasses
kvasses14365502kvasses
lasses64827592_lasses
manses84225512_manses
marses84827112_marses
mashes115030002_mashes
massas85116462_massas
masse75125292_masse_
massed94421322_massed
messes84924342_messes
misses85130872_misses
mosses85527682_mosses
musses84624782_musses
passes86030472_passes
quasses16209502quasses
sasses64124392_sasses
smashes123914612smashes
tasses64826762_tasses
trasses74819322trasses
wrasses103812592wrasses
abacuses1235763abacuses
abase76023483aba_se_
abased96514993aba_sed
abaser86414343aba_ser
abasers95311973abasers
abashed1357663abashed
abasias9711013abasias
abates85825033aba_tes
abatises10311013abatises
abbesses1235333abbesses
abioses9311493abioses
abuses85119103a_buses
accesses1287493accesses
accuses114112193accuses
adages8412953ada_ges
admass957143adma_s_s
advises11138973advises
aegises8311373aegises
agapes95212413aga_pes
agaroses938823agaroses
agates76121343aga_tes
agaves104611513aga_ves
aisles64721143a_isles
alaskas1136683alaskas
alates64833973ala_tes
aldoses8311203aldoses
aliases7914493aliases
amadous1038503amadous
amahs107819063ama__hs
amarones10311353amarones
amas67746293ama___s
amassing1138003amassing
amassment1346413amassment
amassments1444493amassments
amatols938183amatols
amauroses1144473amauroses
amaze166016603ama_ze_
amazed18519313ama_zed
amazons1836653amazons
ambages1269623ambages
ambaries123312383ambaries
ambles105121863am_bles
ambones11312683ambones
ambries111614553ambries
ambsaces1455213ambsaces
ambushes1535803ambushes
amerces1149853amerces
amesaces1246693amesaces
amices105018013am_ices
amidases1136653amidases
amides95722663am_ides
amies76837693am__ies
amines84727983am_ines
amiss75823073am_is_s
amities9317383amities
amitoses1039053amitoses
ammines11312673ammines
amoles84122193am_oles
amosites10311233amosites
amperes11313983amperes
ampules1189433ampules
amuse75920833am_use_
amused94412513am_used
amuser84712623am_user
amusers94610193amusers
amusias938583amusias
amylases1346663amylases
amyloses1347223amyloses
anabases1038083anabases
analyses11149963analyses
anankes1138763anankes
anatases839793anatases
anises64826693a_nises
ankuses1148203ankuses
anlases72514903anlases
anuses66218773a_nuses
apaches143411843apaches
apheses12610703apheses
apoapses1244723apoapses
apposes11511473apposes
apses76823913__apses
arables91814973arables
arames84622573ara_mes
arcuses94814693arcuses
arguses84711743arguses
arises65233803a_rises
arkoses113910833arkoses
arouses74921293arouses
arrases71214543arrases
arrises71617583arrises
arses55733873__arses
asceses938623asceses
asepses946363asepses
ashes86230613__ashes
askeses1136463askeses
aspises9611643aspises
assess65710463__assess
assesses737383assesses
asset55932263__asset
assets65617663__assets
ataxies142410013ataxies
atlases72410643atlases
auxeses1435623auxeses
avenses1049643avenses
avgases11106313avgases
avulses1035433avulses
awakes135012473awa_kes
axises134413993a_xises
baases85218013_baases
babassus1243063babassus
badassed1244273badassed
bagasse1035143bagasse_
balases93815433bala_ses
bases75644353_ba_ses
bashes115631393_bashes
basset85225383_basset
bassets96414823_bassets
bassos85313703_bassos
bastes85330383_bastes
biases84618433bia_ses
biassed10418703biassed
biomasses1343963biomasses
blesses93812393blesses
blisses94911513blisses
bosses85925403_bosses
braises93818873braises
brashes124518463brashes
brassed103612373brassed
brassies103613533brassies
brisses94314313brisses
busses85023383_busses
bypasses1533833bypasses
calashes13310543calashes
camass104114183cama_s_s
camises114218463cam_ises
campuses1437773campuses
canvasses14286043canvasses
carcasses1337483carcasses
caresses10314063caresses
carses85233653_carses
cases75048383_ca_ses
cashes114729883_cashes
cassis84818853_cassis
castes85631863_castes
causes88026473_causes
ceases84427073cea_ses
cesses84221363_cesses
chaises124317493chaises
chaoses124715123chaoses
chases115128233cha_ses
chasse115114603chasse_
chassed134712133chassed
chassis123910663chassis
chausses1345963chausses
chesses124112633chesses
clashes124017283clashes
classed104113653classed
classer93614613classer
classers104111833classers
classis93712723classis
clauses93813323clauses
compasses1547393compasses
crases85532313cra_ses
crashes124618403crashes
crasser94114343crasser
crassest103411523crassest
cresses94219813cresses
crosses94220793crosses
cuisses9319883cuisses
cusses84522773_cusses
daises74318983_daises
damages11511283dama_ges
damasked1643753damasked
damasks1435073dama_sks
dashes106124983_dashes
dassies84418663_dassies
deashes113313903deashes
degasses10278363degasses
disses75225963_disses
dosses76126273_dosses
dresses83716173dresses
drosses84513823drosses
eases56041613_ea_ses
easies64126633_easies
elapses957663elapses
embassies1344003embassies
embosses1235963embosses
emdashes14224303emdashes
emeses86114963em_eses
erases64425403era_ses
esses56422973__esses
eyases94513683eya_ses
famishes1658283famishes
fasces114914543_fasces
fashes124524023_fashes
feases95422923fea_ses
fesses94820253_fesses
flashes133916103flashes
flosses103411973flosses
fosses96022083_fosses
fraises104215693fraises
fusses94920553_fusses
gases65633993_ga_ses
gashes105725153_gashes
gassed85217633_gassed
gasser75017773_gasser
gassers84714633_gassers
gausses8308693gausses
glassed93710433glassed
glassies94012273glassies
glosses84014123glosses
gnashes11419573gnashes
grassed93812793grassed
grosses84517683grosses
guesses8169373guesses
hamates122917683hama_tes
hanses95022633_hanses
harassed1237113harassed
harasser1137043harasser
harassers1246203harassers
hardasses1346453hardasses
hashes125024803_hashes
hassel95614213_hassel
hassels104311013_hassels
hassles103411693_hassles
hastes95727073_hastes
hawses125113993_hawses
hearses104414533hearses
hisses94719353_hisses
iambuses1235783iambuses
images91411463ima_ges
imagoes10126403imagoes
impasse11246463impasse_
impastes12238193impastes
imposes113213683imposes
jackasses2243713jackasses
jesses135215953_jesses
josses135117683_josses
karosses1236493karosses
kisses104217333_kisses
kumisses1443583kumisses
kvases13467103kva_ses
lambastes13114693lambastes
lampases1267293lampases
landmasses1343213landmasses
lapses85217693_lapses
lases54944763_la_ses
lashes94831003_lashes
lassies74420103_lassies
lassis65216703_lassis
lassoes74613853_lassoes
lassos64913813_lassos
lavashes1445573lavashes
leases65428113lea_ses
leashes103514403leashes
liaises7311053liaises
loesses7310033loesses
losses65925233_losses
lyases95211873lya_ses
mabes96331533_ma_bes
maces97139963_ma_ces
maches134827233_maches
macles107023223_macles
madres93718183_madres
maes66948403_ma__es
mages85036023_ma_ges
mahoes11313103_mahoes
mailes84329113_mailes
maists85817573_maists
maizes175115733_maizes
makes115336853_ma_kes
malaises10312333malaises
males75049793_ma_les
mamies104626243_mamies
manes76648963_ma_nes
manges94628943_manges
manse75528233_manse_
mantes84430783_mantes
maples104819423_maples
mares76457633_ma_res
marges94525713_marges
marse76231153_marse_
marshes123615373marshes
masas75630413_ma_sas
maser75029973_ma_ser
masers84623453_masers
mashed125325043_mashed
masher114123203_masher
mashers124621053_mashers
mashies12318253_mashies
masked134316523_masked
maskeg13388693_maskeg
maskegs14375413_maskegs
masker124416103_masker
maskers133913843_maskers
masks115320533_ma_sks
masons83916513_masons
masques18239363_masques
mass66044943_ma_s_s
massa75518923_mass_a
massages1159883_massages
masseur935703_masseur
masseurs1034923_masseurs
masseuse1044253_masseuse
massier93615223_massier
massiest103314423_massiest
massif11412533_massif
massifs1237743_massifs
massless10277113_massless
massy104518963_mass_y
masted94025803_masted
master84831343_master
masters94628923_masters
masts77035763_ma_sts
mates75251363_ma_tes
matrasses1157293matrasses
matres84522233_matres
mattes85624533_mattes
mauves113811553_mauves
mavies114923193_mavies
mavises122812993mavises
maxes145629533_ma_xes
maybes1339243_maybes
mazes165632173_ma_zes
measles92412753measles
megasses11307743megasses
menses84222453_menses
meshes115019443_meshes
mesnes85216213_mesnes
messed95018183_messed
mioses84318853_mioses
mises74740563_m_ises
missed94423603_missed
missel85216523_missel
missels94614813_missels
misset85028153_misset
missets94516573_missets
missies93423983_missies
missis84417503_missis
missus85312293_missus
misuses93216023_misuses
molasses1037233molasses
morasses1038903morasses
moshes115222873_moshes
mossed94818893_mossed
mosser84618273_mosser
mossers94116193_mossers
mouses85531423_mouses
mousses94012703mousses
muses75134303_m_uses
mushes114124563_mushes
mussed94418903_mussed
mussel83412903_mussel
mussels9419843_mussels
myases113711553_myases
myoses114013843_myoses
nesses64718323_nesses
oakmosses1551823oakmosses
oases55330983_oa_ses
oyesses1037333oyesses
parses85534703_parses
pases75346503_pa_ses
pashes115828393_pashes
passe75525693_passe_
passed94320943_passed
passee84522023_passee
passel85117003_passel
passels93913023_passels
passer84721033_passer
passers94717753_passers
passus83610293_passus
pastes85233913_pastes
pauses84621473_pauses
pavisses13397103pavisses
peases85229473pea_ses
phases114618403pha_ses
pisses84525083_pisses
plashes124417393plashes
plisses94411773plisses
plusses93510693plusses
posses85128803_posses
praises94121103praises
prases84429023pra_ses
presses93523153presses
prisses94816713prisses
prosses94019513prosses
pusses84322843_pusses
quamashes2343973quamashes
quashes192110973quashes
raises64826543_raises
rases55447213_ra_ses
rashes95330153_rashes
rassles73513923_rassles
reassess836513reassess
repasses101810373repasses
rubasses1035493rubasses
sashes94728483_sashes
sassed76116173_sassed
sassies74719263_sassies
sisses64520603_sisses
slashes103619113slashes
smashed133711223smashed
smasher123911023smasher
smashers13339593smashers
smazes174311663sma_zes
smushes123710093smushes
snashes105214753snashes
stases64225563sta_ses
stashes103916173stashes
strasses81311443strasses
susses64221053_susses
swashes134714403swashes
swisses10417143swisses
tamales93216153tama_les
tamashas13135683tamashas
tamises92715973tam_ises
tasse54821843_tasse_
tassel66014773_tassel
tassels74510853_tassels
tasset65925313_tasset
tassets75012773_tassets
tassies74918933_tassies
tastes64126423_tastes
tawses94913193_tawses
teases65426273tea_ses
tmeses85712243tm_eses
tosses65225393_tosses
trashes104119263trashes
tresses73719543tresses
trusses73813643trusses
tusses64921243_tusses
ukases10358063uka_ses
unamassed1244243unamassed
upases84112903upa_ses
urases63723563ura_ses
valses94514613_valses
vamooses1345523vamooses
vamoses1239143vam_oses
vases84626263_va_ses
vinasses1135703vinasses
wammuses1543493wammuses
wampuses1534113wampuses
wamuses1237023wam_uses
washes124425493_washes
wastes96224883_wastes
wisses94619603_wisses
wrasse9398773wrasse_
wrassles11376713wrassles
wusses93314893_wusses
yesses93615813_yesses
zymases21938333zyma_ses

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.406440125.6
2DLD Change Limit1340275026.51620568.9
3Display Results5025020.1702952.9
 (SQL Overall)1786915027.09225196.1
 
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.