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

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

23 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
padrones	11	27	1104	(None)
ladrones	9	27	1097	1	ladrones
madrones	11	29	1228	1	madrones
padrone	10	25	1207	1	padrone_
drones	7	50	2343	2	__drones
hadrons	11	33	1430	2	hadron_s
ladrone	8	36	1187	2	ladrone_
ladrons	8	38	1319	2	ladron_s
madronas	11	28	849	2	madronas
madrone	10	28	1266	2	madrone_
madronos	11	33	754	2	madronos
padres	9	50	1698	2	padr__es
padroni	10	27	861	2	padron_i
padronism	14	4	549	2	padronism
pardoned	12	18	933	2	pardoned
pardoner	11	18	944	2	pardoner
pardoners	12	20	821	2	pardoners
pardons	10	38	1762	2	pardon_s
paroles	9	50	2588	2	pa_roles
patroness	11	3	748	2	patroness
patrons	9	38	1810	2	patron_s
pyrones	12	31	1330	2	p_yrones
spadones	11	3	725	2	spad_ones

Search took 5 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	121059	0.393	454684.5
2	DLD Change Limit	121059	23	3.670	32986.1
3	Display Results	23	23	0.000
	(SQL Overall)	178691	23	4.063	43980.1