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

401 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
sphering14281194(None) 
speering113116321speering
spiering112713351spiering
syphering18175731syphering
adhering1338882adhering
ciphering17217702ciphering
cohering142413832cohering
cyphering20175242cyphering
ensphering1644972ensphering
inhering12913712inhering
insphering1644192insphering
ochering14219392ochering
peering103520352_peering
sabering112113742sabering
scheming1636632scheming
sering74731812s__ering
severing122013852severing
sewering122411092sewering
sharing113723242s_haring
shearing123915902s_hearing
sheering123715102sheering
shewing143812192s_hewing
shoring112820072s_horing
sneering93414502sneering
sobering111912782sobering
spaeing103413542spae_ing
sparing104823872sp_aring
sparring113112222sparring
spearing113216102spearing
speeding122810932speeding
speeling112713122speeling
speerings12276842speerings
speiring113711262speiring
spewing133110452sp_ewing
spheric14510072spheri_c
spherics1537072spherics
spherier1337782spherier
spieling113212522spieling
spiring103918182sp_iring
spooring113111462spooring
sporing104319412sp_oring
spring94526012sp__ring
spurring11339762spurring
steering93916792steering
supering11317682supering
unsphering1644282unsphering
ushering1258922ushering
altering91917113altering
angering102113803angering
appearing1436893appearing
ashlering1344153ashlering
aspersing1237603asp_ersing
aspheric1547983aspheri_c
aspiring1138873asp_iring
atheling1249203atheling
bothering152210203bothering
bowering142911713bowering
capering132414963capering
catering112019903catering
cering94522533__cering
charing133721323_charing
cheering143612703cheering
chefing16359033_chefing
chewing163911143_chewing
choring133617663_choring
coppering162810893coppering
coshering15510023coshering
covering142215723covering
cowering142514033cowering
dithering1499853dithering
dowering132510613dowering
entering91920053entering
ephedrin1444703ephedrin_
ephedrine1544383ephedrine
ephedrins1544153ephedrins
eschewing1893503eschewing
fathering161010093fathering
fevering152510083fevering
fleering123811283fleering
gathering1499463gathering
haring104233003__haring
havering152211053havering
hearing113324163__hearing
heiring113312903__heiring
herding122915123__herding
herring113615883__herring
hewing134514243__hewing
hexing174210513__hexing
hiring104421603__hiring
homering141512073homering
hovering151911143hovering
hyphening2144143hyphening
jeering153513043_jeering
kashering1736253kashering
kippering18205443kippering
koshering1735363koshering
lagering102212313lagering
lappering14258843lappering
lathering13912253lathering
layering122310353layering
lechering1538443lechering
leering83417643_leering
levering122212503levering
lippering14217883lippering
livering122012383livering
loppering14237283loppering
lowering122210913lowering
metering112915633metering
mitering113015403mitering
mothering152110183mothering
nidering10510483nidering
ochring13156673och_ring
offering1536393offering
opening1039923op_ening
ordering1039353ordering
overing111918053_overing
pairing103716733_pairing
papering132213313papering
paring94236493_p_aring
parring103222063_parring
peeing94618083_p_eeing
peeking144414953_peeking
peeling102919873_peeling
peening103318303_peening
peeping123615213_peeping
peeving135112243_peeving
peppering1337083peppering
perking143716463_p_erking
perming123416093_p_erming
petering112516813petering
pharming16248143_pharming
phasing133211673_phasing
phoning13312053_phoning
piecing12410453_piecing
pieing93917653_pie_ing
piercing1346663_piercing
poring94227273_p_oring
pothering151911283pothering
pouring103115863_pouring
powering142210803powering
preeing103817673_preeing
preying133114553_preying
pshawing1733523pshawing
pterin81014153_pterin_
pterins9812993_pterins
purring104515823_purring
queering1838203queering
rehearing132211763rehearing
rehiring122911883rehiring
revering122918073revering
rogering10310273rogering
sabeing102611863sabe_ing
sabring102614843s_abring
sacring103115983s_acring
saggering12197793saggering
savoring1269483savoring
scaring103421973s_caring
scarring112511513scarring
sceptering1545793sceptering
schmearing1842863schmearing
schmeering1843433schmeering
scoring103117213s_coring
scouring112810853scouring
screwing14288233screwing
scuppering1754023scuppering
searing83330923s_earing
seceding12288563seceding
secerning1246203secerning
securing11310413securing
seeding93719483s_eeding
seeing74222143s__eeing
seeking124016063s_eeking
seeling83522003s_eeling
seeming103216263s_eeming
seeping103817913s_eeping
serging93416673s__erging
serin55434443s__erin_
serine65432673s__erine
seringa83310743s__eringa
serins64029673s__erins
serving113014983s__erving
sewing103819623s__ewing
sexing144313893s__exing
shading123115563s_hading
shaking153317253s_haking
shaming133016743s_haming
shaping133116183s_haping
sharking163912973s_harking
sharping143011373s_harping
shaving143414333s_having
shawing143514883s_hawing
sheafing15329483s_heafing
shealing123415463s_healing
shearings13337563s_hearings
shearling1336923s_hearling
sheaving154110253s_heaving
shebang1334843s_hebang
shedding14278113s_hedding
sheening123010803sheening
sheeting122712833sheeting
shelling123515213s_helling
shelving15278173s_helving
shending132511253s_hending
shepherding2152273shepherding
sherif122915243s_heri_f
sheriff16287693s_heriff
sherifs13299683s_herifs
shieling123512403shieling
shining113816523s_hining
shirking163210473s_hirking
shirring122910443shirring
shirting123213613s_hirting
shivering1637333shivering
shoeing113211883s_hoeing
shooing112112913s_hooing
shorings12269483s_horings
shorting122514803s_horting
shoving142910643s_hoving
showering1646403showering
showing143814663s_howing
showring1548323showring
shrewing15228093shrewing
shrine94920053s_h_rine
shrink134511733s_h_rink
shuting113212053s_huting
shying134211843s_h_ying
sideling101012183sideling
sieging92613203s_ieging
sieving112311233s_ieving
silvering1337923silvering
simmering1467823simmering
simpering1449293simpering
sinewing1267593sinewing
sintering101014803sintering
siphoning1546133siphoning
siring75128313s__iring
sistering101213753sistering
skeeing12308853s_keeing
skewering1744633skewering
skewing15318723s_kewing
skioring13237223skioring
skippering1943673skippering
skirring13297143skirring
slathering14108283slathering
slavering1338723slavering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353s_lewing
slithering1496893slithering
slivering1338083slivering
slurring9288833slurring
smearing113511753smearing
smeeking15317833smeeking
smerking15258473s_merking
smothering1646013smothering
snaring83920953s_naring
sneezing18267053sneezing
snoring83917203s_noring
soaring83521893s_oaring
soldering1169033soldering
soring74731883s__oring
souring83219063s_ouring
spacing123614493sp_acing
spading113114383sp_ading
spaeings11276253spae_ings
spalling113213463spalling
spamming15317603spamming
spanking153911973spanking
spanning113311083spanning
sparging122611133sparging
sparking152812543sparking
sparling112714533sparling
spasming13227203spasming
spattering13107793spattering
spatting113111763spatting
spawning14296913spawning
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
speccing15306643speccing
specking17359733specking
speedings13265403speedings
speiling113612973speiling
spelling113315233spelling
spending122712433spending
spermine12311433sp_ermine
sphene113412403sphe__ne
sphenic1449093spheni_c
spheral1238423spher_al
sphere113313663spher__e
sphered133512313spher_ed
spheres123114353spher_es
spherical1645803spherical
spheriest1438383spheriest
spheroid1447283spheroid
spheroids1545543spheroids
spherule1343843spherule
sphery14318883spher__y
sphinx1866203sph__inx
spicing123914533sp_icing
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spinning113310813spinning
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splaying14219303splaying
splicing1338963splicing
splining11310773splining
splurging1333623splurging
spoiling112911553spoiling
spoking143212223sp_oking
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
sprang95713523sp__rang
spraying14299883spraying
spreading1339653spreading
sprig85617743sp__ri_g
springe103913983sp__ringe
springs104415923sp__rings
springy13359663sp__ringy
sprint84526793sp__rint
sprucing1336893sprucing
sprung94610033sp__rung
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spunking15258063spunking
spurning11258663spurning
spurting113111633spurting
sputtering13106463sputtering
spying123913253sp__ying
squaring18158633squaring
squiring18177563squiring
staring84527053s_taring
starring92312953starring
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steeving12359653steeving
sterling93615553s_terling
stewing113412493s_tewing
stirring9299653stirring
stoppering1544613stoppering
storing83921123s_toring
strewing12289853strewing
string75327563s__tring
suberin9314563suberin_
suberins10315093suberins
subring104116263s_ubring
suckering1638103suckering
sueding92613753s_ueding
suffering1637293suffering
sugaring1039053sugaring
sulphuring1642773sulphuring
summering1458753summering
sundering11312323sundering
suturing9310373suturing
swearing123711443swearing
sweeping14389143sweeping
sweeting123911313sweeting
swerving1546113s_werving
swithering17105213swithering
syphoning1845393syphoning
tabering112211423tabering
tapering112112503tapering
telphering1644203telphering
tethering1339133tethering
theming133610473_theming
tiering8315253_tiering
tochering1537153tochering
towering122610873towering
ulcering1139333ulcering
umbering1399433umbering
upbearing1435033upbearing
upheaping1743853upheaping
upheaving1843803upheaving
uprearing1238373uprearing
upspring1335703upspring
uptearing1236103uptearing
uttering91613083uttering
veering113213683_veering
wafering15208893wafering
wagering13219523wagering
watering122316313watering
wavering152410543wavering
whoring142910293_whoring
withering16108813withering
wuthering1697803wuthering
zippering23215203zippering

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 Filter1786911461620.470380193.6
2DLD Change Limit1461624017.37619815.9
3Display Results4014010.1702358.8
 (SQL Overall)1786914018.01622291.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.