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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

88 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
dinkey	14	48	1276	(None)
dickey	16	59	1352	1	dickey
dikey	13	51	1642	1	di_key
dingey	11	49	1405	1	dingey
dinked	12	48	1835	1	dinked
dinkeys	15	50	726	1	dinkeys
dinkly	14	43	1108	1	dinkly
dinky	13	58	1937	1	dink_y
donkey	14	44	973	1	donkey
pinkey	15	43	1467	1	pinkey
danker	11	43	1966	2	danker
dankly	14	41	946	2	dankly
darkey	14	52	1242	2	darkey
dicey	11	48	1933	2	di_cey
dicked	14	49	2086	2	dicked
dicker	13	45	2140	2	dicker
dickeys	17	47	930	2	dickeys
dicky	15	48	1624	2	dick_y
dike	9	59	3577	2	di_ke_
diked	11	50	2468	2	di_ked
diker	10	55	2455	2	di_ker
dikes	10	58	3133	2	di_kes
dine	5	55	5534	2	din_e_
dined	7	64	3199	2	din_ed
diner	6	56	3290	2	din_er
dines	6	64	4915	2	din_es
dinge	7	56	2730	2	dinge_
dinged	9	52	2178	2	dinged
dinger	8	53	2367	2	dinger
dinges	8	38	2542	2	dinges
dingeys	12	45	840	2	dingeys
dinghy	14	47	696	2	dinghy
dingy	10	57	2126	2	din_gy
dink	9	71	3781	2	dink__
dinkier	12	34	1150	2	dinkier
dinkies	12	37	1603	2	dinkies
dinks	10	59	2795	2	dink_s
dinkum	13	3	589	2	dinkum
dinned	8	43	1761	2	dinned
dinner	7	42	1716	2	dinner
dinted	8	44	1984	2	dinted
dirked	12	49	1227	2	dirked
disked	12	50	1576	2	disked
donkeys	15	42	666	2	donkeys
drinker	12	34	948	2	drinker
dunked	12	43	1528	2	dunked
dunker	11	36	1646	2	dunker
dykey	16	60	867	2	d_ykey
finked	14	42	1462	2	finked
hickey	18	50	1199	2	hickey
hinky	15	56	1875	2	hink_y
honkey	16	51	1382	2	honkey
hunkey	16	42	1088	2	hunkey
inked	10	42	1852	2	_inked
inker	9	44	2109	2	_inker
inky	11	53	2158	2	_ink_y
jinked	18	40	1314	2	jinked
jinker	17	40	1354	2	jinker
kinked	10	40	1475	2	kinked
kinky	11	58	1639	2	kink_y
liney	8	70	2963	2	lin_ey
linked	11	45	1821	2	linked
linker	10	43	2147	2	linker
linky	12	76	2238	2	link_y
linsey	9	3	899	2	linsey
mickey	17	42	1185	2	mickey
minke	11	54	2176	2	minke_
minkes	12	46	1878	2	minkes
monkey	15	37	1059	2	monkey
oinked	11	42	1328	2	oinked
piney	10	57	2750	2	pin_ey
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinker	12	53	2244	2	pinker
pinkeye	16	32	649	2	pinkeye
pinkeys	16	37	821	2	pinkeys
pinkly	15	50	1224	2	pinkly
pinky	14	58	2340	2	pink_y
punkey	15	40	1117	2	punkey
rickey	15	46	1397	2	rickey
sinker	10	36	2090	2	sinker
tinker	10	36	1992	2	tinker
tinkly	13	48	1115	2	tinkly
wincey	14	41	1038	2	wincey
winey	11	53	2543	2	win_ey
winked	14	40	1860	2	winked
winker	13	42	2029	2	winker
zinky	21	53	1481	2	zink_y

Search took 4 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	82551	0.360	496363.9
2	DLD Change Limit	82551	88	2.653	31116.1
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	3.046	58664.1