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

480 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
sphered13351231(None) 
speered103614811speered
sphere113313661sphere_
spheres123114351spheres
spiered104412461spiered
syphered1755011syphered
adhered1239232adhered
ciphered1637052ciphered
cohered133514692cohered
cyphered1934652cyphered
ensphered1565282ensphered
inhered11313162inhered
insphered1564782insphered
ochered132610282ochered
peered93819492_peered
sabered103213022sabered
schemed1577752schemed
sered65737292s__ered
severed113513862severed
sewered112911242sewered
shared105829062s_hared
sheared114516012s_heared
sheered113515462sheered
sherd96321152s_her_d
shewed134716182s_hewed
shored105723652s_hored
shred98125612s_h_red
sneered83113972sneered
sobered102912432sobered
spared95427492sp_ared
sparred104512862sparred
speared104314422speared
speed85526622sp_e_ed
speeded113310422speeded
speeled103712452speeled
speired103811102speired
spewed125512332sp_ewed
sphene113412402sphene_
sphenes123013162sphenes
spheral1238422spheral
spheric14510072spheric
spherier1337782spherier
spheroid1447282spheroid
sphery14318882spher_y
spieled104811882spieled
spired94921862sp_ired
spoored104411292spoored
spored94821792sp_ored
spurred103610622spurred
steered83615252steered
supered10316122supered
unsphered1556102unsphered
ushered1139152ushered
adhere10310333adhere_
adherend1343863adherend
adherer1137573adherer
adheres11310163adheres
altered83215753altered
angered93013473angered
apheses12610703apheses
appeared1336143appeared
ashlered1244623ashlered
aspersed11428303asp_ersed
aspheric1547983aspheric
aspired1068173asp_ired
bothered142110393bothered
bowered133113043bowered
capered123014043capered
catered103117783catered
cered85227443__cered
chared125423693_chared
cheered133713303cheered
chefed155010563_chefed
chewed154415013_chewed
chored125321883_chored
cipherer1545573cipherer
cohere112716993cohere_
coherer122912783coherer
coheres122917693coheres
coppered153410543coppered
coshered14610293coshered
covered133315293covered
cowered133214653cowered
dithered13189293dithered
dowered122811553dowered
ensphere1366083ensphere_
enspheres1486083enspheres
entered82718883entered
ephebe1336063ephebe_
ephebes1436153ephebes
eschewed1743443eschewed
fathered151510433fathered
fevered14339723fevered
fibered1337643fibered
fleered11309503fleered
gathered13149383gathered
hared95742183__hared
havered144011453havered
heed86437603__he_ed
heired103813043__heired
herbed123513453__herbed
herd84933063__her_d
herded114215643__herded
here76447103__here_
heres86245903__heres
hewed125619433__hewed
hexed165615763__hexed
hired95226263__hired
homered133212713homered
hovered143411573hovered
hyphened2044693hyphened
inhere9313713inhere_
inheres10315173inheres
insphere1355973insphere_
inspheres1455403inspheres
jeered143912793_jeered
kashered1636403kashered
kippered17255623kippered
koshered1636063koshered
lagered92311153lagered
lappered13288213lappered
lathered121512333lathered
layered11259413layered
lechered1437523lechered
leered73816223_leered
levered114212303levered
lippered13287953lippered
livered113111633livered
loppered13326753loppered
lowered112711913lowered
metered103514013metered
mitered103213233mitered
mothered142310103mothered
ochred12328003och_red
offered1436143offered
oosphere1355993oosphere_
oospheres1456633oospheres
opened94311863op_ened
ordered9108533ordered
osiered837123osiered
overed102216623_overed
paired95017523_paired
papered122513173papered
pared86946763_p_ared
parred95024073_parred
peed76239183_p_e_ed
peeked134314583_peeked
peeled94119713_peeled
peened94318163_peened
peeped113915393_peeped
peeved124112893_peeved
peppered1236133peppered
pere66450263_p_ere_
perea75026443_p_erea
peres76246643_p_eres
perked134617693_p_erked
permed115217353_p_ermed
petered103314973petered
phased124011973_phased
phoned124014553_phoned
physed15386793_physed
pieced113912103_pieced
pierced12347593_pierced
pored85234513_p_ored
pothered142311043pothered
poured95116743_poured
powered132911643powered
preed85128123_pre_ed
premed114617763_premed
preyed125313203_preyed
pshawed16103033pshawed
pureed95017813_pureed
purred94218073_purred
queered17117223queered
rapiered1136053rapiered
rehired115013153rehired
revered112819333revered
rogered939553rogered
sabred95916533s_abred
sacheted14127843sacheted
sacred94917103s_acred
saggered11237553saggered
saphead1357773saphe_ad
sapheaded1644183sapheaded
savored1158343savored
scared95227293s_cared
scarred104512633scarred
sceptered1444723sceptered
scheme1379633scheme_
schemer1477963schemer
schemes1489663schemes
scherzi2143583scherzi
scherzo2153943scherzo
schmeared1743053schmeared
schmeered1743273schmeered
schrod1247883sch_rod
sclereid1145363sclereid
scored94621133s_cored
scoured103811153scoured
screed95718933scre_ed
screwed135710663screwed
scuppered1643933scuppered
seared75232843s_eared
seceded11319203seceded
secerned1136103secerned
secured1059723secured
seed55549483s__e_ed
seeded84520463s_eeded
seeled73922093s_eeled
seemed95117613s_eemed
seeped94317523s_eeped
sere46153473s__ere_
serer55935513s__erer
seres55448893s__eres
serged84118773s__erged
served104616813s__erved
severe94016083severe_
severer103511563severer
sewed95325163s__ewed
sexed136618543s__exed
shaded114518873s_haded
shaled105023953s_haled
shamed125120213s_hamed
shaped125020103s_haped
shard96125963s_har_d
share86437083s_hare_
sharer95025483s_harer
shares95236413s_hares
sharked153613913s_harked
sharped134112053s_harped
shaved135118383s_haved
shawed134817233s_hawed
sheafed14388973s_heafed
shearer104414693s_hearer
sheaved143411633s_heaved
shed86536153s_h__ed
shedded13419063s_hedded
sheen85023313s_he_en
sheened113511703sheened
sheep105321523s_he_ep
sheer84726893s_he_er
sheerer103813853sheerer
sheers94322403s_heers
sheet84836963s_he_et
sheeted113813043sheeted
shekel1338383s_hekel
shelled113815093s_helled
shelved14379933s_helved
shend94719973s_he_nd
shepherd1744373shepher_d
shepherded2052263shepherded
sheqel1846523s_heqel
sherbet12311383s_herbet
sherds105614723s_herds
shereef1337743s_hereef
sherif122915243s_herif
sherpa1138093s_herpa
sherry124510413s_herry
shewer124515113s_hewer
shied96125493s_h_ied
shined104620783s_hined
shire84727133s_hire_
shires95225573s_hires
shirked153710463s_hirked
shirred113710503shirred
shivered15177103shivered
shoed95723013s_h_oed
shooed103916083s_hooed
shore85432653s_hore_
shores94830413s_hores
shorted113614403s_horted
shoved134214283s_hoved
showed135016973s_howed
showered1537013showered
shreds105613053s_h_reds
shrew119720173s_h_rew
shrewd136810783s_hrewd
shrewed14589853shrewed
shuted103913173s_huted
sieged85212713s_ieged
sieved104611443s_ieved
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sinewed1137053sinewed
sintered92213903sintered
siphoned1446413siphoned
sired66134283s__ired
sistered92612803sistered
skeed105018983s_ke_ed
skewed145610233s_kewed
skewered1634213skewered
skippered1843433skippered
skirred12347083skirred
slathered13148553slathered
slavered12188033slavered
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
slewed104815523s_lewed
slippered1434823slippered
slithered13136623slithered
slivered12218103slivered
slurred8359193slurred
smeared104510623smeared
smeeked14287223smeeked
smerked14327283s_merked
smothered1545683smothered
snared74824553s_nared
sneerer73512313sneerer
sneezed17287793sneezed
snored74819543s_nored
soared74324293s_oared
soberer93110353soberer
soldered1038153soldered
soleret7321233soleret
sored66141783s__ored
soured74921863s_oured
spaced114517253sp_aced
spaded103816753sp_aded
spaed85522273sp__aed
spahee11313443spahe_e_
spahees1238263spahe_es
spalled103113133spalled
spammed14348523spammed
spanked143111733spanked
spanned104111223spanned
spare75135563sp_are_
sparer84524963sp_arer
spares84834553sp_ares
sparged113512763sparged
sparid94016933sp_arid
sparked143513143sparked
spasmed12296993spasmed
spathed134013183spathed
spatted104014143spatted
spattered12187653spattered
spawned13316803spawned
spayed124213613sp_ayed
speaned103411523speaned
spearer93913663spearer
specced14266703specced
specked16329013specked
sped76031493sp___ed
speeder103811073speeder
speedo94011993sp_e_edo
speedread1342383speedread
speeds94316053sp_e_eds
speedy1218410793sp_e_edy
speel74420763sp_e_el
speer74623903sp_e_er
speers85019953speer_s
speiled104412123speiled
spelled103714743spelled
spend85619333sp_e_nd
sperm93216023sp_er_m
sperms102512603sp_erms
spewer115112153sp_ewer
sphenic1449093sphenic
sphenoid1446323sphenoid
spherics1537073spherics
spheriest1438383spheriest
sphering142811943sphering
spheroids1545543spheroids
spherule1343843spherule
spherules1443823spherules
spiced115218313sp_iced
spied85427713sp__ied
spiegel1034553spiegel
spieler93111233spieler
spier75728033spier__
spiers84421743spier_s
spiffed16257103spiffed
spiked134915553sp_iked
spiled94621993sp_iled
spilled103613623spilled
spined95423943sp_ined
spire75828693sp_ire_
spirea84015633sp_irea
spirem104214163sp_irem
spires84628113sp_ires
spirted103913073spirted
spited94820443sp_ited
spitted103912703spitted
splayed13357813splayed
spleen8310263sple_en
spliced124310593spliced
splined105013113splined
splore81611303splore_
splores91910953splores
splurged1243923splurged
spoiled104811353spoiled
spoked134413893sp_oked
sponged1137953sponged
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spore75428593sp_ore_
spores84726613sp_ores
sported104015433sported
spotted103713143spotted
spoused10349653spoused
spouted103412263spouted
sprayed13398903sprayed
spread9312533spre_ad
spree74830863sp__ree
sprees85620643spre_es
spruced12307533spruced
spudded12235903spudded
spued84918473sp__ued
spumed114711543sp_umed
spunked14307783spunked
spurned10339263spurned
spurrer93710223spurrer
spurrey12307813spurrey
spurted103111973spurted
sputtered12166323sputtered
squared173610563squared
squired173710063squired
stared75429873s_tared
starred85013453starred
steed66024943s_te_ed
steeked124010473steeked
steeled83513223steeled
steeped103412283steeped
steerer73113633steerer
steeved113610133steeved
stere55328543s_tere_
stereo65317913s_tereo
steres63929533s_teres
stewed104814243s_tewed
stirred8359703stirred
stoppered1444473stoppered
stored75524213s_tored
strewed115811343strewed
suckered1537833suckered
sueded84014633s_ueded
suffered1536733suffered
sugared938583sugared
sulphured1542923sulphured
summered1338143summered
sundered10312153sundered
sutured8310373sutured
swerved1455703s_werved
swithered16135463swithered
sypher14317083sypher__
syphers15317273sypher_s
syphoned1745733syphoned
tabered103311593tabered
tapered102612933tapered
telphered1544223telphered
tethered1238493tethered
themed125912583_themed
there87527393_there_
theres96525473_theres
tiered73613973_tiered
tochered1437913tochered
towered112911403towered
ulcered1037973ulcered
umbered121510113umbered
unhired112512153unhired
unsphere1355853unsphere_
unspheres1455363unspheres
upheaped1633643upheaped
upheaved1733763upheaved
upheld12115563uphe_ld
upreared1137083upreared
uttered82712443uttered
veered103612743_veered
wafered14288433wafered
wagered12299333wagered
watered113014963watered
wavered142910433wavered
where117019433_where_
wheres125917443_wheres
whored135512123_whored
withered15169433withered
wuthered15157433wuthered
zippered22244823zippered

Search took 9 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.830215290.4
2DLD Change Limit1340274807.68617437.8
3Display Results4804800.1862580.6
 (SQL Overall)1786914808.70220534.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.