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

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

262 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
puffin	14	114	900	(None)
muffin	14	29	887	1	muffin
puffing	16	29	1094	1	puffing
puffins	15	27	891	1	puffins
biffin	14	36	910	2	biffin
boffin	14	35	905	2	boffin
buffi	13	61	1220	2	buffi_
buffing	16	34	1139	2	buffing
coffin	14	33	981	2	coffin
cuffing	16	32	1025	2	cuffing
huffing	17	27	883	2	huffing
luffing	14	33	1010	2	luffing
muffing	16	32	1040	2	muffing
muffins	15	30	834	2	muffins
puff	12	55	2543	2	puff__
puffed	15	35	1060	2	puffed
puffer	14	46	1073	2	puffer
puffier	15	4	797	2	puffier
puffily	18	3	484	2	puffily
puffs	13	41	1493	2	puff_s
puffy	16	44	1075	2	puff_y
punkin	12	36	1152	2	punkin
purin	7	55	2759	2	pu_rin
purlin	8	36	1586	2	purlin
ruffian	13	4	413	2	ruffian
ruffing	14	32	1084	2	ruffing
suffix	19	3	523	2	suffix
tiffin	12	32	793	2	tiffin
affine	12	3	1050	3	_affine
affix	18	3	600	3	_affix
auxin	12	14	1191	3	au_xin
baffing	16	40	1160	3	baffing
biffing	16	35	1001	3	biffing
biffins	15	35	853	3	biffins
bluefin	12	4	512	3	bluefin
bluffing	17	27	549	3	bluffing
boffing	16	33	998	3	boffing
boffins	15	32	907	3	boffins
bowfin	14	33	835	3	bowfin
buff	12	52	2985	3	buff__
buffed	15	43	1314	3	buffed
buffer	14	45	1268	3	buffer
buffet	14	31	1378	3	buffet
buffier	15	6	840	3	buffier
buffo	13	51	1218	3	buff_o
buffoon	15	4	371	3	buffoon
buffos	14	44	785	3	buffos
buffs	13	55	1951	3	buff_s
buffy	16	50	1337	3	buff_y
bumkin	14	30	808	3	bumkin
burin	7	56	2606	3	bu_rin
buskin	12	38	1149	3	buskin
caffein	15	3	533	3	caffein
chuffing	20	5	504	3	chuffing
coffing	16	38	1125	3	coffing
coffins	15	31	1019	3	coffins
cuff	12	53	2799	3	cuff__
cuffed	15	43	1121	3	cuffed
cufflink	20	15	288	3	cufflink
cuffs	13	50	1749	3	cuff_s
cumin	9	46	1697	3	cu_min
cummin	12	8	878	3	cummin
cutin	7	50	2277	3	cu_tin
daffing	15	36	973	3	daffing
doffing	15	35	779	3	doffing
dubbin	11	32	925	3	dubbin
duff	11	43	2664	3	duff__
duffel	13	40	775	3	duffel
duffer	13	47	1166	3	duffer
duffle	13	36	853	3	duffle
duffs	12	52	1662	3	duff_s
dunlin	7	3	972	3	dunlin
elfin	8	43	1246	3	_elfin
fain	7	58	4056	3	__fain
fin	6	64	5803	3	___fin
fluffing	14	27	541	3	fluffing
foin	7	72	3156	3	__foin
fulfil	12	4	642	3	fulfil
fusain	9	5	864	3	fusain
gaffing	15	37	973	3	gaffing
griffin	14	3	451	3	griffin
gruffing	16	3	527	3	gruffing
guanin	7	6	1080	3	guanin
guff	11	46	2493	3	guff__
guffaw	16	4	279	3	guffaw
guffs	12	44	1482	3	guff_s
gulfing	12	33	947	3	gulfing
haffit	15	3	853	3	haffit
huff	13	56	2384	3	huff__
huffed	16	37	1015	3	huffed
huffier	16	3	749	3	huffier
huffily	19	3	469	3	huffily
huffish	19	3	571	3	huffish
huffs	14	45	1474	3	huff_s
huffy	17	48	1023	3	huff_y
kaffir	16	34	530	3	kaffir
kufi	11	9	1065	3	ku_fi_
kufis	12	4	925	3	ku_fis
luff	10	44	2670	3	luff__
luffa	11	40	902	3	luff_a
luffas	12	33	748	3	luffas
luffed	13	38	1082	3	luffed
luffs	11	45	1628	3	luff_s
lupin	7	52	1584	3	lu_pin
lutein	6	3	1126	3	lutein
maffia	14	32	720	3	maffia
miffing	16	29	840	3	miffing
mucin	9	31	1682	3	mu_cin
muff	12	47	2385	3	muff__
muffed	15	42	1059	3	muffed
muffle	14	33	964	3	muffle
muffling	17	6	550	3	muffling
muffs	13	41	1421	3	muff_s
mufti	10	6	1054	3	mufti_
muftis	11	5	805	3	muftis
muntin	8	29	1518	3	muntin
murein	8	3	1176	3	murein
muslin	8	3	1221	3	muslin
naffing	14	35	903	3	naffing
nubbin	10	30	828	3	nubbin
offing	13	36	864	3	_offing
olefin	9	3	758	3	olefin
outfind	11	3	956	3	outfind
outfit	9	30	1494	3	outfit
outsin	6	36	1755	3	outsin
pain	6	56	4724	3	p__ain
papain	10	3	1379	3	papain
paraffin	16	4	490	3	paraffin
patin	7	68	3285	3	p_atin
paulin	8	3	1298	3	paulin
pavin	10	56	2320	3	p_avin
pectin	10	26	1553	3	pectin
pein	6	58	3494	3	p__ein
pekin	11	15	1442	3	p_ekin
pepsin	10	3	1085	3	pepsin
pfft	12	3	1188	3	p_ff_t
pfui	9	34	979	3	p_fui_
phytin	14	45	900	3	phytin
piaffing	17	3	392	3	piaffing
pidgin	10	25	981	3	pidgin
piffle	14	41	823	3	piffle
piffling	17	4	513	3	piffling
piggin	10	31	1109	3	piggin
pin	5	70	6672	3	p___in
pinyin	11	27	1061	3	pinyin
pipkin	14	24	860	3	pipkin
pippin	9	28	1030	3	pippin
plain	7	48	2330	3	p_lain
poplin	10	4	1348	3	poplin
postin	8	35	2103	3	postin
pouff	13	52	1542	3	pouff__
pouffe	14	44	826	3	pouff_e
pouffed	16	36	595	3	pouffed
pouffes	15	40	812	3	pouffes
pouffs	14	41	812	3	pouff_s
pouffy	17	39	588	3	pouff_y
prefix	18	35	685	3	prefix
profit	11	30	1627	3	profit
pterin	8	10	1415	3	pterin
pubic	11	45	1371	3	pu_bic
pubis	9	46	1646	3	pu_bis
public	12	23	814	3	public
pudding	12	40	1080	3	pudding
pudic	10	46	1456	3	pu_dic
puffers	15	34	920	3	puffers
puffery	18	23	511	3	puffery
puffiest	16	4	731	3	puffiest
puffiness	17	6	436	3	puffin~~ess~~
pugging	12	29	1254	3	pugging
puking	13	39	1306	3	pu_king
puli	6	55	2762	3	pu_li_
pulik	11	36	1330	3	pu_lik
puling	9	36	2140	3	pu_ling
pulis	7	42	2560	3	pu_lis
pulling	10	38	2107	3	pulling
pulping	12	36	1232	3	pulping
pulpit	10	3	1093	3	pulpit
pulsing	10	37	1286	3	pulsing
pulsion	9	3	839	3	pulsion
pulvini	12	3	507	3	pulvini
pumping	14	42	1355	3	pumping
pumpkin	17	4	352	3	pumpkin
pun	5	88	4651	3	pu___n
pundit	9	29	1418	3	pundit
punji	14	3	820	3	punji_
punjis	15	3	669	3	punjis
punkie	12	35	1361	3	punkie
punkins	13	31	1111	3	punkins
punning	10	34	1499	3	punning
punting	10	33	1844	3	punting
pupfish	17	3	553	3	pupfish
pupil	9	47	1298	3	pu_pil
pupping	11	44	1250	3	pupping
purfle	11	25	1118	3	purfle
purfling	14	6	776	3	purfling
purging	11	33	1418	3	purging
puri	6	59	3144	3	pu_ri_
purify	14	39	915	3	purify
purine	8	53	2189	3	pu_rine
purins	8	37	2265	3	pu_rins
puris	7	53	3202	3	pu_ris
purline	9	35	1653	3	purline
purling	10	36	2029	3	purling
purlins	9	34	1542	3	purlins
purloin	9	10	749	3	purloin
purring	10	45	1582	3	purring
pursing	10	37	1555	3	pursing
pushing	13	36	1545	3	pushing
pushpin	14	4	323	3	pushpin
puton	7	36	1791	3	pu_ton
putrid	9	3	1116	3	putrid
putti	7	60	1874	3	putti_
puttie	8	41	1630	3	puttie
putting	10	32	1857	3	putting
putzing	19	35	912	3	putzing
pyin	9	68	2323	3	p__yin
quaffing	24	3	435	3	quaffing
quin	13	58	2392	3	qu__in
quinin	15	28	1195	3	quinin
quoin	14	40	1232	3	qu_oin
raffia	12	28	770	3	raffia
redfin	10	3	1022	3	redfin
reffing	14	37	1217	3	reffing
riffing	14	40	1127	3	riffing
ruff	10	51	2765	3	ruff__
ruffe	11	47	1381	3	ruff_e
ruffed	13	43	1274	3	ruffed
ruffes	12	41	1242	3	ruffes
ruffians	14	4	379	3	ruffians
ruffle	12	41	1167	3	ruffle
ruffling	15	4	609	3	ruffling
ruffly	15	33	667	3	ruffly
ruffs	11	45	1674	3	ruff_s
ruin	4	74	3051	3	ru__in
rutin	5	54	2134	3	ru_tin
scuffing	17	28	711	3	scuffing
sluffing	15	24	730	3	sluffing
snuffing	15	25	679	3	snuffing
soffit	12	3	787	3	soffit
spiffing	17	23	708	3	spiffing
stuffing	15	24	784	3	stuffing
subfix	18	3	507	3	subfix
suffer	12	43	1451	3	suffer
suffice	15	19	757	3	suffice
sulfid	10	3	906	3	sulfid
surfing	11	29	1448	3	surfing
taffia	12	28	690	3	taffia
tiffing	14	33	938	3	tiffing
tiffins	13	32	798	3	tiffins
tuff	10	45	2852	3	tuff__
tuffet	12	26	1208	3	tuffet
tuffs	11	51	1826	3	tuff_s
tufting	11	28	987	3	tufting
turfing	11	30	1005	3	turfing
unfit	8	45	1856	3	_unfit
unfix	15	42	903	3	_unfix
unpin	7	26	1324	3	_unpin
upfling	13	3	709	3	upfling
waffie	15	33	856	3	waffie
waffing	17	37	1024	3	waffing
yaffing	17	33	782	3	yaffing
zaffir	21	39	551	3	zaffir

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	262	5.453	20670.5
3	Display Results	262	262	0.093	2817.2
	(SQL Overall)	178691	262	5.686	31426.5