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

132 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
clink11532004(None) 
blink115720141blink
chink145321591chink
clank114719521clank
click135217951click
cline76428531cline
cling86424671cling
clinks125815061clinks
clonk114417441clonk
clunk114215081clunk
link86943441_link
plink115219121plink
slink95422911slink
aline57243152aline
blank115418552blank
blin67228172blin_
blind86319322blind
blini75519272blini
blinks124613572blinks
boink115516332boink
brink116122002brink
cain65643912cain_
cains75334302cains
chick165419132chick
chin96934742chin_
china105022482china
chine105231722chine
chinks155817572chinks
chinky185610542chinky
chino105823312chino
chins105631462chins
chirk144516182chirk
chunk144812382chunk
cine66242942c_ine
clack134720172clack
clan65633922clan_
clang86019312clang
clanks124615182clanks
clanky15469072clanky
clans75031012clans
cleek115514912cleek
clerk115812452clerk
clicks145315112clicks
client8316342client
cliff135917132cliff
clift106422192clift
climb115413592climb
clime95720892clime
clinal8311552clinal
clinch133910352clinch
clines84926042clines
clings95716212clings
clingy12659062clingy
clinic104312792clinic
clinked144011642clinked
clinker133811662clinker
clip86924002cli_p
clips96018302clips
clipt96324272clipt
cloak115214012cloak
clock134917982clock
clon66232482clon_
clone75728162clone
clonks125013472clonks
clons75228132clons
cluck134914892cluck
cluing93913502cluing
clung86013602clung
clunks124811012clunks
clunky15447892clunky
coin66645352coin_
coins75834552coins
colin76231692colin_
colins85229042colins
conk106531442c_onk
crank114819612crank
crick135118752crick
cuing85420192cuing
dink97137802_dink
drink106816382drink
elint55436472elint
fink117532122_fink
flank124618092flank
flick145017212flick
fling97023512fling
flint87333502flint
flunk125014382flunk
gink97129522_gink
glint66830182glint
ink76433632__ink
jink156227202_jink
kink76034402_kink
klick105311432klick
klik74412652kli_k
lank84734452_lank
lick106935072_lick
lin37967372_lin_
line46965572_line
ling57447962_ling
links96430192_links
linky127622382_linky
linn46034592_linn
lino46343372_lino
lins47059052_lins
lint416266232_lint
liny78141322_liny
lunk86030722_lunk
mink106636532_mink
oink85429342_oink
pink107039382_pink
plank115221142plank
plinks124913262plinks
plonk114613982plonk
plunk114514402plunk
prink114719672prink
reink95518092reink
relink104415922relink
rink87736992_rink
sink86640142_sink
skink85916852skink
slank95822772slank
slick115520522slick
sling66028802sling
slinks104315152slinks
slinky13399102slinky
slunk95016302slunk
stink95122502stink
swink125116352swink
think125018802think
unlink104011012unlink
uplink12388712uplink
wink116435022_wink

Search took 2 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.313570897.8
2DLD Change Limit538001321.40338346.4
3Display Results1321320.0334000.0
 (SQL Overall)1786911321.749102167.5
 
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.