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

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

89 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
surfer	9	35	1588	(None)
suffer	12	43	1451	1	suffer
surer	5	48	3310	1	sur_er
surfed	10	38	1446	1	surfed
surfers	10	36	1413	1	surfers
surfier	10	26	1354	1	surfier
surger	7	43	2009	1	surger
buffer	14	45	1268	2	buffer
burger	9	40	2079	2	burger
burier	8	43	2465	2	burier
burker	12	52	2117	2	burker
burler	8	47	2383	2	burler
burner	8	38	1920	2	burner
burrer	8	37	1847	2	burrer
curber	10	45	1705	2	curber
curer	7	50	3075	2	cur_er
curfew	14	42	674	2	curfew
curler	8	52	2132	2	curler
curser	8	47	2147	2	curser
curter	8	53	2008	2	curter
duffer	13	47	1166	2	duffer
furfur	12	3	555	2	furfur
furler	9	36	1640	2	furler
hurler	9	47	1722	2	hurler
hurter	9	39	1585	2	hurter
lurer	5	46	2531	2	lur_er
lurker	10	36	1329	2	lurker
murder	9	36	1378	2	murder
murker	12	37	1524	2	murker
nurser	6	43	1450	2	nurser
puffer	14	46	1073	2	puffer
purer	7	51	2790	2	pur_er
purfler	12	24	873	2	purfler
purger	9	47	1723	2	purger
purser	8	50	2047	2	purser
safer	8	47	2181	2	s_afer
scarfer	12	45	1108	2	scarfer
scuffer	15	32	888	2	scuffer
scurfier	13	26	705	2	scurfier
serer	5	59	3551	2	ser_er
serger	7	38	1974	2	serger
server	9	49	1771	2	server
snuffer	13	31	885	2	snuffer
sorer	5	62	3659	2	sor_er
sorner	6	47	2039	2	sorner
sorter	6	44	2509	2	sorter
sourer	6	36	2021	2	sour_er
sprier	8	41	1906	2	sprier
spryer	11	41	853	2	spryer
spurner	9	26	965	2	spurner
spurrer	9	37	1022	2	spurrer
spurter	9	40	1300	2	spurter
strafer	10	39	1246	2	strafer
stuffer	13	34	979	2	stuffer
suaver	9	30	1423	2	suaver
suber	7	49	2450	2	su_ber
sucker	12	41	2066	2	sucker
sudser	7	35	1128	2	sudser
suer	4	53	3403	2	su__er
suffers	13	31	1354	2	suffers
suiter	6	41	2181	2	suiter
sulfur	9	3	791	2	sulfur
sulker	10	40	1592	2	sulker
summer	10	40	1771	2	summer
sunder	7	40	1982	2	sunder
super	7	49	2448	2	su_per
supper	10	41	1543	2	supper
sure	4	54	4741	2	sur_e_
surf	7	60	3931	2	surf__
surfacer	13	4	566	2	surfacer
surfeit	10	3	1034	2	surfeit
surfmen	12	3	599	2	surfmen
surfs	8	50	2254	2	surf_s
surfy	11	53	1947	2	surf_y
surge	6	50	2769	2	surge_
surged	8	41	1888	2	surged
surgers	8	35	1748	2	surgers
surgery	11	31	921	2	surgery
surges	7	39	2459	2	surges
surlier	7	29	1544	2	surlier
surrey	9	44	1458	2	surrey
survey	12	41	1167	2	survey
sutler	6	37	1839	2	sutler
turfed	10	31	1096	2	turfed
turfier	10	24	979	2	turfier
turner	6	39	1461	2	turner
urger	6	41	1647	2	_urger
usurer	6	3	810	2	usur_er
usurper	9	3	435	2	usurper

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.360	496363.9
2	DLD Change Limit	82551	89	2.250	36689.3
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	2.640	67686.0