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

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

87 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
deodorizers	22	5	279	(None)
deodorizer	21	4	418	1	deodorizer_
deodorizes	21	4	536	1	deodorize_s
decolorizers	24	5	312	2	decolorizers
deodorize	20	4	527	2	deodorize__
deodorized	22	4	489	2	deodorize_d
colorizers	21	26	760	3	_colorizers
decolorizer	23	5	459	3	decolorizer_
decolorizes	23	4	588	3	decolorize_s
deionizers	20	5	397	3	de_ionizers
dendrimers	14	4	274	3	dend_rimers
deodorizing	23	4	511	3	deodorizing
deoxidizers	29	5	183	3	deoxidizers
depolarizers	24	5	320	3	depolarizers
memorizers	23	12	500	3	me_morizers
odorizes	18	3	721	3	__odorize_s
temporizers	24	4	373	3	temporizers
tenderizers	21	8	341	3	tenderizers
aphorizers	24	4	358	4	_aphorizers
apologizers	23	4	282	4	apologizers
authorizers	23	5	302	4	authorizers
codrivers	15	4	486	4	_cod_rivers
colonizers	21	28	672	4	_colonizers
colorizer	20	24	1062	4	_colorizer_
colorizes	20	30	1452	4	_colorize_s
decolonizes	23	4	553	4	decolonize_s
decolorize	22	5	606	4	decolorize__
decolorized	24	4	525	4	decolorize_d
decriers	11	29	973	4	de__cri_ers
deforcers	15	26	550	4	de_for_cers
deformers	15	26	653	4	de_for_mers
dehorners	13	4	474	4	de_hor_ners
deionizer	19	4	580	4	de_ionizer_
deionizes	19	5	821	4	de_ionize_s
demonizes	21	3	1106	4	de_monize_s
demoralizers	24	9	432	4	demoralizers
dendrimer	13	4	336	4	dend_rimer_
dendrites	11	4	793	4	dend_rite_s
deodorants	12	5	293	4	deodor_ants
deoxidizer	28	5	262	4	deoxidizer_
deoxidizes	28	4	334	4	deoxidize_s
deplorers	12	4	546	4	deplor__ers
depolarizer	23	5	480	4	depolarizer_
depolarizes	23	4	638	4	depolarize_s
deporters	12	7	779	4	de_por_ters
deprivers	15	4	521	4	de__privers
deriders	10	24	1185	4	de___riders
derivers	12	38	1136	4	de___rivers
describers	15	4	358	4	de_scribers
descriers	12	4	569	4	de_scri_ers
despoilers	13	4	353	4	despo_ilers
destriers	10	3	814	4	de_stri_ers
dewormers	15	25	519	4	de_wor_mers
doozers	17	41	929	4	d_o_o__zers
economizers	24	5	264	4	economizers
endorsers	10	4	612	4	_endor_sers
etherizers	22	4	410	4	_etherizers
eulogizers	20	4	281	4	_eulogizers
feodaries	13	4	637	4	feodari_e_s
genderizes	21	7	601	4	genderize_s
geologizes	21	4	679	4	geologize_s
glamorizers	23	10	271	4	glamorizers
ideologizes	22	4	419	4	ideologize_s
idolizers	19	4	414	4	__idolizers
iodizers	18	31	612	4	_iod__izers
melodizers	22	4	338	4	me_lodizers
memorizer	22	13	764	4	me_morizer_
memorizes	22	13	1082	4	me_morize_s
mesmerizers	24	5	265	4	mesmerizers
modernizers	23	5	238	4	_modernizers
motorizes	20	4	1078	4	_motorize_s
neologizes	20	4	724	4	neologize_s
odorize	17	3	740	4	__odorize__
odorized	19	4	584	4	__odorize_d
ozonizers	17	5	323	4	__ozonizers
polarizers	21	6	589	4	_polarizers
randomizers	23	5	235	4	randomizers
sermonizers	22	15	404	4	sermonizers
sodomizes	21	12	566	4	_sodomize_s
temporizer	23	4	523	4	temporizer_
temporizes	23	4	693	4	temporize_s
tenderizer	20	7	458	4	tenderizer_
tenderizes	20	7	668	4	tenderize_s
terrorizes	19	8	706	4	terrorize_s
theologizers	25	10	279	4	theologizers
theorizers	22	4	333	4	_theorizers
vaporizers	24	24	411	4	_vaporizers

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	148819	0.420	425454.8
2	DLD Change Limit	148819	87	8.906	16710.0
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	9.372	19066.5