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 “silking” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
silking12371559(None) 
bilking144413551bilking
milking143712761milking
sicking143720171sicking
siloing83215501siloing
silting83320481silting
sinking123320541sinking
sulking124514311sulking
ailing74331012ail_ing
balking143717352balking
biking135018172bi_king
bilging114212682bilging
billing103823852billing
bulking143815122bulking
calking144617782calking
dicking153617612dicking
diking124320242di_king
dinking133618282dinking
dirking133812602dirking
disking134615492disking
erlking1236702erlking
filing103823762fil_ing
filling113520802filling
filming133210352filming
finking154016602finking
gilding103813002gilding
gilling93520382gilling
hiking143617102hi_king
hilding123713532hilding
hilling113821772hilling
hilting113316892hilting
holking153512312holking
hulking153910982hulking
inking115119052_inking
irking114611752_irking
isling71213882isl_ing
jilting153211742jilting
jinking193613542jinking
kicking133314022kicking
killing123118722killing
kilning12289022kilning
kilting123213852kilting
kinking113615152kinking
licking144118282licking
liking114319582li_king
lilting83515382lilting
linking123818252linking
miking134218462mi_king
milding113615452milding
milling103223682milling
milting103619122milting
nicking143516322nicking
nilling83619562nilling
oiling74925312oil_ing
oinking123714712oinking
picking163418332picking
piking133719642pi_king
piling95025592pil_ing
pilling103722562pilling
pinking143918942pinking
ricking143920232ricking
riling74227972ril_ing
rilling84023622rilling
risking123914242risking
sacking144122702sacking
sailing83927372sail_ing
salting84120792salting
salving113913152salving
sculking15307912sculking
seeking124016062seeking
selfing112911622selfing
selling83225832selling
shaking153317252shaking
shilling123315382shilling
shirking163210472shirking
sibling10814422sibling
siccing12319512siccing
sickling152910332sickling
siding83822132si_ding
sidling9915422sidling
sieging92613202sieging
sieving112311232sieving
sifting113014592sifting
sighing123311662sighing
signing92713962signing
silken104410852silken_
silkie103313402silki_e
silkier114411642silkier
silkies113715692silkies
silkily14236962silkily
singing93221422singing
sinning83918442sinning
siping94220632si_ping
sipping123117432sipping
siring75128312si_ring
siskin1079782siskin_
siskins1159582siskins
siting74126622si_ting
sitting83519632sitting
sizing163616442si_zing
skilling132911332skilling
skinking12299772skinking
skulking12245902skulking
slaking123717472slaking
slicing103514642slicing
slicking153712592slicking
sliding93114552sliding
sliming102913952sliming
sling66028802s_l_ing
slinking133412982slinking
sliping103314412sliping
sluing74315882s_luing
smiling103915442smil_ing
smirking15277232smirking
smoking143210522smoking
snaking123915302snaking
snicking153610232snicking
soaking123116612soaking
socking143518602socking
soiling83422322soil_ing
soling74226822sol_ing
soloing82813802soloing
solving112910852solving
spiking144312882spiking
spiling102919702spil_ing
spilling113113942spilling
spoking143212222spoking
staking123919802staking
stalking133512222stalking
sticking153513462sticking
stilling93415322stilling
stilting93312402stilting
stinking133113542stinking
stoking123615592stoking
sucking143217412sucking
swilling123511932swilling
swinking163410322swinking
talking123815822talking
ticking143218752ticking
tiling73426552til_ing
tilling83522782tilling
tilting83417102tilting
viking143414612vi_king
walking154013302walking
wicking173414772wicking
wilding123814292wilding
wiling103024292wil_ing
willing113821612willing
wilting113515912wilting
winking153317962winking

Search took 4 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 Filter1786911076710.406440125.6
2DLD Change Limit1076711503.31332499.5
3Display Results1501500.0463260.9
 (SQL Overall)1786911503.76547461.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.