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

121 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
manropes123791(None) 
manrope1138031manrope_
madrones112912282madrones
mangoes104316132mango_es
mangroves1574292mangroves
manholes13311182manholes
mannoses1039082mannoses
aerobes9311493_aerobes
amarones10311353amarones
amauroses1144473amauroses
amniotes1036603amniotes
ancones93116343_ancones
anodes74418763_an_odes
anoles64827433_an_oles
apropos1138843_apropos
bandores11311603bandores
banjoes16317313banjo_es
canapes111213083can_apes
canoes84725883can_o_es
canopies12311853can_opies
canzones1939153canzones
dragropes1343353dragropes
enrobes92211113_enrobes
gantlopes1244283gantlopes
garotes8614563ga_rotes
garrotes969363garrotes
gropes95220403__gropes
ladrones92710973ladrones
macrames1438953macrames
macrons113514893macro_ns
macros104017013macro__s
madrases112610003madrases
madres93718183madr__es
madronas11288493madronas
madrone102812663madrone_
madronos11337543madronos
mahoes11313103ma_ho_es
maintops1244403maintop_s
maltoses1039863maltoses
mamboes135011823mambo_es
manacles1239523manacles
manages103418963man_ages
manatees10310423manatees
manches143818623man_ches
manciples1564793manciples
mandates11314093mandates
mandolas1139133mandolas
mandrakes1646353mandrakes
maneges103612143man_eges
manes76648963man___es
manges94628943man__ges
mangles104021463man_gles
mangolds1235193mangolds
mangonel1185763mangonel
mangonels1294373mangonels
mangos94319333mango__s
mangrove1474403mangrove_
manhole12311343manhole_
manhoods1447243manhoods
manilles102312603manilles
maniocas12298473maniocas
maniocs113611443manio_cs
maniples12269423maniples
mannites10312613mannites
mannose939243mannose_
manors84420883man_o_rs
manos74933623man_o__s
manpower1544703manpower
manpowers1644463manpowers
manses84225513man__ses
mantes84430783man__tes
mantises10317923mantises
mantles94820703man_tles
mantraps12298063mantrap_s
manures9313353man_ures
marbles114516653ma_rbles
marches143921173ma_rches
mares76457633ma_r__es
marges94525713ma_r_ges
marines93928013ma_rines
maroons92615553ma_roons
marques182610863ma_rques
marries93825283ma_rries
marrons93216973marro_ns
marrowed1445973marrowed
marrows122911823marro_ws
marses84827113ma_r_ses
marshes123615373ma_rshes
matres84522233matr__es
matrices12312083matrices
matrixes1738063matrixes
matrons93517633matro_ns
maypoles1545993maypoles
maypops16104453maypop_s
metopes11311363m_etopes
microbes1439403microbes
mongoes103415713mongo_es
mopes95134983m___opes
mucrones1237603mucrones
mungoes103510463mungo_es
myopes13419963m__yopes
padrones112711043padrones
pandores11312453pandores
panpipes1135173panpipes
paroles95025883pa_roles
pyropes142210193_pyropes
ropes75940063___ropes
safroles1136933safroles
sannops936693sannop_s
saprobes1237033saprobes
sapropel1244643sapropel
sapropels1343643sapropels
sarapes94617753sa_rapes
sarodes84216143sa_rodes
saroses73619333sa_roses
stanhopes1444463stanhopes
syncopes1545763syncopes
towropes1344953towropes
tropes84824353__tropes
unrobes9269733_unrobes
unroped102812103_unroped

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.420425454.8
2DLD Change Limit1461621217.29620033.2
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.76223021.3
 
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.