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

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

45 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
doughfaces	20	5	183	(None)
doughface	19	5	170	1	doughface_
dogfaces	15	5	414	2	do_g_faces
dogface	14	5	405	3	do_g_face_
outfaces	13	23	1139	3	_ou_tfaces
roughages	14	4	438	3	rough_ages
roughbacks	22	5	256	3	roughbacks
boldfaces	17	9	322	4	bo_ldfaces
bonifaces	16	4	373	4	bo_nifaces
clubfaces	18	4	191	4	clu_bfaces
defaces	13	32	1340	4	d___efaces
disgraces	13	4	845	4	disg_races
dogbanes	12	4	543	4	do_g_banes
doghouses	14	4	535	4	do_ghouses
dogvanes	13	4	430	4	do_g_vanes
douches	13	43	1523	4	douch___es
doughboys	19	5	166	4	dough_boys
doughier	13	3	548	4	dough__ier
doughiest	14	3	578	4	dough__iest
doughlike	18	4	268	4	doughlike_
doughnuts	14	4	218	4	dough_nuts
doughs	11	59	1293	4	dough____s
doughtier	14	4	346	4	dough_tier
doughtiest	15	4	323	4	dough_tiest
doughtiness	16	4	270	4	doughtiness
forefaces	17	4	713	4	fo_refaces
fullfaces	17	4	263	4	_fullfaces
lightfaces	19	7	309	4	_lightfaces
outface	12	30	1197	4	_ou_tface_
outfaced	14	21	946	4	_ou_tfaced
outpaces	12	24	1194	4	_ou_tpaces
outplaces	13	4	774	4	_outplaces
outraces	10	22	1786	4	_ou_traces
postfaces	16	5	627	4	po_stfaces
roughage	13	4	442	4	rough_age_
roughback	21	5	282	4	roughbac_k
roughcasts	16	5	216	4	roughcasts
roughdries	15	5	268	4	roughdries
roughies	12	9	832	4	rough__ies
roughnecks	20	9	190	4	roughnecks
surfaces	13	3	867	4	_su_rfaces
touchbacks	23	13	291	4	touchbacks
toughies	12	7	824	4	tough__ies
unifaces	13	4	639	4	__unifaces
vouchsafes	21	5	137	4	vouchsafes

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	161450	0.440	406115.9
2	DLD Change Limit	161450	45	9.406	17164.6
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	9.876	18093.5