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

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

32 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
railroads	10	4	352	(None)
railroad	9	4	380	1	railroad_
railheads	13	4	397	2	railheads
railroaded	12	5	195	2	railroaded
railroader	11	5	233	2	railroader
railroaders	12	5	196	2	railroaders
armloads	11	4	423	3	arml_oads
carloads	11	3	839	3	carl_oads
fairleads	13	4	302	3	fairleads
inroads	8	3	704	3	__inroads
kilorads	13	4	442	3	_kilorads
mailrooms	13	4	376	3	mailrooms
nailfolds	13	4	184	3	nailfolds
nailheads	13	4	365	3	nailheads
payloads	14	4	529	3	payl_oads
railbirds	12	4	321	3	railbirds
railcars	10	4	531	3	rail_cars
railhead	12	4	418	3	railhead_
railroading	13	5	237	3	railroading
railroadings	14	5	146	3	railroad~~ing~~s
railways	14	4	460	3	rail_ways
raincoats	11	4	406	3	raincoats
ramrods	10	3	658	3	ra_mro_ds
reloads	8	9	1131	3	r_el_oads
sailboards	13	4	548	3	sailboards
sailboats	11	4	524	3	sailboats
tailboards	13	4	508	3	tailboards
tailcoats	11	4	401	3	tailcoats
trailheads	14	4	306	3	trailheads
trainloads	11	5	238	3	trainloads
tramroads	12	4	300	3	tra_mroads
vanloads	12	6	416	3	vanl_oads

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	148641	0.423	422437.4
2	DLD Change Limit	148641	32	6.516	22811.7
3	Display Results	32	32	0.016	2000.0
	(SQL Overall)	178691	32	6.955	25692.5