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

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

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.

79 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
flongs	10	50	1049	(None)
flings	10	67	1528	1	flings
flogs	9	59	1996	1	flo_gs
flong	9	58	1568	1	flong_
klongs	11	43	660	1	klongs
longs	6	55	2706	1	_longs
along	6	54	1949	2	along_
belongs	10	40	822	2	belongs
blogs	8	53	1923	2	blo_gs
blonds	9	52	1334	2	blonds
bongs	8	78	2842	2	_bongs
clangs	9	51	1361	2	clangs
clings	9	57	1621	2	clings
clogs	8	55	1955	2	clo_gs
clones	8	45	2656	2	clones
clonks	12	50	1347	2	clonks
clons	7	52	2813	2	clon_s
clonus	8	52	1241	2	clonus
dongs	7	65	2581	2	_dongs
fangs	9	62	2407	2	f_angs
felons	9	36	1576	2	felon_s
filings	11	52	1307	2	filings
flags	9	53	2128	2	fl_ags
flanes	9	45	2242	2	flanes
flange	10	34	1197	2	flange
flanges	11	34	1327	2	flanges
flanks	13	39	1340	2	flanks
flans	8	53	2797	2	flan_s
fling	9	70	2351	2	fling_
flints	9	56	1745	2	flints
floats	9	68	1625	2	floats
flocks	15	47	1353	2	flocks
flocs	10	55	1923	2	flo_cs
floes	8	55	2814	2	flo_es
flog	8	55	2389	2	flo_g_
floods	10	45	1165	2	floods
floors	9	41	1235	2	floors
flops	10	59	2014	2	flo_ps
floras	9	47	1569	2	floras
floss	8	51	1826	2	flo_ss
flotas	9	40	1300	2	flotas
flours	9	44	1405	2	flours
flouts	9	43	1527	2	flouts
flows	11	58	2236	2	flo_ws
flung	9	51	1458	2	flung_
flunks	13	46	986	2	flunks
flyings	14	49	606	2	flyings
fogs	8	70	3500	2	f_o_gs
fonds	9	58	2482	2	f_onds
fons	7	69	4389	2	f_on_s
fonts	8	61	2475	2	f_onts
frogs	9	62	2077	2	fro_gs
fronds	10	64	1234	2	fronds
frons	8	61	2404	2	fron_s
fronts	9	44	1579	2	fronts
furlongs	12	30	407	2	furlongs
gloggs	9	3	503	2	gloggs
gongs	7	49	2161	2	_gongs
hongs	9	51	2620	2	_hongs
kalongs	12	5	544	2	kalongs
klong	10	53	1040	2	klong_
lings	6	71	3577	2	_lings
logs	5	73	4311	2	_lo_gs
long	5	69	3334	2	_long_
longe	6	66	2646	2	_longe
longes	7	59	2557	2	_longes
lungs	6	52	2388	2	_lungs
oblongs	10	3	353	2	oblongs
oolongs	8	4	595	2	oolongs
plonks	12	42	1042	2	plonks
pongs	8	55	2634	2	_pongs
prongs	9	43	1448	2	prongs
slangs	7	56	1534	2	slangs
slings	7	46	1801	2	slings
slogs	6	45	2184	2	slo_gs
songs	6	77	2555	2	_songs
thongs	10	46	1119	2	thongs
tongs	6	59	2846	2	_tongs
wrongs	10	33	893	2	wrongs

Search took 3 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	82551	0.126	1418182.5
2	DLD Change Limit	82551	79	2.390	34540.2
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	2.546	70185.0