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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
exarchs1916519(None) 
eparchs14196241eparchs
exarch18196171exarch_
exarchy22193691exarchy
anarchs1237092anarchs
earths95014592e_arths
eparch13258422eparch_
eparchy17204752eparchy
exacts15359612exa_cts
exarchal2043722exarchal
exarchies2145212exarchies
hexarchy2642872hexarchy
anarch11310393anarch_
anarchy1544933anarchy
arch98628443__arch_
arches114822043__arches
arcs67834783__arc_s
arcus76918863__arcus
autarchs1344993autarchs
barcas101016603_barcas
brachs134415753bra_chs
clachs133511323cla_chs
dearths11498843dearths
demarche1645533demarche
demarches1745913demarches
diarchy1644673diarchy
dyarchy1942503dyarchy
each95530583e_a_ch_
earache1239323e_arache
earaches13411303e_araches
earls56127513e_ar_ls
earns55927563e_ar_ns
ears46356593e_ar__s
earth85023053e_arth_
earthy12399943e_arthy
ecartes94212563ecartes
enacts84012973ena_cts
endarch1345443endarch_
endarchy1743343endarchy
epacts105010393epa_cts
eparchies1646973eparchies
epochs1335813e_pochs
ethnarchs1751773ethnarchs
eunuchs1272683eunuchs
exact143516933exa_c_t
exacta15337393exa_cta
exactas16336433exactas
exalts13328313exa_lts
examens1637193examens
exams14199083exa__ms
exarchate2144453exarchate
exarchates2243963exarchates
execs14539723ex_ec_s
exercise1747063exercise
exerts133712293exer_ts
exorcise1745933exorcise
exorcism1945203exorcism
exorcist1746873exorcist
expects1866883expects
express1637493express
exsects1655573exsects
extracts1747623extracts
extras13310223extr_as
exurbs1534423exur_bs
farces115223323_farces
garths104111503_garths
hearths135311073hearths
heptarchs1943043heptarchs
hexarchies2543863hexarchies
hierarchs1743423hierarchs
inarch1139163inarch_
inarches1358043inarches
laichs115110893_laichs
larch105919793_larch_
larches124416443_larches
machs125722563_ma_chs
march125622893_march_
marches143921173_marches
marcs95726623_marc_s
menarche1545813menarche
menarches1646683menarches
mesarch1445533mesarch_
monarchs1544833monarchs
narcos86714203_narcos
narcs76122023_narc_s
nomarchs1543903nomarchs
parch125123003_parch_
parches143720003_parches
pentarchs1643933pentarchs
quaichs2144633quaichs
sauchs115112233_sauchs
scarphs14437413scarphs
search113312423search_
searches132112903searches
starch113013203starch_
starches131912913starches
starchy15286743starchy
swarths13537323swarths
tachs105820933_ta_chs
tetrarchs14104283tetrarchs
xerarch1943843xerarch_

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.1561145455.1
2DLD Change Limit1340271017.59317651.4
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.77922970.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.