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

419 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
mussels941984(None) 
missels94614811missels
mussel83412901mussel_
musses84624781musse_s
bushels124110712bushels
busses85023382busse_s
cussers94213392cussers
cusses84522772cusse_s
dossels85511602dossels
fusels94412452fu_sels
fussers104210812fussers
fusses94920552fusse_s
gunsels8338132gunsels
gussets837442gussets
hassels104311012hassels
masses85028712masse_s
messes84924342messe_s
missals93914422missals
missel85216522missel_
misses85130872misse_s
missets94516572missets
morsels94112652morsels
mossers94116192mossers
mosses85527682mosse_s
mousses94012702mousse_s
muscles11310562muscles
musers84719092mu_sers
muses75134302mu_se_s
mushers124016432mushers
mushes114124562mushe_s
muskegs14285002muskegs
muskets13258632muskets
mussed94418902musse_d
mussily12279772mussily
mustees94614922mustees
musters94522492musters
mutuels935942mutuels
ousels64815272ou_sels
passels93913022passels
pusses84322842pusse_s
russets738162russets
susses64221052susse_s
tassels74510852tassels
tussehs10395562tussehs
tussers74313562tussers
tusses64921242tusse_s
tussles737832tussles
vessels1035932vessels
wusses93314892wusse_s
amassers10337833amassers
amasses93912853amasse_s
amusers94610193amu_sers
amuses85117943amu_se_s
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
basses85428303basse_s
bassets96414823bassets
bosses85925403bosse_s
bulbels11398013bulbels
burses84425513burse_s
buses75936013bu_se_s
bushel114513943bushel_
bushers124018803bushers
bushes115226113bushe_s
busies85525263busie_s
buskers133414083buskers
bussed94717053busse_d
busters94724123busters
bustles93816323bustles
cesses84221363cesse_s
chisels12219103chisels
cossets95014283cossets
counsels1037573counsels
cudgels1135333cudgels
cuisses9319883cuisse_s
cupels10310203cu_pels
cursers94317153cursers
curses85328273curse_s
cusecs10509153cu_secs
cussed94917123cusse_d
cussedly1443143cussedly
cusser86016093cusse_r
cussos84210003cuss_os
damsels10126703damsels
diesels8429143diesels
dispels10310503dispels
disses75225963disse_s
dorsels84412573dorsels
dossals8379293dossals
dossel74813643dossel_
dossers84516233dossers
dosses76126273dosse_s
dossils8669773dossils
duels65619233du__els
duffels14296453duffels
dulses73913653dulse_s
dusters84918353dusters
easels65914553_easels
esses56422973_esse_s
eustele738193eustele
eusteles838043eusteles
fesses94820253fesse_s
fosses96022083fosse_s
fossils10379013fossils
fuels87117353fu__els
funnels10348173funnels
fusees95416403fu_sees
fusel85218493fu_sel_
fuses85628423fu_se_s
fusils93912343fu_sils
fussed104613803fusse_d
fusser94813773fusse_r
fussily13267603fussily
gassers84714633gassers
gasses75724783gasse_s
gausses8308693gausse_s
gospels1035593gospels
guessers9174893guessers
guesses8169373guesse_s
guises74216313guise_s
gunnels8358563gunnels
gunsel7339853gunsel_
gushers113512503gushers
gushes104719033gushe_s
gusset7316433gusse_t
gussies82813303gussies
hansels104011653hansels
hassel95614213hassel_
hassles103411693hassles
hirsels10128343hirsels
hisself1335913hisself
hissers104112313hissers
hisses94719353hisse_s
hosels94218603_hosels
hostels103712313hostels
housels105312133housels
hushes124718593hushe_s
huskers143510033huskers
hussars10326973hussars
hussies103213293hussies
hustles103414173hustles
isseis638563_isseis
jesses135215953jesse_s
josses135117683josse_s
jurels133710583ju_rels
justers143815723justers
justles143311433justles
kissers114211293kissers
kisses104217333kisse_s
kugels1146073ku_gels
kummels15234793kummels
kussos10336423kuss_os
lasses64827593lasse_s
lessees73510243lessees
lessens7409383lessens
listels74212433listels
losels64714583_losels
losses65925233losse_s
lushes94022743lushe_s
lusters73921433lusters
lususes736713lususe_s
mangels103614493mangels
manses84225513manse_s
mantels94515043mantels
marcels113212373marcels
marses84827113marse_s
marvels123810093marvels
masers84623453m_asers
mashers124621053mashers
mashes115030003mashe_s
maskegs14375413maskegs
maskers133913833maskers
massas85116463mass_as
masse75125293masse__
massed94421323masse_d
massedly1444303massedly
masseur935703masseur
masseurs1034923masseurs
masseuse1044253masseuse
massifs1237743massifs
massless10277113massless
masters94628923masters
measles92412753measles
mels65941533m___els
menses84222453mense_s
mescals112911553mescals
meseems1165603meseems
meshes115019443meshe_s
mesnes85216213mesne_s
messans92710463messans
messed95018183messe_d
messily12298813messily
mestees94617753mestees
mioses84318853miose_s
misdeals1147223misdeals
misers85025703m_isers
mises74740563m_ise_s
miskals13369763miskals
mispens11311073mispens
misrely12319603misrely
missal84314903missal_
missays124010253missays
misseat93617233misseat
misseats104011683misseats
missed94423603misse_d
missend104411373missend
missends11368233missends
missense1037963missense
missent94318713missent
misset85028153misse_t
missies93423983missies
missile92815403missile
missiles103015083missiles
missis84417503miss_is
misspell1244303misspell
misspells1343763misspells
misspelt1247273misspelt
missteps12156143missteps
missus85312293miss_us
misters93927503misters
misusers10348073misusers
misuses93216023misuse_s
models94216353m_odels
mohels115011323m_ohels
momsers113810843momsers
morels84820013m_orels
morsel85815893morsel_
moseys114711703m_oseys
moshers124017843moshers
moshes115222873moshe_s
mossed94818893mosse_d
mosser84618273mosse_r
motels83616893m_otels
mousers95216443mousers
mouses85531423mouse_s
mousse84813033mousse__
moussed10338913mousse_d
muches134718993muche_s
muckers153612793muckers
muckles153413253muckles
mucuses11148513mucuse_s
mudders113211103mudders
muddles112914353muddles
mudhens1335103mudhens
mudsill1045163mudsill
mudsills1144243mudsills
muesli835183mues_li
mueslis935493mueslis
muffles153910443muffles
mugfuls1344003mugfuls
muggees11338883muggees
muggers113611933muggers
mughals1355753mughals
mules75034293mu_le_s
muleys11409643mu_leys
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mulls75124153mu__lls
mumbles133014433mumbles
mummers103712843mummers
mumpers133311363mumpers
munsters104010543munsters
murals84016753mu_rals
murders103311363murders
mures75937213mu_re_s
murres85019043murre_s
murreys12367323murreys
muscadels1442623muscadels
muscatels1343443muscatels
muscats1138933muscats
muscids12187973muscids
muscle10310973mu_scle
muscled1237783muscled
muscly1337453mu_scly
muse67136033mu_se__
mused85524583mu_se_d
muser76024123mu_se_r
museum1037703mu_seum
museums1134563museums
mushed124420843mushe_d
musher113820573mushe_r
mushily152410093mushily
musicals1247093musicals
musicks15297053musicks
musics103911783mu_sics
musings10389543musings
musjids17185713musjids
muskeg13338183muske_g
musket122818203muske_t
muskies133614663muskies
muskily16289043muskily
muskits13278553muskits
musks116119643mu_s_ks
muslins9312213muslins
muss64933763mu_s__s
mussier93314353mussier
mussiest103112933mussiest
mussiness11238293mussiness
mussing104015543mussing
mussy104117643muss__y
musted93321073muste_d
mustee83922103muste_e
mustelid1144873mustelid
mustelids1243583mustelids
muster84724523muste_r
musths11589483mu_sths
mustily123613633mustily
musts75527443mu_s_ts
mutases92012043mutase_s
mutely113811653mu_tely
mutes75033783mu_te_s
mutters94117133mutters
mutuals937123mutuals
mutuel837823mutuel_
mutules9311843mutules
muzzles17299683muzzles
myases113711553myase_s
myoses114013843myose_s
myself1445593m_yself
nesses64718323nesse_s
nursers74311833nursers
nurses63919353nurse_s
ourself1057453ourself
ousel55222403ou_sel_
ousters74122773ousters
outsees72616433outsees
outsell7109263outsell
outsells888643outsells
outsets73514923outsets
ouzels15408703ou_zels
passel85117003passel_
passers94717753passers
passes86030473passe_s
pastels95215183pastels
pissers95014753pissers
pisses84525083pisse_s
plusses93510693plusse_s
posses85128803posse_s
possess9419113possess
possets94212773possets
pulsers94213153pulsers
pulses83818663pulse_s
pummels13236543pummels
pursers93916093pursers
purses84826373purse_s
puses75532203pu_se_s
pushers123814503pushers
pushes114621663pushe_s
pusleys12286233pusleys
pussies93615693pussies
pussley12375123pussley
pussleys13273173pussleys
pussly11407373puss_ly
quasses16209503quasse_s
rassles73513923rassles
rubels84112993ru_bels
runnels7329153runnels
ruses56136583ru_se_s
rushees103311953rushees
rushers103816103rushers
rushes94724363rushe_s
russet6319433russe_t
russety1034613russety
rustles73416413rustles
sasses64124393sasse_s
seels55632823__seels
sels46345983___sels
sisses64520603sisse_s
smushes123710093smushe_s
subsets92813103subsets
sudsers83310413sudsers
sudses74114503sudse_s
sunsets72911573sunsets
sussed75015533susse_d
tassel66014773tassel_
tasses64826763tasse_s
tassets75012773tassets
teasels74311313teasels
tinsels738373tinsels
tossers74713493tossers
tosses65225393tosse_s
tressels8367653tressels
trussers8348263trussers
trusses73813633trusse_s
tunnels7328723tunnels
tushes94319473tushe_s
tuskers113710033tuskers
tussahs10335113tussahs
tussal6288323tussal_
tussars7359243tussars
tusseh9448423tusse_h
tusser64615833tusse_r
tussis6379953tuss_is
tussle637143tuss_le
tussled835413tussled
tussors7388763tussors
tussurs7356373tussurs
umbels104510583_umbels
unseals73212573_unseals
unsell63512543_unsell
unsells73210773_unsells
unsets64116163_unsets
unsews9379363_unsews
upsets8409683_upsets
users55817573_u_sers
uses44931113_u_se_s
ushers94415533_ushers
usneas638333_usneas
usuals637783_usuals
vassals1057953vassals
vessel937953vessel_
weasels10468503weasels
wisses94619603wisse_s
wurzels1934083wurzels
wussies103411083wussies
yesses93615813yesse_s

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.1731032896.0
2DLD Change Limit1340274196.73319906.0
3Display Results4194190.1402992.9
 (SQL Overall)1786914197.04625360.6
 
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.