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 “musters” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
musters9452251(None) 
busters94724131busters
dusters84918361dusters
justers143815731justers
lusters73921441lusters
masters94628921masters
misters93927511misters
munsters104010551munsters
musers84719101mus_ers
mushers124016441mushers
mustees94614921mustees
muster84724521muster_
mutters94117141mutters
ousters74122791ousters
amusers94610192amus_ers
asters65631602_asters
austere7312992austere
basters94930302basters
bisters93922612bisters
blusters104413892blusters
bunters94717122bunters
bursters1038982bursters
bushers124018802bushers
buskers133414092buskers
buster84726492buster_
bustiers103810052bustiers
bustlers104210612bustlers
butters94521722butters
casters94729902casters
clusters102912402clusters
costers94128332costers
cussers94213402cussers
cutters94218962cutters
duster74919722duster_
easters75125682easters
esters64627732_esters
festers104121392festers
flusters113811502flusters
fosters104220102fosters
fussers104210812fussers
gasters85624292gasters
gushers113512512gushers
gutters83715512gutters
hunters103915732hunters
hurters103413642hurters
huskers143510042huskers
hustlers11349202hustlers
jesters144118192jesters
jousters153210422jousters
juster134617012juster_
lasters75627692lasters
listers74026532listers
luster64023672luster_
lustres73013232lustres
masers84623452mas_ers
mashers124621052mashers
maskers133913842maskers
master84831342master_
mastery124214322mastery
maters85032392m_aters
matters94421752matters
meeters94714542meeters
meisters103313842meisters
melters93918312melters
mestees94617752mestees
meters85625832m_eters
milters93619092milters
minsters103813922minsters
minters93822472minters
misers85025702mis_ers
mister84728562mister_
misterm114314512misterm
misterms123711352misterms
miters84328782m_iters
mobsters12359062mobsters
molters93816972molters
monsters103314552monsters
mooters93818622mooters
moshers124017842moshers
mossers94116192mossers
moulters103510782moulters
mounters103712502mounters
mousers95216442mous_ers
muckers153612802muckers
mudders113211112mudders
muensters1143252muensters
muggers113611932muggers
mullers93217302mullers
mummers103712842mummers
mumpers133311372mumpers
munster93710522munster_
murders103311362murders
murthers1336542murthers
muser76024122mus_er_
muses75134302mus_e_s
musher113820572musher_
mushes114124562mushe_s
muskegs14285012muskegs
muskets13258642muskets
mussels9419842mussels
musses84624782musse_s
mustard10359532mustard
mustards11297882mustards
musted93321072muste_d
mustee83922102muste_e
mustered112511502mustered
musths11589482must_hs
mustier94017962mustier_
musts75527442must__s
muter74525542mu_ter_
mutes75033782mu_te_s
mutter84418882mutter_
mystery15436522mystery
nesters74422792nesters
nutters74215432nutters
ouster64223732ouster_
outers64230172ou_ters
oysters103411692oysters
pasters94531732pasters
pesters93827092pesters
posters93928012posters
punsters103310582punsters
punters93617042punters
pushers123814502pushers
putters94219192putters
questers17168762questers
quoters16369262quoters
rasters74629022rasters
resters74130402resters
rosters73727542rosters
rousters84315682rousters
rushers103816102rushers
rustlers8339852rustlers
sisters73721592sisters
suiters73618882suiters
tasters74225642tasters
testers74124542testers
trusters83112262trusters
tufters10298352tufters
tuskers113710042tuskers
tussers74313562tussers
ulsters72711982ulsters
users55817572_us_ers
ushers94415532_ushers
utters63817122_utters
wasters104026592wasters
westers105221962westers
xysters17307162xysters
zesters163517292zesters
zosters163015412zosters

Search took 5 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 Filter1786911076710.483369960.7
2DLD Change Limit1076711503.93627355.4
3Display Results1501500.0503000.0
 (SQL Overall)1786911504.46939984.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.