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

132 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
madrono1028874(None) 
madrona10288701madrona
madrone102812661madrone
madronos11337541madronos
gadroon938172gadroon
hadron102913752hadron_
hadrons113314302hadrons
ladron73413322ladron_
ladrone83611872ladrone
ladrons83813192ladrons
macron103615672macron_
macrons113514892macrons
madronas11288492madronas
madrones112912282madrones
madzoon1996062madzoon
maroon83118202ma_roon
marrano939422marrano
marron83717542marron_
marrons93216972marrons
matron83918312matron_
matrons93517632matrons
padrone102512072padrone
padroni10278612padroni
adobo84711593_ad_obo
adorn64917093_adorn_
adorns74212613_adorns
adroit7518793_adroit
amarone9311203amarone
ammono1047373_ammono
amorino9310253amorino
amoroso946093amoroso
apron7318833_apron_
aprons8316993_aprons
arroyo936963_arroyo
baron78131243ba_ron_
barong96015823ba_rong
barons85025383ba_rons
barony115915303ba_rony
baudrons1135763baudrons
caldron1038153caldron_
caldrons1138063caldrons
cardon94120853cardon_
cardons104519933cardons
cardoon104813813cardoon
dacron94310693dacron_
dacrons103211033dacrons
drone65324983__drone
drongo836793__drongo
gadroons1037013gadroons
garron73113493garron_
garrons82713463garrons
godroon946043godroon
hadronic1447953hadronic
karoo92519583ka_ro_o
karroo10410013karro_o
ladino73615123lad_ino
ladrones92710973ladrones
lardon74415063lardon_
lardons83914493lardons
lardoon83410373lardoon
macaroni1246523macaroni
macaroon1246343macaroon
macon94519953ma_con_
macons104017243ma_cons
macro94718173macr__o
macros104017013macro_s
madden103912523madden_
maddens11359753maddens
madding123711993madding
madman113712383madman_
madmen113511743madmen_
madonna1044403madonna
madras94316433madr_as
madrasa10387883madrasa
madre85720173madr__e
madres93718183madr_es
madtom1138023madto_m
madtoms1236923madtoms
maduro936983mad_uro
maduros1036303maduro_s
madwort13611363madwort
madzoons20124773madzoons
mafioso1244453mafioso
mahjong2042273mahjong
makimono1641943makimono
mammon939643mammon_
mammons1048513mammons
mano66536803ma___no
manrope1138033manrope
marengo1035263ma_rengo
marina84623413ma_rina
marine84230403ma_rine
maroons92615553maroons
marranos1038423marranos
marring103319553marring
marrow112812603marro_w
marrows122911823marrows
marrowy15236083marrowy
mascon103612743mascon_
mascons113411583mascons
mason74820183ma_son_
masons83916513ma_sons
matronal1048113matronal
matronly1344783matronly
matzoon1896473matzoon
merino8315093m_erino
micron103714283micron_
microns113814783microns
midiron1046003midiron_
midirons1145883midirons
midnoon1044683midnoon
mikron12318503mikron_
mikrons13428413mikrons
mono66036713m___ono
moron76925423m_oron_
morons84919543m_orons
mudrock1644353mudrock
mudroom1244953mudroom
natron64116023natron_
natrons73215663natrons
padrones112711043padrones
pardon94618733pardon_
pardons103817623pardons
patron84018043patron_
patrons93818103patrons
patroon92811973patroon
quadroon1844473quadroon
radon64620503rad_on_
radons74118533rad_ons
sadiron836043sadiron_
sadirons936023sadirons
sarong73914873sa_rong

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.1561145455.1
2DLD Change Limit1340271327.67317467.4
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.87522690.9
 
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.