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

352 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
sterols731344(None) 
sterol6613331sterol_
nerols6914882_nerols
petrols92913082petrols
safrols1036862safrols
serous65023562s_erous
serows96016392s_erows
sheols94614162she_ols
stanols739732stanols
steals64020062ste_als
steels64117982ste_els
stenos63915772steno_s
stereos74314972stereos
steres63929532ster_es
sterile7316602sterile
sternly1037852sternly
sterns64616762ster_ns
steroid81314862steroid
steroids9911442steroids
stertors8310932stertors
stools65117022st_ools
streels73811342streels
stroll6311602st_roll
strolls739182st_rolls
strops86220382st_rops
strows96718272st_rows
stroys95914602st_roys
acerola947823acerola
acerolas1048053acerolas
acerous9513333acerous
apterous10410463apterous
asterias8317013asterias
asteroid9511193asteroid
asteroids1048743asteroids
asters65631603aster__s
astrals75515243ast_rals
beryls11107883_beryls
carols85124983_carols
ceorls848163_ceorls
ceros74726073_cero_s
cerous85821203_cerous
cresols939653cresols
emerods10137653emerods
enols54718403__enols
enrols61213383_enrols
enterons8314153enterons
eros45238453__ero_s
esters64627733ester__s
estriols856253estriols
estrous7712533est_rous
eternals8238953eternals
ferals94216643_ferals
herls85226433_her_ls
heroes94923823_heroes
herons94820543_herons
heros84930863_hero_s
heteros10312683hetero_s
ketols104210763_ketols
laterals8312753laterals
literals8312293literals
merls77423903_mer_ls
metols84115773_metols
metros84217803metro_s
nerol51017813_nerol_
neroli61111153_neroli
nerolis71012773_nerolis
onerous7312973onerous
operons91411743operons
parols84722613_parols
patrols93513513patrols
perils84121853_perils
petrels9279373petrels
petrol82714063petrol_
petrous92714423petrous
phenols1238103phenols
pterins9812993pterins
pteryla1243303pteryla
pyrrols1235403pyrrols
reroll6412683_reroll
rerolls739943_rerolls
retools73411023retools
retros63820193retro_s
sacrals93311793sacrals
safrol937283safrol_
safrole1037253safrole
safroles1136933safroles
salols64017873s_alols
santeros8311193santero_s
santols73513323santols
sarods74918573s_arods
saros55238063s_aro_s
saurels749303saurels
schools1249113schools
schorls1248353schorls
schrods1337433schrods
sclerous1047923sclerous
scrods94111613s_crods
scroll8310173s_croll
scrolls938063s_crolls
seals54839693s_e_als
seels55632823s_e_els
seeress7311573seeress
seers55136383seer__s
segos64919483s_ego_s
sells55134433s_e_lls
sels46345983s_e__ls
senors63620793s_enors
sepals85217373s_epals
sepoys1138473s_epoys
seracs84418573s_eracs
serails73318363s_erails
serais64326133s_erais
seral56336383s_eral_
seres55448893s_er_es
serfs84922013s_er_fs
serges74225973s_erges
serials73919743s_erials
series64540973s_eries
serifs94017053s_erifs
serins64029673s_erins
serious73616283s_erious
sermons9311783s_ermons
serosa6313023s_erosa
serosas7312663s_erosas
serow86720443s_ero_w
sers45746653s_er__s
serums83916303s_erums
servals103410743s_ervals
serves94423653s_erves
servos93812723s_ervos
setons64620173s_etons
setous64917373s_etous
severals1137593severals
sferics1236133sferics
sheals94420643she_als
shekels1436043shekels
shells94319523she_lls
sheol84318373she_ol_
sheqels1934753sheqels
sherds105614723sher_ds
sherifs13299683sherifs
sheroot10414373sheroot
sheroots1137863sheroots
sherpas1238093sherpas
sherris10168803sherris
shools94919013s_hools
shorls94516203shor_ls
shtetels1143233shtetels
shtetls1034583shte_tls
sierras737863sierras
skatols1135533skatols
skells105013783ske_lls
skirls10449823skir_ls
smells83914743sme_lls
smerks12449713smer_ks
snarls64016873snar_ls
snells64614203sne_lls
snools65715883s_nools
sokols10399093s_okols
sols45448163s___ols
sorels63921163s_orels
sorrels7310723sorrels
sorrows10278403sorrows
sotols63714473s_otols
speels85116393spe_els
speils84116223spe_ils
spells84617683spe_lls
spermous1247933spermous
sperms102512603sper_ms
spirals93212513spirals
spools85115913s_pools
stalls64019933st_alls
stanol6310723stanol_
stardoms1136793stardoms
starers74522313starers
stares66038753star_es
starets73515923starets
starkly14277033starkly
stars55836573star__s
startle72511123startle
startles82111963startles
starts65423123star_ts
starves104614553starves
stators73915583stators
steads74116223ste_ads
steaks104415853ste_aks
steal56125473ste_al_
steamroll1152103steamroll
steamrolls1251813steamrolls
steams84916903ste_ams
stearins8312143stearins
steeds73814883ste_eds
steeks103613703ste_eks
steel55721993ste_el_
steely93612573ste_ely
steeple937323steeple
steeples1038013steeples
steeply1236293steeply
steeps85215193ste_eps
steerers82511353steerers
steers63820983ste_ers
steeves103410903steeves
steins64818343ste_ins
stela54019043ste__la
stele55026843ste__le
steles63725663ste_les
stella63612973ste_lla
stellas72813043stellas
stemmas11256973stemmas
stems75219953ste__ms
stemsons1045003stemsons
stencils1046403stencils
steno54716863steno__
stenoky1444253stenoky
stenoses8310443stenoses
stenosis847993stenosis
stentors839743stentors
stents65019453ste_nts
steppes113110693steppes
steps76619883ste__ps
stepsons1045663stepsons
stere55328543ster__e
stereo65317913ster_eo
stereoed937883stereoed
steric8317063ster_ic
sterilise948993sterilise
sterlet71318473sterlet
sterlets8169273sterlets
stern55319123ster__n
sterna63712763ster_na
sternal73411913sternal
sterner7411913sterner
sternest8314433sternest
sternsons944663sternsons
sternum947733sternum
sternums1045783sternums
stertor7310093stertor
stets55423913ste__ts
stetsons845623stetsons
stews85519143ste__ws
stills64118573st_ills
stipels9418953stipels
stirks104914243stir_ks
stirpes95011293stirpes
stirps85011823stir_ps
stirs55921623stir__s
stoas55126023st__oas
stobs75718233st__obs
stole54928813st__ole
stoles63927673st__oles
stolons73410243stolons
stooks105115373st_ooks
stool55619893st_ool_
stoops85917893st_oops
stops74827283st__ops
storers75018683storers
stores65533663stor_es
storeys10559653storeys
stories7324273stories
storks106115953stor_ks
storms85814633stor_ms
stoss54316343st__oss
stots54828553st__ots
stows86622703st__ows
straps87721783st_raps
strass67117223st_rass
straws98718673st_raws
strays96417933st_rays
streaks114411273streaks
streams94713373streams
streeks11378713streeks
streel64214023streel_
streets73312613streets
streps86218063st_reps
stress66616673st_ress
strews96817103st_rews
strips85719653st_rips
strobe84513813st_robe
strobes93813263st_robes
strobils1046563st_robils
strode75215973st_rode
stroke105116173st_roke
strokes114316323st_rokes
stroma84313073st_roma
strong74914883st_rong
strook10410303st_rook
strop77422243st_ro_p
stroud7310383st_roud
strouds837803st_rouds
strove95014793st_rove
strow88920573st_ro_w
strown96812093st_rown
stroy87720393st_ro_y
strums84716453st_rums
struts65616803st_ruts
stulls63912983st_ulls
stupors935883stupors
sturts63915143stur_ts
suberous10311793suberous
suers55128483suer__s
swells93913983swe_lls
swerves1377533swerves
swirls94010133swir_ls
symbols1435523symbols
tarocs84615663_tarocs
taroks106115283_taroks
taros55640823_taro_s
tarots66422993_tarots
taxols13328633_taxols
teals56234133_te_als
teels55726373_te_els
tells55828943_te_lls
telos55424523_telo_s
tels46841693_te__ls
tenons62916603_tenons
tenors63217753_tenors
tepals85415043_tepals
tepoys1137543_tepoys
terais64023513_terais
tercels94110363_tercels
terces83921413_terces
termly1138433_termly
termors94712773_termors
terms75523473_ter_ms
ternes65422903_ternes
terns55226873_ter_ns
terras63516973_terras
terrors73112213_terrors
tetryls1034643_tetryls
thiols95112763_thiols
throbs118311373_throbs
throes97518673_throes
throws129715233_throws
tirls54519803_tir_ls
tiros54524893_tiro_s
tools55325243_t_ools
toros54336193_toro_s
torous64319033_torous
triols66117803_triols
trogs67022603_t_rogs
trois57226093_t_rois
troll54416533_t_roll
trolls64613943_t_rolls
trots56629943_t_rots
trows88826183_t_rows
troys86418613_t_roys
tyros85118593_tyro_s
uterus639203uter_us
viosterols1352783viosterols
zeroes154314343_zeroes
zeros144918113_zero_s
zoosterols1952913zoosterols

Search took 9 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 Limit1340273527.90616952.6
3Display Results3523520.2501408.0
 (SQL Overall)1786913528.56220870.2
 
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.