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

229 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
madrone10281266(None) 
ladrone83611871ladrone
madrona10288701madrona
madrones112912281madrones
madrono10288741madrono
padrone102512071padrone
amarone9311202amarone
drone65324982__drone
hadron102913752hadron_
hadrons113314302hadrons
ladron73413322ladron_
ladrones92710972ladrones
ladrons83813192ladrons
macron103615672macron_
macrons113514892macrons
madre85720172madr__e
madronas11288492madronas
madronos11337542madronos
manrope1138032manrope
marine84230402ma_rine
marron83717542marron_
marrons93216972marrons
matron83918312matron_
matrons93517632matrons
padrones112711042padrones
padroni10278612padroni
adobe84814713_ad_obe
adore65723673_ad_ore
adorn64917093_adorn_
adorned9256893_adorned
adorner8246983_adorner
adorns74212613_adorns
adoze155713833_ad_oze
adroit7518793_adroit
aerobe8412403_aerobe
agone65924553_a_gone
alone55732963_a_lone
amarones10311353amarones
amidone10349313amidone
ancone83916953_ancone
anyone94612733_anyone
apron7318833_apron_
aproned10311503_aproned
aprons8316993_aprons
arene55329413_a_rene
arose55832083_a_rose
atone56527983_a_tone
axone125918473_a_xone
baron78131243ba_ron_
baronet91022203ba_ronet
barong96015823ba_rong
baronne938263ba_ronne
barons85025383ba_rons
barony115915303ba_rony
baudrons1135763baudrons
cadre85419023cadr__e
caldron1038153caldron_
caldrons1138063caldrons
calzone1848623calzone
canzone1858813canzone
caprine11314233caprine
cardon94120853cardon_
cardons104519943cardons
codrove1336423codrove
crone75231333__crone
dacron94310693dacron_
dacrons103211033dacrons
dapsone1038463dapsone
done55747913__d_one
droned84616863__droned
droner74717673__droner
drones75023433__drones
drove95518063__drove
estrone7413953estrone
fordone1149383fordone
gadarene1043993gadarene
gadroon938173gadroon
gadrooned1243403gadrooned
gadroons1037013gadroons
garote7717953ga_rote
garron73113493garron_
garrons82713463garrons
garrote8510103garrote
hadronic1447953hadronic
hagrode1236443hagrode
hambone1439313hambone
irone55126363__irone
jawbone19134443jawbone
krone94018733__krone
lactone9311413lactone
lardon74415063lardon_
lardons83914493lardons
larine63927043la_rine
latrine7715133latrine
macaroni1246523macaroni
machine14313493machine
macon94519953ma_con_
macons104017243ma_cons
macrame1338713macrame
macro94718173macro__
macros104017013macro_s
madame1139853mad_ame
madden103912523madden_
maddened1334893maddened
maddens11359753maddens
madding123711993madding
made75440243mad___e
maderize2049073maderize
madhouse1445503madhouse
madman113712383madman_
madmen113511743madmen_
madonna1044403madonna
madras94316433madr_as
madrasa10387883madrasa
madrases112610003madrases
madrepore1452623madrepore
madres93718183madr_es
madrilene1243663madrilene
madtom1138023madto_m
madtoms1236923madtoms
maduro936983maduro__
maduros1036303maduro_s
madwomen1644793madwomen
madwort13611363madwort
madzoon1996063madzoon
madzoons20124773madzoons
mahjong2042273mahjong
mahoe10315573ma_ho_e
maline84529083ma_line
maltose939793maltose
mammon939643mammon_
mammons1048513mammons
mandrake1546003mandrake
mane65052033ma___ne
mangonel1185763mangonel
mangrove1474403mangrove
manhole12311343manhole
mannose939243mannose
manropes1237913manropes
marble104219103ma_rble
mare64759333ma_r__e
marge85328333ma_r_ge
marina84623413ma_rina
mariner93315993ma_riner
marines93928013ma_rines
marline93320953marline
maroon83118203ma_roon
marooned1138563marooned
maroons92615553maroons
marque172410503ma_rque
marrano939423marrano
marring103319553marring
marrow112812603marro_w
marrowed1445973marrowed
marrows122911823marrows
marrowy15236083marrowy
marse76231153ma_r_se
marten84518263ma_rten
mascon103612743mascon_
mascons113411583mascons
mason74820183ma_son_
masoned1039803ma_soned
masons83916513ma_sons
matronal1048113matronal
matronize2067183matronize
matronly1344783matronly
maypole1446383maypole
menadione1243783menadione
microbe1338663microbe
micron103714283micron_
microns113814783microns
midiron1046003midiron_
midirons1145883midirons
midline102315103midline
midrange1244433midrange
midsole1037813midsole
mikron12318503mikron_
mikrons13428413mikrons
misdone10310863misdone
misdrove1445433misdrove
moderne1037123moderne
moron76925423m_oron_
morons84919543m_orons
morose85116243m_orose
mucrones1237603mucrones
mudhole1344913mudhole
mudrock1644353mudrock
mudroom1244953mudroom
mudstone1145553mudstone
murine84220023m_urine
murrine9411483murrine
nardine82712573nardine
narine63422553na_rine
natron64116023natron_
natrons73215663natrons
neurone739433neurone
padre86018163padr__e
pardine103616723pardine
pardon94618733pardon_
pardoned12189333pardoned
pardoner11189443pardoner
pardons103817623pardons
parole84425253pa_role
patron84018043patron_
patrons93818103patrons
prone75332623__prone
pyrone112714473_pyrone
radome9511873rad_ome
radon64620503rad_on_
radons74118533rad_ons
redbone1037973redbone
redone74820053red_one
redrove11249423redrove
sadiron836043sadiron_
sadirons936023sadirons
safrole1037253safrole
saprobe1137333saprobe
sardine83317393sardine
sarode75317513sa_rode
sarong73914873sa_rong
seadrome1146513seadrome
tacrine9311293tacrine
tadpole1036143tadpole
taurine7311363taurine
throne98517603_throne
trone55131863__trone
undone7914253und_one
vadose1037963vad_ose
wardrobe1464133wardrobe

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272296.69020033.9
3Display Results2292290.0763013.2
 (SQL Overall)1786912297.16924925.5
 
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.