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

Here are the results of your fuzzy-string dictionary search for “nabobs” with Change Limit: [1] [2] [3]

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.

27 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
nabobs	10	38	821	(None)
cabobs	12	43	1189	1	cabobs
kabobs	14	43	930	1	kabobs
nabob	9	39	1374	1	nabob_
abos	6	77	3441	2	_abo_s
baboos	10	35	1701	2	baboos
bobs	8	63	4065	2	__bobs
cabob	11	46	1681	2	cabob_
carobs	10	48	1810	2	carobs
haboobs	14	9	546	2	haboobs
jabots	15	3	888	2	jabots
kababs	14	40	977	2	kababs
kabob	13	41	1393	2	kabob_
kebobs	14	42	729	2	kebobs
labors	8	40	1641	2	labors
nabes	7	54	2709	2	nab_es
nabis	7	60	2058	2	nab_is
nabobess	12	4	220	2	nabobess
nabobish	15	4	410	2	nabobish
nabobism	14	4	411	2	nabobism
nabs	6	62	3619	2	na__bs
naos	4	74	2973	2	na_o_s
nawabs	11	8	506	2	nawabs
nobs	6	64	3690	2	n__obs
sabots	8	3	1470	2	sabots
taboos	8	38	1543	2	taboos
tabors	8	45	1711	2	tabors

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	82551	0.406	440125.6
2	DLD Change Limit	82551	27	5.906	13977.5
3	Display Results	27	27	0.016	1687.5
	(SQL Overall)	178691	27	6.328	28238.1