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

224 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
konk7932061(None) 
bonk105531711bonk
conk106531441conk
honk116931191honk
kink76034401kink
konks84917111konks
kook75822601kook
monk105928521monk
wonk116125301wonk
zonk175018621zonk
bank105835752bank
bock126032512bock
boink115516332boink
bond75334362bond
bone65949322bone
bong75633412bong
bonks116326462bonks
bony96732082bony
book106836332book
bork106933822bork
bosk105825732bosk
bunk105731352bunk
clonk114417442clonk
cock126332902cock
con510268022con_
cone67256962cone
coni65534802coni
conks115525702conks
conky145818742conky
conn66229132conn
cons66057692cons
cony96537832cony
cook107236932cook
cork106635692cork
dank95828242dank
dink97137802dink
dock116228742dock
don46757652don_
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
dork96531462dork
dunk96228572dunk
eon36052082eon_
eons46638712eons
fink117532122fink
folk116021542folk
fon66352272fon_
fond86330952fond
fons76943892fons
font77143752font
fork115930942fork
funk115825622funk
gink97129522gink
gone55639042gone
gong66827192gong
gook96429602gook
gowk125516472gowk
gunk95423572gunk
hank115134142hank
hock136031302hock
holk116027942holk
hon67759382hon_
hone77549322hone
hong85833952hong
honks125124522honks
honky156218522honky
hons77350782hons
hook116133282hook
howk145221962howk
hunk116029542hunk
ikon85814952ikon_
ikons96311012ikons
ink76433632_ink
ion36051022ion_
ions46737852ions
jink156227202jink
jock176522642jock
jouk156015992jouk
junk155121032junk
kana85928532kana
kane85133972kane
kaon87521022kaon_
kaons95014852kaons
keck94920712keck
keek75624972keek
ken76343982ken_
keno87926432keno
kens85435232kens
kent86846962kent
kick96026072kick
kin76353972kin_
kina85632002kina
kind96128562kind
kine85643432kine
king95933662king
kinks84926082kinks
kinky115816382kinky
kino86233622kino
kins85747912kins
kiosk836232kiosk
kirk76221572kirk
klik74412652klik
klong105310402klong
knob107417012knob
knock10487962knock
knop107116592knop
knot85630502knot
know116115842know
koa76737772ko_a
koan85425032koan
koans95818622koans
koas85635092koas
kob99442382ko_b
kobo107422102kobo
kobs105831082kobs
koel84519942koel
kohl113911712kohl
koi77534752ko_i
koine9516482koine
kois85129402kois
koji155611122koji
kola85124962kola
kolo87026222kolo
konked104010582konked
kooks85217262kooks
kooky114412872kooky
kop97440202ko_p
kopek1037812kopek
koph135816542koph
kops107031292kops
kor76538892ko_r
kora86431552kora
kore85834162kore
kors85933012kors
kos76944822ko_s
koss85224812koss
koto86323472koto
krona93611792krona
krone94018732krone
kuna85120702kuna
kune85424572kune
kyak105213632kyak
lank84734452lank
link86943442link
lock106134362lock
lone45849132lone
long56933342long
look87333472look
lunk86030722lunk
mink106636532mink
mock126429442mock
mon57561582mon_
monks116123392monks
mono66036722mono
mons68152262mons
mony96830012mony
mosk105622442mosk
nock106127182nock
nona46929062nona
none45743172none
nook85728492nook
oak76238652_oak
oink85429342oink
on28057182_on_
one37050912_one
ono36838032_ono
ons36148512_ons
pink107039382pink
plonk114613982plonk
pock126129292pock
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
pork106929682pork
punk105729972punk
rank85135532rank
rink87736992rink
rock105735182rock
rook85532032rook
sank85236832sank
sink86640142sink
skank84415582skank
skink85916852skink
skunk85011762skunk
soak87227662soak
sock105233212sock
son37761952son_
sone46649982sone
song55133672song
sons46049552sons
sook84933392sook
souk86127172souk
sunk85031812sunk
tank85134022tank
ton310265102ton_
tone46953742tone
tong56434352tong
tons46553052tons
tony75635152tony
took86531072took
wank115632512wank
wink116435022wink
wok106334172wo_k
won66252062won_
wonks124818342wonks
wonky154011772wonky
wons74942042wons
wont75842502wont
work115528842work
yank115423672yank
yock135924612yock
yok107335242yo_k
yolk116218992yolk
yon67348952yon_
yond86122312yond
yoni77524392yoni
zona136321962zona
zone135231082zone
zonks184815172zonks
zouk174413542zouk

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 Filter178691298720.436409841.7
2DLD Change Limit298722241.44020744.4
3Display Results2242240.0464869.6
 (SQL Overall)1786912241.92292971.4
 
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.