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

406 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
smerking1525847(None) 
smeeking15317831smeeking
smirking15277231smirking
amercing1337192amercing
clerking15257162clerking
emerging1237892emerging
jerking19308922_jerking
marking144020132_marking
merging112711762_merging
perking143716462_perking
seeking124016062s_eeking
serging93416672s_erging
sering74731812s_er_ing
serving113014982s_erving
sharking163912972sharking
shirking163210472shirking
sleeking133410962sleeking
smacking173510762smacking
smarting113212452smarting
smearing113511752smearing
smelling113712722smelling
smelting11339712smelting
smocking17349102smocking
smoking143210522sm_oking
sneaking133211092sneaking
sparking152812542sparking
speaking153212492speaking
specking17359732specking
steeking133411352steeking
sterling93615552sterling
swerving1546112swerving
yerking15368812_yerking
alerting91312383alerting
amending12308913amending
aspersing1237603aspersing
asserting1038663asserting
averring12239063averring
averting122512733averting
barking144724183_barking
becking164416073_becking
beraking153612973_beraking
berming123614833_berming
borking144716173_borking
breaking153914253breaking
burking143716323_burking
carking144322853_carking
cering94522533_cer_ing
charking183512613charking
checking20379203checking
cheeking18349083cheeking
chirking18339383chirking
cleeking15267813cleeking
coercing1349003coercing
corking143018823_corking
creaking153414123creaking
darking134217343_darking
decking153915593_decking
deking125614553_de_king
demarking1736773demarking
demerging1436643demerging
dirking133812603_dirking
eking106614983__e_king
embarking1844193embarking
embruing1344523embruing
emending12298893emending
erlking1236703__erlking
erring73816483__erring
everting122213133everting
exerting162211153exerting
flecking18408233flecking
forking154014843_forking
freaking163611453freaking
gecking154111363_gecking
gherkin1544043gherkin_
gherkins1643993gherkins
gleeking14316493gleeking
harking154120943_harking
herding122915123_herding
herring113615883_herring
homering141512073homer_ing
imbarking1843613imbarking
imbruing1344003imbruing
immerging1544103immerging
immersing1445123immersing
imparking1834713imparking
irking114611753__irking
jeering153513043jeer_ing
jerkin17258113_jerkin_
jerkins18358253_jerkins
kecking134111883_kecking
keeking114210893_keeking
kerbing14308483_kerbing
kerfing15307533_kerfing
kerning124010893_kerning
larking123718253_larking
leaking123616973_leaking
leering83417643leer_ing
lekking11306503_lekking
lurking123710853_lurking
making134823853_m_aking
markings153410243_markings
marling103322763_marling
marring103319553_marring
marting103325013_marting
masking145116613_masking
meaning103918703_meaning
meeting103314963_meeting
melding113414273_melding
melling102822623_melling
melting103317753_melting
mending114018683_mending
mensing103915103_mensing
meouing1059203_meouing
meowing1368593_meowing
merino8315093_mer_ino
meriting11314683_meriting
merlin83916683_merlin_
merlins93015813_merlins
meshing134513813_meshing
messing103916393_messing
meting94320593_me_ting
metring103215293_metring
mewing123914203_me_wing
mewling13329513_mewling
miking134218463_m_iking
milking143712763_milking
miring93723803_mir_ing
mismarking1955863mismarking
mocking163614453_mocking
morning103215043_morning
mucking163213823_mucking
muring95120373_mur_ing
narking124015383_narking
necking143913893_necking
nerving112910833_nerving
omening10310093ome_ning
overing111918053over_ing
overkind1637953overkind
parking143423043_parking
peaking144317693_peaking
pecking164017783_pecking
peeking144414953_peeking
peering103520353peer_ing
perming123416093_perming
piercing1346663piercing
porking143515813_porking
querying2135243querying
quirking22215123quirking
recking144319923_recking
reeking123318643_reeking
remaking152613303remaking
remarking1638893remarking
remerging1358323remerging
reperking1638703reperking
sabering112113743saber_ing
sabring102614843sabr_ing
sacking144122703s_acking
sacring103115983sacr_ing
scarfing14309713scarfing
scaring103421973scar_ing
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
scending122610583scending
scenting113212813scenting
scoring103117213scor_ing
scorning1169133scorning
screaking16228243screaking
screwing14288233screwing
scrying1338663s_crying
sculking15307913sculking
sealing83528563s_ealing
seaming103222113s_eaming
searing83330923s_earing
seating84130683s_eating
secerning1246203secerning
seeding93719483s_eeding
seedling102610953seedling
seeing74222143s_e_eing
seeling83522003s_eeling
seeming103216263s_eeming
seeping103817913s_eeping
seething1239023seething
seining84020773s_eining
seising84018863s_eising
seizing174114833s_eizing
selfing112911623s_elfing
selling83225833s_elling
sending94221373s_ending
sensing84116953s_ensing
serein63318463s_erein_
sereins73716113s_ereins
sergings10299213s_ergings
serin55434443s_er_in_
serine65432673s_er_ine
seringa83310743s_er_inga
serins64029673s_er_ins
serrying12167693serrying
servings12249223s_ervings
setting83621393s_etting
severing122013853sever_ing
sewering122411093sewer_ing
sewing103819623s_e_wing
sexing144313893s_e_xing
shacking184014083shacking
shaking153317253s_haking
shanking163612283shanking
sharing113723243shar_ing
sharping143011373sharping
sheafing15329483sheafing
shealing123415463shealing
shearing123915903shearing
shearling1336923shearling
sheaving154110253sheaving
shedding14278113shedding
sheening123010803sheening
sheering123715103sheering
sheeting122712833sheeting
shelling123515213shelling
shelving15278173shelving
shending132511253shending
shewing143812193she_wing
shirring122910443shirring
shirting123213613shirting
shocking184311543shocking
shoring112820073shor_ing
shorting122514803shorting
shrewing15228093shrewing
shucking18339433shucking
sicking143720173s_icking
sieging92613203sie_ging
sieving112311233sie_ving
silking123715593s_ilking
simmering1467823simmer_ing
simpering1449293simper_ing
sinking123320543s_inking
siring75128313s_ir_ing
skanking12288743skanking
skeeing12308853ske_eing
skeining1347073skeining
skelping1535973skelping
skewing15318723ske_wing
skinking12299773skinking
skirling13249063skirling
skirring13297143skirring
skirting13289393skirting
skulking12245903skulking
skunking12256653skunking
slacking153914133slacking
slaking123717473s_laking
sleaving123310983sleaving
sledding11248503sledding
sledging11288183sledging
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
slewing113311353sle_wing
slicking153712593slicking
slinking133412983slinking
slurping11278123slurping
slurring9288833slurring
smashing143310243smashing
smerk115412723smerk___
smerked14327283smerk_ed
smerks12449713smerk__s
smiling103915443sm_iling
smirching1744393smirching
smirkier1444433smirkier
smirkily1753333smirkily
smiting103014443sm_iting
smockings18264283smockings
smudging13255723smudging
smushing14287453smushing
smutting11278063smutting
snacking153411703snacking
snaking123915303s_naking
snarfing12358663snarfing
snaring83920953snar_ing
snarling92513183snarling
sneaping11349493sneaping
snedding11246953snedding
sneering93414503sneering
sneezing18267053sneezing
snelling93913563snelling
snicking153610233snicking
snooking133010583snooking
snoring83917203snor_ing
snorting92613373snorting
soaking123116613s_oaking
soaring83521893soar_ing
sobering111912783sober_ing
socking143518603s_ocking
something1545403something
sorbing102815263s_orbing
soring74731883s_or_ing
sorning83116813s_orning
sorting83221813s_orting
sourcing1158353sourcing
souring83219063sour_ing
spanking153911973spanking
sparging122611133sparging
sparing104823873spar_ing
sparkling16226353sparkling
sparling112714533sparling
sparring113112223sparring
speakings16345933speakings
speaning113512243speaning
spearing113216103spearing
speccing15306643speccing
speckling18235583speckling
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spending122712433spending
spermine12311433spermine
spewing133110453spe_wing
sphering142811943spher_ing
spiering112713353spier_ing
spiking144312883s_piking
spiring103918183spir_ing
spirting112913633spirting
spoking143212223s_poking
spooking15269803spooking
sporing104319413spor_ing
sporting112415463sporting
spring94526013s_pr_ing
spunking15258063spunking
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
squeaking2334213squeaking
stacking154215083stacking
staking123919803s_taking
stalking133512223stalking
staring84527053star_ing
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
steading103613593steading
stealing93416603stealing
steaming114013213steaming
steeling93615143steeling
steeping113412583steeping
steering93916793steering
steeving12359653steeving
stemming13408203stemming
stepping13329073stepping
stereoing1037893stereoing
sterlings10308753sterlings
stetting93410713stetting
stewing113412493ste_wing
sticking153513463sticking
stinking133113543stinking
stirring9299653stirring
stocking152912503stocking
stoking123615593s_toking
stooking132711143stooking
storing83921123stor_ing
storming11209423storming
storying12249673storying
streaking142010323streaking
streeking14217453streeking
strewing12289853strewing
striking133012233striking
string75327563s_tr_ing
stroking132610943stroking
submerging1644583submerging
submersing1545843submersing
subring104116263subr_ing
sucking143217413s_ucking
sueding92613753sue_ding
sulking124514313s_ulking
summering1458753summer_ing
supering11317683super_ing
surfing112914483s_urfing
surging93115433s_urging
swanking16399963swanking
swarding1359003swarding
swarming1458223swarming
swearing123711443swearing
sweating123213023sweating
sweeping14389143sweeping
sweeting123911313sweeting
swelling123212753swelling
swinking163410323swinking
swirling12249143swirling
terming104016003_terming
tiering8315253tier_ing
trekking1235543trekking
tweaking1635883tweaking
umbering1399433umber_ing
unerring9311273unerring
ushering1258923usher_ing
veering113213683veer_ing
verging123812303_verging
versing112314193_versing
warking153519573_warking
working153813253_working
wreaking163010213wreaking
wrecking18328153wrecking
yeuking15286123_yeuking
zeroing1738343_zeroing

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.436409841.7
2DLD Change Limit1461624067.70318974.7
3Display Results4064060.1562602.6
 (SQL Overall)1786914068.29521542.0
 
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.