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

411 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
specking1735973(None) 
pecking164017781_pecking
speaking153212491speaking
speccing15306641speccing
speckling18235581speckling
becking164416072_becking
checking20379202checking
decking153915592_decking
flecking18408232flecking
gecking154111362_gecking
kecking134111882_kecking
necking143913892_necking
packing164420722_packing
peaking144317692_peaking
peching154513902_peching
peeking144414952_peeking
perking143716462_perking
picking163418332_picking
pocking163916762_pocking
recking144319922_recking
sacking144122702s_acking
seeking124016062s_eeking
shacking184014082shacking
shocking184311542shocking
shucking18339432shucking
sicking143720172s_icking
slacking153914132slacking
sleeking133410962sleeking
slicking153712592slicking
smacking173510762smacking
smeeking15317832smeeking
smerking15258472smerking
smocking17349102smocking
snacking153411702snacking
sneaking133211092sneaking
snicking153610232snicking
socking143518602s_ocking
spacing123614492spac_ing
spackling18266502spackling
spanking153911972spanking
sparking152812542sparking
speakings16345932speakings
speaning113512242speaning
spearing113216102spearing
speeding122810932speeding
speeling112713122speeling
speering113116322speering
speiling113612972speiling
speiring113711262speiring
spelling113315232spelling
spending122712432spending
spewing133110452spe_wing
spicing123914532spic_ing
spiking144312882sp_iking
spoking143212222sp_oking
spooking15269802spooking
spunking15258062spunking
stacking154215082stacking
steeking133411352steeking
sticking153513462sticking
stocking152912502stocking
sucking143217412s_ucking
wrecking18328152wrecking
arcking145811963_arcking
aspersing1237603aspersing
backing165523443_backing
bedecking1934283bedecking
bespeaking1944393bespeaking
blacking174213603blacking
blocking174510573blocking
breaking153914253breaking
bricking173911403bricking
bucking163617573_bucking
cheeking18349083cheeking
chocking204011013chocking
chucking20379503chucking
clacking173313493clacking
cleeking15267813cleeking
clerking15257163clerking
clicking173610983clicking
clocking174312413clocking
clucking17429993clucking
cocking163619983_cocking
cracking174013903cracking
creaking153414123creaking
cricking173412653cricking
crocking174313443crocking
deckings16346683_deckings
deking125614553_de_king
dicking153617613_dicking
docking153615013_docking
ducking154315053_ducking
eching126315563__eching
ejecting18268163ejecting
eking106614983__e_king
electing112113783electing
erecting112415063erecting
expecting2146693expecting
flacking184311793flacking
flicking184110043flicking
flocking183410873flocking
flyspecking265933flyspecking
freaking163611453freaking
freckling1934703freckling
frocking18309573frocking
fucking173212283_fucking
gleeking14316493gleeking
hacking173720613_hacking
heckling18257163_heckling
henpecking2242303henpecking
hocking173417243_hocking
hoicking1836053hoicking
inspecting1546223inspecting
jacking214515263_jacking
jerking19308923_jerking
keckling14245523_keckling
keeking114210893_keeking
kicking133314023_kicking
knacking14296713knacking
knocking14245943knocking
lacking143821543_lacking
leaking123616973_leaking
leching134613653_leching
leeching14318373leeching
lekking11306503_lekking
licking144118283_licking
locking143718153_locking
lucking143615833_lucking
mocking163614453_mocking
mucking163213823_mucking
neckings15346113_neckings
nicking143516323_nicking
nocking143615113_nocking
opening1039923ope_ning
pacing114522753_pac_ing
packings174310063_packings
paiking143814813_paiking
parking143423043_parking
peaching163613643_peaching
peacing124117073_peacing
pealing104123203_pealing
peckier153910523_peckier
peckish18227293_peckish
pectin102615533_pectin_
pectins112315233_pectins
peeing94618083_pe_eing
peeling102919873_peeling
peening103318303_peening
peeping123615213_peeping
peering103520353_peering
peeving135112243_peeving
pegging122811133_pegging
peining104619153_peining
peising103416763_peising
pekin111514423_pe_kin_
pekins121812233_pe_kins
pelting102917273_pelting
pending114119773_pending
penning103616493_penning
pepping113511623_pepping
perching163711633_perching
perming123416093_perming
petting103720953_petting
pickings17359383_pickings
pickling17239203_pickling
piecing12410453piec_ing
piking133719643_p_iking
pinking143918943_pinking
plucking17357723plucking
poking133819303_p_oking
porking143515813_porking
pricking173212603pricking
psyching1934483psyching
puking133913063_p_uking
quacking2436743quacking
racking144323663_racking
reeking123318643_reeking
repacking1838283repacking
reperking1638703reperking
respeaking1736803respeaking
respecting1549883respecting
ricking143920233_ricking
rocking143619633_rocking
rucking143216673_rucking
sackings15389633s_ackings
sacring103115983s_acring
saucing10311003sauc_ing
scending122610583scending
scenting113212813scenting
screaking16228243screaking
sculking15307913sculking
sealing83528563s_ealing
seaming103222113s_eaming
searing83330923s_earing
seating84130683s_eating
seceding12288563s_eceding
securing11310413s_ecuring
seeding93719483s_eeding
seedling102610953seedling
seeing74222143s_e_eing
seeling83522003s_eeling
seeming103216263s_eeming
seeping103817913s_eeping
seething1239023seething
seining84020773s_eining
seising84018863s_eising
seizing174114833s_eizing
selecting12310533selecting
selfing112911623s_elfing
selling83225833s_elling
sending94221373s_ending
sensing84116953s_ensing
serging93416673s_erging
sering74731813s_e_ring
serving113014983s_erving
setting83621393s_etting
sewing103819623s_e_wing
sexing144313893s_e_xing
shackling19286173shackling
shaking153317253s_haking
shanking163612283shanking
sharking163912973sharking
sheafing15329483sheafing
shealing123415463shealing
shearing123915903shearing
sheaving154110253sheaving
shedding14278113shedding
sheening123010803sheening
sheering123715103sheering
sheeting122712833sheeting
shelling123515213shelling
shelving15278173shelving
shending132511253shending
shewing143812193she_wing
shirking163210473shirking
shuckings19273853shuckings
siccing12319513s_iccing
sickling152910333s_ickling
sieging92613203sie_ging
sieving112311233sie_ving
silking123715593s_ilking
sinking123320543s_inking
skanking12288743skanking
skeeing12308853ske_eing
skeining1347073skeining
skelping1535973skelping
sketching1935083sketching
skewing15318723ske_wing
skinking12299773skinking
skulking12245903skulking
skunking12256653skunking
slaking123717473s_laking
sleaving123310983sleaving
sledding11248503sledding
sledging11288183sledging
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sle_wing
slicing103514643slic_ing
slinking133412983slinking
smearing113511753smearing
smelling113712723smelling
smelting11339713smelting
smirking15277233smirking
smockings18264283smockings
smoking143210523s_moking
snaking123915303s_naking
sneaping11349493sneaping
snedding11246953snedding
sneering93414503sneering
sneezing18267053sneezing
snelling93913563snelling
snooking133010583snooking
soaking123116613s_oaking
spacings13287043spac_ings
spading113114383sp_ading
spaeing103413543sp_aeing
spalling113213463spalling
spamming15317603spamming
spankings16215003spankings
spanning113311083spanning
sparging122611133sparging
sparing104823873sp_aring
sparkling16226353sparkling
sparling112714533sparling
sparring113112223sparring
spasming13227203spasming
spatting113111763spatting
spawning14296913spawning
spaying133014623sp_aying
special11310303spec_ial
speciating1548123speciating
specie10412223spec_i_e
species11314133spec_ies
specify1764993spec_ify
specifying2144683specifying
speck135115653speck___
specked16329013speck_ed
speckle15297553speck_le
speckled17255833speckled
speckles16268133speckles
specks144312703speck__s
spectating1546623spectating
speedings13265403speedings
speerings12276843speerings
spellings12296553spellings
spelunking17112003spelunking
spermine12311433spermine
sphering142811943sphering
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiling102919703sp_iling
spilling113113943spilling
spinning113310813spinning
spiring103918183sp_iring
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splaying14219303splaying
splicing1338963splicing
splining11310773splining
spoiling112911553spoiling
sponging1238823sponging
spoofing14228363spoofing
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
spraying14299883spraying
spreading1339653spreading
spring94526013sp__ring
sprucing1336893sprucing
spudding1335653spudding
spuing94313363sp__uing
spuming1248523sp_uming
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
squeaking2334213squeaking
staking123919803s_taking
stalking133512223stalking
steading103613593steading
stealing93416603stealing
steaming114013213steaming
steeling93615143steeling
steeping113412583steeping
steering93916793steering
steeving12359653steeving
stemming13408203stemming
stepping13329073stepping
sterling93615553sterling
stetting93410713stetting
stewing113412493ste_wing
stickling1647003stickling
stinking133113543stinking
stockings16296093stockings
stoking123615593s_toking
stooking132711143stooking
streaking142010323streaking
streeking14217453streeking
striking133012233striking
stroking132610943stroking
suckling152410023s_uckling
sueding92613753sue_ding
sulking124514313s_ulking
supering11317683supe_ring
suspecting1565703suspecting
swanking16399963swanking
swearing123711443swearing
sweating123213023sweating
sweeping14389143sweeping
sweeting123911313sweeting
swelling123212753swelling
swerving1546113swerving
swinking163410323swinking
synching17227713synching
syncing13177223sync_ing
tacking144421483_tacking
talcking1567083talcking
thacking183110043thacking
ticking143218753_ticking
tracking153715463tracking
trekking1235543trekking
tricking152714513tricking
trocking153612423trocking
trucking153310163trucking
tucking143415183_tucking
tweaking1635883tweaking
unpacking1835133unpacking
unpicking1834883unpicking
unspeaking1744423unspeaking
upending12258133upending
whacking21377483whacking
wicking173414773_wicking
wracking18349963wracking
wreaking163010213wreaking
wreckings19233683wreckings
wricking18349493wricking
yacking174315683_yacking
yerking15368813_yerking
yeuking15286123_yeuking
yocking173712373_yocking
yucking173211693_yucking
zincking2435463zincking

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.420425454.8
2DLD Change Limit1461624117.48619524.7
3Display Results4114110.1862209.7
 (SQL Overall)1786914118.09222082.4
 
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.