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

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

74 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
catjangs	18	4	322	(None)
catjang	17	3	392	1	catjang_
catlings	11	37	1204	2	catlings
satangs	8	47	971	2	sat_angs
actings	10	45	1246	3	act_ings
atmans	8	44	1396	3	_atman_s
battings	11	40	1057	3	battings
cabanas	11	24	1303	3	ca_banas
caftans	12	17	944	3	caftan_s
caimans	11	38	1178	3	caiman_s
cajones	16	33	1133	3	ca_jones
calkings	15	28	922	3	calkings
callans	9	45	1847	3	callan_s
callants	10	41	1214	3	callants
callings	11	36	1383	3	callings
campings	15	40	1020	3	campings
campongs	15	35	612	3	campongs
cancans	11	3	1187	3	cancan_s
cannings	11	37	1033	3	cannings
cappings	15	36	949	3	cappings
captans	11	16	1205	3	captan_s
cardings	12	38	1263	3	cardings
carjacks	23	4	557	3	carjacks
carlings	11	40	1585	3	carlings
carpings	13	38	1238	3	carpings
carvings	14	38	1020	3	carvings
casings	10	40	1351	3	ca_sings
castings	11	36	1405	3	castings
catalogs	11	4	803	3	catalogs
catalos	9	4	1416	3	cat_alos
catcalls	12	3	832	3	catcalls
catenas	9	3	1311	3	cat_enas
caterans	10	3	1322	3	cateran_s
catfaces	15	3	696	3	catfaces
catfacings	18	4	218	3	catfacings
catfalls	13	4	706	3	catfalls
cations	9	45	2414	3	cation_s
catkins	13	30	1256	3	catkin_s
catling	10	48	1979	3	catling_
catlins	9	38	1884	3	catlin_s
catmints	12	3	666	3	catmints
catnaps	11	9	703	3	catna_ps
cattails	10	3	855	3	cattails
cattalos	10	3	793	3	cattalos
catting	10	39	2264	3	catting_
catwalks	17	4	479	3	catwalks
cavings	13	47	1254	3	ca_vings
caymans	14	34	951	3	cayman_s
cetanes	9	3	1513	3	cet_anes
changs	12	52	1537	3	c__hangs
clangs	9	51	1361	3	c__langs
coatings	11	38	1184	3	coat_ings
cotans	8	13	1792	3	cot_an_s
cutbanks	16	4	431	3	cutbanks
cuttings	11	27	761	3	cuttings
eatings	8	46	1644	3	eat_ings
fatlings	12	35	930	3	fatlings
gatings	9	52	1282	3	gat_ings
hatbands	14	4	629	3	hatbands
lathings	12	46	985	3	lathings
mahjongs	21	4	181	3	mahjongs
mahuangs	14	5	288	3	mahuangs
matings	10	45	1621	3	mat_ings
mattings	11	36	967	3	mattings
parangs	10	43	1437	3	pa_rangs
ratans	6	38	1937	3	rat_an_s
ratbags	10	3	576	3	ratba_gs
ratings	8	42	1741	3	rat_ings
rattans	7	34	1195	3	rattan_s
satang	7	57	1156	3	sat_ang_
stangs	7	50	1816	3	_st_angs
tangs	6	50	2834	3	__t_angs
tattings	9	40	882	3	tattings
twangs	10	35	809	3	__twangs

Search took 10 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	146162	0.173	1032896.0
2	DLD Change Limit	146162	74	8.703	16794.4
3	Display Results	74	74	0.186	397.8
	(SQL Overall)	178691	74	9.062	19718.7