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

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

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.

64 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
characterized	30	6	237	(None)
characterize	28	6	325	1	characterize_
characterizes	29	6	285	1	characterizes
charactered	19	5	287	2	character__ed
characteries	19	7	496	2	characteri_es
charactering	20	5	371	3	characteri_ng
characterizing	31	6	170	3	characterizing
bacterized	24	4	628	4	___bacterized
caramelized	25	7	332	4	c_ara_melized
cartelized	22	4	617	4	c_ar__telized
catheterized	27	5	250	4	c_atheterized
cauterized	22	8	631	4	c___auterized
character	16	4	588	4	character____
characterful	22	6	147	4	character_ful
characteristic	20	7	177	4	characteristic
characterless	20	6	142	4	characterless
characters	17	4	550	4	character___s
charactery	20	4	342	4	character___y
charcuterie	18	8	288	4	charcuteri_e_
charcuteries	19	9	315	4	charcuteri_es
chartered	15	15	839	4	char__ter__ed
mischaracterize	33	8	79	4	~~mis~~characterize_
parameterized	27	12	251	4	_parameterized
parametrized	26	10	348	4	_parametrized
bacterize	22	4	765	5	___bacterize_
bacterizes	23	4	796	5	___bacterizes
caramelised	16	7	309	5	c_ara_melised
caramelize	23	6	411	5	c_ara_melize_
caramelizes	24	9	412	5	c_ara_melizes
carburized	24	4	425	5	c_ar__burized
cartelised	13	4	491	5	c_ar__telised
cartelize	20	4	810	5	c_ar__telize_
cartelizes	21	4	763	5	c_ar__telizes
catheterize	25	6	283	5	c_atheterize_
catheterizes	26	6	276	5	c_atheterizes
cauterize	20	8	831	5	c___auterize_
cauterizes	21	9	799	5	c___auterizes
chanceries	17	4	765	5	cha_nc_eri_es
channelized	26	5	260	5	ch__annelized
chaptered	17	17	679	5	ch__apter__ed
characid	16	4	686	5	charac___i__d
characteristics	21	7	112	5	characteristics
charivaried	20	5	185	5	char_ivari_ed
charterer	14	19	732	5	char__ter__er
chartering	16	10	925	5	char__teri_ng
chattered	15	19	799	5	ch__atter__ed
cicatrized	24	5	317	5	c_ica_t_rized
computerized	28	22	370	5	c_omputerized
containerized	25	6	211	5	containerized
cratered	11	4	968	5	c__ra_ter__ed
curarized	21	7	640	5	c_ura___rized
factorized	25	9	555	5	___factorized
fraternized	24	9	301	5	__fra_ternized
laterized	19	7	990	5	___la_terized
martyrized	25	4	353	5	_mar__tyrized
mercerized	24	4	457	5	_mer_c_erized
parameterize	25	12	328	5	_parameterize_
parameterizes	26	15	301	5	_parameterizes
parametrize	24	7	429	5	_parametrize_
parametrizes	25	10	456	5	_parametrizes
phylacteries	22	7	333	5	phylacteri_es
racemized	23	4	436	5	___rac_emized
strategized	22	5	260	5	_stra_tegized
traceried	12	4	714	5	__trac_eri_ed

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	124790	0.390	458182.1
2	DLD Change Limit	124790	64	9.326	13380.9
3	Display Results	64	64	0.046	1391.3
	(SQL Overall)	178691	64	9.762	18304.8