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

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

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.

70 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
copyediting	20	5	224	(None)
coediting	13	3	833	2	co__editing
conceiting	15	3	1177	3	conce_iting
copycatting	21	5	198	3	copycatting
copyedit	16	4	435	3	copyedit___
copyedited	19	5	195	3	copyedit_ed
copyedits	17	4	293	3	copyedit__s
crediting	13	3	884	3	c__rediting
expediting	21	4	464	3	exp_editing
postediting	15	5	445	3	postediting
accrediting	17	5	246	4	accrediting
cocreating	15	3	1029	4	cocre_ating
coderiving	17	4	499	4	co_deriving
coempting	16	3	607	4	co__empting
coerecting	15	21	878	4	coere_cting
coexerting	20	4	549	4	coexe_rting
coexisting	20	4	440	4	co__existing
cohabiting	18	4	480	4	co_habiting
collecting	15	4	828	4	colle_cting
colleting	12	3	1105	4	colle__ting
commenting	17	4	917	4	comme_nting
competing	16	37	1246	4	compe__ting
complecting	20	4	576	4	comple_cting
completing	17	4	842	4	comple__ting
compositing	18	4	626	4	compositing
conceding	15	5	934	4	conced__ing
conceiving	18	4	677	4	conce_iving
concerting	15	3	1389	4	conce_rting
confecting	18	3	1055	4	confe_cting
congesting	14	4	1011	4	conge_sting
connecting	15	3	1038	4	conne_cting
consenting	13	3	1321	4	conse_nting
contenting	13	3	1332	4	conte_nting
contesting	13	3	1221	4	conte_sting
convecting	18	3	1043	4	conve_cting
conventing	16	3	1154	4	conve_nting
converting	16	3	1313	4	conve_rting
cooperating	16	4	842	4	cooperating
coparenting	16	4	461	4	coparenting
coplotting	15	5	595	4	cop_lotting
coppering	16	28	1089	4	coppe__ring
coppicing	18	4	540	4	cop__picing
copresenting	17	5	494	4	copresenting
coproducing	19	5	305	4	coproducing
copulating	15	4	937	4	cop_ulating
copying	15	34	1198	4	copy____ing
copyreading	20	5	275	4	copyreading
copyrighting	24	5	163	4	copyrighting
coquetting	22	4	451	4	coque_tting
corelating	13	5	1158	4	co_relating
correcting	15	19	930	4	corre_cting
correlating	14	8	708	4	correlating
corseting	12	3	1217	4	corse__ting
cosseting	12	3	954	4	cosse__ting
coveting	14	19	1230	4	co_ve__ting
cowriting	15	5	732	4	co__writing
depredating	16	5	569	4	depredating
editing	9	3	1313	4	____editing
foredating	15	7	712	4	fo_redating
forfeiting	17	4	413	4	forfe_iting
misediting	14	4	657	4	_misediting
nosediving	15	4	278	4	no_sediving
operating	12	3	1372	4	_op_erating
overediting	16	4	804	4	overediting
predating	13	5	1465	4	__predating
predicting	16	4	987	4	__predicting
preediting	14	4	793	4	_preediting
reediting	11	3	1095	4	__reediting
sopiting	11	3	1076	4	sop___iting
subediting	14	4	530	4	_subediting

Search took 9 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.423	422437.4
2	DLD Change Limit	148819	70	8.203	18142.0
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	8.656	20643.6