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

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

68 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
pinpricking	22	5	218	(None)
finicking	19	5	446	3	fin__icking
mispricing	17	4	671	3	mispric_ing
nitpicking	19	4	303	3	nitp_icking
panicking	18	3	529	3	pan__icking
picnicking	21	4	279	3	pi_cnicking
pigsticking	21	5	243	3	pigsticking
pinpointing	16	4	310	3	pinpointing
pinprick	18	4	306	3	pinprick___
pinpricked	21	5	193	3	pinprick_ed
pinpricks	19	4	276	3	pinprick__s
prepricing	17	4	673	3	prepric_ing
pricking	17	32	1260	3	___pricking
unpicking	18	3	488	3	_unp_icking
anticking	16	4	924	4	_an_ticking
bricking	17	39	1140	4	___bricking
cricking	17	34	1265	4	___cricking
disfrocking	22	5	296	4	disfrocking
disprizing	23	4	792	4	dispri_zing
districting	15	5	900	4	districting
enriching	15	4	615	4	_en_riching
fingerpicking	26	6	118	4	fingerpicking
finickin	17	7	363	4	fin__ickin_
finiking	16	27	707	4	fin__i_king
gimmicking	22	4	198	4	gi_mmicking
handpicking	24	5	184	4	handpicking
henpecking	22	4	230	4	henp_ecking
imprinting	15	4	602	4	_imprinting
inarching	15	4	634	4	_inar_ching
indicting	13	3	961	4	_in_dicting
inflicting	16	4	572	4	_inflicting
infracting	16	4	735	4	_infracting
infringing	15	4	444	4	_infringing
intriguing	12	4	510	4	_intriguing
invoicing	15	4	533	4	_invoic_ing
linebacking	20	5	243	4	linebacking
mimicking	20	4	387	4	mi__micking
miskicking	18	4	424	4	mi_skicking
misprinting	16	4	682	4	misprinting
misprizing	24	4	753	4	mispri_zing
nicking	14	35	1632	4	__n__icking
nondrinking	17	5	341	4	nondrinking
outpricing	15	4	700	4	outpric_ing
outtricking	18	4	414	4	outtricking
physicking	25	10	243	4	p_hysicking
picking	16	34	1833	4	___p_icking
piercing	13	4	666	4	pi_er_c_ing
pinching	16	37	1105	4	pin___ching
pinioning	12	4	686	4	pin__ioning
pinking	14	39	1894	4	pin____king
pinnacling	15	4	306	4	pin_nacling
politicking	20	6	334	4	politicking
prepacking	21	4	577	4	prep_acking
preprinting	16	4	741	4	preprinting
pricing	12	34	1734	4	___pric_ing
prickings	18	31	565	4	___prickings
prickling	18	3	653	4	___prickling
prinking	15	32	1245	4	___prinking
repricing	14	3	1047	4	_repric_ing
ricking	14	39	2023	4	____ricking
snicking	15	36	1023	4	_sn__icking
tricking	15	27	1451	4	___tricking
unfrocking	20	4	353	4	_unfrocking
unpacking	18	3	513	4	_unp_acking
unsticking	17	4	494	4	_unsticking
untracking	17	4	693	4	_untracking
wricking	18	34	949	4	___wricking
zincking	24	3	546	4	zin___cking

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.406	440125.6
2	DLD Change Limit	148819	68	9.250	16088.5
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	9.686	18448.4