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

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

79 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
charry	14	50	1211	(None)
carry	10	58	2378	1	c_arry
charr	10	48	2178	1	charr_
charro	11	42	1296	1	charro
charrs	11	52	1919	1	charrs
chary	13	50	2313	1	cha_ry
cherry	14	48	1076	1	cherry
gharry	13	54	627	1	gharry
harry	11	53	2295	1	_harry
carny	10	58	2292	2	c_arny
carr	6	54	3470	2	c_arr_
carrs	7	57	3085	2	c_arrs
chadri	12	3	814	2	chadri
chaffy	20	45	647	2	chaffy
chair	10	55	1963	2	chair_
chairs	11	49	1618	2	chairs
chakra	15	43	753	2	chakra
chalky	18	46	877	2	chalky
chally	14	43	1429	2	chally
chammy	18	48	895	2	chammy
champy	18	50	961	2	champy
chancy	16	40	1086	2	chancy
chantry	15	38	822	2	chantry
chanty	14	52	1582	2	chanty
char	9	51	3215	2	cha_r_
charas	11	42	2361	2	charas
chard	11	61	2474	2	cha_rd
chards	12	51	1973	2	chards
chare	10	52	3198	2	cha_re
chared	12	54	2369	2	chared
chares	11	56	3180	2	chares
charge	12	51	1421	2	charge
charily	15	3	1028	2	charily
charity	15	3	1102	2	charity
chark	14	42	2271	2	cha_rk
charka	15	40	1170	2	charka
charks	15	52	1970	2	charks
charley	15	11	827	2	charley
charm	12	61	2466	2	cha_rm
charms	13	52	1884	2	charms
charpoy	17	3	571	2	charpoy
charred	13	46	1449	2	charred
charros	12	43	1215	2	charros
chars	10	59	3664	2	cha_rs
chart	10	50	3828	2	cha_rt
charts	11	58	2309	2	charts
chasmy	16	46	854	2	chasmy
chatty	14	41	936	2	chatty
chay	12	49	2487	2	cha__y
cheery	14	49	1315	2	cheery
cherty	14	46	1247	2	cherty
chirpy	16	49	891	2	chirpy
chirr	10	50	1590	2	chirr_
chirre	11	41	1185	2	chirre
chirrs	11	45	1498	2	chirrs
churr	10	45	1285	2	churr_
churro	11	44	835	2	churro
churrs	11	51	1151	2	churrs
clary	10	57	1961	2	cla_ry
curry	10	59	2034	2	c_urry
gharri	10	38	616	2	gharri
hairy	11	53	1683	2	_hairy
hardy	12	56	2206	2	_hardy
harpy	13	64	1821	2	_harpy
herry	11	49	2247	2	_herry
hurry	11	49	1718	2	_hurry
knarry	13	3	461	2	knarry
marry	10	48	2169	2	_marry
parry	10	53	2375	2	_parry
quarry	18	3	747	2	quarry
scarry	11	63	1118	2	scarry
sharny	12	47	1183	2	sharny
sharpy	14	52	1103	2	sharpy
sherry	12	45	1041	2	sherry
sparry	11	51	1130	2	sparry
starry	9	49	1167	2	starry
tarry	8	54	2251	2	_tarry
wherry	15	47	734	2	wherry
whirry	15	47	706	2	whirry

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	82551	0.390	458182.1
2	DLD Change Limit	82551	79	2.673	30883.3
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	3.096	57716.7