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

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

81 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
barrators	11	4	839	(None)
barraters	11	3	804	1	barraters
barrator	10	4	840	1	barrator_
barretors	11	4	624	1	barretors
narrators	9	4	786	1	narrators
aerators	8	3	1561	2	_aerators
barrater	10	3	1014	2	barrater_
barratry	13	11	447	2	barrat_ry
barretor	10	4	671	2	barretor_
narraters	9	4	670	2	narraters
narrator	8	4	756	2	narrator_
warrantors	13	4	304	2	warrantors
abators	9	44	1308	3	_a_bators
ablators	10	6	987	3	_ablators
abrogators	13	4	522	3	abrogators
aerator	7	3	1484	3	_aerator_
arrayers	11	12	585	3	_arrayers
arrestors	9	5	802	3	_arrestors
arrogators	11	4	537	3	_arrogators
aviators	11	16	990	3	_aviators
barbarous	13	4	562	3	barbarous
barnstorm	13	4	393	3	barnstorm
barnstorms	14	4	296	3	barnstorms
barrackers	18	4	376	3	barrackers
barracks	16	3	688	3	barra_cks
barracoon	13	4	330	3	barracoon
barracoons	14	4	298	3	barracoons
barrages	11	7	1108	3	barra_ges
barrancas	13	4	509	3	barrancas
barrancos	13	4	419	3	barrancos
barratries	12	4	573	3	barratries
barretry	13	11	518	3	barret_ry
barrets	9	49	1710	3	barret__s
barrettes	11	4	906	3	barrettes
barriers	10	43	1188	3	barr_iers
barrios	9	3	1077	3	barr_io_s
barristers	12	4	472	3	barristers
barrooms	12	3	789	3	barr_ooms
barrows	12	34	1168	3	barr__ows
barters	9	42	2303	3	ba_r_ters
barytons	13	4	557	3	ba_rytons
burritos	10	4	447	3	burrito_s
castrators	12	4	744	3	castrators
caveators	14	9	726	3	caveators
creators	10	28	1440	3	_creators
curators	10	3	1172	3	_curators
deaerators	11	10	771	3	deaerators
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	841	3	marrano_s
migrators	12	4	754	3	migrators
narrater	8	3	872	3	narrater_
narrates	8	3	1276	3	narrat_es
narrations	10	3	894	3	narrations
nitrators	9	4	921	3	nitrators
obturators	12	4	430	3	obturators
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	1496	3	sa_r_tors
saturators	10	4	609	3	saturators
tarragons	10	4	447	3	tarragons
titrators	9	4	837	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 10 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.173	1032896.0
2	DLD Change Limit	148641	81	8.923	16658.2
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	9.126	19580.4