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

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

79 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
pickaxed	24	4	351	(None)
pickaxe	22	4	462	1	pickaxe_
pickaxes	23	4	491	1	pickaxes
packaged	18	11	575	2	packaged
pickax	21	3	591	2	pickax__
picked	15	44	2131	2	pick__ed
picketed	17	16	738	2	picketed
pickled	16	40	1188	2	pick_led
picrated	13	21	1011	2	picrated
bickered	17	10	800	3	bickered
coaxed	16	56	1251	3	__coaxed
cockaded	18	3	639	3	cockaded
dicked	14	49	2086	3	dick__ed
dickered	16	11	753	3	dickered
dictated	12	3	920	3	dictated
kickboxed	24	5	189	3	kickboxed
kicked	12	44	1594	3	kick__ed
licked	13	46	2156	3	lick__ed
nicked	13	50	1968	3	nick__ed
nickeled	15	11	551	3	nickeled
nickered	15	11	702	3	nickered
nickled	14	40	1044	3	nick_led
nicknamed	18	4	215	3	nicknamed
nictated	11	3	779	3	nictated
package	16	12	801	3	package_
packager	17	13	615	3	packager
packages	17	13	873	3	packages
packed	15	48	2260	3	pack__ed
packeted	17	14	828	3	packeted
packwaxes	27	4	341	3	packwaxes
pecked	15	50	1910	3	peck__ed
pickadil	17	4	263	3	pickadil
pickaxing	25	4	310	3	pickaxing
pickeer	15	37	1011	3	pick_eer
pickeered	18	4	346	3	pickeered
picker	14	44	2217	3	pick__er
pickerel	16	4	527	3	pickerel
picket	14	49	2431	3	pick__et
picketer	16	18	743	3	picketer
pickier	15	39	1297	3	pick_ier
pickle	14	42	1565	3	pick_le_
pickles	15	32	1544	3	pick_les
picoted	12	3	921	3	pic_oted
picowaved	20	10	222	3	picowaved
picrate	11	20	1414	3	picrate_
picrates	12	20	1321	3	picrates
pictured	13	4	657	3	pictured
pikake	11	11	580	3	pi_kake_
pikakes	12	4	582	3	pi_kakes
piked	12	56	2331	3	pi_k__ed
pileated	11	27	1113	3	pileated
pillaged	12	29	809	3	pillaged
pillared	11	22	809	3	pillared
pinked	13	48	1988	3	pink__ed
pinkened	15	3	575	3	pinkened
pinnated	11	33	855	3	pinnated
pirated	10	25	1561	3	pi_rated
plicated	13	3	1064	3	plic_ated
pocked	15	48	1898	3	pock__ed
pocketed	17	14	714	3	pocketed
poleaxed	18	5	481	3	poleaxed
polkaed	14	3	532	3	polka_ed
pricked	16	46	1383	3	prick__ed
prickled	17	35	807	3	prick_led
puckered	17	3	610	3	puckered
ricked	13	65	2362	3	rick__ed
sickbed	16	39	682	3	sick_bed
sicked	13	45	2440	3	sick__ed
sickened	15	4	678	3	sickened
sickled	14	47	1343	3	sick_led
sicklied	15	4	658	3	sicklied
spicated	13	30	990	3	spic_ated
ticked	13	47	2052	3	tick__ed
ticketed	15	14	664	3	ticketed
tickled	14	43	1313	3	tick_led
tickseed	15	8	451	3	tickseed
wickape	18	4	372	3	wickape_
wickapes	19	4	370	3	wickapes
wicked	16	43	1741	3	wick__ed

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	146162	0.156	1145455.1
2	DLD Change Limit	146162	79	7.390	19778.3
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	7.579	23577.1