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

73 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
endarch134544(None) 
endarchy1743341endarchy
anarch11310392an_arch
endash10297122enda_sh
eparch13258422e_parch
exarch18196172e_xarch
inarch1139172in_arch
pentarch1544942pentarch
anarchs1237093an_archs
anarchy1544933an_archy
arch98628443___arch
autarch1246623autarch
each95530583e__a_ch
earth85023053e__arth
eldrich1354583eldrich
emdash12244113emda_sh
enact73525363en_a_ct
encash11276943enca_sh
endarchies1644463endarchies
endear74110013endear__
endeared1038053endeared
endears83710053endear_s
ender64325863ender__
enders74324053ender_s
endorse879203endorse
endosarc1143593endosarc_
endosarcs1243343endosarcs
endrin7312403end_rin
endure74014143endur_e
endured93611213endured
endurer83210363endurer
endures83314603endures
enduro7338623endur_o
enduros8298153enduros
enface112510353enfa_ce
enforce12237423enforce
enhance1239693enhance
enlace82213233enla_ce
enlarge835533enlarge
enrich1138943en_rich
eparchs14196243e_parchs
eparchy17204753e_parchy
ethnarch1642413ethnarch
exarchs19165193e_xarchs
exarchy22193693e_xarchy
gendarme1243523gendarme
heptarch1843563heptarch
inearth1037043inearth
infarct1249013infarct
larch105919793__larch
march125622893__march
menarche1545813men_arche
mesarch1445533mesarch
monarch1445953monarch
narc67127953_n_arc_
narco76718243_n_arco
narcs76122023_n_arcs
natch105018223_n_atch
nomarch1445353nomarch
omniarch1562723omniarch
parch125123003__parch
pentarchs1643933pentarchs
pentarchy1942723pentarchy
research1344553research
search113312423_search
snatch114310603sn_atch
starch113013203_starch
tendance1147523tendance
tetrarch13104783tetrarch
unearth1037063unearth
unlatch1245053unlatch
vendace1357363venda_ce
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 Filter1786911340270.403443402.0
2DLD Change Limit134027736.19021652.2
3Display Results73730.0164562.5
 (SQL Overall)178691736.60927037.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.