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

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

307 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
foliate	10	5	1353	(None)
filiate	10	4	1423	1	filiate
folate	9	33	2039	1	fol_ate
foliage	11	4	753	1	foliage
foliated	12	4	991	1	foliated
foliates	11	4	1275	1	foliates
bifoliate	14	4	431	2	bifoliate
ciliate	9	5	1460	2	ciliate
collate	9	29	1968	2	collate
defoliate	13	4	699	2	defoliate
exfoliate	19	5	413	2	exfoliate
falcate	12	3	1162	2	falcate
fellate	10	3	1343	2	fellate
filiated	12	6	1008	2	filiated
filiates	11	4	1266	2	filiates
flite	8	54	2496	2	f_li_te
folates	10	32	1845	2	fol_ates
folia	8	36	1893	2	folia__
foliaged	13	4	467	2	foliaged
foliages	12	4	762	2	foliages
foliar	9	32	1097	2	folia_r
foliolate	12	4	487	2	foliolate
foliose	10	37	801	2	foliose
fomite	11	33	1407	2	fomi_te
formate	12	31	1509	2	formate
fossate	10	38	860	2	fossate
foveate	13	3	836	2	foveate
goliath	11	4	593	2	goliath
iolite	6	32	2198	2	ioli_te
oleate	6	3	1888	2	_oleate
oolite	6	33	1960	2	ooli_te
opiate	8	5	1346	2	_opiate
polite	8	36	2507	2	poli_te
solate	6	45	2607	2	sol_ate
solvate	10	27	1021	2	solvate
spoliate	10	3	924	2	spoliate
toluate	7	15	934	2	toluate
volvate	13	31	799	2	volvate
ablate	8	22	1921	3	abl_ate
affiliate	15	4	532	3	affiliate
alate	5	53	4033	3	_al_ate
aplite	8	3	1639	3	apli_te
aviate	9	3	1520	3	_aviate
blate	7	59	3378	3	_bl_ate
blite	7	62	2535	3	_bli_te
bloviate	13	8	491	3	bloviate
boite	7	44	2632	3	bo_i_te
bolete	8	5	1961	3	bol_ete
bolide	9	5	1556	3	boli_de
boniato	9	4	728	3	boniato
borate	8	50	2615	3	bo_rate
bullate	9	34	1507	3	bullate
califate	13	3	1048	3	califate
celibate	12	5	931	3	celibate
cholate	12	21	1493	3	chol_ate
ciliated	11	5	1095	3	ciliated
ciliates	10	4	1345	3	ciliates
climate	11	3	1283	3	_climate
cogitate	11	4	855	3	cogitate
cognate	10	3	1220	3	cognate
collage	10	28	1376	3	collage
collated	11	36	1506	3	collated
collates	10	30	1914	3	collates
colligate	12	4	829	3	colligate
collimate	13	4	817	3	collimate
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
defoliated	15	4	583	3	defoliated
defoliates	14	4	633	3	defoliates
delate	7	38	2775	3	del_ate
delicate	11	3	1549	3	delicate
deviate	11	3	1271	3	deviate
dilate	7	32	2069	3	dil_ate
dominate	11	3	1285	3	dominate
donate	7	36	1950	3	do_nate
elate	5	53	3588	3	_el_ate
elite	5	62	3018	3	_eli_te
eluate	6	23	1543	3	_eluate
eolian	6	3	1259	3	eolia_n
eolith	9	30	1390	3	eoli_th
epilate	9	3	1428	3	epilate
exfoliated	21	6	339	3	exfoliated
exfoliates	20	6	370	3	exfoliates
expiate	16	9	1059	3	expiate
faciae	11	29	1341	3	facia_e
falcated	14	3	848	3	falcated
fasciate	13	4	756	3	fasciate
fate	7	54	4428	3	f___ate
feline	9	48	2014	3	feli_ne
fellated	12	3	956	3	fellated
fellates	11	3	1275	3	fellates
felsite	10	3	908	3	felsite
feriae	9	56	1860	3	feria_e
fermate	12	28	1300	3	fermate
ferrate	10	30	1404	3	ferrate
fiat	7	66	4664	3	f__iat_
fiats	8	53	2448	3	f__iats
filial	9	30	1325	3	filia_l
filister	11	3	740	3	filister
filtrate	11	4	822	3	filtrate
finite	9	3	1682	3	fini_te
fissate	10	30	1003	3	fissate
fixate	16	3	873	3	f_ixate
flake	12	51	1997	3	f_l_ake
flame	10	51	2444	3	f_l_ame
flare	8	48	2363	3	f_l_are
flat	7	71	4782	3	f_l_at_
flats	8	64	2974	3	f_l_ats
flint	8	73	3350	3	f_lint_
flinted	11	44	1189	3	f_linted
flints	9	56	1745	3	f_lints
flinty	12	61	1249	3	f_linty
flirt	8	74	2475	3	f_lirt_
flirted	11	42	867	3	f_lirted
flirter	10	31	867	3	f_lirter
flirts	9	54	1148	3	f_lirts
flirty	12	49	914	3	f_lirty
flit	7	65	3927	3	f_li_t_
flited	10	46	1658	3	f_li_ted
flites	9	51	2244	3	f_li_tes
flits	8	56	2522	3	f_li_ts
flitted	11	40	1164	3	f_litted
flitter	10	34	1390	3	f_litter
float	8	59	2857	3	f_loat_
floated	11	33	1270	3	f_loated
floatel	10	30	801	3	f_loatel
floater	10	44	1335	3	f_loater
floats	9	68	1625	3	f_loats
floaty	12	42	1094	3	f_loaty
flokati	14	4	348	3	flokati
florae	9	47	1388	3	flora_e
floriated	13	4	702	3	floriated
flotage	11	3	668	3	flotage
flowage	14	3	572	3	flowage
flute	8	68	2375	3	f_l_ute
flyte	11	57	1394	3	f_l_yte
foggage	13	3	411	3	foggage
fogie	9	67	1900	3	fogi__e
foible	11	4	1038	3	fo_ible
foilable	13	3	806	3	foilable
foist	8	57	3097	3	fo_ist_
foisted	11	32	1060	3	fo_isted
foists	9	54	1398	3	fo_ists
foldable	14	3	713	3	foldable
foliating	13	3	925	3	foliating
foliation	12	11	1079	3	foliation
folic	10	53	1932	3	foli__c
folio	8	38	2088	3	foli__o
folioed	11	3	803	3	folioed
folios	9	39	1546	3	foli_os
folious	10	37	1073	3	folious
folium	11	3	1045	3	foli_um
foliums	12	3	717	3	foliums
folkie	13	36	961	3	fol_kie
folkmote	17	6	334	3	folkmote
folktale	15	4	287	3	folktale
follicle	13	4	439	3	follicle
fomites	12	36	1320	3	fomi_tes
footage	11	4	884	3	footage
forage	10	46	1700	3	fo_rage
forbade	13	25	910	3	forbade
forbare	12	23	1051	3	forbare
foredate	12	3	1091	3	foredate
forficate	17	4	512	3	forficate
forgat	10	40	1858	3	forgat_
forgave	14	3	585	3	forgave
forint	9	3	2502	3	forint_
forints	10	4	1183	3	forints
format	11	30	2135	3	format_
formates	13	28	1429	3	formates
formats	12	31	1357	3	formats
fornicate	14	4	608	3	fornicate
forsake	14	3	653	3	forsake
forte	8	61	3146	3	fo__rte
fossae	9	55	1037	3	fossa_e
fouette	10	3	821	3	fouette
foveae	12	3	756	3	fovea_e
foveated	15	3	629	3	foveated
foxlike	21	22	622	3	foxli_ke
frigate	11	3	1106	3	frigate
fulminate	14	4	655	3	fulminate
fumigate	14	4	615	3	fumigate
furcate	12	3	1045	3	furcate
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
goliard	9	3	607	3	goliard
goliaths	12	4	422	3	goliaths
halite	9	36	2423	3	hali_te
holist	9	47	2321	3	holist_
holists	10	44	1396	3	holists
hoplite	12	3	1107	3	hopli_te
illite	6	34	1492	3	illi_te
iodate	7	3	1350	3	io_date
iodinate	9	4	934	3	iodinate
iolites	7	38	1948	3	ioli_tes
isolate	7	3	1392	3	isol_ate
kalifate	15	5	649	3	kalifate
labiate	9	13	1357	3	labiate
late	4	75	6048	3	__l_ate
liane	5	47	2066	3	__liane
ligate	7	25	1925	3	__ligate
lite	4	70	5454	3	__li_te
lobate	8	29	1524	3	lo_bate
locate	8	39	1984	3	lo_cate
loricate	10	3	1066	3	loricate
malate	8	46	2456	3	mal_ate
maleate	9	41	1754	3	maleate
mediate	10	34	1521	3	mediate
militate	10	3	1167	3	militate
modiste	10	3	928	3	modiste
moline	8	44	2203	3	moli_ne
motivate	13	4	769	3	motivate
muriate	9	3	1336	3	muriate
nominate	10	3	1247	3	nominate
norite	6	32	2113	3	nori_te
notate	6	32	1786	3	no_tate
oblate	8	22	1474	3	_oblate
obligate	11	19	830	3	obligate
obviate	12	3	578	3	obviate
oleates	7	4	1783	3	_oleates
olive	8	48	1715	3	_oli_ve
oolites	7	28	1784	3	ooli_tes
oolith	9	38	1324	3	ooli_th
opiated	10	3	948	3	_opiated
opiates	9	3	1214	3	_opiates
orate	5	51	3330	3	_o_rate
ornate	6	3	1514	3	_ornate
outate	6	29	2340	3	_outate
ovate	8	42	1439	3	_o_vate
oxidate	15	3	702	3	_oxidate
palate	8	42	2679	3	pal_ate
paleate	9	41	2000	3	paleate
palliate	10	3	1189	3	palliate
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
pelite	8	43	2300	3	peli_te
peltate	9	20	1377	3	peltate
perfoliate	15	5	544	3	~~per~~foliate
pileate	9	38	1592	3	pileate
plate	7	46	3511	3	_pl_ate
plicate	11	3	1451	3	_plicate
podite	9	33	1535	3	podi_te
pointe	8	46	1931	3	po_inte
poleaxe	16	5	630	3	poleaxe
police	10	29	1856	3	poli_ce
politer	9	24	1707	3	poli_ter
polity	11	30	1586	3	poli_ty
pollinate	11	4	771	3	pollinate
pollute	9	3	738	3	pollute
prolate	9	4	1979	3	prol_ate
pulsate	9	5	1023	3	pulsate
radiate	8	34	1631	3	radiate
relate	6	40	3363	3	rel_ate
roseate	7	6	1345	3	roseate
rotate	6	33	2034	3	ro_tate
salivate	11	3	1001	3	salivate
satiate	7	3	1540	3	satiate
seriate	7	37	2247	3	seriate
silicate	10	3	1262	3	silicate
slate	5	54	3828	3	_sl_ate
soilage	8	16	935	3	soilage
solace	8	34	1582	3	sol_ace
solated	8	36	1802	3	sol_ated
solates	7	35	2385	3	sol_ates
solute	6	40	1666	3	sol_ute
solvated	12	23	744	3	solvated
solvates	11	24	967	3	solvates
somite	8	45	1937	3	somi_te
sonicate	10	3	1093	3	sonicate
sopite	8	49	1771	3	sopi_te
sorbate	9	3	1173	3	sorbate
soulmate	10	4	719	3	soulmate
spoliated	12	4	691	3	spoliated
spoliates	11	3	854	3	spoliates
striate	7	42	1895	3	striate
sulcate	9	3	1442	3	sulcate
sulfate	10	3	1165	3	sulfate
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
trifoliate	13	4	419	3	~~tri~~foliate
unifoliate	13	5	303	3	~~uni~~foliate
validate	12	3	900	3	validate
vallate	10	30	1656	3	vallate
valuate	10	25	1273	3	valuate
valvate	13	37	1081	3	valvate
variate	10	13	1643	3	variate
velate	9	37	2014	3	vel_ate
violate	10	3	1155	3	viol_ate
vitiate	10	34	1295	3	vitiate
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
vulgate	11	38	843	3	vulgate
vulvate	13	38	832	3	vulvate
zeolite	16	3	890	3	zeoli_te
zonate	15	41	1492	3	zo_nate

Search took 7 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.390	458182.1
2	DLD Change Limit	134027	307	6.283	21331.7
3	Display Results	307	307	0.110	2790.9
	(SQL Overall)	178691	307	6.783	26343.9