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

147 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
sphenic144909(None) 
spheric14510071spheric
splenic1148661splenic
sthenic1268901sthenic
aphetic142912852aphetic
aphonic142713392aphonic
aspheric1547982aspheric
asthenic1378632asthenic
ephebic1646512ephebic
euphenic1557202euphenic
hyphenic2147012hyphenic
phenix1837132_phenix
phonic133315212_phonic
phrenic1438772_phrenic
scenic10510512s_cenic
selenic9410662selenic
siphonic1547982siphonic
sphene113412402sphen_e
sphenes123013162sphenes
sphenoid1446322sphenoid
spherics1537072spherics
splenia948312splenia
splenii945542splenii
sthenia1058502sthenia
aphasic142810063aphasic
aphelia1249423aphelia
aphesis12610513aphesis
aphonia122711883aphonia
aphonics15259523aphonics
aphotic142913123aphotic
apneic1078623apne_ic
arsenic939323arsenic
asthenia1167713asthenia
asthenics1486403asthenics
axenic154210003_axenic
chemic153012093_chemic
dysphonic2044593dysphonic
edenic9310223_edenic
eirenic939003eirenic
ephebi1345083ephebi_
epigenic1347483epigenic
esthetic13119773esthetic
etheric12311783etheric
ethnic1148853eth_nic
eugenic1038603eugenic
euphenics16115363euphenics
euphonic15117813euphonic
galenic1038693galenic
genic85119393__genic
haptenic1545763haptenic
hemic125718623__hemic
hyaenic1545993hyaenic
hyenic1438723_hyenic
irenic8311103_irenic
ischemic1744673ischemic
isogenic11178143isogenic
ophitic1439213ophitic
opsonic1137253opsonic
panic93923903_p_anic
penis75129323_p_enis
phasic133612053_phasic
phatic133014413_phatic
phenetic1549203_phenetic
phenol1149253_phenol
phenolic1546813_phenolic
phenom1339473_phenom
phenyl1435323_phenyl
phenylic1844483_phenylic
phobic153010073_phobic
phoenix1944363_phoenix
phonics143110723_phonics
photic133316443_photic
phylic16279553_phylic
physic16288473_physic
pianic103714123_pianic
picnic123410263_picnic
pionic103515953_pionic
pleonic1139433_pleonic
poetic10416843_poetic
pyemic1537893_pyemic
pyknic1734893_pyknic
ruthenic1345133ruthenic
sachemic1746083sachemic
saphena1235863saphen_a
saphenae1344853saphenae
saphenas1345713saphenas
sapremic1445333sapremic
satanic939933satanic
scenics1137773s_cenics
sememic1336503sememic
sepic94617053s__epic
sheenie10159493sheenie
sheik122514663s_he_ik
shend94719973s_hen_d
shends105313773s_hends
shent85933503s_hen_t
sherif122915243s_herif
sileni63312143sileni_
sonic75225293s__onic
spaeing103413543spaeing
spastic11310383spastic
spathic1437543spathic
spec85821973sp_e__c
specie10412223sp_ecie
speil75618643sp_e_il
speir75315363sp_e_ir
spence103813793sp_ence
spend85619333sp_en_d
spends94714473sp_ends
spendy124911143sp_endy
spense83912433sp_ense
spent75532833sp_en_t
spermic1338523spermic
sphenoids1544673sphenoids
spheral1238423spheral
sphere113313663sphe_re
sphered133512313sphered
spheres123114353spheres
spherical1645803spherical
spherier1337783spherier
sphering142811943sphering
spheroid1447283spheroid
sphery14318883sphe_ry
sphingid1543743sphingid
sphinx1866203sphin_x
sphygmic2141973sphygmic
sphynx2152613sphyn_x
spic85227433sp___ic
splendid1244643splendid
splenetic1345073splenetic
splenial1047183splenial
splenium1246473splenium
splenius1046033splenius
splent84720193splen_t
splents93912133splents
sprent84522383spren_t
sputnik1372273sputnik
stannic936663stannic
stelic8313083s_telic
steric8317063s_teric
sthenias1178163sthenias
suberic11312213suberic
symphonic2146073symphonic
syngenic1445823syngenic
thetic11412893_thetic
typhonic1847173typhonic
xenic144114643__xenic

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.406440125.6
2DLD Change Limit1340271477.12318816.1
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.59223536.7
 
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.