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

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

63 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
administrated	17	6	206	(None)
administrate	15	6	253	1	administrate_
administrates	16	6	239	1	administrates
administrator	16	6	197	2	administrator
administered	16	6	190	3	administ_ered
administrable	18	7	160	3	administrable
administrant	15	6	248	3	administra_nt
administrants	16	6	206	3	administrants
administrating	18	6	213	3	administrating
administration	17	14	255	3	administration
administrative	20	7	215	3	administrative
administrators	17	6	171	3	administrators
administratrix	24	8	128	3	administratrix
administer	13	4	327	4	adminis___ter
administrations	18	16	240	4	administrations
demonstrated	16	13	489	4	demon_strated
denitrated	12	9	803	4	_d_eni_trated
ministate	11	4	726	4	__minist_ate_
ministates	12	4	674	4	__minist_ates
remonstrated	15	14	557	4	remon_strated
administering	17	6	219	5	administering
administers	14	5	290	5	administ__ers
admitted	12	3	476	5	adm__i_t__ted
admonished	17	4	303	5	admonis___hed
ameliorated	14	5	341	5	a_meli_orated
ammoniated	15	4	379	5	ammoni___ated
arbitrated	13	12	552	5	a__rbi_trated
commiserated	19	6	306	5	com_miserated
defenestrated	18	6	214	5	defenestrated
demonstrate	14	14	592	5	demon_strate_
demonstrates	15	15	560	5	demon_strates
denigrated	13	6	697	5	_d_eni_grated
denitrate	10	8	1053	5	_d_eni_trate_
denitrates	11	6	951	5	_d_eni_trates
digitated	12	8	696	5	_d_igi_t_ated
disrated	10	9	1557	5	_d___is_rated
distracted	14	4	887	5	_d___istracted
fenestrated	15	5	424	5	__fenestrated
infiltrated	15	5	343	5	___infiltrated
initiated	10	5	1011	5	___ini_tiated
instated	9	16	1334	5	___in_st_ated
magistrate	13	4	407	5	__magistrate_
magistrates	14	5	373	5	__magistrates
menstruated	14	7	374	5	__men_struated
militated	12	4	880	5	__mili_t_ated
miniskirted	18	5	114	5	__miniskirted
ministered	13	4	496	5	__minist_ered
ministrant	12	5	581	5	__ministra_nt
ministrants	13	5	385	5	__ministrants
ministration	14	6	583	5	__ministration
ministries	12	4	756	5	__ministr_ies
misrated	11	13	1538	5	__m__is_rated
misstarted	13	4	487	5	__mi_sstarted
misstated	12	7	897	5	__mi_sst_ated
mistraced	14	3	945	5	__m__istraced
mistreated	13	4	842	5	__m__istreated
nitrated	9	22	1315	5	____ni_trated
reinitiated	12	4	520	5	_reini_tiated
reinstated	11	4	728	5	_rein_st_ated
remonstrate	13	14	641	5	remon_strate_
remonstrates	14	14	605	5	remon_strates
ringstraked	17	5	100	5	__ringstraked
uninitiated	12	6	486	5	_unini_tiated

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	63	8.080	15444.3
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	8.500	21022.5