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

119 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
muenster104331(None) 
muensters1143251muensters
munster93710521mu_nster
meister93114162m_eister
minster93914322m_inster
monster93214602m_onster
munsters104010552mu_nsters
muster84724522mu__ster
penster92811952_penster
punster92911102pu_nster
quester161410022que_ster
auguster943953auguster
bunter85020383bu_n_ter
burster9310293bu_rster
buster84726493bu__ster
censer84516583_cens_er
center84421413_cen_ter
deemster1175713deemster
denser74115193_dens_er
diester83013683die_ster
dumpster1344053dumpster
duster74919723du__ster
easter65027983__easter
enter54726383__en_ter
ester54727713__e_ster
feaster10812983_feaster
fester94723513_fe_ster
flenser1036783flens_er
guesser8166543gue_sser
guested9157713gue_sted
heister103613623_heister
honester1139713honester
huckster1743823huckster
hunter94817773hu_n_ter
immenser1244173immens_er
jester134319153_je_ster
juster134617013ju__ster
keester11319913_keester
keister113011573_keister
keyster14256153_keyster
kiester11329973kie_ster
leister73212753_leister
luster64023673lu__ster
magister1136283magister
maltster1035303maltster
master84831343m__aster
meeter83616503m_e_eter
meisters103313843m_eisters
melter83520113m_e_lter
menacer112610883m_enacer
mender93520793m_en_der
mensae84114053m_ensae_
mense75025633m_ens_e_
mensed93916543m_ens_ed
menses84222453m_ens_es
menshen1236813m_enshen
menshes12310453m_enshes
menswear1352183m_enswear
mentee84121293m_en_tee
mentor8414363m_en_tor
messier93412923m_essier
mestee84523883m_e_stee
meter75130323m_e__ter
minister10410363minister
minsters103813923m_insters
minter84425103m_in_ter
minuter93510413m_inuter
misenter10310833misen_ter
mister84728563m__ister
mobster11299213m_obster
modester1197483modester
moister94015373m_oister
molester1099373molester
monstera10318883m_onstera
monsters103314553m_onsters
mounter93713173moun_ter
muncher143610373mu_ncher
muser76024123mu__s_er
musher113820573mu__sher
mussier93314363mu_ssier
musted93321073mu__sted
mustee83922103mu__stee
musters94522513mu__sters
mustier94017963mu__stier
muter74525543mu___ter
mutter84418883mu__tter
nester64124183_ne_ster
oleaster837263oleaster
ouster64223733ou__ster
pensters103012123_pensters
pester84827593_pe_ster
prester93519623pre_ster
punsters103310583pu_nsters
punter84320023pu_n_ter
queasier1734473queasier
quencher2234123quencher
quested17168383que_sted
questers17168763que_sters
questor16146633que_stor
quipster1933933quipster
reenter73217793reen_ter
renter64527413_ren_ter
rester63832433_re_ster
reuniter838323reuniter
spinster1036683spinster
teensier835573teensier
tenser64919433_tens_er
tenter64623933_ten_ter
tester64227153_te_ster
ulster63712103_u_lster
uniter64619143_u_niter
unstep839223_u_nstep
venter94218723_ven_ter
webster1236093_webster
weensier1134243weensier
wester94222893_we_ster
wrester102812413wre_ster
yester93417983_ye_ster
zester153617793_ze_ster

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621197.18620339.8
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.63823395.0
 
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.