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

Here are the results of your fuzzy-string dictionary search for “bardolaters” with Change Limit: [1] [2] [3] [4] [5]

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.

78 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
bardolaters	14	5	270	(None)
bardolater	13	4	384	1	bardolater_
bardolatry	16	5	182	2	bardolat_ry
bandoleers	13	4	356	3	bandol_eers
bandoliers	13	4	414	3	bandol_iers
bardolatries	15	5	192	3	bardolatries
barometers	14	19	851	3	bar_ometers
barraters	11	3	804	3	bar__raters
cardplayers	19	5	166	3	cardplayers
idolaters	10	4	571	3	__idolaters
variolates	13	4	746	3	variolate_s
abrogates	12	10	897	4	abr_ogate_s
abrogators	13	4	522	4	abr_ogators
adopters	11	3	669	4	_a_do_pters
adulates	9	3	1191	4	_a_dulate_s
adulators	10	4	806	4	_a_dulators
aldolases	10	4	522	4	_aldolase_s
apholates	14	4	968	4	_apholate_s
areolate	8	10	1445	4	_areolate__
areolated	10	8	971	4	_areolate_d
arrogates	10	12	942	4	_arrogate_s
arrogators	11	4	537	4	_arrogators
backwaters	21	9	516	4	ba_ckwaters
baldpates	14	4	523	4	bald_pate_s
ballasters	12	4	509	4	ba__llasters
balloters	11	5	767	4	ba__lloters
ballplayers	18	5	160	4	ballplayers
bandagers	13	3	588	4	band__agers
bandleaders	15	5	271	4	bandleaders
bandmasters	16	8	418	4	bandmasters
bandmates	14	4	792	4	band_mate_s
bandoleer	12	4	425	4	bandol_eer_
bandolier	12	4	528	4	bandol_ier_
barometer	13	18	904	4	bar_ometer_
baronages	12	4	715	4	bar_onage_s
barosaurs	11	4	381	4	bar_osa_urs
barrater	10	3	1014	4	bar__rater_
barrators	11	4	839	4	bar__rators
barrelages	13	4	362	4	barrelage_s
barristers	12	4	472	4	bar_risters
barters	9	42	2303	4	bar____ters
baseplates	14	11	440	4	baseplate_s
bathwaters	18	4	353	4	ba_thwaters
bedplates	14	4	549	4	b_edplate_s
bibliolaters	16	7	210	4	bibliolaters
bloaters	10	33	1102	4	b__lo_aters
boaters	9	34	1924	4	b___o_aters
bolsters	10	37	1245	4	b___olsters
bolters	9	40	1780	4	b___ol_ters
brocatels	13	4	419	4	b_r_ocatels
bromates	12	4	1314	4	b_r_omate_s
burgomasters	17	5	145	4	burgomasters
carbonates	14	4	913	4	carbonate_s
cardholders	18	5	299	4	cardhol_ders
cardplayer	18	5	198	4	cardplayer_
carolers	10	33	1417	4	car_ol__ers
carollers	11	3	770	4	car_ol_lers
desolaters	11	4	604	4	_desolaters
dilaters	9	25	1306	4	___dilaters
garotters	10	5	503	4	gar_o_tters
garroters	10	5	581	4	garro__ters
idolater	9	3	686	4	__idolater_
idolators	10	4	628	4	__idolators
narraters	9	4	670	4	nar__raters
pardoners	12	20	821	4	pardo__ners
parroters	11	5	676	4	parro__ters
percolates	14	4	1041	4	percolate_s
percolators	15	4	536	4	percolators
relaters	8	32	1815	4	__r_elaters
sandblasters	15	5	215	4	sandblasters
sandlotters	12	5	287	4	sandlotters
variolate	12	4	855	4	variolate__
variolated	14	4	540	4	variolate_d
variolites	13	4	667	4	variolite_s
variometers	16	4	516	4	variometers
violaters	12	4	596	4	__violaters
yardmasters	17	5	273	4	yardmasters
zoolaters	18	4	498	4	__zoolaters

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	148819	0.156	1145455.1
2	DLD Change Limit	148819	78	9.016	16506.1
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	9.202	19418.7