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 “ethnoses” 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
ethnoses114608(None) 
ethoses10311761eth_oses
ethnos947052ethno__s
stenoses8310442stenoses
adenoses947903adenoses
arthroses1248733arthroses
athetoses1244983athetoses
bathoses13310463bath_oses
benthoses1446693benth_oses
chaoses124715123_chaoses
chooses125717433_chooses
choses115825133_ch_oses
cyanoses1337423cyanoses
dethrones1347313dethrones
ebonises1039223ebonises
echoes114715523ech_o_es
encloses10911063encloses
endnotes945943endnotes
enosis63816423e__nosis
enthrones12910073enthrones
enthuses1138253enth_uses
eposes84418783e__poses
eroses65327063e__roses
estheses1137783esth_eses
eternises9119453eternises
ethanes103713513eth_anes
ethanols1144333ethano_ls
ethenes103313873eth_enes
ethions1038483ethio_ns
ethmoids1444053ethmoids
ethnics1236263ethn_ics
ethnonym1642563ethnonym
ethnonyms1752183ethnonyms
ethos85514193eth_o__s
ethoxies1845703ethoxies
ethynes13377573eth_ynes
exposes1639963e_xposes
gnoses76515163__gnoses
heteroses12410793heteroses
hognoses12108143hognoses
hoses85443183__h_oses
hypnoses1646633hypnoses
ketoses114912873ket__oses
mannoses1039083mannoses
melanoses1147303melanoses
nephroses1446313nephroses
noses55435643___noses
orthoses11311143orth_oses
pathoses13412773path_oses
petasoses1145443petasoses
petuntses1142643petuntses
ptoses83514673pt__oses
pycnoses1554973pycnoses
pyknoses1783573pyknoses
rechooses14107623rechooses
schnozes2244493schnozes
selenoses947463selenoses
starnoses9157153starnoses
stenosed946343stenosed
stenosis847993stenosis
tennises82810133tennises
tenses64722553_ten_ses
tetanises979873tetanises
tetanuses984613tetanuses
theses96517973_th_eses
tholes94919783_th_oles
those85218143_th_ose_
throes97518673_thro_es
thrones105715843_thrones
thyrses1335023_thyrses
tonuses73612193_tonuses
trioses75015653_trioses
zoonoses1746203zoonoses

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.453394461.4
2DLD Change Limit146162736.32623105.0
3Display Results73730.0332212.1
 (SQL Overall)178691736.81226231.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.