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

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

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.

66 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
barbets	11	49	1584	(None)
barbels	11	45	1443	1	barbels
barbers	11	43	1750	1	barbers
barbes	10	45	2623	1	barbe_s
barbet	10	44	2788	1	barbet_
barbuts	11	43	984	1	barbuts
barrets	9	49	1710	1	barrets
abets	7	56	2167	2	_a_bets
armets	8	49	1835	2	_armets
babels	10	52	1672	2	ba_bels
babes	9	58	3411	2	ba_be_s
baguets	10	3	748	2	baguets
ballets	9	37	1951	2	ballets
bannets	9	40	1384	2	bannets
barbate	11	3	1454	2	barbate
barbe	9	53	2828	2	barbe__
barbed	11	51	2131	2	barbe_d
barbel	10	43	1707	2	barbe_l
barbell	11	42	996	2	barbell
barbells	12	36	882	2	barbells
barber	10	44	1932	2	barbe_r
barbette	12	4	911	2	barbette
barbettes	13	4	816	2	barbettes
barbies	11	45	1959	2	barbies
barbless	12	31	871	2	barbless
barbs	9	59	2819	2	barb__s
barbut	10	46	1700	2	barbut_
bardes	9	50	2693	2	barde_s
bares	7	54	5713	2	bar_e_s
barest	8	53	2769	2	bar_est
bargees	10	54	1587	2	bargees
barges	9	45	2825	2	barge_s
barites	9	43	2233	2	barites
barkers	13	43	1851	2	barkers
barless	9	43	1700	2	barless
barleys	12	50	1184	2	barleys
barneys	12	56	956	2	barneys
baronets	10	14	1090	2	baronets
barrels	9	45	1436	2	barrels
barrens	9	44	1432	2	barrens
barres	8	44	2754	2	barre_s
barret	8	49	3048	2	barret_
barters	9	42	2303	2	barters
baryes	11	62	1850	2	barye_s
barytes	12	46	1115	2	barytes
baskets	13	51	1183	2	baskets
bassets	9	64	1482	2	bassets
baubees	11	34	871	2	baubees
bawbees	14	33	724	2	bawbees
berets	8	58	2252	2	ber_ets
burbots	11	6	867	2	burbots
burets	8	43	2126	2	bur_ets
burnets	9	38	1326	2	burnets
carets	8	53	3077	2	car_ets
carnets	9	39	1840	2	carnets
carpets	11	39	1533	2	carpets
gargets	9	46	1457	2	gargets
garnets	8	41	1540	2	garnets
garrets	8	44	1362	2	garrets
labrets	9	3	936	2	labrets
markets	13	33	1403	2	markets
pargets	10	52	1519	2	pargets
rabbets	11	27	942	2	rabbets
sorbets	9	30	1250	2	sorbets
targets	8	43	1422	2	targets
varlets	10	4	1157	2	varlets

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	66	3.643	29555.6
3	Display Results	66	66	0.013	5076.9
	(SQL Overall)	178691	66	3.796	47073.5