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

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

97 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
yonker	13	41	1085	(None)
conker	12	47	2155	1	conker
honker	13	41	1746	1	honker
yonder	10	32	1413	1	yonder
yonkers	14	37	982	1	yonkers
younker	14	31	645	1	younker
banker	12	42	2273	2	banker
bonder	9	53	2478	2	bonder
boner	7	51	3308	2	bon_er
bonier	8	43	2199	2	bonier
bonked	13	55	1731	2	bonked
bonkers	13	40	1530	2	bonkers
bonzer	17	53	1367	2	bonzer
booker	12	47	1919	2	booker
bosker	12	38	1365	2	bosker
bunker	12	45	1937	2	bunker
canker	12	44	2252	2	canker
cocker	14	43	2039	2	cocker
confer	11	40	1868	2	confer
conger	9	50	2427	2	conger
conked	13	50	1911	2	conked
conkers	13	37	2104	2	conkers
conner	8	44	2396	2	conner
cooker	12	47	2245	2	cooker
corker	12	47	2085	2	corker
danker	11	43	1966	2	danker
docker	13	44	1765	2	docker
donkey	14	44	973	2	donkey
dunker	11	36	1646	2	dunker
fonder	10	41	2006	2	fonder
forker	13	47	1790	2	forker
funker	13	39	1576	2	funker
goner	6	60	2516	2	gon_er
hanker	13	46	2209	2	hanker
hocker	15	51	1856	2	hocker
honer	8	53	3209	2	hon_er
honked	14	45	1791	2	honked
honkers	14	33	1523	2	honkers
honkey	16	51	1382	2	honkey
hooker	13	48	2017	2	hooker
hunker	13	39	1767	2	hunker
inker	9	44	2109	2	_inker
jinker	17	40	1354	2	jinker
joker	16	57	1589	2	jo_ker
junker	17	42	1365	2	junker
konked	10	40	1058	2	konked
lanker	10	41	2300	2	lanker
linker	10	43	2147	2	linker
locker	12	40	1942	2	locker
loner	5	54	3104	2	lon_er
longer	7	58	2320	2	longer
looker	10	48	1695	2	looker
lunker	10	47	1834	2	lunker
mocker	14	33	1544	2	mocker
monger	9	44	1833	2	monger
moniker	13	3	867	2	moniker
monkery	16	31	745	2	monkery
monkey	15	37	1059	2	monkey
ocker	11	39	1575	2	_ocker
pinker	12	53	2244	2	pinker
poker	11	51	2288	2	po_ker
ponder	9	45	2169	2	ponder
porker	12	49	1754	2	porker
punker	12	37	1882	2	punker
ranker	10	50	2190	2	ranker
rocker	12	43	1957	2	rocker
sinker	10	36	2090	2	sinker
soaker	10	57	1753	2	soaker
sonder	7	36	2352	2	sonder
tanker	10	45	2112	2	tanker
tinker	10	36	1992	2	tinker
toker	9	59	2491	2	to_ker
toner	5	53	3624	2	ton_er
tonger	7	47	1968	2	tonger
tonier	6	55	2071	2	tonier
tonner	6	48	1920	2	tonner
wanker	13	42	1997	2	wanker
winker	13	42	2029	2	winker
wonder	10	36	1781	2	wonder
wonkier	14	3	742	2	wonkier
wonner	9	51	1444	2	wonner
worker	13	47	1511	2	worker
yakker	12	40	553	2	yakker
yanked	14	43	1224	2	yanked
yocked	16	41	1442	2	yocked
yodler	10	38	994	2	yodler
yoke	11	56	2639	2	yo_ke_
yoked	13	48	2162	2	yo_ked
yokel	12	48	1261	2	yo_kel
yokes	12	52	2302	2	yo_kes
yolked	14	36	715	2	yolked
yolkier	14	33	612	2	yolkier
younger	11	38	716	2	younger
younkers	15	29	576	2	younkers
yowler	12	33	1004	2	yowler
zoner	14	45	2034	2	zon_er
zonked	20	42	947	2	zonked

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	97	2.093	39441.5
3	Display Results	97	97	0.030	3233.3
	(SQL Overall)	178691	97	2.466	72461.9