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

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

86 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
daunts	7	50	1408	(None)
aunts	5	52	2763	1	_aunts
daunt	6	59	2908	1	daunt_
dauts	6	78	2224	1	dau_ts
dunts	6	58	2841	1	d_unts
haunts	9	56	1439	1	haunts
jaunts	13	75	1188	1	jaunts
taunts	6	57	1566	1	taunts
vaunts	9	52	1262	1	vaunts
adults	7	29	995	2	adults
ants	4	72	4347	2	_a_nts
aunt	4	65	5365	2	_aunt_
aunty	8	59	1981	2	_aunty
blunts	8	45	1289	2	blunts
brunts	8	52	1545	2	brunts
bunts	7	57	2980	2	_bunts
cants	7	70	3694	2	ca_nts
chaunts	12	6	708	2	chaunts
counts	8	46	1827	2	counts
cunts	7	61	2512	2	_cunts
dainty	10	53	1147	2	dainty
damns	8	49	1692	2	damn_s
dangs	7	56	2320	2	da_ngs
dans	5	67	4814	2	da_n_s
darns	6	69	2789	2	darn_s
darts	6	76	3573	2	da_rts
daubes	9	49	1370	2	daubes
daubs	8	50	1456	2	dau_bs
daunted	9	38	1019	2	daunted
daunter	8	38	1175	2	daunter
daunters	9	32	985	2	daunters
daut	5	64	4356	2	dau_t_
davits	10	40	1236	2	davits
dawns	9	59	1659	2	dawn_s
dawts	9	72	1612	2	da_wts
dents	6	50	3180	2	d_ents
dints	6	74	3131	2	d_ints
donuts	7	4	1058	2	donuts
doubts	9	6	873	2	doubts
drunks	11	42	751	2	drunks
ducts	8	53	1989	2	d_ucts
duets	6	53	2388	2	d_uets
duits	6	50	2188	2	d_uits
dunes	6	53	3217	2	d_unes
dungs	7	58	2197	2	d_ungs
dunks	10	56	2119	2	d_unks
duns	5	51	4043	2	d_un_s
dunt	5	57	4687	2	d_unt_
dusts	6	59	2356	2	d_usts
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
flaunts	10	5	613	2	flaunts
founts	9	43	1338	2	founts
gaults	7	41	1278	2	gaults
gaunt	6	54	3040	2	gaunt_
grunts	7	55	1185	2	grunts
haints	9	44	1758	2	haints
hants	8	63	3540	2	ha_nts
haunt	8	52	2913	2	haunt_
hunts	8	68	2617	2	_hunts
jaunt	12	50	2527	2	jaunt_
jaunty	16	38	851	2	jaunty
lunts	5	58	2690	2	_lunts
maunds	9	51	965	2	maunds
mauts	7	59	2719	2	mau_ts
mounts	8	41	1507	2	mounts
paints	8	59	2183	2	paints
pants	7	65	3692	2	pa_nts
punts	7	58	2800	2	_punts
quants	15	36	1414	2	quants
rants	5	59	3534	2	ra_nts
runts	5	59	2763	2	_runts
saints	6	51	2242	2	saints
saults	6	58	1617	2	saults
saunas	6	39	1543	2	saunas
shunts	9	57	1201	2	shunts
stunts	6	56	1525	2	stunts
taints	6	45	2053	2	taints
taunt	5	55	3228	2	taunt_
tauts	5	61	2551	2	tau_ts
vaults	9	45	1167	2	vaults
vaunt	8	59	2531	2	vaunt_
vaunty	12	40	906	2	vaunty
wants	8	79	3221	2	wa_nts

Search took 8 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.160	1116818.8
2	DLD Change Limit	82551	86	6.750	12229.8
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	6.956	25688.8