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

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

75 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
bumpkin	17	4	361	(None)
bumkin	14	30	808	1	bum_kin
bumpkins	18	4	370	1	bumpkins
pumpkin	17	4	352	1	pumpkin
bumkins	15	31	801	2	bum_kins
bumping	14	38	1249	2	bump_ing
bumpkinly	22	4	133	2	bumpkinly
buskin	12	38	1149	2	bu_skin
limpkin	15	3	422	2	limpkin
pumpkins	18	4	385	2	pumpkins
baudekin	15	4	270	3	baudekin
bodkin	13	3	892	3	b_odkin
boomkin	15	4	536	3	boomkin
bucking	16	36	1757	3	bu_cking
buckskin	15	4	357	3	buckskin
bulking	14	38	1512	3	bu_lking
bumbling	15	24	976	3	bumbling
bumelia	11	4	526	3	bumelia
bumming	14	34	1078	3	bum_ming
bump	10	62	2824	3	bump___
bumped	13	44	1400	3	bump_ed
bumper	12	37	1434	3	bump_er
bumpering	16	3	659	3	bumpering
bumpers	13	39	1205	3	bumpers
bumph	14	49	1198	3	bump__h
bumphs	15	46	710	3	bump_hs
bumpier	13	35	920	3	bumpier
bumpily	16	6	565	3	bumpily
bumpkinish	23	5	131	3	bumpkin~~ish~~
bumps	11	59	2114	3	bump__s
bumpy	14	47	1505	3	bump__y
bunking	14	40	1619	3	bu_nking
bupkes	14	48	1148	3	bu_pkes
bupkus	14	38	568	3	bu_pkus
buppie	12	28	873	3	bu_ppie
burin	7	56	2606	3	bu__rin
burking	14	37	1632	3	bu_rking
burping	12	40	1294	3	burp_ing
busking	14	41	1657	3	bu_sking
buskins	13	33	1094	3	bu_skins
butyrin	12	4	581	3	butyrin
buzuki	21	4	276	3	buzuki_
buzukia	22	4	222	3	buzukia
buzukis	22	4	266	3	buzukis
complin	13	3	1207	3	complin
cumarin	11	3	926	3	cumarin
cumin	9	46	1697	3	cum__in
cummin	12	8	878	3	cum_min
duckpin	16	4	346	3	duckpin
dumping	13	37	1291	3	dump_ing
dumpling	14	21	789	3	dumpling
gumption	13	4	398	3	gumption
humphing	19	3	516	3	humphing
humping	15	32	1307	3	hump_ing
jumping	19	31	980	3	jump_ing
lambkin	15	4	524	3	lambkin
limpkins	16	4	423	3	limpkins
lumpen	10	40	1066	3	lump_en
lumping	12	33	1464	3	lump_ing
lupin	7	52	1584	3	lu_p_in
mumping	14	34	1163	3	mump_ing
napkin	12	3	690	3	_napkin
pipkin	14	24	860	3	_pipkin
pumping	14	42	1355	3	pump_ing
punkin	12	36	1152	3	pu_nkin
ramekin	13	12	649	3	ramekin
rumaki	12	3	513	3	rumaki_
rumakis	13	3	553	3	rumakis
rumpling	13	17	876	3	rumpling
thumbkin	19	4	211	3	thumbkin
tumping	12	31	1424	3	tump_ing
tumpline	12	3	711	3	tumpline
umping	11	48	1533	3	_ump_ing
unakin	10	3	1096	3	_unakin
unpin	7	26	1324	3	_unp_in

Search took 8 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.406	440125.6
2	DLD Change Limit	134027	75	6.656	20136.3
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	7.092	25196.1