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

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

78 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
yonkers	14	37	982	(None)
bonkers	13	40	1530	1	bonkers
conkers	13	37	2104	1	conkers
honkers	14	33	1523	1	honkers
yonker	13	41	1085	1	yonker_
younkers	15	29	576	1	younkers
bankers	13	39	1909	2	bankers
bonders	10	41	2066	2	bonders
boners	8	48	2543	2	bon_ers
bookers	13	40	1661	2	bookers
bunkers	13	37	1595	2	bunkers
cankers	13	44	1875	2	cankers
cockers	15	36	1833	2	cockers
confers	12	41	2009	2	confers
congers	10	42	2323	2	congers
conker	12	47	2155	2	conker_
conners	9	40	2311	2	conners
cookers	13	46	1946	2	cookers
corkers	13	41	1885	2	corkers
dockers	14	37	1500	2	dockers
donkeys	15	42	666	2	donkeys
dunkers	12	35	1219	2	dunkers
forkers	14	46	1578	2	forkers
funkers	14	37	1206	2	funkers
goners	7	44	2017	2	gon_ers
hankers	14	42	1813	2	hankers
hockers	16	39	1591	2	hockers
honers	9	43	2497	2	hon_ers
honker	13	41	1746	2	honker_
honkeys	17	43	951	2	honkeys
hookers	14	49	1651	2	hookers
hunkers	14	33	1433	2	hunkers
inkers	10	40	1883	2	_inkers
jinkers	18	35	1181	2	jinkers
jokers	17	55	1119	2	jo_kers
junkers	18	40	1086	2	junkers
linkers	11	43	1771	2	linkers
lockers	13	35	1692	2	lockers
loners	6	42	2581	2	lon_ers
longers	8	48	1954	2	longers
lookers	11	40	1407	2	lookers
lunkers	11	34	1460	2	lunkers
mockers	15	38	1294	2	mockers
mongers	10	42	1727	2	mongers
monikers	14	3	741	2	monikers
monkery	16	31	745	2	monkery
monkeys	16	40	742	2	monkeys
ockers	12	38	1390	2	_ockers
pinkers	13	41	1860	2	pinkers
pokers	12	46	1792	2	po_kers
ponders	10	36	1884	2	ponders
porkers	13	43	1493	2	porkers
punkers	13	37	1485	2	punkers
rankers	11	32	1746	2	rankers
rockers	13	39	1655	2	rockers
sinkers	11	36	1854	2	sinkers
soakers	11	41	1495	2	soakers
sonders	8	38	2071	2	sonders
tankers	11	34	1691	2	tankers
tinkers	11	35	1714	2	tinkers
tokers	10	48	1889	2	to_kers
toners	6	41	2800	2	ton_ers
tongers	8	41	1601	2	tongers
tonners	7	38	1640	2	tonners
wankers	14	45	1471	2	wankers
winkers	14	35	1711	2	winkers
wonders	11	33	1599	2	wonders
wonners	10	43	1281	2	wonners
workers	14	46	1269	2	workers
yakkers	13	30	427	2	yakkers
yodlers	11	29	892	2	yodlers
yokels	13	48	806	2	yo_kels
yokes	12	52	2302	2	yo_ke_s
yonder	10	32	1413	2	yonder_
youngers	12	33	693	2	youngers
younker	14	31	645	2	younker_
yowlers	13	32	892	2	yowlers
zoners	15	51	1599	2	zon_ers

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	107671	0.356	501941.0
2	DLD Change Limit	107671	78	2.766	38926.6
3	Display Results	78	78	0.016	4875.0
	(SQL Overall)	178691	78	3.138	56944.2