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

433 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
stella6361297(None) 
stela54019041ste_la
stellar72610421stellar
stellas72813041stellas
cella75420312_cella
fella84918652_fella
paella8410912paella
patella938952patella
rostella845492rostella
scilla8310942scilla
scutella1043552scutella
sell45840612s_ell_
selle54428312s_elle
sells55134432s_ells
selva83014272s_elva
sheila969842sheila
shell84424122shell_
shellac1236692shellac
shells94319522shells
shelly124414472shelly
shelta93111792shelta
skell94915832skell_
skells105013782skells
smell74916232smell_
smells83914742smells
smelly114110362smelly
snell54517302snell_
snells64614202snells
spell75020302spell_
spells84617682spells
stall54722352stall_
stalls64019932stalls
steal56125472steal_
steals64020062steals
steel55721992steel_
steels64117982steels
steely93612572steely
stelae63716482stelae
stelai63912562stelai
stelar64013862stelar
stele55026842ste_le
steles63725662steles
stelic8313082stelic
stellate8310502stellate
stemma10328132stemma
sterna63712762sterna
still54922082still_
stills64118572stills
stilly93714092stilly
stull54916272stull_
stulls63912982stulls
swell84815982swell_
swells93913982swells
tela45532972_te_la
telia55821142_telia
tell44934702_tell_
tells55828942_tells
telly84920822_telly
tesla55612602_tesla
abelia83114403abelia
abolla8410193abolla
akela9311343ake_la
areola6813673areola
asteria7316183asteria
atelic8313703atelic
atoll57913923atoll_
atolls65511353atolls
avellan1037293avellan
axilla13289573axilla
belga8313233_belga
bell66237183_bell_
belle75827833_belle
bells76432163_bells
belly104625493_belly
bulla74620563_bulla
calla74827073_calla
canella9310793canella
castellan1144343castellan
cell65031723_cell_
cellae84915933_cellae
cellar84514983_cellar
celli76717693_celli
cello74919583_cello
cells75428063_cells
challa114014193challa
chela103916803che_la
cholla113911023cholla
clitella1043673clitella
dell56938203_dell_
dells66630943_dells
delly96023873_delly
delta66117773_delta
duelli767003duelli
duello756783duello
dwell9519853dwell_
dwells10417713dwells
ell36735683__ell_
ells46431353__ells
favella1336173favella
fell76833073_fell_
fellah124910773_fellah
fellas95116963_fellas
fells85327383_fells
felly114922803_felly
haustella1242453haustella
hell75637893_hell_
hello86522983_hello
hells85032043_hells
holla84918493_holla
jell117125873_jell_
jello126716273_jello
jells125522163_jells
jelly154218253_jelly
kelly124617023_kelly
knell94210923knell_
knells10439253knells
kvell12436693kvell_
kvells13346613kvells
labella988943labella
lamella988613lamella
latilla737953latilla
mell64935613_mell_
mells75031333_mells
micella11106823micella
mulla74317113_mulla
nelly84618813_nelly
nielli636303nielli
niello636603niello
nigella844523nigella
novella1076213novella
obelia8329453obelia
ocellar936533ocellar
ocelli836843ocelli
olla44821173__olla
osteal6312963osteal_
osteoma945433osteoma
paellas9411413paellas
patellae1047623patellae
patellar1046863patellar
patellas1039103patellas
pepla9312863_pepla
psylla1133953psylla
pteryla1243303pteryla
quelea1547303quelea
quell144311433quell_
quells15359703quells
retell63813643retell_
retells73211523retells
rostellar943963rostellar
rubella9146523rubella
salal55425703s_alal
sall44544683s_all_
sally85129713s_ally
salpa75018353s_alpa
salsa56718923s_alsa
scall74420373scall_
scalls84218203scalls
scena74815783sce_na
scillas9310473scillas
sclera838893sclera
scull75315763scull_
sculls84613883sculls
scutellar1142443scutellar
sea36161293s_e__a
seal45654373s_eal_
seals54839693s_eals
seel45042983s_eel_
seeled73922093seeled
seels55632823s_eels
seely84522633s_eely
seemly1138433seemly
sel38253323s_e_l_
selah8319613s_elah
self75138293s_e_lf
selfs85220243s_elfs
seller63824593s_eller
selles64426983s_elles
sels46345983s_e_ls
selvas93812913s_elvas
senna54617983s_enna
sensa54117473s_ensa
sepal77723003s_epal
sepia75318673s_epia
septa75518083s_epta
sera46141393s_e_ra
seral56336383s_eral
seta45637313s_e_ta
setal56430903setal_
settle63915663settle
shall85024053shall_
shea76031573she__a
sheal84927703sheal_
sheals94420643sheals
sheilas1059403sheilas
shelf115221113she_lf
shellack1745083shellack
shellacs1345573shellacs
shelled113815083shelled
sheller103515883sheller
sheltas10279673sheltas
shelty124011553shelty
shelve124012763shelve
shelvy15377863shelvy
sheol84318373sheol_
sheols94614163sheols
sherpa1138093sherpa
shigella1243063shigella
shill85325333shill_
shills94519613shills
shtetl936443shtetl_
shtetls1034583shtetls
sienna647193sienna
sierra637313sierra
siesta639503siesta
sigla64515203s_igla
sill45545153s_ill_
sills55135993s_ills
silly84527623s_illy
silva82714023s_ilva
skellum1343853skellum
skelm114211293ske_lm
skelms12368023skelms
skelp114211423ske_lp
skelps12407923skelps
skill94316723skill_
skills104313923skills
skull94812033skull_
skulls10429643skulls
small74016263small_
smalls84514123smalls
smegma1134113smegma
smelled103511853smelled
smeller94212783smeller
smelt74726783sme_lt
smelts85412773smelts
snelled83313043snelled
sneller73512843sneller
sola45541863s__ola
solely93714213solely
spall74919303spall_
spalls84217343spalls
specula11187413specula
speel74420763speel_
speels85116393speels
speil75618643speil_
speils84116223speils
spelean937123spelean
spelled103714733spelled
speller95415143speller
spelt75430193spe_lt
spelts84614643spelts
speltz174010123speltz
spill74821163spill_
spills84717463spills
squilla1635533squilla
stable83921643stable
stably113314123stably
stadia7312143stadia
stalag7310023stalag
stale55637103st_ale
staled74728103staled
stalely1039213stalely
staler64025823staler
stales65538293stales
stalk94518003st_alk
stalks104614553stalks
stalky13499303stalky
stalled83515683stalled
stanza1537073stanza
stapelia1044673stapelia
staple84415823staple
statal61613223statal
stead65520273ste_ad
steads74116223steads
steady103510203steady
steak95219803ste_ak
steaks104415853steaks
stealage946583stealage
stealer72913973stealer
stealth1096453stealth
steam76322933ste_am
steams84916903steams
steamy115112373steamy
steed66024943ste_ed
steeds73814883steeds
steek95418003ste_ek
steeks103613703steeks
steeled83513213steeled
steelie7310213steelie
steep76020703ste_ep
steeple937323steeple
steeply1236293steeply
steeps85215193steeps
steer55423863ste_er
steers63820983steers
steeve93710903steeve
stein54620543ste_in
steins64818343steins
stelene7310253stelene
stellated1046803stellated
stellify1443883stellify
stellite839533stellite
stellular942733stellular
stem610628253ste__m
stemmas11256973stemmas
stemmy13417033stemmy
stems75219953ste_ms
stench114111163stench
stengah1144563stengah
steno54716863ste_no
stenos63915773stenos
stent55634513ste_nt
stents65019453stents
step67126293ste__p
steppe10319873steppe
steps76619883ste_ps
stere55328543ste_re
stereo65317913stereo
steres63929533steres
steric8317063steric
sterile7316603sterile
sterlet71318473sterlet
stern55319123ste_rn
sternal73411913sternal
sternly1037853sternly
sterns64616763sterns
sterol6613333sterol
sterols7313443sterols
stet45947323ste__t
stets55423913ste_ts
stew77525463ste__w
stewed104814243stewed
stewpan1234193stewpan
stews85519143ste_ws
stewy116112063ste_wy
stey76224413ste__y
sthenia1058503sthenia
stifle93611903stifle
stigma9226763stigma
stile54931573st_ile
stiles64328773stiles
stilled83314783stilled
stiller73414293stiller
stillman1043953stillman
stilt54831983st_ilt
stilts67915313stilts
stoa45425913st__oa
stole54928813st_ole
stoled74521593stoled
stolen64315063stolen
stoles63927673stoles
stolid74213183stolid
stollen747583stollen
stolon64112073stolon
stoma75918273st_oma
stomal85213313stomal
stool55619893stool_
stools65117023stools
strata63616283strata
streel64214023streel_
streels73811343streels
stretta737293stretta
stria55723213st_ria
stroll6311603stroll
strolls739183strolls
stroma84313073stroma
struma84313273struma
studly10397693studly
stupa74112313st_upa
stylar9358113stylar
style85519363st_yle
styled105613103styled
styler94013303styler
styles94418653styles
stylet94018573stylet
styli83911173st_yli
stylus9397463stylus
sulfa8313923s_ulfa
sully84622903s_ully
svelte9319753svelte
swelled113211693swelled
sweller103012463sweller
swill83417373swill_
swills94213363swills
sylva11268443s_ylva
tabla73318363_tabla
tala45938053_t_ala
tall47240213_tall_
talls55133433_talls
tally84526863_tally
tea37353323_te__a
teal45546503_teal_
teals56234133_teals
tecta74215523_tecta
teel46335803_teel_
teels55726373_teels
tegua6109563_tegua
tel35647903_te_l_
telae54323293_telae
telco7511873_telco
tele45040873_te_le
telega736773_telega
teles54536003_teles
telex125214823_telex
telial65815363_telial
telic76019823_telic
teller63519813_teller
tellys9348843_tellys
teloi54217383_teloi
telos55424523_telos
tels46841693_te_ls
tenia55324483_tenia
tepa66021683_te_pa
tepal76319583_tepal
terga63315643_terga
terra54419663_terra
teslas64212173_teslas
testa54822043_testa
tetra53417953_tetra
till45941203_till_
tills54631713_tills
tola45236333_t_ola
toll45535263_toll_
tolls54728433_tolls
tulle54019933_tulle
vela75725543_ve_la
villa85321233_villa
walla85321033_walla
well75832043_well_
wells85426193_wells
welly114620013_welly
yell76028323_yell_
yells85821943_yells

Search took 6 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.376475242.0
2DLD Change Limit1127164334.76623650.0
3Display Results4334330.1403092.9
 (SQL Overall)1786914335.28233830.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.