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

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

315 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
citrate	9	22	1680	(None)
cirrate	9	24	1349	1	cirrate
citrated	11	27	1225	1	citrated
citrates	10	23	1509	1	citrates
nitrate	7	20	1701	1	nitrate
titrate	7	22	1557	1	titrate
acierate	10	3	1181	2	acierate
carate	8	47	3400	2	c_arate
castrate	10	3	1386	2	castrate
cerate	8	48	2946	2	c_erate
ciliate	9	5	1460	2	ciliate
citral	8	11	1389	2	citra_l
citrals	9	11	1167	2	citrals
citrine	9	25	1402	2	citrine
crate	7	65	3740	2	c__rate
cultrate	10	3	1087	2	cultrate
curate	8	52	2624	2	c_urate
curtate	9	3	1264	2	curtate
disrate	8	14	1852	2	disrate
filtrate	11	4	822	2	filtrate
irate	5	56	2798	2	_i_rate
iterate	7	11	1911	2	_iterate
librate	9	32	1423	2	librate
literate	8	12	1689	2	literate
migrate	10	13	1417	2	migrate
misrate	9	13	1914	2	misrate
nitrated	9	22	1315	2	nitrated
nitrates	8	25	1622	2	nitrates
nitrite	7	23	1446	2	nitrite
outrate	7	23	2318	2	outrate
picrate	11	20	1414	2	picrate
pirate	8	23	2288	2	pi_rate
situate	7	4	1078	2	situate
titrated	9	26	1168	2	titrated
titrates	8	23	1466	2	titrates
vibrate	12	28	1152	2	vibrate
vitiate	10	34	1295	2	vitiate
vittate	10	40	973	2	vittate
accurate	12	4	1066	3	accurate
acerate	9	28	1891	3	acerate
acetate	9	25	1475	3	acet_ate
acierated	12	3	828	3	acierated
acierates	11	3	1081	3	acierates
activate	13	5	1037	3	activate
actuate	9	3	1144	3	actuate
aerate	6	48	3055	3	_aerate
agitate	8	3	1206	3	agit_ate
airdate	8	3	1132	3	airdate
aliterate	9	16	1134	3	aliterate
amirate	9	11	1595	3	amirate
arbitrate	11	13	737	3	arbitrate
attrite	7	3	1183	3	attrite
aurate	6	44	2647	3	_aurate
berate	8	47	2902	3	_berate
biforate	13	4	690	3	biforate
binate	8	4	1977	3	bi_nate
birthrate	14	4	530	3	birthrate
bistate	9	3	1382	3	bistate
borate	8	50	2615	3	_borate
butyrate	13	4	620	3	butyrate
calibrate	13	4	775	3	calibrate
capitate	12	17	1218	3	capit_ate
carafe	11	54	1616	3	c_arafe
carat	7	50	4879	3	c_arat_
carates	9	56	3061	3	c_arates
carats	8	59	2902	3	c_arats
cartage	10	3	1259	3	cartage
carte	7	59	4042	3	c_ar_te
caseate	9	3	1478	3	caseate
castrated	12	3	951	3	castrated
castrater	11	4	852	3	castrater
castrates	11	3	1267	3	castrates
castrati	10	4	864	3	castrati
castrato	10	4	852	3	castrato
cate	6	62	5460	3	c___ate
catenate	10	3	1283	3	catenate
catface	14	3	676	3	catface
caudate	10	3	1135	3	caudate
cavitate	13	15	983	3	cavit_ate
cerated	10	39	2247	3	c_erated
cerates	9	54	2825	3	c_erates
cerite	8	47	2487	3	c_erite
cetane	8	3	1528	3	cet_ane
charade	13	12	991	3	charade
chelate	12	29	1490	3	chelate
chlorate	13	31	1269	3	chlorate
cholate	12	21	1493	3	cholate
chorale	12	43	1335	3	chorale
chordate	14	4	803	3	chordate
cicale	10	3	1450	3	ci_cale
cigaret	10	4	1300	3	cigaret
ciliated	11	5	1095	3	ciliated
ciliates	10	4	1345	3	ciliates
cineaste	10	4	574	3	cineaste
circle	10	3	970	3	ci_rcle
cire	6	58	3637	3	ci_r__e
cirque	17	3	585	3	ci_rque
cirrose	9	3	747	3	cirrose
citable	11	3	1346	3	citable
citadel	10	4	438	3	cit_adel
citator	9	3	1012	3	cit_ator
cite	6	56	4034	3	ci___te
citeable	12	3	841	3	citeable
cithara	12	16	651	3	cithara
citole	8	3	1150	3	cit_ole
citric	10	28	1231	3	citr_ic
citrin	8	26	1541	3	citr_in
citrines	10	25	1313	3	citrines
citrins	9	26	1436	3	citrins
citron	8	31	1298	3	citr_on
citrons	9	29	1322	3	citrons
citrous	9	31	1299	3	citrous
citrus	8	36	1092	3	citr_us
citruses	10	3	748	3	citruses
citrusy	12	28	418	3	citrusy
clathrate	14	4	535	3	clathrate
clavate	12	3	871	3	clavate
climate	11	3	1283	3	climate
cocreate	12	26	1181	3	cocreate
cogitate	11	4	855	3	cogit_ate
cognate	10	3	1220	3	cognate
coinmate	12	3	906	3	coinmate
collate	9	29	1968	3	collate
comate	10	41	2484	3	c_omate
comrade	12	13	921	3	comrade
connate	9	3	1575	3	connate
contrite	10	3	1854	3	contrite
cordate	10	3	1522	3	cordate
corrade	10	11	1104	3	corrade
costate	9	40	1927	3	costate
cottae	8	46	1570	3	cotta_e
cottage	10	42	1057	3	cottage
courage	10	3	1099	3	courage
courante	10	4	995	3	courante
cowrite	12	36	1268	3	cowrite
cowrote	12	28	967	3	cowrote
crake	11	48	2352	3	c__rake
crane	7	53	3160	3	c__rane
crape	9	61	2844	3	c__rape
crated	9	48	2777	3	c__rated
crater	8	50	2664	3	c__rater
crates	8	57	3606	3	c__rates
crave	10	56	2631	3	c__rave
craze	16	52	2146	3	c__raze
create	8	51	2638	3	c_reate
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
crispate	12	4	691	3	crispate
cristate	10	3	1060	3	cristate
cultrated	12	4	822	3	cultrated
cuneate	9	3	1172	3	cuneate
cuprite	11	5	968	3	cuprite
curare	8	49	1695	3	c_urare
curated	10	47	1758	3	c_urated
curates	9	53	2383	3	c_urates
curite	8	52	2294	3	c_urite
cuspate	11	3	823	3	cuspate
cuttage	10	31	834	3	cuttage
cutwater	13	4	483	3	cutwater
cyanate	12	25	970	3	cyanate
denitrate	10	8	1053	3	denitrate
derate	7	45	3123	3	_derate
dictate	10	3	1166	3	dictate
dilate	7	32	2069	3	di_late
diorite	8	3	1491	3	diorite
disrated	10	9	1557	3	disrated
disrates	9	11	1815	3	disrates
distraite	10	6	1148	3	distraite
emigrate	11	4	960	3	emigrate
emirate	9	10	1583	3	emirate
estate	6	47	1976	3	est_ate
ferrate	10	30	1404	3	ferrate
figurate	12	3	719	3	figurate
filiate	10	4	1423	3	filiate
filtrated	13	4	596	3	filtrated
filtrates	12	4	773	3	filtrates
fissate	10	30	1003	3	fissate
fixate	16	3	873	3	fi_xate
grate	6	49	3288	3	__grate
guttate	8	32	890	3	guttate
gyrate	10	49	1252	3	_gyrate
hydrate	14	23	981	3	hydrate
ideate	7	3	1368	3	_ideate
imitate	9	3	1087	3	imit_ate
ingate	7	30	1824	3	_ingate
ingrate	8	7	1512	3	ingrate
initiate	8	4	1269	3	initiate
inmate	8	29	1736	3	_inmate
innate	6	39	1731	3	_innate
iodate	7	3	1350	3	_iodate
irade	6	56	1815	3	_i_rade
irater	6	52	1835	3	_i_rater
iterated	9	12	1382	3	_iterated
iterates	8	13	1782	3	_iterates
karate	10	53	2092	3	_karate
liberate	10	11	1338	3	liberate
librae	8	43	1017	3	libra_e
librated	11	31	1031	3	librated
librates	10	34	1295	3	librates
liftgate	12	4	341	3	liftgate
ligate	7	25	1925	3	li_gate
limbate	11	3	921	3	limbate
lineate	7	8	1515	3	lineate
liquate	16	3	842	3	liquate
literates	9	14	1565	3	literates
literati	8	12	1080	3	literati
litigate	9	4	830	3	litigate
litre	5	54	2146	3	litr__e
lustrate	8	3	1044	3	lustrate
lyrate	9	41	1210	3	_lyrate
maturate	10	3	1262	3	maturate
metate	8	27	2053	3	met_ate
micturate	13	6	664	3	micturate
migrated	12	11	1051	3	migrated
migrates	11	11	1285	3	migrates
mirage	9	23	1365	3	mi_rage
misate	8	12	2269	3	mi_sate
misdate	10	14	1396	3	misdate
mismate	11	14	1535	3	mismate
misrated	11	13	1538	3	misrated
misrates	10	13	1824	3	misrates
mistrace	12	3	1264	3	mistrace
mitigate	11	4	869	3	mitigate
mitral	8	13	1432	3	mitra_l
mitre	7	55	2242	3	mitr__e
mutate	8	30	1748	3	mut_ate
narrate	7	3	1349	3	narrate
nictate	9	3	1022	3	nictate
nidate	7	3	1378	3	ni_date
niobate	9	3	770	3	niobate
nitrator	8	4	955	3	nitrator
nitre	5	75	1968	3	nitr__e
nitride	8	28	1124	3	nitride
nitrile	7	30	1137	3	nitrile
nitrites	8	23	1345	3	nitrites
notate	6	32	1786	3	not_ate
nutate	6	30	1737	3	nut_ate
obturate	10	7	777	3	obturate
operate	9	6	1573	3	operate
orate	5	51	3330	3	__orate
outate	6	29	2340	3	out_ate
outdate	8	30	1642	3	outdate
outrace	9	24	1855	3	outrace
outrage	8	26	1689	3	outrage
outrated	9	22	1931	3	outrated
outrates	8	24	2137	3	outrates
outrave	10	26	1441	3	outrave
overate	10	6	2096	3	overate
patriate	10	3	1193	3	patriate
petrale	9	3	1262	3	petrale
phorate	12	4	1336	3	phorate
picrated	13	21	1011	3	picrated
picrates	12	20	1321	3	picrates
picrite	11	19	1131	3	picrite
pileate	9	38	1592	3	pileate
pinnate	9	36	1374	3	pinnate
pirated	10	25	1561	3	pi_rated
pirates	9	30	2033	3	pi_rates
prate	7	51	3598	3	__prate
priorate	10	4	1173	3	priorate
prorate	9	4	1873	3	prorate
rate	4	54	5876	3	___rate
recrate	9	26	2166	3	recrate
regrate	8	26	1866	3	regrate
reiterate	9	4	1293	3	reiterate
retrace	9	14	1734	3	retrace
rostrate	8	3	1384	3	rostrate
rotate	6	33	2034	3	rot_ate
satiate	7	3	1540	3	satiate
saturate	8	3	1281	3	saturate
scutate	9	3	1032	3	scut_ate
serrate	7	30	1754	3	serrate
sigmate	10	7	1014	3	sigmate
sinuate	7	4	1216	3	sinuate
situated	9	3	803	3	situated
situates	8	3	1037	3	situates
state	5	62	3733	3	_st_ate
strafe	9	52	1598	3	_strafe
strake	10	40	1739	3	_strake
strata	6	36	1628	3	_strata
strath	9	32	1637	3	_strath
strati	6	35	1890	3	_strati
striate	7	42	1895	3	_striate
tartrate	8	9	968	3	tartrate
tate	4	47	4860	3	__t_ate
tirade	7	3	1169	3	ti_rade
titanate	8	9	717	3	titanate
titivate	11	4	680	3	titivate
titrable	10	3	896	3	titrable
titrant	7	3	1519	3	titrant
titrants	8	3	848	3	titrants
titrator	8	5	854	3	titrator
titre	5	46	1939	3	titr__e
trace	7	58	2961	3	__trace
trade	6	50	2604	3	__trade
trave	8	52	2303	3	__trave
trite	5	47	3003	3	__trite
triturate	9	4	748	3	triturate
uncrate	9	4	1595	3	uncrate
uprate	8	39	1654	3	_uprate
urate	5	54	3216	3	__urate
vibrated	14	22	839	3	vibrated
vibrates	13	22	1061	3	vibrates
vibrato	12	24	738	3	vibrato
vicarate	13	7	860	3	vicarate
violate	10	3	1155	3	violate
virgate	11	3	873	3	virgate
vitae	8	42	1763	3	vit_a_e
vitiated	12	28	922	3	vitiated
vitiates	11	23	1143	3	vitiates
vitrain	10	3	894	3	vitrain
vitrine	10	25	1136	3	vitrine
vittae	9	39	1100	3	vitta_e
vizirate	20	4	535	3	vizirate
zincate	18	3	853	3	zincate

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.403	443402.0
2	DLD Change Limit	134027	315	6.313	21230.3
3	Display Results	315	315	0.110	2863.6
	(SQL Overall)	178691	315	6.826	26178.0