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

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

48 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
chancy	16	40	1086	(None)
chance	13	46	1709	1	chance
chanty	14	52	1582	1	chanty
candy	11	51	1982	2	c_andy
canny	10	58	1769	2	c_anny
canty	10	52	2680	2	c_anty
chaffy	20	45	647	2	chaffy
chalky	18	46	877	2	chalky
chally	14	43	1429	2	chally
chammy	18	48	895	2	chammy
champy	18	50	961	2	champy
chanced	15	41	1321	2	chanced
chancel	14	40	1177	2	chancel
chancer	14	42	1563	2	chancer
chancery	18	36	665	2	chancery
chances	14	52	1809	2	chances
chancily	18	4	524	2	chancily
chancre	14	34	878	2	chancre
chang	11	54	1856	2	chan_g
change	12	41	1675	2	change
changs	12	52	1537	2	changs
chanoyu	15	4	448	2	chanoyu
chant	10	59	3269	2	chan_t
chantey	15	41	1254	2	chantey
chantry	15	38	821	2	chantry
chants	11	50	2039	2	chants
charry	14	50	1211	2	charry
chary	13	50	2313	2	cha_ry
chasmy	16	46	854	2	chasmy
chatty	14	41	936	2	chatty
chay	12	49	2487	2	cha__y
chinch	16	39	1122	2	chinch
chinchy	20	33	551	2	chinchy
chinky	18	56	1054	2	chinky
chunky	18	46	827	2	chunky
clanky	15	46	907	2	clanky
cranch	13	36	1353	2	cranch
cranky	15	39	1063	2	cranky
cranny	11	42	1027	2	cranny
fancy	13	46	1548	2	_fancy
hance	10	54	2415	2	_hance
handy	12	55	2087	2	_handy
hanky	15	54	1829	2	_hanky
nancy	10	52	1492	2	_nancy
shandy	13	47	1003	2	shandy
shanny	12	41	1009	2	shanny
shanty	12	47	1511	2	shanty
unchancy	18	4	470	2	unchancy

Search took 3 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.126	1418182.5
2	DLD Change Limit	82551	48	2.686	30733.8
3	Display Results	48	48	0.016	3000.0
	(SQL Overall)	178691	48	2.828	63186.4