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

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

94 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
sideway	14	4	567	(None)
sideways	15	4	523	1	sideways
slideway	15	4	316	1	slideway
tideway	14	4	515	1	tideway
bikeway	19	4	431	2	bikeway
guideway	16	4	243	2	guideway
hideaway	18	4	271	2	hideaway
lifeway	16	4	427	2	lifeway
midway	15	32	715	2	mid_way
sidebar	10	4	556	2	sidebar
sidecar	10	4	523	2	sidecar
sideman	10	3	797	2	sideman
sidewalk	16	4	409	2	sidewalk
sidewall	12	4	480	2	sidewall
sideward	13	4	595	2	sideward
sinewy	12	66	751	2	sinew_y
skidway	18	4	308	2	skid_way
slideways	16	4	285	2	slideways
someway	15	4	561	2	someway
tideways	15	4	456	2	tideways
wireway	16	4	604	2	wireway
airway	12	3	769	3	ai_rway
aisleway	14	4	252	3	aisleway
bikeways	20	4	365	3	bikeways
decay	11	47	1848	3	__decay
delay	9	48	2063	3	__delay
deray	9	50	2418	3	__deray
dewan	9	57	1804	3	__dewan
dewar	9	58	1773	3	__dewar
dewax	16	55	1085	3	__dewax
dewy	11	54	1902	3	__dew_y
driveway	18	4	199	3	driveway
fadeaway	18	4	265	3	fadeaway
fishway	19	4	381	3	fishway
freeway	16	3	560	3	freeway
gateway	14	3	493	3	gateway
giveaway	18	4	190	3	giveaway
guideways	17	4	230	3	guideways
hideaways	19	4	246	3	hideaways
highway	20	4	426	3	highway
idea	5	91	2277	3	_ide_a_
ideal	6	57	1639	3	_ide_al
ideas	6	59	1901	3	_ide_as
laneway	13	4	527	3	laneway
leeway	12	5	588	3	_leeway
lifeways	17	4	389	3	lifeways
midday	13	32	750	3	mid_day
midways	16	38	618	3	mid_ways
mildewy	16	35	353	3	mildew_y
oilway	12	3	574	3	oi_lway
raceway	15	4	613	3	raceway
ropeway	15	4	477	3	ropeway
screwy	14	65	946	3	screw_y
seaway	12	30	999	3	s_eaway
sewan	8	59	2129	3	s__ewan
sewar	8	54	2110	3	s__ewar
shipway	18	4	421	3	shipway
sickbay	18	4	372	3	sickbay
side	5	54	4448	3	side___
sidearm	10	3	597	3	sidearm
sideband	12	4	502	3	sideband
sidebars	11	4	664	3	sidebars
sidecars	11	4	590	3	sidecars
sided	7	48	2595	3	side__d
sidemen	10	3	794	3	sidemen
sidereal	9	4	605	3	sidereal
sides	6	58	3836	3	side__s
sidewalks	17	4	353	3	sidewalks
sidewalls	13	4	428	3	sidewalls
sidewards	14	4	505	3	sidewards
sidewise	12	4	535	3	sidewise
sinew	8	47	1892	3	sinew__
sinewed	11	3	705	3	sinewed
sinews	9	42	1062	3	sinew_s
skidways	19	4	282	3	skid_ways
skyway	19	3	334	3	s_kyway
slipway	15	4	387	3	slipway
sluiceway	17	5	115	3	sluiceway
snidely	11	3	681	3	snide_ly
someday	13	4	588	3	someday
someways	16	4	482	3	someways
speedway	17	4	331	3	speedway
spidery	13	30	820	3	spide_ry
spillway	16	4	276	3	spillway
stewy	11	61	1206	3	s_tew_y
subway	14	4	707	3	s_ubway
sway	10	71	2823	3	s___way
underway	15	13	634	3	underway
viewy	14	51	810	3	vi_ew_y
virelay	13	3	594	3	virelay
widely	13	33	1103	3	wide_ly
widthway	21	4	194	3	widthway
windway	17	4	515	3	windway
wireways	17	4	583	3	wireways

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.483	369960.7
2	DLD Change Limit	134027	94	7.296	18369.9
3	Display Results	94	94	0.046	2043.5
	(SQL Overall)	178691	94	7.825	22835.9