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

345 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
skunking1225665(None) 
skanking12288741skanking
skinking12299771skinking
skulking12245901skulking
spunking15258061spunking
bunking144016192_bunking
chunking18328052chunking
clunking15329432clunking
dunking133813262_dunking
flunking16317772flunking
funking154013022_funking
junking193910072_junking
kinking113615152_kinking
konking113510212_konking
plunking15328482plunking
saunaing937012saunaing
sculking15307912sculking
shanking163612282shanking
shucking18339432shucking
shunning12367842shunning
shunting123610422shunting
sinking123320542s_inking
skinning13327892skinning
skulling13258102skulling
skunkier11174282skunkier
slinking133412982slinking
sounding102712872sounding
spanking153911972spanking
stinking133113542stinking
stunning9298462stunning
stunting92811502stunting
sucking143217412s_ucking
sulking124514312s_ulking
sunning83715672s_unning
swanking16399962swanking
swinking163410322swinking
thunking16196952thunking
banking144621353_banking
baulking1536003baulking
blanking154411933blanking
blinking153510623blinking
blunging12328413blunging
blunting11319843blunting
boinking15378423boinking
bonking144116373_bonking
bouncing13318773bouncing
bounding123012133bounding
bucking163617573_bucking
bulking143815123_bulking
bunging113616503_bunging
bunkoing15355643_bunkoing
bunting103718833_bunting
burking143716323_burking
busking144116573_busking
caulking1536803caulking
chinking183210893chinking
chucking20379503chucking
clanking154313063clanking
clinking153611663clinking
clonking153810153clonking
clucking17429993clucking
conking143618453_conking
counting113115263counting
cranking154613073cranking
cunning104214623_cunning
daunting103310403daunting
debunking1733353debunking
dinking133618283_dinking
drinking14308913drinking
ducking154315053_ducking
duking124715133_du_king
dunging103012623_dunging
dunning93514473_dunning
dunting93418383_dunting
dusking133912053_dusking
finking154016603_finking
flanking164211083flanking
fluking154410513flu_king
founding133010783founding
franking164310863franking
fucking173212283_fucking
funding124113663_funding
funning113813613_funning
grunting10269583grunting
gunning93413173_gunning
hanking154619103_hanking
haunting123510053haunting
honking153414793_honking
hounding132610053hounding
hulking153910983_hulking
hunting114317123_hunting
husking154312053_husking
inking115119053__inking
jauking19418323jau_king
jauncing18314783jauncing
jaunting16328633jaunting
jinking193613543_jinking
jouking19307613jou_king
jouncing18336853jouncing
juking183810473_ju_king
kecking134111883_kecking
keeking114210893_keeking
kenning124010543_kenning
kicking133314023_kicking
kinging133115033_kinging
linking123818253_linking
lounging1036753lounging
lucking143615833_lucking
lunging93714213_lunging
lunting83817743_lunting
lurking123710853_lurking
mounding123311263mounding
mounting112711813mounting
mucking163213823_mucking
munting103718773_munting
nuking113411253_nu_king
oinking123714713_oinking
pinking143918943_pinking
planking153513013planking
plinking153611243plinking
plonking15358563plonking
plucking17357723plucking
plunging12357673plunging
pouncing13318883pouncing
pounding123311473pounding
pranking153813383pranking
prinking153212453prinking
pruning10311733prun_ing
puking133913063_pu_king
punkin123611523_punkin_
punkins133111113_punkins
punning103414993_punning
punting103318443_punting
quaking2139313_quaking
ranking124320883_ranking
reinking13311023reinking
rounding102812283rounding
rucking143216673_rucking
runkling13217613_runkling
running83514593_running
sacking144122703s_acking
saining83621393sain_ing
sainting93215733sainting
sanding93520603s_anding
saning75127643s_an_ing
saucing10311003sau_cing
sauteing937913sauteing
scanning113310773scanning
scanting113914763scanting
scending122610583scending
scenting113212813scenting
sconcing1338263sconcing
scubaing1335733scubaing
scudding1335673scudding
scuffing17287113scuffing
sculling112910993sculling
sculping13298943sculping
scumming15256793scumming
seeking124016063s_eeking
seining84020773sein_ing
sending94221373s_ending
sensing84116953s_ensing
shacking184014083shacking
shaking153317253s_haking
sharking163912973sharking
shending132511253shending
shining113816523shin_ing
shinning123211023shinning
shirking163210473shirking
shocking184311533shocking
shrinking1735653shrinking
shuckings19273853shuckings
shunpiking2041343shunpiking
shushing15317743shushing
shuting113212043shu_ting
shutting12309683shutting
sicking143720173s_icking
signing92713963sign_ing
silking123715593s_ilking
singing93221423s_inging
sinning83918443s_inning
skankier11184883skankier
skating123613843sk_ating
skeeing12308853sk_eeing
skeining1347073skeining
skelping1535973skelping
skewing15318723sk_ewing
skidding1535463skidding
skiing113610193sk__iing
skilling132911323skilling
skimming17286273skimming
skimping17306243skimping
skioring13237223skioring
skipping17297603skipping
skirling13249063skirling
skirring13297143skirring
skirting13289393skirting
skiting123812493sk_iting
skiving15298373sk_iving
sklenting1475123sklenting
skoaling13227203skoaling
skunk85011763skunk___
skunked11316193skunk_ed
skunkiest12135083skunkiest
skunks9468163skunk__s
skunky12436163skunk__y
skying14399983sk__ying
slacking153914133slacking
slaking123717473s_laking
slanging103413433slanging
slanting94115093slanting
sleeking133410963sleeking
slicking153712593slicking
slinging103312863slinging
slubbing13248033slubbing
sludging11268363sludging
sluffing15247303sluffing
slugging11339423slugging
sluicing1137063sluicing
sluing74315883slu__ing
slumming13278383slumming
slumping13359973slumping
slurping11278123slurping
slurring9288833slurring
slushing12299643slushing
smacking173510763smacking
smeeking15317833smeeking
smerking15258463smerking
smirking15277233smirking
smocking17349103smocking
smoking143210523s_moking
smudging13255723smudging
smushing14287453smushing
smutting11278063smutting
snacking153411703snacking
snaking123915303s_naking
sneaking133211093sneaking
snicking153610233snicking
snooking133010583snooking
snubbing13236673snubbing
snuffing15256793snuffing
snugging11286933snugging
soaking123116613s_oaking
socking143518603s_ocking
sorning83116813sorn_ing
soughing13259733soughing
soundings11266153soundings
souping104215533sou_ping
sourcing1158353sourcing
souring83219063sou_ring
sousing83517823sou_sing
southing122811823southing
spankings16215003spankings
spanning113311083spanning
sparking152812533sparking
speaking153212493speaking
specking17359733specking
spelunking17112003spelunking
spending122712433spending
spiking144312883s_piking
spinning113310813spinning
spoking143212223s_poking
sponging1238823sponging
spooking15269803spooking
spudding1335653spudding
spuing94313363spu__ing
spuming1248523spu_ming
spunkie13215293spunki_e
spunkier14235813spunkier
spunkies14227583spunkies
spunkily1733773spunkily
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
squaring18158633squaring
squawking2642433squawking
squeaking2334213squeaking
squinting1936223squinting
squiring18177553squiring
stacking154215083stacking
staking123919803s_taking
stalking133512223stalking
standing103413633standing
stanging104013653stanging
staning83922243stan_ing
steeking133411353steeking
sticking153513463sticking
stinging103213453stinging
stinting93415743stinting
stocking152912503stocking
stoking123615593s_toking
stoning83717443ston_ing
stooking132711143stooking
stounding1136233stounding
striking133012233striking
stroking132610943stroking
strunting1037873strunting
stubbing13237453stubbing
studding1136703studding
studying1335553studying
stuffing15247843stuffing
stumming13347673stumming
stumping13289083stumping
subbing123915583s_ubbing
subring104116263s_ubring
suckling152410023s_uckling
sudsing92910323s_udsing
sueding92613753s_ueding
sughing12359713s_ughing
suing65026363s_u__ing
suiting83419003s_uiting
summing122912383s_umming
sunken103511783s_unken_
supping123814533s_upping
surfing112914483s_urfing
surging93115433s_urging
sussing84013703s_ussing
swanning12338813swanning
swinging133411113swinging
swounding1434133swounding
swouning12246563swoun_ing
syncing13177223s_yncing
tanking123918793_tanking
taunting93510933taunting
thanking16409523thanking
thinking16289843thinking
trucking153310163trucking
tsktsking134933tsktsking
tucking143415183_tucking
tuning74016843_tun_ing
tunning83514453_tunning
tusking124212063_tusking
unkind113310573__unkind
unkink9308713__unkink
unkinking1334783unkinking
vaunting12338753vaunting
wanking154216783_wanking
wauking153410013wau_king
winking153317963_winking
wounding13249403wounding
yanking154512463_yanking
yeuking15286123yeu_king
yucking173211693_yucking
yukking14374733_yukking
zonking21359113_zonking

Search took 7 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.1701051123.5
2DLD Change Limit1461623456.53322372.9
3Display Results3453450.1402464.3
 (SQL Overall)1786913456.84326113.0
 
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.