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

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

19 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
handlebar	15	4	235	(None)
handlebars	16	4	237	1	handlebars
handler	11	35	1616	2	handle__r
candler	10	35	1659	3	candle__r
chandler	14	35	837	3	chandle__r
dandler	9	44	1427	3	dandle__r
handbag	14	9	586	3	hand__bag
handcar	13	3	737	3	hand__car
hander	10	45	2643	3	hand_e__r
handier	11	38	1744	3	handie__r
handle	10	42	1929	3	handle___
handleable	16	4	374	3	handleable
handled	12	41	1453	3	handle__d
handlers	12	40	1414	3	handle_rs
handles	11	40	2065	3	handle__s
handless	12	35	1206	3	handle_ss
landler	8	41	1320	3	landle__r
saddlebag	14	5	175	3	saddlebag
sandbar	10	10	819	3	sand__bar

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	19	7.360	20195.8
3	Display Results	19	19	0.016	1187.5
	(SQL Overall)	178691	19	7.532	23724.2