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

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

86 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
tideway	14	4	515	(None)
sideway	14	4	567	1	sideway
tideways	15	4	456	1	tideways
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
sideways	15	4	523	2	sideways
slideway	15	4	316	2	slideway
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
sidebar	10	4	556	3	sidebar
sidecar	10	4	523	3	sidecar
sideman	10	3	797	3	sideman
sidewalk	16	4	409	3	sidewalk
sidewall	12	4	480	3	sidewall
sideward	13	4	594	3	sideward
sinewy	12	66	751	3	sinew_y
skidway	18	4	308	3	skid_way
slideways	16	4	285	3	slideways
someway	15	4	561	3	someway
takeaway	18	4	305	3	takeaway
taxiway	20	4	346	3	taxiway
thewy	14	63	1185	3	t_hew_y
thisaway	17	4	275	3	thisaway
thruway	16	4	316	3	thruway
tidal	6	45	1644	3	tid__al
tidally	11	3	793	3	tidally
tiddly	11	30	878	3	tid_dly
tide	5	52	3737	3	tide___
tided	7	63	2251	3	tide__d
tideland	10	4	463	3	tideland
tidemark	15	4	340	3	tidemark
tiderip	10	4	551	3	tiderip
tides	6	48	3015	3	tide__s
tidewater	13	4	412	3	tidewater
tidily	10	28	1139	3	tid_ily
tidy	8	68	2241	3	tid___y
timely	11	34	1011	3	time_ly
tindery	11	38	936	3	tinde_ry
tinea	5	49	2316	3	tine_a_
tineal	6	62	1616	3	tine_al
tineas	6	46	1648	3	tine_as
tiredly	11	3	679	3	tiredly
today	9	64	1695	3	tod__ay
tollway	13	4	479	3	tollway
towaway	16	4	415	3	towaway
tramway	15	4	486	3	tramway
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 9 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.143	1249587.4
2	DLD Change Limit	134027	86	7.966	16824.9
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	8.142	21946.8