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

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

177 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
suffix	19	3	523	(None)
subfix	18	3	507	1	subfix
affix	18	3	600	2	_affix
buffi	13	61	1220	2	buffi_
muffin	14	29	887	2	muffin
puffin	14	114	900	2	puffin
soffit	12	3	788	2	soffit
suffer	12	43	1451	2	suffer
suffice	15	19	757	2	suffice
suffixal	21	4	285	2	suffixal
suffixed	22	21	434	2	suffixed
suffixes	21	19	635	2	suffixes
sulfid	10	3	906	2	sulfid
unfix	15	42	903	2	_unfix
biffin	14	36	910	3	biffin
boffin	14	35	905	3	boffin
buff	12	52	2986	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
buffing	16	34	1139	3	buffing
buffo	13	51	1218	3	buff_o
buffos	14	44	785	3	buffos
buffs	13	55	1951	3	buff_s
buffy	16	50	1337	3	buff_y
coffin	14	33	981	3	coffin
cuff	12	53	2799	3	cuff__
cuffed	15	43	1121	3	cuffed
cuffing	16	32	1025	3	cuffing
cuffs	13	50	1749	3	cuff_s
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
fix	13	62	3610	3	___fix
fulfil	12	4	642	3	fulfil
guff	11	46	2493	3	guff__
guffaw	16	4	279	3	guffaw
guffs	12	44	1482	3	guff_s
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
huffing	17	27	883	3	huffing
huffish	19	3	571	3	huffish
huffs	14	45	1474	3	huff_s
huffy	17	48	1023	3	huff_y
infix	15	33	777	3	_infix
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
luffing	14	33	1010	3	luffing
luffs	11	45	1628	3	luff_s
maffia	14	32	720	3	maffia
muff	12	47	2386	3	muff__
muffed	15	42	1059	3	muffed
muffing	16	32	1040	3	muffing
muffins	15	30	834	3	muffins
muffle	14	33	964	3	muffle
muffs	13	41	1421	3	muff_s
mufti	10	6	1054	3	mufti_
muftis	11	5	805	3	muftis
outfit	9	30	1495	3	outfit
outfox	16	3	614	3	outfox
prefix	18	35	685	3	prefix
puff	12	55	2543	3	puff__
puffed	15	35	1060	3	puffed
puffer	14	46	1073	3	puffer
puffier	15	4	797	3	puffier
puffily	18	3	484	3	puffily
puffing	16	29	1094	3	puffing
puffins	15	27	891	3	puffins
puffs	13	41	1493	3	puff_s
puffy	16	44	1075	3	puff_y
raffia	12	28	770	3	raffia
reaffix	20	4	232	3	reaffix
refix	15	52	1248	3	_refix
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
ruffian	13	4	413	3	ruffian
ruffing	14	32	1084	3	ruffing
ruffle	12	41	1167	3	ruffle
ruffly	15	33	667	3	ruffly
ruffs	11	45	1674	3	ruff_s
scuff	13	39	1489	3	scuff__
scuffed	16	29	824	3	scuffed
scuffer	15	32	888	3	scuffer
scuffing	17	28	711	3	scuffing
scuffle	15	26	689	3	scuffle
scuffs	14	41	905	3	scuff_s
shuffle	16	27	692	3	shuffle
six	10	53	3974	3	s___ix
sluff	11	40	1681	3	sluff__
sluffed	14	30	830	3	sluffed
sluffing	15	24	730	3	sluffing
sluffs	12	34	958	3	sluff_s
snuff	11	35	1404	3	snuff__
snuffbox	23	4	104	3	snuffbox
snuffed	14	30	807	3	snuffed
snuffer	13	31	885	3	snuffer
snuffier	14	27	694	3	snuffier
snuffily	17	12	432	3	snuffily
snuffing	15	25	680	3	snuffing
snuffle	13	26	783	3	snuffle
snuffly	16	30	520	3	snuffly
snuffs	12	35	853	3	snuff_s
snuffy	15	35	624	3	snuff_y
soffits	13	3	509	3	soffits
softie	9	33	1248	3	softie
souffle	13	30	680	3	souffle
spadix	16	3	611	3	spadix
stiffie	13	24	577	3	stiffie
stuff	11	38	1705	3	stuff__
stuffed	14	32	897	3	stuffed
stuffer	13	34	979	3	stuffer
stuffier	14	33	662	3	stuffier
stuffily	17	12	416	3	stuffily
stuffing	15	24	784	3	stuffing
stuffs	12	38	1022	3	stuff_s
stuffy	15	31	708	3	stuff_y
subfile	12	20	1050	3	subfile
subfixes	20	20	749	3	subfixes
submit	10	3	1267	3	submit
suffari	13	4	550	3	suffari
suffaris	14	4	508	3	suffaris
suffers	13	31	1354	3	suffers
sufficed	17	20	566	3	sufficed
sufficer	16	22	582	3	sufficer
suffices	16	20	818	3	suffices
suffixing	23	4	347	3	suffix~~ing~~
suffixion	22	5	224	3	suffix~~ion~~
suffuse	13	3	544	3	suffuse
suit	4	56	4987	3	su__it
sulci	7	6	1505	3	sulci_
sulfa	8	3	1392	3	sulf_a
sulfas	9	3	1156	3	sulfas
sulfide	11	3	810	3	sulfide
sulfids	11	3	729	3	sulfids
sulfite	10	3	1047	3	sulfite
sulfo	8	3	1336	3	sulf_o
sulfur	9	3	791	3	sulfur
summit	10	3	1154	3	summit
sunfish	13	3	888	3	sunfish
sunlit	6	15	1610	3	sunlit
superfix	20	4	546	3	superfix
surf	7	60	3931	3	surf__
surfed	10	38	1446	3	surfed
surfeit	10	3	1034	3	surfeit
surfer	9	35	1588	3	surfer
surffish	17	4	478	3	surffish
surfier	10	26	1354	3	surfier
surfing	11	29	1448	3	surfing
surfs	8	50	2254	3	surf_s
surfy	11	53	1947	3	surf_y
surtax	13	3	784	3	surtax
sushi	8	3	1049	3	sushi_
sushis	9	3	1118	3	sushis
suslik	10	3	637	3	suslik
taffia	12	28	690	3	taffia
tiffin	12	32	793	3	tiffin
tuff	10	45	2852	3	tuff__
tuffet	12	26	1208	3	tuffet
tuffs	11	51	1826	3	tuff_s
unfit	8	45	1856	3	_unfit
unfixt	16	39	842	3	_unfixt
unmix	14	38	897	3	_unmix
waffie	15	33	856	3	waffie
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.376	475242.0
2	DLD Change Limit	112716	177	4.953	22757.1
3	Display Results	177	177	0.046	3847.8
	(SQL Overall)	178691	177	5.375	33244.8