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

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

236 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
valvate	13	37	1081	(None)
vallate	10	30	1656	1	vallate
valuate	10	25	1273	1	valuate
volvate	13	31	799	1	volvate
vulvate	13	38	832	1	vulvate
alate	5	53	4032	2	_al_ate
clavate	12	3	871	2	clavate
evaluate	11	28	779	2	evaluate
falcate	12	3	1161	2	falcate
galeate	8	39	1678	2	galeate
gallate	8	34	1712	2	gallate
malate	8	46	2455	2	mal_ate
maleate	9	41	1754	2	maleate
palate	8	42	2678	2	pal_ate
paleate	9	41	2000	2	paleate
palmate	11	32	1523	2	palmate
palpate	11	32	1392	2	palpate
salivate	11	3	1001	2	salivate
salvage	11	3	819	2	salvage
savate	9	3	1378	2	sa_vate
solvate	10	27	1021	2	solvate
vacate	11	3	1455	2	va_cate
valerate	11	3	1147	2	valerate
validate	12	3	900	2	validate
valuated	12	23	920	2	valuated
valuates	11	28	1120	2	valuates
valval	12	39	886	2	valva_l
valvar	12	38	865	2	valva_r
valve	11	45	1593	2	valv__e
valvule	13	4	366	2	valvule
variate	10	13	1643	2	variate
velate	9	37	2014	2	vel_ate
vulgate	11	38	843	2	vulgate
vulvae	12	43	803	2	vulva_e
abate	7	66	2784	3	_a_bate
ablate	8	22	1921	3	_ablate
acuate	8	3	1563	3	_acuate
adnate	7	29	1348	3	_adnate
aerate	6	48	3055	3	_aerate
agate	6	65	2515	3	_a_gate
agnate	7	33	1488	3	_agnate
alae	4	56	4375	3	_al_a_e
alane	5	61	3561	3	_al_ane
alated	7	56	2514	3	_al_ated
alates	6	48	3396	3	_al_ates
albata	8	3	933	3	_albata
albite	8	3	1331	3	_albite
alcade	9	11	1151	3	_alcade
algae	6	53	1962	3	_alga_e
alkane	10	43	1332	3	_alkane
alvine	9	46	1458	3	_alvine
ansate	6	45	1786	3	_ansate
aurate	6	44	2647	3	_aurate
aviate	9	3	1520	3	_aviate
baccate	13	10	1126	3	baccate
balata	8	6	1467	3	bal_ata
baldpate	13	4	548	3	baldpate
ballade	10	40	1256	3	ballade
ballute	9	3	854	3	ballute
barbate	11	3	1454	3	barbate
blate	7	59	3378	3	_bl_ate
bullate	9	34	1507	3	bullate
calceate	12	3	986	3	calceate
calcite	11	4	1378	3	calcite
califate	13	3	1048	3	califate
calotte	9	5	1056	3	calotte
calvary	15	3	718	3	calvary
calve	10	59	1992	3	calv__e
calycate	15	3	789	3	calycate
carate	8	47	3400	3	ca_rate
caseate	9	3	1478	3	caseate
caudate	10	3	1135	3	caudate
ciliate	9	5	1460	3	ciliate
collate	9	29	1968	3	collate
dealate	8	36	1784	3	deal_ate
delate	7	38	2775	3	del_ate
devaluate	13	22	636	3	devaluate
dilate	7	32	2069	3	dil_ate
elate	5	53	3588	3	_el_ate
elevate	10	11	1037	3	elevate
eluate	6	23	1543	3	_eluate
evacuate	13	21	730	3	evacuate
evaluated	13	27	665	3	evaluated
evaluates	12	24	735	3	evaluates
falcated	14	3	847	3	falcated
fellate	10	3	1343	3	fellate
filiate	10	4	1423	3	filiate
folate	9	33	2039	3	fol_ate
foliate	10	5	1353	3	foliate
galatea	8	3	996	3	gal_atea
galeae	7	47	1745	3	galea_e
galeated	10	41	1157	3	galeated
galette	8	42	1269	3	galette
gallates	9	28	1552	3	gallates
gavage	11	3	719	3	ga_vage
gelate	7	34	2125	3	gel_ate
halite	9	36	2423	3	hal_ite
halva	11	54	1443	3	halva__
halvah	15	49	983	3	halva_h
halvahs	16	41	753	3	halvahs
halvas	12	47	1417	3	halva_s
halve	11	48	1892	3	halv__e
hamate	11	33	1983	3	ha_mate
hastate	10	3	1391	3	hastate
kalifate	15	5	649	3	kalifate
karate	10	53	2092	3	ka_rate
labiate	9	13	1357	3	labiate
lactate	9	3	1269	3	lactate
lanate	6	4	2126	3	la_nate
larvae	9	3	884	3	larva_e
late	4	75	6048	3	__l_ate
lavage	10	3	826	3	la_vage
magnate	10	5	1270	3	magnate
malates	9	35	2260	3	mal_ates
maleates	10	33	1634	3	maleates
maltase	9	3	890	3	maltase
mammate	10	44	1127	3	mammate
mandate	10	3	1557	3	mandate
naivete	10	5	566	3	naivete
narrate	7	3	1349	3	narrate
nervate	10	3	953	3	nervate
oblate	8	22	1474	3	obl_ate
obovate	12	3	546	3	obovate
oleate	6	3	1888	3	_oleate
ovate	8	42	1439	3	__ovate
ovulate	10	3	945	3	ovul_ate
oxalate	14	5	762	3	oxal_ate
palace	10	45	1691	3	pal_ace
palates	9	36	2493	3	pal_ates
paleae	8	48	2029	3	palea_e
palette	9	36	1398	3	palette
palliate	10	3	1189	3	palliate
palmated	13	25	1100	3	palmated
palpated	13	24	976	3	palpated
palpates	12	26	1306	3	palpates
pavane	11	41	1344	3	pa_vane
peltate	9	20	1377	3	peltate
pileate	9	38	1592	3	pileate
placate	11	3	1243	3	placate
planate	9	3	1457	3	planate
plate	7	46	3511	3	_pl_ate
private	12	15	1326	3	private
pulsate	9	5	1023	3	pulsate
radiate	8	34	1631	3	radiate
ramate	8	39	2168	3	ra_mate
ravage	10	3	930	3	ra_vage
relate	6	40	3363	3	rel_ate
revaluate	12	27	710	3	revaluate
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
satiate	7	3	1540	3	satiate
savage	10	4	1017	3	sa_vage
savates	10	3	1295	3	sa_vates
selvage	11	3	655	3	selvage
silvae	9	28	1109	3	silva_e
slate	5	54	3828	3	_sl_ate
solate	6	45	2607	3	sol_ate
solvated	12	23	744	3	solvated
solvates	11	24	967	3	solvates
sulcate	9	3	1442	3	sulcate
sulfate	10	3	1165	3	sulfate
sylvae	12	23	686	3	sylva_e
sylvite	13	26	635	3	sylvite
tailgate	9	4	682	3	tailgate
tallage	8	27	1207	3	tallage
tannate	7	18	1352	3	tannate
toluate	7	15	934	3	toluate
vacated	13	4	935	3	va_cated
vacates	12	3	1283	3	va_cates
vacillate	14	5	685	3	vacillate
vaginate	12	39	1108	3	vaginate
valance	12	6	925	3	valance
vale	7	49	3734	3	val___e
valence	12	6	877	3	valence
valerates	12	3	1054	3	valerates
valet	8	43	3787	3	val_et_
valeted	11	3	901	3	val_eted
valets	9	37	1562	3	val_ets
valiance	13	9	738	3	valiance
valiant	10	3	1462	3	valiant
valiants	11	3	779	3	valiants
validated	14	4	649	3	validated
validates	13	3	824	3	validates
valine	9	46	2309	3	val_ine
valise	9	29	1764	3	val_ise
valse	8	51	1752	3	val__se
valuable	13	3	686	3	valuable
valuator	11	9	672	3	valuator
value	8	57	1909	3	val__ue
valuta	9	3	874	3	val_uta
valutas	10	3	653	3	valutas
valved	13	67	1104	3	valv_ed
valvelet	14	4	534	3	valvelet
valves	12	41	1378	3	valv_es
valving	14	36	855	3	valving
valvula	13	4	325	3	valvula
valvulae	14	4	272	3	valvulae
valvules	14	4	347	3	valvules
vanadate	12	4	551	3	vanadate
vantage	11	10	989	3	vantage
variated	12	12	1139	3	variated
variates	11	12	1498	3	variates
varve	11	57	1685	3	varv__e
veloute	10	3	773	3	veloute
velvet	12	36	1375	3	velvet_
velveted	15	3	383	3	velveted
velvets	13	32	669	3	velvets
velvety	16	30	400	3	velvety
vibrate	12	28	1152	3	vibrate
villae	9	56	1538	3	villa_e
village	11	36	1083	3	village
violate	10	3	1155	3	violate
virgate	11	3	873	3	virgate
vitiate	10	34	1295	3	vitiate
vittate	10	40	973	3	vittate
vivace	14	3	655	3	v_ivace
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
vulgates	12	23	723	3	vulgates
vulva	11	44	880	3	vulva__
vulval	12	41	766	3	vulva_l
vulvar	12	42	796	3	vulva_r
vulvas	12	38	884	3	vulva_s

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.406	440125.6
2	DLD Change Limit	134027	236	6.423	20866.7
3	Display Results	236	236	0.093	2537.6
	(SQL Overall)	178691	236	6.922	25814.9