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

135 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
plink11521912(None) 
blink115720141blink
clink115320041clink
link86943451_link
pink107039391p_ink
plank115221141plank
plinks124913261plinks
plonk114613981plonk
plunk114514401plunk
prink114719671prink
slink95422911slink
uplink12388711uplink
aline57243152aline
blank115418552blank
blin67228172blin_
blind86319322blind
blini75519272blini
blinks124613572blinks
boink115516332boink
brink116122002brink
chink145321592chink
clank114719522clank
click135217952click
cline76428532cline
cling86424672cling
clinks125815062clinks
clonk114417442clonk
clunk114215082clunk
dink97137812_dink
drink106816382drink
elint55436472elint
fink117532132_fink
flank124618092flank
flick145017212flick
fling97023512fling
flint87333502flint
flunk125014382flunk
gink97129532_gink
glint66830182glint
ink76433642__ink
jink156227212_jink
kink76034412_kink
klick105311442klick
klik74412662kli_k
lank84734452_lank
lick106935082_lick
lin37967382_lin_
line46965582_line
ling57447972_ling
links96430192_links
linky127622382_linky
linn46034602_linn
lino46343382_lino
lins47059062_lins
lint416266242_lint
liny78141332_liny
lunk86030722_lunk
mink106636542_mink
oink85429352_oink
paik105726802pai_k
pain65647242pain_
pains75138282pains
paint75443692paint
paling93530132paling
pein65834942pein_
peins76128062peins
pick125933822p_ick
piing85218832piing
piling95025592piling
pin57066732p_in_
pina65842642p_ina
pine67755722p_ine
ping75943602p_ing
pinko115618252p_inko
pinks115729382p_inks
pinky145823402p_inky
pins65558462p_ins
pint66963182p_int
piny911838362p_iny
plack135017842plack
plain74823302plain_
plains85019592plains
plaint85323202plaint
plan65833942plan_
plane74929142plane
planks124116752planks
plans75731272plans
plant75437112plant
plena75816392plena
pliant83918822pliant
plica9613372plica
plie65127392pli_e
plied85118592plied
plier75221282plier
plies74526512plies
plinked143910892plinked
plinker134010972plinker
plinth11310452plinth
plisky1533712plisky
plonks124210422plonks
pluck134212302pluck
plunks124711162plunks
plunky15377952plunky
plying124312082plying
poind84217912poind
point75338732point
poling93526502poling
prank115019452prank
prick134317502prick
prinks124315382prinks
print74837462print
pulik113613302puli_k
puling93621402puling
punk105729972p_unk
pyin96823232pyin_
pyins105815862pyins
reink95518092reink
relink104415922relink
rink87737002_rink
sink86640152_sink
skink85916862skink
slank95822772slank
slick115520522slick
sling66028802sling
slinks104315152slinks
slinky13399102slinky
slunk95016302slunk
spline86020532spline
splint85223282splint
stink95122502stink
swink125116352swink
think125018802think
unlink104011012unlink
uplinks13345612uplinks
wink116435032_wink

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538001352.39322482.2
3Display Results1351350.0304500.0
 (SQL Overall)1786911352.73365382.7
 
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.