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

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

99 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
fount	8	47	2703	(None)
count	7	49	3205	1	count
font	7	71	4375	1	fo_nt
found	9	49	1784	1	found
founts	9	43	1338	1	founts
mount	7	41	2806	1	mount
amount	8	4	1448	2	amount
aunt	4	65	5365	2	_aunt
blunt	7	55	2502	2	blunt
bound	8	48	1958	2	bound
bounty	11	34	1107	2	bounty
bout	6	63	5329	2	bou_t
brunt	7	57	2875	2	brunt
bunt	6	58	5085	2	_bunt
counts	8	46	1827	2	counts
county	11	43	1332	2	county
court	7	55	3276	2	court
cunt	6	62	4367	2	_cunt
daunt	6	59	2908	2	daunt
donut	6	3	2451	2	donut
doubt	8	7	2009	2	doubt
dunt	5	57	4687	2	_dunt
faint	8	58	3706	2	faint
fault	8	54	2831	2	fault
faun	7	62	2662	2	faun_
fauna	8	48	1651	2	fauna
fauns	8	45	1675	2	fauns
feint	8	47	3225	2	feint
flaunt	9	7	1291	2	flaunt
flint	8	73	3350	2	flint
flout	8	62	2620	2	flou_t
fluent	9	3	1393	2	fluent
flung	9	51	1458	2	flung
flunk	12	50	1438	2	flunk
fluyt	11	46	1420	2	fluyt
fohn	10	61	1655	2	fohn_
fohns	11	73	1078	2	fohns
foin	7	72	3156	2	foin_
foins	8	55	2338	2	foins
foist	8	57	3097	2	foist
foment	11	37	1830	2	foment
fon	6	63	5227	2	fo_n_
fond	8	63	3095	2	fo_nd
fons	7	69	4389	2	fo_ns
fonts	8	61	2475	2	fo_nts
foot	7	62	4801	2	fo_ot
forint	9	3	2502	2	forint
fort	7	64	5644	2	fo_rt
fou	6	67	4378	2	fou__
fought	13	51	1239	2	fought
foul	7	70	2758	2	fou_l
fouls	8	72	2143	2	fouls
founds	10	48	1419	2	founds
four	7	62	2686	2	fou_r
fours	8	55	2149	2	fours
fourth	12	35	744	2	fourth
foxhunt	20	4	317	2	foxhunt
front	8	50	2922	2	front
fruit	8	51	2222	2	fruit
fun	6	68	4114	2	f_un_
fund	8	56	2498	2	f_und
funk	11	58	2562	2	f_unk
funs	7	52	3573	2	f_uns
gaunt	6	54	3040	2	gaunt
gout	5	66	4600	2	gou_t
grunt	6	55	2354	2	grunt
haunt	8	52	2913	2	haunt
hound	9	50	1648	2	hound
hunt	7	64	4549	2	_hunt
jaunt	12	50	2527	2	jaunt
joint	12	52	2772	2	joint
joust	12	51	2229	2	joust
lout	4	59	5214	2	lou_t
lunt	4	61	4884	2	_lunt
moult	7	47	2872	2	moult
mound	8	39	1831	2	mound
mounts	8	41	1507	2	mounts
noun	4	57	2418	2	noun_
nouns	5	67	1731	2	nouns
oust	4	67	4744	2	_oust
out	3	80	7215	2	_ou_t
point	7	53	3873	2	point
poult	7	69	2887	2	poult
pound	8	44	1786	2	pound
pout	6	57	5255	2	pou_t
punt	6	57	4720	2	_punt
round	6	43	1843	2	round
roust	5	55	3206	2	roust
rout	4	61	5328	2	rou_t
runt	4	66	4798	2	_runt
shunt	8	52	2650	2	shunt
sound	6	44	2002	2	sound
stunt	5	53	2817	2	stunt
taunt	5	55	3228	2	taunt
tout	4	67	5382	2	tou_t
vaunt	8	59	2531	2	vaunt
wont	7	58	4250	2	wo_nt
wound	9	44	1421	2	wound
young	9	7	774	2	young

Search took 2 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	53800	0.076	2351197.4
2	DLD Change Limit	53800	99	1.720	31279.1
3	Display Results	99	99	0.030	3300.0
	(SQL Overall)	178691	99	1.826	97859.3