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

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

34 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
administrator	16	6	197	(None)
administrators	17	6	171	1	administrators
administrate	15	6	253	2	administrat_e
administrated	17	6	206	2	administrated
administrates	16	6	239	2	administrates
administration	17	14	255	2	administration
administrable	18	7	160	3	administrable
administrant	15	6	247	3	administra_nt
administrants	16	6	206	3	administrants
administrating	18	6	213	3	administrating
administrations	18	16	240	3	administrations
administrative	20	7	215	3	administrative
administratrix	24	8	128	3	administratrix
administer	13	4	327	4	adminis___ter
demonstrator	15	7	392	4	demon_strator
ministration	14	6	583	4	__ministration
remonstrator	14	7	408	4	remon_strator
administered	16	6	190	5	administ_ered
administering	17	6	219	5	administering
administers	14	5	290	5	administ__ers
admonitor	12	4	312	5	admoni____tor
ameliorator	13	10	264	5	a_meli_orator
arbitrator	12	5	439	5	a__rbi_trator
demonstrators	16	7	341	5	demon_strators
denigrator	12	4	522	5	_d_eni_grator
infiltrator	14	5	302	5	___infiltrator
initiator	9	9	811	5	___ini_tiator
ministate	11	4	726	5	__minist_at_e
ministates	12	4	674	5	__minist_ates
ministrant	12	5	580	5	__ministra_nt
ministrants	13	5	385	5	__ministrants
ministrations	15	5	544	5	__ministrations
nitrator	8	4	955	5	____ni_trator
remonstrators	15	8	356	5	remon_strators

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	34	7.956	15685.0
3	Display Results	34	34	0.013	2615.4
	(SQL Overall)	178691	34	8.359	21377.1