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

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

65 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
quakes	19	40	1334	(None)
quake	18	41	1464	1	quake_
quaked	20	39	1003	1	quaked
quaker	19	38	1162	1	quaker
quakers	20	30	969	1	quakers
awakes	13	50	1247	2	awakes
bakes	11	70	3537	2	_bakes
brakes	12	49	2312	2	brakes
bubkes	14	46	1262	2	bubkes
bupkes	14	48	1148	2	bupkes
burkes	12	44	2131	2	burkes
cakes	11	60	3767	2	_cakes
crakes	12	49	2181	2	crakes
cukes	11	54	2209	2	cu_kes
drakes	11	47	1586	2	drakes
dukes	10	50	2347	2	du_kes
equates	16	20	1232	2	equates
fakes	12	60	3248	2	_fakes
flakes	13	41	1887	2	flakes
hakes	12	60	3430	2	_hakes
jakes	16	50	2364	2	_jakes
jukes	16	53	1910	2	ju_kes
lakes	9	57	3765	2	_lakes
makes	11	53	3685	2	_makes
nukes	9	54	1812	2	nu_kes
pukes	11	45	2302	2	pu_kes
quacked	23	3	679	2	quacked
quacks	21	47	1010	2	quacks
quads	15	45	1584	2	qua_ds
quaeres	16	33	1084	2	quaeres
quaffs	21	12	569	2	quaffs
quags	15	46	1325	2	qua_gs
quails	15	34	1264	2	quails
quais	14	46	1839	2	qua_is
quakier	20	23	920	2	quakier
quakiest	21	3	858	2	quakiest
quaky	21	43	1074	2	quak_y
quale	14	36	1785	2	quale_
qualms	17	31	724	2	qualms
quants	15	36	1414	2	quants
quare	14	39	2054	2	quare_
quarks	19	38	1091	2	quarks
quartes	16	33	1493	2	quartes
quarts	15	47	1593	2	quarts
quashes	19	21	1097	2	quashes
quass	14	44	1376	2	qua_ss
quasses	16	20	950	2	quasses
quate	14	45	2141	2	quate_
quatres	16	34	1193	2	quatres
quaver	18	30	931	2	quaver
quavers	19	30	901	2	quavers
quays	17	46	1204	2	qua_ys
queues	15	35	1019	2	queues
quires	15	40	1574	2	quires
quotes	15	33	1246	2	quotes
rakes	9	44	4035	2	_rakes
sakes	9	55	4075	2	_sakes
shakes	13	50	2459	2	shakes
slakes	10	40	2188	2	slakes
snakes	10	39	1960	2	snakes
squares	16	37	1446	2	squares
stakes	10	39	2729	2	stakes
takes	9	44	3779	2	_takes
ukes	8	61	2281	2	_u_kes
wakes	12	66	3365	2	_wakes

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.110	1624463.6
2	DLD Change Limit	82551	65	2.203	37472.1
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	2.343	76265.9