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 “monarda” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
monarda104661(None) 
monardas1145711monardas
mojarra1642512mojarra
monad85519472mona_d_
monadal1047892mona_dal
monads94515302mona_ds
monarch1445952monarch
board85523003bo_ard_
boards94616933bo_ards
bonanza1843843bonanza
boyard125411283boyard_
boyards13399323boyards
canard9314763canard_
canards10311203canards
contra83314703contr_a
coward12411673coward_
cowards1339613cowards
dotard839053dotard_
dotards937253dotards
garda7316763__garda
gonad75216053gona_d_
gonadal956523gona_dal
gonads84511733gona_ds
hoard94918313ho_ard_
hoards104912623ho_ards
holard10410573holard_
holards1148433holards
honda9414983hon__da
innards837153innards
kinara10310373kinar_a
malaria9313703malaria
manana84816073mana_na
mansard1049313mansard_
mansards1148013mansards
mantra84116093mantr_a
manward1349093manward_
manwards1447613manwards
mara67444573m__ar_a
maria75032883m__aria
marka114620793m__arka
mazard1838763mazard_
mazards1937703mazards
megara9310093megar_a
menad85918983mena_d_
menads95514383mena_ds
minaret9520683minaret
minorca1145223minorca
moaned94514173moaned_
moira71012023mo_ir_a
mojarras1742253mojarras
molar75223093molar__
molars85517323molar_s
monachal1545703monachal
monacid121310243monacid
monacids13137513monacids
monades103713823monades
monadic1268883monadic
monandry1443233monandry
monarchal1643973monarchal
monarchs1544833monarchs
monarchy1843603monarchy
monas74732153mona__s
monaural1046213monaural
monaxial1745963monaxial
monaxon1644913monaxon
monde85723143mon__de
mondo85721233mon__do
moneran9311113moneran
mongrel1036333mongrel
monied94319463monied_
monody1238243mon_ody
monuron937463monuron
moonward1474473moonward_
moonwards1574203moonwards
mora66641273mo__r_a
myocardia1752853myocardia
nada58022903__na_da
nard56634453__nard_
nards65928463__nards
nonart6319193nonar_t
nonarts7311303nonarts
nonhardy1544333nonhardy
onward1039053_onward_
onwards1137173_onwards
panada94113053pana_da
poniard1037583poniard_
poniards1145823poniards
posada937163posa_da
rosaria749253rosaria
solaria7312493solaria
sonar56523423sonar__
sonarman1045563sonarman
sonars64818973sonar_s
sonata6313223sona_ta
toward10311063toward_
towards1138783towards
zenaida17914783zenaida
zoaria1548383zo_aria
zonary1838793zonar_y

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.406440125.6
2DLD Change Limit134027996.84319586.0
3Display Results99990.0333000.0
 (SQL Overall)178691997.28224538.7
 
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.