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

Here are the results of your fuzzy-string dictionary search for “freak” 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
freak	12	51	1524	(None)
break	11	53	1940	1	break
creak	11	54	1843	1	creak
freaks	13	47	1306	1	freaks
freaky	16	43	923	1	freaky
wreak	12	55	1327	1	wreak
apeak	11	55	1345	2	apeak
arak	8	69	2957	2	ar_ak
area	4	58	4339	2	area_
areae	5	52	2974	2	areae
areal	5	59	2873	2	areal
areas	5	59	3577	2	areas
beak	10	65	3438	2	_beak
bleak	11	59	1538	2	bleak
bread	8	55	2311	2	bread
breaks	12	48	1642	2	breaks
bream	9	51	2181	2	bream
creaks	12	43	1596	2	creaks
creaky	15	49	1155	2	creaky
cream	9	57	2135	2	cream
creek	11	49	1739	2	creek
croak	11	52	1663	2	croak
dread	7	44	1902	2	dread
dream	8	51	2039	2	dream
drear	6	50	1690	2	drear
dreck	12	48	1280	2	dreck
drek	9	63	2109	2	dre_k
feal	7	139	4042	2	f_eal
fear	7	53	3779	2	f_ear
feat	7	64	5822	2	f_eat
feck	13	49	2343	2	f_eck
feral	8	54	2465	2	feral
flak	11	60	2617	2	f_lak
flea	7	56	2849	2	flea_
fleam	10	60	1728	2	fleam
fleas	8	64	2366	2	fleas
fleck	14	82	1359	2	fleck
frae	7	53	3047	2	fr_ae
frag	8	51	2627	2	fr_ag
frank	12	44	1751	2	frank
frap	9	59	2581	2	fr_ap
frat	7	56	4854	2	fr_at
fray	10	54	2890	2	fr_ay
freaked	15	39	970	2	freaked
free	7	59	4018	2	fre_e
freed	9	52	2354	2	freed
freer	8	60	2124	2	freer
frees	8	61	3139	2	frees
fremd	11	50	1032	2	fremd
frena	8	59	1527	2	frena
frere	8	56	1772	2	frere
fresh	11	50	1220	2	fresh
fret	7	58	4504	2	fre_t
frets	8	55	2340	2	frets
friar	8	54	1427	2	friar
frisk	12	53	1237	2	frisk
frock	14	53	1465	2	frock
great	6	60	3424	2	great
greek	10	59	1594	2	greek
leak	8	62	3371	2	_leak
oread	6	46	1960	2	oread
peak	10	65	3520	2	_peak
phreak	15	3	615	2	phreak
read	5	59	4253	2	_read
real	4	57	5029	2	_real
ream	6	58	4161	2	_ream
reap	6	59	3474	2	_reap
rear	4	56	4455	2	_rear
reck	10	61	3056	2	_reck
reek	8	52	3252	2	_reek
screak	12	53	1106	2	screak
sneak	9	60	1617	2	sneak
speak	11	46	1867	2	speak
steak	9	52	1980	2	steak
streak	10	46	1362	2	streak
teak	8	59	3084	2	_teak
tread	6	48	2170	2	tread
treat	5	62	4035	2	treat
trek	8	62	2231	2	tre_k
troak	9	52	1357	2	troak
tweak	12	5	775	2	tweak
urea	4	65	2805	2	urea_
ureal	5	67	2268	2	ureal
ureas	5	58	2601	2	ureas
weak	11	71	2630	2	_weak
wreaks	13	47	1111	2	wreaks
wreck	14	46	1104	2	wreck

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	87	1.436	37465.2
3	Display Results	87	87	0.016	5437.5
	(SQL Overall)	178691	87	1.765	101241.4