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

494 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
sphene11341240(None) 
sphenes123013161sphenes
sphere113313661sphere
achene11313812achene
ephebe1336062ephebe
ethene93312922ethene
phone105621932_phone
saphena1235862saphena
saphenae1344852saphenae
scene77220572s_cene
scheme1379632scheme
sene46848052s__ene
serene63522352serene
sheen85023312s_heen
shend94719972s_hend
shent85933502s_hent
shine85533092s_hine
shone83725982s_hone
skene96118122s_kene
spahee11313442spahe_e
spence103813792sp_ence
spend85619332sp_end
spense83912432sp_ense
spent75532832sp_ent
sphenic1449092sphenic
sphered133512312sphered
spheres123114352spheres
sphery14318882sphery
sphinx1866202sphinx
sphynx2152612sphynx
spine76534422sp_ine
spleen8310262spleen
splent84720192splent
spline86020532spline
spree74830862spre_e
sprent84522382sprent
achenes12313493achenes
adhere10310333adhere
agene65621583_agene
akene95818663_akene
alkene104114003alkene
apheses12610703apheses
apiece10510083apiece
append1138273append
arene55329413_arene
ashen87818673ashen_
aspen75216093asp_en_
aspens85013353asp_ens
astheny1345293astheny
bene66439493__bene
butene8312623butene
camphene1746613camphene
chine105231723_chine
cohere112716993cohere
cohune1189423cohune
cymene1377393cymene
daphne12237013daph_ne
dene56643413__dene
diene65720133_diene
ensphere1366083ensphere
eocene8311613eocene
epee64628503ep_e_e
ephebes1436153ephebes
ephebi1345083ephebi
epicene1148593epicene
epigene1037893epigene
esthete1047433esthete
ethane94613243ethane
ethenes103313873ethenes
ethyne12407153ethyne
gene56237223__gene
ghee85726113_ghe_e
gyrene10227243gyrene
haptene123810933haptene
hebe96424703__hebe
heme95034413__heme
hen67555273__hen_
hence104920053__hence
henge94819833__henge
hens75642573__hens
hent76656383__hent
here76447103__here
hone77549323__hone
hyphen1736393hyphen_
hyphened2044693hyphened
hyphens1836043hyphens
imphee13310353imphe_e
indene73215373indene
inhere9313713inhere
insphere1355973insphere
isoprene1045613isoprene
ketene106613003ketene
nene45932063__nene
ochone11311293ochone
oosphere1355993oosphere
open66427003op_en_
opened94311863op_ened
opener83910993op_ener
opens76118553op_ens
ophite11410563ophite
opine77422463op_ine
pane64950293_p_ane
panne76623653_panne
pee56066513_p_e_e
peen65938083_peen_
peened94318163_peened
peens76428193_peens
peeve104915253_peeve
peke105926203_p_eke
pele65539553_p_ele
pen56558843_p_en_
pence94924453_p_ence
pend75934533_p_end
penes75839223_p_enes
penne75423853_penne
pens65649643_p_ens
pent66559073_p_ent
pere66450263_p_ere
phage115113673_phage
phase104617213_phase
phenate12412203_phenate
phenix1837133_phenix
phenol1149253_phenol
phenom1339473_phenom
phenyl1435323_phenyl
phew128417113_phe_w
phoebe1335003_phoebe
phon95925383_phon_
phoned124014553_phoned
phones114121213_phones
phoney143612983_phoney
phono104917023_phono
phons105221143_phons
phony136715443_phony
phosphene1996243phosphene
phyle134111153_phyle
piece96717993_piece
pine67755713_p_ine
pinene82915653pinene
plane74929143_plane
plebe95014873_plebe
plena75816393_plena
pone65747533_p_one
pree67044733_pre_e
preen75925053_preen
prese75228383_prese
prone75332623_prone
prune75119633_prune
pschent1437413pschent
pyrene113210733pyrene
retene69224273retene
rheme106214053_rheme
sabine84020393sabine
saline65132703saline
sane45954343s__ane
saphead1357773saphead
saphenas1345713saphenas
sapience12106613sapience
sapiens9310173sapiens
sapient9415343sapient
saree55044663sare_e
sateen63815013sateen
savine94220283savine
scalene9310773scalene
scena74815783s_cena
scend85516293s_cend
scenes84520353s_cenes
scent75831623s_cent
schema1388373schema
schemed1577753schemed
schemer1477963schemer
schemes1489663schemes
schmoe13328333schmoe
science1138793science
scone74621833s_cone
scree720031713scre_e
screen85216023screen
secede93311993secede
see35772263s__e_e
seen46943123s_een_
seine55732873s_eine
seme65836653s__eme
sememe10129983sememe
semen75724103semen_
semens84616973semens
sen36058523s__en_
send55237293s__end
sense55526823s__ense
sent46963013s__ent
sente56432883s__ente
sere46153473s__ere
serener73415763serener
serenes73222903serenes
serine65432673serine
seven84118313seven_
sevens93813663sevens
severe94016083severe
shade95125583s_hade
shake124726403s_hake
shale85332833s_hale
shame105726703s_hame
shank125422193s_hank
shape105125113s_hape
share86437083s_hare
shave114425893s_have
she66837693s_h__e
shea76031573s_he_a
sheaf115424123s_heaf
sheal84927703s_heal
shear85424833s_hear
sheas86331793s_heas
sheave124514003s_heave
shed86536153s_he_d
sheds96122703s_heds
sheened113511703sheened
sheeney13398933sheeney
sheenie10159493sheenie
sheens95116993sheens
sheeny124912193sheeny
sheep105321523s_heep
sheer84726893s_heer
sheet84836963s_heet
sheeve123412843sheeve
sheik122514663s_heik
shekel1338383s_hekel
shelf115221113s_helf
shell84424123s_hell
shelve124012763s_helve
shends105313773s_hends
sheol84318373s_heol
sheqel1846523s_heqel
sherd96321153s_herd
shes75734353s_he_s
shew108030763s_he_w
shewed134716183s_hewed
shewer124515113s_hewer
shewn115715703s_hewn
shews115924713s_hews
shin75634313s_hin_
shined104620783s_hined
shiner93820873s_hiner
shines95028913s_hines
shins85131043s_hins
shiny115122143s_hiny
shire84727133s_hire
shive114423423s_hive
shoe75933443s_h_oe
shore85432653s_hore
shote85526103s_hote
shove114421043s_hove
shrine94920053shrine
shun75122773s_hun_
shuns85018143s_huns
shunt85226513s_hunt
shute84520353s_hute
siege66718443s_iege
sieve84918843s_ieve
signee73617233signee
silane62718053silane
silence9310223silence
sileni63312143sileni
silent64125843silent
sine46560623s__ine
siphon1138463siphon_
siphoned1446413siphoned
siphons1239353siphons
siree55238813sire_e
siren54525823siren_
sirens65318153sirens
sithence1344793sithence
sithens1039383sithens
skeane104611373skeane
skee85431473s_ke_e
skeen94817403skeen_
skeens103912913skeens
skenes104616633s_kenes
sklent103614353sklent
sleeve93411593sleeve
slieve9359273slieve
sneeze15318523sneeze
soigne74310033soigne
someone938813someone
sone46649983s__one
sowens93613153sowens
sozine15712353sozine
space95325673sp_ace
spade84423323sp_ade
spae65034323sp__ae
spaed85522273spae_d
spaeing103413543spaeing
spaes76029973spae_s
spahees1238263spahees
spake114322743sp_ake
spale74929213sp_ale
span65234663sp_an_
spang84919733sp_ang
spank115919573sp_ank
spanned104111223spanned
spanner94312563spanner
spans74528733sp_ans
spare75135563sp_are
sparge94216053sparge
sparse84516343sparse
spate74731583sp_ate
spathe115115693spathe
spavie113611383spavie
spawn107811713spawn_
spawned13316803spawned
spawner12347363spawner
spawns11577923spawns
speak114618673sp_eak
spean74620513sp_ean
speaned103411523speaned
speans85417143speans
spear75821063sp_ear
spec85821973sp_e_c
specie10412223specie
speck135115653sp_eck
specs96916673sp_ecs
sped76031493sp_e_d
speech1347563speech
speed85526623sp_eed
speeded113310423speeded
speeder103811073speeder
speedo94011993speedo
speeds94316053speeds
speedy1218410793speedy
speel74420763sp_eel
speeled103712453speeled
speels85116393speels
speer74623903sp_eer
speered103614813speered
speers85019953speers
speil75618643sp_eil
speir75315363sp_eir
speise84614253speise
spell75020303sp_ell
spelt75430193sp_elt
spencer113610973sp_encer
spences113413923sp_ences
spender103713693sp_ender
spends94714473sp_ends
spendy124911143sp_endy
spenses92913573sp_enses
sperm93216023sp_erm
spew95421873sp_e_w
spewed125512333sp_ewed
spewer115112153sp_ewer
spews105015923sp_ews
sphenoid1446323sphenoid
spheral1238423spheral
spheric14510073spheric
spherier1337783spherier
sphering142811943sphering
spherule1343843spherule
sphinges14267483sphinges
sphinxes20334403sphinxes
sphynxes23292423sphynxes
spicae104313703spicae
spice95528813sp_ice
spied85427713spie_d
spiegel1034553spiegel
spiel74623913spie_l
spieled104811883spieled
spieler93111233spieler
spiels85317953spiels
spier75728033spie_r
spiered104412463spiered
spiers84421743spiers
spies76037623spie_s
spike114922843sp_ike
spile75230083sp_ile
spin66231303sp_in_
spined95423943spined
spinel85317333spinel
spines85132033spines
spinet85629753spinet
spinner93912263spinner
spinney12438923spinney
spinny114510183spinny
spins75327983sp_ins
spiny104921303sp_iny
spire75828693sp_ire
spireme11478363spireme
spite75430663sp_ite
splake1259783splake
spleens937103spleens
spleeny1234563spleeny
splenia948313splenia
splenic1148663splenic
splenii945543splenii
splents93912133splents
splice104915103splice
splined105013113splined
splines94718893splines
splint85223283splint
splore81611303splore
spode84617703sp_ode
spoke114818663sp_oke
spoken124610003spoken_
sponge939663sponge
spoon74719443spoon_
spooned103412443spooned
spooney12418243spooney
spoons84116023spoons
spoony114111793spoony
spore75428593sp_ore
spouse84112513spouse
sprang95713523sprang
spread9312533spread
sprees85620643sprees
spring94526013spring
springe103913983springe
sprint84526793sprint
sprite84421773sprite
spruce103910873spruce
sprue74717633sp_rue
sprung94610033sprung
spue66025523sp__ue
spued84918473spue_d
spues75025383spue_s
spuing94313363spuing
spume95817313sp_ume
spumone1154383spumone
spun66221463sp_un_
spunk114513403sp_unk
spurge93711323spurge
spurn74815453spurn_
spurned10339263spurned
spurner9269653spurner
spurns84811383spurns
spying123913253spying
stane55933003s_tane
steeve93710903steeve
stele55026843s_tele
stelene7310253stelene
steno54716863s_teno
stent55634513s_tent
stere55328543s_tere
sthenia1058503sthenia
sthenic1268903sthenic
stone55431183s_tone
styrene10116693styrene
subvene1238493subvene
suede64419753s_uede
sulphone1345983sulphone
supine84216693supine
supreme1137893supreme
swede94413203s_wede
sweeney13387003sweeney
sweeny12358843sweeny
swine85625303s_wine
sycee105018623syce_e
syne75725763s__yne
sypher14317083syphe_r
syphered1755013syphered
syphers15317273syphers
syphon1436853syphon_
syphoned1745733syphoned
syphons1537503syphons
syren85216743syren_
syrens94911993syrens
thane86122533_thane
thebe107515433_thebe
thee78039063_the_e
theine94814923_theine
theme105921733_theme
then78429693_then_
thence112010853_thence
thens85921833_thens
there87527393_there
these86519013_these
thine85026863_thine
triene64316383triene
unsphere1355853unsphere
upend85011043up_end
upheap13105213upheap
upheave1544023upheave
upheld12115563upheld
uphove1436133uphove
uphroe1136083uphroe
upsend9356883upsend
upsent83314063upsent
vahine123612113vahine
venene92912523venene
wahine123813013wahine
whee105429593_whe_e
wheen115016053_wheen
when105723043_when_
whence14187933_whence
whens114618763_whens
where117019423_where
whine116022813_whine
xylene1645793xylene

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.393454684.5
2DLD Change Limit1127164945.26321416.7
3Display Results4944940.1563166.7
 (SQL Overall)1786914945.81230745.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.