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

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

95 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
psalmic	13	4	533	(None)
phallic	14	4	729	2	phallic
plasmic	13	24	911	2	plasmic
psalm	9	4	927	2	psalm__
psalmed	12	3	450	2	psalmed
psalming	13	7	547	2	psalming
psalmist	12	7	635	2	psalmist
psalmodic	16	5	243	2	psalmodic
psalms	10	4	567	2	psalm_s
pyaemic	16	4	587	2	pyaemic
salic	7	34	2471	2	_sal_ic
salmi	7	8	1586	2	_salmi_
salmis	8	5	1427	2	_salmis
acmic	11	3	1233	3	__acmic
agamic	11	31	1056	3	aga_mic
anaemic	11	4	990	3	anaemic
basaltic	12	4	515	3	basaltic
cadmic	13	3	898	3	_cadmic
calcic	9	3	1187	3	_calcic
chasmic	16	17	798	3	chasmic
dharmic	15	3	502	3	dharmic
filmic	13	34	845	3	_filmic
gallic	9	4	1164	3	_gallic
gamic	10	39	1620	3	_ga_mic
haemic	13	32	1008	3	_haemic
holmic	13	3	878	3	_holmic
isthmic	14	4	479	3	isthmic
italic	8	3	990	3	ital_ic
kalmia	12	3	889	3	_kalmia
karmic	14	3	811	3	_karmic
malic	9	45	2566	3	_mal_ic
miasmic	13	3	574	3	miasmic
myalgic	15	13	422	3	myalgic
osmic	9	3	991	3	os__mic
otalgic	10	4	506	3	otalgic
oxalic	15	3	709	3	oxal_ic
palais	8	4	2042	3	p_alais
pallia	8	30	1559	3	p_allia
pallid	9	39	1528	3	p_allid
palm	8	53	3136	3	p_alm__
palmar	10	41	1346	3	p_almar
palmed	11	43	1464	3	p_almed
palmer	10	58	1654	3	p_almer
palmier	11	33	1217	3	p_almier
palming	12	39	1401	3	p_alming
palmist	11	28	1434	3	p_almist
palms	9	49	2175	3	p_alm_s
palmy	12	60	1673	3	p_alm_y
palpi	9	54	1455	3	p_alpi_
panic	9	39	2390	3	p_a_nic
pashalic	15	4	618	3	pashal_ic
pelagic	12	3	786	3	pelagic
pelvic	13	30	755	3	p_elvic
phalli	11	4	826	3	phalli_
phasic	13	36	1205	3	pha_sic
phasmid	15	26	760	3	phasmid
phatic	13	30	1441	3	pha_tic
phylic	16	27	955	3	phyl_ic
pianic	10	37	1412	3	pia_nic
plasmid	12	23	955	3	plasmid
plasmin	11	24	1003	3	plasmin
plastic	11	28	1506	3	plastic
polemic	13	3	1125	3	polemic
potamic	13	3	1085	3	potamic
practic	13	3	1225	3	practic
psalmists	13	4	407	3	psalmists
psalmody	16	4	209	3	psalmody
psalter	9	24	781	3	psalter
psaltry	12	21	380	3	psaltry
psammite	14	4	298	3	psammite
psammitic	17	4	311	3	psammitic
psammon	13	4	254	3	psammon
psilotic	12	4	577	3	psilotic
psoatic	11	3	930	3	psoatic
psychic	19	4	483	3	psychic
psyllid	13	4	452	3	psyllid
public	12	23	814	3	publ_ic
pyaemia	14	4	573	3	pyaemia
pyemic	15	3	789	3	p_yemic
saimin	8	3	1366	3	_saimin
salami	8	3	1310	3	_salami_
salamis	9	3	1351	3	_salamis
salmon	8	46	1418	3	_salmon
salpid	9	5	1088	3	_salpid
saltie	6	34	2243	3	_saltie
salvia	9	33	1075	3	_salvia
scaldic	12	3	594	3	scaldic
sialic	8	3	1363	3	sial_ic
skaldic	14	4	355	3	skaldic
spastic	11	3	1038	3	spastic
spathic	14	3	754	3	spathic
spermic	13	3	852	3	spermic
thalamic	15	4	555	3	thalamic
thallic	12	4	655	3	thallic
uraemic	11	5	654	3	uraemic

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	95	5.890	22755.0
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	6.326	28247.1