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

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

98 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
contacted	14	13	909	(None)
contactee	13	14	931	1	contactee
contracted	15	4	982	1	contracted
coacted	12	36	1161	2	co__acted
coenacted	14	4	580	2	coenacted
compacted	18	29	736	2	compacted
concocted	13	4	676	2	concocted
conducted	15	4	731	2	conducted
confected	17	3	907	2	confected
connected	14	3	875	2	connected
contact	11	440	2068	2	contact__
contactees	14	13	599	2	contactees
contactor	13	4	843	2	contactor
contacts	12	32	1521	2	contact_s
contained	12	3	1089	2	contained
contented	12	3	1304	2	contented
contested	12	3	1069	2	contested
contorted	12	3	947	2	contorted
contrasted	13	4	857	2	contrasted
convected	17	3	878	2	convected
convicted	17	4	631	2	convicted
outacted	11	3	938	2	_outacted
recontacted	16	5	471	2	recontacted
coached	15	33	1384	3	co__ached
coadapted	15	4	316	3	coadapted
coapted	12	39	1150	3	co__apted
coasted	10	40	1595	3	co__asted
coated	9	49	2704	3	co__a_ted
coerected	14	4	764	3	coerected
cogitated	13	4	632	3	cogita_ted
coinfected	18	4	382	3	coinfected
collated	11	36	1506	3	colla_ted
collected	14	4	797	3	collected
colocated	14	3	961	3	colocated
combated	15	3	982	3	comba_ted
combatted	16	4	465	3	combatted
compacter	17	25	788	3	compacter
comparted	16	33	842	3	comparted
concaved	16	3	622	3	conca_ved
conceited	14	3	1042	3	conceited
concerted	14	3	1211	3	concerted
concocter	12	4	762	3	concocter
concreted	14	3	941	3	concreted
conduced	14	13	696	3	conduc_ed
confabbed	19	4	246	3	confabbed
conflated	15	3	933	3	conflated
conflicted	18	4	405	3	conflicted
confuted	14	3	768	3	con_futed
congaed	11	39	974	3	conga__ed
congested	13	3	867	3	congested
connate	9	3	1575	3	conna_te_
connecter	13	4	905	3	connecter
connoted	11	3	886	3	con_noted
consented	12	3	1194	3	consented
consisted	12	3	850	3	consisted
consorted	12	3	977	3	consorted
constricted	16	4	636	3	constricted
constructed	16	4	625	3	constructed
consulted	12	7	792	3	consulted
contacting	15	6	1007	3	contacting
contactors	14	4	884	3	contactors
container	11	3	1107	3	container
contemned	14	4	679	3	contemned
contended	13	3	927	3	contended
contester	11	3	1118	3	contester
continued	12	4	848	3	continued
contoured	12	3	730	3	contoured
contract	12	29	1563	3	contract__
contractor	14	4	907	3	contractor
contracts	13	22	1201	3	contract_s
contradicted	18	5	355	3	contradicted
contrite	10	3	1854	3	contrite_
contrived	15	4	799	3	contrived
contused	11	3	844	3	cont_used
convented	15	4	1075	3	convented
converted	15	3	1156	3	converted
corotated	12	28	1005	3	corota_ted
corrected	14	3	811	3	corrected
costarred	12	4	470	3	costarred
costate	9	40	1927	3	costa_te_
counteracted	17	4	736	3	counteracted
cuneated	11	3	1010	3	cunea_ted
dentated	10	4	1170	3	denta_ted
donated	9	35	1386	3	don_a_ted
enacted	10	3	1064	3	_en_acted
montaged	12	10	776	3	monta_ged
nonrated	9	3	1084	3	nonra_ted
nonsacred	12	4	467	3	nonsacred
notated	8	27	1366	3	no_ta_ted
obtected	13	4	455	3	_obtected
rotated	8	27	1529	3	ro_ta_ted
sonicated	12	4	845	3	sonicated
tentacled	12	4	495	3	tentacled
unacted	10	3	1273	3	_un_acted
uncontracted	17	15	414	3	uncontracted
untacked	15	23	992	3	_untacked
untasted	9	20	1157	3	_untasted
zonated	17	33	1053	3	zon_a_ted

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.423	422437.4
2	DLD Change Limit	148641	98	7.250	20502.2
3	Display Results	98	98	0.046	2130.4
	(SQL Overall)	178691	98	7.719	23149.5