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

321 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
stellas7281304(None) 
stella63612971stella_
stellar72610431stellar
fellas95116962_fellas
paellas9411412paellas
patellas1039102patellas
scillas9310472scillas
selles64426982s_elles
sells55134432s_ell_s
selvas93812912s_elvas
sheilas1059402sheilas
shellac1236692shellac
shellacs1345572shellacs
shells94319522shell_s
sheltas10279672sheltas
skells105013782skell_s
smells83914742smell_s
snells64614202snell_s
spells84617682spell_s
stalls64019932stall_s
steals64020062steal_s
steels64117982steel_s
stela54019042ste_la_
stelae63716482ste_lae
stelai63912562ste_lai
stelar64013862ste_lar
steles63725662ste_les
stellate8310502stellate
stemmas11256972stemmas
stills64118572still_s
stulls63912982stull_s
swells93913982swell_s
tells55828942_tell_s
tellys9348842_tellys
teslas64212172_teslas
abelias93213563abelias
akelas10311193ake_las
areolas71013863areolas
asterias8317013asterias
atlas55821583at__las
atolls65511353atoll_s
avellan1037293avellan
axillas14278963axillas
belgas9311713_belgas
belles85325993_belles
bells76432163_bell_s
callas84526753_callas
canellas10310563canellas
castellan1144353castellan
castellans1243583castellans
cella75420313_cella_
cellae84915933_cellae
cellar84514983_cellar
cellars93713693_cellars
cellos84517803_cellos
cells75428063_cell_s
challas124414123challas
chelas113817203che_las
chollas123811353chollas
dells66630943_dell_s
deltas74414823_deltas
duellos845763duellos
dwells10417713dwell_s
ells46431353__ell_s
entellus845173entellus
favellas1446163favellas
fella84918653_fella_
fellah124910773_fellah
fellahs13428393_fellahs
fells85327383_fell_s
hellos95321683_hellos
hells85032043_hell_s
hollas94616903_hollas
jellos134714283_jellos
jells125522163_jell_s
knells10439253knell_s
kvells13346613kvell_s
lamellas1098163lamellas
latillas847363latillas
mells75031333_mell_s
mullas84215933_mullas
niellos736143niellos
nigellas944723nigellas
novellas1176343novellas
obelias9279033obelias
ocellar936533ocellar
ocellus935983ocellus
ollas54218283__ollas
osteomas1045333osteomas
paella8410913paella_
patella938953patella_
patellae1047623patellae
patellar1046863patellar
psyllas1244883psyllas
queleas1636723queleas
quells15359703quell_s
retells73211523retell_s
rostella845493rostella_
rostellar943973rostellar
rubellas10136123rubellas
salals65120083s_alals
salpas85116923s_alpas
salsas65316133s_alsas
scalls84218203scall_s
scenas84114703sce_nas
scilla8310943scilla_
scleras948223scleras
sculls84613883scull_s
scutella1043553scutella_
scutellar1142443scutellar
seals54839693s_eal_s
seas45755273s_e__as
seels55632823s_eel_s
selah8319613s_e_lah
selahs9313213s_elahs
selfs85220243s_e_lfs
sell45840613s_ell__
selle54428313s_ell_e
seller63824603s_eller
sellers73721323s_ellers
sels46345983s_e_l_s
selva83014273s_elva_
selves94119613s_elves
sennas64214233s_ennas
sepals85217373s_epals
sepias83616103s_epias
settles73916003settles
sheals94420643sheal_s
sheas86331793she__as
sheila969843sheila_
shell84424123shell__
shellack1745083shellack
shellacks1844553shellacks
shelled113815093shelled
sheller103515893sheller
shellers112812583shellers
shelly124414473shell_y
shelta93111793shelta_
shelves134112093shelves
sheols94614163sheol_s
sherpas1238093sherpas
shigellas1343143shigellas
shills94519613shill_s
shtetls1034583shtetl_s
siennas736123siennas
sierras737863sierras
siestas738813siestas
sills55135993s_ill_s
silvas92912183s_ilvas
skell94915833skell__
skellum1343853skellum
skellums1443003skellums
skelms12368023ske_lms
skelps12407923ske_lps
skills104313923skill_s
skulls10429643skull_s
smalls84514123small_s
smegmas1233503smegmas
smell74916233smell__
smelled103511863smelled
smeller94212793smeller
smellers10329773smellers
smelly114110363smell_y
smelts85412773sme_lts
snell54517303snell__
snelled83313053snelled
sneller73512853sneller
snellest839493snellest
spalls84217343spall_s
speels85116393speel_s
speils84116223speil_s
spelean937123spelean
spell75020303spell__
spelled103714743spelled
speller95415153speller
spellers102812763spellers
spelts84614643spe_lts
spills84717463spill_s
squillas1745333squillas
stables93219073stables
stadias8411113stadias
stalag7310023st_alag
stalags838643stalags
stales65538293st_ales
stalks104614553st_alks
stall54722353stall__
stalled83515693stalled
stanzas1636363stanzas
stapelias1145103stapelias
staples93617213staples
stead65520273ste__ad
steads74116223ste_ads
steak95219803ste__ak
steaks104415853ste_aks
steal56125473ste__al
stealage946583stealage
stealages1046043stealages
stealer72913983stealer
stealers83412213stealers
stealth1096453stealth
stealths11104123stealths
steam76322933ste__am
steams84916903ste_ams
stedfast1243643stedfast
steeds73814883ste_eds
steeks103613703ste_eks
steel55721993steel__
steeled83513223steeled
steelie7310213steelie
steelies8312553steelies
steely93612573steel_y
steeples1038013steeples
steeps85215193ste_eps
steers63820983ste_ers
steeves103410903steeves
steins64818343ste_ins
stele55026843ste_l_e
stelene7310253stelene
stelic8313083ste_lic
stellated1046803stellated
stellify1443883stellify
stellite839533stellite
stellites938123stellites
stellular942733stellular
stemless1036653stemless
stemma10328133stemma_
stems75219953ste__ms
stengah1144563stengah
stengahs1243393stengahs
stenos63915773ste_nos
stents65019453ste_nts
steppes113110693steppes
steps76619883ste__ps
stereos74314973stereos
steres63929533ste_res
sterlet71318473sterlet
sterlets8169273sterlets
sterna63712763sterna_
sternal73411913sternal
sterns64616763ste_rns
sterols7313443sterols
stets55423913ste__ts
stewpan1234193stewpan
stewpans1343713stewpans
stews85519143ste__ws
sthenias1178163sthenias
stifles103013393stifles
stigmas10206643stigmas
stiles64328773st_iles
still54922083still__
stilled83314793stilled
stiller73414303stiller
stillest8311073stillest
stillman1043953stillman
stilly93714093still_y
stilts67915313st_ilts
stoas55126023st__oas
stoles63927673st_oles
stollen747593stollen
stollens835293stollens
stolons73410243stolons
stomas84816323st_omas
stools65117023stool_s
stratas73013583stratas
streels73811343streel_s
strettas846423strettas
strolls739183strolls
strumas9419833strumas
stull54916273stull__
stupas83910883st_upas
stylar9358113st_ylar
stylers10359353stylers
styles94418653st_yles
stylets10369213stylets
stylus9397463st_ylus
sulfas9311563s_ulfas
swell84815983swell__
swelled113211703swelled
sweller103012473sweller
swellest1137663swellest
swills94213363swill_s
sylvas12288173s_ylvas
tablas83716163_tablas
talas55935893_t_alas
tallis63319963_tallis
talls55133433_tall_s
teals56234133_teal_s
teas45851493_te__as
teels55726373_teel_s
teguas768013_teguas
tela45532973_te_la_
telae54323293_te_lae
telcos8710683_telcos
telegas837443_telegas
teles54536003_te_les
telia55821143_telia_
telial65815363_telial
tell44934703_tell__
teller63519823_teller
tellers73717603_tellers
tellies73820503_tellies
telly84920823_tell_y
telos55424523_te_los
tels46841693_te_l_s
tenias64720073_tenias
tepals85415043_tepals
tepas76521683_te_pas
terras63516973_terras
tesla55612603_tesla_
tetras63017623_tetras
texas126514933_te_xas
tills54631713_till_s
tolas54532773_t_olas
tolls54728433_toll_s
trellis739873trellis
tulles63218893_tulles
villas96117263_villas
vitellus1144143vitellus
wallas95719393_wallas
wells85426193_well_s
yells85821943_yell_s

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 Filter1786911340270.390458182.1
2DLD Change Limit1340273216.94019312.2
3Display Results3213210.1102918.2
 (SQL Overall)1786913217.44024017.6
 
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.