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

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

80 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
cannels	9	34	1336	(None)
cancels	11	41	1331	1	cancels
cannel	8	42	1640	1	cannel_
canners	9	38	2266	1	canners
channels	13	38	849	1	channels
angels	7	44	1617	2	_angels
annals	6	64	1592	2	_annals
anneals	7	44	994	2	_anneals
annuls	6	47	1173	2	_annuls
banners	9	40	1871	2	banners
bannets	9	40	1384	2	bannets
camels	10	52	1708	2	ca_mels
canals	8	44	2166	2	ca_nals
cancel	10	53	1668	2	cancel_
cancers	11	40	1858	2	cancers
candela	10	8	974	2	candela
candelas	11	3	953	2	candelas
candles	10	44	2234	2	candles
caners	8	46	2920	2	ca_ners
canes	7	53	5037	2	ca_ne_s
canfuls	12	4	842	2	canfuls
canines	9	37	2403	2	canine_s
cankers	13	44	1875	2	cankers
cannas	8	45	1840	2	cann_as
canned	9	50	2206	2	canne_d
cannelon	10	4	512	2	cannelon
cannelons	11	4	521	2	cannelons
canner	8	46	2598	2	canne_r
cannery	12	36	1001	2	cannery
cannily	12	3	926	2	cannily
cannoli	9	3	726	2	cannoli
cannolis	10	3	786	2	cannolis
cannons	9	44	1288	2	cannons
cannula	9	3	743	2	cannula
cannulas	10	3	758	2	cannulas
canoers	9	43	1837	2	canoers
canoes	8	47	2588	2	canoe_s
canoness	10	3	939	2	canoness
cantals	9	39	1957	2	cantals
canters	9	48	2773	2	canters
cantles	9	47	2141	2	cantles
carcels	11	45	1606	2	carcels
carnets	9	39	1840	2	carnets
carneys	12	43	1054	2	carneys
carpels	11	53	1546	2	carpels
carrels	9	51	1730	2	carrels
cartels	9	46	1812	2	cartels
carvels	12	49	1459	2	carvels
chancels	15	43	908	2	chancels
channel	12	39	1048	2	channel_
charnels	13	32	817	2	charnels
chunnels	13	30	455	2	chunnels
conners	9	40	2311	2	conners
cornels	9	47	1666	2	cornels
crenels	9	37	1101	2	crenels
cunners	9	39	1347	2	cunners
darnels	8	37	1043	2	darnels
fanners	10	39	1465	2	fanners
fennels	10	38	790	2	fennels
flannels	11	3	484	2	flannels
funnels	10	34	817	2	funnels
gannets	8	38	1144	2	gannets
gunnels	8	35	856	2	gunnels
hansels	10	40	1165	2	hansels
kennels	11	38	719	2	kennels
lanners	7	36	1833	2	lanners
mangels	10	36	1449	2	mangels
manners	9	34	1783	2	manners
mantels	9	45	1504	2	mantels
panels	8	47	1652	2	pa_nels
panners	9	36	2127	2	panners
pannes	8	55	2285	2	panne_s
ronnels	7	31	861	2	ronnels
runnels	7	32	915	2	runnels
scanners	10	37	970	2	scanners
scrannels	11	4	351	2	scrannels
tanners	7	40	1839	2	tanners
tunnels	7	32	872	2	tunnels
vanners	10	36	1284	2	vanners
wanness	10	26	1068	2	wanness

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.140	1276364.3
2	DLD Change Limit	107671	80	2.983	36094.9
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	3.156	56619.5