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

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

77 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
funfests	14	25	356	(None)
funfest	13	34	808	1	funfest_
funest	9	43	1686	2	fun_est_
funnest	10	29	1200	2	funnest_
infests	10	27	979	2	_infests
unrests	7	22	946	2	_unrests
buffest	15	29	864	3	buffest_
buffets	15	31	759	3	buffe_ts
bundists	11	4	538	3	bundists
confects	15	31	1087	3	confects
confess	12	39	990	3	confes_s
congests	11	35	1038	3	congests
contests	10	34	1338	3	contests
dunness	8	29	898	3	dunnes_s
dunnest	8	33	1226	3	dunnest_
fanjets	17	3	480	3	fanje_ts
fantasts	11	4	711	3	fantasts
fests	8	58	2804	3	___fests
finest	9	43	2173	3	fin_est_
finfoots	14	4	415	3	finfoots
finless	10	28	1078	3	finles_s
fondest	11	3	1240	3	fondest_
forests	10	41	1495	3	f_orests
forfeits	14	4	580	3	forfeits
fuguists	12	4	369	3	fuguists
fullest	10	3	1334	3	fullest_
fulness	10	24	896	3	fulnes_s
fumets	11	43	1181	3	fu_me_ts
fumiest	12	3	1219	3	fumiest_
funders	11	38	1393	3	funde_rs
funfairs	14	4	213	3	funfairs
funguses	12	5	471	3	funguses
funkers	14	37	1206	3	funke_rs
funkiest	15	28	1097	3	funkiest_
funnels	10	34	817	3	funne_ls
funniest	11	30	1073	3	funniest_
furless	10	32	1014	3	furles_s
gabfests	14	4	238	3	gabfests
guests	7	43	1120	3	gu__ests
gunless	8	29	963	3	gunles_s
incests	9	27	1138	3	_incests
infects	12	27	971	3	_infects
infest	9	33	1543	3	_infest_
ingests	8	32	1098	3	_ingests
invests	10	31	968	3	_invests
junkets	18	37	762	3	junke_ts
lunets	6	69	1476	3	lun_e_ts
luniest	7	35	1699	3	luniest_
manifests	14	4	412	3	manifests
nests	5	57	2800	3	__n_ests
outfasts	11	11	723	3	outfasts
outfeasts	12	11	433	3	outfeasts
puniest	9	29	1809	3	puniest_
punkest	13	26	1169	3	punkest_
punnets	9	40	926	3	punne_ts
quests	15	33	1035	3	qu__ests
renests	7	40	1421	3	ren_ests
runless	7	28	1042	3	runles_s
runlets	7	33	1077	3	runle_ts
slugfests	13	4	157	3	slugfests
songfests	13	4	298	3	songfests
subtests	10	3	753	3	subtests
suggests	10	4	471	3	suggests
sunbelts	10	4	467	3	sunbelts
sunfast	10	3	850	3	sunfast_
sunkets	11	35	1128	3	sunke_ts
sunless	7	30	1369	3	sunles_s
sunsets	7	29	1157	3	sunse_ts
surfeits	11	4	622	3	surfeits
tuffets	13	26	652	3	tuffe_ts
unbelts	9	23	766	3	_unbelts
unfelt	9	24	1346	3	_unfelt_
unfits	9	39	1029	3	_unf_its
unless	6	24	1307	3	_unles_s
unrest	6	29	1885	3	_unrest_
unseats	7	30	1285	3	_unseats
unsets	6	41	1616	3	_unse_ts

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	77	6.780	21557.8
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	6.969	25640.8