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

62 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
demarche164553(None) 
demarches1745911demarches
demarcate1446612demarcate
menarche1545812menarche
dearie73319813de_ar_ie
dearth104212513de_arth_
dearths11498843de_arths
debacle1237443deba_cle
debauch15134423debauch_
debauched18123343debauched
debauchee17123613debauchee
debaucher17123293debaucher
debauches17124063debauches
debouche16123773debouche
decare93919153decar__e
deface123113863defa_c_e
deforce13267243deforc_e
dekare112811563dekar__e
demarcated1645083demarcated
demarcates1545973demarcates
demark134211023demar__k
demarked16187223demarked
demarks14339233demar_ks
demerge11168023demer_ge
demure9311533demur__e
departee1139723departee
detach12310413deta_ch_
detached1537733deta_ched
detacher1437543deta_cher
detaches1439653deta_ches
diarchy1644673d_iarchy
dyarchy1942503d_yarchy
earache1239323_e_arache
eparch13258423_eparch_
eparchs14196243_eparchs
eparchy17204753_eparchy
exarch18196173_exarch_
exarchs19165193_exarchs
exarchy22193693_exarchy
hexarchy2642873hexarchy
mache125925303__ma_che
manche133515103__manche
march125622893__march_
marched153813403__marched
marchen143312073__marchen
marcher143912973__marcher
marches143921173__marches
menarches1646683menarches
mesarch1445533mesarch_
nomarch1445353nomarch_
nomarchs1543903nomarchs
nomarchy1852763nomarchy
remarque1993553remarque
rematch1436193rematch_
rematched1745223rematched
rematches1636653rematches
revanche1645003revanche
search113312423se_arch_
searched14209253se_arched
searcher13209103se_archer
searches132112903se_arches
xerarch1943843xerarch_

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 Filter1786911461620.423422437.4
2DLD Change Limit146162626.37622923.8
3Display Results62620.0302066.7
 (SQL Overall)178691626.82926166.5
 
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.