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

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

154 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
serves	9	44	2365	(None)
nerves	9	42	1619	1	nerves
selves	9	41	1961	1	selves
seres	5	54	4889	1	ser_es
serges	7	42	2597	1	serges
series	6	45	4097	1	series
serve	8	54	2596	1	serve_
served	10	46	1681	1	served
server	9	49	1771	1	server
servers	10	32	1483	1	servers
servos	9	38	1272	1	servos
swerves	13	7	753	1	swerves
verves	12	46	1788	1	verves
aeries	6	47	3778	2	aeries
beeves	11	46	1504	2	beeves
bermes	10	60	2300	2	bermes
breves	11	55	1642	2	breves
carves	11	51	2845	2	carves
ceres	7	55	4001	2	cer_es
certes	8	46	2308	2	certes
corves	11	51	2252	2	corves
curves	11	46	1928	2	curves
deaves	10	53	1953	2	deaves
delves	10	49	1708	2	delves
derives	11	40	1781	2	derives
deserves	12	10	989	2	deserves
eaves	8	52	3199	2	_eaves
elves	8	51	1874	2	_elves
ernes	5	52	2481	2	_ernes
erses	5	58	2680	2	_erses
eves	7	62	3046	2	_e_ves
feres	8	60	3818	2	fer_es
heaves	12	41	2030	2	heaves
helves	12	43	1606	2	helves
heres	8	62	4590	2	her_es
heroes	9	49	2383	2	heroes
herpes	11	55	1732	2	herpes
keeves	13	37	1199	2	keeves
kermes	12	46	1613	2	kermes
kernes	10	47	1753	2	kernes
leaves	9	42	2238	2	leaves
merces	10	57	2074	2	merces
merdes	9	45	1860	2	merdes
meres	7	51	4357	2	mer_es
merges	9	41	2249	2	merges
merles	8	53	2276	2	merles
nerve	8	66	1737	2	nerve_
nerved	10	41	1169	2	nerved
neves	8	70	2187	2	ne_ves
observes	13	4	617	2	observes
peeves	11	38	1487	2	peeves
pelves	11	45	1466	2	pelves
peres	7	62	4664	2	per_es
perses	8	54	2806	2	perses
pervs	10	51	1737	2	perv_s
reaves	9	41	2757	2	reaves
reeves	9	47	2149	2	reeves
reives	9	57	2304	2	reives
reserves	11	10	1198	2	reserves
salves	9	42	2176	2	salves
sarees	6	53	2994	2	sarees
sarges	7	51	2859	2	sarges
saves	8	58	3863	2	s_aves
scarves	12	45	1162	2	scarves
screes	8	50	2397	2	screes
scries	8	52	2682	2	scries
scrives	12	44	1427	2	scrives
sedges	8	38	1781	2	sedges
sees	4	53	6105	2	se__es
segues	7	4	1207	2	segues
seines	6	50	2990	2	seines
seises	6	40	2671	2	seises
seizes	15	43	1753	2	seizes
selles	6	44	2698	2	selles
selvas	9	38	1291	2	selvas
semes	7	57	3158	2	se_mes
senses	6	39	2394	2	senses
sepses	8	45	1588	2	sepses
seracs	8	44	1857	2	seracs
serais	6	43	2613	2	serais
serapes	9	52	1810	2	serapes
sere	4	61	5347	2	ser_e_
sered	6	57	3729	2	ser_ed
serenes	7	32	2290	2	serenes
serer	5	59	3551	2	ser_er
serest	6	48	3161	2	ser_est
serfs	8	49	2201	2	ser_fs
serge	6	47	2747	2	serge_
serged	8	41	1877	2	serged
serger	7	38	1974	2	serger
sergers	8	38	1563	2	sergers
serifs	9	40	1705	2	serifs
serines	7	42	2954	2	serines
serins	6	40	2967	2	serins
serous	6	50	2356	2	serous
serows	9	60	1639	2	serows
serries	7	39	2535	2	serries
sers	4	57	4665	2	ser__s
serums	8	39	1630	2	serums
serval	9	39	1341	2	serval
servals	10	34	1075	2	servals
services	13	3	857	2	services
servo	8	45	1668	2	serv_o
seven	8	41	1831	2	se_ven
sevens	9	38	1366	2	se_vens
sever	8	54	2605	2	se_ver
severs	9	41	2112	2	se_vers
sexes	12	61	2622	2	se_xes
shaves	12	52	2493	2	shaves
sheaves	13	44	1297	2	sheaves
sheeves	13	39	1195	2	sheeves
shelves	13	41	1209	2	shelves
shives	12	49	2141	2	shives
shoves	12	49	1942	2	shoves
shrives	13	44	1617	2	shrives
sieves	9	32	1600	2	sieves
sirees	6	46	2458	2	sirees
sires	5	59	4537	2	sir_es
skives	13	41	1394	2	skives
slaves	9	50	2302	2	slaves
sleaves	10	38	1320	2	sleaves
sleeves	10	33	1134	2	sleeves
soaves	9	42	1867	2	soaves
solves	9	50	1822	2	solves
sores	5	54	5428	2	sor_es
sprees	8	56	2064	2	sprees
sprues	8	45	1576	2	sprues
starves	10	46	1455	2	starves
staves	9	45	2519	2	staves
steeves	10	34	1090	2	steeves
steres	6	39	2953	2	ster_es
stoves	9	38	1892	2	stoves
strives	10	41	1937	2	strives
surges	7	39	2459	2	surges
survey	12	41	1167	2	survey
surveys	13	35	757	2	surveys
swerve	12	5	629	2	swerve_
swerved	14	5	570	2	swerved
swerver	13	6	573	2	swerver
swervers	14	5	521	2	swervers
swives	12	39	1518	2	swives
terces	8	39	2141	2	terces
ternes	6	54	2290	2	ternes
turves	9	42	1269	2	turves
varves	12	44	1478	2	varves
verges	10	43	2018	2	verges
vermes	11	50	1914	2	vermes
verses	9	42	2376	2	verses
verve	11	54	1772	2	verve_
vervet	12	46	1906	2	vervet
vervets	13	41	975	2	vervets
weaves	12	36	1637	2	weaves
wherves	16	54	806	2	wherves
zeroes	15	43	1434	2	zeroes

Search took 4 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.346	516448.0
2	DLD Change Limit	82551	154	3.046	27101.4
3	Display Results	154	154	0.046	3347.8
	(SQL Overall)	178691	154	3.438	51975.3