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

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

229 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
biffins	15	35	853	(None)
biffies	15	27	1085	1	biffies
biffin	14	36	910	1	biffin_
biffing	16	35	1001	1	biffing
boffins	15	32	907	1	boffins
tiffins	13	32	798	1	tiffins
baffies	15	36	1294	2	baffies
baffing	16	40	1160	2	baffing
biffs	13	48	1441	2	biff__s
biggins	11	34	1069	2	biggins
biotins	9	31	1445	2	biotins
boffin	14	35	905	2	boffin_
boffing	16	33	998	2	boffing
bowfins	15	26	770	2	bowfins
buffing	16	34	1139	2	buffing
coffins	15	31	1019	2	coffins
griffins	15	4	478	2	griffins
jiffies	20	32	747	2	jiffies
miffing	16	29	840	2	miffing
muffins	15	30	834	2	muffins
puffins	15	27	891	2	puffins
riffing	14	40	1127	2	riffing
tiffin	12	32	793	2	tiffin_
tiffing	14	33	938	2	tiffing
affine	12	3	1050	3	_affine
affines	13	3	948	3	_affines
aiblins	9	3	1147	3	aiblins
baffles	15	37	1068	3	baffles
baffling	17	5	605	3	baffling
baffs	13	47	1805	3	baff__s
barfing	13	46	1509	3	barfing
basins	8	57	2276	3	b_asins
beduins	10	3	912	3	beduins
beefing	13	39	1147	3	beefing
befits	11	47	1150	3	b_efits
begins	9	44	1530	3	b_egins
benzins	18	3	869	3	benzins
berlins	9	32	1601	3	berlins
bialies	9	36	1841	3	bialies
bialis	8	36	1716	3	biali_s
biasing	10	35	1245	3	biasing
bibbing	11	29	961	3	bibbing
bicorns	11	33	876	3	bicorns
bicrons	11	34	1047	3	bicrons
biddies	11	35	1449	3	biddies
bidding	12	36	1351	3	bidding
biddings	13	39	756	3	biddings
biding	10	47	2079	3	bi_ding
bidis	8	67	2114	3	bi_di_s
bifaces	14	4	806	3	bifaces
biff	12	50	2689	3	biff___
biffed	15	44	988	3	biff_ed
biffy	16	47	1113	3	biff__y
bifid	11	9	1070	3	bi_fi_d
biggies	11	38	1352	3	biggies
biggin	10	37	1060	3	biggin_
bigging	12	28	1588	3	bigging
biggings	13	32	747	3	biggings
bigwigs	14	4	300	3	bigwigs
bikies	12	45	1516	3	bi_kies
biking	13	50	1817	3	bi_king
bikini	12	41	891	3	bi_kini
bikinis	13	34	620	3	bi_kinis
bilbies	11	47	1234	3	bilbies
bilging	11	42	1268	3	bilging
bilking	14	44	1355	3	bilking
billies	9	39	2350	3	billies
billing	10	38	2385	3	billing
billings	11	34	1263	3	billings
billions	10	22	1179	3	billions
billons	9	30	1336	3	billons
binding	11	38	1938	3	binding
bindings	12	38	1047	3	bindings
bindis	9	46	1458	3	bindi_s
binging	11	36	1938	3	binging
binits	8	57	1667	3	bi_nits
binning	10	36	1545	3	binning
bins	6	65	4825	3	b___ins
biofilm	14	4	433	3	biofilm
biofilms	15	4	277	3	biofilms
biogens	10	3	896	3	biogens
bionics	11	43	1087	3	bionics
biopics	13	31	854	3	biopics
biotics	11	38	1217	3	biotics
biotin	8	32	1582	3	biotin_
birdies	10	40	1621	3	birdies
birding	11	40	1492	3	birding
birdings	12	37	882	3	birdings
birkies	13	37	1243	3	birkies
birling	10	43	1705	3	birling
birlings	11	35	961	3	birlings
birring	10	37	1306	3	birring
bisons	8	39	1437	3	bi_sons
biting	9	53	2182	3	bi_ting
bitting	10	37	1729	3	bitting
bittings	11	33	929	3	bittings
blains	8	45	1637	3	b_lains
bluefins	13	4	511	3	bluefins
bluffing	17	27	549	3	bluffing
bobbins	10	34	1034	3	bobbins
bodkins	14	3	831	3	bodkins
boffos	14	56	819	3	boff_os
boffs	13	49	1550	3	boff__s
boudins	10	3	1131	3	boudins
bowfin	14	33	835	3	bowfin_
brains	8	51	2547	3	b_rains
briefing	14	3	694	3	briefing
briefings	15	4	373	3	briefings
brins	7	55	3397	3	b__rins
bromins	11	25	1378	3	bromins
brucins	11	5	800	3	brucins
bruins	8	60	1495	3	b_ruins
buffers	15	33	1079	3	buffers
buffets	15	31	759	3	buffets
buffi	13	61	1220	3	buffi__
buffier	15	6	840	3	buffier
buffiest	16	5	755	3	buffiest
buffoons	16	4	309	3	buffoons
buffos	14	44	785	3	buff_os
buffs	13	55	1951	3	buff__s
bumkins	15	31	801	3	bumkins
burins	8	42	2189	3	b_urins
buskins	13	33	1094	3	buskins
caffeins	16	4	512	3	caffeins
chiffons	19	4	369	3	chiffons
citrins	9	26	1436	3	citrins
coffin	14	33	981	3	coffin_
coffing	16	38	1125	3	coffing
coiffing	17	5	593	3	coiffing
cuffing	16	32	1025	3	cuffing
daffing	15	36	973	3	daffing
diamins	10	3	1221	3	diamins
diazins	17	3	918	3	diazins
differs	14	33	997	3	differs
diffs	12	63	1548	3	diff__s
dioxins	15	6	800	3	dioxins
doffing	15	35	779	3	doffing
elfins	9	48	1094	3	_elfins
fibrins	12	3	863	3	fibrins
ficins	11	35	1398	3	fi_cins
fifing	13	42	1234	3	fi_fing
fifties	13	21	1108	3	fifties
fins	7	58	4909	3	___fins
firkins	14	3	766	3	firkins
foins	8	55	2338	3	__foins
gaffing	15	37	973	3	gaffing
gifting	12	38	1089	3	gifting
griffin	14	3	451	3	griffin_
griffons	15	4	257	3	griffons
haffits	16	3	619	3	haffits
huffing	17	27	883	3	huffing
iffier	12	3	676	3	_iffier
iffiest	13	3	795	3	_iffiest
iffiness	14	3	502	3	_iffiness
iodins	7	42	1652	3	_iodins
jiffs	18	57	1031	3	jiff__s
kaffirs	17	32	555	3	kaffirs
kinins	10	40	1458	3	ki_nins
lifting	11	33	1327	3	lifting
lignins	8	40	1049	3	lignins
linins	6	59	2214	3	li_nins
lipins	8	50	1688	3	li_pins
luffing	14	33	1010	3	luffing
maffias	15	32	728	3	maffias
miffier	15	3	702	3	miffier
miffiest	16	3	712	3	miffiest
miffiness	17	3	452	3	miffiness
miffs	13	45	1288	3	miff__s
mirins	8	39	1890	3	mi_rins
misfits	12	27	966	3	misfits
muffin	14	29	887	3	muffin_
muffing	16	32	1040	3	muffing
naffing	14	35	903	3	naffing
niacins	9	3	854	3	niacins
niffers	13	28	736	3	niffers
nifties	10	26	1250	3	nifties
offing	13	36	864	3	_offing
offings	14	28	583	3	_offings
olefins	10	3	749	3	olefins
piaffing	17	3	392	3	piaffing
pidgins	11	25	912	3	pidgins
piffles	15	36	876	3	piffles
piffling	17	4	513	3	piffling
piggins	11	30	1047	3	piggins
pipkins	15	32	818	3	pipkins
pippins	10	31	975	3	pippins
puffin	14	114	900	3	puffin_
puffing	16	29	1094	3	puffing
raffias	13	23	771	3	raffias
redfins	11	3	992	3	redfins
reffing	14	37	1217	3	reffing
ricins	8	36	1870	3	ri_cins
riffles	13	39	1116	3	riffles
riffling	15	5	611	3	riffling
riffs	11	51	1461	3	riff__s
rifling	11	28	1501	3	rifling
riflings	12	22	730	3	riflings
riflips	12	3	416	3	riflips
rifting	11	35	1500	3	rifting
ruffians	14	4	379	3	ruffians
ruffing	14	32	1084	3	ruffing
sifting	11	30	1459	3	sifting
siftings	12	23	658	3	siftings
simlins	9	3	1184	3	simlins
siskins	11	5	958	3	siskins
sniffing	15	22	745	3	sniffing
soffits	13	3	509	3	soffits
spiffies	16	27	798	3	spiffies
spiffing	17	23	708	3	spiffing
stiffens	14	24	411	3	stiffens
stiffies	14	25	837	3	stiffies
stiffing	15	24	870	3	stiffing
taffias	13	37	741	3	taffias
taffies	13	30	1269	3	taffies
tailfins	11	3	544	3	tailfins
tiepins	9	3	946	3	tiepins
tiffany	16	4	266	3	tiffany
tiffined	15	4	340	3	tiffined
tiffs	11	44	1488	3	tiff__s
toffies	13	32	1021	3	toffies
violins	10	3	1145	3	violins
virgins	11	3	786	3	virgins
waffies	16	36	1144	3	waffies
waffing	17	37	1024	3	waffing
whiffing	21	3	470	3	whiffing
wifing	13	35	1339	3	wi_fing
withins	13	35	1169	3	withins
yaffing	17	33	782	3	yaffing
zaffirs	22	37	566	3	zaffirs

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.140	1276364.3
2	DLD Change Limit	134027	229	8.596	15591.8
3	Display Results	229	229	0.076	3013.2
	(SQL Overall)	178691	229	8.812	20278.1