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

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

197 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
magnesite	12	96	931	(None)
magnesites	13	189	833	1	magnesites
magnetite	12	73	1121	1	magnetite
magnesia	11	4	572	2	magnesi_a
magnesian	12	4	471	2	magnesian
magnesias	12	4	569	2	magnesias
magnesic	13	4	575	2	magnesi_c
magnesium	14	5	373	2	magnesium
magnetise	12	51	1040	2	magnetise
magnetites	13	89	1090	2	magnetites
magnetize	21	51	987	2	magnetize
andesite	9	4	945	3	_andesite
anglesite	10	4	575	3	anglesite
magnate	10	5	1270	3	magn__ate
magnesiums	15	6	259	3	magnesiums
magnet	9	3	2066	3	magne__t_
magnetic	13	4	923	3	magneti_c
magnetics	14	4	716	3	magnetics
magnetised	14	50	670	3	magnetised
magnetises	13	67	1009	3	magnetises
magnetism	14	56	729	3	magnetism
magnetized	23	45	768	3	magnetized
magnetizer	22	47	705	3	magnetizer
magnetizes	22	79	1007	3	magnetizes
magneto	10	4	674	3	magne__to
magnets	10	3	1114	3	magne__ts
manganite	12	4	778	3	manganite
mannite	9	3	1290	3	ma_n_nite
marcasite	13	4	666	3	marcasite
marguerite	13	5	391	3	marguerite
martensite	12	5	441	3	martensite
abnegate	11	4	486	4	_abnegate
adamsite	11	4	442	4	_adamsite
adhesive	15	4	380	4	_adhesive
ageist	7	3	1538	4	_ag_eist_
ageists	8	4	849	4	_ag_eists
agemate	10	12	1058	4	_ag_emate
agenesia	9	4	598	4	_agenesi_a
agenesias	10	4	536	4	_agenesias
agenesis	9	3	804	4	_agenesi_s
agenize	17	29	1015	4	_ag_enize
agentive	12	4	804	4	_agentive
agnate	7	33	1488	4	_agn__ate
agnize	16	32	956	4	_agn__ize
agnosia	8	3	764	4	_agnosi_a
agnosias	9	4	724	4	_agnosias
agnostic	11	4	671	4	_agnostic
agrestic	11	4	792	4	_agrestic
aguelike	13	4	467	4	_aguelike
amnesia	9	3	829	4	_amnesi_a
amnesiac	12	6	507	4	_amnesiac
amnesias	10	4	783	4	_amnesias
amnesic	11	3	718	4	_amnesi_c
amnesics	12	5	528	4	_amnesics
amnestic	12	4	705	4	_amnestic
amnestied	12	6	363	4	_amnestied
amnesties	11	6	687	4	_amnesties
amnesty	12	4	482	4	_amnes_ty
amosite	9	3	1316	4	_a_mosite
andesites	10	4	855	4	_andesites
andesyte	12	4	345	4	_andesyte
anglesites	11	4	479	4	anglesites
ankerite	12	4	892	4	_ankerite
ansate	6	45	1786	4	_a_n_sate
appetite	12	5	849	4	_appetite
apposite	12	4	1001	4	_apposite
arenite	7	10	1771	4	_a_renite
argentite	10	4	781	4	argentite
arsenite	8	11	966	4	_arsenite
baguette	11	10	593	4	bague_tte
bakelite	14	4	725	4	ba_kelite
bankside	15	11	565	4	ba_nkside
cagelike	15	3	772	4	cag_elike
cagiest	10	29	1643	4	cagies_t_
campsite	14	4	741	4	ca_mpsite
carnotite	11	4	735	4	carnotite
coesite	9	7	1362	4	__coesite
demagnetize	24	5	342	4	demagnetize
earnest	7	3	1873	4	earnes_t_
earnests	8	3	785	4	earnes_ts
fainest	10	4	1770	4	faines_t_
gahnite	11	3	597	4	gahn__ite
galenite	9	12	1006	4	ga_lenite
garnierite	11	5	307	4	garnierite
geste	6	59	2069	4	__g_es_te
gravesite	13	4	444	4	gravesite
hangnest	12	3	1141	4	hangnes_t_
hangnests	13	4	454	4	hangnes_ts
homesite	13	5	926	4	_homesite
ignite	7	14	1058	4	_ign__ite
inosite	7	3	1406	4	__inosite
jadeite	15	4	640	4	ja_de_ite
jarosite	15	4	838	4	ja_rosite
kainite	11	4	954	4	kain__ite
lakeside	13	4	467	4	la_keside
landside	10	14	744	4	la_ndside
lanosity	11	4	635	4	la_nosity
laterite	8	7	1634	4	la_terite
lignite	8	13	1030	4	lign__ite
macerate	12	23	1407	4	ma_cerate
machete	14	3	1088	4	mache__te
maddest	11	23	1121	4	maddes_t_
maderize	20	4	907	4	ma_derize
madness	10	3	1007	4	madnes__s
madnesses	12	3	983	4	madnesses
magazine	20	4	655	4	mag_azine
magenta	10	3	862	4	mag_e_nta
mages	8	50	3602	4	mag_es___
magister	11	3	628	4	mag_is_ter
magnates	11	5	1161	4	magn__ates
magnetising	15	5	373	4	magnetising
magnetisms	15	57	669	4	magnetisms
magnetizers	23	54	492	4	magnetizers
magneton	11	4	494	4	magne_ton
magnetons	12	4	454	4	magnetons
magnetos	11	4	626	4	magne_tos
magnetron	12	4	327	4	magnetron
magnific	16	5	421	4	magnifi_c
magnifico	17	6	257	4	magnifico
magnified	16	4	576	4	magnified
magnifier	15	4	527	4	magnifier
magnifies	15	4	728	4	magnifies
magnify	16	3	453	4	magn__ify
magnitude	13	4	336	4	magnitude
magnolia	11	4	479	4	magnoli_a
magnolias	12	4	472	4	magnolias
magpie	11	3	909	4	mag__pi_e
mainline	10	3	986	4	main_line
majestic	19	4	491	4	ma_jestic
majesties	18	4	537	4	ma_jesties
majesty	19	4	350	4	ma_jes_ty
makebate	16	4	506	4	ma_kebate
malachite	16	6	603	4	malachite
maleate	9	41	1754	4	ma_le_ate
malemute	12	4	492	4	ma_lemute
mandate	10	3	1557	4	ma_n_date
manege	9	41	1320	4	ma_ne__ge
manes	7	66	4896	4	ma_nes___
manganate	12	4	640	4	manganate
manganese	12	4	480	4	manganes__e
manganesian	14	5	179	4	manganesian
manganites	13	4	703	4	manganites
manges	9	46	2895	4	manges___
mangiest	11	28	1590	4	mangies_t_
manito	8	5	1869	4	ma_n__ito
manitu	8	3	1582	4	ma_n__itu
manlike	13	30	1278	4	ma_n_like
mannerism	13	5	594	4	mannerism
mannerist	11	4	910	4	mannerist
mannerists	12	4	593	4	mannerists
mannites	10	3	1261	4	ma_n_nites
mannose	9	3	924	4	mannos__e
manse	7	55	2823	4	ma_n_s__e
mansion	9	6	1154	4	ma_n_sion
manumit	11	4	957	4	ma_numit_
manumits	12	4	600	4	ma_numits
manwise	12	3	918	4	ma_n_wise
maplelike	17	4	420	4	maplelike
maquette	19	4	611	4	maque_tte
marbelize	22	4	611	4	marbelize
marcasites	14	4	562	4	marcasites
margarite	12	4	751	4	margarite
marguerites	14	5	373	4	marguerites
marlite	9	29	1707	4	ma__rlite
marmite	11	24	1399	4	ma__rmite
martensites	13	5	362	4	martensites
masonite	10	4	968	4	ma_sonite
massive	12	28	977	4	ma__ssive
matelote	10	4	760	4	ma_telote
matiest	9	25	2245	4	maties_t_
maximite	19	5	585	4	ma_ximite
mayest	11	46	1479	4	ma_yes_t_
mazelike	23	3	646	4	ma_zelike
maziest	18	36	1387	4	mazies_t_
meanest	9	3	1570	4	meanes_t_
millerite	11	4	840	4	millerite
mimetite	12	4	760	4	m_imetite
monazite	19	5	708	4	m_onazite
monetise	10	3	1147	4	m_onetise
monetize	19	4	998	4	m_onetize
multisite	11	4	747	4	multisite
nonelite	8	3	1361	4	_nonelite
parasite	10	3	1484	4	pa_rasite
planeside	12	8	512	4	planeside
resite	6	41	2845	4	___resite
sagest	7	49	2026	4	sag_es_t_
sagiest	8	26	1799	4	sagies_t_
sanest	6	44	2669	4	sa_nes_t_
tangerine	10	4	840	4	tangerine
tannest	7	26	1785	4	tannes_t_
umangite	11	4	482	4	uma_n_gite
vaguest	11	3	733	4	vagues_t_
vainest	10	3	1576	4	vaines_t_
vignette	12	4	504	4	vigne_tte
wagonette	13	4	335	4	wagone_tte
wannest	10	39	1500	4	wannes_t_
wernerite	12	4	517	4	wernerite

Search took 13 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	165329	0.423	422437.4
2	DLD Change Limit	165329	197	11.593	14261.1
3	Display Results	197	197	0.093	2118.3
	(SQL Overall)	178691	197	12.109	14756.9