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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

75 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
dopamine	13	4	617	(None)
dopamines	14	4	604	1	dopamines
diamine	10	3	1198	2	d_iamine
domaine	10	6	1050	2	doma_ine
domine	9	29	1825	2	do__mine
opaline	9	4	1248	2	_opaline
topazine	19	4	498	2	topazine
amine	7	58	3538	3	___amine
calamine	12	3	1403	3	calamine
coaming	12	38	1832	3	co_aming
cocaine	11	13	1517	3	coca_ine
defaming	15	23	846	3	defaming
delaine	8	3	1479	3	dela_ine
depaint	10	3	1459	3	depa_int
diamide	11	3	847	3	d_iamide
diamin	9	3	1252	3	d_iamin_
diamines	11	3	1164	3	d_iamines
diamins	10	3	1221	3	d_iamins
diazine	17	3	893	3	d_iazine
doating	9	38	1686	3	do_ating
doctrine	11	4	673	3	doctrine
dolomite	11	4	813	3	dolomite
domain	9	5	1132	3	doma_in_
domaines	11	6	1106	3	doma_ines
domains	10	5	1087	3	doma_ins
domines	10	29	1897	3	do__mines
doming	10	42	1839	3	do__ming
dominie	10	31	1164	3	do__minie
domino	9	26	1149	3	do__mino
donating	10	3	1180	3	donating
donative	12	13	987	3	donative
dooming	11	31	1253	3	do_oming
dopant	9	3	1613	3	dopa__nt
doping	10	39	1946	3	dop__ing
dormice	12	3	713	3	do_rmice
dormie	9	3	1262	3	do_rmi_e
dormin	9	3	1231	3	do_rmin_
dormins	10	3	1127	3	do_rmins
dourine	8	3	1145	3	do_urine
dreaming	12	40	1106	3	dreaming
dynamite	14	4	481	3	dynamite
enamine	9	12	1431	3	_enamine
etamine	9	13	1307	3	_etamine
examine	16	15	1003	3	_examine
famine	11	43	1819	3	__famine
foaming	13	36	1299	3	fo_aming
foramina	13	4	616	3	foramina
gamine	9	46	2015	3	__gamine
hexamine	20	4	687	3	hexamine
indamine	11	4	843	3	indamine
ketamine	14	15	705	3	ketamine
loaming	10	36	1373	3	lo_aming
melamine	12	3	1030	3	melamine
monoamine	13	4	720	3	monoamine
moraine	9	3	1457	3	mora_ine
opalines	10	3	1142	3	_opalines
opine	7	74	2246	3	_op__ine
oxazine	23	5	477	3	_oxazine
patine	8	53	2812	3	__patine
polyamine	16	4	721	3	polyamine
prolamine	13	15	1056	3	prolamine
protamine	13	13	1091	3	protamine
rhodamine	15	4	355	3	rhodamine
roaming	10	32	1579	3	ro_aming
rolamite	10	4	874	3	rolamite
romaine	9	5	1212	3	roma_ine
sepaline	10	3	1134	3	sepaline
sodamide	12	4	545	3	sodamide
solanine	8	3	1153	3	solanine
sonatine	8	3	1332	3	sonatine
sycamine	15	4	572	3	sycamine
thiamine	13	4	677	3	thiamine
topline	9	23	1318	3	top_line
tyramine	13	4	730	3	tyramine
vitamine	13	4	737	3	vitamine

Search took 8 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.406	440125.6
2	DLD Change Limit	146162	75	7.030	20791.2
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	7.469	23924.4