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

202 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
madrones11291228(None) 
ladrones92710981ladrones
madronas11288491madronas
madrone102812661madrone_
madronos11337541madronos
padrones112711041padrones
amarones10311352amarones
drones75023432__drones
hadrons113314302hadron_s
ladrone83611882ladrone_
ladrons83813192ladron_s
macrons113514892macron_s
madrases112610002madrases
madres93718182madr__es
madrona10288702madron_a
madrono10288742madron_o
manropes1237912manropes
marines93928022ma_rines
marrons93216972marron_s
matrons93517632matron_s
mucrones1237602mucrones
padrone102512072padrone_
adobes94411533_ad_obes
adonis7314063_ad_onis
adores74420723_ad_ores
adorned9256893_adorned
adorner8246983_adorner
adorners9196623_adorners
adorns74212613_adorn_s
aerobes9311493_aerobes
agones75719863_a_gones
amarone9311203amarone_
amauroses1144473amauroses
ambones11312683_ambones
amidones11348663amidones
ancones93116343_ancones
aproned10311503_aproned
aprons8316993_apron_s
arenes64928393_a_renes
atones65225773_a_tones
axones134614513_a_xones
baroness101210063ba_roness
baronet91022213ba_ronet
baronets101410913ba_ronets
barongs105310833ba_rongs
baronies10315023ba_ronies
baronnes1038553ba_ronnes
barons85025383ba_ron_s
baudrons1135763baudron_s
baudronses1341983baudronses
cadres94017933cadr__es
cajones163311333ca_jones
caldrons1138063caldron_s
calzones1948763calzones
canzones1939153canzones
cardons104519943cardon_s
crones84729243__crones
dacrons103211033dacron_s
dadoes85616533dad_o_es
daemones11209163daemones
daimones11208803daimones
dapsones1138383dapsones
drone65324983__drone_
droned84616863__droned
droner74717673__droner
droners84114383__droners
droves105116673__droves
estrones8313333estrones
gadrooned1243403gadrooned
gadroons1037013gadroons
garotes8614573ga_rotes
garrons82713463garron_s
garrotes969383garrotes
hadron102913753hadron__
hadronic1447953hadronic
hambones1539673hambones
hidroses1237903hidroses
irones64724013__irones
jawbones20134853jawbones
lactones10311243lactones
ladron73413323ladron__
lardons83914493lardon_s
latrines8515013latrines
macaronies1446173macaronies
macaronis1346563macaronis
machines15312893machines
macons104017243ma_con_s
macrames1438953macrames
macron103615673macron__
macros104017013macro__s
madames12310063mad_ames
maddened1334893maddened
maddens11359753madden_s
maderizes2148953maderizes
madhouse1445503madhouse
madhouses1545743madhouses
madness10310073mad__ness
madonna1044403mad_onna
madonnas1143843madonnas
madras94316433madr__as
madrasas11317763madrasas
madre85720173madr__e_
madrepores1552573madrepores
madrilenes1343483madrilenes
madtoms1236923madto_ms
maduros1036303maduro__s
madwomen1644793madwomen
madworts1456173madworts
madzoons20124773madzoons
mahjongs2141813mahjongs
mahoes11313103ma_ho_es
malines93625613ma_lines
maltoses1039863maltoses
mamboes135011823mambo_es
mammons1048513mammon_s
mandrakes1646353mandrakes
manes76648963ma___nes
mangoes104316133mango_es
mangonel1185763mangonel
mangonels1294373mangonels
mangroves1574293mangroves
manholes13311183manholes
mannoses1039083mannoses
manrope1138033manrope_
marbles114516653ma_rbles
marches143921173ma_rches
mares76457633ma_r__es
marges94525713ma_r_ges
marinas93519393ma_rinas
marine84230413ma_rine_
mariner93316003ma_riner
mariners103113863ma_riners
marlines103818733marlines
marooned1138563marooned
maroons92615553ma_roons
marques182610863ma_rques
marranos1038423marranos
marries93825283ma_rries
marron83717543marron__
marrowed1445993marrowed
marrows122911833marro_ws
marses84827113ma_r_ses
marshes123615373ma_rshes
martens93714953ma_rtens
mascons113411583mascon_s
masoned1039803ma_soned
masons83916513ma_son_s
matres84522233matr__es
matrices12312083matrices
matrixes1738063matrixes
matron83918313matron__
matronal1048113matronal
matronizes2196843matronizes
matronly1344783matronly
maypoles1545993maypoles
menadiones1343783menadiones
microbes1439403microbes
microns113814783micron_s
midirons1145883midiron_s
midlines112613333midlines
midranges1344653midranges
midsoles1137763midsoles
mikrons13428413mikron_s
modernes1138423modernes
morons84919543m_oron_s
mudholes1444873mudholes
mudrocks1743993mudrocks
mudrooms1344083mudrooms
mudstones1245033mudstones
murines93718223m_urines
natrons73215663natron_s
neurones839683neurones
padres95016983padr__es
padroni10278613padron_i
padronism1445503padronism
pardoned12189333pardoned
pardoner11189443pardoner
pardoners12208213pardoners
pardons103817623pardon_s
paroles95025883pa_roles
patroness1137493patroness
patrons93818103patron_s
pyrones123113303_pyrones
radomes10311053rad_omes
radons74118533rad_on_s
redbones1137593redbones
sadirons936033sadiron_s
safroles1136933safroles
saprobes1237033saprobes
sardines92815573sardines
sarodes84216143sa_rodes
sarongs84511803sa_rongs
saroses73619333sa_roses
sawbones13126643sawbones
seadromes1246103seadromes
spadones1137253spad_ones
tacrines10310563tacrines
tadpoles1135953tadpoles
taurines8310553taurines
thrones105715843_thrones
trones65629283__trones
wardrobes1583803wardrobes

Search took 10 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 Limit1461622028.55017095.0
3Display Results2022020.0762657.9
 (SQL Overall)1786912029.04619753.6
 
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.