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

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

90 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
evite	8	53	1768	(None)
elite	5	62	3018	1	elite
evited	10	40	1314	1	evited
evites	9	49	1647	1	evites
aviate	9	3	1520	2	aviate
axite	12	52	1825	2	axite
bite	6	65	4700	2	_bite
blite	7	62	2535	2	blite
boite	7	44	2632	2	boite
cerite	8	47	2487	2	cerite
cite	6	56	4034	2	_cite
deviate	11	3	1271	2	deviate
device	12	45	1216	2	device
devise	10	42	1575	2	devise
devote	10	45	1378	2	devote
dite	5	55	4755	2	_dite
edile	6	48	1949	2	edile
edit	5	49	3486	2	edit_
edited	8	39	1367	2	edited
edits	6	58	1903	2	edits
eide	5	58	3224	2	e_ide
elate	5	53	3588	2	elate
elide	6	49	2264	2	elide
elites	6	60	2712	2	elites
elute	5	48	2257	2	elute
emit	6	54	3842	2	emit_
emits	7	54	2147	2	emits
emote	7	54	2119	2	emote
enate	5	44	2815	2	enate
endite	7	38	1759	2	endite
evade	9	3	818	2	evade
eve	6	63	3116	2	ev__e
evict	10	44	1714	2	evict
evicted	13	3	724	2	evicted
evictee	12	4	810	2	evictee
evicts	11	36	855	2	evicts
evil	7	53	1807	2	evi_l
eviler	9	48	1189	2	eviler
evils	8	41	1426	2	evils
evince	11	3	776	2	evince
evoke	12	47	885	2	evoke
excite	15	3	1088	2	excite
exile	12	61	1765	2	exile
exine	12	55	1849	2	exine
exit	11	44	2867	2	exit_
exited	14	47	1252	2	exited
exits	12	55	1591	2	exits
flite	8	54	2496	2	flite
gite	5	54	3861	2	_gite
invite	9	37	1503	2	invite
kite	8	53	3824	2	_kite
lenite	6	7	1998	2	lenite
levity	12	7	790	2	levity
lite	4	70	5454	2	_lite
mite	6	62	4941	2	_mite
nite	4	59	4358	2	_nite
ovate	8	42	1439	2	ovate
ovine	8	63	1664	2	ovine
pelite	8	43	2300	2	pelite
petite	8	43	2065	2	petite
quite	14	46	2146	2	quite
recite	8	36	2511	2	recite
resite	6	41	2845	2	resite
revile	9	49	2161	2	revile
revise	9	40	1974	2	revise
revive	12	49	1482	2	revive
revote	9	49	1745	2	revote
rite	4	58	4945	2	_rite
site	4	70	5241	2	_site
skite	9	51	2005	2	skite
smite	7	52	2487	2	smite
spite	7	54	3066	2	spite
suite	5	48	2956	2	suite
trite	5	47	3003	2	trite
unite	5	48	2838	2	unite
verite	9	43	2344	2	verite
vibe	9	51	2450	2	_vibe
vice	9	57	3285	2	_vice
vide	8	54	3276	2	_vide
vie	6	54	4763	2	_vi_e
vile	7	61	3980	2	_vile
vine	7	56	4368	2	_vine
vise	7	56	3267	2	_vise
vita	7	58	2852	2	_vita
vitae	8	42	1763	2	_vitae
vive	10	54	2662	2	_vive
vote	7	47	2862	2	_vote
white	11	49	2030	2	white
wite	7	54	4327	2	_wite
write	8	55	2283	2	write

Search took 2 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.313	570897.8
2	DLD Change Limit	53800	90	1.530	35163.4
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	1.876	95251.1