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

111 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
monsoon93849(None) 
monsoons1047341monsoons
gossoon865662gossoon
mansion9611542mansion
monaxon1644912monaxon
monsoonal1144052monsoonal
monuron937462monuron
pontoon93010702pontoon
bassoon937613bassoon
bolson8410683bols_on
bonbon10310073bon_bon
boson76019733bo_s_on
boston8513043bo_ston
cocoon10312263co_coon
conjoin1638203conjoin
consign1038773consign
consol82614113cons_ol
console92715983console
consols92914073consols
consort91319903consort
dobson936593dobs_on
donjon1436463don_jon
eftsoon1043253eftsoon
foison948933fois_on
forsook1446003forsook
godroon946043godroon
godson857383gods_on
gonion73612833gon_ion
gossoons944893gossoons
johnson1742333johns_on
madzoon1996063madzoon
manhood1338993manhood
mansions1069793mansions
maroon83118203m_aroon
mascon103612743m_ascon
mason74820183m_as_on
matzoon1896473matzoon
menazon1846053menazon
menshen1236813menshen
mention9314373mention
meson74118313m_es_on
midnoon1044683midnoon
minion83416243min_ion
mission9312743mission
moisten93110143moisten
monaxons1744813monaxons
mondo85721233mon_do_
mondos95217333mon_dos
moneran9311113moneran
mongo810122413mon_go_
mongoe94214983mon_goe
mongoes103415713mongoes
mongol94912533mon_gol
mongols103310823mongols
mongoose1175353mongoose
mongos94318623mon_gos
monition10311723monition
monitor9310723monitor
monkhood1884993monkhood
monkshood1982853monkshood
mono66036723mon__o_
monocot11412013monocot
monody1238243mon_ody
monolog10259353monolog
monopod1247493monopod
monos75930863mon__os
monosome1299403monosome
monosomy1586313monosomy
monotone10310153monotone
monotony1347073monotony
mons68152263mons___
monster93214603monster
monurons1037093monurons
moon67140813m___oon
moonroof1344543moonroof
moonshot1346283moonshot
moonstone1146143moonstone
morion86217733mo_rion
moron76925423mo__ron
morrion959003morrion
mosso74715183mo_sso_
motion85217553mo_tion
mouflon12104083mouflon
mouton8410853mo_uton
munnion935863munnion
nonagon847313nonagon
nonbook1346283nonbook
nonfood1156653nonfood
noniron738373noniron
nonpoor956483nonpoor
nonstop9106923nonstop
nonwool1046673nonwool
noon47134623__n_oon
onion54320973_on_ion
pension9412203pension
pocoson1156753pocoson
poison8312223pois_on
ponton83217643pon_ton
pontoons10279313pontoons
rockoon1345653rockoon
ronion63315643ron_ion
ronyon9309133ron_yon
sonhood1168313sonhood
soon46240503___soon
sponsion1045623sponsion
sponson935383spons_on
spontoon1043783spontoon
tension7311803tension
torsion7310803torsion
unsown9328433_unsown
wonton93410963won_ton

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271115.87622809.2
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.34228175.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.