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

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

77 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
ropeway	15	4	477	(None)
ropeways	16	4	405	1	ropeways
raceway	15	4	613	2	raceway
roadway	14	6	461	2	roadway
rollway	13	4	465	2	rollway
ropery	11	43	1387	2	rope_ry
ropewalk	17	4	323	2	ropewalk
ropey	10	60	2187	2	rope__y
rosebay	12	13	577	2	rosebay
routeway	14	4	341	2	routeway
someway	15	4	561	2	someway
bikeway	19	4	431	3	bikeway
cogway	15	6	618	3	co_gway
copay	12	65	1631	3	cop__ay
crossway	16	4	385	3	crossway
doorway	14	4	424	3	doorway
dopey	11	60	2035	3	dope__y
driveway	18	4	199	3	driveway
folkway	20	4	335	3	folkway
footway	16	3	525	3	footway
forebay	15	3	813	3	forebay
freeway	16	3	560	3	freeway
gateway	14	3	493	3	gateway
laneway	13	4	527	3	laneway
leeway	12	5	588	3	_leeway
lifeway	16	4	427	3	lifeway
logway	13	3	591	3	lo_gway
mopery	13	52	1097	3	mope_ry
mopey	12	48	2182	3	mope__y
nosegay	11	4	384	3	nosegay
noway	11	11	1284	3	no__way
oilway	12	3	574	3	_oilway
openly	11	3	712	3	_openly
opera	7	3	1357	3	_opera_
operas	8	3	1245	3	_operas
popery	13	45	1170	3	pope_ry
properly	15	4	646	3	properly
property	15	4	707	3	property
raceways	16	4	523	3	raceways
railway	13	4	531	3	railway
relay	8	44	2467	3	r__elay
renewal	10	3	871	3	renewal
repay	10	48	1845	3	r__epay
repeal	8	47	1829	3	repe_al
repeat	8	51	2721	3	repe_at
replay	11	34	1292	3	rep_lay
resay	8	53	2054	3	r__esay
rewan	8	56	2366	3	r__ewan
rewax	15	57	1392	3	r__ewax
ripely	11	25	1115	3	ripe_ly
roadways	15	6	461	3	roadways
rockaway	20	4	234	3	rockaway
rollaway	14	4	326	3	rollaway
rollways	14	4	423	3	rollways
rope	6	55	4291	3	rope___
roped	8	46	3081	3	rope__d
roper	7	54	3191	3	rope__r
ropers	8	43	2590	3	rope_rs
ropes	7	59	4006	3	rope__s
ropewalks	18	4	242	3	ropewalks
ropily	11	33	1244	3	rop_ily
ropy	9	63	2341	3	rop___y
rosebays	13	11	491	3	rosebays
rosemary	13	4	443	3	rosemary
rosery	9	38	1328	3	rose_ry
routeways	15	4	315	3	routeways
rowan	8	54	1873	3	ro__wan
rowdy	12	57	1153	3	ro__wdy
runaway	13	4	368	3	runaway
runway	12	10	597	3	r_unway
sideway	14	4	567	3	sideway
someday	13	4	588	3	someday
someways	16	4	483	3	someways
tideway	14	4	515	3	tideway
tollway	13	4	479	3	tollway
towaway	16	4	415	3	towaway
wireway	16	4	604	3	wireway

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.500	357382.0
2	DLD Change Limit	134027	77	6.826	19634.8
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	7.359	24282.0