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

Here are the results of your fuzzy-string dictionary search for “undefoliated” 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
undefoliated	17	5	245	(None)
defoliated	15	4	583	2	__defoliated
defoliate	13	4	699	3	__defoliate_
defoliates	14	4	633	3	__defoliates
unaffiliated	19	5	242	3	unaffiliated
undecorated	15	4	572	3	undeco_rated
undefeated	15	4	620	3	undef__eated
unifoliate	13	5	303	3	un_ifoliate_
decollated	14	13	628	4	__decollated
defalcated	17	4	418	4	__defalcated
deflated	13	34	1230	4	__def_l_ated
defoliator	14	4	418	4	__defoliator
desolated	11	3	965	4	__desol_ated
exfoliated	21	6	339	4	__exfoliated
foliated	12	4	991	4	____foliated
negotiated	12	4	445	4	_n_egotiated
unassociated	15	5	276	4	unassociated
unciliated	13	4	805	4	un__ciliated
undebated	13	3	809	4	unde___bated
undeclared	14	4	504	4	unde_cl_ared
undedicated	16	5	481	4	unde_dicated
undefaced	16	4	475	4	undef___aced
undefiled	14	4	611	4	undef__i_led
undefined	14	4	587	4	undef__i_ned
undeformed	17	4	337	4	undefo__rmed
undelegated	14	4	407	4	unde_legated
undeleted	11	4	806	4	unde__l_eted
undercoated	15	4	682	4	unde_rcoated
underheated	16	4	701	4	unde_rheated
underlined	12	16	1021	4	unde_rli_ned
underloaded	14	4	450	4	unde_rloaded
underplayed	18	7	502	4	underpl_ayed
underrated	12	3	1084	4	unde__rrated
undershirted	17	5	347	4	undershirted
understated	13	4	783	4	unde_rstated
undesignated	15	5	283	4	undesignated
undissociated	17	6	193	4	undissociated
undulated	11	3	1008	4	und__ul_ated
unduplicated	18	5	368	4	und_uplicated
unevaluated	15	5	307	4	un_evaluated
uninflated	14	7	476	4	uninf_l_ated
unmediated	14	4	516	4	unme__diated
unregulated	13	4	440	4	unregul_ated
unrelated	10	3	1043	4	unre__l_ated
unventilated	16	5	351	4	unventilated

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	124790	0.373	479064.3
2	DLD Change Limit	124790	45	6.673	18700.7
3	Display Results	45	45	0.013	3461.5
	(SQL Overall)	178691	45	7.059	25313.9