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

108 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
ethoxy193392(None) 
ethoxyl2042351ethoxyl
methoxy2243951methoxy
echoey14397852echoey
epoxy17465772e_poxy
ethos85514192etho_s
ethoxyls2142212ethoxyls
methoxyl2342742methoxyl
ahoy101919183_aho_y
alkoxy2033343alkoxy
ataxy1537313at_axy
athodyd1542693athodyd
atomy107415193at_omy
atony87218853at_ony
atopy106813393at_opy
bethorn1238643bethorn
betony114211583bet_ony
boxy166420733__boxy
choky175711223_choky
deoxy1648883_deoxy
desoxy1744623desoxy
detox13310953det_ox_
doxy156419953__doxy
ebony104511513e_bony
echo96615953echo__
echoed125211163echoed
echoer114011103echoer
echoes114715523echoes
echoic1339043echoic
echos105216463echo_s
embody1435033embody
emboly1336723emboly
enjoy1545963enjo_y
entropy1247353entropy
envoy1156723envo_y
ephod1139123epho_d
ephods1238363ephods
ephor10310013epho_r
ephori1139603ephori
ephors11311403ephors
eth66630983eth___
ethane94613243ethane
ethene93312923ethene
ether84518773eth_er
ethers94518413ethers
ethic101511223eth_ic
ethics11169283ethics
ethinyl1343433ethinyl
ethion938813ethion
ethions1038483ethions
ethmoid1345803ethmoid
ethnic1148853ethnic
ethnonym1642563ethnonym
ethnos947053ethnos
ethology1547253ethology
ethoses10311763ethoses
ethoxies1845703ethoxies
eths76619523eth__s
ethyl1136513eth_yl
ethyls1235903ethyls
ethyne12407153ethyne
ethynyl1642123ethynyl
eulogy1035633eulogy
euphony1545403euphony
euroky1334823euroky
eutaxy1643303eutaxy
exhort16410803exhort
foxy176517753__foxy
holy106333433__holy
homy126623223__homy
hoy97447913__ho_y
method1239033metho_d
methods1338893methods
oxy136320983___oxy
peroxy1838253peroxy
phony136715443_phony
poxy166820893__poxy
proxy175011013_proxy
ptooey11346413ptooey
showy145714013_showy
stogy95414083st_ogy
stony85818643st_ony
story86723033st_ory
stroy87720393stro_y
tepoy10312163tepo_y
theory121098363_theory
thewy146311853_thewy
they107223753_th_ey
tho67433963_tho__
thole85620843_thole
thong95014183_thong
thorn85318703_thorn
thorny12509843_thorny
thoro86217873_thoro
thorp104414263_thorp
those85218143_those
thou76722213_tho_u
thous86017263_thous
thy97022913_th__y
thymy16437923_thymy
toby96322293_t_oby
tody86327213_t_ody
tony75635153_t_ony
tory75840543_t_ory
towy105325473_t_owy
toy69655193_t_o_y
troy77429683_tro_y
unholy1238163unholy

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 Filter1786911127160.373479064.3
2DLD Change Limit1127161085.65619928.6
3Display Results1081080.0303600.0
 (SQL Overall)1786911086.05929491.8
 
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.