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

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

54 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
cannery	12	36	1001	(None)
canner	8	46	2598	1	canner_
canners	9	38	2266	1	canners
tannery	10	38	866	1	tannery
banner	8	44	2150	2	banner_
banners	9	40	1871	2	banners
canary	11	3	1469	2	ca_nary
cancer	10	42	2092	2	cancer_
cancers	11	40	1858	2	cancers
caner	7	53	3477	2	ca_ner_
caners	8	46	2920	2	ca_ners
canker	12	44	2252	2	canker_
cankers	13	44	1875	2	cankers
canned	9	50	2206	2	canne_d
cannel	8	42	1640	2	canne_l
cannels	9	34	1336	2	cannels
cannier	9	40	1416	2	cannier_
cannily	12	3	926	2	cannily
cannonry	13	4	329	2	cannonry
canny	10	58	1769	2	cann__y
canoer	8	51	2107	2	canoer_
canoers	9	43	1837	2	canoers
canonry	12	3	592	2	canonry
canter	8	52	3011	2	canter_
canters	9	48	2773	2	canters
carney	11	53	1570	2	carne_y
cattery	12	38	1160	2	cattery
cautery	12	34	959	2	cautery
chancery	18	36	665	2	chancery
cindery	13	42	919	2	cindery
conner	8	44	2396	2	conner_
conners	9	40	2311	2	conners
cunner	8	39	1500	2	cunner_
cunners	9	39	1347	2	cunners
fanner	9	42	1818	2	fanner_
fanners	10	39	1465	2	fanners
gunnery	11	37	637	2	gunnery
hennery	13	3	530	2	hennery
lanner	6	49	2060	2	lanner_
lanners	7	36	1833	2	lanners
manner	8	40	2051	2	manner_
mannerly	13	4	498	2	mannerly
manners	9	34	1783	2	manners
nunnery	10	35	530	2	nunnery
panner	8	42	2476	2	panner_
panners	9	36	2127	2	panners
scanner	9	44	1181	2	scanner_
scanners	10	37	970	2	scanners
swannery	14	3	355	2	swannery
tanner	6	37	2228	2	tanner_
tanners	7	40	1839	2	tanners
vanner	9	42	1584	2	vanner_
vanners	10	36	1284	2	vanners
wanner	9	40	1962	2	wanner_

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.360	496363.9
2	DLD Change Limit	107671	54	3.280	32826.5
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	3.656	48876.1