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

162 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
ethynes1337757(None) 
ethanes103713511ethanes
ethenes103313871ethenes
ethyne12407151ethyne_
ethane94613242ethane_
ethene93312922ethene_
ethnos947052eth_nos
ethoses10311762ethoses
ethylenes1544222ethylenes
ethyls1235902ethy_ls
ethynyl1642122ethynyl
ethynyls1741872ethynyls
methanes133812162methanes
thanes94918982_thanes
thymes144810742_thymes
tynes85920302_t_ynes
achenes12313493achenes
alkynes14336463alkynes
atones65225773at_ones
attunes737823attunes
berhymes1843803berhymes
betaines10313293betaines
bethanks1765313bethanks
bethinks1765043bethinks
cetanes9315133cet_anes
chines115029173_chines
chyles144813283_chyles
chymes165912153_chymes
cohunes1249713cohunes
dethrones1347313dethrones
dynes95917583__dynes
ecdyses1333413ecdyses
eches106322163ech__es
echinus1236203echinus
echoes114715523ech_oes
ectypes1434803ectypes
eikones1137853eikones
emydes1236173e_mydes
engines81114463engines
enhances1339293enhances
enthrones12910073enthrones
enthuses1138253enthuses
entwines1148753entwines
enzymes2164413enzymes
eosines73718293eosines
ephebes1436153ephebes
equines161811593equines
ermines9416673ermines
ernes55224813e__rnes
errhines1136413errhines
esnes54817363e__snes
estheses1137783estheses
esthetes1147743esthetes
estrones8313323estrones
etamines101611813etamines
etapes85415293et_apes
etchants1346023etchants
etches114217763et_ches
etchings14396293etchings
eterne6311723eterne_
ethanol1044593ethanol
ethanols1144333ethanols
ether84518773eth__er
ethers94518413eth_ers
ethics11169283eth_ics
ethinyl1343433ethinyl
ethinyls1442873ethinyls
ethions1038483ethions
ethnic1148853eth_nic
ethnics1236263ethnics
ethnoses1146083ethnoses
ethos85514193eth__os
ethoxies1845703ethoxies
eths76619523eth___s
ethyl1136513ethy__l
ethylates1545943ethylates
ethylene1444233ethylene
ethylic1546323ethylic
etnas54713933et__nas
etoiles7411293etoiles
etudes73811603et_udes
etwees9348793et_wees
evzones1964523evzones
exhales1737143exhales
exhumes1934323exhumes
exines135715803e_xines
externes1539833externes
eyes75837883e__y_es
eyne76322463e__yne_
eyres84921773e__yres
groynes1137823groynes
hones88144493__hones
hypes135818673__hypes
ketenes114813503ket_enes
ketones115014503ket_ones
lethes94818083leth__es
menthenes1447703menthenes
methane123211793methane_
methinks1775193methinks
methylenes1854603methylenes
methyls1535453methy_ls
phones114121213_phones
physes14399783_physes
reshines112615443reshines
retenes76324623ret_enes
rethinks1576033rethinks
retines75134673ret_ines
retunes76918403ret_unes
retypes12308623ret_ypes
rhymes14419823_rhymes
setlines8312743setlines
shines95028913_shines
shyness1344993_shyness
sphenes123013163sphenes
sphynxes23292423sphynxes
stanes64933403st_anes
stones65130033st_ones
styes86316523st_y_es
styles94418653st_yles
ternes65422903_ternes
thane86122533_thane_
thanks134313133_thanks
thebes115914493_thebes
theines104013233_theines
themes115319253_themes
thens85921833_then_s
theres96525473_theres
theses96517973_theses
thine85026863_thine_
things104914303_things
thinks134613363_thinks
thins85826333_thin_s
tholes94919783_tholes
thongs104611193_thongs
threes97117323_threes
throes97518673_throes
thrones105715843_thrones
thunks13459033_thunks
thyme134612473_thyme_
thymey17426313_thymey
thymines1635613_thymines
thymus14324743_thymus
thyrse1235133_thyrse
thyrses1335023_thyrses
tines54848423_t_ines
tones56048663_t_ones
tonnes65320853_tonnes
trines64132563_trines
trones65629283_trones
tunes55332193_t_unes
twines94717273_twines
tyees86019453_t_yees
tyes76433373_t_y_es
tykes125817063_t_ykes
tyne76325053_t_yne_
tyned95915013_t_yned
types105721063_t_ypes
tyres84725233_t_yres
urethanes1245163urethanes
vahines133410523vahines
wahines133111173wahines
whines125120103_whines

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.406440125.6
2DLD Change Limit1340271625.81323056.4
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.28228444.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.