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

94 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
menarches164668(None) 
menarche1545811menarche_
demarches1745912demarches
inarches1358042_inarches
marches143921172m__arches
menaces112715522mena_c_es
menarcheal1752602menarcheal
mensches1536302men_sches
merches144013762me__rches
monarchies1745372monarchies
monarchs1544832monarch_s
searches132112902se_arches
anarchies1448183_anarchies
anarchs1237093_anarch_s
arches114822043___arches
beaches144120653be_a_ches
benches143918603ben__ches
cenacles1238023cena_cles
debauches17124063debauches
demarche1645533demarche_
detaches1439653deta_ches
earaches13411303_e_araches
endarchies1644463_endarchies
enriches1337263_enriches
eparchies1646973_eparchies
eparchs14196243_eparch_s
exarchies2145213_exarchies
exarchs19165193_exarch_s
ganaches1437423gana_ches
gynarchies1943173gynarchies
hexarchies2543863hexarchies
inarched1486113_inarched
kenches163912273ken__ches
larches124416443__larches
leaches123319343le_a_ches
maches134827233m__a_ches
manacles1239523mana_cles
manches143818623m__anches
marched153813403m__arched
marchen143312073m__archen
marcher143912973m__archer
marchers153710813m__archers
marchesa15346883m__archesa
marchese15358913m__archese
marchesi15337323m__archesi
marshes123615373m__arshes
matches143219783m__atches
menace103216943mena_c_e_
menaced122710093mena_c_ed
menacer112610883mena_c_er
menacers12279313mena_cers
menages103615393mena__ges
menorahs1346543menorah_s
menorrhea1453493menorrhea
menorrheas1552963menorrheas
menschen1543713men_schen
menshes12310453men__shes
merces105720743me__rc_es
mercies113817563me__rcies
mesarch1445533mesarch__
monarch1445953monarch__
monarchal1643973monarchal
monarchic1844953monarchic
monarchism1954023monarchism
monarchist1755243monarchist
monarchy1843603monarch_y
munches144215793mun__ches
naches114622413__na_ches
overarches1846833overarches
panaches15310283pana_ches
parches143720003__parches
peaches144120053pe_a_ches
penances12312443penanc_es
penoches1538933pen_oches
pentarchies1853973pentarchies
pentarchs1643933pentarch_s
penuches1536943pen_uches
perches143717953pe__rches
reaches123423203re_a_ches
rematches1636653rematches
repatches1636713repatches
researches1544293researches
revanches1746253revanches
searched14209253se_arched
searcher13209103se_archer
searchers14197353se_archers
snatches131410713_snatches
starches131912913_starches
teaches122718353te_a_ches
tenaces92814513tena_c_es
tenancies1149173tenancies
tenches123515523ten__ches
unarched14128553_unarched
wenches152914133wen__ches

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 Filter1786911486410.420425454.8
2DLD Change Limit148641947.34620234.3
3Display Results94940.0303133.3
 (SQL Overall)178691947.79622920.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.