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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

110 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
creak	11	54	1843	(None)
break	11	53	1940	1	break
creaks	12	43	1596	1	creaks
creaky	15	49	1155	1	creaky
cream	9	57	2134	1	cream
creek	11	49	1739	1	creek
croak	11	52	1663	1	croak
freak	12	51	1524	1	freak
screak	12	53	1105	1	screak
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
cereal	8	3	1583	2	cereal
cheap	12	69	1594	2	cheap
cheat	10	57	3245	2	cheat
check	16	47	1471	2	check
cheek	14	51	1571	2	cheek
clean	7	54	2041	2	clean
clear	7	62	1905	2	clear
cleat	7	63	3506	2	cleat
cleek	11	55	1491	2	cleek
clerk	11	58	1245	2	clerk
cloak	11	52	1401	2	cloak
craal	7	41	1775	2	craal
crab	8	57	2767	2	cr_ab
crack	13	41	2053	2	crack
crag	7	56	2530	2	cr_ag
crake	11	48	2352	2	cr_ake
cram	8	56	3549	2	cr_am
crank	11	48	1961	2	crank
crap	8	57	3184	2	cr_ap
craw	9	77	2526	2	cr_aw
creaked	14	34	1323	2	creaked
creams	10	47	1525	2	creams
creamy	13	48	1136	2	creamy
crease	8	55	1957	2	crease
creasy	11	46	1230	2	creasy
create	8	51	2637	2	create
cred	7	65	3088	2	cre_d
credal	9	3	1167	2	credal
credo	8	48	1556	2	credo
creds	8	54	1877	2	creds
creed	8	57	2739	2	creed
creeks	12	48	1292	2	creeks
creel	7	51	2148	2	creel
creep	9	52	1810	2	creep
creme	9	43	1932	2	creme
crepe	9	55	2072	2	crepe
crept	9	51	2589	2	crept
crepy	12	48	1270	2	crepy
cress	7	50	2283	2	cress
crest	7	46	3269	2	crest
crew	9	61	2267	2	cre_w
crews	10	59	1749	2	crews
crick	13	51	1875	2	crick
croaks	12	58	1298	2	croaks
croaky	15	52	848	2	croaky
crock	13	59	2199	2	crock
crook	11	52	1757	2	crook
cruck	13	56	1532	2	cruck
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	2108	2	dre_k
freaks	13	47	1306	2	freaks
freaky	16	43	923	2	freaky
great	6	60	3424	2	great
greek	10	59	1594	2	greek
leak	8	62	3371	2	_leak
ocrea	7	33	1182	2	ocrea_
ocreae	8	33	1027	2	ocreae
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
screaks	13	46	935	2	screaks
screaky	16	43	621	2	screaky
scream	10	48	1424	2	scream
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 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	53800	0.140	1276364.3
2	DLD Change Limit	53800	110	1.920	28020.8
3	Display Results	110	110	0.030	3666.7
	(SQL Overall)	178691	110	2.090	85498.1