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

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

76 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
ablegates	12	4	681	(None)
ablegate	11	4	726	1	ablegate_
abnegates	12	4	496	1	abnegates
ablates	9	24	1691	2	abl__ates
abnegate	11	4	487	2	abnegate_
abnegated	13	4	417	2	abnegated
abrogates	12	10	899	2	abrogates
delegates	11	3	984	2	delegates
legates	8	29	1768	2	__legates
obligates	12	20	785	2	obligates
relegates	10	3	1094	2	relegates
tablemates	14	4	470	2	tablemates
abates	8	58	2504	3	ab___ates
abdicates	14	4	816	3	abdicates
ablate	8	22	1921	3	abl__ate_
ablated	10	25	1344	3	abl__ated
ableists	10	3	656	3	ableist_s
abnegator	12	4	361	3	abnegator
abnegators	13	4	369	3	abnegators
abrogate	11	12	961	3	abrogate_
abrogated	13	12	672	3	abrogated
acetates	10	20	1307	3	a_cetates
acierates	11	3	1082	3	acierates
aerates	7	46	2750	3	a__erates
agates	7	61	2134	3	a___gates
agemates	11	11	1003	3	a_gemates
aggregates	13	4	414	3	aggregates
alates	6	48	3397	3	a_l__ates
alegars	8	3	893	3	a_lega_rs
alienates	9	3	1069	3	alienates
alleges	8	42	1257	3	alleg__es
alleviates	13	4	497	3	alleviates
allocates	11	4	1047	3	allocates
ameerates	11	4	907	3	ameerates
antedates	10	4	862	3	antedates
arrogates	10	12	943	3	arrogates
arsenates	9	7	938	3	arsenates
asperates	11	3	1256	3	asperates
baldpates	14	4	523	3	baldpates
ballgames	14	4	357	3	ballgames
begazes	19	3	796	3	_b_egazes
berates	9	41	2688	3	_b_erates
bleated	10	40	1597	3	_ble_ated
bleater	9	45	1530	3	_ble_ater
bleaters	10	34	1232	3	_ble_aters
bleats	8	55	1862	3	_ble_at_s
delegate	10	4	1046	3	delegate_
delegated	12	3	837	3	delegated
delegatee	11	4	881	3	delegatee
delegatees	12	4	427	3	delegatees
elevates	11	11	1043	3	_elevates
legate	7	29	1745	3	__legate_
legated	9	25	1398	3	__legated
legatee	8	28	1463	3	__legatee
legatees	9	25	843	3	__legatees
legatos	8	27	1119	3	__legatos
ligates	8	23	1838	3	__ligates
maleates	10	33	1634	3	male_ates
negates	8	32	1584	3	__negates
oblates	9	19	1324	3	obl__ates
obligate	11	19	830	3	obligate_
obligated	13	18	690	3	obligated
obligatos	12	19	507	3	obligatos
oleates	7	4	1783	3	_ole_ates
relegate	9	3	1124	3	relegate_
relegated	11	3	976	3	relegated
selenates	9	16	1136	3	selenates
stablemates	15	5	242	3	stablemates
tablemate	13	4	483	3	tablemate_
tablewares	15	5	315	3	tablewares
tailgates	10	4	653	3	tail_gates
tolerates	9	3	1212	3	tolerates
tollgates	10	4	605	3	tollgates
valerates	12	3	1054	3	valerates
variegates	14	4	404	3	variegates
vulgates	12	23	723	3	vul_gates

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.420	425454.8
2	DLD Change Limit	148641	76	6.800	21859.0
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.250	24647.0