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

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

97 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
barefit	12	4	972	(None)
backfit	18	10	821	2	backfit
barefoot	13	4	641	2	barefoot
barest	8	53	2769	2	bare_st
befit	10	52	2266	2	b__efit
benefit	12	4	807	2	benefit
bereft	11	43	1730	2	beref_t
rarebit	9	4	842	2	rarebit
refit	8	42	3006	2	__refit
abreact	11	3	1082	3	abreact
abreast	9	3	1127	3	abreast
areic	7	32	1939	3	_are_ic
arenite	7	10	1771	3	_arenite
armpit	10	8	1109	3	_armpit
babesia	11	4	662	3	babesia
babysit	14	14	561	3	babysit
backbit	17	12	910	3	backbit
backfits	19	10	695	3	backfits
backlit	15	9	1190	3	backlit
bait	6	65	5600	3	ba___it
bakelite	14	4	725	3	bakelite
balefire	13	4	466	3	balefire
baleful	12	3	800	3	baleful
bandit	9	38	2113	3	ba_ndit
baneful	12	3	789	3	baneful
bankit	12	36	1704	3	ba_nkit
barbet	10	44	2788	3	bar_bet
barbie	10	50	1835	3	bar_bie
barbut	10	46	1700	3	bar_but
bardic	11	3	1292	3	bar_dic
bare	6	54	6052	3	bare___
bareboat	12	4	994	3	bareboat
bared	8	51	4448	3	bare__d
barege	9	47	1354	3	bare_ge
bareges	10	52	1203	3	bareges
barely	11	47	1679	3	bare_ly
barer	7	45	3580	3	bare__r
bares	7	54	5713	3	bare__s
barf	9	58	4441	3	bar_f__
barfed	12	54	1638	3	bar_fed
barfing	13	46	1509	3	bar_fing
barfly	14	33	965	3	bar_fly
barfs	10	48	2600	3	bar_f_s
bargain	10	7	906	3	bargain
baric	9	61	2569	3	bar__ic
barite	8	42	2481	3	bar__ite
barmaid	12	3	820	3	barmaid
barmie	10	38	1639	3	bar_mie
baronet	9	10	2220	3	baronet
barret	8	49	3048	3	bar_ret
barrio	8	3	1257	3	bar_rio
barytic	14	3	782	3	barytic
basest	8	47	2049	3	base_st
befits	11	47	1150	3	b__efits
benefic	14	4	604	3	benefic
benefits	13	4	571	3	benefits
beret	7	49	4636	3	bere__t
bluefin	12	4	512	3	bluefin
breast	8	3	1963	3	b_reast
brent	7	57	3413	3	b_re_nt
brevet	11	57	1733	3	b_revet
brevity	15	3	478	3	b_revity
brewis	11	46	998	3	b_rewis
brit	6	63	5015	3	b_r__it
bruit	7	61	2672	3	b_r_uit
buret	7	74	4401	3	bure__t
careful	12	4	911	3	careful
caret	7	53	6056	3	care__t
credit	9	3	1519	3	_credit
dareful	11	5	705	3	dareful
firelit	10	3	1086	3	firelit
forfeit	13	3	920	3	forfeit
haffit	15	3	853	3	ha_ffit
harelip	12	4	595	3	harelip
malefic	14	8	632	3	malefic
overfit	13	26	1096	3	overfit
parent	8	32	3042	3	pare_nt
paresis	9	33	1509	3	paresis
paretic	11	30	1667	3	paretic
parfait	12	3	1205	3	parfait
prefix	18	35	685	3	_prefix
profit	11	30	1627	3	_profit
rarebits	10	4	522	3	rarebits
rarefied	12	4	591	3	rarefied
rarefier	11	3	535	3	rarefier
rarefies	11	3	899	3	rarefies
rarefy	12	29	634	3	raref_y
rarest	6	57	2548	3	rare_st
recit	7	52	3510	3	__recit
refits	9	40	1765	3	__refits
refix	15	52	1248	3	__refix
reft	7	51	4127	3	__ref_t
relit	5	53	4068	3	__relit
remit	7	57	3722	3	__remit
resit	5	42	4104	3	__resit
surfeit	10	3	1034	3	surfeit
yarest	9	50	1891	3	yare_st

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	134027	0.423	422437.4
2	DLD Change Limit	134027	97	6.670	20094.0
3	Display Results	97	97	0.046	2108.7
	(SQL Overall)	178691	97	7.139	25030.3