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
sphere113313651sphere_
spheres123114351spheres
spiered104412461spiered
syphered1755011syphered
adhered1239232adhered
ciphered1637052ciphered
cohered133514692cohered
cyphered1934652cyphered
ensphered1565282ensphered
inhered11313162inhered
insphered1564782insphered
ochered132610282ochered
peered93819482_peered
sabered103213022sabered
schemed1577752schemed
sered65737292s__ered
severed113513862severed
sewered112911242sewered
shared105829062s_hared
sheared114516002s_heared
sheered113515452sheered
sherd96321152s_her_d
shewed134716182s_hewed
shored105723642s_hored
shred98125612s_h_red
sneered83113972sneered
sobered102912432sobered
spared95427482sp_ared
sparred104512852sparred
speared104314422speared
speed85526622sp_e_ed
speeded113310422speeded
speeled103712452speeled
speired103811102speired
spewed125512332sp_ewed
sphene113412402sphene_
sphenes123013162sphenes
spheral1238422spheral
spheric14510072spheric
spherier1337782spherier
spheroid1447282spheroid
sphery14318882spher_y
spieled104811882spieled
spired94921862sp_ired
spoored104411292spoored
spored94821792sp_ored
spurred103610612spurred
steered83615252steered
supered10316122supered
unsphered1556102unsphered
ushered1139152ushered
adhere10310333adhere_
adherend1343863adherend
adherer1137563adherer
adheres11310163adheres
altered83215733altered
angered93013473angered
apheses12610703apheses
appeared1336143appeared
ashlered1244623ashlered
aspersed11428293asp_ersed
aspheric1547983aspheric
aspired1068173asp_ired
bothered142110393bothered
bowered133113043bowered
capered123014043capered
catered103117763catered
cered85227443__cered
chared125423693_chared
cheered133713293cheered
chefed155010563_chefed
chewed154415013_chewed
chored125321883_chored
cipherer1545573cipherer
cohere112716993cohere_
coherer122912783coherer
coheres122917693coheres
coppered153410543coppered
coshered14610293coshered
covered133315293covered
cowered133214643cowered
dithered13189293dithered
dowered122811553dowered
ensphere1366073ensphere_
enspheres1486083enspheres
entered82718883entered
ephebe1336063ephebe_
ephebes1436153ephebes
eschewed1743443eschewed
fathered151510433fathered
fevered14339723fevered
fibered1337643fibered
fleered11309503fleered
gathered13149373gathered
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
hyphened2044683hyphened
inhere9313713inhere_
inheres10315173inheres
insphere1355963insphere_
inspheres1455403inspheres
jeered143912793_jeered
kashered1636403kashered
kippered17255623kippered
koshered1636063koshered
lagered92311153lagered
lappered13288213lappered
lathered121512323lathered
layered11259413layered
lechered1437523lechered
leered73816223_leered
levered114212303levered
lippered13287953lippered
livered113111633livered
loppered13326753loppered
lowered112711913lowered
metered103514013metered
mitered103213233mitered
mothered142310103mothered
ochred12328003och_red
offered1436143offered
oosphere1355983oosphere_
oospheres1456623oospheres
opened94311863op_ened
ordered9108533ordered
osiered837123osiered
overed102216623_overed
paired95017523_paired
papered122513163papered
pared86946763_p_ared
parred95024073_parred
peed76239183_p_e_ed
peeked134314573_peeked
peeled94119703_peeled
peened94318153_peened
peeped113915383_peeped
peeved124112883_peeved
peppered1236113peppered
pere66450263_p_ere_
perea75026443_p_erea
peres76246643_p_eres
perked134617683_p_erked
permed115217343_p_ermed
petered103314963petered
phased124011973_phased
phoned124014553_phoned
physed15386793_physed
pieced113912103_pieced
pierced12347593_pierced
pored85234513_p_ored
pothered142311043pothered
poured95116743_poured
powered132911643powered
preed85128113_pre_ed
premed114617753_premed
preyed125313193_preyed
pshawed16103033pshawed
pureed95017803_pureed
purred94218073_purred
queered17117213queered
rapiered1136053rapiered
rehired115013153rehired
revered112819333revered
rogered939553rogered
sabred95916533s_abred
sacheted14127833sacheted
sacred94917103s_acred
saggered11237553saggered
saphead1357773saphe_ad
sapheaded1644183sapheaded
savored1158343savored
scared95227293s_cared
scarred104512633scarred
sceptered1444723sceptered
scheme1379633scheme_
schemer1477953schemer
schemes1489663schemes
scherzi2143573scherzi
scherzo2153933scherzo
schmeared1743053schmeared
schmeered1743273schmeered
schrod1247883sch_rod
sclereid1145363sclereid
scored94621133s_cored
scoured103811153scoured
screed95718923scre_ed
screwed135710653screwed
scuppered1643933scuppered
seared75232843s_eared
seceded11319203seceded
secerned1136103secerned
secured1059723secured
seed55549483s__e_ed
seeded84520463s_eeded
seeled73922093s_eeled
seemed95117613s_eemed
seeped94317523s_eeped
sere46153473s__ere_
serer55935503s__erer
seres55448893s__eres
serged84118763s__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
sharked153613903s_harked
sharped134112043s_harped
shaved135118383s_haved
shawed134817233s_hawed
sheafed14388973s_heafed
shearer104414683s_hearer
sheaved143411633s_heaved
shed86536153s_h__ed
shedded13419063s_hedded
sheen85023313s_he_en
sheened113511703sheened
sheep105321523s_he_ep
sheer84726893s_he_er
sheerer103813843sheerer
sheers94322403s_heers
sheet84836953s_he_et
sheeted113813033sheeted
shekel1338383s_hekel
shelled113815083s_helled
shelved14379933s_helved
shend94719973s_he_nd
shepherd1744373shepher_d
shepherded2052263shepherded
sheqel1846523s_heqel
sherbet12311383s_herbet
sherds105614723s_herds
shereef1337743s_hereef
sherif122915233s_herif
sherpa1138093s_herpa
sherry124510413s_herry
shewer124515103s_hewer
shied96125493s_h_ied
shined104620783s_hined
shire84727133s_hire_
shires95225573s_hires
shirked153710463s_hirked
shirred113710493shirred
shivered15177103shivered
shoed95723003s_h_oed
shooed103916073s_hooed
shore85432643s_hore_
shores94830403s_hores
shorted113614393s_horted
shoved134214273s_hoved
showed135016963s_howed
showered1537013showered
shreds105613053s_h_reds
shrew119720163s_h_rew
shrewd136810773s_hrewd
shrewed14589843shrewed
shuted103913163s_huted
sieged85212713s_ieged
sieved104611443s_ieved
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sinewed1137053sinewed
sintered92213903sintered
siphoned1446413siphoned
sired66134283s__ired
sistered92612803sistered
skeed105018983s_ke_ed
skewed145610233s_kewed
skewered1634213skewered
skippered1843423skippered
skirred12347073skirred
slathered13148533slathered
slavered12188033slavered
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
slewed104815523s_lewed
slippered1434823slippered
slithered13136623slithered
slivered12218103slivered
slurred8359183slurred
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
spalled103113123spalled
spammed14348523spammed
spanked143111723spanked
spanned104111223spanned
spare75135563sp_are_
sparer84524963sp_arer
spares84834553sp_ares
sparged113512753sparged
sparid94016933sp_arid
sparked143513133sparked
spasmed12296993spasmed
spathed134013183spathed
spatted104014143spatted
spattered12187643spattered
spawned13316803spawned
spayed124213613sp_ayed
speaned103411523speaned
spearer93913663spearer
specced14266703specced
specked16329013specked
sped76031493sp___ed
speeder103811073speeder
speedo94011993sp_e_edo
speedread1342383speedread
speeds94316053sp_e_eds
speedy1218410783sp_e_edy
speel74420763sp_e_el
speer74623903sp_e_er
speers85019953speer_s
speiled104412123speiled
spelled103714733spelled
spend85619333sp_e_nd
sperm93216013sp_er_m
sperms102512603sp_erms
spewer115112143sp_ewer
sphenic1449093sphenic
sphenoid1446323sphenoid
spherics1537073spherics
spheriest1438373spheriest
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_
splores91910943splores
splurged1243913splurged
spoiled104811353spoiled
spoked134413893sp_oked
sponged1137953sponged
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spore75428593sp_ore_
spores84726613sp_ores
sported104015433sported
spotted103713133spotted
spoused10349653spoused
spouted103412263spouted
sprayed13398903sprayed
spread9312533spre_ad
spree74830863sp__ree
sprees85620643spre_es
spruced12307523spruced
spudded12235903spudded
spued84918473sp__ued
spumed114711543sp_umed
spunked14307783spunked
spurned10339263spurned
spurrer93710213spurrer
spurrey12307803spurrey
spurted103111973spurted
sputtered12166323sputtered
squared173610553squared
squired173710053squired
stared75429873s_tared
starred85013453starred
steed66024943s_te_ed
steeked124010473steeked
steeled83513213steeled
steeped103412283steeped
steerer73113633steerer
steeved113610133steeved
stere55328543s_tere_
stereo65317913s_tereo
steres63929533s_teres
stewed104814243s_tewed
stirred8359693stirred
stoppered1444463stoppered
stored75524213s_tored
strewed115811333strewed
suckered1537833suckered
sueded84014633s_ueded
suffered1536733suffered
sugared938583sugared
sulphured1542923sulphured
summered1338143summered
sundered10312153sundered
sutured8310373sutured
swerved1455703s_werved
swithered16135463swithered
sypher14317083sypher__
syphers15317273sypher_s
syphoned1745733syphoned
tabered103311593tabered
tapered102612933tapered
telphered1544213telphered
tethered1238493tethered
themed125912583_themed
there87527393_there_
theres96525473_theres
tiered73613973_tiered
tochered1437913tochered
towered112911403towered
ulcered1037973ulcered
umbered121510113umbered
unhired112512153unhired
unsphere1355843unsphere_
unspheres1455363unspheres
upheaped1633643upheaped
upheaved1733763upheaved
upheld12115563uphe_ld
upreared1137073upreared
uttered82712433uttered
veered103612743_veered
wafered14288433wafered
wagered12299333wagered
watered113014953watered
wavered142910433wavered
where117019423_where_
wheres125917433_wheres
whored135512123_whored
withered15169433withered
wuthered15157433wuthered
zippered22244823zippered

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.1601116818.8
2DLD Change Limit1340274806.82619634.8
3Display Results4804800.1732774.6
 (SQL Overall)1786914807.15924960.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.