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

225 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
stellar7261042(None) 
stelar64013861ste_lar
stella63612971stella_
stellas72813041stellas
cellar84514982_cellar
ocellar936532ocellar
patellar1046862patellar
rostellar943962rostellar
scutellar1142442scutellar
seller63824592s_eller
shellac1236692shellac
sheller103515882sheller
smeller94212782smeller
sneller73512842sneller
speller95415142speller
stealer72913972stealer
stela54019042ste_la_
stelae63716482ste_lae
stelai63912562ste_lai
stellate8310502stellate
stellular942732stellular
stiller73414292stiller
stylar9358112st_ylar
sweller103012462sweller
teller63519812_teller
areolar779223areolar
astylar10265063ast_ylar
atelier7311623atelier
avellan1037293avellan
axillar14247563axillar
castellan1144343castellan
cella75420313_cella_
cellae84915933_cellae
cellars93713693_cellars
collar83816173_collar
dollar74110983_dollar
dueller8329833dueller
dweller11297273dweller
fella84918653_fella_
fellah124910773_fellah
fellas95116963_fellas
feller94419553_feller
fueller10279963fueller
heller93322513_heller
hosteller1245833hosteller
lamellar1096493lamellar
medlar93010463_medlar
micellar12105573micellar
nucellar1044333nucellar
ostiolar844583ostiolar
paella8410913paella_
paellas9411413paellas
patella938953patella_
patellae1047623patellae
patellas1039103patellas
pedlar93311273_pedlar
pillar8314023_pillar
queller16289293queller
rostella845493rostella_
saltcellar1251803saltcellar
scalar83612433s_calar
scholar1236953scholar
scilla8310943scilla_
scillas9310473scillas
sculler99812153sculler
scutella1043553scutella_
sealer63928963s_ealer
sear47353843s_e__ar
secpar1037923s_ecpar
secular92211533secular
seggar8357813s_eggar
selah8319613s_e_lah
sell45840613s_ell__
selle54428313s_ell_e
sellers73721313s_ellers
selles64426983s_elles
sells55134433s_ell_s
selva83014273s_elva_
selvas93812913s_elvas
settler73410653settler
settlor7314733settlor
sewar85421093s_e_war
shear85424833she__ar
sheila969843sheila_
sheilas1059403sheilas
shell84424123shell__
shellack1745083shellack
shellacs1345573shellacs
shellbark1843023shellbark
shelled113815083shelled
shellers112812573shellers
shellier1138393shellier
shells94319523shell_s
shelly124414473shell_y
shelta93111793shelta_
sheltas10279673sheltas
shelter103214963shelter
shelver134211063shelver
siller64026063s_iller
similar937853similar
simular938673simular
skell94915833skell__
skells105013783skell_s
skellum1343853skellum
skelter113610003skelter
smaller93410333smaller
smear74416393sme__ar
smell74916233smell__
smelled103511853smelled
smellers10329763smellers
smellier1036793smellier
smells83914743smell_s
smelly114110363smell_y
smelter93311913smelter
snell54517303snell__
snelled83313043snelled
snells64614203snell_s
solar55927343s__olar
spaller92713473spaller
spear75821063spe__ar
specular12217613specular
spelean937123spelean
spell75020303spell__
spelled103714733spelled
spellers102812753spellers
spells84617683spell_s
spelter94113703spelter
spiller92914333spiller
stabler94014933stabler
stalag7310023st_alag
staler64025823st_aler
stalker113912253stalker
stall54722353stall__
stalled83515683stalled
stalls64019933stall_s
stalwart1147193stalwart
stapler93913633stapler
star48037763st___ar
stead65520273ste__ad
steak95219803ste__ak
steal56125473ste__al
stealage946583stealage
stealers83412203stealers
steals64020063steal_s
stealth1096453stealth
steam76322933ste__am
steamer93313093steamer
steel55721993steel__
steeled83513213steeled
steelie7310213steelie
steelier839183steelier
steels64117983steel_s
steely93612573steel_y
steelyard1342093steelyard
steeper93812773steeper
steer55423863ste__er
steerer73113633steerer
stele55026843ste_l_e
stelene7310253stelene
steles63725663ste_les
stelic8313083ste_lic
stellated1046803stellated
stellify1443883stellify
stellite839533stellite
stemma10328133stemma_
stemmas11256973stemmas
stemmer113210183stemmer
stemware1344873stemware
stengah1144563stengah
stentor739373stentor
stepper113010853stepper
sterlet71318473sterlet
sterna63712763sterna_
sternal73411913sternal
sterner7411913sterner
stertor7310083stertor
steward1138053ste_ward
stewpan1234193stewpan
stifler102911473stifler
still54922083still__
stilled83314783stilled
stillier868823stillier
stillman1043953stillman
stills64118573still_s
stilly93714093still_y
stipular1045843stipular
stollen747583stollen
stroller848173stroller
stull54916273stull__
stulls63912983stull_s
styler94013303st_yler
subalar9118073subalar
subcellar1343633subcellar
svelter10359673svelter
swear85316853swe__ar
swell84815983swell__
swelled113211693swelled
swells93913983swell_s
swelter103711173swelter
swiller103211663swiller
talar56225383_t_alar
taller63721963_taller
tear45242883_te__ar
tegular836603_tegular
tela45532973_te_la_
telae54323293_te_lae
telfer9379893_telfer
telia55821143_telia_
telial65815363_telial
tell44934703_tell__
tellers73717593_tellers
tells55828943_tell_s
telly84920823_tell_y
tellys9348843_tellys
templar1145643_templar
tesla55612603_tesla_
teslas64212173_teslas
tiller64222543_tiller
tolar55524113_t_olar
tollbar945453_tollbar
toller63819443_toller
tutelar735373tute_lar
umbellar1243643umbellar
velar85817633_ve_lar
yeller94214513_yeller

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.1401276364.3
2DLD Change Limit1340272256.97019229.1
3Display Results2252250.0762960.5
 (SQL Overall)1786912257.18624866.5
 
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.