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

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

78 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
abrogates	12	10	897	(None)
abrogate	11	12	960	1	abrogate_
abrogated	13	12	671	1	abrogated
arrogates	10	12	942	1	arrogates
ablegates	12	4	679	2	ablegates
abnegates	12	4	494	2	abnegates
abrogator	12	4	536	2	abrogator
abrogators	13	4	522	2	abrogators
arrogate	9	12	1032	2	arrogate_
arrogated	11	14	714	2	arrogated
bromates	12	4	1314	2	_bromates
derogates	11	3	1097	2	derogates
subrogates	13	4	583	2	subrogates
abates	8	58	2503	3	ab___ates
abdicates	14	4	815	3	abdicates
ablates	9	24	1690	3	ab__lates
ablegate	11	4	725	3	ablegate_
abnegate	11	4	486	3	abnegate_
abnegated	13	4	416	3	abnegated
abrades	10	3	1207	3	abr__ades
abrogable	14	4	457	3	abrogable
abrogating	14	9	798	3	abrogating
abrogation	13	10	733	3	abrogation
abrogations	14	11	646	3	abrogations
absolutes	11	4	452	3	absolutes
acrobats	12	5	834	3	acrobat_s
acrylates	14	4	668	3	acrylates
advocates	15	4	588	3	advocates
aerates	7	46	2749	3	aer__ates
aerobats	10	4	984	3	aerobat_s
aerolites	9	3	1258	3	aerolites
aerosats	8	4	1101	3	aerosat_s
agates	7	61	2134	3	a___gates
aggregates	13	4	412	3	aggregates
airdates	9	3	972	3	air_dates
allocates	11	4	1047	3	allocates
annotates	9	7	729	3	annotates
apholates	14	4	968	3	apholates
approbates	16	4	585	3	approbates
arrogances	13	4	424	3	arrogances
arrogator	10	4	525	3	arrogator
arrogators	11	4	537	3	arrogators
automates	11	4	1205	3	automates
baronages	12	4	715	3	baronages
biogases	11	3	614	3	_biogases
borates	9	48	2301	3	_b_orates
brigades	12	3	639	3	_brigades
brocades	13	5	871	3	_brocades
brocatel	12	4	671	3	_brocatel
brocatels	13	4	419	3	_brocatels
brogans	10	4	966	3	_broga_ns
brogues	10	71	982	3	_brog_ues
brokages	15	3	625	3	_brokages
bromate	11	3	1355	3	_bromate_
bromated	13	3	917	3	_bromated
carbonates	14	4	913	3	carbonates
chromates	16	3	1311	3	chromates
coronates	11	108	1692	3	coronates
corotates	11	27	1428	3	corotates
derogate	10	3	1135	3	derogate_
derogated	12	3	868	3	derogated
embrocates	16	6	501	3	embrocates
ergates	8	3	1449	3	_er_gates
fabricates	17	4	646	3	fabricates
frigates	12	3	1093	3	_frigates
irrigates	10	5	725	3	irrigates
obligates	12	20	785	3	obligates
perorates	11	4	1702	3	perorates
probates	12	4	1428	3	_probates
pronates	10	4	1837	3	_pronates
prorates	10	4	1807	3	_prorates
prorogates	13	4	731	3	prorogates
rotates	7	28	1977	3	__rotates
sororates	9	4	1047	3	sororates
subrogate	12	4	604	3	subrogate_
subrogated	14	4	438	3	subrogated
surrogates	11	4	468	3	surrogates
virgates	12	3	792	3	vir_gates

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	148641	0.420	425454.8
2	DLD Change Limit	148641	78	7.860	18911.1
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	8.313	21495.4