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

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

50 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
protracted	15	4	576	(None)
prorated	11	5	1371	2	pro_ra_ted
prostrated	13	4	942	2	prostra_ted
protected	14	15	865	2	prot_ected
protract	12	5	1060	2	protract__
protractor	14	4	626	2	protractor
protracts	13	4	702	2	protract_s
retracted	12	4	1095	2	_retracted
abstracted	15	4	484	3	abstracted
attracted	12	4	607	3	_attracted
contracted	15	4	982	3	contracted
detracted	13	5	779	3	_detracted
distracted	14	4	887	3	distracted
extracted	19	4	672	3	_extracted
perorated	12	4	1247	3	pero_ra_ted
portrayed	15	6	411	3	portra_yed
preacted	13	27	1094	3	pr__eacted
preenacted	15	4	497	3	preenacted
preerected	15	4	557	3	preerected
pretasted	12	14	796	3	pret_asted
pretrained	13	5	706	3	pretrained
pretreated	13	4	763	3	pretreated
probated	13	4	1086	3	pro_ba_ted
procreated	15	4	644	3	procreated
programed	15	8	589	3	progra_med
programmed	18	8	388	3	programmed
projected	21	16	582	3	pro_jected
pronated	11	4	1405	3	pro_na_ted
prorate	9	4	1873	3	pro_ra_te_
prorates	10	4	1807	3	pro_ra_tes
prosected	14	15	863	3	pro_sected
prospected	17	4	487	3	prospected
prostrate	11	4	1248	3	prostra_te_
prostrates	12	4	1199	3	prostra_tes
protecter	13	17	910	3	prot_ecter
protested	12	15	911	3	prot_ested
protonated	13	4	859	3	protonated
protractile	15	5	410	3	protractile
protracting	16	4	693	3	protracting
protraction	15	4	721	3	protraction
protractive	18	5	563	3	protractive
protractors	15	4	662	3	protractors
protrade	11	4	821	3	protra_de_
protruded	13	4	344	3	protr_uded
refracted	15	5	739	3	_refracted
retraced	11	14	1303	3	_retrac_ed
retracked	16	5	745	3	_retracked
retroacted	13	6	614	3	_retroacted
rotated	8	27	1529	3	_rot_a_ted
subtracted	15	6	500	3	subtracted

Search took 9 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	140603	0.420	425454.8
2	DLD Change Limit	140603	50	7.563	18590.9
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	7.999	22339.2