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

420 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
sterol661332(None) 
sterols7313441sterols
nerol51017812_nerol
petrol82714062petrol
safrol937282safrol
seral56336382s_eral
serow86720442s_erow
sheol84318362she_ol
stanol6310722stanol
steal56125472ste_al
steel55721992ste_el
steno54716862steno_
stenos63915772stenos
stere55328542ster_e
stereo65317912stereo
stereos74314972stereos
steres63929532steres
steric8317062steric
sterile7316602sterile
stern55319122ster_n
sterna63712762sterna
sternal73411902sternal
sternly1037852sternly
sterns64616752sterns
steroid81314852steroid
stertor7310082stertor
stool55619892st_ool
streel64214022streel
stroll6311602st_roll
strop77422242st_rop
strow88920572st_row
stroy87720392st_roy
acerola947823acerola
aero45435343_aero_
apteral9311523apteral
aster55434893aster__
asteria7316173asteria
astern64815813aster_n
asternal858313asternal
asteroid9511173asteroid
asters65631603aster_s
astral66919283ast_ral
beryl101211673_beryl
carol75128613_carol
ceorl7410913_ceorl
cero66329453_cero_
ceros74726073_ceros
cresol8310203cresol
emerod9139213emerod
enol45823823__enol
enrol51014283_enrol
enteral73516433enteral
enteron7313333enteron
eros45238453__eros
ester54727713ester__
esters64627733ester_s
estral64716513est_ral
estriol747553estriol
eternal72910893eternal
eterne6311723eterne
feral85424653_feral
herl75834553_her_l
hero74635783_hero_
heron85025503_heron
heros84930863_heros
hetero9312633hetero_
heteros10312683heteros
iterum837903iterum
ketol95414003_ketol
lateral7313563lateral
literal7613263literal
merl65830973_mer_l
metol75917813_metol
metro74718803metro_
metros84217803metros
neroli61111153_neroli
nerols6914883_nerols
operon8811773operon
osteal6312953oste_al
parol74826273_parol
patrol83213023patrol
peril75425953_peril
petrel83111533petrel
petrols92913083petrols
phenol1149253phenol
pterin81014153pterin
pteryla1243303pteryla
pyrrol1136273pyrrol
reroll6412683_reroll
retool63914483retool
retral64419743retral
retro55020953retro_
retros63820193retros
sacral83414413sacral
safrole1037253safrole
safrols1036863safrols
salol55222143s_alol
santero7311133santero_
santeros8311193santeros
santol64515243santol
sarod65325873s_arod
saros55238063s_aros
saurel6511983saurel
school11410723school
schorl1179803schorl
schrod1247883schrod
scleral937863scleral
scrod85115063s_crod
scroll8310163s_croll
seal45654373s_e_al
seel45042983s_e_el
seer45547043seer__
seers55136383seer_s
sego56525183s_ego_
segos64919483s_egos
sel38253323s_e__l
sell45840613s_e_ll
senor53822793s_enor
sepal77723003s_epal
sepoy10314303s_epoy
ser36752403s_er__
sera46141393s_er_a
serac75925203s_erac
serai56830163s_erai
serail64222673s_erail
sere46153473s_er_e
sered65737293s_ered
serer55935503s_erer
seres55448893s_eres
serf76340113s_er_f
serfs84922013s_erfs
serge64727463s_erge
serial64625853s_erial
serif84132123s_erif
serin55434443s_erin
sermon8413553s_ermon
serosa6313023s_erosa
serosal7311143s_erosal
serous65023563s_erous
serows96016393s_erows
serry84824123s_erry
sers45746653s_er_s
serum75223473s_erum
serval93913413s_erval
serve85425963s_erve
servo84516683s_ervo
servos93812723s_ervos
setal56430903s_etal
seton55223543s_eton
several1039533several
sheal84927703she_al
shekel1338383shekel
shell84424123she_ll
sheols94614153she_ols
sheqel1846523sheqel
sherd96321153sher_d
sherds105614723sherds
sherif122915233sherif
sheroot10414373sheroot
sherpa1138093sherpa
sherry124510413sherry
shool84523143s_hool
shorl84720243shor_l
shtetel1033933shtetel
shtetl936433shte_tl
sierra637313sierra
skatol1035713skatol
skell94915833ske_ll
skerry13356103skerry
skirl96012913skir_l
smell74916233sme_ll
smerk115412723smer_k
smerks12449713smerks
snarl54921083snar_l
snell54517303sne_ll
snool55118643s_nool
sokol94612283s_okol
sol37256623s___ol
sorel56231443s_orel
sorrel6413543sorrel
sorrow9339443sorrow
sotol54917643s_otol
speel74420763spe_el
speil75618643spe_il
spell75020303spe_ll
sperm93216013sper_m
sperms102512603sperms
spheral1238423spheral
spiral83715343spiral
spool75219043s_pool
sporal82915453sporal
stall54722353st_all
stanols739733stanols
star48037763star__
starch113013203starch
stardom1037763stardom
stare54440263star_e
stared75429873stared
starer64027363starer
stares66038753stares
stark95425623star_k
starkly14277033starkly
starry94911673starry
stars55836573star_s
start55642313star_t
startle72511123startle
starts65423123starts
starve94613743starve
statal61613223statal
stator64015473stator
stead65520273ste_ad
steads74116223steads
steady103510203steady
steak95219803ste_ak
steaks104415853steaks
steals64020063steals
steam76322923ste_am
steamroll1152103steamroll
steams84916903steams
steamy115112373steamy
stearic939423stearic
stearin7312003stearin
steed66024943ste_ed
steeds73814883steeds
steek95418003ste_ek
steeks103613703steeks
steels64117983steels
steely93612573steely
steep76020703ste_ep
steeple937323steeple
steeply1236293steeply
steeps85215193steeps
steer55423863ste_er
steered83615253steered
steerer73113633steerer
steers63820983steers
steeve93710903steeve
stein54620533ste_in
steins64818343steins
stela54019043ste_la
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stele55026843ste_le
steles63725663steles
stelic8313083stelic
stella63612973stella
stem610628243ste__m
stemma10328133stemma
stemmy13417033stemmy
stems75219953ste_ms
stemson945163stemson
stench114111163stench
stencil946893stencil
stenoky1444253stenoky
stent55634513ste_nt
stentor739373stentor
stents65019453stents
step67126293ste__p
steppe10319873steppe
steps76619883ste_ps
stepson945663stepson
stereoed937883stereoed
sterical10311243sterical
sterlet71318473sterlet
sterner7411913sterner
sternson844833sternson
sternum947733sternum
steroidal1045463steroidal
steroids9911433steroids
stertors8310903stertors
stet45947323ste__t
stets55423913ste_ts
stetson745783stetson
stew77525463ste__w
stewed104814243stewed
stews85519143ste_ws
stewy116112063ste_wy
stey76224413ste__y
still54922073st_ill
stipel84412123stipel
stir45723243stir__
stirk95717413stir_k
stirks104914233stirks
stirp76815503stir_p
stirps85011813stirps
stirs55921613stir_s
stoa45425913st__oa
stob66724613st__ob
stole54928813st__ole
stolon64112063stolon
stomal85213313stomal
stood65517713st_ood
stook95218213st_ook
stools65117023st_ools
stoop75821543st_oop
stop66532033st__op
storax1389783storax
store56333813stor_e
stored75524213stored
storer64721673storer
stores65533643stores
storey95217613storey
stork96819693stor_k
storks106115933storks
storm76520373stor_m
storms85814603storms
stormy115510723stormy
story86723033stor_y
stot46347323st__ot
stow77325743st__ow
strap77925263st_rap
straw813321293st_raw
stray88525573st_ray
streak104613623streak
stream84717283stream
streek104111413streek
streels73811343streels
street64125773street
strep77120853st_rep
streps86218063streps
stress66616673stress
strew89220653st_rew
strewn96710003strewn
strews96817093strews
stria55723203st_ria
strip77524333st_rip
strobe84513813st_robe
strobil936953st_robil
strode75215973st_rode
stroke105116173st_roke
strolls739183st_rolls
stroma84313073st_roma
stromal93010583st_romal
strong74914883st_rong
strook10410303strook
strops86220383st_rops
stroud7310383st_roud
strove95014793st_rove
strown96812093st_rown
strows96718273st_rows
stroys95914603st_roys
strum75619443st_rum
strut56030733st_rut
stull54916273st_ull
stupor836013stupor
sturdy1037043sturdy
sturt56028963stur_t
sturts63915143sturts
styrax1675243styrax
suer45334033suer__
suers55128483suer_s
sural55931263s_ural
sutural7310223sutural
swell84815983swe_ll
swerve1256293swerve
swirl84514143swir_l
symbol1336083symbol
taro46846913_taro_
taroc75721643_taroc
tarok97921073_tarok
taros55640823_taros
tarot55943933_tarot
taxol124011363_taxol
teal45546503_te_al
teel46335803_te_el
tel35647903_te__l
tell44934703_te_ll
teloi54217383_teloi
telos55424523_telos
tenon53320513_tenon
tenor53620253_tenor
tepal76319583_tepal
tepoy10312163_tepoy
terai53525483_terai
terce75721843_terce
tercel83612993_tercel
terga63315643_terga
tergal72912833_tergal
term66233153_ter_m
termly1138433_termly
termor84412513_termor
terms75523473_terms
tern46134803_ter_n
terne56426153_terne
terns55226873_terns
terra54419653_terra
terror63811723_terror
terry84721873_terry
terse55026823_terse
tetryl935693_tetryl
thiol87616043_thiol
thro77726423_thro_
throb109816853_throb
throe89321423_throe
throw118719733_throw
tirl45029923_tir_l
tiro46832363_tiro_
tiros54524893_tiros
tool46735683_t_ool
toro48045683_toro_
toros54336193_toros
torot56139943_torot
triol55521363_triol
trod57627953_t_rod
trog57628213_t_rog
troll54416533_t_roll
trop66833303_t_rop
trot46351313_t_rot
trow78031423_t_row
troy77429683_t_roy
tyro76622363_tyro_
tyros85118593_tyros
uteri51012983uter_i
uterus639193uterus
viosterol1242843viosterol
xerox1138623_xerox
zero134822463_zero_
zeros144918103_zeros
zoosterol1842863zoosterol

Search took 8 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.283631417.0
2DLD Change Limit1127164206.64016975.3
3Display Results4204200.1403000.0
 (SQL Overall)1786914207.06325299.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.