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

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

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

261 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
solvate	10	27	1021	(None)
solate	6	45	2607	1	sol_ate
solvated	12	23	744	1	solvated
solvates	11	24	967	1	solvates
volvate	13	31	799	1	volvate
collate	9	29	1968	2	collate
folate	9	33	2039	2	fol_ate
foliate	10	5	1353	2	foliate
isolate	7	3	1392	2	isol_ate
oleate	6	3	1888	2	_oleate
ovate	8	42	1439	2	_o_vate
salivate	11	3	1001	2	salivate
salvage	11	3	819	2	salvage
savate	9	3	1378	2	s_avate
selvage	11	3	655	2	selvage
silvae	9	28	1109	2	silva_e
slate	5	54	3828	2	s_l_ate
solace	8	34	1582	2	sol_ace
solated	8	36	1802	2	sol_ated
solates	7	35	2385	2	sol_ates
solute	6	40	1666	2	sol_ute
solvable	13	3	747	2	solvable
solve	8	56	1894	2	solv__e
sorbate	9	3	1173	2	sorbate
soulmate	10	4	719	2	soulmate
spoliate	10	3	924	2	spoliate
sulcate	9	3	1442	2	sulcate
sulfate	10	3	1165	2	sulfate
sylvae	12	23	686	2	sylva_e
sylvite	13	26	635	2	sylvite
toluate	7	15	934	2	toluate
valvate	13	37	1081	2	valvate
vulvate	13	38	832	2	vulvate
ablate	8	22	1921	3	abl_ate
alate	5	53	4033	3	_al_ate
blate	7	59	3378	3	_bl_ate
bloviate	13	8	491	3	bloviate
bolete	8	5	1961	3	bol_ete
borate	8	50	2615	3	bo_rate
bullate	9	34	1507	3	bullate
cholate	12	21	1493	3	chol_ate
ciliate	9	5	1460	3	ciliate
clavate	12	3	871	3	clavate
cognate	10	3	1220	3	cognate
collage	10	28	1376	3	collage
collated	11	36	1506	3	collated
collates	10	30	1914	3	collates
colocate	12	3	1344	3	colocate
comate	10	41	2484	3	co_mate
connate	9	3	1575	3	connate
cordate	10	3	1522	3	cordate
costate	9	40	1927	3	costate
couvade	13	3	506	3	couvade
delate	7	38	2775	3	del_ate
desolate	9	4	1199	3	desol_ate
dilate	7	32	2069	3	dil_ate
dogvane	12	4	385	3	dogvane
donate	7	36	1950	3	do_nate
elate	5	53	3588	3	_el_ate
elevate	10	11	1037	3	elevate
eluate	6	23	1543	3	_eluate
estivate	11	10	1000	3	estivate
falcate	12	3	1162	3	falcate
fellate	10	3	1343	3	fellate
filiate	10	4	1423	3	filiate
folates	10	32	1845	3	fol_ates
foliage	11	4	753	3	foliage
foliated	12	4	991	3	foliated
foliates	11	4	1275	3	foliates
formate	12	31	1509	3	formate
fossate	10	38	860	3	fossate
foveate	13	3	836	3	foveate
galeate	8	39	1679	3	galeate
gallate	8	34	1713	3	gallate
gelate	7	34	2126	3	gel_ate
globate	10	5	782	3	globate
goliath	11	4	593	3	goliath
insolate	8	3	1189	3	insol_ate
iodate	7	3	1350	3	io_date
iolite	6	32	2198	3	iol_ite
isolated	9	4	1052	3	isol_ated
isolates	8	6	1351	3	isol_ates
late	4	75	6048	3	__l_ate
lobate	8	29	1524	3	lo_bate
locate	8	39	1984	3	lo_cate
lovage	10	3	735	3	lo_vage
lovat	8	3	2104	3	lo_vat_
lovats	9	3	907	3	lo_vats
malate	8	46	2456	3	mal_ate
maleate	9	41	1754	3	maleate
motivate	13	4	769	3	motivate
nervate	10	3	953	3	nervate
notate	6	32	1786	3	no_tate
novae	8	59	1312	3	no_va_e
oblate	8	22	1474	3	_oblate
obovate	12	3	546	3	obovate
obviate	12	3	578	3	_obviate
oleates	7	4	1783	3	_oleates
oolite	6	33	1960	3	ool_ite
opiate	8	5	1346	3	_opiate
orate	5	51	3330	3	_o_rate
ornate	6	3	1514	3	_ornate
outate	6	29	2340	3	_outate
palate	8	42	2679	3	pal_ate
paleate	9	41	2000	3	paleate
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
peltate	9	20	1377	3	peltate
pileate	9	38	1592	3	pileate
plate	7	46	3511	3	_pl_ate
poleaxe	16	5	630	3	poleaxe
polite	8	36	2507	3	pol_ite
pollute	9	3	738	3	pollute
private	12	15	1326	3	private
prolate	9	4	1979	3	prol_ate
pulsate	9	5	1023	3	pulsate
relate	6	40	3363	3	rel_ate
roseate	7	6	1345	3	roseate
rotate	6	33	2034	3	ro_tate
saccate	11	13	1176	3	saccate
salivated	13	3	747	3	salivated
salivates	12	3	929	3	salivates
salpae	8	46	1427	3	salpa_e
salute	6	44	1802	3	sal_ute
salvable	13	3	840	3	salvable
salvaged	13	3	536	3	salvaged
salvagee	12	4	648	3	salvagee
salvager	12	3	559	3	salvager
salvages	12	3	812	3	salvages
salve	8	50	2213	3	salv__e
sate	4	55	5610	3	s___ate
satiate	7	3	1540	3	satiate
savage	10	4	1017	3	s_avage
savates	10	3	1295	3	s_avates
scutate	9	3	1032	3	scutate
sedate	7	30	1981	3	s_edate
selenate	8	17	1253	3	selenate
selva	8	30	1427	3	selva__
selvaged	13	3	434	3	selvaged
selvages	12	3	651	3	selvages
selvas	9	38	1291	3	selva_s
senate	6	37	2517	3	s_enate
sensate	7	3	1189	3	sensate
septate	9	5	1187	3	septate
seriate	7	37	2247	3	seriate
serrate	7	30	1754	3	serrate
sigmate	10	7	1014	3	sigmate
silage	7	27	1530	3	sil_age
silane	6	27	1805	3	sil_ane
silicate	10	3	1262	3	silicate
silva	8	27	1402	3	silva__
silvan	9	28	1015	3	silva_n
silvans	10	30	833	3	silvans
silvas	9	29	1218	3	silva_s
sinuate	7	4	1216	3	sinuate
situate	7	4	1078	3	situate
skate	9	47	2155	3	s__kate
slake	9	37	2405	3	s_l_ake
slat	4	69	5902	3	s_l_at_
slated	7	50	2831	3	s_l_ated
slater	6	44	2918	3	s_l_ater
slates	6	49	3406	3	s_l_ates
slatey	9	54	1706	3	s_l_atey
slats	5	54	3690	3	s_l_ats
slaty	8	65	2315	3	s_l_aty
slave	8	42	2403	3	s_l_ave
sleave	9	47	1415	3	s_leave
sleaze	15	26	1186	3	s_leaze
soakage	12	3	610	3	soakage
soave	8	42	1905	3	so__ave
socage	9	10	1212	3	so_cage
soccage	12	3	628	3	soccage
soilage	8	16	935	3	soilage
sola	4	55	4186	3	sol_a__
solaced	10	29	1106	3	sol_aced
solacer	9	30	1110	3	sol_acer
solaces	9	31	1613	3	sol_aces
solan	5	53	2815	3	sol_a_n
soland	7	51	1504	3	sol_and
solano	6	53	1418	3	sol_ano
solans	6	41	2249	3	sol_ans
solar	5	59	2734	3	sol_a_r
solatia	7	3	1225	3	sol_atia
soldan	7	35	1185	3	solda_n
soldans	8	32	1040	3	soldans
sole	4	60	5367	3	sol___e
soleplate	11	4	528	3	soleplate
soleret	7	3	2123	3	soleret
solfege	11	4	422	3	solfege
soluble	9	6	610	3	soluble
solutes	7	35	1526	3	sol_utes
solvating	13	3	644	3	solvating
solvation	12	3	777	3	solvation
solved	10	53	1293	3	solv_ed
solvent	10	3	1083	3	solvent
solvents	11	3	676	3	solvents
solver	9	40	1670	3	solv_er
solvers	10	44	1425	3	solvers
solves	9	50	1822	3	solv_es
solving	11	29	1085	3	solving
somata	8	3	1238	3	so_mata
somite	8	45	1937	3	so_mite
sonata	6	3	1322	3	so_nata
sonicate	10	3	1093	3	sonicate
sopite	8	49	1771	3	so_pite
sorbates	10	3	1110	3	sorbates
sororate	8	4	1117	3	sororate
soulmates	11	4	707	3	soulmates
soutane	7	3	1206	3	soutane
soviet	9	7	2015	3	so_viet
spate	7	47	3158	3	s__pate
spicate	11	32	1419	3	spicate
spinate	9	31	1481	3	spinate
splake	12	5	978	3	spl_ake
splat	7	61	2934	3	spl_at_
splats	8	48	1730	3	spl_ats
spoliated	12	4	691	3	spoliated
spoliates	11	3	854	3	spoliates
state	5	62	3733	3	s__tate
stellate	8	3	1050	3	stellate
stolonate	9	4	483	3	stolonate
stomate	9	3	1312	3	stomate
striate	7	42	1895	3	striate
stylate	10	17	977	3	stylate
sublate	9	3	1536	3	sublate
subovate	13	4	733	3	subovate
sulcated	11	3	1037	3	sulcated
sulfated	12	3	883	3	sulfated
sulfates	11	3	1079	3	sulfates
sulfite	10	3	1047	3	sulfite
sullage	8	5	991	3	sullage
sulphate	13	4	664	3	sulphate
summate	11	36	1166	3	summate
sylva	11	26	844	3	sylva__
sylvan	12	25	736	3	sylva_n
sylvanite	15	4	379	3	sylvanite
sylvans	13	23	589	3	sylvans
sylvas	12	28	817	3	sylva_s
sylvatic	16	4	535	3	sylvatic
sylvine	13	21	654	3	sylvine
sylvites	14	22	584	3	sylvites
toccate	11	3	877	3	toccate
togate	7	45	1568	3	to_gate
tolane	6	43	1658	3	tol_ane
tolerate	8	3	1232	3	tolerate
tollage	8	26	1016	3	tollage
tollgate	9	4	625	3	tollgate
toluates	8	13	890	3	toluates
vallate	10	30	1656	3	vallate
valuate	10	25	1273	3	valuate
velate	9	37	2014	3	vel_ate
violate	10	3	1155	3	viol_ate
volante	10	3	851	3	volante
voltage	11	3	686	3	voltage
volte	8	53	2130	3	vol__te
volute	9	39	1276	3	vol_ute
volva	11	39	900	3	volva__
volvas	12	44	799	3	volva_s
vulgate	11	38	843	3	vulgate
vulvae	12	43	803	3	vulva_e
zonate	15	41	1492	3	zo_nate

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	134027	0.826	216332.9
2	DLD Change Limit	134027	261	7.626	17575.0
3	Display Results	261	261	0.093	2806.5
	(SQL Overall)	178691	261	8.545	20911.8