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

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

328 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
quiff	20	11	1156	(None)
quaff	20	13	1135	1	quaff
quiffs	21	13	543	1	quiffs
biff	12	50	2689	2	_biff
buff	12	52	2986	2	bu_ff
cliff	13	59	1713	2	cliff
cuff	12	53	2799	2	cu_ff
cuif	9	65	2914	2	cui_f
cuifs	10	48	1469	2	cuifs
diff	11	62	2884	2	_diff
duff	11	43	2664	2	du_ff
gliff	12	49	1566	2	gliff
griff	12	44	1646	2	griff
guff	11	46	2493	2	gu_ff
huff	13	56	2384	2	hu_ff
iff	9	67	3039	2	__iff
jiff	17	53	2141	2	_jiff
luff	10	44	2670	2	lu_ff
miff	12	56	2506	2	_miff
muff	12	47	2386	2	mu_ff
puff	12	55	2543	2	pu_ff
quaffs	21	12	569	2	quaffs
quick	20	43	1106	2	quick
quid	14	49	2235	2	qui_d
quids	15	49	1746	2	quids
quiet	14	45	3073	2	quiet
quill	14	84	1377	2	quill
quilt	14	41	2510	2	quilt
quin	13	58	2392	2	qui_n
quins	14	48	1985	2	quins
quint	14	45	2990	2	quint
quip	15	48	1862	2	qui_p
quips	16	47	1337	2	quips
quipu	16	48	1164	2	quipu
quire	14	49	1713	2	quire
quirk	18	40	1100	2	quirk
quirt	14	46	2423	2	quirt
quit	13	61	3651	2	qui_t
quite	14	46	2146	2	quite
quits	14	41	2235	2	quits
quiz	22	49	2000	2	qui_z
riff	10	44	3010	2	_riff
ruff	10	51	2765	2	ru_ff
skiff	15	36	1280	2	skiff
sniff	11	39	1586	2	sniff
spiff	13	36	1640	2	spiff
squiffy	25	4	257	2	squiffy
stiff	11	42	1924	2	stiff
tiff	10	47	2772	2	_tiff
tuff	10	45	2852	2	tu_ff
whiff	17	3	1006	2	whiff
aff	9	55	3761	3	__aff
alif	7	62	4214	3	ali_f
alifs	8	61	2126	3	alifs
aquifer	19	3	488	3	aquifer
baff	12	46	3227	3	_baff
biffs	13	48	1441	3	_biffs
biffy	16	47	1113	3	_biffy
blaff	13	52	1648	3	blaff
bluff	13	44	1383	3	bluff
boff	12	47	2733	3	_boff
brief	10	54	2260	3	brief
buffi	13	61	1220	3	buffi
buffo	13	51	1218	3	buffo
buffs	13	55	1951	3	buffs
buffy	16	50	1337	3	buffy
build	8	44	1335	3	build
built	7	43	2592	3	built
bumf	11	61	2651	3	bu_mf
bumfs	12	54	1405	3	bumfs
buyoff	17	5	423	3	buyoff
caff	12	56	3167	3	_caff
chaff	16	50	1628	3	chaff
chief	13	44	1948	3	chief
chuff	16	48	1249	3	chuff
cliffs	14	47	759	3	cliffs
cliffy	17	43	524	3	cliffy
clift	10	64	2219	3	clift
coff	12	69	3078	3	_coff
coif	9	63	3791	3	coi_f
coiffe	14	4	704	3	coiffe
coifs	10	57	1870	3	coifs
cuffs	13	50	1749	3	cuffs
cuing	8	54	2019	3	cuing
cuish	10	3	1317	3	cuish
curf	9	75	3878	3	cu_rf
curfs	10	51	2214	3	curfs
cutoff	14	3	656	3	cutoff
daff	11	52	2968	3	_daff
deify	12	41	1276	3	deify
dif	7	68	4690	3	_di_f
diffs	12	63	1548	3	_diffs
difs	8	60	2732	3	_difs
doff	11	62	2578	3	_doff
draff	12	56	1566	3	draff
drift	9	57	2284	3	drift
duffs	12	52	1662	3	duffs
dui	4	64	3338	3	dui__
duit	5	62	4158	3	dui_t
duits	6	50	2188	3	duits
edify	12	30	856	3	edify
eff	9	61	2862	3	__eff
equid	15	46	1032	3	equi_d
equids	16	43	914	3	equids
equine	15	17	1157	3	equine
equip	16	46	726	3	equi_p
equips	17	38	719	3	equips
equity	18	3	810	3	equity
feoff	10	7	1105	3	feoff
fief	10	73	3136	3	_fief
fife	10	60	2770	3	_fife
fluff	10	39	1361	3	fluff
gaff	11	48	2815	3	_gaff
gift	8	67	3579	3	_gift
gliffs	13	43	632	3	gliffs
goniff	13	40	889	3	goniff
grief	9	53	1978	3	grief
griffe	13	43	809	3	griffe
griffs	13	39	899	3	griffs
grift	9	59	2446	3	grift
gruff	12	47	1214	3	gruff
guffs	12	44	1482	3	guffs
guid	6	60	2282	3	gui_d
guide	7	50	1988	3	guide
guids	7	55	1615	3	guids
guild	7	53	1275	3	guild
guile	6	45	2113	3	guile
guilt	6	51	2557	3	guilt
guiro	6	37	1209	3	guiro
guise	6	47	1771	3	guise
gulf	8	49	2942	3	gu_lf
gulfs	9	49	1530	3	gulfs
gulfy	12	46	1200	3	gulfy
howff	17	51	1049	3	howff
huffs	14	45	1474	3	huffs
huffy	17	48	1023	3	huffy
huic	9	48	1805	3	hui_c
if	5	72	3995	3	__i_f
iffy	13	53	1228	3	__iffy
ifs	6	71	2424	3	__ifs
jiffs	18	57	1031	3	_jiffs
jiffy	21	45	831	3	_jiffy
juice	14	3	1132	3	juice
juicy	17	3	828	3	juicy
kaif	11	69	3393	3	kai_f
kaifs	12	57	1564	3	kaifs
kief	11	71	2841	3	_kief
kif	10	59	4119	3	_ki_f
kifs	11	60	2351	3	_kifs
knife	12	100	1013	3	knife
kufi	11	9	1065	3	ku_fi
kufis	12	4	925	3	kufis
lief	7	60	3699	3	_lief
life	7	54	3373	3	_life
lift	7	69	4272	3	_lift
liquify	22	4	403	3	liquify
luffa	11	40	902	3	luffa
luffs	11	45	1628	3	luffs
miffs	13	45	1288	3	_miffs
miffy	16	39	1020	3	_miffy
muffs	13	41	1421	3	muffs
naff	10	51	2893	3	_naff
naif	7	68	3902	3	nai_f
naifs	8	76	1742	3	naifs
neif	7	54	2949	3	nei_f
neifs	8	56	1304	3	neifs
off	9	63	3163	3	__off
pouff	13	52	1542	3	pouff
puffs	13	41	1493	3	puffs
puffy	16	44	1075	3	puffy
purify	14	39	915	3	purify
putoff	14	3	642	3	putoff
qaid	14	60	2384	3	qai_d
qaids	15	61	1631	3	qaids
qi	11	65	2690	3	q_i__
qis	12	69	3438	3	q_i_s
qua	12	48	2197	3	qu__a
quack	20	38	1250	3	quack
quad	14	46	1870	3	qu_ad
quads	15	45	1584	3	quads
quaffed	23	3	425	3	quaffed
quaffer	22	3	513	3	quaffer
quag	14	48	1594	3	qu_ag
quags	15	46	1325	3	quags
quai	13	44	2039	3	qu_ai
quaich	20	4	769	3	quaich
quaigh	19	3	546	3	quaigh
quail	14	43	1436	3	quail
quails	15	34	1264	3	quails
quaint	15	4	1517	3	quaint
quais	14	46	1839	3	quais
quake	18	41	1464	3	quake
quaky	21	43	1074	3	quaky
quale	14	36	1785	3	quale
qualify	22	3	547	3	qualify
qualm	16	35	1118	3	qualm
quant	14	36	2481	3	quant
quare	14	39	2054	3	quare
quark	18	46	1412	3	quark
quart	14	40	2785	3	quart
quash	17	45	1216	3	quash
quasi	14	40	1502	3	quasi
quass	14	44	1376	3	quass
quate	14	45	2141	3	quate
quay	16	46	1835	3	qu_ay
quays	17	46	1204	3	quays
qubit	16	42	1899	3	qubit
qubits	17	37	1035	3	qubits
quean	14	36	1284	3	quean
queen	14	43	1206	3	queen
queer	14	37	1281	3	queer
quell	14	43	1143	3	quell
quern	14	36	1040	3	quern
query	17	42	1208	3	query
quest	14	41	2132	3	quest
queue	14	37	1123	3	queue
quey	16	46	1647	3	qu_ey
queys	17	39	836	3	queys
quiche	20	5	790	3	quiche
quicks	21	38	930	3	quicks
quiets	15	40	1437	3	quiets
quills	15	38	1185	3	quills
quilts	15	41	1254	3	quilts
quince	17	39	1013	3	quince
quinic	17	31	947	3	quinic
quinin	15	28	1195	3	quinin
quinoa	15	37	765	3	quinoa
quinol	15	35	797	3	quinol
quinsy	18	38	635	3	quinsy
quinta	15	33	1237	3	quinta
quinte	15	34	1452	3	quinte
quints	15	43	1656	3	quints
quippu	19	34	486	3	quippu
quippy	22	38	426	3	quippy
quipus	17	45	800	3	quipus
quired	16	37	1195	3	quired
quires	15	40	1575	3	quires
quirks	19	41	911	3	quirks
quirky	22	43	553	3	quirky
quirts	15	42	1355	3	quirts
quitch	20	3	641	3	quitch
quiver	18	27	874	3	quiver
quod	14	54	1362	3	qu_od
quods	15	46	1022	3	quods
quoin	14	40	1232	3	quoin
quoins	15	41	1058	3	quoins
quoit	14	38	1986	3	quoit
quoits	15	37	968	3	quoits
quoll	14	37	949	3	quoll
quota	14	51	1196	3	quota
quote	14	37	1477	3	quote
quoth	17	33	1035	3	quoth
qursh	17	41	1084	3	qursh
raff	10	49	3304	3	_raff
reif	7	69	3765	3	rei_f
reifs	8	48	1909	3	reifs
reify	11	48	1497	3	reify
rif	6	59	5156	3	_ri_f
rife	7	46	3232	3	_rife
riffs	11	51	1461	3	_riffs
rifs	7	49	2900	3	_rifs
rift	7	56	4233	3	_rift
ruboff	14	3	520	3	ruboff
ruffe	11	47	1381	3	ruffe
ruffs	11	45	1674	3	ruffs
ruin	4	74	3051	3	rui_n
ruing	6	72	2105	3	ruing
ruins	5	58	2203	3	ruins
runoff	12	3	541	3	runoff
scoff	13	44	1334	3	scoff
scuff	13	39	1489	3	scuff
seif	7	56	3873	3	sei_f
seifs	8	50	1933	3	seifs
shift	11	42	2514	3	shift
sift	7	107	4066	3	_sift
skiffs	16	32	701	3	skiffs
sluff	11	40	1681	3	sluff
sniffs	12	37	884	3	sniffs
sniffy	15	33	719	3	sniffy
snuff	11	35	1404	3	snuff
spiffs	14	32	847	3	spiffs
spiffy	17	32	622	3	spiffy
spliff	14	3	860	3	spliff
squib	16	37	1050	3	squi_b
squibs	17	31	745	3	squibs
squid	15	42	1190	3	squi_d
squids	16	40	980	3	squids
squiffed	24	3	373	3	squiffed
squill	15	3	723	3	squill
squint	15	42	1479	3	squint
squire	15	59	1246	3	squire
squirm	17	38	767	3	squirm
squirt	15	38	1293	3	squirt
squish	18	3	857	3	squish
staff	11	38	1771	3	staff
stiffs	12	38	996	3	stiffs
stuff	11	38	1705	3	stuff
suing	6	50	2636	3	suing
suint	5	56	3818	3	suint
suit	4	56	4987	3	sui_t
suite	5	48	2956	3	suite
suits	5	50	2805	3	suits
sulfa	8	3	1392	3	sulfa
sulfo	8	3	1336	3	sulfo
surf	7	60	3931	3	su_rf
surfs	8	50	2254	3	surfs
surfy	11	53	1947	3	surfy
swift	11	68	1805	3	swift
tariff	12	7	1136	3	tariff
teff	10	60	2376	3	_teff
thief	11	45	1630	3	thief
tiffs	11	44	1488	3	_tiffs
toff	10	59	2990	3	_toff
tufa	7	50	1661	3	tu_fa
tuffs	11	51	1826	3	tuffs
tuft	7	69	2951	3	tu_ft
tui	3	70	3402	3	tui__
tuis	4	48	2964	3	tui_s
turf	7	53	3405	3	tu_rf
turfs	8	46	2044	3	turfs
turfy	11	43	1540	3	turfy
unify	11	36	1111	3	unify
waff	13	42	2804	3	_waff
waif	10	58	3675	3	wai_f
waifs	11	57	1987	3	waifs
whiffs	18	3	508	3	whiffs
wife	10	52	2802	3	_wife
yaff	13	53	2426	3	_yaff

Search took 4 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	83667	0.326	548131.9
2	DLD Change Limit	83667	328	3.266	25617.6
3	Display Results	328	328	0.093	3526.9
	(SQL Overall)	178691	328	3.685	48491.5