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

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

82 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
undefaced	16	4	475	(None)
defaced	14	29	1097	2	__defaced
undebated	13	3	809	2	undebated
undecayed	16	4	517	2	undecayed
undefeated	15	4	620	2	undefeated
undefiled	14	4	611	2	undefiled
undefined	14	4	587	2	undefined
underacted	14	4	925	2	underacted
underaged	12	10	1123	2	underaged
uneffaced	18	4	257	2	uneffaced
barefaced	17	4	369	3	barefaced
deface	12	31	1386	3	__deface_
defacer	13	28	1036	3	__defacer
defaces	13	32	1340	3	__defaces
defamed	14	30	983	3	__defamed
endeared	10	3	805	3	ende_ared
enfaced	13	21	891	3	en__faced
interfaced	16	4	793	3	interfaced
medevaced	18	4	233	3	medevaced
prefaced	16	3	842	3	_prefaced
refaced	13	37	1357	3	__refaced
unbeared	11	16	1165	3	unbe_ared
unbraced	13	23	1043	3	un_braced
undamaged	14	4	342	3	undamaged
undated	9	31	1846	3	und__ated
undead	8	27	1190	3	unde_a__d
undecided	14	4	598	3	undecided
undecked	16	23	849	3	unde_cked
undeclared	14	4	504	3	undeclared
undefended	16	4	400	3	undefended
undeformed	17	4	337	3	undeformed
undeleted	11	4	806	3	undeleted
undeluded	12	4	436	3	undeluded
undenied	10	22	1156	3	unde_nied
undented	10	23	1395	3	unde_nted
underact	11	3	1151	3	underac_t
underacts	12	4	858	3	underacts
underage	10	10	1227	3	underage_
underages	11	8	1108	3	underages
underate	9	9	1860	3	underate_
underbaked	18	4	617	3	underbaked
underbred	13	3	899	3	underbred
undercard	13	4	700	3	undercard
underfed	13	3	1171	3	unde_rfed
underfeed	14	4	863	3	underfeed
underived	14	3	1051	3	underived
underrated	12	3	1084	3	underrated
undertaxed	19	4	651	3	undertaxed
underused	11	3	933	3	underused
undesired	11	4	752	3	undesired
undetected	14	4	487	3	undetected
undraped	12	3	939	3	und_raped
undreamed	13	3	697	3	undreamed
undulated	11	3	1008	3	undulated
unerased	9	3	1277	3	un_erased
unevaded	13	3	642	3	un_evaded
unfaded	12	31	1173	3	un__faded
unfaked	15	32	1117	3	un__faked
unfazed	20	29	905	3	un__fazed
unfeared	12	15	1101	3	unfe_ared
unfenced	14	3	773	3	unfe_nced
ungraced	12	23	914	3	un_graced
unhealed	12	15	1107	3	unhe_aled
unheated	12	15	1455	3	unhe_ated
unideaed	10	4	573	3	unide_a_ed
uniface	12	3	695	3	un_iface_
unifaces	13	4	639	3	un_ifaces
unlaced	10	29	1373	3	un__laced
unleaded	10	4	1133	3	unle_aded
unleased	9	3	1071	3	unle_ased
unplaced	13	3	861	3	un_placed
unreached	15	3	688	3	unre_ached
unrefined	13	4	546	3	unrefined
unrelated	10	3	1043	3	unrelated
unrelaxed	17	4	446	3	unrelaxed
unsealed	9	15	1362	3	unse_aled
unseamed	11	12	1066	3	unse_amed
unseared	9	11	1394	3	unse_ared
unseated	9	13	1768	3	unse_ated
untraced	11	24	1324	3	un_traced
unweaned	12	3	859	3	unwe_aned
unyeaned	12	3	774	3	unye_aned

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.420	425454.8
2	DLD Change Limit	148641	82	7.063	21045.0
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.513	23784.2