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

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

83 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
flaccid	15	4	439	(None)
flaccidly	20	4	177	2	flaccidly
flacked	17	37	1158	2	flacked
flocced	15	36	548	2	flocced
flocci	13	3	502	2	flocci_
placid	11	40	1254	2	pla_cid
placoid	12	3	977	2	placoid
acid	7	75	3339	3	__a_cid
acrid	8	69	2010	3	__acrid
alcid	8	58	1797	3	__alcid
blacked	16	36	1337	3	blacked
chalcid	15	3	788	3	chalcid
clacked	16	41	1360	3	clacked
coccid	10	29	1074	3	_coccid
diacid	10	3	1063	3	dia_cid
elapid	9	3	954	3	ela_pid
faced	11	77	2765	3	f_a_ced
facia	10	32	1846	3	f_a_cia
factoid	13	3	869	3	f_actoid
fancied	13	33	1060	3	f_ancied
farced	12	52	1653	3	f_arced
farci	10	59	1931	3	f_arci_
farcie	11	48	1647	3	f_arcie
fascia	11	4	870	3	f_ascia
filariid	12	4	403	3	filariid
flaccidity	21	6	167	3	flaccid~~ity~~
flack	14	45	1941	3	fla_c_k
flacking	18	43	1179	3	flacking
flacks	15	41	1453	3	fla_cks
flacon	11	3	863	3	fla_con
flacons	12	3	805	3	flacons
flagged	13	45	963	3	flagged
flail	8	53	1618	3	fla__il
flailed	11	3	730	3	flailed
flair	8	61	1412	3	fla__ir
flaked	14	47	1565	3	fla_ked
flamed	12	46	1897	3	fla_med
flammed	15	37	741	3	flammed
flancard	14	4	337	3	flancard
flanged	12	38	1084	3	flanged
flanked	15	37	1064	3	flanked
flapped	15	32	825	3	flapped
flared	10	53	1760	3	fla_red
flashed	14	41	1218	3	flashed
flatbed	13	39	798	3	flatbed
flatcap	14	6	365	3	flatcap
flatcar	12	7	461	3	flatcar
flatted	11	40	1294	3	flatted
flavin	12	3	930	3	fla_vin
flawed	13	47	1272	3	fla_wed
flayed	13	44	1405	3	fla_yed
flecked	17	35	807	3	flecked
fleeced	13	35	815	3	fleeced
flicked	17	46	1067	3	flicked
floccing	16	30	603	3	floccing
floccus	14	4	365	3	floccus
flocked	17	45	1025	3	flocked
florid	10	3	1145	3	fl_orid
fluid	9	40	1396	3	fl__uid
fluorid	11	3	678	3	fluorid
focaccia	14	5	198	3	focaccia
folacin	12	3	805	3	fola_cin
fracted	13	3	937	3	fracted
fracti	11	3	996	3	fracti_
fucoid	12	3	789	3	f_ucoid
glaceed	11	3	619	3	glaceed
glacis	9	40	1213	3	gla_cis
glanced	11	43	923	3	glanced
glochid	14	4	526	3	glochid
laced	8	71	3264	3	_la_ced
lacked	13	53	2465	3	_lacked
lactic	10	7	1349	3	_lactic
laid	5	64	3914	3	_la__id
lanced	9	37	1772	3	_lanced
lucid	8	43	1457	3	_l_ucid
placard	12	3	678	3	placard
placed	11	43	1800	3	pla_ced
placoids	13	4	734	3	placoids
plaid	8	51	1830	3	pla__id
plasmid	12	23	955	3	plasmid
plastid	10	21	1252	3	plastid
rancid	9	5	1386	3	_rancid
slacked	14	38	1545	3	slacked

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.423	422437.4
2	DLD Change Limit	134027	83	5.780	23188.1
3	Display Results	83	83	0.033	2515.2
	(SQL Overall)	178691	83	6.236	28654.7