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

482 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
sphenes12301316(None) 
sphene113412401sphene_
spheres123114351spheres
achenes12313492achenes
apheses12610702apheses
ephebes1436152ephebes
ethenes103313872ethenes
penes75839222_p_enes
phones114121212_phones
saphenas1345712saphenas
scenes84520352s_cenes
schemes1489662schemes
serenes73222902serenes
sheens95116992s_heens
shends105313772s_hends
shines95028912s_hines
skenes104616632s_kenes
spahees1238262spahe_es
spences113413922sp_ences
spends94714472sp_ends
spense83912432sp_ense
spenses92913572sp_enses
sphenic1449092sphenic
sphere113313662sphere_
sphered133512312sphered
sphinges14267482sphinges
sphinxes20334402sphinxes
sphynxes23292422sphynxes
spines85132032sp_ines
spleens937102spleens
splents93912132splents
splines94718892splines
sprees85620642spre_es
achene11313813achene_
adheres11310163adheres
agenes74720253_agenes
akenes104817343_akenes
alkenes114212753alkenes
apexes1539133ap_exes
aphesis12610513aphesis
aphides134711203aphides
appends1236393appends
arenes64928393_arenes
aspens85013353asp_en_s
asthenies1278063asthenies
benes75536233__benes
butenes9313033butenes
camphenes1846463camphenes
chines115029173_chines
coheres122917693coheres
cohunes1249713cohunes
cymenes1477413cymenes
daphnes13327683daph_nes
denes65639723__denes
dienes75719903_dienes
enspheres1486083enspheres
epees75219833ep_e_es
ephebe1336063ephebe_
ephebos1444113ephebos
ephebus1443283ephebus
epicenes1249253epicenes
estheses1137783estheses
esthetes1147743esthetes
ethanes103713513ethanes
ethene93312923ethene_
ethynes13377573ethynes
genes65133093__genes
ghees95215553_ghe_es
gyrenes11267523gyrenes
haptenes133810823haptenes
hebes105521673__hebes
hemes105031083__hemes
henges104516463__henges
hens75642573__hen_s
hents87330743__hents
heres86245903__heres
hexes155123043__hexes
hones88144493__hones
hyphened2044693hyphened
hyphens1836043hyphen_s
imphees1436693imphe_es
indenes82916253indenes
inheres10315173inheres
inspheres1455403inspheres
isoprenes1146113isoprenes
ketenes114813503ketenes
lenes54738523__lenes
nenes55329673__nenes
oospheres1456633oospheres
opened94311863op_ened
opener83910993op_ener
openers9339493op_eners
openest9312913op_enest
opens76118553op_en_s
ophites12310103ophites
opines84820703op_ines
panes76148693_p_anes
pannes85522853_pannes
pedes85327293_p_edes
peened94318163_peened
peens76428193_peen_s
pees65257373_p_e_es
peeves113814873_peeves
pekes114623563_p_ekes
peles75738083_p_eles
pends85527193_p_ends
penis75129323_p_enis
pens65649643_p_en_s
peones83821043_peones
peres76246643_p_eres
phages125213513_phages
phases114618403_phases
phenates13611583_phenates
phenix1837133_phenix
phenixes2035643_phenixes
phenol1149253_phenol
phenols1238103_phenols
phenom1339473_phenom
phenoms1437813_phenoms
phenyl1435323_phenyl
phenyls1534333_phenyls
phizes20389133_phizes
phoebes1435813_phoebes
phone105621933_phone_
phoned124014553_phoned
phoney143612983_phoney
phoneys15437143_phoneys
phonies123717513_phonies
phonos114114793_phonos
phons105221143_phon_s
phosphenes2076553phosphenes
physes14399783_physes
pieces104217273_pieces
pinenes93416673pinenes
pines76048863_p_ines
planes85028083_planes
plebes104313623_plebes
plexes155313543_plexes
pones74547043_p_ones
preens85020113_preens
prees75937173_pre_es
prexes154915953_prexes
prezes173614693_prezes
prunes83419063_prunes
pschents1544113pschents
pyrenes123511223pyrenes
retenes76324623retenes
rhemes115913183_rhemes
sabines94318483sabines
safeness11239633safeness
sageness92111983sageness
salines74029413salines
sameness102712683sameness
saneness82313723saneness
sanes55649073s__anes
sapheads1466083sapheads
saphena1235863saphen_a
saphenae1344853saphenae
saphenous1444873saphenous
sapiences13116423sapiences
sapiens9310173sapien_s
sapients1037423sapients
sarees65329943sare_es
sateens73710753sateens
savines104417633savines
scenas84114703s_cenas
scends95213003s_cends
scene77220573s_cene_
scents85317023s_cents
schemas1468163schemas
scheme1379633scheme_
schemed1577753schemed
schemer1477963schemer
schemers1576713schemers
schmoes14308543schmoes
sciences1238773sciences
scones84521303s_cones
screens95212183screens
screes85023973scre_es
secedes103711983secedes
sees45361053s__e_es
seines65029903s_eines
sememes11109203sememes
semens84616973semen_s
semes75731583s__emes
sends65528243s__ends
sene46848053s__ene_
sense55526823s__ense
senses63923943s__enses
serene63522353serene_
serener73415763serener
serenest82717623serenest
seres55448893s__eres
serines74229543serines
sevens93813663seven_s
sexes126126223s__exes
shades105924533s_hades
shakes135024593s_hakes
shales94731253s_hales
shames114726223s_hames
shanks135315583s_hanks
shapes115124953s_hapes
shares95236413s_hares
shaves125224933s_haves
sheafs124912883s_heafs
sheals94420643s_heals
shears93820903s_hears
sheas86331793s_he_as
sheaves134412973s_heaves
sheds96122703s_he_ds
sheen85023313s_he_en
sheened113511703sheened
sheeney13398933sheeney
sheeneys14294903sheeneys
sheenies111411543sheenies
sheeny124912193s_heeny
sheep105321523s_he_ep
sheer84726893s_he_er
sheers94322403s_heers
sheesh1237813s_he_esh
sheet84836963s_he_et
sheets93918503s_heets
sheeves133911953sheeves
sheiks132510013s_heiks
shekel1338383s_hekel
shekels1436043s_hekels
shells94319523s_hells
shelves134112093s_helves
shend94719973s_hen_d
shent85933503s_hen_t
sheols94614163s_heols
sheqel1846523s_heqel
sheqels1934753s_heqels
sherds105614723s_herds
shes75734353s_h__es
shewed134716183s_hewed
shewer124515113s_hewer
shewers134312053s_hewers
shews115924713s_he_ws
shies86136553s_h_ies
shine85533093s_hine_
shined104620783s_hined
shiner93820873s_hiner
shiners104015943s_hiners
shins85131043s_hin_s
shires95225573s_hires
shives124921413s_hives
shmoes114612103s_hmoes
shoes85429663s_h_oes
shone83725983s_hone_
shores94830413s_hores
shotes95321913s_hotes
shoves124919423s_hoves
shrines104618693shrines
shuns85018143s_hun_s
shunts95712023s_hunts
shutes93518223s_hutes
shyness1344993s_hyness
sieges73816833s_ieges
sieves93216003s_ieves
signees83510803signees
silanes72517163silanes
silences10310073silences
silents73514493silents
silenus7369693silenus
silexes1438653silexes
sines55954823s__ines
siphoned1446413siphoned
siphons1239353siphon_s
sirees64624583sire_es
sirens65318153siren_s
sithens1039383sithen_s
skeanes113610713skeanes
skeens103912913skeen_s
skees95023123s_ke_es
skene96118123s_kene_
sklents11348163sklents
sleeves103311343sleeves
slieves10378963slieves
sneezes16278503sneezes
soleness8814263soleness
someones1039063someones
sones55444143s__ones
sophies12314623soph_ies
soreness8914793soreness
sowens93613153sowen_s
sozines16611263sozines
spaces104722633sp_aces
spades94222583sp_ades
spadones1137253spadones
spaeings11276253spaeings
spaes76029973sp__aes
spahee11313443spahe_e_
spales84728103sp_ales
spanks124514123sp_anks
spanned104111223spanned
spanner94312563spanner
spanners103710773spanners
spans74528733sp_an_s
spareness1139863spareness
spares84834553sp_ares
sparges104016343sparges
spates85028173sp_ates
spathes125116533spathes
spavies123012953spavies
spawned13316803spawned
spawner12347363spawner
spawners13396493spawners
spawns11577923spawn_s
spazzes1735263spazzes
speaks125114583sp_eaks
speaned103411523speaned
speans85417143sp_eans
spears84019473sp_ears
species11314133species
specks144312703sp_ecks
specs96916673sp_e_cs
speeches1537413speeches
speed85526623sp_e_ed
speeded113310423speeded
speeder103811073speeder
speeders11339313speeders
speedos10298263speedos
speeds94316053sp_eeds
speel74420763sp_e_el
speeled103712453speeled
speels85116393sp_eels
speer74623903sp_e_er
speered103614813speered
speers85019953sp_eers
speils84116223sp_eils
speirs85013233sp_eirs
speise84614253sp_eise
speises93813933speises
speiss84311643sp_eiss
spells84617683sp_ells
spelts84614643sp_elts
spence103813793sp_ence
spencer113610973sp_encer
spencers12269193sp_encers
spend85619333sp_en_d
spender103713693sp_ender
spenders113211743sp_enders
spendy124911143sp_endy
spent75532833sp_en_t
sperms102512603sp_erms
spewed125512333sp_ewed
spewer115112153sp_ewer
spewers124210663sp_ewers
spews105015923sp_e_ws
sphenoid1446323sphenoid
sphenoids1544673sphenoids
spheral1238423spheral
spheric14510073spheric
spherics1537073spherics
spherier1337783spherier
spheriest1438383spheriest
spherules1443823spherules
sphery14318883sphe_ry
sphinx1866203sphin_x
sphynx2152613sphyn_x
spices104326033sp_ices
spiegel1034553spiegel
spiegels1133873spiegels
spieled104811883spieled
spieler93111233spieler
spielers10319653spielers
spiels85317953spie_ls
spiered104412463spiered
spiers84421743spie_rs
spies76037623sp__ies
spikes124520713sp_ikes
spiles84227913sp_iles
spine76534423sp_ine_
spined95423943sp_ined
spinel85317333sp_inel
spinels94512443spinels
spinet85629753sp_inet
spinets94714813spinets
spinner93912263spinner
spinners103810863spinners
spinney12438923spinney
spinneys13335553spinneys
spinnies103210543spinnies
spins75327983sp_in_s
spiremes12397623spiremes
spires84628113sp_ires
spites84127333sp_ites
spitzes1849183spitzes
splakes1349673splakes
spleen8310263sple_en
spleeny1234563spleeny
splenia948313splenia
splenic1148663splenic
splenii945543splenii
splenius1046033splenius
splent84720193splen_t
splices113914383splices
spline86020533spline_
splined105013113splined
splints94511743splints
splores91910953splores
spodes94817433sp_odes
spokes124417213sp_okes
sponges10311043sponges
spooned103412443spooned
spooney12418243spooney
spooneys13314583spooneys
spoonies101911753spoonies
spoons84116023spoon_s
spores84726613sp_ores
spouses92912813spouses
sprangs104610053sprangs
spreads1039763spreads
spree74830863spre_e_
sprent84522383spren_t
springes114014033springes
springs104415923springs
sprints94113773sprints
sprites94220333sprites
spruces113810503spruces
sprues84515763sp_rues
spryness1334003spryness
spues75025383sp__ues
spumes1021314883sp_umes
spumones1254953spumones
spunks12349333sp_unks
spurges104111653spurges
spurned10339263spurned
spurner9269653spurner
spurners10288493spurners
spurns84811383spurn_s
stanes64933403s_tanes
steeves103410903steeves
steles63725663s_teles
stenos63915773s_tenos
stents65019453s_tents
steres63929533s_teres
sthenia1058503sthenia
sthenias1178163sthenias
sthenic1268903sthenic
stones65130033s_tones
styrenes11116623styrenes
subvenes1339633subvenes
suedes73918113s_uedes
sulphones1446063sulphones
supines94216383supines
supremes1238363supremes
sureness8912903sureness
swedes102711893s_wedes
sweeney13387003sweeney
sweeneys14294023sweeneys
sweenies11148763sweenies
sycees11409653syce_es
syphered1755013syphered
syphers15317273syphe_rs
syphoned1745733syphoned
syphons1537503syphon_s
syrens94911993syren_s
thanes94918983_thanes
thebes115914493_thebes
theines104013233_theines
themes115319253_themes
thens85921833_then_s
theres96525473_theres
theses96517973_theses
trienes74118413trienes
unspheres1455363unspheres
upends9438763up_ends
upheaps1494233upheaps
upheaves1643913upheaves
uphroes1236303uphroes
upsends10265293upsends
vahines133410523vahines
venenes102712133venenes
wahines133111173wahines
wheens124610613_wheens
whenas124610463_whenas
whens114618763_when_s
wheres125917433_wheres
whines125120103_whines
xylenes1745093xylenes

Search took 7 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 Limit1340274826.12621878.4
3Display Results4824820.1862591.4
 (SQL Overall)1786914826.71826598.8
 
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.