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

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

73 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
magnetising	15	5	373	(None)
magnetizing	24	5	440	1	magnetizing
monetising	13	4	621	2	m_onetising
appetising	15	4	451	3	_appetising
demagnetizing	27	9	208	3	demagnetizing
magnetise	12	51	1040	3	magnetis__e
magnetised	14	50	670	3	magnetis_ed
magnetises	13	67	1009	3	magnetis_es
magnetism	14	56	729	3	magnetis__m
magnetisms	15	57	669	3	magnetis_ms
monetizing	22	4	730	3	m_onetizing
palletising	14	5	357	3	palletising
sanitising	11	11	657	3	sa_nitising
advertising	16	14	361	4	_advertising
agatizing	20	8	747	4	_ag_atizing
agenizing	20	4	633	4	_ag_enizing
agenting	10	3	938	4	_agent__ing
agnizing	19	3	683	4	_agn__izing
agonising	11	4	657	4	_ag_onising
amortising	13	4	597	4	_amortising
antiking	13	4	1207	4	_a_n_tiking
appetizing	24	4	540	4	_appetizing
azotising	19	4	529	4	_a_zotising
baptising	14	4	609	4	ba__ptising
canalising	13	4	936	4	ca_nalising
canonising	13	4	658	4	ca_nonising
cartelising	14	4	479	4	cartelising
cognising	13	4	704	4	cogn__ising
harnessing	14	4	390	4	harne_ssing
maderizing	23	4	646	4	ma_derizing
magnesia	11	4	572	4	magne__si_a
magnesian	12	4	471	4	magne__sian
magnesias	12	4	569	4	magne__sias
magnesic	13	4	575	4	magne__si_c
magnesite	12	96	931	4	magne__site
magnesium	14	5	373	4	magne__sium
magnetic	13	4	923	4	magnet__i_c
magnetics	14	4	716	4	magnet__ics
magnetite	12	73	1121	4	magnet__ite
magnetites	13	89	1090	4	magneti_tes
magnetize	21	51	987	4	magnet__ize
magnetized	23	45	768	4	magneti_zed
magnetizer	22	47	705	4	magneti_zer
magnetizers	23	54	492	4	magnetizers
magnetizes	22	79	1007	4	magneti_zes
magneton	11	4	494	4	magnet__on_
magnetons	12	4	454	4	magnet__ons
magnetos	11	4	626	4	magnetos___
magnetron	12	4	327	4	magnet_ron_
magnetrons	13	4	307	4	magnet_rons
magnets	10	3	1114	4	magnet_s___
magnifying	20	4	403	4	magn_ifying
mainlining	13	4	387	4	main_lining
maintaining	14	5	359	4	maintaining
mantling	11	20	1261	4	ma_n_t_ling
marbelizing	25	4	470	4	marbelizing
marbleising	16	5	255	4	marbleising
margenting	14	4	615	4	margent__ing
marketing	16	3	651	4	market__ing
maximising	22	9	346	4	ma_ximising
mercerising	16	5	383	4	mercerising
mesmerising	16	4	393	4	mesmerising
minimising	15	4	493	4	m_inimising
mortising	12	3	869	4	m__ortising
paganising	14	4	595	4	pag_anising
palletizing	23	4	491	4	palletizing
pelletising	14	5	339	4	pelletising
poetising	12	3	871	4	__poetising
sanitizing	20	10	795	4	sa_nitizing
signalising	13	4	416	4	signalising
signeting	11	3	622	4	signet__ing
sonnetizing	21	5	436	4	sonnetizing
vignetting	15	4	282	4	vignet_ting

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	148819	0.420	425454.8
2	DLD Change Limit	148819	73	8.220	18104.5
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	8.686	20572.3