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

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

230 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
marinate	10	30	1778	(None)
carinate	10	33	2024	1	carinate
marginate	12	17	960	1	marginate
marinade	11	25	938	1	marinade
marinated	12	25	1317	1	marinated
marinates	11	25	1638	1	marinates
carinae	9	43	1858	2	carina_e
carinated	12	34	1426	2	carinated
emarginate	13	8	545	2	emarginate
laminate	10	30	1463	2	laminate
machinate	16	4	795	2	machinate
magnate	10	5	1270	2	ma_gnate
marginated	14	18	734	2	marginated
marginates	13	16	874	2	marginates
marina	8	46	2341	2	marina__
marinaded	13	27	653	2	marinaded
marinades	12	26	897	2	marinades
marinara	10	4	649	2	marinara
marinas	9	35	1937	2	marina_s
marine	8	42	3040	2	marin__e
muriate	9	3	1336	2	muri_ate
muricate	12	3	1111	2	muricate
paginate	11	40	1244	2	paginate
patinate	10	30	1631	2	patinate
urinate	7	3	1536	2	_urinate
vaginate	12	39	1108	2	vaginate
variate	10	13	1643	2	vari_ate
adnate	7	29	1348	3	_a_dnate
agitate	8	3	1206	3	_agitate
agminate	11	3	924	3	agminate
agnate	7	33	1487	3	_a_gnate
airdate	8	3	1132	3	_airdate
alginate	9	3	1069	3	alginate
alienate	8	3	1155	3	_alienate
amirate	9	11	1595	3	_amirate
animate	9	16	1721	3	_animate
arcuate	9	3	1196	3	_arcuate
arenite	7	10	1771	3	_arenite
arginase	9	4	643	3	_arginase
ariette	7	3	1237	3	_ariette
arillate	8	4	1299	3	_arillate
aristae	7	3	1252	3	_aristae
aristate	8	3	1212	3	_aristate
arsenate	8	10	1048	3	_arsenate
aviate	9	3	1520	3	_avi_ate
badinage	12	9	492	3	badinage
barbate	11	3	1454	3	bar_bate
barite	8	42	2481	3	bari__te
baronage	11	4	707	3	baronage
binate	8	4	1977	3	__binate
cabinmate	15	4	409	3	cabinmate
califate	13	3	1048	3	califate
capitate	12	17	1218	3	capitate
carate	8	47	3400	3	car__ate
carbonate	13	4	1051	3	carbonate
carina	8	43	2532	3	carina__
carinal	9	43	1822	3	carina_l
carinas	9	36	2238	3	carina_s
carnage	10	3	1174	3	car_nage
caseinate	11	4	824	3	caseinate
catenate	10	3	1283	3	catenate
catkinate	15	4	582	3	catkinate
cavitate	13	15	983	3	cavitate
circinate	13	4	781	3	circinate
coronate	10	30	1821	3	coronate
craniate	10	3	1256	3	craniate
crenate	9	33	1711	3	_crenate
crinite	9	5	1363	3	_crinite
deaminate	12	4	1017	3	deaminate
derivate	12	3	1120	3	derivate
dominate	11	3	1285	3	dominate
drainage	10	4	578	3	drainage
echinate	13	5	940	3	echinate
emaciate	12	4	875	3	emaci_ate
emanate	9	3	1247	3	ema__nate
evaginate	13	7	648	3	evaginate
fabricate	16	4	683	3	fabricate
farina	9	46	1823	3	farina__
farinas	10	32	1523	3	farina_s
farinose	11	3	646	3	farinose
fascinate	14	4	776	3	fascinate
frigate	11	3	1106	3	_frigate
geminate	11	4	1179	3	geminate
germinate	12	4	862	3	germinate
herniate	11	4	811	3	herniate
imbricate	15	4	566	3	imbricate
iodinate	9	4	934	3	iodinate
irrigate	9	6	763	3	irrigate
irritate	8	6	787	3	irritate
jarina	13	40	1406	3	jarina__
jarinas	14	37	1218	3	jarina_s
kainite	11	4	954	3	ka_inite
kalifate	15	5	649	3	kalifate
karate	10	53	2092	3	kar__ate
labiate	9	13	1357	3	labi_ate
laciniate	11	5	684	3	laciniate
lacunate	10	12	896	3	lacunate
laminae	9	35	1297	3	lamina_e
laminated	12	26	1028	3	laminated
laminates	11	27	1290	3	laminates
lanate	6	4	2126	3	la__nate
lancinate	11	4	780	3	lancinate
lapidate	11	5	790	3	lapidate
lariat	6	6	2904	3	lari_at_
lariated	9	12	1206	3	lari_ated
lariats	7	6	1505	3	lari_ats
larine	6	39	2704	3	larin__e
loricate	10	3	1066	3	loricate
macerate	12	23	1407	3	macerate
machinated	18	4	566	3	machinated
machinates	17	4	732	3	machinates
maculate	12	28	1562	3	maculate
magnates	11	5	1160	3	ma_gnates
makebate	16	4	506	3	makebate
malate	8	46	2455	3	ma__late
maleate	9	41	1754	3	ma_leate
maline	8	45	2908	3	malin__e
mammate	10	44	1127	3	ma_mmate
manage	9	38	1890	3	ma__nage
manat	7	60	3998	3	ma__nat_
manatee	9	3	1766	3	ma__natee
manats	8	46	2346	3	ma__nats
mandarinate	14	5	313	3	m~~and~~arinate
mandate	10	3	1557	3	ma_ndate
manganate	12	4	639	3	manganate
mannite	9	3	1290	3	ma_nnite
maranatha	14	5	295	3	maranatha
maranta	9	3	1169	3	maran_ta
marantas	10	3	1002	3	marantas
marcato	11	3	974	3	mar_cato
marginal	11	3	760	3	margina_l
marginals	12	4	599	3	marginals
margrave	14	4	479	3	margrave
maria	7	50	3288	3	mari_a__
marinaras	11	4	555	3	marinaras
marinating	13	4	1025	3	marinating
marination	12	3	1281	3	marination
mariner	9	33	1599	3	marin_er
mariners	10	31	1386	3	mariners
marines	9	39	2801	3	marin_es
marionette	12	5	367	3	marionette
marital	9	23	1418	3	marita_l
maritime	12	4	738	3	maritime
marline	9	33	2095	3	marlin__e
marlite	9	29	1707	3	mar_lite
marmite	11	24	1399	3	mar_mite
marquisate	21	5	239	3	marquisate
marriage	11	4	725	3	marriage
martinet	10	3	1964	3	martinet_
martinets	11	3	888	3	martinets
martingale	13	4	319	3	martingale
maryjane	20	4	304	3	maryjane
masonite	10	4	968	3	masonite
masticate	13	4	1128	3	masticate
matinal	9	3	1260	3	matina_l
matinee	9	24	1561	3	matin_ee
maturate	10	3	1261	3	maturate
maximite	19	5	585	3	maximite
mediate	10	34	1521	3	medi_ate
medicate	13	5	1324	3	medicate
meditate	11	3	1062	3	meditate
melinite	10	4	1174	3	melinite
meringue	11	4	433	3	meringue
metricate	13	4	991	3	metricate
militate	10	3	1167	3	militate
minae	7	56	2772	3	m__ina_e
minute	8	34	1429	3	m__inute
misate	8	12	2269	3	m__isate
mitigate	11	4	869	3	mitigate
motivate	13	4	769	3	motivate
mucronate	13	4	623	3	mucronate
muriated	11	3	979	3	muri_ated
muriates	10	3	1208	3	muri_ates
muricated	14	4	824	3	muricated
murine	8	42	2002	3	murin__e
mutilate	10	3	1227	3	mutilate
narine	6	34	2255	3	narin__e
narrate	7	3	1349	3	nar_rate
navigate	12	4	607	3	navigate
nominate	10	3	1247	3	nominate
ordinate	9	3	1025	3	ordinate
ornate	6	3	1513	3	_or_nate
paginated	13	30	946	3	paginated
paginates	12	31	1136	3	paginates
parlante	10	3	969	3	parlante
patinae	9	54	1440	3	patina_e
patinated	12	39	1141	3	patinated
patinates	11	38	1469	3	patinates
patriate	10	3	1193	3	patri_ate
primate	11	15	1628	3	_primate
private	12	15	1326	3	_private
pronate	9	4	1887	3	_pronate
quinate	16	5	1157	3	_quinate
rabbinate	13	4	514	3	rabbinate
radiate	8	34	1631	3	radi_ate
radicate	11	4	1287	3	radicate
raffinate	15	4	502	3	raffinate
resinate	8	3	1677	3	resinate
ruinate	7	3	1283	3	_ruinate
ruminate	10	5	1147	3	ruminate
salivate	11	3	1001	3	salivate
sanitate	8	6	1204	3	sanitate
sarcinae	10	4	719	3	sarcina_e
satiate	7	3	1540	3	sati_ate
serenate	8	19	1487	3	serenate
seriate	7	37	2247	3	seri_ate
spinate	9	31	1481	3	_spinate
staminate	11	8	798	3	staminate
striate	7	42	1895	3	stri_ate
supinate	10	3	1031	3	supinate
suricate	10	3	1261	3	suricate
tannate	7	18	1352	3	ta_nnate
tartrate	8	9	967	3	tartrate
terminate	11	4	1120	3	terminate
ternate	7	4	1548	3	ter_nate
turbinate	11	4	667	3	turbinate
uncinate	10	3	1239	3	uncinate
urinated	9	3	1161	3	_urinated
urinates	8	3	1413	3	_urinates
vaccinate	16	4	683	3	vaccinate
vaginae	11	37	768	3	vagina_e
vaginated	14	32	815	3	vaginated
validate	12	3	900	3	validate
variance	13	9	741	3	variance
variant	10	3	1680	3	variant_
variants	11	3	920	3	variants
variated	12	12	1139	3	vari_ated
variates	11	12	1497	3	vari_ates
variegate	13	4	409	3	variegate
variolate	12	4	855	3	variolate

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	146162	0.170	1051123.5
2	DLD Change Limit	146162	230	7.783	18779.6
3	Display Results	230	230	0.093	2473.1
	(SQL Overall)	178691	230	8.046	22208.7