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

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

67 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
ulcerating	13	4	698	(None)
lacerating	13	4	945	2	lacerating
macerating	15	4	954	2	macerating
ulceration	12	4	726	2	ulceration
ulcerations	13	4	636	2	ulcerations
ulcerative	15	4	517	2	ulcerative
ulcering	11	3	933	2	ulcer__ing
uncrating	12	8	1318	2	unc_rating
uncreating	13	3	1047	2	uncreating
acerbating	15	4	629	3	_acerbating
acierating	13	4	832	3	acierating
adulterating	14	5	324	3	adulterating
aerating	9	28	2100	3	__aerating
alerting	9	13	1238	3	al_er_ting
alienating	11	4	723	3	alienating
altercating	14	5	560	3	altercating
alternating	12	4	571	3	alternating
asperating	13	4	956	3	asperating
berating	11	32	2076	3	__berating
bleating	11	35	1450	3	bl_e_ating
ceratin	9	30	2016	3	__ceratin_
ceratins	10	28	1873	3	__ceratins
cleating	11	35	1814	3	cl_e_ating
cocreating	15	3	1029	3	cocreating
crating	10	37	2520	3	__c_rating
creating	11	39	2195	3	__creating
curating	11	3	1429	3	__curating
deaerating	12	3	1156	3	deaerating
decorating	14	3	1207	3	decorating
derating	10	32	2228	3	__derating
edulcorating	16	5	205	3	edulcorating
elevating	13	3	820	3	el_evating
excerpting	22	4	414	3	excerpting
execrating	20	4	788	3	execrating
federating	15	4	885	3	federating
fulgurating	16	4	296	3	fulgurating
generating	12	3	1038	3	generating
iterating	10	3	1425	3	_iterating
legating	10	23	1311	3	_l_egating
liberating	13	4	925	3	liberating
librating	12	3	905	3	_librating
lucubrating	16	5	278	3	lucubrating
lustrating	11	4	778	3	lustrating
moderating	14	4	880	3	moderating
nucleating	13	4	694	3	nucle_ating
numerating	13	5	723	3	numerating
operating	12	3	1372	3	_operating
pleating	11	29	1605	3	pl_e_ating
recrating	12	13	1879	3	rec_rating
recreating	13	12	1458	3	recreating
sulfurating	15	9	457	3	sulfurating
tolerating	11	4	859	3	tolerating
ulcerate	10	3	973	3	ulcerat__e
ulcerated	12	4	774	3	ulcerat_ed
ulcerates	11	4	885	3	ulcerat_es
ultimating	13	8	680	3	ultimating
ultratiny	12	4	670	3	ul_tratiny
ululating	10	3	664	3	ul_ulating
unceasing	12	3	965	3	unce_asing
uncertain	11	4	620	3	uncertain_
uncoating	12	6	1192	3	unc_oating
underacting	15	4	752	3	underacting
undereating	13	6	955	3	undereating
underrating	13	8	825	3	underrating
unseating	10	7	1320	3	unse_ating
uprating	11	3	1111	3	u__prating
venerating	14	4	1005	3	venerating

Search took 7 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	140603	0.423	422437.4
2	DLD Change Limit	140603	67	6.233	22557.8
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	6.689	26714.2