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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
monsoons104734(None) 
monsoon938491monsoon_
gossoons944892gossoons
mansions1069792mansions
monaxons1744812monaxons
monsoonal1144052monsoonal
monurons1037092monurons
pontoons10279312pontoons
bassoons1036553bassoons
bolsons969483bols_ons
bonbons1139333bon_bons
bosons85016653bo_s_ons
bostons9312903bo_stons
cocoons11310563co_coons
conjoins1738133conjoins
consigns1137533consigns
consoles103216153consoles
consols92914073cons_ols
consorts101512343consorts
dobsons1036203dobs_ons
donjons1536733don_jons
eftsoons1142613eftsoons
foisons1047613fois_ons
godroons1045363godroons
godsons966663gods_ons
gossoon865663gossoon_
johnsons1842383johns_ons
madzoons20124773madzoons
manhoods1447243manhoods
mansion9611543mansion_
maroons92615553m_aroons
mascons113411583m_ascons
masons83916513m_as_ons
matzoons19105083matzoons
menazons1945733menazons
mentions10312893mentions
mesons83215843m_es_ons
midnoons1144403midnoons
minions93314623min_ions
missions10311903missions
moistens10268773moistens
monaxon1644913monaxon_
mondos95217333mon_do_s
monerans10310353monerans
mongoes103415713mon_goes
mongols103310823mon_gols
mongoose1175353mongoose
mongooses1285603mongooses
mongos94318623mon_go_s
monitions11310883monitions
monitors10310823monitors
monkhoods1984353monkhoods
monkshoods2082333monkshoods
monocots1249813monocots
monologs112210533monologs
monopods1347973monopods
monos75930863mon__o_s
monosome1299403monosome
monosomes1399403monosomes
monosomy1586313monosomy
monotone10310153monotone
monotones11410553monotones
monotony1347073monotony
monsters103314553monsters
monstrous1187353monstrous
monuron937463monuron_
moonroofs1443253moonroofs
moons75331003m___oons
moonshots1444283moonshots
moonstone1146143moonstone
moonstones1246053moonstones
morions94014643mo_rions
morons84919543mo__rons
morrions1077673morrions
motions94215003mo_tions
mouflons13133653mouflons
moutons9410313mo_utons
munnions1035273munnions
nonagons947223nonagons
nonbooks1446123nonbooks
nonstops10116883nonstops
noons54125283__n_oons
onions64016433_on_ions
pensions10311693pensions
pocosons1266103pocosons
poisons9310353pois_ons
pontons93315553pon_tons
pontoon93010703pontoon_
rockoons1445003rockoons
ronions73313343ron_ions
ronyons10258433ron_yons
sonhoods1247083sonhoods
sponsions1145223sponsions
sponsons1045813spons_ons
spontoons1153403spontoons
tensions8310223tensions
torsions839183torsions
wontons103310533won_tons

Search took 7 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.420425454.8
2DLD Change Limit146162986.40622816.4
3Display Results98980.0462130.4
 (SQL Overall)178691986.87226002.8
 
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.