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

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

65 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
canvasses	14	28	603	(None)
canvases	13	34	951	1	canva_ses
canvassed	15	27	403	1	canvassed
canvasser	14	27	425	1	canvasser
canvassers	15	27	357	1	canvassers
camasses	12	38	897	2	ca_masses
canvased	14	24	621	2	canva_sed
canvaser	13	27	655	2	canva_ser
canvasers	14	26	535	2	canvasers
canvass	12	37	687	2	canva_s_s
carcasses	13	3	747	2	carcasses
crevasses	14	4	413	2	crevasses
kavasses	15	4	430	2	ka_vasses
admasses	11	3	541	3	_admasses
amasses	9	39	1285	3	_a_masses
anlases	7	25	1490	3	_anla_ses
avgasses	12	8	419	3	_avgasses
badasses	11	3	617	3	ba_dasses
bagasses	11	3	631	3	ba_gasses
calashes	13	3	1053	3	ca_lashes
calvadoses	16	4	248	3	calvadoses
calvaries	14	4	980	3	calvaries
camases	11	42	1634	3	ca_ma_ses
canalises	11	5	1549	3	canalises
canapes	11	12	1308	3	can_a_pes
canaries	10	3	1894	3	can_aries
canastas	10	3	769	3	can_astas
cannabises	14	4	443	3	cannabises
canonesses	12	3	841	3	canonesses
canonises	11	4	1080	3	canonises
canvas	11	38	1333	3	canva___s
canvasing	15	4	643	3	canvasing
canvassing	16	4	380	3	canvassing
capiases	12	3	925	3	capia_ses
carcases	12	3	1308	3	carca_ses
caresses	10	3	1406	3	ca_resses
carwashes	17	4	577	3	carwashes
caseases	10	4	1047	3	casea_ses
catharses	14	4	641	3	catharses
caucusses	13	4	304	3	caucusses
chasses	12	40	1750	3	c__hasses
cineastes	11	6	556	3	cineastes
classes	9	47	1794	3	c__lasses
compasses	15	4	739	3	compasses
concusses	13	4	634	3	concusses
confesses	14	3	862	3	confesses
converses	14	3	1116	3	converses
convulses	14	4	550	3	convulses
crevasse	13	4	308	3	crevasse_
crevassed	15	4	319	3	crevassed
cuirasses	11	4	437	3	cuirasses
cutlasses	11	4	510	3	cutlasses
fantasies	12	9	885	3	fantasies
fantasises	13	9	588	3	fantasises
harasses	11	3	1103	3	ha_rasses
hardasses	13	4	645	3	hardasses
jackasses	22	4	371	3	jackasses
kvasses	14	36	550	3	__kvasses
landmasses	13	4	321	3	landmasses
lavashes	14	4	557	3	la_vashes
matrasses	11	5	729	3	matrasses
pavisses	13	39	710	3	pa_visses
syngasses	13	4	381	3	syngasses
vinasses	11	3	570	3	vin_asses
wannesses	12	3	923	3	wannesses

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.156	1145455.1
2	DLD Change Limit	148641	65	7.063	21045.0
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	7.249	24650.4