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

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

78 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
creaking	15	34	1412	(None)
breaking	15	39	1425	1	breaking
creaming	13	34	1314	1	creaming
creasing	11	33	1444	1	creasing
creating	11	39	2195	1	creating
croaking	15	37	1216	1	croaking
freaking	16	36	1145	1	freaking
screaking	16	22	823	1	screaking
wreaking	16	30	1021	1	wreaking
beraking	15	36	1297	2	beraking
braking	14	39	1771	2	br_aking
breading	12	35	1546	2	breading
breakings	16	29	706	2	breakings
breaming	13	36	1251	2	breaming
caking	13	46	2467	2	c__aking
caretaking	17	6	533	2	caretaking
ceasing	10	41	1826	2	c_easing
cheating	14	40	1452	2	cheating
checking	20	37	920	2	checking
cheeking	18	34	908	2	cheeking
cleaning	11	31	1238	2	cleaning
clearing	11	30	1488	2	clearing
cleating	11	35	1813	2	cleating
cleaving	14	138	968	2	cleaving
cleeking	15	26	781	2	cleeking
clerking	15	25	716	2	clerking
cloaking	15	29	971	2	cloaking
comaking	17	3	999	2	comaking
craaling	11	27	1135	2	craaling
cracking	17	40	1390	2	cracking
craning	10	36	2030	2	cr_aning
cranking	15	46	1307	2	cranking
craping	12	40	1871	2	cr_aping
crating	10	37	2520	2	cr_ating
craving	13	40	1573	2	cr_aving
crazing	19	39	1458	2	cr_azing
creakier	14	32	833	2	creakier
creakily	17	3	539	2	creakily
creatin	9	36	1813	2	creatin_
creatine	10	34	1741	2	creatine
creatins	10	36	1751	2	creatins
creeling	11	35	1336	2	creeling
creeping	13	33	1010	2	creeping
cremating	14	3	1219	2	cremating
creping	12	29	1365	2	cre_ping
cresting	11	40	1704	2	cresting
crewing	13	32	1262	2	cre_wing
cricking	17	34	1265	2	cricking
crocking	17	43	1344	2	crocking
crooking	15	36	1134	2	crooking
dreading	11	37	1280	2	dreading
dreaming	12	40	1106	2	dreaming
greasing	10	28	1139	2	greasing
leaking	12	36	1697	2	_leaking
peaking	14	43	1769	2	_peaking
phreaking	19	3	647	2	phreaking
prebaking	18	3	806	2	prebaking
raking	11	47	2842	2	_r_aking
reading	9	33	2721	2	_reading
reaming	10	39	2401	2	_reaming
reaping	10	36	2121	2	_reaping
rearing	8	31	2878	2	_rearing
reaving	11	38	2053	2	_reaving
recking	14	43	1992	2	_recking
reeking	12	33	1864	2	_reeking
remaking	15	26	1330	2	_remaking
retaking	13	31	1428	2	_retaking
rewaking	16	23	1098	2	_rewaking
screaming	14	21	782	2	screaming
sneaking	13	32	1109	2	sneaking
speaking	15	32	1249	2	speaking
streaking	14	20	1032	2	streaking
treading	10	35	1533	2	treading
treating	9	25	1961	2	treating
trekking	12	3	554	2	trekking
troaking	13	33	1097	2	troaking
tweaking	16	3	588	2	tweaking
wrecking	18	32	815	2	wrecking

Search took 5 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	121059	0.393	454684.5
2	DLD Change Limit	121059	78	3.593	33693.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	4.016	44494.8