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

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

72 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
catenating	13	4	868	(None)
caseating	12	3	1174	2	case_ating
catenation	12	4	952	2	catenation
catenations	13	4	836	2	catenations
caveating	15	3	929	2	cave_ating
patenting	12	4	894	2	paten_ting
patinating	13	3	987	2	patinating
accenting	14	8	782	3	accen_ting
acierating	13	4	831	3	acierating
activating	16	4	785	3	activating
actuating	12	3	922	3	act_uating
aerating	9	28	2100	3	_a_erating
agenting	10	3	938	3	_agen_ting
alienating	11	4	722	3	alienating
alternating	12	4	571	3	alternating
antedating	12	7	755	3	antedating
attenuating	12	5	310	3	attenuating
cadencing	15	4	496	3	caden_cing
calendaring	15	5	300	3	calendaring
canaling	11	20	1641	3	ca__naling
canting	10	47	2590	3	ca__n_ting
canulating	13	4	954	3	canulating
captivating	19	4	488	3	captivating
carbonating	16	4	586	3	carbonating
caretaking	17	6	533	3	caretaking
castigating	15	4	600	3	castigating
castrating	13	4	977	3	castrating
catenaries	12	4	866	3	catenaries
catenate	10	3	1283	3	catenat__e
catenated	12	3	891	3	catenat_ed
catenates	11	3	1181	3	catenat_es
catering	11	20	1990	3	cate__ring
catfacing	17	4	455	3	cat_facing
cathecting	18	4	483	3	cathecting
catnapping	17	4	253	3	cat_napping
catting	10	39	2264	3	cat___ting
cavitating	16	4	690	3	cavitating
cementing	14	3	876	3	cemen_ting
cheating	14	40	1452	3	c_he_ating
chelating	15	4	935	3	c_helating
cleating	11	35	1813	3	c_le_ating
coenacting	15	4	587	3	c_oenacting
concatenating	18	5	326	3	~~con~~catenating
contenting	13	3	1332	3	conten_ting
corelating	13	5	1158	3	corelating
coronating	13	4	1017	3	coronating
covenanting	17	4	301	3	covenanting
creating	11	39	2195	3	c_re_ating
cremating	14	3	1219	3	c_remating
cybernating	19	5	285	3	cybernating
detonating	12	4	882	3	detonating
extenuating	19	4	357	3	extenuating
intonating	11	4	863	3	intonating
iterating	10	3	1425	3	_iterating
lacerating	13	4	944	3	lacerating
lamenting	12	3	769	3	lamen_ting
laminating	13	4	872	3	laminating
latening	9	7	1149	3	laten__ing
lateraling	11	14	880	3	lateraling
macerating	15	4	953	3	macerating
marinating	13	4	1026	3	marinating
maturating	13	10	857	3	maturating
outeating	10	8	1449	3	oute_ating
paginating	14	4	752	3	paginating
parenting	12	6	1158	3	paren_ting
patriating	13	5	1020	3	patriating
satiating	10	3	1180	3	sat_iating
saturating	11	11	920	3	saturating
stagnating	12	5	497	3	stagnating
tenanting	10	3	621	3	__tenanting
tenting	8	46	2115	3	__ten_ting
venenating	14	4	601	3	venenating

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	140603	0.423	422437.4
2	DLD Change Limit	140603	72	6.890	20406.8
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.343	24334.9