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

Here are the results of your fuzzy-string dictionary search for “agglomerating” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

60 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
agglomerating	18	6	154	(None)
agglomeration	17	6	208	2	agglomeration
agglomerations	18	6	178	2	agglomerations
agglomerative	20	6	191	2	agglomerative
agglomerate	15	6	194	3	agglomerat__e
agglomerated	17	9	161	3	agglomerat_ed
agglomerates	16	9	190	3	agglomerat_es
conglomerating	20	6	242	3	conglomerating
adulterating	14	5	324	4	adul_terating
agglutinating	16	6	247	4	agglutinating
aggregating	13	4	358	4	agg__regating
alliterating	13	5	427	4	a_lliterating
abominating	16	4	484	5	a__bominating
accelerating	17	5	373	5	a_ccelerating
acclimating	18	4	528	5	acclim__ating
acierating	13	4	831	5	a___cierating
adumbrating	17	5	240	5	a__dumbrating
aerating	9	28	2100	5	a_____erating
aggrading	13	4	484	5	agg____rading
aggravating	17	5	241	5	agg__ravating
alerting	9	13	1238	5	a__l__er_ting
alienating	11	4	722	5	a__l_ienating
alimenting	13	4	450	5	a__lime_nting
allocating	13	4	738	5	a_llo__cating
allografting	17	5	186	5	a_llo_grafting
altercating	14	5	560	5	a__l_tercating
alternating	12	4	571	5	a__l_ternating
ameliorating	15	5	307	5	amel_iorating
asperating	13	4	956	5	a___sperating
asseverating	16	5	227	5	a_sseverating
augmenting	14	4	385	5	aug__me_nting
automating	13	8	930	5	a_utom__ating
conglomeratic	20	6	216	5	conglomerati_c
conglomeration	19	6	300	5	conglomeration
conglomerations	20	6	273	5	conglomerations
conglomerative	22	13	232	5	conglomerative
cooperating	16	4	842	5	__cooperating
degenerating	15	4	566	5	deg_enerating
deliberating	16	4	512	5	_deliberating
enumerating	14	4	500	5	__enumerating
exaggerating	22	5	318	5	exagg___erating
exonerating	19	4	555	5	__exonerating
generating	12	3	1038	5	__g_enerating
gloating	10	26	1146	5	__glo___ating
glomerate	12	4	567	5	__glomerat__e
glowering	14	3	565	5	__glower__ing
halogenating	17	5	252	5	_halogenating
lacerating	13	4	944	5	___lacerating
liberating	13	4	925	5	___liberating
moderating	14	4	880	5	___moderating
nonoperating	15	5	541	5	_nonoperating
numerating	13	5	723	5	___numerating
obliterating	15	5	339	5	_obliterating
operating	12	3	1372	5	____operating
overoperating	19	5	672	5	overoperating
proliferating	19	6	236	5	proliferating
regenerating	14	4	633	5	reg_enerating
reoperating	14	4	902	5	__reoperating
tolerating	11	4	859	5	___tolerating
ulcerating	13	4	698	5	__ul_cerating

Search took 9 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.390	458182.1
2	DLD Change Limit	124790	60	8.266	15096.8
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	8.689	20565.2