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

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

73 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
quake	18	41	1464	(None)
quaked	20	39	1003	1	quaked
quaker	19	38	1162	1	quaker
quakes	19	40	1334	1	quakes
quaky	21	43	1074	1	quaky
quale	14	36	1785	1	quale
quare	14	39	2054	1	quare
quate	14	45	2141	1	quate
aquae	14	22	1271	2	aqua_e
awake	12	50	1478	2	awake
bake	10	56	3751	2	_bake
brake	11	60	2534	2	brake
burke	11	51	2276	2	burke
cake	10	54	3996	2	_cake
crake	11	48	2352	2	crake
cuke	10	58	2498	2	cu_ke
drake	10	49	1830	2	drake
duke	9	56	2810	2	du_ke
equate	15	20	1246	2	equate
fake	11	55	3494	2	_fake
flake	12	51	1997	2	flake
hake	11	56	3784	2	_hake
jake	15	59	2577	2	_jake
juke	15	47	2166	2	ju_ke
lake	8	57	4160	2	_lake
make	10	55	3789	2	_make
nuke	8	59	2075	2	nu_ke
puke	10	50	2546	2	pu_ke
qua	12	48	2197	2	qua__
quack	20	38	1250	2	quack
quacked	23	3	679	2	quacked
quacks	21	47	1010	2	quacks
quacky	24	37	696	2	quacky
quad	14	46	1870	2	qua_d
quads	15	45	1584	2	quads
quaere	15	41	1067	2	quaere
quaff	20	13	1135	2	quaff
quag	14	48	1594	2	qua_g
quags	15	46	1325	2	quags
quai	13	44	2039	2	qua_i
quail	14	43	1436	2	quail
quais	14	46	1839	2	quais
quakers	20	30	969	2	quakers
quakier	20	23	920	2	quakier
qualm	16	35	1118	2	qualm
quant	14	36	2481	2	quant
quark	18	46	1412	2	quark
quarks	19	38	1091	2	quarks
quart	14	40	2785	2	quart
quarte	15	41	1532	2	quarte
quash	17	45	1216	2	quash
quasi	14	40	1502	2	quasi
quass	14	44	1376	2	quass
quatre	15	35	1235	2	quatre
quaver	18	30	931	2	quaver
quay	16	46	1835	2	qua_y
quays	17	46	1204	2	quays
queue	14	37	1123	2	queue
quire	14	49	1713	2	quire
quite	14	46	2146	2	quite
quote	14	37	1477	2	quote
rake	8	48	4157	2	_rake
sake	8	52	4496	2	_sake
shake	12	47	2640	2	shake
slake	9	37	2405	2	slake
snake	9	48	2111	2	snake
spake	11	43	2274	2	spake
square	15	45	1336	2	square
stake	9	59	2753	2	stake
suave	8	35	1987	2	suave
take	8	47	3926	2	_take
uke	7	57	2729	2	_u_ke
wake	11	49	3570	2	_wake

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.343	520965.0
2	DLD Change Limit	53800	73	2.033	26463.4
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	2.406	74268.9