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

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

59 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
hurley	12	50	1252	(None)
burley	11	47	1575	1	burley
hurled	10	46	1745	1	hurled
hurler	9	47	1722	1	hurler
hurleys	13	40	733	1	hurleys
hurly	11	58	1929	1	hurl_y
barley	11	51	1676	2	barley
burled	9	48	2538	2	burled
burler	8	47	2383	2	burler
burleys	12	47	967	2	burleys
burly	10	49	2283	2	burl_y
charley	15	11	827	2	charley
curled	9	50	2165	2	curled
curler	8	52	2132	2	curler
curlew	11	40	1090	2	curlew
curly	10	53	2123	2	curl_y
curvey	14	41	1184	2	curvey
furled	10	47	1705	2	furled
furler	9	36	1640	2	furler
gulley	10	42	1316	2	gulley
gurney	10	42	941	2	gurney
henley	12	3	748	2	henley
holey	11	56	2690	2	h_oley
horsey	12	51	1540	2	horsey
hourly	12	36	962	2	hourl_y
hugely	13	3	680	2	hugely
hulky	15	53	1247	2	hu_lky
hulled	10	39	2001	2	hulled
huller	9	39	1910	2	huller
hunkey	16	42	1088	2	hunkey
hurdle	10	37	1279	2	hurdle_
hurdled	12	37	983	2	hurdled
hurdler	11	36	1000	2	hurdler
hurdles	11	36	1337	2	hurdles
hurl	7	60	2993	2	hurl__
hurlers	10	37	1432	2	hurlers
hurlies	10	33	1533	2	hurlies
hurls	8	65	2271	2	hurl_s
hurray	12	45	991	2	hurray
hurry	11	49	1718	2	hur_ry
hurter	9	39	1585	2	hurter
hurtle	9	35	1294	2	hurtle_
hurtled	11	33	959	2	hurtled
hurtles	10	39	1375	2	hurtles
muley	10	48	1928	2	mu_ley
mulley	11	40	1345	2	mulley
murrey	11	43	1226	2	murrey
nurled	7	40	1623	2	nurled
parley	11	67	1836	2	parley
pulley	11	37	1340	2	pulley
purely	11	40	1363	2	purely
purled	9	45	2075	2	purled
purvey	14	55	957	2	purvey
pusley	11	37	961	2	pusley
surely	9	38	1646	2	surely
surly	8	51	2443	2	surl_y
surrey	9	44	1458	2	surrey
survey	12	41	1167	2	survey
turkey	13	3	776	2	turkey

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	59	2.406	34310.5
3	Display Results	59	59	0.013	4538.5
	(SQL Overall)	178691	59	2.762	64696.2