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

113 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
mucrones123760(None) 
crones84729242__crones
macrons113514892macron_s
madrones112912282madrones
microbes1439402microbes
microns113814782micron_s
murines93718222mu_rines
sucroses1039942sucroses
amarones10311353amarones
ancones93116343anc_ones
bicornes12307253bicornes
bicrons113410473bicron_s
buckoes153810393bucko_es
cicerones1347083cicerones
clones84526563__clones
cones76457423__c_ones
cranes84330753__cranes
crone75231333__crone_
cronies9622513__cronies
crores86121163__crores
crozes174417663__crozes
cyclones1537483cyclones
dacrons103211033dacron_s
drones75023433__drones
duotones937643duotones
estrones8313333estrones
eucaines1038513eucaines
eucrites1049483eucrites
fucoses12148303fuc_oses
furanes103214863fu_ranes
furores10310033fu_rores
icones84616383_ic_ones
irones64724013__irones
lactones10311243lactones
ladrones92710983ladrones
lucarnes1045093lucarnes
lucernes1046363lucernes
lucres84513303lucr__es
macaronies1446173macaronies
macaronis1346563macaronis
machines15312893machines
macons104017243mac_on_s
macrames1438953macrames
macron103615673macron__
macros104017013macro__s
madronas11288493madronas
madrone102812663madrone_
madronos11337543madronos
manropes1237913manropes
marines93928033m_arines
marrons93216973marron_s
matrons93517633matron_s
microbe1338663microbe_
microbus1456033microbus
microhms1765613microhms
micron103714283micron__
micronizes2349003micronizes
micros104115363micro__s
microtones1449803microtones
mikrons13428413mikron_s
morons84919543m_oron_s
muches134718993muc__hes
muchness1534073muc_hness
mucinous1245373mucinous
mucins102712513muc_in_s
muckles153413253muc_kles
muckrakes1642743muckrakes
mucoids1237423muc_oids
mucors104410853muc_o_rs
mucosas11146683muc_osas
mucose10149313muc_ose_
mucous104411653muc_o_us
mucro94513723mucro___
mucronate1346233mucronate
mucuses11148513muc_uses
mudholes1444873mudholes
mudrocks1743993mudrocks
mudrooms1344083mudrooms
mudstones1245033mudstones
mungoes103510463mungo_es
muons75816173mu__on_s
mures75937223mu_r__es
murexes1636973mu_rexes
murices112612283mu_rices
murine84220023mu_rine_
murres85019043mu_r_res
murries94118673mu_rries
murrine9411483murrine_
muscarines1445393muscarines
mutines93117823mu_tines
mutons84314363mu_ton_s
muttons949283mutton_s
mycoses1437733myc_oses
necroses10310573necroses
neurones839683neurones
omicrons1275193omicron_s
padrones112711043padrones
purines94420773pu_rines
pyrones123113303_pyrones
quinones17227753quinones
scones84521303_sc_ones
subtones10311383subtones
subzones1947223subzones
sucrases10310253sucrases
sucres84218893sucr__es
sucrose939313sucrose_
sulfones1147683sulfones
tacrines10310563tacrines
thrones105715843_thrones
trones65629283__trones
umbones1138013_umbones
unrobes9269733_unrobes
urines64724123_u_rines

Search took 9 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 Limit1461621137.84618628.9
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.31221498.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.