Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “dink” with Change Limit: [1] [2]

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

292 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
dink	9	71	3780	(None)
dank	9	58	2824	1	dank
dick	11	64	3238	1	dick
din	4	64	5946	1	din_
dine	5	55	5533	1	dine
ding	6	69	4095	1	ding
dinks	10	59	2795	1	dinks
dinky	13	58	1937	1	dinky
dino	5	60	3675	1	dino
dins	5	66	5204	1	dins
dint	5	67	5905	1	dint
dirk	9	63	2683	1	dirk
disk	9	66	2583	1	disk
drink	10	68	1638	1	drink
dunk	9	62	2857	1	dunk
fink	11	75	3212	1	fink
gink	9	71	2952	1	gink
ink	7	64	3363	1	_ink
jink	15	62	2720	1	jink
kink	7	60	3439	1	kink
link	8	69	4344	1	link
mink	10	66	3653	1	mink
oink	8	54	2934	1	oink
pink	10	70	3938	1	pink
rink	8	77	3699	1	rink
sink	8	66	4014	1	sink
wink	11	64	3502	1	wink
ain	3	75	7909	2	ain_
ains	4	61	5888	2	ains
bank	10	58	3575	2	bank
bilk	10	58	2442	2	bilk
bin	5	66	5864	2	bin_
bind	7	62	3451	2	bind
bine	6	66	5086	2	bine
bins	6	65	4825	2	bins
bint	6	73	5504	2	bint
birk	10	63	2686	2	birk
bisk	10	65	2335	2	bisk
blink	11	57	2014	2	blink
boink	11	55	1633	2	boink
bonk	10	55	3171	2	bonk
brink	11	61	2200	2	brink
bunk	10	57	3135	2	bunk
chink	14	53	2159	2	chink
cine	6	62	4294	2	cine
clink	11	53	2004	2	clink
conk	10	65	3144	2	conk
dak	8	63	4069	2	d_ak
dan	4	68	5967	2	dan_
dang	6	51	3154	2	dang
dans	5	67	4815	2	dans
dark	9	51	3321	2	dark
dawk	12	61	1728	2	dawk
deck	11	58	2775	2	deck
den	4	75	5434	2	den_
dene	5	66	4341	2	dene
deni	5	69	2939	2	deni
dens	5	59	4507	2	dens
dent	5	71	5841	2	dent
deny	8	60	2712	2	deny
desk	9	56	1890	2	desk
dhak	12	55	1203	2	dhak
dial	5	59	3506	2	dial
dib	6	57	4694	2	di_b
dibs	7	62	3368	2	dibs
dice	7	58	4189	2	dice
dicks	12	58	2469	2	dicks
dicky	15	48	1624	2	dicky
did	5	68	5051	2	di_d
dido	6	65	2819	2	dido
didy	9	91	2150	2	didy
die	4	67	5965	2	di_e
died	6	61	3785	2	died
diel	5	90	3460	2	diel
diene	6	57	2013	2	diene
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dif	7	68	4690	2	di_f
diff	11	62	2884	2	diff
difs	8	60	2732	2	difs
dig	5	75	4447	2	di_g
digs	6	60	3605	2	digs
dike	9	59	3576	2	dike
dill	5	52	3997	2	dill
dim	6	81	4649	2	di_m
dime	7	62	3764	2	dime
dims	7	54	3502	2	dims
dinar	6	63	1989	2	dinar
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
dinge	7	56	2730	2	dinge
dingo	7	47	2079	2	dingo
dings	7	63	3140	2	dings
dingy	10	57	2126	2	dingy
dinked	12	48	1835	2	dinked
dinkey	14	48	1276	2	dinkey
dinkly	14	43	1108	2	dinkly
dinkum	13	3	589	2	dinkum
dinos	6	54	2806	2	dinos
dints	6	74	3131	2	dints
diol	5	73	2913	2	diol
dip	6	78	4898	2	di_p
dips	7	55	3691	2	dips
dipt	7	73	3932	2	dipt
dire	5	66	4414	2	dire
dirks	10	56	1952	2	dirks
dirl	5	74	3002	2	dirl
dirt	5	55	5038	2	dirt
dis	4	64	5989	2	di_s
disc	7	61	2323	2	disc
dish	8	63	2833	2	dish
disks	10	54	1747	2	disks
diss	5	64	3448	2	diss
dit	4	70	7133	2	di_t
dita	5	60	3252	2	dita
dite	5	55	4755	2	dite
dits	5	64	5052	2	dits
ditz	14	69	2951	2	ditz
diva	8	59	2088	2	diva
dive	8	56	3477	2	dive
djin	12	9	1163	2	djin_
djinn	13	5	563	2	djinn
djins	13	6	845	2	djins
dock	11	62	2874	2	dock
doing	7	49	2358	2	doing
don	4	67	5765	2	don_
dona	5	55	2963	2	dona
done	5	57	4791	2	done
dong	6	60	3165	2	dong
dons	5	60	4870	2	dons
dork	9	65	3146	2	dork
drank	10	48	1620	2	drank
drek	9	63	2109	2	drek
drinks	11	68	1071	2	drinks
drunk	10	54	984	2	drunk
duck	11	59	2917	2	duck
dun	4	65	4558	2	dun_
dune	5	61	3758	2	dune
dung	6	63	2843	2	dung
dunks	10	56	2119	2	dunks
duns	5	51	4043	2	duns
dunt	5	57	4687	2	dunt
dusk	9	57	2415	2	dusk
dwine	9	56	1614	2	dwine
dying	10	53	1603	2	dying
dyne	8	53	2093	2	dyne
fin	6	64	5803	2	fin_
find	8	75	3260	2	find
fine	7	51	4795	2	fine
finks	12	54	2422	2	finks
fino	7	60	3469	2	fino
fins	7	58	4909	2	fins
funk	11	58	2562	2	funk
gin	4	60	5575	2	gin_
ginks	10	43	1956	2	ginks
gins	5	55	4395	2	gins
gunk	9	54	2357	2	gunk
hank	11	51	3414	2	hank
hick	13	55	3030	2	hick
hin	6	75	5956	2	hin_
hind	8	55	2975	2	hind
hinky	15	56	1875	2	hinky
hins	7	64	4799	2	hins
hint	7	74	5574	2	hint
honk	11	69	3119	2	honk
hunk	11	60	2954	2	hunk
ick	9	73	2932	2	_ick
ilk	7	83	2530	2	_ilk
in	2	81	5086	2	_in_
inks	8	69	2650	2	_inks
inky	11	53	2158	2	_inky
inn	3	67	2743	2	_inn
ins	3	59	4560	2	_ins
irk	7	64	2636	2	_irk
jin	10	64	4393	2	jin_
jinks	16	50	1933	2	jinks
jinn	11	54	2024	2	jinn
jins	11	56	3501	2	jins
jinx	18	55	1657	2	jinx
junk	15	51	2103	2	junk
kick	9	60	2606	2	kick
kin	7	63	5396	2	kin_
kina	8	56	3199	2	kina
kind	9	61	2855	2	kind
kine	8	56	4342	2	kine
king	9	59	3365	2	king
kinks	8	49	2608	2	kinks
kinky	11	58	1638	2	kinky
kino	8	62	3361	2	kino
kins	8	57	4790	2	kins
kirk	7	62	2156	2	kirk
konk	7	93	2061	2	konk
lank	8	47	3445	2	lank
lick	10	69	3507	2	lick
lin	3	79	6737	2	lin_
line	4	69	6557	2	line
ling	5	74	4796	2	ling
links	9	64	3019	2	links
linky	12	76	2238	2	linky
linn	4	60	3459	2	linn
lino	4	63	4337	2	lino
lins	4	70	5905	2	lins
lint	4	162	6623	2	lint
liny	7	81	4132	2	liny
lunk	8	60	3072	2	lunk
mick	12	63	3343	2	mick
milk	10	50	2847	2	milk
mina	6	51	3692	2	mina
mind	7	54	3438	2	mind
mine	6	72	5617	2	mine
mini	6	56	3456	2	mini
minke	11	54	2176	2	minke
minks	11	58	2927	2	minks
mint	6	67	5806	2	mint
minx	13	77	2335	2	minx
mirk	10	67	2950	2	mirk
monk	10	59	2852	2	monk
nick	10	66	2760	2	nick
nine	4	58	4217	2	nine
oinks	9	48	1991	2	oinks
pick	12	59	3381	2	pick
pin	5	70	6672	2	pin_
pina	6	58	4263	2	pina
pine	6	77	5571	2	pine
ping	7	59	4359	2	ping
pinko	11	56	1825	2	pinko
pinks	11	57	2938	2	pinks
pinky	14	58	2340	2	pinky
pins	6	55	5845	2	pins
pint	6	69	6317	2	pint
piny	9	118	3835	2	piny
plink	11	52	1912	2	plink
prink	11	47	1967	2	prink
punk	10	57	2997	2	punk
rank	8	51	3553	2	rank
reink	9	55	1809	2	reink
rick	10	73	3465	2	rick
rin	3	66	6318	2	rin_
rind	5	65	3560	2	rind
ring	5	65	4115	2	ring
rinks	9	48	2710	2	rinks
rins	4	61	5319	2	rins
risk	8	57	2410	2	risk
sank	8	52	3683	2	sank
sick	10	64	3557	2	sick
silk	8	55	2932	2	silk
sin	3	62	6589	2	sin_
sine	4	65	6062	2	sine
sing	5	75	4417	2	sing
sinh	7	62	3804	2	sinh
sinks	9	55	2918	2	sinks
sins	4	67	5527	2	sins
skink	8	59	1685	2	skink
slink	9	54	2291	2	slink
stink	9	51	2250	2	stink
sunk	8	50	3181	2	sunk
swink	12	51	1635	2	swink
tank	8	51	3402	2	tank
think	12	50	1880	2	think
tick	10	62	3122	2	tick
tin	3	63	6217	2	tin_
tine	4	58	5513	2	tine
ting	5	61	3990	2	ting
tins	4	52	5130	2	tins
tint	4	67	5886	2	tint
tiny	7	61	3463	2	tiny
vina	7	63	3180	2	vina
vine	7	56	4368	2	vine
vino	7	61	2843	2	vino
viny	10	60	2595	2	viny
wank	11	56	3251	2	wank
wick	13	57	2630	2	wick
win	6	64	5629	2	win_
wind	8	55	3385	2	wind
wine	7	49	5342	2	wine
wing	8	63	3922	2	wing
winks	12	53	2543	2	winks
wino	7	59	3361	2	wino
wins	7	59	4917	2	wins
winy	10	70	3432	2	winy
wonk	11	61	2530	2	wonk
yank	11	54	2367	2	yank
yin	6	76	4873	2	yin_
yins	7	53	3512	2	yins
zin	12	56	4377	2	zin_
zinc	15	68	1909	2	zinc
zine	13	70	3615	2	zine
zing	14	57	2861	2	zing
zinky	21	53	1481	2	zinky
zins	13	57	3500	2	zins
zonk	17	50	1862	2	zonk

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	29872	0.156	1145455.1
2	DLD Change Limit	29872	292	2.653	11259.7
3	Display Results	292	292	0.080	3650.0
	(SQL Overall)	178691	292	2.889	61852.2