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

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

81 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
pinkos	12	53	1387	(None)
pingos	9	53	1767	1	pingos
pinko	11	56	1825	1	pinko_
pinkoes	13	55	1231	1	pinkoes
pinks	11	57	2938	1	pink_s
pintos	8	60	2129	1	pintos
bingos	9	55	1479	2	bingos
bunkos	12	42	1032	2	bunkos
dinks	10	59	2795	2	dink_s
dinos	6	54	2806	2	din_os
epinaos	9	3	628	2	epinaos
finks	12	54	2422	2	fink_s
finos	8	62	2695	2	fin_os
gingkos	13	40	534	2	gingkos
ginkgos	13	31	418	2	ginkgos
ginks	10	43	1956	2	gink_s
infos	8	43	1167	2	_infos
inks	8	69	2650	2	_ink_s
jinks	16	50	1933	2	jink_s
kinks	8	49	2608	2	kink_s
kinos	9	66	2614	2	kin_os
links	9	64	3019	2	link_s
linos	5	56	3150	2	lin_os
minkes	12	46	1878	2	minkes
minks	11	58	2927	2	mink_s
oinks	9	48	1991	2	oink_s
pantos	8	52	2274	2	pantos
pengos	9	46	1241	2	pengos
pianos	8	43	1593	2	pianos
picks	13	52	2614	2	pick_s
pikas	11	42	1809	2	pi_kas
pikes	11	50	3103	2	pi_kes
pikis	11	51	1639	2	pi_kis
pinas	7	54	3445	2	pin_as
pines	7	60	4886	2	pin_es
pingo	8	71	2271	2	pingo_
pingoes	10	51	1652	2	pingoes
pings	8	58	3088	2	pin_gs
pinion	8	38	1589	2	pinion
pinions	9	34	1360	2	pinions
pink	10	70	3938	2	pink__
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinkens	13	41	964	2	pinkens
pinker	12	53	2244	2	pinker
pinkers	13	41	1860	2	pinkers
pinkest	13	28	1262	2	pinkest
pinkey	15	43	1467	2	pinkey
pinkeys	16	37	821	2	pinkeys
pinkie	12	44	1427	2	pinkie
pinkies	13	38	1826	2	pinkies
pinkish	16	27	911	2	pinkish
pinkly	15	50	1224	2	pinkly
pinky	14	58	2340	2	pink_y
pinnas	8	53	1551	2	pinnas
pinon	7	60	2453	2	pin_on
pinons	8	60	1994	2	pinons
pinot	7	87	3729	2	pin_ot
pinots	8	59	2027	2	pinots
pins	6	55	5845	2	pin__s
pintas	8	50	2139	2	pintas
pinto	7	56	2575	2	pinto_
pintoes	9	51	1771	2	pintoes
pints	7	59	3622	2	pin_ts
pinups	10	3	741	2	pinups
pinyon	11	45	976	2	pinyon
pinyons	12	29	900	2	pinyons
piscos	10	51	1259	2	piscos
pisos	7	60	2106	2	pi_sos
plinks	12	49	1326	2	plink_s
prinks	12	43	1538	2	prink_s
punkas	12	34	1067	2	punkas
punks	11	48	2268	2	punk_s
puntos	8	59	1579	2	puntos
rinks	9	48	2710	2	rink_s
sickos	12	51	1203	2	sickos
sinks	9	55	2918	2	sink_s
spintos	9	3	913	2	spintos
vinos	8	47	2307	2	vin_os
winks	12	53	2543	2	wink_s
winos	8	46	2504	2	win_os

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	81	2.563	32208.7
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	2.936	60862.1