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

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

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
breastworks	20	5	236	(None)
breastwork	19	5	260	1	breastwork_
beadworks	19	4	572	3	b_ea_dworks
breastbones	15	14	258	3	breastbones
brightworks	24	6	158	3	brightworks
brushworks	22	5	283	3	br_ushworks
craftworks	22	4	262	3	cr_aftworks
fretworks	19	4	510	3	fre__tworks
frostworks	20	4	303	3	fr_ostworks
pressworks	19	5	411	3	pre_ssworks
seatworks	16	4	630	3	_sea_tworks
artworks	15	4	652	4	___artworks
basketworks	19	5	159	4	basketworks
beadwork	18	4	603	4	b_ea_dwork_
brasswares	15	8	373	4	br_asswares
breastbone	14	13	263	4	breastbo_ne
breastfeeds	17	5	80	4	breastfeeds
breastpins	14	4	271	4	breast_pins
breasts	9	3	970	4	breast____s
breaststroke	18	6	82	4	breaststroke
breaststrokes	19	7	86	4	breaststrokes
breathers	14	31	909	4	brea_ther_s
brickworks	20	5	305	4	br_ickworks
bridgeworks	22	5	152	4	bridgeworks
brightwork	23	6	191	4	brightwork_
broadswords	18	5	175	4	broadswords
brushwork	21	4	291	4	br_ushwork_
busyworks	21	4	337	4	b__usyworks
caseworks	18	4	641	4	__caseworks
classworks	19	4	331	4	_classworks
craftwork	21	4	268	4	cr_aftwork_
creators	10	28	1438	4	crea_t_or_s
crewelworks	23	5	131	4	crewelworks
drawnworks	21	5	185	4	dr_awnworks
earthworks	20	4	356	4	__earthworks
eastwards	13	4	425	4	__eastwards
flatworks	19	4	470	4	_fla_tworks
frameworks	22	4	326	4	fr_ameworks
fretwork	18	4	568	4	fre__twork_
frostwork	19	4	349	4	fr_ostwork_
gasworks	16	4	594	4	__gas_works
glassworks	18	4	280	4	_glassworks
greasewoods	16	5	150	4	greasewoods
guessworks	18	5	187	4	gue_ssworks
headworks	20	4	595	4	_hea_dworks
heartworms	18	4	288	4	_heartworms
leadworks	17	4	512	4	_lea_dworks
meshworks	21	4	363	4	_me_shworks
networks	15	4	614	4	_ne__tworks
presswork	18	5	452	4	pre_sswork_
prestores	11	47	1606	4	pre_st_ores
preworks	17	59	900	4	pre___works
rackworks	17	4	554	4	_r_ackworks
reactors	10	32	1228	4	_react_or_s
realtors	8	28	1168	4	_realt_or_s
reassorts	9	4	562	4	_reas_sorts
restocks	14	3	750	4	_re_st_ocks
restores	8	52	2298	4	_re_st_ores
reworks	14	51	1359	4	_re___works
roadworks	17	4	529	4	_roa_dworks
saltworks	16	4	516	4	__saltworks
seatwork	15	4	677	4	_sea_twork_
taskworks	15	4	390	4	__taskworks
teamworks	18	4	459	4	_tea_mworks
trestleworks	19	6	91	4	tre_stleworks
wheatworms	21	5	187	4	whea_tworms

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	66	8.876	16766.4
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	9.062	19718.7