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

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

67 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
edifices	14	5	486	(None)
edifice	13	4	493	1	edifice_
edifies	11	30	1228	1	edifi_es
deifies	11	33	1745	2	deifi_es
edified	12	33	971	2	edifi_ed
edifier	11	30	926	2	edifi_er
edifiers	12	33	667	2	edifiers
editrices	12	4	532	2	editrices
orifices	13	4	648	2	orifices
advices	13	13	693	3	ad_vices
aerifies	11	13	1339	3	aerifi_es
artifices	14	4	647	3	artifices
benefices	16	4	506	3	benefices
bifaces	14	4	806	3	_bifaces
cilices	11	38	1402	3	_cilices
cimices	13	27	980	3	_cimices
codifies	14	3	964	3	codifi_es
defaces	13	32	1340	3	_defaces
defies	10	46	2405	3	_defi_es
defiles	11	40	1684	3	_defiles
defines	11	41	1868	3	_defines
deices	9	41	1937	3	_d_eices
deicides	12	4	930	3	deicides
deific	12	3	731	3	deific__
deifical	14	4	554	3	deifical
deified	12	31	1241	3	deifi_ed
deifier	11	30	1312	3	deifi_er
deifiers	12	34	899	3	deifiers
deities	8	26	2192	3	deiti_es
deixises	16	3	569	3	deixises
devices	13	32	1258	3	_devices
devoices	14	30	741	3	devoices
dices	8	64	3424	3	_d__ices
didies	8	46	2183	3	_didi_es
divides	12	32	1145	3	_divides
divines	11	35	1472	3	_divines
eddies	8	33	1316	3	ed_di_es
edibles	10	4	800	3	edi_bles
edicts	9	49	1170	3	ed__icts
edificial	15	5	357	3	edificial
ediles	7	40	1698	3	ed__iles
editions	9	3	1040	3	editions
editrixes	17	4	381	3	editrixes
educes	9	40	1195	3	ed__uces
effaces	15	27	727	3	e_ffaces
enfaces	12	21	1091	3	e_nfaces
entices	9	16	1633	3	e_ntices
evinces	12	3	780	3	evi_nces
fices	10	60	3116	3	___fices
ibices	10	39	816	3	__ibices
idiocies	11	4	522	3	idiocies
mediacies	14	4	718	3	mediacies
medicides	15	5	658	3	medicides
medicines	14	4	790	3	medicines
modifies	14	3	916	3	modifi_es
nidifies	12	3	823	3	nidifi_es
offices	15	3	624	3	_offices
orifice	12	4	634	3	orifice_
redefies	12	7	1016	3	redefi_es
redefines	13	4	741	3	redefines
redivides	14	4	568	3	redivides
reedifies	13	4	732	3	reedifi_es
reifies	10	42	1828	3	reifi_es
suffices	16	20	818	3	suffices
unifaces	13	4	639	3	unifaces
unifies	10	27	1471	3	unifi_es
verifies	14	13	1348	3	verifi_es

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	146162	0.436	409841.7
2	DLD Change Limit	146162	67	7.330	19940.2
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	7.796	22920.9