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

151 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
madrona1028870(None) 
madronas11288491madronas
madrone102812661madrone
madrono10288741madrono
hadron102913752hadron_
hadrons113314302hadrons
ladron73413322ladron_
ladrone83611872ladrone
ladrons83813192ladrons
macron103615672macron_
macrons113514892macrons
madonna1044402madonna
madrasa10387882madrasa
madrones112912282madrones
madronos11337542madronos
marina84623412ma_rina
marron83717542marron_
marrons93216972marrons
matron83918312matron_
matronal1048112matronal
matrons93517632matrons
padrone102512072padrone
padroni10278612padroni
adorn64917093_adorn_
adorns74212613_adorns
adrenal838263_adrenal
adroit7518793_adroit
amarna839793amar_na
amarone9311203amarone
annona648873_annona
apron7318833_apron_
aprons8316993_aprons
arena55323813_a_rena
aroma71220143_a_roma
arroba898663_arroba
aurora6411763_aurora
baron78131243ba_ron_
barong96015823ba_rong
barons85025383ba_rons
barony115915303ba_rony
baudrons1135763baudrons
caldron1038153caldron_
caldrons1138063caldrons
canzona1836073canzona
cardon94120853cardon_
cardons104519933cardons
carina84325323ca_rina
corona83817403_corona
dacron94310693dacron_
dacrons103211033dacrons
dona55529633__d_ona
drone65324983__drone
farina94618233fa_rina
gadroon938173gadroon
gadroons1037013gadroons
garron73113493garron_
garrons82713463garrons
hadronic1447953hadronic
jarina134014063ja_rina
krona93611793__krona
ladrones92710973ladrones
lardon74415063lardon_
lardons83914493lardons
macaroni1246523macaroni
macon94519953ma_con_
macons104017243ma_cons
macro94718173macro__
macros104017013macro_s
madden103912523madden_
maddens11359753maddens
madding123711993madding
madeira1045103madeira
madman113712383madman_
madmen113511743madmen_
madonnas1143843madonnas
madras94316433madr_as
madrasah14324783madrasah
madrasas11317763madrasas
madrassa11274633madrassa
madre85720173madr__e
madres93718183madr_es
madrigal121627253madrigal
madtom1138023madto_m
madtoms1236923madtoms
maduro936983maduro__
maduros1036303maduro_s
madwoman1643693madwoman
madwort13611363madwort
madzoon1996063madzoon
madzoons20124773madzoons
mahjong2042273mahjong
mahonia1238443ma_honia
malaroma1245583malaroma
mammon939643mammon_
mammons1048513mammons
mana65341963ma___na
manana84816073ma_nana
mandioca1354113mandioca
mandola1039023mandola
manioca11358943manioca
manna75522543ma__nna
manrope1138033manrope
mara67444573ma_r__a
maraca10314153ma_raca
maranta9311693ma_ranta
maria75032883ma_r_ia
marinas93519383ma_rinas
marine84230403ma_rine
marka114620793ma_r_ka
markka11416593ma_rkka
maroon83118203ma_roon
maroons92615553maroons
marrano939423marrano
marring103319553marring
marrow112812603marro_w
marrows122911823marrows
marrowy15236083marrowy
mascon103612743mascon_
mascons113411583mascons
mason74820183ma_son_
masons83916513ma_sons
matronly1344783matronly
medina94114093med_ina
micron103714283micron_
microns113814783microns
midiron1046003midiron_
midirons1145883midirons
mikron12318503mikron_
mikrons13428413mikrons
moron76925423m_oron_
morons84919543m_orons
mudra83912433mudr__a
mudrock1644353mudrock
mudroom1244953mudroom
natron64116023natron_
natrons73215663natrons
padrones112711043padrones
pardon94618733pardon_
pardons103817623pardons
patron84018043patron_
patronal1048653patronal
patrons93818103patrons
radon64620503rad_on_
radons74118533rad_ons
ramona8412413ra_mona
sadiron836043sadiron_
sadirons936023sadirons
sardana838643sardana
sarong73914873sa_rong
trona54118953__trona
varna84516173va_r_na

Search took 7 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 Limit1340271516.43620824.6
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.65526850.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.