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

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

61 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
pinkie	12	44	1427	(None)
pinkies	13	38	1826	1	pinkies
punkie	12	35	1361	1	punkie
bikie	11	39	1588	2	bi_kie
birkie	12	41	1013	2	birkie
dickie	13	39	1311	2	dickie
dinkier	12	34	1150	2	dinkier
dinkies	12	37	1603	2	dinkies
hankie	13	39	1571	2	hankie
hickie	15	38	1247	2	hickie
hinkier	14	36	1079	2	hinkier
honkie	13	30	1167	2	honkie
hunkie	13	38	1238	2	hunkie
indie	6	37	2147	2	_indie
inkier	10	40	1378	2	_inkier
inkle	9	45	1583	2	_inkle
junkie	17	33	960	2	junkie
kinkier	10	31	943	2	kinkier
minke	11	54	2176	2	mink_e
pantie	8	43	2647	2	pantie
pickier	15	39	1297	2	pickier
pickle	14	42	1565	2	pickle
piggie	10	32	1077	2	piggie
pike	10	63	3521	2	pi_k_e
piki	10	65	2056	2	pi_ki_
pikis	11	51	1639	2	pi_kis
pine	6	77	5571	2	pin__e
pinene	8	29	1564	2	pinene
pinier	8	40	2469	2	pin_ier
pinite	8	3	2124	2	pinite
pink	10	70	3938	2	pink__
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinker	12	53	2244	2	pinker
pinkey	15	43	1467	2	pinkey
pinkeye	16	32	649	2	pinkeye
pinking	14	39	1894	2	pinking
pinkish	16	27	911	2	pinkish
pinkly	15	50	1224	2	pinkly
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
pinky	14	58	2340	2	pink_y
pinnae	8	44	1464	2	pinnae
pinnies	9	33	1844	2	pinnies
pinole	8	32	1878	2	pinole
pintle	8	38	1826	2	pintle
pinyin	11	27	1061	2	pinyin
pipkin	14	24	860	2	pipkin
pixie	14	54	1552	2	pi_xie
pliskie	13	9	454	2	pliskie
punkier	13	35	1279	2	punkier
punkies	13	42	1680	2	punkies
punkin	12	36	1152	2	punkin
sickie	12	37	1574	2	sickie
silkie	10	33	1340	2	silkie
spunkie	13	21	529	2	spunkie
tinkle	10	37	1445	2	tinkle
twinkie	14	3	457	2	twinkie
winkle	13	38	1283	2	winkle

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.343	520965.0
2	DLD Change Limit	82551	61	2.860	28864.0
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	3.219	55511.3