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

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

74 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
fidgetiness	16	5	191	(None)
fidgetinesses	18	5	188	2	fidgetinesses
fidgeters	14	4	362	3	fidget__ers
fidgeting	15	4	452	3	fidgetin__g
fieriness	12	3	862	3	fi__eriness
flightiness	18	4	389	3	flightiness
mightiness	16	4	509	3	mi_ghtiness
ridgelines	12	16	429	3	ridgeline_s
bittiness	11	22	833	4	bi__ttiness
dewiness	12	3	845	4	__d_ewiness
dinginess	11	3	782	4	ding__iness
dirtiness	10	3	947	4	__dirtiness
dodginess	12	3	528	4	dodg__iness
dottiness	10	5	804	4	__dottiness
doughtiness	16	4	270	4	doughtiness
dustiness	10	22	1103	4	__dustiness
edginess	10	3	605	4	_edg__iness
fadedness	14	4	561	4	fad_e_dness
fattiness	12	23	937	4	f__attiness
faultiness	13	4	482	4	f_aultiness
feistiness	13	4	507	4	f_eistiness
fetidness	13	4	544	4	f___etidness
fidgeted	14	4	389	4	fidget__e_d
fidgeter	13	4	378	4	fidget__e_r
fidgets	12	38	876	4	fidget____s
fightings	17	27	650	4	fi_ghtin_gs
figulines	13	4	504	4	fi_guline_s
figurines	13	4	450	4	fi_gurine_s
filminess	14	3	598	4	fi__lminess
filthiness	16	4	371	4	fi_lthiness
fineness	11	3	1064	4	fi_ne__ness
fingerings	15	4	507	4	fingerin_gs
finickiness	20	5	202	4	finickiness
finiteness	13	4	711	4	fi_niteness
firstness	12	4	501	4	fi_rst_ness
fishiness	15	3	734	4	fi__shiness
fitness	10	29	939	4	fi___t_ness
fixedness	20	4	371	4	fi_xe_dness
fleetness	12	4	475	4	f_leet_ness
flintiness	13	4	589	4	f_lintiness
floweriness	17	4	307	4	floweriness
fogginess	14	3	497	4	f_og_giness
frostiness	13	3	656	4	f_rostiness
fruitiness	13	4	599	4	f_ruitiness
fustiness	12	19	1024	4	f__ustiness
giddiness	12	3	468	4	gid__diness
gingerliness	14	5	279	4	gingerliness
haughtiness	18	4	223	4	haughtiness
hiddenness	15	4	219	4	hidde_nness
idleness	9	3	684	4	_idle__ness
jitteriness	18	4	327	4	jitteriness
kingliness	15	4	395	4	king_liness
lightness	13	10	743	4	li_ght_ness
liveliness	13	4	563	4	li_veliness
mistiness	11	19	1163	4	mi__stiness
naughtiness	15	4	238	4	naughtiness
niftiness	12	3	636	4	ni__ftiness
pigginess	13	7	545	4	pi_g_giness
pudginess	13	7	473	4	pudg__iness
ridgeline	11	17	472	4	ridgeline__
ridgelings	13	17	299	4	ridgelin_gs
rightness	13	11	735	4	ri_ght_ness
sidedness	11	4	678	4	sid_e_dness
sideliners	11	12	513	4	sid_eliners
sidelines	10	10	968	4	sid_eline_s
sightliness	15	7	456	4	si_ghtliness
silveriness	14	4	385	4	silveriness
tidiness	9	3	879	4	tid___iness
tightness	13	8	660	4	ti_ght_ness
timeliness	12	4	530	4	ti_meliness
weightiness	18	4	326	4	weightiness
wideness	12	25	947	4	wid_e__ness
wifeliness	16	4	448	4	wi_feliness
wittiness	12	19	722	4	wi__ttiness

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	74	8.920	16683.7
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	9.376	19058.3