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

Here are the results of your fuzzy-string dictionary search for “sharper” with Change Limit: [1] [2] [3]

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.

87 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
sharper	12	43	1270	(None)
harper	11	50	1840	1	_harper
scarper	11	48	1482	1	scarper
shaper	11	41	1993	1	sha_per
sharer	9	50	2548	1	shar_er
sharker	14	43	1381	1	sharker
sharped	13	41	1205	1	sharped
sharpen	12	38	972	1	sharpen
sharpers	13	38	1094	1	sharpers
carper	10	49	2363	2	_carper
champer	16	38	1341	2	champer
charger	13	39	1406	2	charger
charier	12	43	1790	2	charier
charmer	14	49	1366	2	charmer
charter	12	39	1830	2	charter
chirper	14	35	996	2	chirper
hamper	13	45	1865	2	_hamper
harder	10	50	2240	2	_harder
harmer	11	47	1955	2	_harmer
harped	12	44	1840	2	_harped
harpers	12	49	1620	2	_harpers
sapper	10	38	2235	2	s_apper
scalper	11	39	1292	2	scalper
scamper	13	46	1316	2	scamper
scarcer	11	39	1137	2	scarcer
scarer	8	45	2461	2	scar_er
scarfer	12	45	1108	2	scarfer
scarier	9	40	1787	2	scarier
scarped	12	43	1440	2	scarped
scarpers	12	47	1251	2	scarpers
scauper	11	37	945	2	scauper
scraper	11	45	1342	2	scraper
searer	6	54	3202	2	sear_er
shader	10	42	1876	2	sha_der
shadier	11	31	1115	2	shadier
shaker	13	43	1946	2	sha_ker
shakier	14	34	1115	2	shakier
shalier	10	31	1642	2	shalier
shammer	14	46	1314	2	shammer
shape	10	51	2511	2	sha_pe_
shaped	12	50	2010	2	sha_ped
shapen	11	44	1465	2	sha_pen
shapers	12	40	1689	2	sha_pers
shapes	11	51	2495	2	sha_pes
share	8	64	3708	2	shar_e_
shared	10	58	2906	2	shar_ed
sharers	10	47	2062	2	shar_ers
shares	9	52	3641	2	shar_es
sharked	15	36	1391	2	sharked
sharkers	15	40	1105	2	sharkers
sharp	10	49	2253	2	sharp__
sharpener	14	4	458	2	sharpener
sharpens	13	37	781	2	sharpens
sharpest	13	3	915	2	sharpest
sharpie	12	3	840	2	sharpie
sharpies	13	4	1123	2	sharpies
sharply	15	40	683	2	sharply
sharps	11	55	1608	2	sharp_s
sharpy	14	52	1103	2	sharp_y
shatter	10	36	1570	2	shatter
shaver	12	37	1891	2	sha_ver
shearer	10	44	1468	2	shear_er
shipper	14	35	1404	2	shipper
shirker	14	37	1134	2	shirker
shopper	14	33	1263	2	shopper
shorter	10	35	1550	2	shorter
slapper	11	35	1247	2	slapper
smarter	9	41	1313	2	smarter
snapper	11	35	1207	2	snapper
snarer	6	46	2084	2	snar_er
snarler	7	36	1063	2	snarler
soaper	8	45	1787	2	soa_per
soarer	6	45	2224	2	soar_er
sparer	8	45	2496	2	spar_er
sparger	10	36	1308	2	sparger
sparker	13	39	1436	2	sparker
sparser	9	43	1148	2	sparser
stamper	11	37	1440	2	stamper
starer	6	40	2736	2	star_er
starker	11	41	1469	2	starker
starter	7	38	1788	2	starter
starver	10	46	1199	2	starver
swamper	14	34	931	2	swamper
swapper	14	35	970	2	swapper
swarmer	12	4	780	2	swarmer
warper	11	40	1558	2	_warper
whapper	17	34	827	2	whapper

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	107671	0.750	238254.7
2	DLD Change Limit	107671	87	6.376	16886.9
3	Display Results	87	87	0.060	1450.0
	(SQL Overall)	178691	87	7.186	24866.5