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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

192 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
magnesites	13	189	832	(None)
magnesite	12	96	928	1	magnesite_
magnetites	13	89	1086	1	magnetites
magnesias	12	4	566	2	magnesi_as
magnesiums	15	6	259	2	magnesiums
magnetises	13	67	1006	2	magnetises
magnetite	12	73	1117	2	magnetite_
magnetizes	22	79	1003	2	magnetizes
amnesties	11	6	685	3	_amnesties
andesites	10	4	852	3	_andesites
anglesites	11	4	479	3	anglesites
madnesses	12	3	983	3	madnes_ses
magnates	11	5	1158	3	magn__ates
magnesia	11	4	571	3	magnesi__a
magnesian	12	4	470	3	magnesi_an
magnesic	13	4	574	3	magnesi__c
magnesium	14	5	372	3	magnesi_um
magnetics	14	4	714	3	magneti_cs
magnetise	12	51	1036	3	magnetise_
magnetised	14	50	669	3	magnetised
magnetisms	15	57	668	3	magnetisms
magnetize	21	51	982	3	magnetize_
magnetized	23	45	765	3	magnetized
magnetizer	22	47	703	3	magnetizer
magnetizers	23	54	490	3	magnetizers
magnetos	11	4	625	3	magne__tos
magnets	10	3	1112	3	magne__t_s
magnifies	15	4	727	3	magnifi_es
majesties	18	4	534	3	ma_jesties
manganites	13	4	698	3	manganites
mannites	10	3	1257	3	ma_n_nites
marcasites	14	4	556	3	marcasites
marguerites	14	5	371	3	marguerites
martensites	13	5	358	3	martensites
abnegates	12	4	493	4	_abnegates
adamsites	12	4	351	4	_adamsites
adhesives	16	4	309	4	_adhesives
ageists	8	4	848	4	_ag_eist_s
agemates	11	11	1000	4	_ag_emates
agencies	11	3	869	4	_agenci_es
ageneses	9	3	929	4	_agenes__es
agenesias	10	4	535	4	_agenesi_as
agenesis	9	3	803	4	_agenesi__s
agenizes	18	26	972	4	_ag_enizes
agentives	13	4	640	4	_agentives
agnates	8	28	1318	4	_agn__ates
agnizes	17	32	882	4	_agn__izes
agnosias	9	4	721	4	_agnosi_as
agnostics	12	4	445	4	_agnostics
agonistes	10	26	626	4	_agonis_tes
amnesiacs	13	5	324	4	_amnesiacs
amnesias	10	4	780	4	_amnesi_as
amnesics	12	5	527	4	_amnesi_cs
amnestied	12	6	361	4	_amnestied
amosites	10	3	1122	4	_a_mosites
andesite	9	4	943	4	_andesite_
andesytes	13	4	358	4	_andesytes
anglesite	10	4	574	4	anglesite_
ankerites	13	4	848	4	_ankerites
appetites	13	4	747	4	_appetites
arenites	8	9	1704	4	_a_renites
argentites	11	4	697	4	argentites
arsenites	9	14	911	4	_arsenites
badnesses	12	3	923	4	badnes_ses
baguettes	12	11	538	4	bague_ttes
bakelites	15	4	599	4	ba_kelites
banksides	16	10	482	4	ba_nksides
bignesses	12	6	793	4	bignes_ses
caginesses	13	3	1092	4	cagines_ses
campsites	15	4	647	4	ca_mpsites
canneries	11	3	1306	4	canneri_es
carnotites	12	4	651	4	carnotites
coesites	10	13	1309	4	__coesites
demagnetizes	25	5	298	4	demagnetizes
earnests	8	3	784	4	earnes_t_s
farnesses	12	23	1079	4	farnes_ses
fatnesses	12	17	1046	4	fatnes_ses
gahnites	12	3	568	4	gahn__ites
galenites	10	12	913	4	ga_lenites
garnierites	12	5	272	4	garnierites
gaynesses	13	3	656	4	gaynes_ses
gestes	7	57	2138	4	__g_es_tes
gneisses	9	3	367	4	__gneisses
gravesites	14	4	393	4	gravesites
hangnests	13	4	452	4	hangnes_t_s
harnesses	12	18	1205	4	harnes_ses
homesites	14	4	890	4	_homesites
honesties	12	4	989	4	_honesties
ignites	8	13	1057	4	_ign__ites
imageries	12	4	675	4	imag_eri_es
inosites	8	3	1275	4	__inosites
jadeites	16	4	579	4	ja_de_ites
jaggeries	18	13	696	4	jaggeri_es
jarosites	16	4	732	4	ja_rosites
kainites	12	3	877	4	kain__ites
lakesides	14	4	406	4	la_kesides
landsides	11	11	671	4	la_ndsides
lanosities	10	4	785	4	la_nosities
laterites	9	7	1502	4	la_terites
laxnesses	16	4	663	4	laxnes_ses
lignites	9	12	959	4	lign__ites
macerates	13	21	1353	4	ma_cerates
machetes	15	3	963	4	mache__tes
maderizes	21	4	893	4	ma_derizes
madness	10	3	1006	4	madnes___s
magazines	21	4	561	4	mag_azines
magentas	11	3	789	4	mag_e_ntas
magister	11	3	626	4	mag_is_ter
magisters	12	3	577	4	mag_is_ters
magnate	10	5	1267	4	magn__ate_
magnet	9	3	2066	4	magne__t__
magnetic	13	4	921	4	magne__tic
magnetism	14	56	725	4	magneti_sm
magneto	10	4	674	4	magne__t_o
magneton	11	4	493	4	magne__ton
magnetons	12	4	453	4	magne_tons
magnetrons	13	4	306	4	magnetrons
magnificoes	19	7	183	4	magnificoes
magnificos	18	6	199	4	magnificos
magnified	16	4	574	4	magnifi_ed
magnifier	15	4	527	4	magnifi_er
magnifiers	16	4	379	4	magnifiers
magnitudes	14	4	332	4	magnitudes
magnolias	12	4	467	4	magnoli_as
magpies	12	3	1035	4	mag__pi_es
mainlines	11	3	846	4	main_lines
makebates	17	4	493	4	ma_kebates
malachites	17	8	502	4	malachites
maleates	10	33	1631	4	ma_le_ates
malemutes	13	4	443	4	ma_lemutes
malenesses	12	3	1213	4	malenes_ses
mandates	11	3	1405	4	ma_n_dates
maneges	10	36	1212	4	ma_ne__ges
mangabies	14	4	635	4	mangabi_es
manganates	13	4	591	4	manganates
manganeses	13	4	500	4	manganes__es
manganite	12	4	773	4	manganite_
manginesses	14	9	959	4	mangines_ses
manitos	9	3	1402	4	ma_n__itos
manitus	9	3	1089	4	ma_n__itus
mannerisms	14	5	498	4	mannerisms
mannerists	12	4	589	4	mannerists
mannite	9	3	1286	4	ma_n_nite_
mannoses	10	3	906	4	mannos__es
manses	8	42	2551	4	ma_n_s__es
mansions	10	6	977	4	ma_n_sions
mantes	8	44	3077	4	ma_n___tes
mantises	10	3	1790	4	ma_n_tises
manumits	12	4	596	4	ma_numit_s
maquettes	20	4	589	4	maque_ttes
marbelizes	23	4	536	4	marbelizes
marcasite	13	4	662	4	marcasite_
margarites	13	4	650	4	margarites
marguerite	13	5	386	4	marguerite_
marlites	10	34	1521	4	ma__rlites
marmites	12	22	1276	4	ma__rmites
martensite	12	5	440	4	martensite_
masonites	11	4	914	4	ma_sonites
masteries	11	10	1846	4	masteri_es
matelotes	11	4	630	4	ma_telotes
matinesses	12	3	1452	4	matines_ses
maundies	11	3	783	4	maun_di_es
maximites	20	4	530	4	ma_ximites
mazinesses	21	3	990	4	mazines_ses
meannesses	12	12	816	4	meannes_ses
millerites	12	4	791	4	millerites
mimesises	13	4	534	4	m_imesises
mimetites	13	4	678	4	m_imetites
modesties	12	4	744	4	m_odesties
monazites	20	4	640	4	m_onazites
monetises	11	3	1103	4	m_onetises
monetizes	20	4	920	4	m_onetizes
pansies	9	45	2193	4	pa_n_si_es
parasites	11	3	1306	4	pa_rasites
patnesses	11	16	1177	4	patnes_ses
planesides	13	5	434	4	planesides
rawnesses	12	8	811	4	rawnes_ses
resites	7	40	2776	4	___resites
sadnesses	10	3	1028	4	sadnes_ses
sagenesses	11	5	1081	4	sagenes_ses
smugnesses	13	4	455	4	smugnes_ses
synesises	12	4	560	4	_synesises
tangerines	11	4	748	4	tangerines
tanneries	9	3	1040	4	tanneri_es
tansies	7	45	2118	4	ta_n_si_es
umangites	12	4	446	4	uma_n_gites
vignettes	13	4	466	4	vigne_ttes
waenesses	12	3	976	4	waenes_ses
waggeries	14	12	745	4	waggeri_es
wagonettes	14	4	288	4	wagone_ttes
wannesses	12	3	923	4	wannes_ses
wernerites	13	4	489	4	wernerites

Search took 12 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.186	960704.3
2	DLD Change Limit	161450	192	11.066	14589.7
3	Display Results	192	192	0.093	2064.5
	(SQL Overall)	178691	192	11.345	15750.6