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

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

71 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
narrators	9	4	786	(None)
barrators	11	4	839	1	barrators
narraters	9	4	670	1	narraters
narrator	8	4	756	1	narrator_
aerators	8	3	1561	2	_aerators
barraters	11	3	804	2	barraters
barrator	10	4	840	2	barrator_
barretors	11	4	624	2	barretors
narrater	8	3	872	2	narrater_
narrates	8	3	1276	2	narrat_es
narrations	10	3	894	2	narrations
nitrators	9	4	921	2	nitrators
warrantors	13	4	304	2	warrantors
abators	9	44	1308	3	_a_bators
ablators	10	6	987	3	_ablators
aerator	7	3	1484	3	_aerator_
animators	11	12	1042	3	animators
arrayers	11	12	585	3	_arrayers
arrestors	9	5	803	3	_arrestors
arrogators	11	4	537	3	_arrogators
aviators	11	16	990	3	_aviators
barrater	10	3	1014	3	barrater_
barratry	13	11	447	3	barrat_ry
barretor	10	4	671	3	barretor_
castrators	12	4	744	3	castrators
caveators	14	9	726	3	caveators
creators	10	28	1441	3	_creators
curators	10	3	1172	3	_curators
deaerators	11	10	771	3	deaerators
enervators	13	4	570	3	enervators
farragoes	13	4	463	3	farragoes
garroters	10	5	581	3	garroters
gyrators	12	4	599	3	_gyrators
hydrators	16	4	568	3	hydrators
labradors	12	4	379	3	labradors
laudators	10	4	589	3	laudators
macerators	14	16	748	3	macerators
mandators	12	4	787	3	mandators
marcatos	12	4	916	3	marcato_s
marranos	10	3	842	3	marrano_s
migrators	12	4	754	3	migrators
narrate	7	3	1349	3	narrat__e
narrated	9	3	1032	3	narrat_ed
narrating	10	3	1035	3	narrating
narration	9	3	1006	3	narration
narrative	12	4	737	3	narrative
narratives	13	4	479	3	narratives
narrows	10	25	884	3	narr__ows
natatory	11	4	660	3	na_tatory
navigators	14	6	482	3	navigators
negators	9	24	1117	3	n_egators
nitrator	8	4	955	3	nitrator_
numerators	12	4	555	3	numerators
operators	11	4	1075	3	operators
orators	7	3	1382	3	__orators
palpators	13	4	679	3	palpators
paradors	11	34	1190	3	pa_radors
parroters	11	5	676	3	parroters
perorators	12	4	935	3	perorators
radiators	10	4	932	3	radiators
sartors	7	3	1497	3	sa_r_tors
saturators	10	4	609	3	saturators
tarragons	10	4	448	3	tarragons
titrators	9	4	838	3	titrators
valuators	12	8	646	3	valuators
varactors	14	4	639	3	varactors
varistors	12	4	653	3	varistors
vibrators	14	23	725	3	vibrators
warranters	13	4	452	3	warranters
warrantor	12	4	321	3	warrantor_
warriors	11	3	536	3	warr_iors

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.406	440125.6
2	DLD Change Limit	148641	71	7.360	20195.8
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	7.796	22920.9