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

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

303 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
sniffed	14	31	818	1	sniffed
sniffer	13	31	890	1	sniffer
sniffers	14	25	712	1	sniffers
sniffles	14	25	771	1	sniffles
sniffs	12	37	884	1	sniff_s
coiffes	15	4	680	2	coiffes
griffes	14	36	792	2	griffes
knifes	13	62	1021	2	kni_fes
niffer	12	37	844	2	_niffer
niffers	13	28	736	2	_niffers
skiffles	18	26	570	2	skiffles
skiffs	16	32	701	2	skiff_s
snaffles	14	24	603	2	snaffles
sniff	11	39	1585	2	sniff__
sniffier	14	35	663	2	sniffier
sniffiest	15	23	599	2	sniffiest
sniffish	17	4	450	2	sniffish
sniffle	13	28	764	2	sniffle
sniffled	15	27	643	2	sniffled
sniffler	14	29	682	2	sniffler
snifflers	15	27	504	2	snifflers
sniffly	16	26	564	2	sniffly
sniffy	15	33	719	2	sniff_y
snifter	10	34	962	2	snifter
snifters	11	31	860	2	snifters
snipes	8	39	1739	2	sni_pes
snuffed	14	30	806	2	snuffed
snuffer	13	31	884	2	snuffer
snuffers	14	32	691	2	snuffers
snuffles	14	31	840	2	snuffles
snuffs	12	35	852	2	snuff_s
spiffed	16	25	710	2	spiffed
spiffies	16	27	798	2	spiffies
spiffs	14	32	847	2	spiff_s
stiffed	14	35	958	2	stiffed
stiffen	13	28	602	2	stiffen
stiffens	14	24	410	2	stiffens
stiffer	13	31	939	2	stiffer
stiffest	14	3	567	2	stiffest
stiffies	14	25	837	2	stiffies
stiffs	12	38	996	2	stiff_s
stifles	10	30	1338	2	stifles
unifies	10	27	1471	2	unifies
animes	8	47	1959	3	ani_mes
anises	6	48	2669	3	ani_ses
biffed	15	44	988	3	_biffed
biffies	15	27	1085	3	_biffies
biffs	13	48	1440	3	_biff_s
bouffes	15	38	863	3	bouffes
cliffs	14	47	759	3	cliff_s
coiffe	14	4	704	3	coiffe_
coiffed	16	3	541	3	coiffed
deifies	11	33	1745	3	deifies
differ	13	39	1084	3	_differ
differs	14	33	997	3	_differs
diffs	12	63	1548	3	_diff_s
edifies	11	30	1228	3	edifies
enisles	7	23	1260	3	enisles
fifes	11	48	2239	3	_fi_fes
gaffes	13	48	1110	3	_gaffes
gliffs	13	43	632	3	gliff_s
goniffs	14	47	390	3	goniff_s
griffe	13	43	809	3	griffe_
griffs	13	39	899	3	griff_s
ignifies	12	7	756	3	ignifies
infixes	17	23	813	3	infixes
jiffies	20	32	747	3	_jiffies
jiffs	18	57	1031	3	_jiff_s
knife	12	100	1013	3	kni_fe_
knifed	14	52	812	3	kni_fed
knifer	13	59	856	3	kni_fer
knifers	14	53	708	3	knifers
knishes	14	3	826	3	knishes
knives	13	45	855	3	kni_ves
miffed	15	39	871	3	_miffed
miffs	13	45	1287	3	_miff_s
minifies	13	3	1289	3	minifies
naffed	13	40	833	3	_naffed
naffs	11	62	1396	3	_naff_s
niches	11	44	1914	3	_niches
nides	6	52	2913	3	_ni_des
nieces	8	41	1271	3	_nieces
nieves	9	43	1129	3	_nieves
nifties	10	26	1250	3	_nifties
nines	5	59	3734	3	_ni_nes
nites	5	57	3634	3	_ni_tes
nitres	6	55	1933	3	_nitres
nixes	12	45	1962	3	_ni_xes
nixies	13	53	1387	3	_nixies
ossifies	11	7	756	3	ossifies
piaffes	15	11	505	3	piaffes
piffles	15	36	876	3	_piffles
pouffes	15	40	812	3	pouffes
quiffs	21	13	543	3	quiff_s
reifies	10	42	1828	3	reifies
riffed	13	38	1156	3	_riffed
riffles	13	39	1116	3	_riffles
riffs	11	51	1461	3	_riff_s
rifles	9	42	1770	3	_rifles
ruffes	12	41	1242	3	_ruffes
safes	8	52	2672	3	s__afes
saices	8	42	2180	3	sai_ces
salifies	11	3	1479	3	salifies
sanicles	10	14	994	3	sanicles
sanies	6	30	3195	3	sani__es
sanities	8	12	1975	3	sanities
scoffed	16	26	618	3	scoffed
scoffer	15	31	702	3	scoffer
scoffers	16	28	613	3	scoffers
scoffs	14	34	750	3	scoff_s
scuffed	16	29	824	3	scuffed
scuffer	15	32	888	3	scuffer
scuffers	16	30	749	3	scuffers
scuffles	16	28	785	3	scuffles
scuffs	14	41	905	3	scuff_s
seiches	12	5	1381	3	seiches
seifs	8	50	1933	3	sei_f_s
seines	6	50	2990	3	sei_nes
seises	6	40	2671	3	sei_ses
seizes	15	43	1753	3	sei_zes
seniles	7	26	1802	3	seni_les
seriffed	15	9	497	3	seriffed
shies	8	61	3655	3	shi__es
shifted	14	35	997	3	shifted
shifter	13	29	1107	3	shifter
shifters	14	31	985	3	shifters
shifts	12	44	1293	3	shi_fts
shikses	14	11	657	3	shikses
shines	9	50	2891	3	shi_nes
shires	9	52	2557	3	shi_res
shives	12	49	2141	3	shi_ves
shuffles	17	29	777	3	shuffles
sices	7	56	3727	3	s_i_ces
sides	6	58	3836	3	s_i_des
sidles	7	47	2115	3	s_idles
sieges	7	38	1683	3	s_ieges
sieves	9	32	1600	3	s_ieves
sifted	10	43	1367	3	s_ifted
sifter	9	45	1623	3	s_ifter
sifters	10	37	1478	3	s_ifters
sifts	8	49	1892	3	s_i_fts
signifies	13	4	706	3	signifies
sikes	9	62	3608	3	s_i_kes
sines	5	59	5482	3	s_i_nes
singes	7	43	2685	3	s_inges
singles	8	35	2043	3	singles
sinuses	7	30	1159	3	sinuses
sipes	7	60	3695	3	s_i_pes
sirees	6	46	2458	3	s_irees
sires	5	59	4537	3	s_i_res
sises	5	52	3383	3	s_i_ses
sisses	6	45	2060	3	s_isses
sites	5	60	4543	3	s_i_tes
sixes	12	45	2636	3	s_i_xes
sixtes	13	36	1240	3	s_ixtes
sizes	14	67	2776	3	s_i_zes
skies	9	50	2683	3	ski__es
skiff	15	36	1279	3	skiff__
skiffle	17	22	520	3	skiffle
skiffled	19	24	442	3	skiffled
skiffless	19	24	304	3	skiffless
skites	10	44	1803	3	ski_tes
skives	13	41	1394	3	ski_ves
slices	8	40	2285	3	sli_ces
slides	7	39	2218	3	sli_des
slieves	10	37	896	3	slieves
slimes	8	47	2204	3	sli_mes
slipes	8	49	2141	3	sli_pes
sluffed	14	30	830	3	sluffed
sluffs	12	34	958	3	sluff_s
smidges	11	44	819	3	smidges
smiles	8	45	2229	3	smi_les
smites	8	39	2192	3	smi_tes
snaffle	13	21	624	3	snaffle
snaffled	15	28	520	3	snaffled
snafued	11	3	493	3	snafued
snafus	9	3	674	3	sn_afus
snakes	10	39	1960	3	sn_akes
snares	6	53	2903	3	sn_ares
snarfed	11	37	875	3	snarfed
snarfs	9	51	1342	3	snarf_s
snashes	10	52	1475	3	snashes
snathes	10	48	1649	3	snathes
sneezes	16	27	850	3	sneezes
snibbed	12	32	563	3	snibbed
snibs	7	56	1375	3	sni__bs
snicked	14	38	1163	3	snicked
snicker	13	30	1267	3	snicker
snickers	14	30	1096	3	snickers
snicks	12	43	1247	3	sni_cks
snide	6	43	1872	3	sni_de_
snider	7	44	1391	3	sni_der
snidest	8	3	1091	3	sni_dest
sniffily	17	15	403	3	sniffily
sniffiness	16	4	375	3	sniffiness
sniffing	15	22	745	3	sniffing
snigger	9	32	837	3	snigger
sniggers	10	31	709	3	sniggers
sniggles	10	30	731	3	sniggles
sniglet	8	36	1241	3	sniglet
sniglets	9	27	681	3	sniglets
snipe	7	53	2057	3	sni_pe_
sniped	9	49	1348	3	sni_ped
sniper	8	44	1364	3	sni_per
snipers	9	33	1176	3	snipers
snipped	12	35	1004	3	snipped
snipper	11	39	1132	3	snipper
snippers	12	29	971	3	snippers
snippet	11	33	1043	3	snippet
snippets	12	22	561	3	snippets
snips	7	58	1801	3	sni__ps
snitches	13	14	898	3	snitches
snits	5	41	2483	3	sni__ts
snivel	9	36	885	3	sni_vel
snivels	10	33	690	3	snivels
snoozes	16	28	976	3	snoozes
snores	6	43	2431	3	sn_ores
snuff	11	35	1404	3	snuff__
snuffier	14	27	693	3	snuffier
snuffiest	15	24	604	3	snuffiest
snuffle	13	26	782	3	snuffle
snuffled	15	27	702	3	snuffled
snuffler	14	31	740	3	snuffler
snufflers	15	28	521	3	snufflers
snuffly	16	30	519	3	snuffly
snuffy	15	35	624	3	snuff_y
snyes	8	50	1275	3	sn__yes
soirees	7	24	1164	3	soirees
souffles	14	29	811	3	souffles
spices	10	43	2603	3	spi_ces
spies	7	60	3762	3	spi__es
spiff	13	36	1639	3	spiff__
spiffied	17	23	482	3	spiffied
spiffier	16	25	588	3	spiffier
spiffiest	17	23	564	3	spiffiest
spiffy	17	32	622	3	spiff_y
spikes	12	45	2071	3	spi_kes
spiles	8	42	2791	3	spi_les
spines	8	51	3203	3	spi_nes
spires	8	46	2811	3	spi_res
spites	8	41	2733	3	spi_tes
spitzes	18	4	917	3	spitzes
spliffs	15	3	356	3	spliff_s
squiffed	24	3	372	3	squiffed
staffed	14	29	828	3	staffed
staffer	13	29	909	3	staffer
staffers	14	24	708	3	staffers
staffs	12	34	975	3	staff_s
sties	5	51	3298	3	sti__es
stiff	11	42	1923	3	stiff__
stiffie	13	24	577	3	stiffie
stiffish	17	4	524	3	stiffish
stiffly	16	23	517	3	stiffly
stiffness	15	4	355	3	stiffness
stifle	9	36	1190	3	stifle_
stifled	11	35	1109	3	stifled
stifler	10	29	1146	3	stifler
stiflers	11	23	882	3	stiflers
stiles	6	43	2876	3	sti_les
stimes	8	59	2057	3	sti_mes
stimies	9	3	1655	3	stimies
stipes	8	45	2405	3	sti_pes
stirpes	9	50	1129	3	stirpes
strafes	10	45	1599	3	strafes
strifes	10	47	1658	3	strifes
stuffed	14	32	897	3	stuffed
stuffer	13	34	979	3	stuffer
stuffers	14	27	738	3	stuffers
stuffs	12	38	1022	3	stuff_s
suffer	12	43	1451	3	s_uffer
suffers	13	31	1354	3	s_uffers
suites	6	37	2740	3	sui_tes
swifter	13	31	805	3	swifter
swifters	14	27	748	3	swifters
swiftest	14	3	435	3	swiftest
swifts	12	40	817	3	swi_fts
swinges	11	34	1342	3	swinges
swipes	11	41	1433	3	swi_pes
swiples	12	33	964	3	swiples
swishes	13	34	1137	3	swishes
swisses	10	41	714	3	swisses
swives	12	39	1518	3	swi_ves
tiffed	13	36	839	3	_tiffed
tiffs	11	44	1488	3	_tiff_s
trifles	10	38	1482	3	trifles
truffes	13	5	677	3	truffes
unfixes	17	23	811	3	unfixes
unifaces	13	4	639	3	unifaces
unified	11	24	1356	3	unified
unifier	10	22	1186	3	unifier
unifiers	11	23	717	3	unifiers
uniques	16	6	744	3	uniques
unites	6	50	2485	3	uni_tes
unities	7	25	2014	3	unities
vinifies	14	3	987	3	vinifies
whiffed	20	6	447	3	whiffed
whiffer	19	10	532	3	whiffer
whiffers	20	6	449	3	whiffers
whiffet	19	6	534	3	whiffet
whiffets	20	7	252	3	whiffets
whiffles	20	3	426	3	whiffles
whiffs	18	3	508	3	whiff_s
wifes	11	45	2256	3	_wi_fes

Search took 9 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.170	1051123.5
2	DLD Change Limit	134027	303	8.300	16147.8
3	Display Results	303	303	0.123	2463.4
	(SQL Overall)	178691	303	8.593	20794.9