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

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

96 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
fidgety	15	38	489	(None)
fidget	11	42	1647	1	fidget_
fidgets	12	38	876	1	fidgets
biggety	14	3	443	2	biggety
fidge	10	45	1605	2	fidge__
fidged	12	46	1092	2	fidge_d
fidges	11	41	1438	2	fidge_s
fidgeted	14	4	389	2	fidgeted
fidgeter	13	4	378	2	fidgeter
gadgety	13	35	616	2	gadgety
midget	10	37	1844	2	midget_
midgets	11	39	1025	2	midgets
nidget	8	37	1563	2	nidget_
nidgets	9	35	814	2	nidgets
widget	11	38	1525	2	widget_
widgets	12	31	845	2	widgets
bidet	8	49	3562	3	bid_et_
bidets	9	52	1553	3	bid_ets
biggity	14	3	501	3	biggity
biogeny	13	3	602	3	biogeny
budget	10	46	1811	3	budget_
budgets	11	48	986	3	budgets
dingey	11	49	1405	3	dinge_y
dodgery	13	62	778	3	dodgery
eighty	13	37	1160	3	ei_ghty
fadge	10	48	1699	3	fadge__
fadged	12	47	1235	3	fadge_d
fadges	11	48	1402	3	fadge_s
faggoty	15	4	285	3	faggoty
ferrety	13	28	701	3	ferrety
fiddly	14	32	848	3	fid_dly
fidelity	15	4	493	3	fidelity
fidgeters	14	4	361	3	fidgeters
fidgeting	15	4	451	3	fidgeting
fidging	13	39	1050	3	fidging
fiery	11	47	1479	3	fi__ery
fifty	14	52	1142	3	fi__fty
figged	12	40	1389	3	figge_d
fight	12	40	2709	3	fi_ght_
fights	13	38	1655	3	fi_ghts
filet	8	55	4016	3	fi_let_
filets	9	47	1895	3	fi_lets
fillet	9	50	2708	3	fillet_
fillets	10	34	1475	3	fillets
finely	12	30	1156	3	fi_nely
finery	12	45	1289	3	fi_nery
finger	10	49	2033	3	finge_r
fingers	11	34	1843	3	fingers
fishery	16	39	773	3	fishery
fixity	19	42	780	3	fi_xity
flighty	17	34	743	3	flighty
fodgel	11	3	640	3	fodge_l
fogey	12	56	1787	3	f_oge_y
forgery	14	41	930	3	forgery
forget	10	63	2639	3	forget_
forgets	11	38	1379	3	forgets
fridge	11	37	925	3	fridge__
fridges	12	36	948	3	fridge_s
fudge	10	53	1552	3	fudge__
fudged	12	52	1281	3	fudge_d
fudges	11	43	1449	3	fudge_s
furmety	15	3	481	3	furmety
gadget	9	36	1617	3	gadget_
gadgetry	14	26	320	3	gadgetry
gadgets	10	34	868	3	gadgets
gargety	12	38	804	3	gargety
gingely	12	37	820	3	gingely
gingery	12	36	890	3	gingery
kidney	14	3	475	3	kidne_y
midge	9	50	1654	3	midge__
midges	10	35	1647	3	midge_s
midgut	10	35	1005	3	midgut_
midguts	11	29	601	3	midguts
mighty	15	43	1020	3	mi_ghty
nicety	11	3	843	3	ni_cety
nighty	13	56	1127	3	ni_ghty
nimiety	12	4	463	3	nimiety
ninety	9	5	1096	3	ni_nety
nuggety	12	3	431	3	nuggety
piety	10	58	1730	3	pi__ety
piggery	14	26	619	3	piggery
pigsty	12	3	593	3	pi_gsty
rickety	16	47	831	3	rickety
ridge	7	50	1866	3	ridge__
ridged	9	40	1421	3	ridge_d
ridgel	8	39	996	3	ridge_l
ridgels	9	34	802	3	ridgels
ridges	8	58	1700	3	ridge_s
ridgetop	12	4	223	3	ridgetop
ridgy	10	41	1064	3	ridg__y
ridley	10	16	954	3	ridle_y
righty	13	50	1183	3	ri_ghty
viduity	14	4	534	3	viduity
widely	13	33	1103	3	wid_ely
widgeon	12	4	414	3	widgeon
wiggery	15	29	587	3	wiggery

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	96	6.516	20568.9
3	Display Results	96	96	0.030	3200.0
	(SQL Overall)	178691	96	6.702	26662.3