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

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

94 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
sharply	15	40	683	1	sharply
sharp	10	49	2253	2	sharp__
sharped	13	41	1205	2	sharped
sharpen	12	38	972	2	sharpen
sharper	12	43	1270	2	sharper
sharpie	12	3	840	2	sharpie
sharps	11	55	1608	2	sharp_s
sharpy	14	52	1103	2	sharp_y
bharal	11	3	889	3	bharal_
bharals	12	3	673	3	bharals
charily	15	3	1028	3	charily
charpai	14	3	663	3	charpai
charpoy	17	3	571	3	charpoy
haply	13	59	1506	3	_ha_ply
hardly	13	51	1283	3	_hardly
harl	7	57	4000	3	_har_l_
harls	8	56	3450	3	_har_ls
harp	9	61	3429	3	_harp__
harped	12	44	1840	3	_harped
harper	11	50	1840	3	_harper
harpin	11	36	1438	3	_harpin
harps	10	59	2687	3	_harp_s
harpy	13	64	1821	3	_harp_y
hirple	11	15	897	3	_hirple
sample	10	42	1501	3	s_ample
scarily	12	3	1170	3	scarily
scarp	9	57	2410	3	scarp__
scarped	12	43	1440	3	scarped
scarper	11	48	1482	3	scarper
scarph	13	42	960	3	scarp_h
scarphs	14	43	741	3	scarphs
scarps	10	47	1860	3	scarp_s
shackle	16	40	954	3	shackle
shadfly	17	3	378	3	shadfly
shadily	14	3	772	3	shadily
shakily	17	3	690	3	shakily
shale	8	53	3283	3	sha__le
shall	8	50	2405	3	sha__ll
shalt	8	55	3449	3	sha__lt
shaly	11	43	2286	3	sha__ly
shamble	14	14	926	3	shamble
shampoo	14	3	537	3	shampoo
shape	10	51	2511	3	sha_p_e
shaped	12	50	2010	3	sha_ped
shapely	15	3	689	3	shapely
shapen	11	44	1465	3	sha_pen
shaper	11	41	1993	3	sha_per
shapes	11	51	2495	3	sha_pes
sharable	13	19	1069	3	sharable
shard	9	61	2596	3	shar__d
shards	10	43	1917	3	shar_ds
share	8	64	3708	3	shar__e
shared	10	58	2906	3	shar_ed
sharer	9	50	2548	3	shar_er
sharers	10	47	2062	3	sharers
shares	9	52	3641	3	shar_es
sharia	9	31	1673	3	shar_ia
shariah	13	22	1053	3	shariah
sharias	10	25	1600	3	sharias
sharif	12	29	1712	3	shar_if
sharifs	13	27	990	3	sharifs
sharing	11	37	2324	3	sharing
shark	12	62	2502	3	shar__k
sharked	15	36	1391	3	sharked
sharker	14	43	1381	3	sharker
sharks	13	50	1972	3	shar_ks
sharn	8	48	2370	3	shar__n
sharns	9	55	1698	3	shar_ns
sharny	12	47	1183	3	shar_ny
sharpens	13	37	781	3	sharpens
sharpers	13	38	1094	3	sharpers
sharpest	13	3	915	3	sharpest
sharpies	13	4	1123	3	sharpies
sharping	14	30	1137	3	sharping
shaul	8	54	1810	3	sha_ul_
shauls	9	49	1311	3	sha_uls
shawl	11	62	1757	3	sha_wl_
shawls	12	54	1197	3	sha_wls
sherpa	11	3	809	3	sherp_a
sherpas	12	3	809	3	sherpas
shorl	8	47	2025	3	shor_l_
shorls	9	45	1620	3	shor_ls
shortly	13	38	757	3	shortly
shrill	9	47	1230	3	sh_rill
smartly	12	49	743	3	smartly
snarl	5	49	2108	3	snar_l_
snarls	6	40	1687	3	snar_ls
snarly	9	38	1500	3	snar_ly
sparely	12	34	1067	3	sparely
sparkle	13	37	1021	3	sparkle
sparkly	16	34	813	3	sparkly
staple	8	44	1582	3	sta_ple
starkly	14	27	703	3	starkly
startle	7	25	1112	3	startle

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.406	440125.6
2	DLD Change Limit	134027	94	6.530	20524.8
3	Display Results	94	94	0.033	2848.5
	(SQL Overall)	178691	94	6.969	25640.8