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

535 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
spheres12311435(None) 
sphenes123013161sphenes
sphere113313661sphere_
sphered133512311sphered
adheres11310162adheres
apheses12610702apheses
coheres122917692coheres
enspheres1486082enspheres
ephebes1436152ephebes
heres86245902__heres
inheres10315172inheres
inspheres1455402inspheres
oospheres1456632oospheres
peres76246642_p_eres
schemes1489662schemes
seres55448892s__eres
shares95236412s_hares
sheers94322402s_heers
sherds105614722s_herds
shires95225572s_hires
shores94830412s_hores
spahees1238262spahe_es
spares84834552sp_ares
speered103614812speered
speers85019952speer_s
sperms102512602sp_erms
sphene113412402sphene_
spheral1238422spheral
spheric14510072spheric
spherics1537072spherics
spherier1337782spherier
spheriest1438382spheriest
spherules1443822spherules
sphery14318882spher_y
spiered104412462spiered
spiers84421742spier_s
spires84628112sp_ires
splores91910952splores
spores84726612sp_ores
sprees85620642spre_es
steres63929532s_teres
syphered1755012syphered
syphers15317272sypher_s
theres96525472_theres
unspheres1455362unspheres
wheres125917442_wheres
achenes12313493achenes
adhere10310333adhere_
adhered1239233adhered
adherer1137573adherer
adherers1296923adherers
amperes11313983amperes
aperies9423203ap_eries
apers76629133ap_er_s
apexes1539133ap_exes
aphereses1466423aphereses
apheresis1475333apheresis
aphesis12610513aphesis
aphides134711203aphides
apres75426403ap__res
asperges11318093asp_erges
aspers86220313asp_er_s
asperse94210663asp_erse
asperses104111673asp_erses
aspheric1547983aspheric
aspires9612043asp_ires
biospheres1765143biospheres
ceres75540013__ceres
chares115631803_chares
cheers114518913_cheers
cherts115617233_cherts
chevres15379793_chevres
chores114828023_chores
ciphered1637053ciphered
cipherer1545573cipherer
cipherers1644893cipherers
ciphers14379993cipher_s
cohere112716993cohere_
cohered133514693cohered
coherer122912783coherer
coherers132310733coherers
cyphered1934653cyphered
cyphers17316753cypher_s
ecospheres1795133ecospheres
ensphere1366083ensphere_
ensphered1565283ensphered
epees75219833ep_e_es
ephebe1336063ephebe_
ephebos1444113ephebos
ephebus1443283ephebus
ephedras1444413ephedras
ephors11311403ephor_s
epimeres12117653epimeres
estheses1137783estheses
esthetes1147743esthetes
ethenes103313873ethenes
ethers94518413ether_s
exospheres2294423exospheres
feres86038183__feres
freres94716173_freres
galeres83514343galeres
ghees95215553_ghe_es
gophers1338983gopher_s
haeres94017033_haeres
hares86255543__hares
hebes105521673__hebes
hemes105031083__hemes
herbs105520503__herbs
herds96424683__herds
here76447103__here_
heresy125011233__heresy
herls85226433__herls
herms105626433__herms
herns84825583__herns
heroes94923833__heroes
heros84930863__heros
herpes115517323__herpes
hers75844873__her_s
hexes155123043__hexes
hires86134343__hires
imphees1436693imphe_es
inhere9313713inhere_
inhered11313163inhered
insphere1355973insphere_
insphered1564783insphered
isotheres1246333isotheres
meres75143573__meres
noospheres1545143noospheres
nowheres1437513nowheres
ochered132610283ochered
ochers113915303ocher_s
ochres113510833och_res
oosphere1355993oosphere_
operas8312453op_eras
ophites12310103ophites
others93918003other_s
padres95016983_padres
pares77164483_p_ares
pedes85327293_p_edes
peered93819493_peered
peeress939503_peeress
peeries93623023_peeries
peers75130273_peer_s
pees65257373_p_e_es
peeves113814873_peeves
pekes114623563_p_ekes
peles75738083_p_eles
penes75839223_p_enes
pere66450263_p_ere_
perea75026443_p_erea
peris75537073_p_eris
perks115325803_p_erks
perms95524513_p_erms
perps95521483_p_erps
perse75429523_p_erse
perses85428063_p_erses
pervs105117373_p_ervs
phages125213513_phages
pharos11312063_pharos
phases114618403_phases
phereses1348093_phereses
pheresis1377633_pheresis
phizes20389133_phizes
phoebes1435813_phoebes
phones114121213_phones
phoresy1534653_phoresy
physes14399783_physes
pieces104217273_pieces
pierces113411193_pierces
piers75926333_pier_s
plebes104313623_plebes
plexes155313543_plexes
pores75849033_p_ores
prees75937173_pre_es
prexes154915953_prexes
prezes173614693_prezes
purees84721683_purees
pyres105523883_p_yres
quaeres163310843quaeres
rehires105016113rehires
reveres103621343reveres
rhemes115913183_rhemes
sabered103213023sabered
sabers85224733saber_s
sabres85520863s_abres
sakers104125433saker_s
samphires1645513samphires
sapheads1466083sapheads
saphenas1345713saphenas
sappers113518903sapper_s
sapphires1644043sapphires
sarees65329943sare_es
satires72617573satires
savers93825923saver_s
sawers94620163sawer_s
sayers94221593sayer_s
scares85033003s_cares
scenes84520353s_cenes
schemas1468163schemas
scheme1379633scheme_
schemed1577753schemed
schemer1477963schemer
schemers1576713schemers
scherzi2143583scherzi
scherzo2153943scherzo
scherzos2243703scherzos
schmeers1574833schmeers
schmoes14308543schmoes
schorls1248353schorls
scleras948223scleras
scores84725923s_cores
screes85023973scre_es
secedes103711983secedes
secerns987733secerns
secures9613163secures
seders74420283seder_s
seeress7311573s_eeress
seers55136383s_eer_s
sees45361053s__e_es
sememes11109203sememes
semes75731583s__emes
senhores112810993senhores
senores73218113senores
sere46153473s__ere_
sered65737293s__ered
serenes73222903serenes
serer55935513s__erer
serest64831613s__erest
serfs84922013s__erfs
serges74225973s__erges
series64540973s__eries
sers45746653s__er_s
serves94423653s__erves
severe94016083severe_
severed113513863severed
severer103511563severer
severest11310323severest
severs94121123sever_s
sewered112911243sewered
sewers94719723sewer_s
sexes126126223s__exes
shades105924533s_hades
shakes135024593s_hakes
shales94731253s_hales
shames114726223s_hames
shapes115124953s_hapes
shards104319173s_hards
share86437083s_hare_
shared105829063s_hared
sharer95025483s_harer
sharers104720623s_harers
sharks135019723s_harks
sharns95516983s_harns
sharps115516083s_harps
shaves125224933s_haves
sheafs124912883s_heafs
sheals94420643s_heals
sheared114516013s_heared
shearer104414693s_hearer
shearers113911323s_hearers
shears93820903s_hears
sheas86331793s_he_as
sheaves134412973s_heaves
sheds96122703s_he_ds
sheen85023313s_he_en
sheens95116993s_heens
sheep105321523s_he_ep
sheer84726893s_he_er
sheered113515463sheered
sheerer103813853sheerer
sheerest11310083sheerest
sheesh1237813s_he_esh
sheet84836963s_he_et
sheets93918503s_heets
sheeves133911953sheeves
sheiks132510013s_heiks
shekel1338383s_hekel
shekels1436043s_hekels
shells94319523s_hells
shelves134112093s_helves
shends105313773s_hends
sheols94614163s_heols
shepherds1843223shepherds
sheqel1846523s_heqel
sheqels1934753s_heqels
sherbet12311383s_herbet
sherbets1335213s_herbets
sherd96321153s_her_d
shereef1337743s_hereef
shereefs1433863s_hereefs
sherif122915243s_herif
sherifs13299683s_herifs
sherpa1138093s_herpa
sherpas1238093s_herpas
sherries111812903s_herries
sherris10168803s_herris
sherry124510413s_herry
shes75734353s_h__es
shewed134716183s_hewed
shewer124515113s_hewer
shewers134312053s_hewers
shews115924713s_he_ws
shiers94921753shier_s
shies86136553s_h_ies
shines95028913s_hines
shire84727133s_hire_
shirks134814123s_hirks
shirrs94413173s_hirrs
shirts94918343s_hirts
shives124921413s_hives
shmoes114612103s_hmoes
shoers94518333shoer_s
shoes85429663s_h_oes
shore85432653s_hore_
shored105723653s_hored
shorls94516203s_horls
shorts95321743s_horts
shotes95321913s_hotes
shoves124919423s_hoves
shred98125613s_h_red
shreds105613053s_hreds
shrew119720173s_h_rew
shrews129313923s_hrews
shris84221453s_h_ris
shutes93518223s_hutes
shyers124712203shyer_s
sieges73816833s_ieges
sieves93216003s_ieves
sighers113712183sigher_s
silexes1438653silexes
sippers113117753sipper_s
sirees64624583sire_es
sires55945373s__ires
sirrees73410573sirrees
sivers95324153siver_s
sizers155215813sizer_s
skees95023123s_ke_es
skenes104616633s_kenes
skiers104713703skier_s
sleeves103311343sleeves
slieves10378963slieves
smerks12449713s_merks
snares65329033s_nares
sneered83113973sneered
sneerer73512313sneerer
sneerers8309803sneerers
sneers64016173sneer_s
sneezes16278503sneezes
snores64324323s_nores
sobered102912433sobered
soberer93110353soberer
soberest10310353soberest
sobers85218863sober_s
soirees72411643soirees
soleret7321233soleret
solerets839693solerets
sophies12314623soph_ies
sores55454283s__ores
sowers94923443sower_s
spacers113813873spacer_s
spaces104722633sp_aces
spaders104214473spader_s
spades94222583sp_ades
spaes76029973sp__aes
spahee11313443spahe_e_
spales84728103sp_ales
spare75135563sp_are_
spared95427493sp_ared
sparer84524963sp_arer
sparers94519613sparers
sparest94616433sp_arest
sparges104016343sparges
sparks124616363sp_arks
sparred104512863sparred
spars75431543sp_ar_s
sparse84516343sp_arse
spates85028173sp_ates
spathes125116533spathes
spavies123012953spavies
spazzes1735263spazzes
speaks125114583sp_eaks
speans85417143sp_eans
speared104314423speared
spearer93913663spearer
spearers103711143spearers
spears84019473sp_ears
species11314133species
specks144312703sp_ecks
specs96916673sp_e_cs
spectres12268683spectres
speeches1537413speeches
speed85526623sp_e_ed
speeded113310423speeded
speeder103811073speeder
speeders11339313speeders
speedos10298263speedos
speeds94316053sp_eeds
speel74420763sp_e_el
speeled103712453speeled
speels85116393sp_eels
speer74623903sp_e_er
speils84116223sp_eils
speired103811103speired
speirs85013233sp_eirs
speise84614253sp_eise
speises93813933speises
speiss84311643sp_eiss
spells84617683sp_ells
spelts84614643sp_elts
spences113413923spences
spends94714473sp_ends
spense83912433sp_ense
spenses92913573spenses
sperm93216023sp_er_m
spewed125512333sp_ewed
spewer115112153sp_ewer
spewers124210663sp_ewers
spews105015923sp_e_ws
sphenic1449093sphenic
sphering142811943sphering
spheroid1447283spheroid
spheroids1545543spheroids
spherule1343843spherule
sphinges14267483sphinges
sphinxes20334403sphinxes
sphynxes23292423sphynxes
spiceries1349313spiceries
spicers113815553spicer_s
spices104326033sp_ices
spiders103914413spider_s
spiegel1034553spiegel
spiegels1133873spiegels
spieled104811883spieled
spieler93111233spieler
spielers10319653spielers
spiels85317953spie_ls
spier75728033spier__
spies76037623sp__ies
spikers135311993spiker_s
spikes124520713sp_ikes
spiles84227913sp_iles
spines85132033sp_ines
spire75828693sp_ire_
spirea84015633sp_irea
spireas94412513spireas
spired94921863sp_ired
spirem104214163sp_irem
spiremes12397623spiremes
spirems11499563spirems
spirts85317133sp_irts
spites84127333sp_ites
spitzes1849183spitzes
splakes1349673splakes
spleen8310263sple_en
spleens937103spleens
splents93912133splents
splices113914383splices
splines94718893splines
splore81611303splore_
splurges1145163splurges
spodes94817433sp_odes
spokes124417213sp_okes
sponges10311043sponges
spoored104411293spoored
spoors84014033spoor_s
spore75428593sp_ore_
spored94821793sp_ored
sports84619183sp_orts
spouses92912813spouses
spreads1039763spreads
spree74830863sp__ree
sprites94220333sprites
spruces113810503spruces
sprues84515763sp_rues
spues75025383sp__ues
spumes1021314883sp_umes
spurges104111653spurges
spurns84811383sp_urns
spurred103610623spurred
spurrer93710223spurrer
spurrers10338463spurrers
spurrey12307813spurrey
spurreys13364603spurreys
spurries102311323spurries
spurs74621523sp_ur_s
spurts84814973sp_urts
squares163714463squares
squires163812843squires
stares66038753s_tares
steered83615253steered
steerer73113633steerer
steerers82511353steerers
steers63820983steer_s
steeves103410903steeves
steles63725663s_teles
stere55328543s_tere_
stereo65317913s_tereo
stereos74314973s_tereos
sterns64616763s_terns
stores65533663s_tores
stoures74614163stoures
subers85722643suber_s
subseres10312423subseres
sucres84218893s_ucres
suedes73918113s_uedes
suers55128483s_uer_s
supered10316123supered
supers84622403super_s
suppers113314703supper_s
supremes1238363supremes
sutures7314223sutures
swedes102711893s_wedes
swerves1377533s_werves
sycees11409653syce_es
sypher14317083sypher__
thebes115914493_thebes
themes115319253_themes
there87527393_there_
thermes126214613_thermes
therms115914873_therms
theses96517973_theses
threes97117323_threes
tuyeres10417793tuyeres
unsphere1355853unsphere_
unsphered1556103unsphered
upheaps1494233upheaps
upheaves1643913upheaves
uphroes1236303uphroes
uppers102912293upper_s
ushered1139153ushered
ushers94415533usher_s
where117019433_where_
whereas13448903_whereas
wherves16548063_wherves
whores125617103_whores

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 Limit1340275355.92322628.2
3Display Results5355350.1862876.3
 (SQL Overall)1786915356.51527427.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.