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

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

104 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
clears	8	41	1656	(None)
blears	8	51	1645	1	blears
cleans	8	58	1705	1	cleans
clear	7	62	1905	1	clear_
cleats	8	49	1931	1	cleats
lears	5	59	3873	1	_lears
alegars	8	3	893	2	alegars
altars	6	45	1815	2	altars
anears	6	37	1718	2	anears
bears	7	57	3904	2	_bears
bleaks	12	51	1243	2	bleaks
blear	7	59	1868	2	blear_
bleary	11	51	1255	2	bleary
bleats	8	55	1861	2	bleats
caesars	9	4	1073	2	caesars
calcars	11	3	1265	2	calcars
cars	6	73	6476	2	c__ars
cedars	9	33	1283	2	cedars
cellars	9	37	1369	2	cellars
chars	10	59	3664	2	c_hars
cheaps	13	46	1368	2	cheaps
cheats	11	45	1954	2	cheats
cheers	11	45	1891	2	cheers
cigars	9	9	1072	2	cigars
clads	8	57	2273	2	cl_ads
clags	8	56	2112	2	cl_ags
clams	9	51	2767	2	cl_ams
clans	7	50	3101	2	cl_ans
claps	9	56	2618	2	cl_aps
claro	7	50	1869	2	cl_aro
claros	8	40	1511	2	cl_aros
clary	10	57	1961	2	cl_ary
class	7	55	2548	2	cl_ass
claws	10	60	2083	2	cl_aws
clays	10	55	2133	2	cl_ays
clean	7	54	2041	2	clea_n
cleaners	10	36	1054	2	cleaners
cleanse	9	35	872	2	cleanse
cleared	10	36	1246	2	cleared
clearer	9	37	1082	2	clearer
clearers	10	34	930	2	clearers
clearest	10	3	865	2	clearest
clearly	12	3	666	2	clearly
cleat	7	63	3506	2	clea_t
cleave	11	42	1251	2	cleave
cleavers	13	39	887	2	cleavers
cleaves	12	41	1162	2	cleaves
cleeks	12	50	1054	2	cleeks
clefs	10	66	1624	2	cle_fs
clefts	11	46	1016	2	clefts
clepes	10	42	1462	2	clepes
clerk	11	58	1245	2	cle_rk
clerks	12	45	884	2	clerks
clevis	11	5	896	2	clevis
clews	10	55	1633	2	cle_ws
cloaks	12	44	1126	2	cloaks
clours	8	52	1509	2	clours
coleads	10	29	1142	2	coleads
collars	9	38	1657	2	collars
creaks	12	43	1596	2	creaks
creams	10	47	1525	2	creams
cymars	13	59	915	2	cymars
czars	16	48	1291	2	c_zars
dears	6	57	3688	2	_dears
drears	7	46	1425	2	drears
ears	4	63	5659	2	__ears
fears	8	48	2939	2	_fears
fleams	11	50	1194	2	fleams
fleas	8	64	2366	2	flea_s
fleers	9	60	1579	2	fleers
gears	6	46	2869	2	_gears
gleams	9	48	1225	2	gleams
gleans	7	50	1474	2	gleans
hears	8	67	3737	2	_hears
lars	4	69	5657	2	_l_ars
leads	6	60	2849	2	_leads
leafs	8	57	2118	2	_leafs
leaks	9	59	2391	2	_leaks
leans	5	55	3625	2	_leans
leaps	7	55	2293	2	_leaps
lear	4	70	4595	2	_lear_
learn	5	53	2266	2	_learn
learns	6	55	1374	2	_learns
leary	8	59	2738	2	_leary
leas	4	59	5418	2	_lea_s
leers	5	48	2898	2	_leers
lehrs	8	61	1113	2	_lehrs
liars	5	47	2316	2	_liars
nears	5	55	2942	2	_nears
pears	7	51	3861	2	_pears
pleads	9	46	1395	2	pleads
pleas	7	56	2703	2	plea_s
pleats	8	52	1859	2	pleats
rears	5	47	3965	2	_rears
scleras	9	4	822	2	scleras
sears	5	47	4491	2	_sears
shears	9	38	2090	2	shears
smears	8	47	1443	2	smears
spears	8	40	1947	2	spears
swears	9	41	1407	2	swears
tears	5	54	3646	2	_tears
velars	9	39	1372	2	velars
wears	8	60	3030	2	_wears
years	8	45	2767	2	_years

Search took 7 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.686	260482.5
2	DLD Change Limit	82551	104	5.296	15587.4
3	Display Results	104	104	0.080	1300.0
	(SQL Overall)	178691	104	6.062	29477.2