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

Here are the results of your fuzzy-string dictionary search for “pumpkins” 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
pumpkins	18	4	385	(None)
bumpkins	18	4	370	1	bumpkins
pumpkin	17	4	352	1	pumpkin_
bumkins	15	31	801	2	bum_kins
bumpkin	17	4	361	2	bumpkin_
limpkins	16	4	423	2	limpkins
pipkins	15	32	818	2	p_ipkins
pumping	14	42	1355	2	pump_ing
punkins	13	31	1111	2	pu_nkins
bumkin	14	30	808	3	bum_kin_
bumping	14	38	1249	3	bump_ing
bumpkinish	23	5	131	3	bumpkinish
bumpkinly	22	4	133	3	bumpkinly
buskins	13	33	1094	3	bu_skins
complins	14	3	1311	3	complins
cumarins	12	3	864	3	cumarins
cumins	10	33	1493	3	cum__ins
cummins	13	5	896	3	cum_mins
duckpins	17	4	369	3	duckpins
dumping	13	37	1291	3	dump_ing
dumpings	14	29	576	3	dump_ings
dumpling	14	21	789	3	dumpling
dumplings	15	21	385	3	dumplings
emptins	11	7	940	3	_emptins
gumptions	14	4	377	3	gumptions
humphing	19	3	516	3	humphing
humping	15	32	1307	3	hump_ing
jumping	19	31	980	3	jump_ing
lambkins	16	6	498	3	lambkins
limpkin	15	3	422	3	limpkin_
lumpens	11	29	826	3	lump_ens
lumping	12	33	1464	3	lump_ing
lupins	8	45	1446	3	lu_p_ins
mumping	14	34	1163	3	mump_ing
napkins	13	3	667	3	_napkins
pampeans	14	4	470	3	pampeans
papains	11	3	1236	3	p_apains
pekins	12	18	1223	3	p__ekins
pepsins	11	3	1043	3	p_epsins
pigskins	15	4	425	3	pigskins
pimping	14	38	1212	3	pimp_ing
pipkin	14	24	860	3	p_ipkin_
pippins	10	31	975	3	p_ippins
plumpens	14	30	495	3	plump_ens
plumping	15	27	763	3	plump_ing
pompons	13	3	855	3	pomp_ons
poplins	11	3	1315	3	p_oplins
puffins	15	27	891	3	pu_ffins
puking	13	39	1306	3	pu__king
pulping	12	36	1232	3	pulp_ing
pulpits	11	3	724	3	pulp_its
pumicing	15	3	584	3	pumicing
pumpers	13	31	1367	3	pump_ers
pumpkinseed	22	6	40	3	pumpkins~~eed~~
pumpless	14	23	637	3	pumpless
pumplike	18	3	437	3	pumplike
pumps	11	55	2060	3	pump___s
punkies	13	42	1680	3	pu_nkies
punkin	12	36	1152	3	pu_nkin_
pupils	10	38	991	3	pu_p_ils
puppies	10	32	1261	3	pu_ppies
pupping	11	44	1250	3	pu_pping
purins	8	37	2265	3	pu__rins
purlins	9	34	1542	3	pu_rlins
purloins	10	7	703	3	purloins
purpling	13	6	854	3	purpling
purpurins	13	6	446	3	purpurins
pushpins	15	4	334	3	pushpins
ramekins	14	6	611	3	ramekins
rumakis	13	3	553	3	rumaki_s
rumpling	13	17	876	3	rumpling
thumbkins	20	4	216	3	thumbkins
tumping	12	31	1424	3	tump_ing
tumpline	12	3	711	3	tumpline
tumplines	13	4	602	3	tumplines
umping	11	48	1533	3	_ump_ing
unpins	8	23	1238	3	_unp_ins

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.423	422437.4
2	DLD Change Limit	146162	77	6.513	22441.6
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	6.969	25640.8