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

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

66 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
canvas	11	38	1333	(None)
cannas	8	45	1840	1	cannas
canvass	12	37	687	1	canvass
anas	4	66	4986	2	_an_as
angas	6	58	2798	2	_angas
anlas	5	56	2693	2	_anlas
annas	5	58	2488	2	_annas
anoas	5	72	2649	2	_anoas
antas	5	54	3203	2	_antas
bandas	9	51	2054	2	bandas
cacas	9	56	2798	2	ca_cas
callas	8	45	2675	2	callas
calves	11	51	1928	2	calves
camas	9	63	3352	2	ca_mas
canal	7	54	2804	2	can_al
canals	8	44	2166	2	canals
cancan	10	3	1410	2	cancan
cancans	11	3	1187	2	cancans
canchas	14	32	1240	2	canchas
caners	8	46	2919	2	caners
canes	7	53	5037	2	can_es
canids	9	51	1813	2	canids
canna	7	59	1933	2	canna_
canoes	8	47	2588	2	canoes
canolas	9	3	1399	2	canolas
canons	8	55	2206	2	canons
cans	6	50	5084	2	can__s
cansos	8	49	1538	2	cansos
cantal	8	41	2203	2	cantal
cantals	9	39	1957	2	cantals
cantos	8	48	2697	2	cantos
cants	7	70	3694	2	can_ts
cantus	8	51	1776	2	cantus
canulas	9	3	1285	2	canulas
canvased	14	24	621	2	canvased
canvaser	13	27	655	2	canvaser
canvases	13	34	951	2	canvases
capias	10	3	1835	2	capias
carves	11	51	2845	2	carves
casas	7	53	2784	2	ca_sas
casavas	12	3	781	2	casavas
caves	10	56	3970	2	ca_ves
centas	8	50	2070	2	centas
congas	9	44	1703	2	congas
fangas	10	50	1719	2	fangas
favas	11	56	1859	2	fa_vas
ganjas	14	14	911	2	ganjas
halvas	12	47	1417	2	halvas
hansas	9	46	1604	2	hansas
javas	15	59	1542	2	ja_vas
kanas	9	53	2691	2	kan_as
kavas	12	59	1995	2	ka_vas
larvas	9	3	1023	2	larvas
lavas	8	54	2222	2	la_vas
manas	7	62	4042	2	man_as
mangas	9	41	2292	2	mangas
manias	8	40	2903	2	manias
mannas	8	50	1980	2	mannas
mantas	8	57	2536	2	mantas
nanas	5	59	2863	2	nan_as
pandas	9	55	2196	2	pandas
pangas	9	99	2110	2	pangas
sangas	7	52	2265	2	sangas
tankas	10	46	1376	2	tankas
vandas	10	39	1599	2	vandas
zanzas	14	8	705	2	zanzas

Search took 5 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	82551	0.123	1452772.4
2	DLD Change Limit	82551	66	4.360	18933.7
3	Display Results	66	66	0.046	1434.8
	(SQL Overall)	178691	66	4.529	39454.8