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 “monarch” 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
monarch144595(None) 
monarchs1544831monarchs
monarchy1843601monarchy
anarch11310392_anarch
inarch1139172_inarch
march125622892m__arch
menarche1545812menarche
mesarch1445532mesarch
monarchal1643972monarchal
monarchic1844952monarchic
monarda1046612monarda
nomarch1445352nomarch
omniarch1562722omniarch
anarchs1237093_anarchs
anarchy1544933_anarchy
arch98628443___arch
autarch1246623autarch
bonaci10310963bona_ci
coach125919453co_a_ch
conch124620073con__ch
endarch1345443endarch
eparch13258423_eparch
ethnarch1642413ethnarch
exarch18196173_exarch
gynarchy2042103gynarchy
larch105919793__larch
loach105116363lo_a_ch
mach116134483m__a_ch
marc87034633m__arc_
marcs95726623m__arcs
marsh105320853m__arsh
match125621103m__atch
menace103216943mena_ce
menarches1646683menarches
menorah1247933menorah
mensch13387093men_sch
merch125417963m__erch
minaret9520683minaret
minorca1145223minorca
mojarra1642513mojarra
molar75223093molar__
molars85517323molar_s
moloch1356483mo_loch
monachal1545693mona_chal
monacid121310243monacid
monad85519473mona__d
monadal1047893monadal
monades103713823monades
monadic1268883monadic
monads94515303mona_ds
monarchial1754053monarchial
monarchies1745373monarchies
monarchism1954023monarchism
monarchist1755243monarchist
monardas1145713monardas
monas74732153mona__s
monaural1046213monaural
monaxon1644913monaxon
moneran9311113moneran
mongrel1036333mongrel
monish114217593mon_ish
monkish1638243monkish
monoecy1445083monoecy
monorchid1746163monorchid
month104818423mon__th
monuron937463monuron
mooch125313613mo__och
morph121712513mo__rph
mosaic10311143mosaic_
mosaics1138073mosaics
mouch124715803mo__uch
munch124917103mun__ch
mynah13569563myna__h
narc67127953__narc_
narco76718243__narco
narcs76122023__narcs
natch105018223__natch
nomarchs1543903nomarchs
nomarchy1852763nomarchy
nonart6319193nonar_t
nonarts7311303nonarts
nonsuch1244683nonsuch
omniarchs1682223omniarchs
orach105219233_ora_ch
parch125123003__parch
pentarch1544943pentarch
poach124917863po_a_ch
porch125918623po__rch
roach105717003ro_a_ch
search113312423_search
snatch114310603_snatch
sonance9310313sonance
sonar56523423sonar__
sonars64818973sonar_s
starch113013203_starch
torch107420933to__rch
tovarich1643453tovarich
xerarch1943843xerarch
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 Limit134027997.20318607.1
3Display Results99990.0303300.0
 (SQL Overall)178691997.63923391.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.