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

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

324 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
miffier	15	3	702	(None)
iffier	12	3	676	1	_iffier
biffies	15	27	1085	2	biffies
buffier	15	6	840	2	buffier
cliffier	16	3	391	2	cliffier
daffier	14	5	783	2	daffier
differ	13	39	1084	2	diff_er
huffier	16	3	749	2	huffier
jiffies	20	32	747	2	jiffies
miffed	15	39	871	2	miff_ed
miffiest	16	3	713	2	miffiest
miffing	16	29	840	2	miffing
milkier	13	34	1116	2	milkier
millier	9	37	1670	2	millier
miltier	9	32	1496	2	miltier
mincier	11	35	1247	2	mincier
mingier	10	38	1529	2	mingier
mintier	9	36	1599	2	mintier
mirier	8	39	1836	2	mi_rier
mirkier	13	31	905	2	mirkier
misfire	12	22	989	2	misfire
mistier	9	34	1871	2	mistier
mitier	8	36	2067	2	mi_tier
muffler	15	39	834	2	muffler
niffer	12	37	844	2	niff_er
niftier	10	32	871	2	niftier
puffier	15	4	797	2	puffier
riffler	13	32	835	2	riffler
sniffier	14	35	664	2	sniffier
spiffier	16	25	588	2	spiffier
wiftier	13	29	773	2	wiftier
affixer	20	3	391	3	_affixer
airier	6	46	1936	3	ai_rier
baffies	15	36	1294	3	baffies
baffler	15	41	811	3	baffler
beefier	12	32	909	3	beefier
biffed	15	44	988	3	biff_ed
biffin	14	36	910	3	biffi_n
biffing	16	35	1001	3	biffing
biffins	15	35	853	3	biffins
bilgier	10	35	853	3	bilgier
bitsier	9	37	907	3	bitsier
bittier	9	42	1166	3	bittier
buffer	14	45	1268	3	buff_er
chaffier	19	3	547	3	chaffier
chuffier	19	3	454	3	chuffier
coffer	14	41	1286	3	coff_er
comfier	14	3	916	3	comfier
deffer	13	44	1130	3	deff_er
defier	10	51	1865	3	_defier
deifier	11	30	1312	3	deifier
dicier	9	44	1623	3	di_cier
dickier	14	35	1245	3	dickier
dictier	10	34	1186	3	dictier
differs	14	33	997	3	diff_ers
diffuser	15	4	314	3	diffuser
dingier	9	35	1367	3	dingier
dinkier	12	34	1150	3	dinkier
dippier	12	31	1139	3	dippier
dirtier	8	33	1209	3	dirtier
dishier	11	36	1340	3	dishier
ditsier	8	30	1029	3	ditsier
ditzier	17	30	796	3	ditzier
dizzier	16	31	754	3	dizzier
doffer	13	39	1135	3	doff_er
draffier	15	7	432	3	draffier
driftier	12	7	512	3	driftier
duffer	13	47	1166	3	duff_er
edifier	11	30	926	3	edifier
fierier	10	35	1119	3	fierier
fifer	11	55	1997	3	fi_f_er
fifties	13	21	1108	3	fifties
filmier	12	3	750	3	filmier
finnier	10	31	995	3	finnier
firrier	10	34	1013	3	firrier
fishier	13	35	985	3	fishier
fizzier	18	32	671	3	fizzier
flier	8	60	2340	3	__flier
fluffier	13	26	433	3	fluffier
frier	8	52	2584	3	__frier
gaffer	13	43	1013	3	gaff_er
giddier	10	30	872	3	giddier
gimpier	12	24	794	3	gimpier
ginnier	8	29	898	3	ginnier
girlier	8	28	952	3	girlier
goffer	13	40	951	3	goff_er
goofier	11	33	931	3	goofier
gruffier	15	4	470	3	gruffier
gulfier	11	3	779	3	gulfier
heftier	13	3	720	3	heftier
hillier	10	34	1396	3	hillier
hinkier	14	36	1079	3	hinkier
hippier	14	32	1210	3	hippier
hissier	10	34	1050	3	hissier
icier	7	43	1375	3	_i_cier
ickier	12	43	992	3	_ickier
iffiest	13	3	796	3	_iffiest
infer	8	42	1503	3	_inf_er
inkier	10	40	1378	3	_inkier
inlier	6	36	1536	3	_inlier
jiggier	16	37	782	3	jiggier
jivier	16	43	861	3	ji_vier
kaffir	16	34	530	3	kaffi_r
kickier	12	34	905	3	kickier
kinkier	10	31	943	3	kinkier
leafier	10	32	983	3	leafier
liefer	9	52	957	3	lief_er
lifer	8	58	2215	3	li_f_er
lifter	9	38	1481	3	li_fter
limbier	11	34	911	3	limbier
limier	8	35	1872	3	li_mier
lingier	8	41	1338	3	lingier
linier	6	44	2379	3	li_nier
lintier	7	36	1380	3	lintier
lippier	11	27	1057	3	lippier
livier	9	75	1459	3	li_vier
loftier	10	3	776	3	loftier
maffia	14	32	720	3	maffi_a
maffias	15	32	728	3	maffias
maffick	21	4	352	3	maffick
mafficker	23	4	225	3	mafficker
maftir	11	3	649	3	mafti_r
malmier	11	36	1195	3	malmier
maltier	9	30	1548	3	maltier
mangier	10	41	1406	3	mangier
manlier	9	24	1402	3	manlier
marlier	9	26	1477	3	marlier
marrier	9	38	1752	3	marrier
massier	9	36	1522	3	massier
matier	8	43	2152	3	m_atier
mazier	17	50	1306	3	m_azier
mealier	9	30	1590	3	mealier
meatier	9	32	1461	3	meatier
merrier	9	26	1230	3	merrier
meshier	12	34	1085	3	meshier
messier	9	34	1292	3	messier
metier	8	35	1769	3	m_etier
mickler	15	33	1023	3	mickler
midair	9	3	799	3	midai_r
middies	11	31	1615	3	middies
middler	11	27	1227	3	middler
midfield	15	20	384	3	midfield
midlifer	14	21	579	3	midlifer
miff	12	56	2506	3	miff___
miffiness	17	3	452	3	miffiness
miffs	13	45	1288	3	miff__s
miffy	16	39	1020	3	miff__y
mightier	14	3	638	3	mightier
milder	9	38	1845	3	mi_lder
miler	7	57	3306	3	mi__ler
milieu	8	3	1411	3	mi_lieu
milker	12	48	1432	3	mi_lker
miller	8	46	2541	3	mi_ller
milliers	10	26	1190	3	milliers
milliner	10	28	1186	3	milliner
milter	8	49	2123	3	mi_lter
mimer	9	48	2576	3	mi__mer
mincer	10	40	1736	3	mi_ncer
minder	9	48	2250	3	mi_nder
miner	7	69	3354	3	mi__ner
mingler	10	42	1384	3	mingler
minified	14	3	965	3	minified
minifies	13	3	1290	3	minifies
miniver	12	3	839	3	miniver
minnies	9	36	1736	3	minnies
minster	9	39	1432	3	minster
minter	8	44	2510	3	mi_nter
minuter	9	35	1041	3	minuter
mirker	12	37	1269	3	mi_rker
misaver	12	4	981	3	misaver
misdoer	10	4	863	3	misdoer
miser	7	54	3040	3	mi__ser
misfed	12	41	1302	3	misf_ed
misfeed	13	38	968	3	misfeed
misfield	14	26	591	3	misfield
misfile	12	26	1155	3	misfile
misfiled	14	27	865	3	misfiled
misfiles	13	31	1098	3	misfiles
misfired	14	23	854	3	misfired
misfires	13	22	1058	3	misfires
misfit	11	28	1383	3	misfi_t
misfits	12	27	966	3	misfits
mislie	8	32	1915	3	mislie_
mislies	9	29	2228	3	mislies
misliker	14	31	957	3	misliker
missies	9	34	2398	3	missies
mister	8	47	2856	3	mi_ster
misuser	9	32	1044	3	misuser
miter	7	57	3479	3	mi__ter
miterer	9	25	1133	3	miterer
mither	11	42	1856	3	mi_ther
mixer	14	50	1764	3	mi__xer
modifier	14	4	670	3	modifier
moldier	10	31	1003	3	moldier
moodier	10	32	1220	3	moodier
moonier	9	37	1410	3	moonier
moorier	9	31	1307	3	moorier
mopier	10	39	1478	3	m_opier
mossier	9	44	1381	3	mossier
mothier	12	19	1021	3	mothier
motlier	9	20	1058	3	motlier
mousier	9	37	1246	3	mousier
muckier	15	34	1148	3	muckier
muddier	11	41	1002	3	muddier
muffed	15	42	1059	3	muff_ed
muffin	14	29	887	3	muffi_n
muffineer	17	4	201	3	muffineer
muffing	16	32	1040	3	muffing
muffins	15	30	834	3	muffins
muffle	14	33	964	3	muffle_
muffled	16	37	778	3	muffled
mufflers	16	31	600	3	mufflers
muffles	15	39	1045	3	muffles
muggier	11	28	894	3	muggier
murkier	13	31	1027	3	murkier
mushier	12	38	1359	3	mushier
muskier	13	43	1273	3	muskier
mussier	9	33	1436	3	mussier
mustier	9	40	1796	3	mustier
muzzier	17	32	655	3	muzzier
mythier	15	12	518	3	mythier
niffers	13	28	736	3	niff_ers
nifties	10	26	1250	3	nifties
nippier	11	31	983	3	nippier
nittier	7	35	1224	3	nittier
offer	11	43	1138	3	_off_er
officer	15	3	421	3	_officer
oilier	6	44	1723	3	oi_lier
piaffer	15	10	444	3	piaffer
pickier	15	39	1297	3	pickier
piffle	14	41	823	3	piffle_
piffled	16	36	640	3	piffled
piffles	15	36	876	3	piffles
piggier	11	35	1000	3	piggier
pilfer	11	3	916	3	pilf_er
pinier	8	40	2469	3	pi_nier
pipier	10	49	1398	3	pi_pier
pithier	12	30	1029	3	pithier
pitier	8	40	1982	3	pi_tier
puffer	14	46	1073	3	puff_er
raffler	13	33	922	3	raffler
reefier	10	29	1255	3	reefier
reifier	10	34	1452	3	reifier
ribbier	11	3	759	3	ribbier
ribier	8	44	1423	3	ri_bier
ridgier	9	3	788	3	ridgier
rifer	8	47	2198	3	ri_f_er
riffed	13	38	1156	3	riff_ed
riffing	14	40	1127	3	riffing
riffle	12	42	1023	3	riffle_
riffled	14	33	860	3	riffled
rifflers	14	33	644	3	rifflers
riffles	13	39	1116	3	riffles
rifler	9	40	1426	3	ri_fler
rimfire	12	4	379	3	rimfire
rimier	8	39	1627	3	ri_mier
riskier	11	3	842	3	riskier
ritzier	16	29	720	3	ritzier
ruffler	13	36	972	3	ruffler
rufflier	14	3	401	3	rufflier
shiftier	14	3	634	3	shiftier
siffleur	14	4	183	3	siffleur
sifter	9	45	1623	3	si_fter
silkier	11	44	1164	3	silkier
sillier	7	40	1759	3	sillier
siltier	7	34	1386	3	siltier
sissier	7	37	1136	3	sissier
sizier	15	148	1339	3	si_zier
smirkier	14	4	443	3	smirkier
sniffer	13	31	890	3	sniff_er
sniffler	14	29	683	3	sniffler
snuffier	14	27	694	3	snuffier
spiffied	17	23	482	3	spiffied
spiffies	16	27	799	3	spiffies
squiffier	24	4	284	3	squiffier
stiffer	13	31	939	3	stiff_er
stiffie	13	24	577	3	stiffie_
stiffies	14	25	838	3	stiffies
stuffier	14	33	662	3	stuffier
suffer	12	43	1451	3	suff_er
sufficer	16	22	582	3	sufficer
surfier	10	26	1354	3	surfier
taffies	13	30	1269	3	taffies
tidier	7	35	1511	3	ti_dier
tiffed	13	36	839	3	tiff_ed
tiffin	12	32	793	3	tiffi_n
tiffined	15	4	340	3	tiffined
tiffing	14	33	938	3	tiffing
tiffins	13	32	798	3	tiffins
tinier	6	36	2223	3	ti_nier
tinnier	7	29	1014	3	tinnier
tippier	11	32	1054	3	tippier
tipsier	9	26	889	3	tipsier
titfer	9	40	952	3	titf_er
toffies	13	32	1021	3	toffies
tuftier	10	9	660	3	tuftier
turfier	10	24	979	3	turfier
unifier	10	22	1186	3	unifier
viewier	13	3	498	3	viewier
vilifier	14	5	669	3	vilifier
vinier	9	37	1674	3	vi_nier
vivifier	17	4	517	3	vivifier
vizier	18	43	1102	3	vi_zier
waffie	15	33	856	3	waffie_
waffies	16	36	1144	3	waffies
waffler	16	37	778	3	waffler
wafflier	17	3	395	3	wafflier
whiffer	19	10	532	3	whiff_er
whiffler	20	3	348	3	whiffler
wifelier	14	3	485	3	wifelier
wiggier	12	41	886	3	wiggier
wilier	9	32	1707	3	wi_lier
wimpier	14	24	805	3	wimpier
windier	11	34	1216	3	windier
wingier	11	34	1328	3	wingier
winier	9	45	2245	3	wi_nier
wirier	9	42	1555	3	wi_rier
wispier	12	24	940	3	wispier
withier	13	29	1049	3	withier
wittier	10	39	1082	3	wittier
zaffer	21	39	715	3	zaff_er
zaffir	21	39	551	3	zaffi_r
zingier	17	36	949	3	zingier
zippier	20	30	819	3	zippier

Search took 8 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.406	440125.6
2	DLD Change Limit	134027	324	6.763	19817.7
3	Display Results	324	324	0.126	2571.4
	(SQL Overall)	178691	324	7.295	24495.0