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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

333 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
novices	12	3	822	(None)
notices	9	3	1228	1	notices
novice	11	3	843	1	novice_
advices	13	13	693	2	advices
bodices	12	7	1059	2	bodices
bovines	12	4	1266	2	bovines
codices	12	5	1258	2	codices
devices	13	32	1258	2	devices
invoices	13	13	586	2	invoices
movies	11	51	1845	2	movi_es
navies	9	52	1862	2	navi_es
noises	6	50	2185	2	no_ises
nonces	8	44	1883	2	no_nces
norites	7	40	1880	2	norites
notice	8	3	1344	2	notice_
noticed	10	3	786	2	noticed
noticer	9	3	727	2	noticer
noticers	10	3	569	2	noticers
ovines	9	46	1434	2	_ovines
polices	11	31	1805	2	polices
unvoices	13	12	516	2	unvoices
vices	10	57	2553	2	__vices
voices	11	44	1401	2	vo_ices
advice	12	10	788	3	advice_
advises	11	13	897	3	advises
amices	10	50	1801	3	_amices
anodizes	18	3	796	3	anodizes
anomies	9	33	1699	3	anomi_es
apices	10	49	1626	3	_apices
bevies	11	40	1730	3	bevi_es
bices	9	50	2996	3	__bices
bocces	12	39	1202	3	bo_cces
boccies	13	33	1151	3	boccies
bodice	11	7	1142	3	bodice_
bodies	9	45	2414	3	bodi_es
bogies	9	47	2431	3	bogi_es
boites	8	43	2270	3	bo_ites
bolides	10	5	1507	3	bolides
boraces	11	37	1685	3	boraces
borides	10	5	1515	3	borides
bounces	11	38	1368	3	bounces
bovids	12	8	797	3	bovi_ds
bovine	11	7	1243	3	bovine_
calices	11	43	2169	3	calices
carices	11	42	2095	3	carices
cavies	11	45	2500	3	cavi_es
cervices	15	3	713	3	cervices
ceviches	18	3	484	3	ceviches
choices	14	20	1061	3	choices
cilices	11	38	1402	3	cilices
cimices	13	27	980	3	cimices
civics	13	39	782	3	civic_s
civies	11	41	1644	3	civi_es
coerces	11	3	1194	3	coerces
colics	10	42	1990	3	colic_s
colies	8	48	3705	3	coli_es
comics	12	40	1556	3	comic_s
conics	10	39	2059	3	conic_s
conies	8	43	3859	3	coni_es
conines	9	38	2779	3	conines
convicts	15	33	771	3	convicts
convinces	16	4	783	3	convinces
copies	10	41	3030	3	copi_es
coppices	16	3	824	3	coppices
cornices	12	7	1329	3	cornices
cortices	12	6	1501	3	cortices
cosies	8	49	3215	3	cosi_es
cosines	9	41	2267	3	cosines
coves	10	55	3917	3	cov__es
covings	13	45	1124	3	covings
covins	11	46	1806	3	covi_ns
cozies	17	45	2141	3	cozi_es
crevices	15	3	671	3	crevices
culices	11	37	1312	3	culices
cylices	14	35	928	3	cylices
davies	10	50	2051	3	davi_es
deices	9	41	1937	3	_deices
device	12	45	1216	3	device_
devises	11	41	1676	3	devises
devoices	14	30	741	3	devoices
dices	8	64	3424	3	__dices
divides	12	32	1145	3	divides
divines	11	35	1472	3	divines
dobies	9	44	2209	3	dobi_es
dogies	8	50	2225	3	dogi_es
domines	10	29	1897	3	domines
dories	7	52	3236	3	dori_es
doves	9	47	2815	3	dov__es
doxies	14	39	1785	3	doxi_es
enosises	8	3	1100	3	enosises
enounces	10	3	760	3	enounces
entices	9	16	1633	3	entices
envies	9	3	1405	3	envi_es
eosines	7	37	1829	3	eosines
evicts	11	36	855	3	_evicts
evinces	12	3	780	3	_evinces
evites	9	49	1647	3	_evites
fices	10	60	3116	3	__fices
fogies	10	41	1806	3	fogi_es
fomites	12	36	1320	3	fomites
forces	11	44	2213	3	fo_rces
fornices	13	6	910	3	fornices
gobies	9	54	1806	3	gobi_es
helices	12	3	1372	3	helices
hoicks	15	37	828	3	ho_icks
hoises	9	48	2367	3	ho_ises
holies	9	46	3003	3	holi_es
homies	11	45	2472	3	homi_es
homines	12	35	1864	3	homines
hospices	15	8	763	3	hospices
ibices	10	39	816	3	_ibices
ices	6	61	2964	3	___ices
indices	10	35	1344	3	indices
inosines	8	3	1270	3	inosines
inosites	8	3	1279	3	inosites
invites	10	39	1581	3	invites
invoice	12	13	624	3	invoice_
invoiced	14	9	482	3	invoiced
iodides	9	38	1161	3	iodides
iodines	8	36	1663	3	iodines
iodises	8	34	1363	3	iodises
iodizes	17	39	1172	3	iodizes
iolites	7	38	1948	3	iolites
ionics	8	42	1448	3	ionic_s
ionises	7	29	1643	3	ionises
ionizes	16	28	1334	3	ionizes
ivies	8	42	1576	3	_ivi_es
jounces	16	36	985	3	jounces
juices	15	4	942	3	_juices
koines	10	4	1573	3	ko_ines
latices	9	3	1376	3	latices
levies	9	39	1986	3	levi_es
logics	9	57	1112	3	logic_s
looies	6	50	2583	3	looi_es
lories	6	49	3304	3	lori_es
lorises	7	39	1859	3	lorises
louies	6	45	2510	3	loui_es
lovages	11	3	803	3	lovages
loves	8	53	3201	3	lov__es
malices	11	43	1662	3	malices
mavies	11	49	2319	3	mavi_es
mavises	12	28	1299	3	mavises
mobiles	11	28	1312	3	mobiles
moires	8	9	1563	3	mo_ires
molies	8	44	2951	3	moli_es
monies	8	32	3316	3	moni_es
mortices	12	7	1156	3	mortices
motiles	9	33	1743	3	motiles
motives	12	36	1189	3	motives
moves	10	61	2842	3	mov__es
movie	10	53	1913	3	movi_e_
moxies	15	43	1740	3	moxi_es
murices	11	26	1228	3	murices
naives	9	49	1422	3	n_aives
nances	8	36	1864	3	n_ances
nancies	9	35	1684	3	nancies
natives	10	3	1082	3	natives
naves	8	70	3038	3	nav__es
navicert	13	4	488	3	navicert
navicerts	14	4	164	3	navicerts
navvies	13	3	532	3	navvies
nervines	11	23	1046	3	nervines
neves	8	70	2187	3	nev__es
newies	9	10	1407	3	newi_es
nice	6	55	3471	3	n__ice_
nicer	7	46	1829	3	n__icer
nicest	8	23	1566	3	n__icest
niches	11	44	1914	3	n__iches
nicks	11	49	2049	3	n__icks
nides	6	52	2913	3	n__ides
nieces	8	41	1271	3	n_ieces
nines	5	59	3734	3	n__ines
niobites	10	3	731	3	niobites
nites	5	57	3634	3	n__ites
nixes	12	45	1962	3	n__ixes
nixies	13	53	1387	3	nixi_es
nobbles	11	40	1452	3	nobbles
nobles	8	33	1972	3	no_bles
nocks	11	51	2101	3	no__cks
noddies	9	35	1204	3	noddies
noddles	9	29	1129	3	noddles
nodes	6	46	3349	3	no__des
nodical	10	4	986	3	nodical
nodules	8	26	970	3	nodules
noes	4	58	4539	3	no___es
noesises	8	3	850	3	noesises
noils	5	50	2433	3	no_i_ls
noirs	5	56	1546	3	no_i_rs
noise	5	57	2373	3	no_ise_
noised	7	54	1623	3	no_ised
nombles	11	32	1234	3	nombles
nomes	7	49	3312	3	no__mes
nominee	9	3	1158	3	nominee
nominees	10	3	736	3	nominees
nomisms	11	26	874	3	nomisms
nonages	8	3	1384	3	nonages
nonce	7	57	1982	3	no_nce_
nones	5	56	3913	3	no__nes
nonlives	11	3	836	3	nonlives
nonuses	7	33	1386	3	nonuses
noodges	9	31	771	3	noodges
noodles	8	35	1319	3	noodles
noogies	8	28	1458	3	noogies
nookies	11	34	1496	3	nookies
nooses	6	56	2364	3	no_oses
nopales	9	38	1252	3	nopales
norias	6	55	1820	3	nori_as
noris	5	49	2827	3	nori__s
norite	6	32	2113	3	norite_
noses	5	54	3564	3	no__ses
noshes	9	66	1823	3	no_shes
nosier	6	37	1632	3	nosi_er
nosiest	7	34	1567	3	nosi_est
nosiness	8	32	1139	3	nosiness
nosings	8	34	959	3	nosings
notates	7	28	1748	3	notates
notches	12	35	1365	3	notches
notes	5	50	3458	3	no__tes
notifies	11	3	1042	3	notifies
notions	7	40	1448	3	notions
nouses	6	46	2716	3	no_uses
novae	8	59	1312	3	nov_ae_
novas	8	52	1536	3	nov__as
novel	8	56	1599	3	nov__el
novelises	12	4	737	3	novelises
novelizes	21	4	622	3	novelizes
novels	9	55	1250	3	nov_els
novenas	10	3	689	3	novenas
noviciates	15	4	376	3	novic~~iat~~es
nowise	9	5	1107	3	nowise_
noxious	14	4	656	3	noxious
noyades	11	3	656	3	noyades
nozzles	15	27	630	3	nozzles
nuances	9	3	852	3	nuances
nudies	7	52	1709	3	nudi_es
offices	15	3	624	3	offices
ogives	10	36	791	3	_ogives
olives	9	43	1395	3	_olives
oolites	7	28	1784	3	oolites
opines	8	48	2070	3	_opines
orrices	9	12	936	3	orrices
ounces	8	36	1777	3	_ounces
ovibos	11	4	546	3	_ovibos
ovicides	14	4	546	3	_ovicides
ovine	8	63	1664	3	_ovine_
ovules	9	3	822	3	_ovules
oxides	14	10	969	3	_oxides
oximes	15	10	742	3	_oximes
pavises	12	53	1549	3	pavises
plaices	11	4	1114	3	plaices
podites	10	30	1473	3	podites
pogies	9	41	2354	3	pogi_es
poises	8	42	2654	3	po_ises
pokies	12	59	2133	3	poki_es
police	10	29	1856	3	police_
policed	12	32	1223	3	policed
policer	11	31	1268	3	policer
policers	12	25	999	3	policers
policies	12	24	1566	3	policies
polies	8	40	3458	3	poli_es
pollices	12	4	1075	3	pollices
pomaces	13	27	1212	3	pomaces
ponces	10	47	2084	3	po_nces
ponies	8	48	3346	3	poni_es
posies	8	44	3143	3	posi_es
potiches	15	3	920	3	potiches
pounces	11	41	1389	3	pounces
prices	10	45	2454	3	_prices
provides	14	3	988	3	provides
provinces	16	4	685	3	provinces
pumices	13	3	827	3	pumices
radices	10	23	1426	3	radices
ravines	10	42	2023	3	ravines
reviles	10	44	2135	3	reviles
revises	10	42	2053	3	revises
revives	13	47	1554	3	revives
revoices	13	27	899	3	revoices
rices	7	55	3615	3	__rices
roves	8	48	3448	3	rov__es
rovings	11	43	949	3	rovings
saices	8	42	2180	3	_saices
savines	10	44	1763	3	savines
scolices	12	3	873	3	scolices
services	13	3	857	3	services
seviches	16	3	580	3	seviches
sices	7	56	3727	3	__sices
slices	8	40	2285	3	_slices
sluices	9	5	907	3	sluices
solaces	9	31	1613	3	solaces
somites	9	42	1912	3	somites
sonics	8	43	1563	3	sonic_s
sopites	9	38	1717	3	sopites
sorites	7	38	2524	3	sorites
sources	9	3	1217	3	sources
soviet	9	7	2015	3	sovi_et
soviets	10	8	729	3	soviets
sozines	16	6	1126	3	sozines
spices	10	43	2603	3	_spices
splices	11	39	1438	3	splices
tobies	8	45	2102	3	tobi_es
todies	7	42	2355	3	todi_es
toiles	6	39	2351	3	to_iles
tonics	8	36	1786	3	tonic_s
topics	10	47	1458	3	topic_s
torics	8	51	1835	3	toric_s
tories	6	54	3588	3	tori_es
towies	9	35	2119	3	towi_es
toxics	15	39	1020	3	toxic_s
toxines	14	29	1226	3	toxines
trices	8	48	2633	3	_trices
unvoice	12	12	615	3	unvoice_
unvoiced	14	10	630	3	unvoiced
varices	12	33	1357	3	varices
vibes	10	47	1995	3	__vibes
vice	9	57	3285	3	__vice_
viced	11	51	1818	3	__viced
vies	7	52	3862	3	__vi_es
vines	8	51	3764	3	__vines
vires	8	45	2968	3	__vires
vises	8	44	2777	3	__vises
vivaces	15	3	641	3	vivaces
voces	10	59	1805	3	__voces
voice	10	49	1532	3	vo_ice_
voiced	12	39	1011	3	vo_iced
voicer	11	39	1054	3	vo_icer
voicers	12	34	899	3	vo_icers
voiles	9	46	1644	3	vo_iles
vortices	13	6	912	3	vortices
votives	13	33	795	3	votives
wavicles	16	3	378	3	wavicles
wavies	12	50	1984	3	wavi_es
yoicks	15	37	593	3	yo_icks
yowies	12	39	1373	3	yowi_es

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	134027	0.406	440125.6
2	DLD Change Limit	134027	333	5.970	22450.1
3	Display Results	333	333	0.123	2707.3
	(SQL Overall)	178691	333	6.499	27495.2