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

Here are the results of your fuzzy-string dictionary search for “pinkey” 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.

92 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
pinkey	15	43	1467	(None)
dinkey	14	48	1276	1	dinkey
piney	10	57	2750	1	pin_ey
pinked	13	48	1988	1	pinked
pinken	12	45	1328	1	pinken
pinker	12	53	2244	1	pinker
pinkeye	16	32	649	1	pinkeye
pinkeys	16	37	821	1	pinkeys
pinkly	15	50	1224	1	pinkly
pinky	14	58	2340	1	pink_y
punkey	15	40	1117	1	punkey
dickey	16	59	1352	2	dickey
dikey	13	51	1642	2	di_key
dingey	11	49	1405	2	dingey
dinked	12	48	1835	2	dinked
dinkeys	15	50	726	2	dinkeys
dinkly	14	43	1108	2	dinkly
dinky	13	58	1937	2	dink_y
donkey	14	44	973	2	donkey
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	1638	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
picked	15	44	2131	2	picked
picker	14	44	2217	2	picker
picket	14	49	2431	2	picket
picky	16	54	1694	2	pick_y
pike	10	63	3521	2	pi_ke_
piked	12	56	2331	2	pi_ked
piker	11	56	2284	2	pi_ker
pikes	11	50	3103	2	pi_kes
pincer	10	40	1917	2	pincer
pinder	9	45	2345	2	pinder
pine	6	77	5571	2	pin_e_
pined	8	59	3532	2	pin_ed
pinery	11	52	1429	2	pinery
pines	7	60	4886	2	pin_es
pinged	10	43	2138	2	pinged
pinger	9	43	2409	2	pinger
pinier	8	40	2469	2	pinier
pink	10	70	3938	2	pink__
pinkens	13	41	964	2	pinkens
pinkers	13	41	1860	2	pinkers
pinkest	13	28	1262	2	pinkest
pinkeyes	17	33	597	2	pinkeyes
pinkie	12	44	1427	2	pinkie
pinkies	13	38	1826	2	pinkies
pinko	11	56	1825	2	pink_o
pinkoes	13	55	1231	2	pinkoes
pinkos	12	53	1387	2	pinkos
pinks	11	57	2938	2	pink_s
pinned	9	48	1838	2	pinned
pinner	8	45	2150	2	pinner
pinny	10	52	2206	2	pin_ny
piny	9	118	3835	2	pin__y
plinked	14	39	1089	2	plinked
plinker	13	40	1096	2	plinker
pokey	14	53	1897	2	p_okey
prinked	14	34	1216	2	prinked
prinker	13	34	1274	2	prinker
punker	12	37	1882	2	punker
punkeys	16	36	649	2	punkeys
punky	14	44	1939	2	punk_y
rickey	15	46	1397	2	rickey
sinker	10	36	2090	2	sinker
spikey	15	54	1133	2	spi_key
spinney	12	43	892	2	spinney
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 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	82551	0.343	520965.0
2	DLD Change Limit	82551	92	2.610	31628.7
3	Display Results	92	92	0.016	5750.0
	(SQL Overall)	178691	92	2.969	60185.6