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

380 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
munsters10401055(None) 
minsters103813921minsters
monsters103314551monsters
muensters1143251muensters
munster93710521munster_
musters94522511mu_sters
punsters103310581punsters
bunters94717122bun_ters
bursters1038982bursters
busters94724132bu_sters
dusters84918362du_sters
hunters103915732hun_ters
justers143815732ju_sters
lusters73921442lu_sters
masters94628922m_asters
meisters103313842meisters
ministers1139622ministers
minster93914322minster_
minters93822472min_ters
misters93927512m_isters
mobsters12359062mobsters
monster93214602monster_
monstera10318882monstera
monsteras11318242monsteras
mounters103712502moun_ters
muenster1043312muenster_
munchers15318772munchers
musers84719102mu_s_ers
mushers124016442mu_shers
mustees94614922mu_stees
muster84724522mu_ster_
mutters94117142mu_tters
ousters74122792ou_sters
pensters103012122pensters
punster92911102punster_
punters93617042pun_ters
questers17168762questers
ulsters72711982_ulsters
uniters73814172_uniters
unsteps936212_unsteps
amusers94610193amu_s_ers
answers1037043_answers
asters65631603__asters
austere7312993au_stere
banisters11189473banisters
banters94623123ban_ters
basters94930313_basters
bisters93922613_bisters
blasters104116143blasters
blisters104015083blisters
blusters104413893blusters
boasters103915663boasters
bolsters103712453bolsters
boosters104013453boosters
bundlers11399183bundlers
bunglers11398483bunglers
bunkers133715953bun_kers
bunter85020383bun_ter_
burster9310293burster_
bushers124018803bu_shers
buskers133414093bu_skers
buster84726493bu_ster_
bustiers103810053bu_stiers
bustlers104210623bu_stlers
butters94521723bu_tters
canisters112310203canisters
canters94827733can_ters
casters94729903_casters
censers94313903cens_ers
centers94420603cen_ters
chunters133910903chun_ters
clusters102912403clusters
clysters13227843clysters
coasters104317343coasters
costers94128343_costers
counters103320193coun_ters
cunners93913473cun_ners
cursers94317163curs_ers
cussers94213403cu_ssers
cutters94218963cu_tters
dabsters1137053dabsters
daunters9329853daun_ters
diasters92913183diasters
diesters92513603diesters
dumpsters1453743dumpsters
dunites8313593dunite_s
dunkers123512193dun_kers
duster74919723du_ster_
easters75125683_easters
enters64425643_en_ters
esters64627733__esters
feasters11511563feasters
festers104121393_festers
fibsters13126413fibsters
flusters113811503flusters
fosters104220103_fosters
functors1335743functors
funders113813933fun_ders
funkers143712063fun_kers
fussers104210813fu_ssers
gagsters10317083gagsters
gangsters11205733gangsters
ganisters10248313ganisters
gasters85624293_gasters
glisters93912603glisters
gristers94013413gristers
grunters9359033grun_ters
guessers9174903guessers
gunites8313123gunite_s
gunners83111733gun_ners
gunsels8338133guns_els
gushers113512513gu_shers
gutters83715513gu_tters
gypsters1434023gypsters
hamsters13710423hamsters
haunters11329543haun_ters
heisters113413133heisters
hinters103719583hin_ters
hipsters13268793hipsters
hoisters113513493hoisters
holsters113211943holsters
hucksters1843653hucksters
hungers114013303hun_gers
hunkers143314333hun_kers
hunter94817773hun_ter_
hurters103413643hu_rters
huskers143510043hu_skers
hustlers11349203hu_stlers
igniters9126233igniters
imposters13347343imposters
instars7411133_instars
insteps936573_insteps
inters64328053_in_ters
jesters144118193_jesters
jousters153210423jousters
junipers1733933junipers
junkers184010863jun_kers
junketers2042933junketers
juster134617013ju_ster_
keesters12319593keesters
keisters123212043keisters
keysters15326333keysters
kiesters123310153kiesters
klisters123910483klisters
lamsters1099753lamsters
lasters75627693_lasters
leisters83312823leisters
linters73822633lin_ters
listers74026533_listers
lobsters10268743lobsters
lunchers13349563lunchers
lungers83817093lun_gers
lunkers113414603lun_kers
luster64023673lu_ster_
lustres73013233lu_stres
magisters1235803magisters
maltsters1135193maltsters
managers112911003managers
manatees10310423manatees
mangers103521263man_gers
manglers113311903manglers
manners93417833man_ners
manses84225513mans_e_s
mantels94515043man_tels
mantes84430783man_te_s
manurers1037593manurers
masers84623453m_as_ers
mashers124621053m_ashers
maskers133913843m_askers
masseters1136283masseters
master84831343m_aster_
mastery124214323m_astery
maters85032393m__aters
matters94421753m_atters
maunders11348343maun_ders
meeters94714543m_eeters
meister93114163meister_
melters93918313m_elters
menacers12279313menacers
menders103818803men_ders
menses84222453mens_e_s
menshes12310453menshe_s
mentees93214503men_tees
mentors9314993men_tors
mestees94617753m_estees
meters85625833m__eters
milters93619093m_ilters
mincers113714853min_cers
minders103720123min_ders
miners84126633min__ers
minglers113011293minglers
minister10410363minister_
minivers1337483minivers
minstrel1046913minstrel
minstrels1145693minstrels
minter84425103min_ter_
minuter93510413minuter_
minutes93513443minute_s
misers85025703m_is_ers
missteers1135913missteers
missteps12156143missteps
mister84728563m_ister_
misterm114314513m_isterm
misterms123711353m_isterms
miters84328783m__iters
mobster11299213mobster_
moistens10268773moistens
moister94015373moister_
molesters1198873molesters
molters93816973m_olters
momsers113810853moms_ers
monastery1444373monastery
moneyers1337423moneyers
mongers104217273mon_gers
monikers1437413monikers
monitors10310823monitors
monoesters1245993monoesters
monomers12311033monomers
montero9310133mon_tero
monteros1039453mon_teros
montes84226933mon_te_s
mooters93818623m_ooters
moshers124017843m_oshers
mossers94116193m_ossers
moulters103510783moulters
mounter93713173moun_ter_
mousers95216443mous_ers
muckers153612803mu_ckers
mudders113211113mu_dders
muddlers12428813muddlers
mufflers16316003mufflers
muggers113611933mu_ggers
muleteers1143673muleteers
mullers93217303mu_llers
mumblers14328763mumblers
mummers103712843mu_mmers
mumpers133311373mu_mpers
muncher143610373muncher_
munches144215793munche_s
mungoes103510463mungoe_s
muntins92715133mun_tins
murders103311363mu_rders
murthers1336543murthers
muser76024123mu_s_er_
muses75134303mu_s_e_s
musher113820573mu_sher_
mushes114124563mu_she_s
muskegs14285013mu_skegs
muskets13258643mu_skets
mussels9419843mu_ssels
musses84624783mu_sse_s
mussier93314363mussier_
mustard10359533mu_stard
mustards11297883mu_stards
musted93321073mu_ste_d
mustee83922103mu_ste_e
mustered112511503mu_stered
musths11589483mu_st_hs
mustier94017963mu_stier_
musts75527443mu_st__s
mutates92215793mutate_s
muter74525543mu__ter_
mutes75033783mu__te_s
mutter84418883mu_tter_
muzzlers18245203muzzlers
mynheers1642113mynheers
mystery15436523m_ystery
nesters74422793_nesters
niters64624213__niters
noters64021003__noters
nursers74311833nurs_ers
nutters74215433nu_tters
oldsters996733oldsters
ouster64223733ou_ster_
outers64230173ou__ters
outsteers936033outsteers
oysters103411693_oysters
pasters94531733_pasters
penster92811953penster_
pesters93827093_pesters
piasters102912813piasters
pinasters1136823pinasters
plasters103518133plasters
posters93928013_posters
presters103419003presters
pulsers94213153puls_ers
punchers152610073punchers
punishers1434973punishers
punkers133714853pun_kers
punners94114233pun_ners
punter84320023pun_ter_
pursers93916093purs_ers
pursuers10376523pursuers
pushers123814503pu_shers
putters94219193pu_tters
quarters173110453quarters
quashers20186803quashers
quester161410023quester_
questors17147013questors
quieters17248733quieters
quilters17228433quilters
quipsters2043593quipsters
quitters17238523quitters
quoters16369263qu_oters
ranters73323643ran_ters
rasters74629023_rasters
renters74224813ren_ters
resters74130403_resters
reuniters936423reuniters
rinsers73815743rins_ers
roasters83615933roasters
roisters83615563roisters
roosters83514673roosters
rosters73727553_rosters
rousters84315683rousters
roysters113610533roysters
runners74212453run_ners
runovers1134473runovers
rushers103816103ru_shers
rustlers8339853ru_stlers
saunters82911753saun_ters
shunters113210753shun_ters
shysters14106463shysters
sinters74024083sin_ters
sisters73721593_sisters
songsters1046113songsters
spinsters1136613spinsters
sudsers83310423suds_ers
suiters73618883su_iters
sumpters1238023sumpters
sunders84120053sun_ders
sunsets72911573suns_ets
tapsters10318803tapsters
tasters74225643_tasters
taunters8259273taun_ters
tenters73921103ten_ters
testers74124543_testers
tinters74221113tin_ters
tipsters10278523tipsters
toasters83912723toasters
trusters83112263trusters
trysters11298373trysters
tufters10298353tu_fters
tuners64417343tun__ers
tungstens1042223tungstens
tuskers113710043tu_skers
tussers74313563tu_ssers
twisters11268173twisters
ulster63712103_ulster_
undoers82910583_undoers
uniter64619143_uniter_
unites65024853_unite_s
unmiters1037073_unmiters
unsets64116163_uns_ets
unsews9379363_uns_ews
unsteel738793_unsteel
unsteels845793_unsteels
unstep839223_unste_p
unstops936993_unstops
unstress837373_unstress
unswears1144023_unswears
upsteps1133743_upsteps
upstirs935293_upstirs
ureters7311823_ureters
users55817573_u_s_ers
ushers94415533_u_shers
utters63817123_u_tters
vaunters11327753vaun_ters
venters103717733ven_ters
waisters113811523waisters
wanters104420093wan_ters
wasters104026593_wasters
websters1335803websters
westers105221963_westers
winters103720483win_ters
wresters112711733wresters
xysters17307163_xysters
youngsters1441973youngsters
zesters163517293_zesters
zosters163015413_zosters

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 Filter1786911461620.453394461.4
2DLD Change Limit1461623807.40619735.6
3Display Results3803800.1562435.9
 (SQL Overall)1786913808.01522294.6
 
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.