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

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

80 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
baywoods	17	4	559	(None)
baywood	16	4	644	1	baywood_
babyhoods	20	4	291	2	babyhoods
backwoods	21	4	639	2	backwoods
basswoods	15	7	432	2	basswoods
bearwoods	15	4	502	2	bearwoods
bogwoods	15	4	482	2	bogwoods
boxwoods	21	4	418	2	boxwoods
boyhoods	17	4	488	2	boyhoods
bywords	16	3	428	2	b_ywords
dagwoods	14	4	458	2	dagwoods
fatwoods	15	8	595	2	fatwoods
plywoods	17	4	435	2	plywoods
sapwoods	14	5	626	2	sapwoods
agalwoods	14	4	314	3	agalwoods
babools	11	31	945	3	ba_bools
baboons	11	32	1108	3	ba_boons
baboos	10	35	1701	3	ba_boo_s
babyhood	19	5	310	3	babyhood_
backwood	20	4	697	3	backwood_
backwoodsy	25	5	216	3	backwoodsy
bagworms	16	4	521	3	bagworms
balloons	10	31	1052	3	balloons
bamboos	13	4	875	3	bamboo_s
barrooms	12	3	789	3	barrooms
bassoons	10	3	655	3	bassoons
basswood	14	9	455	3	basswood_
bawds	11	61	1549	3	ba_w__ds
bayamos	14	3	466	3	bayamo_s
bayards	13	37	968	3	bay_ards
bayous	11	4	1115	3	bay__ous
bazooms	20	28	538	3	ba_zooms
bazoos	17	32	1262	3	ba_zoo_s
bearwood	14	4	540	3	bearwood_
bebloods	13	11	523	3	bebloods
beefwoods	18	4	317	3	beefwoods
bentwoods	15	4	399	3	bentwoods
beyonds	13	3	506	3	bey_onds
blackwoods	22	4	389	3	blackwoods
bloods	9	46	1484	3	b__loods
bluewoods	15	4	380	3	bluewoods
bogwood	14	4	641	3	bogwood_
boxwood	20	4	524	3	boxwood_
boyhood	16	4	649	3	boyhood_
briarwoods	16	5	283	3	briarwoods
broods	9	54	1638	3	b__roods
byroads	13	3	529	3	b_yroads
byword	15	3	505	3	b_yword_
byworks	19	4	454	3	b_yworks
dagwood	13	4	483	3	dagwood_
daybooks	18	4	398	3	daybooks
dayrooms	14	4	434	3	dayrooms
dayworks	19	4	556	3	dayworks
deadwoods	15	4	431	3	deadwoods
dogwoods	14	5	448	3	dogwoods
dyewoods	16	4	350	3	dyewoods
earlywoods	17	5	220	3	earlywoods
fatwood	14	8	639	3	fatwood_
gumwoods	15	12	392	3	gumwoods
hardwoods	17	13	551	3	hardwoods
haywards	18	4	587	3	haywards
inkwoods	16	7	408	3	inkwoods
keywords	19	4	432	3	keywords
lacewoods	15	5	489	3	lacewoods
ladhoods	13	4	587	3	ladhoods
ladyhoods	17	4	294	3	ladyhoods
latewoods	13	5	520	3	latewoods
logwoods	13	4	476	3	logwoods
manhoods	14	4	724	3	manhoods
mayweeds	17	4	299	3	mayweeds
nutwoods	12	4	426	3	nutwoods
payloads	14	4	529	3	payloads
pearwoods	15	4	454	3	pearwoods
plywood	16	4	513	3	plywood_
redwoods	13	4	577	3	redwoods
sapwood	13	6	691	3	sapwood_
sasswoods	13	11	404	3	sasswoods
sassywoods	17	7	186	3	sassywoods
teakwoods	17	4	379	3	teakwoods
woods	9	57	2303	3	___woods

Search took 7 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.406	440125.6
2	DLD Change Limit	146162	80	6.296	23215.1
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	6.732	26543.5