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

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

401 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
etcetera104318(None) 
etceteras1142651etceteras
detecter11298733detecter_
detecters12217753detecters
entera64216833e__ntera
ephemera1554213ephemera
erecter93113393erecter_
erecters102611613erecters
etcher113912943etc_her_
etchers123411293etc_hers
exciter1637753exciter_
exciters1736323exciters
excreter1766123excreter_
excreters1874873excreters
teeter65420313_teeter_
teeters74018303_teeters
tetra53417953_t_et_ra
tuatera756373_tuatera
acceder1235364acceder_
acceders1334794acceders
accepter14144934accepter_
accepters15114604accepters
aceta74017354_acet__a
acuter84412864_acuter_
ammeter1148394ammeter_
ammeters1237694ammeters
attester836504attester_
attesters935804attesters
bacteria1248994bac_teria
betatter1035454betatter_
betatters1134964betatters
better84723704bet__ter_
betters94422094bet__ters
cafeteria1453804cafeteria
camera10313694__camera
catena8312484__catena
cater74840724__cater_
cateran9313774__cateran
caters85336504__caters
catheter1338154catheter_
catheters1437014catheters
ceder85322244__ceder_
ceders93817674__ceders
celery1139624__celery
cemetery1554924cemetery
center84421414__center_
centers94420604__centers
centra84113884__centra
cerebra1155924__cerebra
cesura838764__cesura
cete64934784__cete__
cetes75731104__cete_s
citer74827334__citer_
citers85022984__citers
cocinera1245554cocinera
coveter122912064coveter_
coveters132411084coveters
cuter74728234__cuter_
decenter112412164decenter_
decenters122410374decenters
depleter11298864depleter_
depleters12327544depleters
detected12289734detecte_d
detector11278324detector_
detectors12278304detectors
deter65028044__deter_
deters74724684__deters
detester9239684detester_
detesters10298304detesters
dicentra1145434dicentra
dieter73516774_dieter_
dieters83216434_dieters
dimeter10411894dimeter_
dimeters11411094dimeters
diptera1037214_diptera
eagerer8248824eagerer_
easter65027984e_aster_
eastern74412534e_astern
easters75125684e_asters
eater54639844e__ater_
eaters65535954e__aters
eatery95316354e__atery
echeveria1752314echeveria
echoer114011104e_choer_
echoers12459694e_choers
ectoderm1383794ectoderm
ectomere1245754ectomere
ectotherm1642744ectotherm
eczema1973074e_c_zema
effecter1664774effecter_
effecters1764324effecters
effete1235184effete__
effetely1742694effetely
eglatere945164eglatere
ejecta15337394eject__a
ejected17297654ejecte_d
ejector16378604ejector_
ejectors17328664ejectors
elater64724204e_later_
elaters74420194e_laters
elected102812614electe_d
electee92513244electe_e
electees10238724electees
elector93313264elector_
electoral1156734electoral
electors103013864electors
electret10412004electret
electro92810034elect_ro
elytra934894e_lyt_ra
emcee9315944emce_e__
emceed1136284emce_e_d
emcees1037814emce_e_s
emeer74815364e_me_er_
emeers83314184e_me_ers
emitter93211084emitter_
emitters10349644emitters
emoter85415194e_moter_
emoters94712874e_moters
encoder1038634encoder_
encoders1137514encoders
enfetter1145354enfetter_
enfetters1244464enfetters
enfever1344644enfever_
enfevers1444514enfevers
enter54726384e__nter_
enteral73516454e__nteral
enterer72015634enterer_
enterers82214154enterers
enters64425644e__nters
eocene8311614eocene__
ephedra1344214ephe_dra
ephemerae1653274ephemerae
ephemeral1653884ephemeral
ephemeras1653574ephemeras
epicenter1395504epicenter_
epicenters14114464epicenters
epicentra1353654epicentra
episterna1143374episterna
erected103213994erecte_d
erector93513814erector_
erectors103514264erectors
escaper11368844escaper_
escapers12337414escapers
eschewer1643174eschewer_
eschewers1742884eschewers
escoted1038184escote_d
ester54727714e__ster_
esters64627734e__sters
esthete1047434esthete__
esthetes1147744esthete_s
etagere836534et_agere
etched123613704etc_he_d
etches114217764etc_he_s
ethene93312924ethene__
ethenes103313874ethene_s
ether84518774et__her_
ethereal1146784ethereal
ethers94518414et__hers
etwee84115334etwe_e__
etwees9348794etwe_e_s
evener91010624e_vener_
eveners10109504e_veners
exacter1637404exacter_
exacters1736774exacters
exalter1437564exalter_
exalters1536654exalters
exceed1636174exce_e_d
exceeder1843954exceeder_
exceeders1943284exceeders
exceeds1733844exce_eds
excepted2055234excepte_d
excerpter2063904excerpter_
excerpters2143184excerpters
excimer1834964excimer_
excimers1944704excimers
excite15310884excite__
excited1737854excite_d
excites16310634excite_s
excitor1645994excitor_
excitors1746094excitors
excreta1674624exc_reta
excrete1667164excrete__
excreted1846154excrete_d
excretes1787574excrete_s
excretory2143464excretory
excuser1635814excuser_
excusers1734444excusers
executer1745314executer_
executers1854184executers
exedra1434504e_xe_dra
exhedra1843304exhe_dra
expecter1936514expecter_
expecters2045474expecters
extern1348474e__xtern
extorter1546514extorter_
extorters1645764extorters
extra1239004e__xt_ra
extremer1744654extremer_
eyewear1342624e_yewear
facete115014834facete__
faceted13509564facete_d
facetely1643854facetely
ferreter1136544ferreter_
ferreters1246254ferreters
fetcher153510394fetc_her_
fetchers16328864fetc_hers
fetter94120384fet__ter_
fetterer11207814fetterer_
fetterers12267044fetterers
fetters103517904fet__ters
fleeter103210364fleeter_
genera71211714__genera
geometer1138424geometer_
geometers1238194geometers
getter74117614get__ter_
getters84216104get__ters
greeter82812674greeter_
greeters92610114greeters
hetaera1036494het__aera
hetero9312634__hetero
iceberg1242294_iceberg
incenter102212094incenter_
incenters112510304incenters
inciter93113774inciter_
inciters103210674inciters
itchier12247674itchier_
lectern937034lec_tern
letter63722584let__ter_
letterer8259224letterer_
letterers9228114letterers
letters73819854let__ters
locater93113604locater_
locaters102710074locaters
meeter83616504_meeter_
meeters94714544_meeters
mesentera1144654mesentera
metacenter1452904metacenter_
metacenters1552484metacenters
metepa1066014__metepa
meter75130324__meter_
meters85625834__meters
monstera10318884monstera
mycetoma1752374mycetoma
netter63722024net__ter_
netters73618584net__ters
osetra667424_oset_ra
osmeteria1153154osmeteria
ossetra744074osset_ra
otter54423974ot__ter_
otters64021514ot__ters
panetela1044154panetela
peter74427594__peter_
peters86624594__peters
petter83924774pet__ter_
petters93722364pet__ters
picketer16187434picketer_
picketers17196484picketers
plectra1145794plect_ra
pocketer16157374pocketer_
pocketers17196494pocketers
preterm11310164_preterm
quieter162810334quieter_
quieters17248734quieters
recenter102715444recenter_
reciter94117264reciter_
reciters102613114reciters
rejecter17258944rejecter_
rejecters18257544rejecters
retear63115484__retear
retorter8410734retorter_
retorters938774retorters
retreater9310204retreater_
retreaters1047544retreaters
riveter10208754riveter_
riveters11228164riveters
rocketer14158334rocketer_
rocketers15186884rocketers
santera7311304_santera
scenery1236564_scenery
scepter1138364_scepter_
scepters1237794_scepters
sclera838894_sc_lera
scoter83815484_scoter_
scoters93313814_scoters
seceder10329574seceder_
seceders11277964seceders
secreter1038514secreter_
setter64023724set__ter_
setters73822064set__ters
sheeter103814914sheeter_
sheeters113111864sheeters
skeeter113410414skeeter_
skeeters12298964skeeters
specter113111734specter_
specters122811064specters
spectra11275834spect_ra
starter73817884starter_
starters83714774starters
stater64427564st_ater_
staters73922344st_aters
steeper93812774steeper_
steepers103011374steepers
steer55423864st_e_er_
steerer73113634steerer_
steerers82511354steerers
steers63820984st_e_ers
stinter73614514stinter_
stinters83312754stinters
stouter74012054stouter_
stretta737294stret_ta
strewer104310414strewer_
strewers11409064strewers
stutter72911464stutter_
stutters83210474stutters
sweeter103212004sweeter_
tantara72410824_tantara
tantra63713364_tant_ra
tarter64023564_tarter_
taster64930574_taster_
tasters74225644_tasters
tater54138614_t_ater_
taters64932204_t_aters
tatter64024574_tatter_
tatters74520484_tatters
tauter64318024_tauter_
techier1269244techier_
tecta74215524tec_t__a
teemer85515744_teemer_
teemers95012904_teemers
teener64717504_teener_
teeners74415454_teeners
teetered9258304_teetered
teether10349694_teether_
teethers11328714_teethers
telega736774_t_elega
teleran7510184_t_eleran
teletext1545254teletext
tempera11329044_tempera
tempter11358214tempter_
tempters12257294tempters
tenter64623934_tenter_
tenters73921104_tenters
tephra1136484_t_ephra
terete6319334terete__
terra54419664_t_e_rra
tessera736334_tessera
tester64227154_tester_
testers74124544_testers
tetchier1336454tetchier_
tether93716104_t_ether_
tethers103815314_t_ethers
tetrad73612054_t_et_rad
tetras63017624_t_et_ras
tetri52716454_t_et_ri
tetter64322454_tetter_
tetters74320474_tetters
theater104014254_theater_
theaters114211904_theaters
theta83414574_thet__a
tilter63417694_tilter_
tilters73315954_tilters
tinter63923644_tinter_
tinters74221114_tinters
titer55430614_t_iter_
titers64526414_t_iters
titter63421164_titter_
titters74219624_titters
tooter64420804_tooter_
tooters73818774_tooters
toter55932134_t_oter_
toters65026364_t_oters
totter65021464_totter_
totters74618734_totters
tottery10388484_tottery
touter63821034_touter_
touters74018354_touters
treater74219834_treater_
treaters83615844_treaters
triter65120594_triter_
tuatara745514_tuatara
tuateras836194_tuateras
tufter9319934_tufter_
tufters10298354_tufters
tweeter10288534tweeter_
tweeters11287144tweeters
ureter6313204_ureter_
ureteral856234_ureteral
ureters7311824_ureters
urethra1064154_urethra
utter54218764ut__ter_
utterer71910464utterer_
utterers8218654utterers
utters63817124ut__ters
veteran1039354__veteran
vetter93417644vet__ter_
vetters104016324vet__ters
vicegeral1551854vicegeral
wetter93919444wet__ter_
wetters103817754wet__ters
yachter1534914yachter_
yachters1633884yachters

Search took 20 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 Filter1786911616090.903197885.9
2DLD Change Limit16160940118.0338961.8
3Display Results4014010.1562570.5
 (SQL Overall)17869140119.0929359.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.