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

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

33 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
appellant	13	4	635	(None)
appellants	14	4	396	1	appellants
appellate	13	4	619	2	appellate
appendant	14	5	573	2	appendant
expellant	18	4	496	2	expellant
repellant	11	4	682	2	repellant
aphelian	13	7	696	3	aphelian_
appalling	14	4	492	3	appalling
appealing	14	4	649	3	appealing
appellee	12	4	625	3	appell_ee
appellees	13	4	403	3	appellees
appellor	12	4	357	3	appell_or
appellors	13	4	354	3	appellors
appendants	15	4	406	3	appendants
appendent	14	4	627	3	appendent
appestat	12	4	671	3	appesta_t
appetent	12	4	808	3	appe_tent
applecart	15	5	360	3	applecart
applicant	15	4	544	3	applicant
avellan	10	3	729	3	a_vellan_
avellane	11	4	626	3	a_vellane
expellants	19	4	286	3	expellants
expellent	18	4	527	3	expellent
gellant	8	32	1405	3	__gellant
impellent	13	4	644	3	impellent
libellant	11	4	569	3	libellant
oppilant	12	4	602	3	opp_ilant
pieplant	12	6	873	3	_pieplant
preplant	12	7	1291	3	_preplant
propellant	14	12	585	3	propellant
rappelling	15	4	436	3	rappelling
repellants	12	4	417	3	repellants
repellent	11	4	838	3	repellent

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.436	409841.7
2	DLD Change Limit	148641	33	6.733	22076.5
3	Display Results	33	33	0.016	2062.5
	(SQL Overall)	178691	33	7.185	24870.0