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

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

90 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
floccus	14	4	365	(None)
coccus	9	7	928	2	_coccus
flocced	15	36	548	2	flocced
flocci	13	3	502	2	flocc_i
floccose	15	4	313	2	floccose
floccule	15	4	281	2	floccule
floccules	16	4	285	2	floccules
flocculi	15	4	237	2	flocculi
flocculus	16	5	222	2	flocculus
flocks	15	47	1353	2	flo_cks
flocs	10	55	1923	2	flo_c_s
focus	10	58	1588	2	f_o_cus
locus	7	48	1999	2	_lo_cus
blocks	14	45	1394	3	blo_cks
blocs	9	52	1965	3	blo_c_s
bocces	12	39	1202	3	_bocces
boccis	12	39	1113	3	_boccis
cloacas	11	3	623	3	cloacas
cloches	14	41	1371	3	cloches
clocks	14	49	1623	3	clo_cks
clonus	8	52	1241	3	clo_nus
coccous	10	3	900	3	_coccous
crocus	10	48	1317	3	cro_cus
feluccas	15	4	221	3	feluccas
fichus	14	38	811	3	f_ichus
ficus	10	50	1549	3	f__icus
flaccid	15	4	439	3	flaccid
flacks	15	41	1453	3	fl_acks
flacons	12	3	805	3	flacons
flatus	9	43	1078	3	fl_atus
fleches	15	34	1144	3	fleches
flecks	15	43	1080	3	fl_ecks
fleeces	12	39	964	3	fleeces
flicks	15	45	1299	3	fl_icks
flics	10	54	1836	3	fl_ic_s
floats	9	68	1625	3	flo_ats
floc	9	59	2212	3	flo_c__
floccing	16	30	603	3	floccing
flock	14	47	1742	3	flo_c_k
flocked	17	45	1025	3	flocked
flocky	18	46	842	3	flo_cky
floes	8	55	2814	3	flo__es
flogs	9	59	1996	3	flo__gs
flongs	10	50	1049	3	flo_ngs
floods	10	45	1165	3	flo_ods
floors	9	41	1235	3	flo_ors
flops	10	59	2014	3	flo__ps
florals	10	42	1006	3	florals
floras	9	47	1569	3	flo_ras
florets	10	3	985	3	florets
florins	10	3	1164	3	florins
floss	8	51	1826	3	flo__ss
flosses	10	34	1197	3	flosses
flotas	9	40	1300	3	flo_tas
flounces	13	3	510	3	flounces
flour	8	49	1645	3	flo__ur
flours	9	44	1405	3	flo_urs
flout	8	62	2620	3	flo__ut
flouts	9	43	1527	3	flo_uts
flowers	13	34	1317	3	flowers
flows	11	58	2236	3	flo__ws
flus	7	56	2654	3	fl___us
foetus	9	5	852	3	f_oetus
folious	10	37	1073	3	folious
fondus	10	52	1094	3	f_ondus
forces	11	44	2213	3	f_orces
fractus	12	14	659	3	fractus
frocks	15	41	1121	3	fro_cks
fucous	11	39	986	3	f_ucous
fucus	10	55	1589	3	f__ucus
fuscous	12	5	667	3	fuscous
globous	10	3	650	3	globous
glomus	9	46	809	3	glo_mus
hocus	10	47	1520	3	_ho_cus
locals	8	37	1450	3	_locals
lochs	10	67	1551	3	_lo_chs
locks	11	51	2692	3	_lo_cks
lockup	14	3	476	3	_lockup
lockups	15	3	424	3	_lockups
locoes	8	55	1658	3	_locoes
locos	7	58	2260	3	_lo_cos
loculus	9	29	697	3	_loculus
locum	9	48	1217	3	_lo_cum
locums	10	47	830	3	_locums
locust	8	53	1234	3	_lo_cust
lotus	5	57	1806	3	_lo_tus
occur	9	13	732	3	__occur
occurs	10	13	655	3	__occurs
reoccur	11	4	335	3	reoccur
reoccurs	12	4	296	3	reoccurs

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.153	1167915.0
2	DLD Change Limit	134027	90	6.753	19847.0
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	6.936	25762.8