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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

113 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
barkeeps	16	3	414	(None)
barkeep	15	3	636	1	barkeep_
bargees	10	54	1587	2	bargee_s
barkeeper	17	4	293	2	barkeeper
barkeepers	18	4	289	2	barkeepers
barkers	13	43	1851	2	bark_ers
barkless	14	31	802	2	barkless
ackees	12	49	1457	3	_ackee_s
akees	9	61	1924	3	_a_kee_s
backers	15	38	2188	3	back_ers
backless	16	29	1063	3	backless
backsets	16	3	885	3	backsets
backups	17	3	617	3	back_ups
bailees	9	39	1438	3	bailee_s
bakers	12	53	2345	3	ba_k_ers
bakes	11	70	3537	3	ba_k_e_s
baleens	9	3	847	3	ba_leens
balkers	13	49	1572	3	balk_ers
bankers	13	39	1909	3	bank_ers
barbells	12	36	882	3	barbells
barbels	11	45	1443	3	bar_bels
barbers	11	43	1750	3	bar_bers
barbes	10	45	2623	3	bar_be_s
barbets	11	49	1584	3	bar_bets
barbies	11	45	1959	3	barbie_s
barbless	12	31	871	3	barbless
bardes	9	50	2693	3	bar_de_s
bareges	10	52	1203	3	bar_eges
bareness	10	9	1281	3	bareness
bares	7	54	5713	3	bar__e_s
bargee	9	46	2444	3	bargee__
barges	9	45	2825	3	bar_ge_s
barhops	14	28	811	3	bar_hops
barites	9	43	2233	3	barite_s
barked	13	50	2731	3	bark_e_d
barker	12	48	2286	3	bark_e_r
barkier	13	38	1448	3	barkie_r
barkiest	14	41	1515	3	barkiest
barks	11	57	3581	3	bark___s
barless	9	43	1700	3	bar_less
barleys	12	50	1184	3	bar_leys
barneys	12	56	956	3	bar_neys
baroness	10	12	1006	3	baroness
baronets	10	14	1090	3	baronets
barques	18	25	964	3	barque_s
barrels	9	45	1436	3	bar_rels
barrens	9	44	1432	3	bar_rens
barres	8	44	2754	3	bar_re_s
barrets	9	49	1710	3	bar_rets
barriers	10	43	1188	3	barriers
bartends	11	3	679	3	bartends
barterers	11	26	963	3	barterers
barters	9	42	2303	3	bar_ters
baryes	11	62	1850	3	bar_ye_s
barytes	12	46	1115	3	baryte_s
baskets	13	51	1183	3	bask_ets
baubees	11	34	871	3	baubee_s
bawbees	14	33	724	3	bawbee_s
beeps	9	53	2097	3	b___eeps
berseems	12	6	393	3	berseems
beweeps	14	9	456	3	b_eweeps
bidarkees	16	4	214	3	bidarkee_s
birkies	13	37	1243	3	birkie_s
bleeps	10	49	910	3	b__leeps
bopeeps	13	3	310	3	b_opeeps
boreens	9	3	1040	3	bor_eens
brakeless	15	4	499	3	brakeless
brakes	12	49	2312	3	brak_e_s
breeds	9	49	1488	3	b_r_eeds
breeks	12	53	1079	3	b_r_eeks
brees	7	56	3255	3	b_r_ee_s
buckeens	16	3	485	3	buckeens
burgees	10	49	1589	3	burgee_s
burkers	13	37	1662	3	burk_ers
burkes	12	44	2131	3	burk_e_s
burseeds	11	3	478	3	burseeds
burweeds	14	3	410	3	burweeds
careens	9	45	1470	3	car_eens
careers	9	52	1878	3	car_eers
creeps	10	42	1362	3	_cr_eeps
darkeners	14	3	515	3	darkeners
darkens	12	40	987	3	dark_ens
darkeys	15	35	653	3	dark_eys
darkies	12	40	1575	3	darkie_s
darkles	12	40	1193	3	darkle_s
darkness	13	24	734	3	darkness
fakeers	14	44	667	3	fa_keers
hackees	16	50	1410	3	hackee_s
hakeems	16	39	480	3	ha_keems
hareems	12	42	820	3	har_eems
harkeners	16	3	607	3	harkeners
harkens	14	41	1286	3	hark_ens
keeps	11	60	2028	3	___keeps
kreeps	12	42	741	3	_kr_eeps
larees	6	53	2311	3	lar_ee_s
larkers	11	30	1451	3	lark_ers
makeups	15	3	360	3	ma_keups
markers	13	35	1610	3	mark_ers
marketers	15	4	598	3	marketers
markets	13	33	1403	3	mark_ets
markups	15	3	496	3	mark_ups
miskeeps	16	4	416	3	miskeeps
nankeens	12	4	324	3	nankeens
outkeeps	14	4	358	3	outkeeps
parakeets	15	4	510	3	parakeets
parkers	13	38	1687	3	park_ers
rakees	10	45	1697	3	ra_kee_s
sarees	6	53	2994	3	sar_ee_s
takeups	13	3	340	3	ta_keups
tarweeds	12	4	427	3	tarweeds
threeps	12	68	704	3	thr_eeps
upkeeps	15	3	219	3	_upkeeps
vakeels	14	11	373	3	va_keels

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	113	7.123	20519.7
3	Display Results	113	113	0.046	2456.5
	(SQL Overall)	178691	113	7.325	24394.7