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

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

317 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
sniffer	13	31	890	(None)
niffer	12	37	844	1	_niffer
sniffed	14	31	818	1	sniffed
sniffers	14	25	712	1	sniffers
sniffier	14	35	663	1	sniffier
sniffler	14	29	682	1	sniffler
snifter	10	34	962	1	snifter
snuffer	13	31	884	1	snuffer
stiffer	13	31	939	1	stiffer
differ	13	39	1084	2	_differ
knifer	13	59	856	2	kni_fer
niffers	13	28	736	2	_niffers
scoffer	15	31	702	2	scoffer
scuffer	15	32	888	2	scuffer
shifter	13	29	1107	2	shifter
sifter	9	45	1623	2	s_ifter
snicker	13	30	1267	2	snicker
snider	7	44	1391	2	sni_der
sniff	11	39	1585	2	sniff__
sniffle	13	28	764	2	sniffle
sniffled	15	27	643	2	sniffled
snifflers	15	27	504	2	snifflers
sniffles	14	25	771	2	sniffles
sniffly	16	26	564	2	sniffly
sniffs	12	37	884	2	sniff_s
sniffy	15	33	719	2	sniff_y
snifters	11	31	860	2	snifters
snigger	9	32	837	2	snigger
sniper	8	44	1364	2	sni_per
snipper	11	39	1132	2	snipper
snuffed	14	30	806	2	snuffed
snuffers	14	32	691	2	snuffers
snuffier	14	27	693	2	snuffier
snuffler	14	31	740	2	snuffler
spiffed	16	25	710	2	spiffed
spiffier	16	25	588	2	spiffier
staffer	13	29	909	2	staffer
stiffed	14	35	958	2	stiffed
stiffen	13	28	602	2	stiffen
stifler	10	29	1146	2	stifler
stuffer	13	34	979	2	stuffer
suffer	12	43	1451	2	s_uffer
swifter	13	31	805	2	swifter
unifier	10	22	1186	2	unifier
whiffer	19	10	532	2	whiffer
biffed	15	44	988	3	_biffed
bluffer	15	39	688	3	bluffer
briefer	12	3	556	3	briefer
buffer	14	45	1268	3	_buffer
chaffer	18	38	947	3	chaffer
chiefer	15	3	686	3	chiefer
chuffer	18	33	714	3	chuffer
cliffier	16	3	391	3	cliffier
coffer	14	41	1286	3	_coffer
coiffe	14	4	704	3	coiffe_
coiffed	16	3	541	3	coiffed
coiffes	15	4	680	3	coiffes
coiffeur	16	4	215	3	coiffeur
coinfer	12	41	939	3	coinfer
conifer	12	32	1264	3	coni_fer
deffer	13	44	1130	3	_deffer
deifier	11	30	1312	3	deifier
differs	14	33	997	3	_differs
doffer	13	39	1135	3	_doffer
drifter	11	34	870	3	drifter
duffer	13	47	1166	3	_duffer
edifier	11	30	926	3	edifier
feoffer	12	3	302	3	feoffer
fifer	11	55	1997	3	_fi_fer
fluffer	12	33	650	3	fluffer
gaffer	13	43	1013	3	_gaffer
gauffer	14	7	442	3	gauffer
goffer	13	40	951	3	_goffer
griffe	13	43	809	3	griffe_
griffes	14	36	792	3	griffes
grifter	11	38	1049	3	grifter
gruffer	14	7	579	3	gruffer
heifer	12	3	820	3	hei_fer
iffier	12	3	675	3	__iffier
infer	8	42	1503	3	__infer
knife	12	100	1013	3	kni_fe_
knifed	14	52	812	3	kni_fed
knifers	14	53	708	3	kni_fers
knifes	13	62	1021	3	kni_fes
knitter	11	34	813	3	knitter
liefer	9	52	957	3	_liefer
lifer	8	58	2215	3	_li_fer
lifter	9	38	1481	3	_lifter
miffed	15	39	871	3	_miffed
miffier	15	3	702	3	_miffier
naffed	13	40	833	3	_naffed
nicer	7	46	1829	3	_ni_cer
nicker	12	38	1870	3	_nicker
niffered	15	4	414	3	_niffered
niftier	10	32	871	3	_niftier
nigger	8	97	1357	3	_nigger
nigher	10	36	1275	3	_nigher
nipper	10	37	1571	3	_nipper
niter	5	50	2897	3	_ni_ter
offer	11	43	1138	3	__offer
ossifier	11	119	627	3	ossifier
piaffer	15	10	444	3	piaffer
pilfer	11	3	916	3	_pilfer
proffer	15	12	693	3	proffer
puffer	14	46	1073	3	_puffer
quaffer	22	3	513	3	quaffer
reifier	10	34	1452	3	reifier
reoffer	13	3	501	3	reoffer
rifer	8	47	2198	3	_ri_fer
riffed	13	38	1156	3	_riffed
riffler	13	32	835	3	_riffler
rifler	9	40	1426	3	_rifler
safer	8	47	2181	3	s__afer
sailer	6	35	2610	3	sai_ler
scarfer	12	45	1108	3	scarfer
sclaffer	16	11	265	3	sclaffer
scoffed	16	26	618	3	scoffed
scoffers	16	28	613	3	scoffers
scuffed	16	29	824	3	scuffed
scuffers	16	30	749	3	scuffers
scuffler	16	28	669	3	scuffler
seiner	6	46	2248	3	sei_ner
seiser	6	53	1834	3	sei_ser
seizer	15	41	1457	3	sei_zer
seriffed	15	9	497	3	seriffed
shicker	16	39	1482	3	shicker
shier	8	54	2894	3	shi__er
shifted	14	35	997	3	shifted
shifters	14	31	985	3	shifters
shiftier	14	3	633	3	shiftier
shikker	13	27	702	3	shikker
shimmer	14	33	1087	3	shimmer
shiner	9	38	2087	3	shi_ner
shinier	10	41	1314	3	shinier
shipper	14	35	1403	3	shipper
shirker	14	37	1134	3	shirker
shiver	12	45	1737	3	shi_ver
shuffler	17	30	679	3	shuffler
sicker	12	40	2390	3	s_icker
sidler	7	47	1696	3	s_idler
siffleur	14	4	183	3	s_iffleur
sifted	10	43	1367	3	s_ifted
sifters	10	37	1478	3	s_ifters
sigher	10	38	1370	3	s_igher
signer	7	40	1562	3	s_igner
signifier	13	4	571	3	signifier
siker	9	53	2603	3	s_i_ker
siller	6	40	2605	3	s_iller
silver	9	38	1581	3	s_ilver
simmer	10	41	1535	3	s_immer
simper	10	36	1629	3	s_imper
singer	7	42	2730	3	s_inger
sinister	8	3	858	3	sinister
sinker	10	36	2090	3	s_inker
sinner	6	43	2059	3	s_inner
sinter	6	36	2592	3	s_inter
sipper	10	39	2098	3	s_ipper
sister	6	44	2158	3	s_ister
sitter	6	33	2338	3	s_itter
siver	8	57	2861	3	s_i_ver
sizer	14	55	2181	3	s_i_zer
sizier	15	148	1339	3	s_izier
skidder	13	6	573	3	skidder
skier	9	51	1959	3	ski__er
skiff	15	36	1279	3	skiff__
skiffle	17	22	520	3	skiffle
skiffled	19	24	442	3	skiffled
skiffles	18	26	570	3	skiffles
skiffs	16	32	701	3	skiff_s
skimmer	15	32	753	3	skimmer
skinker	10	31	944	3	skinker
skinner	11	34	809	3	skinner
skipper	15	33	956	3	skipper
skirter	11	33	848	3	skirter
skitter	11	38	1039	3	skitter
skiver	13	46	1210	3	ski_ver
slicer	8	41	1760	3	sli_cer
slicker	13	33	1453	3	slicker
slider	7	39	1836	3	sli_der
slier	5	48	2724	3	sli__er
slimier	9	32	1201	3	slimier
slimmer	11	42	1134	3	slimmer
slinger	8	34	1382	3	slinger
slipper	11	37	1297	3	slipper
slither	10	41	1298	3	slither
slitter	7	36	1587	3	slitter
sliver	9	41	1659	3	sli_ver
sluffed	14	30	830	3	sluffed
smiler	8	39	1668	3	smi_ler
smirker	13	32	742	3	smirker
smiter	8	36	1641	3	smi_ter
snacker	13	31	1260	3	snacker
snaffle	13	21	624	3	snaffle
snaffled	15	28	520	3	snaffled
snaffles	14	24	603	3	snaffles
snafued	11	3	493	3	snafued
snakier	11	28	1000	3	snakier
snapper	11	35	1207	3	snapper
snarer	6	46	2084	3	sn_arer
snarfed	11	37	875	3	snarfed
snarler	7	36	1063	3	snarler
sneaker	11	29	1045	3	sneaker
sneer	5	49	1995	3	sn__eer
sneerer	7	35	1231	3	sneerer
sneezer	16	23	796	3	sneezer
sneller	7	35	1284	3	sneller
snibbed	12	32	563	3	snibbed
snicked	14	38	1163	3	snicked
snickers	14	30	1096	3	snickers
snickery	17	29	554	3	snickery
snide	6	43	1872	3	sni_de_
sniffiest	15	23	599	3	sniffiest
sniffily	17	15	403	3	sniffily
sniffing	15	22	745	3	sniffing
sniffish	17	4	450	3	sniffish
sniggers	10	31	709	3	sniggers
sniggler	10	39	611	3	sniggler
sniglet	8	36	1241	3	sniglet
snipe	7	53	2057	3	sni_pe_
sniped	9	49	1348	3	sni_ped
snipers	9	33	1176	3	sni_pers
snipes	8	39	1739	3	sni_pes
snipped	12	35	1004	3	snipped
snippers	12	29	971	3	snippers
snippet	11	33	1043	3	snippet
snippier	12	5	579	3	snippier
snitcher	13	15	737	3	snitcher
snivel	9	36	885	3	sni_vel
sniveler	11	5	525	3	sniveler
snooker	11	39	1030	3	snooker
snooper	9	35	1153	3	snooper
snoozer	16	40	918	3	snoozer
snorer	6	43	1676	3	sn_orer
snorter	7	44	1265	3	snorter
snowier	10	3	878	3	snowier
snubber	11	27	773	3	snubber
snuff	11	35	1404	3	snuff__
snuffle	13	26	782	3	snuffle
snuffled	15	27	702	3	snuffled
snufflers	15	28	521	3	snufflers
snuffles	14	31	840	3	snuffles
snufflier	15	4	329	3	snufflier
snuffly	16	30	519	3	snuffly
snuffs	12	35	852	3	snuff_s
snuffy	15	35	624	3	snuff_y
snugger	9	31	831	3	snugger
softer	9	40	1531	3	s_ofter
spicer	10	47	1931	3	spi_cer
spicier	11	51	1246	3	spicier
spider	9	45	1680	3	spi_der
spieler	9	31	1123	3	spieler
spier	7	57	2803	3	spi__er
spiff	13	36	1639	3	spiff__
spiffied	17	23	482	3	spiffied
spiffies	16	27	798	3	spiffies
spiffs	14	32	847	3	spiff_s
spiffy	17	32	622	3	spiff_y
spiker	12	43	1566	3	spi_ker
spikier	13	36	998	3	spikier
spiller	9	29	1432	3	spiller
spinier	9	37	1516	3	spinier
spinner	9	39	1226	3	spinner
spirier	9	32	1407	3	spirier
spitter	9	40	1518	3	spitter
spoofer	12	36	872	3	spoofer
squiffed	24	3	372	3	squiffed
squiffier	24	4	284	3	squiffier
staffed	14	29	828	3	staffed
staffers	14	24	708	3	staffers
sticker	13	35	1588	3	sticker
stiff	11	42	1923	3	stiff__
stiffener	15	4	196	3	stiffener
stiffens	14	24	410	3	stiffens
stiffest	14	3	567	3	stiffest
stiffie	13	24	577	3	stiffie
stiffies	14	25	837	3	stiffies
stiffly	16	23	517	3	stiffly
stiffs	12	38	996	3	stiff_s
stifle	9	36	1190	3	stifle_
stifled	11	35	1109	3	stifled
stiflers	11	23	882	3	stiflers
stifles	10	30	1338	3	stifles
stiller	7	34	1428	3	stiller
stinger	8	43	1468	3	stinger
stinker	11	33	1331	3	stinker
stinter	7	36	1451	3	stinter
stirrer	7	33	822	3	stirrer
stiver	9	39	1573	3	sti_ver
strafer	10	39	1244	3	strafer
stuffed	14	32	897	3	stuffed
stuffers	14	27	738	3	stuffers
stuffier	14	33	661	3	stuffier
suffers	13	31	1354	3	s_uffers
suiter	6	41	2181	3	sui_ter
surfer	9	35	1588	3	s_urfer
surfier	10	26	1354	3	surfier
swifters	14	27	748	3	swifters
swigger	12	33	845	3	swigger
swiller	10	32	1165	3	swiller
swimmer	14	29	765	3	swimmer
swinger	11	38	1256	3	swinger
swisher	13	36	952	3	swisher
swither	13	37	1099	3	swither
tiffed	13	36	839	3	_tiffed
titfer	9	40	952	3	_titfer
trifler	10	39	1215	3	trifler
troffer	13	12	586	3	troffer
unified	11	24	1356	3	unified
unifiers	11	23	717	3	unifiers
unifies	10	27	1471	3	unifies
uniquer	16	7	578	3	uniquer
uniter	6	46	1914	3	uni_ter
whiffed	20	6	447	3	whiffed
whiffers	20	6	449	3	whiffers
whiffet	19	6	534	3	whiffet
whiffler	20	3	348	3	whiffler
zaffer	21	39	715	3	_zaffer

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.143	1249587.4
2	DLD Change Limit	134027	317	6.623	20236.6
3	Display Results	317	317	0.110	2881.8
	(SQL Overall)	178691	317	6.876	25987.6