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

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

77 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
arrogates	10	12	942	(None)
abrogates	12	10	897	1	abrogates
arrogate	9	12	1032	1	arrogate_
arrogated	11	14	714	1	arrogated
abrogate	11	12	960	2	abrogate_
abrogated	13	12	671	2	abrogated
arrogances	13	4	424	2	arrogances
arrogator	10	4	525	2	arrogator
arrogators	11	4	537	2	arrogators
derogates	11	3	1097	2	derogates
irrigates	10	5	725	2	irrigates
prorogates	13	4	731	2	prorogates
surrogates	11	4	468	2	surrogates
ablegates	12	4	679	3	ablegates
abnegates	12	4	494	3	abnegates
abrogator	12	4	536	3	abrogator
abrogators	13	4	522	3	abrogators
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
areolate	8	10	1445	3	areolate_
areolated	10	8	971	3	areolated
arrases	7	12	1454	3	arr__ases
arrobas	9	6	921	3	arroba__s
arrogance	12	6	446	3	arrogance
arrogancies	14	5	407	3	arrogancies
arrogancy	15	5	354	3	arrogancy
arrogant	9	4	915	3	arroga_nt
arrogantly	14	13	280	3	arrogantly
arrogating	12	177	839	3	arrogating
arrogation	11	10	744	3	arrogation
arrogations	12	12	648	3	arrogations
arsenates	9	7	937	3	arsenates
automates	11	4	1205	3	automates
bromates	12	4	1314	3	_bromates
carbonates	14	4	913	3	carbonates
carronades	13	4	576	3	carronades
chromates	16	3	1311	3	chromates
coronates	11	108	1692	3	coronates
corotates	11	27	1428	3	corotates
corrugates	13	4	518	3	corrugates
derogate	10	3	1135	3	derogate_
derogated	12	3	867	3	derogated
ergates	8	3	1449	3	_er_gates
frigates	12	3	1093	3	_frigates
garrotes	9	6	936	3	garro__tes
garrottes	10	6	548	3	garro_ttes
irrigate	9	6	763	3	irrigate_
irrigated	11	7	631	3	irrigated
irritates	9	7	722	3	irritates
narrates	8	3	1276	3	narr__ates
perorates	11	4	1702	3	perorates
priorates	11	4	1076	3	priorates
probates	12	4	1428	3	_probates
pronates	10	4	1837	3	_pronates
prorates	10	4	1807	3	_prorates
prorogate	12	4	769	3	prorogate_
prorogated	14	4	572	3	prorogated
rotates	7	28	1977	3	__rotates
sororates	9	4	1047	3	sororates
subrogates	13	4	583	3	subrogates
surrogate	10	4	478	3	surrogate_
surrogated	12	4	370	3	surrogated
variegates	14	4	404	3	variegates
variolates	13	4	746	3	variolates
virgates	12	3	792	3	vir_gates

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	148641	0.153	1167915.0
2	DLD Change Limit	148641	77	6.503	22857.3
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.686	26726.1