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

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

45 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
patterns	10	43	994	(None)
pasterns	10	41	1262	1	pasterns
pattens	9	54	1492	1	patte_ns
pattern	9	37	1205	1	pattern_
patters	9	48	2519	1	patter_s
attorns	7	3	844	2	_attorns
battens	9	53	1326	2	batte_ns
batters	9	46	2601	2	batter_s
bitterns	10	42	895	2	bitterns
citterns	10	31	812	2	citterns
fattens	10	51	1171	2	fatte_ns
gitterns	9	32	657	2	gitterns
hatters	10	42	2152	2	hatter_s
lanterns	8	3	830	2	lanterns
lattens	7	50	1467	2	latte_ns
matters	9	44	2175	2	matter_s
natters	7	37	1806	2	natter_s
palters	9	40	2168	2	palter_s
pastern	9	44	1506	2	pastern_
pasters	9	45	3173	2	paster_s
patens	8	48	2086	2	pa_te_ns
paters	8	49	3583	2	pa_ter_s
patten	8	44	1819	2	patte_n_
patter	8	46	2826	2	patter__
pattered	11	27	1420	2	pattered
patterer	10	31	1217	2	patterer
patterers	11	24	1012	2	patterers
pattering	12	23	1442	2	pattering
patterned	12	6	574	2	patterned
patzers	18	42	1057	2	patzer_s
petters	9	37	2236	2	petter_s
platters	10	34	1528	2	platter_s
posterns	10	27	1372	2	posterns
potteens	10	25	679	2	potteens
potters	9	40	2434	2	potter_s
putters	9	42	1919	2	putter_s
ratteens	8	25	605	2	ratteens
rattens	7	42	1340	2	ratte_ns
ratters	7	44	2247	2	ratter_s
repatterns	12	4	249	2	repatterns
salterns	8	38	890	2	salterns
slatterns	9	3	536	2	slatterns
spatters	10	39	1470	2	spatter_s
tatters	7	45	2048	2	tatter_s
yatters	10	39	1462	2	yatter_s

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.373	479064.3
2	DLD Change Limit	121059	45	3.656	33112.4
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	4.045	44175.8