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

243 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
steroid8131486(None) 
asteroid9511191asteroid
steroids9911441steroids
aneroid8314002aneroid
asteroids1048742asteroids
ctenoid1078682ctenoid
emeroid101511182emeroid
hysteroid1645892hysteroid
osteoid848192oste_oid
scleroid1147212scleroid
sparoid102311542sparoid
spheroid1447282spheroid
spiroid10219822spiroid
sporoid102310732sporoid
stereoed937882stereoed
steric8317062ster_ic
steroidal1045472steroidal
sterol6613332stero_l
sterols7313442sterols
stroud7310382st_roud
styloid1137552styloid
theroid11313402theroid
toroid7416012_toroid
acaroid103512313acaroid
adenoid959253adenoid
amberoid1346433amberoid
ambroid1238883ambroid
ameboid1277233ameboid
android9311513android
aneroids9310203aneroids
aroid65428343__aroid
asteria7316183aster_ia
asteroidal1154123asteroidal
athetoid1246743athetoid
bacteroid1456253bacteroid
catenoid1149113catenoid
ceboid11310653_ceboid
cervid1239323_cervid
cheloid13310833cheloid
choroid13311803choroid
clerid9312413cler_id
dermoid1138523_dermoid
devoid1189363_devoid
droid74218543__droid
emerod9139213emero_d
emeroids11147723emeroids
energid948303energid
ethmoid1345803ethmoid
fervid1337513_fervid
fibroid1337243fibroid
geoid74215763_ge_oid
glenoid937803glenoid
haemoid1337203haemoid
hemoid12313513_hemoid
heroic113516923_heroic
heroin94420593_heroin
hydroid1539713hydroid
hyenoid1448613hyenoid
isthmoid1463093isthmoid
jerid132316423_jer_id
jerrid14259143_jerrid
keloid11812623_keloid
labroid1038823labroid
meloid9616003_meloid
meteoroid1245113meteoroid
myeloid13108123myeloid
naevoid1194593naevoid
negroid9108893negroid
nereid7312923_nereid
neuroid81110303neuroid
nevoid1098793_nevoid
nonsteroid1154593nonsteroid
oceloid1037973oceloid
ochroid1357903ochroid
osteoids945953oste_oids
overbid132710273overbid
overdid12199173overdid
percoid12312313_percoid
period9314983_period
peroxid17310273_peroxid
pterin81014153pter_in
pteropod1344663pteropod
pterygoid1652243pterygoid
sarcoid10310453sarcoid
sarod65325873s_aro_d
satyrid1137233satyr_id
schrod1247883schro_d
sciuroid1144403sciuroid
sclereid1145363sclereid
scrod85115073s_cro_d
second9411153s_econd
serai56830163s_erai_
serail64222673s_erail
serais64326133s_erais
sered65737293s_er_ed
serein63318463s_erein
serged84118773s_erged
serif84132133s_er_if
serin55434443s_er_in
serosa6313023s_erosa
serous65023563s_erous
serow86720443s_ero_w
serows96016393s_erows
serried82513963s_erried
served104616813s_erved
sherd96321153sher__d
sherif122915243sher_if
sheroot10414373sheroot
sherris10168803sherris
shroud1038773s_hroud
sialoid8310963sialoid
sigmoid1146113sigmoid
siluroid945053siluroid
simioid1047993simioid
sistroid947263sistroid
sleazoid1843203sleazoid
sloid64619713s__loid
smerked14327283smerked
solenoid947873solenoid
sordid83411163s_ordid
sparid94016933spar_id
sparoids11218713sparoids
spermic1338523spermic
sphenoid1446323sphenoid
spheroids1545543spheroids
staid66722083st__aid
stared75429873star_ed
starlit71512913starlit
starred85013453starred
started84217323started
starved114911573starved
stead65520273ste__ad
steaded92811673steaded
steadied1036563steadied
steamed103712143steamed
stearic939423stearic
stearin7312003stearin
steed66024943ste__ed
steeked124010473steeked
steeled83513223steeled
steelie7310213steelie
steeped103412283steeped
steered83615253steered
steeved113610133steeved
stein54620543ste__in
stelai63912563stelai_
stelic8313083ste_lic
stemmed12278153stemmed
stencil946893stencil
steno54716863steno__
stenoky1444253stenoky
stenos63915773steno_s
stenosed946343stenosed
stenosis847993stenosis
stenotic1048083stenotic
stepped123210053stepped
stere55328543ster__e
stereo65317913ster_eo
stereoing1037893stereoing
stereos74314973stereos
steres63929533ster_es
sterile7316603sterile
sterlet71318473sterlet
sterling93615553sterling
stern55319123ster__n
sterna63712763ster_na
sternal73411913sternal
sterner7411913sterner
sternite8310543sternite
sternly1037853sternly
sterns64616763ster_ns
sternum947733sternum
stertor7310093stertor
stertors8310933stertors
stetted82610403stetted
steward1138063steward
stewed104814243ste_wed
stirred8359703stirred
stoic7317253st__oic
stolid74213183st_olid
stood65517713st__ood
stored75524213stor_ed
storied8515163storied
stormed1039043stormed
strain64919573st_rain
strait64025893st_rait
strand74514823st_rand
strewed115811343strewed
stria55723213st_r_ia
stride75420963st_r_ide
strip77524343st_r_ip
strobe84513813st_robe
strobic1138253st_robic
strobil936963st_robil
strode75215973st_rode
stroke105116173st_roke
stroked124613623st_roked
stroll6311603st_roll
stroma84313073st_roma
strong74914883st_rong
strook10410303st_rook
strop77422243st_ro_p
strops86220383st_rops
strouds837803st_rouds
strove95014793st_rove
strow88920573st_ro_w
strowed115312143st_rowed
strown96812093st_rown
strows96718273st_rows
stroy87720393st_ro_y
stroyed114110863st_royed
stroys95914603st_roys
stupid937593st_upid
sturdied10215963sturdied
swerved1455703swerved
synergid1344573synergid
teiid6312533_te_iid
teloi54217383_teloi_
tepid8314313_te_pid
terai53525483_terai_
terais64023513_terais
teratoid9411073_teratoid
terbia8311153_terbia
terbic10410963_terbic
termed94816703_termed
territ63421373_territ
tetroxid1646443_tetroxid
thyroid1438253thyroid
toroids8310643_toroids
torpid9310913_torpid
torrid7311853_torrid
toxoid1438153_toxoid
trepid9310083_trepid
trod57627953_t_ro_d
trois57226093_t_rois
tuberoid1146013tuberoid
turbid979713_turbid
turgid868023_turgid
uteri51012983uter_i_
verbid122311313_verbid
viroid10411523_viroid
zebroid1936463zebroid
zeroed16409413_zeroed

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 Limit1340272436.21621561.6
3Display Results2432430.0803037.5
 (SQL Overall)1786912436.70226662.3
 
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.