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

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

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.

56 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
taffetized	26	5	169	(None)
magnetized	23	45	768	3	magnetized
palletized	22	4	545	3	palletized
safetied	12	4	466	3	sa_feti_ed
advertized	24	4	379	4	_advertized
affected	17	4	479	4	_affe_cted
affectioned	20	5	245	4	_affectioned
affective	20	13	541	4	_affective_
affined	14	3	641	4	_aff__ined
affixed	21	3	412	4	_aff__ixed
agatized	19	4	707	4	_a_gatized
agenized	19	25	773	4	_a_genized
amortized	21	8	593	4	_amortized
appetizer	22	4	443	4	_appetizer
azotized	17	4	567	4	_a_zotized
bacterized	24	4	628	4	bacterized
baptized	22	4	548	4	ba__ptized
buffeted	17	5	373	4	buffet__ed
caffeine	16	4	451	4	caffe_ine_
caffeines	17	4	391	4	caffe_ines
cartelized	22	4	617	4	cartelized
cauterized	22	8	631	4	cauterized
graffitied	18	5	190	4	graffiti_ed
laterized	19	7	990	4	la_terized
maderized	22	4	702	4	ma_derized
magnetised	14	50	670	4	magnetised
magnetize	21	51	987	4	magnetize_
magnetizer	22	47	705	4	magnetizer
magnetizes	22	79	1007	4	magnetizes
marbelized	24	5	461	4	marbelized
monetized	21	4	715	4	_monetized
narcotized	22	8	390	4	narcotized
palletised	13	4	451	4	palletised
palletize	20	12	717	4	palletize_
palletizer	21	8	436	4	palletizer
palletizes	21	7	644	4	palletizes
panelized	21	4	703	4	pa_nelized
pauperized	24	4	375	4	pauperized
pelletized	22	4	499	4	pelletized
poetized	20	3	798	4	__poetized
racemized	23	4	436	4	ra_cemized
safeties	11	3	916	4	sa_feti_es
sanitized	19	13	817	4	sa_nitized
sonnetized	20	4	447	4	sonnetized
sovietized	23	4	303	4	sovietized
tableted	11	3	753	4	tablet__ed
tabletted	12	4	483	4	tablet_ted
tafferel	14	4	312	4	taffe__rel
taffeta	13	4	326	4	taffet___a
taffetas	14	4	272	4	taffet__as
taffies	13	30	1269	4	taff__i_es
tantalized	20	11	892	4	tantalized
targeted	10	3	748	4	target__ed
tenderized	21	7	515	4	tenderized
tiffined	15	4	340	4	tiff__ined
traumatized	23	5	425	4	traumatized

Search took 10 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	161450	0.440	406115.9
2	DLD Change Limit	161450	56	9.263	17429.6
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	9.736	18353.6