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

145 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
monstera1031888(None) 
monster93214601monster_
monsteras11318241monsteras
monsters103314551monsters
minster93914322minster_
minsters103813922minsters
mobster11299212mobster_
mobsters12359062mobsters
moister94015372moister_
monastery1444372monastery
montero9310132mon_tero
munster93710522munster_
munsters104010552munsters
boaster94616433boaster_
boasters103915663boasters
bolster93713423bolster_
bolsters103712453bolsters
booster94314553booster_
boosters104013443boosters
coaster94219043coaster_
coasters104317333coasters
contra83314703con_t_ra
coster84331293co_ster_
costers94128333co_sters
entera64216833_en_tera
foster94322223fo_ster_
fosters104220103fo_sters
hoister103714203hoister_
hoisters113513483hoisters
holster103512213holster_
holsters113211943holsters
honester1139713honester_
jouster143311043jouster_
jousters153210423jousters
lobster9288853lobster_
lobsters10268743lobsters
mantra84116093man_t_ra
master84831343m_aster_
masters94628923m_asters
mastery124214323m_astery
meister93114163meister_
meisters103313843meisters
menstrua1044023menstrua
menswear1352183menswear
minister10410363minister_
ministers1139623ministers
minstrel1046913minstrel
minter84425103min_ter_
minters93822473min_ters
minuter93510413minuter_
mister84728563m_ister_
misterm114314513m_isterm
misters93927513m_isters
modester1197483modester_
moisten93110143moiste_n
moistens10268773moistens
moistest1038763moistest
moisture1046653moisture
molester1099373molester_
molesters1198873molesters
molter84119423mo_lter_
molters93816973mo_lters
momser104011413moms_er_
momsers113810843moms_ers
moneran9311113mon__eran
monetary1346523monetary
moneyer1237903moneyer_
moneyers1337423moneyers
monger94418333mon_ger_
mongers104217273mon_gers
moniker1338673moniker_
monikers1437413monikers
monitor9310723monitor_
monitors10310823monitors
monitory1347853monitory
monkery16317453mon_kery
monoester1146453monoester_
monoesters1245993monoesters
monogerm1345963monogerm
monomer11311893monomer_
monomers12311033monomers
monostele1145333monostele
monostely1444813monostely
monsieur1043313monsieur
monte75829773mon_te__
monteros1039453mon_teros
montes84226933mon_te_s
mooter83921093mo_oter_
mooters93818623mo_oters
mosher114719793mo_sher_
moshers124017843mo_shers
mosser84618273mo_sser_
mossers94116193mo_ssers
mossier94413813mossier_
moste75925083mo_ste__
mostest9314793mo_stest
moulter93812423moulter_
moulters103510783moulters
mounter93713173mounter_
mounters103712503mounters
mouser85822443mous_er_
mousers95216443mous_ers
mousetrap1352423mousetrap
mousier93712463mousier_
muenster1043313muenster_
muensters1143253muensters
muster84724523m_uster_
musters94522513m_usters
mystery15436523m_ystery
nonstory1148103nonstory
onstream1045113_onstream
osetra667423_o_setra
ossetra744073_ossetra
ouster64223733_ouster_
ousters74122793_ousters
oyster94111703_oyster_
oysters103411693_oysters
penster92811953penster_
pensters103012123pensters
poster84129173po_ster_
postern93615613po_stern
posters93928013po_sters
punster92911103punster_
punsters103310583punsters
roaster74116663roaster_
roasters83615933roasters
roister73516203roister_
roisters83615553roisters
rooster74415173rooster_
roosters83514663roosters
roster64329083ro_ster_
rosters73727543ro_sters
rostra6310933ro_st_ra
rouster73517083rouster_
rousters84315683rousters
royster103110533royster_
roysters113610533roysters
santera7311303san_tera
songster935793songster_
songsters1046113songsters
sonsier7711743sonsier_
toaster74414463toaster_
toasters83912723toasters
zoster153715853zo_ster_
zosters163015413zo_sters

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.596299817.1
2DLD Change Limit1461621456.34323043.0
3Display Results1451450.0602416.7
 (SQL Overall)1786911456.99925530.9
 
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.