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

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

404 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
daffier	14	5	783	(None)
draffier	15	7	432	1	draffier
affixer	20	3	391	2	_affixer
baffies	15	36	1294	2	baffies
baffler	15	41	811	2	baffler
buffier	15	6	840	2	buffier
chaffier	19	3	547	2	chaffier
daffed	14	42	949	2	daff_ed
daffiest	15	3	784	2	daffiest
daffily	17	3	513	2	daffily
daffing	15	36	973	2	daffing
dafter	10	48	1334	2	da_fter
dallier	8	42	1537	2	dallier
dandier	9	37	1457	2	dandier
dashier	11	43	1118	2	dashier
daubier	10	3	710	2	daubier
deffer	13	44	1130	2	deff_er
defier	10	51	1865	2	d_efier
deifier	11	30	1312	2	deifier
differ	13	39	1084	2	diff_er
doffer	13	39	1135	2	doff_er
draftier	12	8	526	2	draftier
duffer	13	47	1166	2	duff_er
gaffer	13	43	1013	2	gaff_er
huffier	16	3	749	2	huffier
iffier	12	3	676	2	_iffier
kaffir	16	34	530	2	kaffi_r
miffier	15	3	702	2	miffier
puffier	15	4	797	2	puffier
raffler	13	33	922	2	raffler
taffies	13	30	1269	2	taffies
waffie	15	33	856	2	waffie_
waffies	16	36	1144	2	waffies
waffler	16	37	778	2	waffler
wafflier	17	3	395	2	wafflier
zaffer	21	39	715	2	zaff_er
zaffir	21	39	551	2	zaffi_r
achier	11	39	1426	3	_achier
aerier	6	48	2315	3	_aerier
affair	12	3	435	3	_affair
affaire	13	4	446	3	_affaire
affine	12	3	1050	3	_affine
affined	14	3	641	3	_affined
affines	13	3	948	3	_affines
affirm	14	3	552	3	_affirm
affirmer	16	4	308	3	_affirmer
affix	18	3	600	3	_affi_x
affixed	21	3	412	3	_affixed
affixers	21	4	329	3	_affixers
affixes	20	3	550	3	_affixes
afire	8	62	1591	3	_a_fire
after	8	57	1979	3	_a_fter
airier	6	46	1936	3	_airier
artier	6	34	1973	3	_artier
ashier	9	47	1483	3	_ashier
babier	10	35	1557	3	ba_bier
baffed	15	48	1217	3	baff_ed
baffing	16	40	1160	3	baffing
baffle	14	39	987	3	baffle_
baffled	16	41	806	3	baffled
bafflers	16	35	659	3	bafflers
baffles	15	37	1068	3	baffles
baggier	11	36	1164	3	baggier
balkier	13	41	1198	3	balkier
balmier	11	38	1151	3	balmier
barkier	13	38	1448	3	barkier
barmier	11	43	1304	3	barmier
barnier	9	32	1367	3	barnier
barrier	9	40	1773	3	barrier
basifier	13	3	731	3	basifier
battier	9	35	1571	3	battier
bawdier	13	37	820	3	bawdier
beefier	12	32	909	3	beefier
biffies	15	27	1085	3	biffies
buffer	14	45	1268	3	buff_er
caffein	15	3	533	3	caffein
cagier	9	37	1593	3	ca_gier
cahier	11	36	1577	3	ca_hier
cakier	12	31	1524	3	ca_kier
campier	13	33	1327	3	campier
cannier	9	40	1416	3	cannier
carrier	9	36	1958	3	carrier
cashier	12	37	1332	3	cashier
cattier	9	33	1707	3	cattier
chaffer	18	38	947	3	chaff_er
chuffier	19	3	454	3	chuffier
cliffier	16	3	391	3	cliffier
coffer	14	41	1286	3	coff_er
comfier	14	3	916	3	comfier
craftier	13	7	619	3	craftier
dabber	11	48	1696	3	da_bber
dabbler	12	40	1215	3	dabbler
dabster	10	3	670	3	dabster
dacker	13	49	2075	3	da_cker
daddies	10	34	1494	3	daddies
daff	11	52	2968	3	daff___
daffiness	16	3	484	3	daffiness
daffs	12	51	1642	3	daff__s
daffy	15	55	1028	3	daff__y
dagger	9	50	1730	3	da_gger
daiker	11	51	1303	3	da_iker
dailies	8	42	1926	3	dailies
daintier	9	3	740	3	daintier
dairies	8	42	1773	3	dairies
daisied	9	34	1001	3	daisied
daisies	8	42	1709	3	daisies
dallied	9	37	1361	3	dallied
dalliers	9	36	1061	3	dalliers
dallies	8	40	2319	3	dallies
damager	11	5	798	3	damager
dammer	11	43	1793	3	da_mmer
damner	9	52	1343	3	da_mner
damper	11	41	1775	3	da_mper
dancer	9	48	1761	3	da_ncer
dander	8	112	2299	3	da_nder
dandies	9	41	2144	3	dandies
dandler	9	44	1427	3	dandler
danger	8	37	2282	3	da_nger
dangler	9	69	1281	3	dangler
danglier	10	5	675	3	danglier
danker	11	43	1966	3	da_nker
dapper	11	40	1663	3	da_pper
darbies	10	42	1698	3	darbies
darer	6	52	3079	3	da__rer
darker	11	47	1869	3	da_rker
darkie	11	37	1401	3	darkie_
darkies	12	40	1575	3	darkies
darklier	13	3	501	3	darklier
darner	7	40	1730	3	da_rner
darter	7	53	2036	3	da_rter
dasher	10	43	1898	3	da_sher
dassie	7	46	1557	3	dassie_
dassies	8	44	1866	3	dassies
dater	6	53	3231	3	da__ter
dauber	9	41	1201	3	da_uber
daunder	9	34	889	3	daunder
daunter	8	38	1175	3	daunter
dautie	7	29	1470	3	dautie_
dauties	8	33	1576	3	dauties
davies	10	50	2051	3	da_vies
dawdler	12	35	679	3	dawdler
dawtie	10	30	1109	3	dawtie_
dawties	11	33	1270	3	dawties
dayflies	15	3	446	3	dayflies
dazzler	16	3	471	3	dazzler
deadlier	10	3	686	3	deadlier
deafer	10	41	1481	3	deaf_er
decrier	10	27	1355	3	decrier
deedier	9	30	1159	3	deedier
defacer	13	28	1036	3	defacer
defamer	13	27	1032	3	defamer
defer	9	46	1975	3	d_ef_er
defied	11	50	1638	3	d_efied
defiers	11	39	1399	3	d_efiers
defies	10	46	2405	3	d_efies
defiler	11	39	1188	3	defiler
definer	11	44	1377	3	definer
defter	10	42	1592	3	d_efter
defuser	11	51	1050	3	defuser
deified	12	31	1241	3	deified
deifiers	12	34	899	3	deifiers
deifies	11	33	1745	3	deifies
denier	7	44	2069	3	d_enier
dernier	8	30	1194	3	dernier
dewier	10	40	1346	3	d_ewier
dicier	9	44	1623	3	d_icier
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
dodgier	10	38	824	3	dodgier
doffed	14	42	850	3	doff_ed
doffers	14	35	985	3	doff_ers
doffing	15	35	779	3	doffing
doggier	10	38	1094	3	doggier
doomier	10	36	1012	3	doomier
dopier	9	35	1592	3	d_opier
dorkier	12	28	1002	3	dorkier
dossier	8	37	1169	3	dossier
dotier	7	39	1703	3	d_otier
dottier	8	39	1092	3	dottier
dowdier	12	32	857	3	dowdier
downier	11	29	970	3	downier
dozier	16	36	1163	3	d_ozier
draffiest	16	4	436	3	draffiest
draffish	18	4	455	3	draffish
drafter	11	44	943	3	drafter
draggier	11	13	577	3	draggier
drawlier	12	22	525	3	drawlier
drier	6	44	2396	3	d__rier
drifter	11	34	870	3	drifter
driftier	12	7	512	3	driftier
duckier	14	39	1179	3	duckier
duffel	13	40	775	3	duff_el
duffers	14	34	1009	3	duff_ers
duffle	13	36	853	3	duffle_
duffles	14	30	892	3	duffles
dumpier	12	40	965	3	dumpier
dungier	9	36	858	3	dungier
duskier	12	40	943	3	duskier
dustier	8	38	1413	3	dustier
dwarfer	14	3	368	3	dwarf_er
earlier	7	26	1274	3	earlier
easier	6	42	1846	3	ea_sier
edifier	11	30	926	3	edifier
faddier	12	3	778	3	faddier
faggier	12	30	984	3	faggier
fancier	12	34	1206	3	fancier
farrier	10	35	1489	3	farrier
fattier	10	35	1346	3	fattier
fawnier	13	29	636	3	fawnier
fifer	11	55	1997	3	__fifer
flier	8	60	2340	3	__flier
fluffier	13	26	433	3	fluffier
frier	8	52	2584	3	__frier
gabbier	12	37	963	3	gabbier
gaffe	12	41	1165	3	gaff_e_
gaffed	14	42	1020	3	gaff_ed
gaffers	14	42	871	3	gaff_ers
gaffes	13	48	1110	3	gaff_es
gaffing	15	37	973	3	gaffing
gambier	12	47	1197	3	gambier
gamier	9	36	1793	3	ga_mier
gammier	12	37	1119	3	gammier
gappier	12	36	984	3	gappier
gasifier	12	3	627	3	gasifier
gassier	8	38	1257	3	gassier
gaudier	9	3	845	3	gaudier
gauffer	14	7	442	3	gauffer
gauzier	17	3	563	3	gauzier
gawkier	15	32	652	3	gawkier
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
haffet	15	3	1170	3	haff_et
haffit	15	3	853	3	haffi_t
haffits	16	3	619	3	haffits
hafter	12	48	1588	3	ha_fter
hairier	10	31	1105	3	hairier
hammier	14	35	1065	3	hammier
handier	11	38	1744	3	handier
happier	14	33	1204	3	happier
hardier	11	47	2154	3	hardier
harrier	10	44	1775	3	harrier
hastier	10	39	1662	3	hastier
haulier	10	5	994	3	haulier
hazier	18	47	1240	3	ha_zier
heftier	13	3	720	3	heftier
jaggier	16	33	918	3	jaggier
jammier	18	40	802	3	jammier
jazzier	22	3	388	3	jazzier
jiffies	20	32	747	3	jiffies
kaffirs	17	32	555	3	kaffirs
kaffiyeh	24	6	192	3	kaffiyeh
kafir	12	48	890	3	ka_fi_r
lacier	8	40	2009	3	la_cier
lakier	10	47	1627	3	la_kier
lambier	11	36	1164	3	lambier
lankier	11	37	1163	3	lankier
lardier	8	35	1834	3	lardier
larkier	11	37	1152	3	larkier
lathier	10	3	1083	3	lathier
lazier	15	42	1461	3	la_zier
leafier	10	32	983	3	leafier
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	ma_tier
mazier	17	50	1306	3	ma_zier
muffler	15	39	834	3	muffler
naffed	13	40	833	3	naff_ed
naffing	14	35	903	3	naffing
naggier	9	30	915	3	naggier
nappier	11	44	1117	3	nappier
nastier	7	41	1529	3	nastier
nattier	7	36	1462	3	nattier
niffer	12	37	844	3	niff_er
niftier	10	32	871	3	niftier
oakier	10	40	1139	3	oa_kier
offer	11	43	1138	3	_off_er
officer	15	3	421	3	_officer
pacier	10	50	1868	3	pa_cier
pacifier	15	5	750	3	pacifier
palier	8	50	2356	3	pa_lier
pallier	9	44	1716	3	pallier
palmier	11	33	1217	3	palmier
panier	8	44	2550	3	pa_nier
pannier	9	36	1335	3	pannier
pappier	10	35	1160	3	pappier
parrier	9	37	1765	3	parrier
partier	9	35	2071	3	partier
pastier	9	43	2038	3	pastier
pawkier	16	23	661	3	pawkier
piaffer	15	10	444	3	piaff_er
puffer	14	46	1073	3	puff_er
quaffer	22	3	513	3	quaff_er
racier	8	51	2097	3	ra_cier
raffia	12	28	770	3	raffi_a
raffias	13	23	771	3	raffias
raffish	16	5	884	3	raffish
raffle	12	39	1070	3	raffle_
raffled	14	42	908	3	raffled
rafflers	14	31	736	3	rafflers
raffles	13	36	1184	3	raffles
rafter	9	45	1758	3	ra_fter
rainier	7	16	1426	3	rainier
rallier	7	38	1627	3	rallier
rammier	11	28	1102	3	rammier
randier	8	36	1847	3	randier
rangier	8	37	1435	3	rangier
rapier	8	40	1999	3	ra_pier
rarefier	11	3	535	3	rarefier
raspier	9	31	1064	3	raspier
ratifier	11	3	967	3	ratifier
rattier	7	40	1559	3	rattier
reefier	10	29	1255	3	reefier
reifier	10	34	1452	3	reifier
riffler	13	32	835	3	riffler
ruffler	13	36	972	3	ruffler
rufflier	14	3	401	3	rufflier
safer	8	47	2181	3	sa_f_er
saggier	9	29	1206	3	saggier
sagier	7	37	1716	3	sa_gier
sallier	7	33	2042	3	sallier
saltier	7	43	1863	3	saltier
sandier	8	40	1784	3	sandier
sappier	11	36	1312	3	sappier
sarkier	11	34	1331	3	sarkier
sassier	7	34	1323	3	sassier
saucier	9	8	1028	3	saucier
savvier	13	3	548	3	savvier
sniffier	14	35	664	3	sniffier
snuffier	14	27	694	3	snuffier
spiffier	16	25	588	3	spiffier
staffer	13	29	909	3	staff_er
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
tackier	13	37	1252	3	tackier
taffia	12	28	690	3	taffi_a
taffias	13	37	741	3	taffias
talkier	11	40	1184	3	talkier
tallier	7	28	1721	3	tallier
tangier	8	30	1390	3	tangier
tardier	8	597	1999	3	tardier
tarrier	7	43	2317	3	tarrier
tarsier	7	41	1925	3	tarsier
tartier	7	41	2326	3	tartier
tastier	7	118	1709	3	tastier
tattier	7	42	1624	3	tattier
tawnier	10	31	846	3	tawnier
toffies	13	32	1021	3	toffies
tuftier	10	9	660	3	tuftier
turfier	10	24	979	3	turfier
unifier	10	22	1186	3	unifier
vampier	14	30	823	3	vampier
varier	9	46	1935	3	va_rier
vastier	10	36	1320	3	vastier
wackier	16	36	973	3	wackier
wafer	11	44	1764	3	wa_f_er
waffed	16	45	979	3	waff_ed
waffing	17	37	1024	3	waffing
waffle	15	36	918	3	waffle_
waffled	17	35	752	3	waffled
wafflers	17	30	632	3	wafflers
waffles	16	32	998	3	waffles
wafter	12	41	1461	3	wa_fter
wanier	9	39	2068	3	wa_nier
warier	9	37	2289	3	wa_rier
wartier	10	34	1391	3	wartier
washier	13	36	1115	3	washier
waspier	12	25	905	3	waspier
wavier	12	46	1308	3	wa_vier
waxier	16	43	990	3	wa_xier
wiftier	13	29	773	3	wiftier
yaffed	16	45	732	3	yaff_ed
yaffing	17	33	782	3	yaffing
zaffar	21	38	504	3	zaff_ar
zaffers	22	38	677	3	zaff_ers
zaffirs	22	37	566	3	zaffirs
zaffre	21	35	466	3	zaffre_
zaffres	22	32	499	3	zaffres
zanier	15	43	1471	3	za_nier
zappier	20	45	837	3	zappier

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.390	458182.1
2	DLD Change Limit	134027	404	6.720	19944.5
3	Display Results	404	404	0.156	2589.7
	(SQL Overall)	178691	404	7.266	24592.8