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

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

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.

60 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
fidgetinesses	18	5	188	(None)
fidgetiness	16	5	191	2	fidgetine_s_s
fierinesses	14	3	923	3	fi__erinesses
flightinesses	20	5	313	3	flightinesses
mightinesses	18	4	438	3	mi_ghtinesses
bittinesses	13	14	826	4	bi__ttinesses
dewinesses	14	3	835	4	__d_ewinesses
dinginesses	13	3	747	4	ding__inesses
dirtinesses	12	3	988	4	__dirtinesses
dodginesses	14	3	543	4	dodg__inesses
dottinesses	12	3	813	4	__dottinesses
doughtinesses	18	5	255	4	doughtinesses
dustinesses	12	11	1035	4	__dustinesses
edginesses	12	3	670	4	_edg__inesses
fadednesses	16	12	656	4	fad_e_dnesses
fattinesses	14	11	897	4	f__attinesses
faultinesses	15	4	518	4	f_aultinesses
feistinesses	15	5	589	4	f_eistinesses
fetidnesses	15	4	665	4	f___etidnesses
filminesses	16	3	623	4	fi__lminesses
filthinesses	18	4	446	4	fi_lthinesses
finenesses	13	3	1071	4	fi_ne__nesses
finickinesses	22	7	206	4	finickinesses
finitenesses	15	5	772	4	fi_nitenesses
firstnesses	14	4	573	4	fi_rst_nesses
fishinesses	17	10	724	4	fi__shinesses
fitnesses	12	21	937	4	fi___t_nesses
fixednesses	22	4	485	4	fi_xe_dnesses
fleetnesses	14	4	548	4	f_leet_nesses
flintinesses	15	4	632	4	f_lintinesses
flowerinesses	19	4	290	4	flowerinesses
fogginesses	16	4	549	4	f_og_ginesses
frostinesses	15	4	653	4	f_rostinesses
fruitinesses	15	4	644	4	f_ruitinesses
fustinesses	14	12	978	4	f__ustinesses
giddinesses	14	3	530	4	gid__dinesses
gingerlinesses	16	5	268	4	gingerlinesses
haughtinesses	20	4	216	4	haughtinesses
hiddennesses	17	5	265	4	hidde_nnesses
idlenesses	11	3	803	4	_idle__nesses
jitterinesses	20	8	331	4	jitterinesses
kinglinesses	17	4	385	4	king_linesses
lightnesses	15	4	614	4	li_ght_nesses
livelinesses	15	14	563	4	li_velinesses
mistinesses	13	13	1062	4	mi__stinesses
naughtinesses	17	5	241	4	naughtinesses
niftinesses	14	3	724	4	ni__ftinesses
pigginesses	15	5	561	4	pi_g_ginesses
pudginesses	15	4	505	4	pudg__inesses
rightnesses	15	4	623	4	ri_ght_nesses
sidednesses	13	4	710	4	sid_e_dnesses
sightlinesses	17	4	386	4	si_ghtlinesses
silverinesses	16	4	369	4	silverinesses
tidinesses	11	3	922	4	tid___inesses
tightnesses	15	6	558	4	ti_ght_nesses
timelinesses	14	4	545	4	ti_melinesses
weightinesses	20	5	290	4	weightinesses
widenesses	14	3	877	4	wid_e__nesses
wifelinesses	18	4	481	4	wi_felinesses
wittinesses	14	12	748	4	wi__ttinesses

Search took 6 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	95024	0.126	1418182.5
2	DLD Change Limit	95024	60	5.436	17480.5
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	5.595	31937.6