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

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

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.

40 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
cannelons	11	4	521	(None)
cannelon	10	4	512	1	cannelon_
cannelloni	12	5	249	2	cannelloni
cannels	9	34	1336	2	cannel__s
cannons	9	44	1288	2	cann__ons
annelids	9	4	623	3	_annelids
bannerols	11	4	409	3	bannerols
cabezons	21	4	455	3	ca_bezons
cancelers	13	24	786	3	cancelers
canceling	14	3	1016	3	canceling
cancellous	14	4	364	3	cancellous
cancels	11	41	1331	3	cancel__s
cancerous	13	6	753	3	cancerous
candelas	11	3	953	3	candel_as
canellas	10	3	1056	3	ca_nellas
cankerous	15	6	605	3	cankerous
cannabins	13	6	578	3	cannabins
cannel	8	42	1640	3	cannel___
canneries	11	3	1308	3	canneries
canners	9	38	2266	3	canne__rs
cannikins	15	22	568	3	cannikins
cannolis	10	3	786	3	cannol_is
cannon	8	45	1444	3	cann__on_
cannulas	10	3	758	3	cannul_as
canons	8	55	2206	3	ca_n__ons
canteens	10	3	857	3	cante_ens
cantons	9	52	2120	3	ca_n_tons
canyons	12	45	1159	3	ca_n_yons
capelans	12	3	801	3	ca_pelans
capelins	12	3	1113	3	ca_pelins
carillons	11	4	636	3	carillons
carnelians	12	4	423	3	carnelians
channelers	15	4	385	3	channelers
channeling	16	4	520	3	channeling
channels	13	38	849	3	channel__s
cinnamons	13	4	303	3	cinnamons
connexions	19	7	462	3	connexions
dandelions	12	4	361	3	dandelions
magnetons	12	4	454	3	magnetons
tangelos	9	3	574	3	tangelo_s

Search took 8 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	148641	0.440	406115.9
2	DLD Change Limit	148641	40	7.356	20206.8
3	Display Results	40	40	0.016	2500.0
	(SQL Overall)	178691	40	7.812	22873.9