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

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

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.

86 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
actuary	12	4	561	(None)
actual	8	3	1102	2	actua_l
actually	13	6	685	2	actually
actuate	9	3	1144	2	actuate
estuary	10	3	468	2	estuary
lactary	12	3	784	2	lact_ary
sanctuary	14	4	218	2	sanctuary
acari	7	50	2028	3	ac__ari
accuracy	14	4	360	3	accuracy
acinar	8	3	1048	3	acinar_
acquire	18	3	560	3	acquire
acta	6	95	2480	3	act_a__
actor	7	11	1607	3	act_or_
actorly	12	4	641	3	actorly
actors	8	10	1676	3	act_ors
actuality	14	4	580	3	actuality
actuarial	11	4	497	3	actuarial
actuaries	11	4	756	3	actuaries
actuated	11	3	874	3	actuated
actuates	10	3	1031	3	actuates
actuator	10	4	664	3	actuator
actuators	11	4	644	3	actuators
acuate	8	3	1563	3	ac_uate
acuity	11	3	937	3	ac_uity
acutely	12	4	612	3	acutely
acuter	8	44	1286	3	acuter_
alary	8	61	2344	3	a__lary
altar	5	55	2064	3	alt_ar_
altars	6	45	1815	3	alt_ars
ambary	13	40	1054	3	a_mbary
angary	10	3	1132	3	a_ngary
antiar	6	3	1717	3	antiar_
antiars	7	3	1462	3	antiars
antiquary	21	4	479	3	antiquary
apiary	11	39	1038	3	a_piary
ariary	9	41	1420	3	a_riary
artery	9	9	1145	3	art_ery
astray	9	56	1554	3	astra_y
ataxy	15	3	731	3	a_t_axy
attar	5	65	1669	3	a_ttar_
attars	6	45	1531	3	a_ttars
augury	10	36	666	3	augu_ry
autarky	14	4	470	3	aut_arky
aviary	12	33	841	3	a_viary
aweary	12	3	730	3	a_weary
calvary	15	3	718	3	calvary
canary	11	3	1469	3	_canary
cartulary	14	4	464	3	cartulary
catenary	13	4	658	3	catenary
cattery	12	38	1160	3	cattery
cautery	12	34	959	3	cautery
cedary	12	41	960	3	_cedary
chary	13	50	2313	3	_c_hary
clary	10	57	1961	3	_c_lary
covary	14	3	874	3	_covary
curry	10	59	2034	3	_c_urry
datary	10	3	1024	3	dat_ary
electuary	14	4	327	3	electuary
factory	15	10	834	3	fact_ory
factual	12	4	672	3	factua_l
factually	17	4	466	3	factually
facture	12	10	892	3	factu_re
jacquard	27	4	255	3	jacquard
lacunary	13	11	415	3	lacunary
manuary	12	3	777	3	manuary
mortuary	13	7	392	3	mortuary
nectary	12	4	622	3	nect_ary
notary	9	23	1071	3	not_ary
obituary	13	4	285	3	obituary
octonary	13	4	498	3	octonary
octuply	14	4	313	3	octuply
ossuary	10	4	394	3	ossuary
ostiary	10	3	646	3	ostiary
retiary	10	3	833	3	retiary
rotary	9	24	1130	3	rot_ary
salutary	11	4	511	3	salutary
scary	10	52	2259	3	sc__ary
scurry	11	41	959	3	sc_urry
sectary	12	3	827	3	sect_ary
statuary	11	4	403	3	statuary
tactual	9	3	620	3	tactua_l
tactually	14	4	500	3	tactually
teary	8	51	2405	3	__teary
textuary	18	4	267	3	textuary
titulary	11	4	487	3	titulary
votary	12	24	833	3	vot_ary

Search took 8 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	134027	0.406	440125.6
2	DLD Change Limit	134027	86	6.780	19768.0
3	Display Results	86	86	0.033	2606.1
	(SQL Overall)	178691	86	7.219	24752.9