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

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

88 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
founts	9	43	1338	(None)
counts	8	46	1827	1	counts
fonts	8	61	2475	1	fo_nts
founds	10	48	1419	1	founds
fount	8	47	2703	1	fount_
mounts	8	41	1507	1	mounts
amounts	9	3	704	2	amounts
aunts	5	52	2763	2	_aunts
blunts	8	45	1289	2	blunts
bounds	9	44	1580	2	bounds
bounty	11	34	1107	2	bounty
bouts	7	51	3131	2	bou_ts
brunts	8	52	1545	2	brunts
bunts	7	57	2980	2	_bunts
count	7	49	3205	2	count_
county	11	43	1332	2	county
courts	8	42	1617	2	courts
cunts	7	61	2512	2	_cunts
daunts	7	50	1408	2	daunts
donuts	7	4	1058	2	donuts
doubts	9	6	873	2	doubts
dunts	6	58	2841	2	_dunts
faints	9	48	1878	2	faints
faults	9	45	1355	2	faults
faunas	9	40	1363	2	faunas
fauns	8	45	1675	2	faun_s
feints	9	48	1387	2	feints
flaunts	10	5	613	2	flaunts
flints	9	56	1745	2	flints
flouts	9	43	1527	2	flou_ts
flunks	13	46	986	2	flunks
fluyts	12	36	715	2	fluyts
fohns	11	73	1078	2	fohn_s
foins	8	55	2338	2	foin_s
foists	9	54	1398	2	foists
foments	12	29	1205	2	foments
fonds	9	58	2482	2	fo_nds
fons	7	69	4389	2	fo_n_s
font	7	71	4375	2	fo_nt_
foots	8	55	2828	2	fo_ots
forints	10	4	1183	2	forints
forts	8	60	3445	2	fo_rts
fouls	8	72	2143	2	fou_ls
found	9	49	1784	2	foun_d
fours	8	55	2149	2	fou_rs
fourth	12	35	744	2	fourth
fourths	13	37	495	2	fourths
foxhunts	21	4	199	2	foxhunts
fronts	9	44	1579	2	fronts
fruits	9	45	1249	2	fruits
funds	9	41	1925	2	f_unds
funks	12	53	1891	2	f_unks
funs	7	52	3573	2	f_un_s
gouts	6	48	2617	2	gou_ts
grunts	7	55	1185	2	grunts
haunts	9	56	1439	2	haunts
hounds	10	44	1313	2	hounds
hunts	8	68	2617	2	_hunts
jaunts	13	75	1188	2	jaunts
joints	13	38	1145	2	joints
jousts	13	50	1127	2	jousts
louts	5	63	3027	2	lou_ts
lunts	5	58	2690	2	_lunts
moults	8	47	1370	2	moults
mounds	9	39	1513	2	mounds
mount	7	41	2806	2	mount_
nouns	5	67	1731	2	noun_s
ousts	5	52	2570	2	_ousts
outs	4	57	4696	2	_ou_ts
points	8	56	1853	2	points
poults	8	46	1348	2	poults
pounds	9	37	1438	2	pounds
pouts	7	55	3032	2	pou_ts
punts	7	58	2800	2	_punts
rounds	7	36	1562	2	rounds
rousts	6	170	1672	2	rousts
routs	5	71	3341	2	rou_ts
runts	5	59	2763	2	_runts
shunts	9	57	1202	2	shunts
sounds	7	46	1618	2	sounds
stunts	6	56	1525	2	stunts
taunts	6	57	1566	2	taunts
touts	5	48	3039	2	tou_ts
vaunts	9	52	1262	2	vaunts
wonts	8	76	2154	2	wo_nts
wounds	10	38	1163	2	wounds
youngs	10	3	538	2	youngs
zounds	16	43	1017	2	zounds

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.110	1624463.6
2	DLD Change Limit	82551	88	2.733	30205.3
3	Display Results	88	88	0.016	5500.0
	(SQL Overall)	178691	88	2.859	62501.2