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

Here are the results of your fuzzy-string dictionary search for “cankers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

166 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
cankers	13	44	1875	(None)
bankers	13	39	1909	1	bankers
calkers	13	44	1469	1	calkers
cancers	11	40	1858	1	cancers
caners	8	46	2920	1	can_ers
canker	12	44	2252	1	canker_
canners	9	38	2266	1	canners
canoers	9	43	1837	1	canoers
canters	9	48	2773	1	canters
conkers	13	37	2104	1	conkers
hankers	14	42	1813	1	hankers
rankers	11	32	1746	1	rankers
tankers	11	34	1691	1	tankers
wankers	14	45	1471	1	wankers
angers	7	52	2254	2	_angers
askers	10	59	1540	2	_askers
backers	15	38	2189	2	backers
bakers	12	53	2345	2	ba_kers
balkers	13	49	1572	2	balkers
banders	10	43	2456	2	banders
bangers	10	40	2035	2	bangers
banker	12	42	2273	2	banker_
banners	9	40	1871	2	banners
banters	9	46	2312	2	banters
barkers	13	43	1851	2	barkers
bonkers	13	40	1530	2	bonkers
bunkers	13	37	1595	2	bunkers
cabers	10	50	2392	2	ca_bers
cablers	11	44	1671	2	cablers
cacklers	16	37	1070	2	cacklers
cadgers	11	47	1200	2	cadgers
cagers	9	56	2419	2	ca_gers
cahiers	12	35	1067	2	cahiers
cakes	11	60	3767	2	ca_ke_s
calker	12	49	1708	2	calker_
callers	9	42	2196	2	callers
cambers	13	40	1744	2	cambers
campers	13	42	2029	2	campers
cancels	11	41	1331	2	cancels
cancer	10	42	2092	2	cancer_
candlers	11	42	1410	2	candlers
candors	10	42	1676	2	candors
caner	7	53	3477	2	can_er_
canes	7	53	5037	2	can_e_s
cankered	15	30	1022	2	cankered
cankerous	15	6	605	2	cankerous
cannels	9	34	1336	2	cannels
canner	8	46	2598	2	canner_
cannery	12	36	1001	2	cannery
canoer	8	51	2107	2	canoer_
canoes	8	47	2588	2	canoe_s
canter	8	52	3011	2	canter_
cantors	9	46	2075	2	cantors
capers	10	54	2814	2	ca_pers
cappers	13	44	1940	2	cappers
carders	10	48	2035	2	carders
careers	9	52	1878	2	careers
carers	8	51	3396	2	ca_rers
carpers	11	45	2125	2	carpers
carters	9	53	2725	2	carters
carvers	12	48	1754	2	carvers
caskets	13	39	1017	2	caskets
casters	9	47	2990	2	casters
caters	8	53	3650	2	ca_ters
caulkers	14	37	565	2	caulkers
causers	9	40	1479	2	causers
cavers	11	50	2684	2	ca_vers
censers	9	43	1390	2	censers
centers	9	44	2060	2	centers
chancers	15	43	1349	2	chancers
changers	14	43	1320	2	changers
chanters	13	40	1674	2	chanters
chokers	16	43	1152	2	chokers
cinders	10	46	1776	2	cinders
clackers	16	39	1170	2	clackers
clangers	11	43	1234	2	clangers
clinkers	14	33	983	2	clinkers
clunkers	14	32	755	2	clunkers
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
crackers	16	41	1172	2	crackers
cranker	13	36	1279	2	cranker_
cunners	9	39	1347	2	cunners
dackers	14	34	1704	2	dackers
daikers	12	40	1031	2	daikers
dancers	10	34	1309	2	dancers
danders	9	39	2118	2	danders
dangers	9	48	1821	2	dangers
danker	11	43	1966	2	danker_
dunkers	12	35	1219	2	dunkers
fakers	13	42	1953	2	fa_kers
fanners	10	39	1465	2	fanners
flankers	15	34	930	2	flankers
frankers	15	34	835	2	frankers
funkers	14	37	1206	2	funkers
ganders	9	35	2170	2	ganders
gangers	9	44	1860	2	gangers
gawkers	15	34	745	2	gawkers
hackers	16	46	1904	2	hackers
handers	11	42	2433	2	handers
hangers	11	31	2081	2	hangers
hanker	13	46	2209	2	hanker_
hawkers	17	42	1033	2	hawkers
honkers	14	33	1523	2	honkers
hunkers	14	33	1433	2	hunkers
inkers	10	40	1883	2	_inkers
jackers	20	42	1445	2	jackers
jinkers	18	35	1181	2	jinkers
junkers	18	40	1086	2	junkers
lackers	13	41	2054	2	lackers
lakers	10	52	2515	2	la_kers
lancers	9	36	1664	2	lancers
landers	8	40	2621	2	landers
lanker	10	41	2300	2	lanker_
lanners	7	36	1833	2	lanners
larkers	11	30	1451	2	larkers
linkers	11	43	1771	2	linkers
lunkers	11	34	1460	2	lunkers
makers	12	39	2173	2	ma_kers
mangers	10	35	2126	2	mangers
manners	9	34	1783	2	manners
markers	13	35	1610	2	markers
maskers	13	39	1384	2	maskers
packers	15	38	1889	2	packers
panders	10	34	2373	2	panders
paniers	9	47	1733	2	paniers
panners	9	36	2127	2	panners
panzers	18	40	1201	2	panzers
parkers	13	38	1687	2	parkers
pinkers	13	41	1860	2	pinkers
punkers	13	37	1485	2	punkers
rackers	13	43	2045	2	rackers
rakers	10	41	2357	2	ra_kers
rangers	8	36	2104	2	rangers
ranker	10	50	2190	2	ranker_
ranters	7	33	2364	2	ranters
sackers	13	38	2022	2	sackers
sakers	10	41	2543	2	sa_kers
sanders	8	40	2594	2	sanders
sangers	8	44	2194	2	sangers
scanners	10	37	970	2	scanners
sinkers	11	36	1854	2	sinkers
skankers	11	31	648	2	skankers
spankers	14	36	986	2	spankers
tackers	13	43	1962	2	tackers
takers	10	39	2374	2	ta_kers
talkers	11	35	1321	2	talkers
tanker	10	45	2113	2	tanker_
tanners	7	40	1839	2	tanners
thankers	15	29	783	2	thankers
tinkers	11	35	1714	2	tinkers
vanners	10	36	1284	2	vanners
wakers	13	48	2249	2	wa_kers
walkers	14	34	1147	2	walkers
wanders	11	42	2133	2	wanders
wanker	13	42	1997	2	wanker_
wanters	10	44	2009	2	wanters
winkers	14	35	1711	2	winkers
yakkers	13	30	427	2	yakkers
yonkers	14	37	982	2	yonkers
zanders	17	30	1579	2	zanders

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.373	479064.3
2	DLD Change Limit	107671	166	3.483	30913.3
3	Display Results	166	166	0.046	3608.7
	(SQL Overall)	178691	166	3.902	45794.7