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

Here are the results of your fuzzy-string dictionary search for “coattesting” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

153 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
coattesting	14	4	345	(None)
attesting	10	3	638	2	__attesting
coattending	15	4	354	2	coattending
contesting	13	3	1221	2	co_ntesting
cathecting	18	4	483	3	c_athecting
chattering	16	10	864	3	chatte_ring
clattering	13	10	923	3	clatte_ring
coalescing	15	4	516	3	coa_lescing
coassisting	14	4	359	3	coassisting
coasting	11	36	1551	3	coa___sting
coattest	10	3	886	3	coattest___
coattested	13	4	297	3	coattest_ed
coattests	11	4	346	3	coattest__s
congesting	14	4	1011	3	co_ngesting
contenting	13	3	1332	3	co_ntenting
contrasting	14	5	935	3	contrasting
courtesying	17	4	312	3	courtesying
obtesting	12	4	588	3	_o_btesting
arresting	10	3	863	4	__arresting
attempting	15	4	292	4	__attempting
attending	11	13	637	4	__attending
attestant	9	4	597	4	__attestant
attriting	10	4	868	4	__attriting
battening	12	26	885	4	_batte_ning
battering	12	27	1514	4	_batte_ring
blattering	13	10	871	4	blatte_ring
boasting	11	35	1250	4	boa___sting
boatlifting	17	5	199	4	boatlifting
cacheting	17	3	715	4	c_ache_ting
cantering	12	24	1737	4	c_ante_ring
caressing	12	3	880	4	c_a_ressing
carpeting	14	3	948	4	c_arpe_ting
caseating	12	3	1174	4	c_a_seating
casketing	16	3	538	4	c_aske_ting
casting	10	46	2834	4	c_a___sting
castrating	13	4	977	4	c_astrating
catenating	13	4	868	4	c_atenating
catering	11	20	1990	4	c_a_te_ring
catting	10	39	2264	4	c_a_t__ting
caveating	15	3	929	4	c_a_veating
chaptering	18	10	796	4	chapte_ring
chartering	16	10	925	4	charte_ring
chastening	16	5	652	4	chaste_ning
chastising	16	5	488	4	chastis_ing
chatting	14	28	1014	4	cha_t__ting
chittering	16	10	718	4	chitte_ring
clandestine	14	5	301	4	clandestine
cluttering	13	10	683	4	clutte_ring
coacting	13	34	1270	4	coa___cting
coadmitting	17	5	261	4	coadmitting
coagulating	15	4	507	4	coagulating
coannexing	20	8	316	4	coanne_xing
coappearing	18	4	276	4	coappearing
coapting	13	35	1161	4	coa___pting
coarsening	13	4	554	4	coarse_ning
coastings	12	35	786	4	coa___stings
coating	10	35	2531	4	coa____ting
coattend	11	3	465	4	coatte___nd
coauthoring	17	4	258	4	coauthoring
cocreating	15	3	1029	4	co_creating
codirecting	17	4	364	4	codirecting
coerecting	15	21	878	4	co_erecting
coexerting	20	4	549	4	co_exerting
coexisting	20	4	440	4	co_existing
coextending	22	5	291	4	coextending
cogitating	14	4	721	4	cogit_ating
cohostessing	18	5	111	4	cohostessing
cohosting	15	4	632	4	co__hosting
coinfecting	19	4	457	4	coinfecting
cointerring	14	4	714	4	cointerring
coinventing	17	4	454	4	coinventing
collecting	15	4	828	4	co_llecting
colleting	12	3	1105	4	co_lle_ting
combusting	17	4	545	4	co_mbusting
commenting	17	4	917	4	co_mmenting
competing	16	37	1246	4	co_mpe_ting
complecting	20	4	576	4	complecting
completing	17	4	842	4	comple_ting
composting	17	17	805	4	co_mposting
compressing	18	4	643	4	compressing
conceiting	15	3	1177	4	co_nceiting
concerting	15	3	1389	4	co_ncerting
concreting	15	3	987	4	concre_ting
confecting	18	3	1055	4	co_nfecting
confessing	16	4	718	4	co_nfessing
congressing	15	4	560	4	congressing
connecting	15	3	1038	4	co_nnecting
consenting	13	3	1322	4	co_nsenting
consisting	13	4	952	4	co_nsisting
contacting	15	6	1007	4	co_ntacting
contemning	15	7	706	4	co_ntemning
contending	14	4	912	4	co_ntending
contestant	12	6	993	4	co_ntestant
contorting	13	4	1010	4	co_ntorting
contracting	16	6	1047	4	contracting
contusing	12	3	914	4	co_ntus_ing
convecting	18	3	1043	4	co_nvecting
conventing	16	3	1154	4	co_nventing
converting	16	3	1313	4	co_nverting
coparenting	16	4	461	4	coparenting
coquetting	22	4	451	4	co_quetting
corotating	13	4	932	4	corot_ating
correcting	15	19	930	4	co_rrecting
corseting	12	3	1217	4	co_rse_ting
cosseting	12	3	954	4	co_sse_ting
costing	10	43	2302	4	co____sting
cottoning	12	3	734	4	co_tt_oning
countering	13	3	1447	4	counte_ring
countersuing	15	4	708	4	countersuing
coveting	14	19	1230	4	co__ve_ting
cratering	12	3	1265	4	cra_te_ring
cresting	11	40	1704	4	c___resting
detesting	11	26	1032	4	__detesting
fattening	13	28	783	4	_fatte_ning
flattening	14	11	510	4	flatte_ning
flattering	14	9	874	4	flatte_ring
foresting	13	3	1136	4	fo__resting
foretasting	15	5	442	4	foretasting
fortressing	15	4	396	4	fortressing
goaltending	14	5	199	4	goaltending
harvesting	17	4	441	4	_harvesting
hostessing	14	4	457	4	ho_stessing
mattering	12	23	1405	4	_matte_ring
molesting	12	3	775	4	mo__lesting
nattering	10	22	1221	4	_natte_ring
outeating	10	8	1449	4	_o_uteating
outfasting	14	4	633	4	_outfasting
outfeasting	15	4	384	4	_outfeasting
outlasting	11	3	752	4	_outlasting
outtasking	15	4	572	4	_outtasking
outtelling	11	10	713	4	_outtelling
outwasting	14	4	643	4	_outwasting
patenting	12	4	894	4	_pa_tenting
pattering	12	23	1442	4	_patte_ring
patterning	13	4	607	4	_patterning
pottering	12	26	1200	4	po_tte_ring
pretesting	13	18	1068	4	_pretesting
protesting	13	19	1025	4	_protesting
rattening	10	28	876	4	_ratte_ning
rearresting	12	4	596	4	rearresting
reattempting	17	5	165	4	reattempting
retesting	10	26	1460	4	__retesting
roasting	9	30	1270	4	roa___sting
scattering	13	9	801	4	scatte_ring
shattering	14	9	828	4	shatte_ring
smattering	13	9	758	4	smatte_ring
spattering	13	10	779	4	spatte_ring
tattering	10	22	1232	4	_tatte_ring
testing	8	60	2105	4	____testing
toasting	9	34	1058	4	toa___sting
tottering	10	22	961	4	to_tte_ring
trapnesting	14	5	315	4	trapnesting
yattering	13	24	1044	4	_yatte_ring

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	148819	0.453	394461.4
2	DLD Change Limit	148819	153	8.796	16918.9
3	Display Results	153	153	0.093	1645.2
	(SQL Overall)	178691	153	9.342	19127.7