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

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

61 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
castanets	11	4	633	(None)
castanet	10	4	1619	1	castanet_
carcanets	13	4	731	2	carcanets
alkanets	12	36	623	3	_alkanets
basinets	10	3	906	3	bas_inets
bassinets	11	4	632	3	bassinets
cabarets	12	26	846	3	ca_barets
cabernets	13	4	506	3	cabernets
cabinets	12	3	828	3	ca_binets
cabstands	14	5	373	3	cabstan_ds
caftaned	14	4	509	3	caftane_d
caftans	12	17	944	3	caftan__s
calcaneus	13	4	416	3	calcaneus
callants	10	41	1214	3	callan_ts
canzonets	20	4	448	3	canzonets
capstans	12	5	724	3	capstan__s
capstones	13	4	737	3	capstone_s
captans	11	16	1205	3	captan__s
carcanet	12	3	1635	3	carcanet_
carnets	9	39	1840	3	ca__rnets
cartages	11	3	1331	3	cartage_s
cascabels	15	16	323	3	cascabels
cascades	13	12	855	3	cascade_s
caseases	10	4	1047	3	casease_s
caseates	10	3	1371	3	caseate_s
casements	13	4	858	3	casements
casernes	10	38	1075	3	caserne_s
caskets	13	39	1017	3	cas__kets
cassenes	10	36	1129	3	cassene_s
cassines	10	31	1661	3	cassine_s
castaways	17	4	367	3	castaways
casters	9	47	2990	3	cast__ers
castes	8	56	3186	3	cast__e_s
castings	11	36	1405	3	castin_gs
castles	9	49	1773	3	cast_le_s
castraters	12	4	647	3	castraters
castrates	11	3	1267	3	castrate_s
casualness	12	4	322	3	casualness
cattiness	11	23	1063	3	cattiness
cetanes	9	3	1513	3	c_etane_s
chasteners	15	5	479	3	chasteners
chasteness	15	4	652	3	chasteness
constants	11	4	1091	3	constan_ts
cystines	13	3	947	3	cystine_s
fasteners	12	23	705	3	fasteners
fastness	11	23	876	3	fast_ness
gastness	9	27	847	3	gast_ness
hasteners	12	26	781	3	hasteners
hastiness	12	24	1088	3	hastiness
instants	8	9	1015	3	instan_ts
martinets	11	3	888	3	martinets
nastiness	9	23	1057	3	nastiness
pantalets	11	4	767	3	pantalets
pastiness	11	23	1235	3	pastiness
pastness	10	25	1050	3	past_ness
satinets	8	3	1173	3	sa_tinets
stanes	6	49	3340	3	__stane_s
starets	7	35	1592	3	__starets
tastiness	9	23	1114	3	tastiness
vastness	11	25	729	3	vast_ness
wastages	12	10	975	3	wastage_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.420	425454.8
2	DLD Change Limit	148641	61	7.300	20361.8
3	Display Results	61	61	0.013	4692.3
	(SQL Overall)	178691	61	7.733	23107.6