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

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

316 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
fillip	11	26	895	(None)
fillips	12	29	813	1	fillips
billie	8	50	1917	2	billie
fill	7	55	4019	2	fill__
fille	8	43	2740	2	fill_e
filled	10	49	2226	2	filled
filler	9	46	2362	2	filler
filles	9	42	2452	2	filles
fillet	9	50	2708	2	fillet
fillies	10	34	2025	2	fillies
filling	11	35	2080	2	filling
filliped	14	3	522	2	filliped
fillo	8	43	1978	2	fill_o
fillos	9	44	1508	2	fillos
fills	8	46	3237	2	fill_s
filly	11	44	2490	2	fill_y
filmi	10	59	1400	2	filmi_
filmic	13	34	845	2	filmic
filmis	11	46	1028	2	filmis
flip	9	63	2426	2	f__lip
follis	9	31	1390	2	follis
gillie	7	48	1694	2	gillie
killie	10	41	1489	2	killie
riflip	11	3	472	2	riflip
villi	8	65	1785	2	villi_
willie	9	41	1645	2	willie
aioli	5	3	1831	3	aioli_
aiolis	6	3	1684	3	aiolis
biali	7	34	1907	3	biali_
bialis	8	36	1716	3	bialis
bill	6	72	3994	3	bill__
billed	9	42	2490	3	billed
biller	8	49	2348	3	biller
billet	8	60	2972	3	billet
billies	9	39	2350	3	billies
billing	10	38	2385	3	billing
billion	9	22	1217	3	billion
billon	8	37	1383	3	billon
billow	11	41	1122	3	billow
bills	7	56	3286	3	bill_s
billy	10	55	2536	3	bill_y
blip	8	83	2277	3	__blip
bollix	15	3	805	3	bollix
celli	7	67	1769	3	celli_
chilli	11	43	1277	3	chilli_
chillis	12	44	1160	3	chillis
cilia	7	30	1676	3	ci_lia
clip	8	69	2400	3	__clip
collie	8	36	2199	3	collie
collop	10	73	1231	3	collop
cullis	8	41	1599	3	cullis
dill	5	52	3997	3	dill__
dilled	8	41	2222	3	dilled
dillies	8	41	2216	3	dillies
dills	6	55	3097	3	dill_s
dilly	9	49	2378	3	dill_y
dollop	9	25	936	3	dollop
faille	9	34	1474	3	faill_e
failles	10	29	1413	3	failles
fall	7	55	3531	3	fall__
fallal	9	36	1269	3	fallal
fallen	9	38	1337	3	fallen
faller	9	46	2123	3	faller
falling	11	36	2158	3	falling
fallow	12	47	1385	3	fallow
falls	8	57	2765	3	fall_s
falsie	9	35	1385	3	falsie
felid	9	47	1717	3	f_elid
fell	7	68	3307	3	fell__
fella	8	49	1865	3	fell_a
fellah	12	49	1077	3	fellah
fellas	9	51	1696	3	fellas
felled	10	37	2030	3	felled
feller	9	44	1955	3	feller
fellies	10	41	1974	3	fellies
felling	11	33	2113	3	felling
felloe	9	35	1392	3	felloe
fellow	12	37	1274	3	fellow
fells	8	53	2738	3	fell_s
felly	11	49	2280	3	fell_y
felsic	11	4	705	3	felsic
ferlie	9	28	1405	3	ferlie
fibril	11	3	716	3	fibril
fibrin	11	3	853	3	fibrin
ficin	10	35	1672	3	fi_cin
field	9	50	1532	3	fiel_d
fields	10	42	1104	3	fields
fil	6	54	4714	3	fi_l__
fila	7	47	2913	3	fi_l_a
filar	8	48	1929	3	fi_lar
filaria	10	3	965	3	filaria
filch	13	48	1332	3	fi_lch
file	7	54	4664	3	fi_l_e
filed	9	53	3190	3	fi_led
filer	8	54	3300	3	fi_ler
filers	9	46	2372	3	filers
files	8	54	4127	3	fi_les
filet	8	55	4016	3	fi_let
filets	9	47	1895	3	filets
filial	9	30	1325	3	filial
filing	10	38	2376	3	filing
fillers	10	43	2021	3	fillers
fillets	10	34	1475	3	fillets
fillings	12	29	1050	3	fillings
filliping	15	4	423	3	fillip~~ing~~
film	9	48	2817	3	fi_l_m
filmed	12	46	1036	3	filmed
filmer	11	41	1240	3	filmer
filmier	12	3	750	3	filmier
filmily	15	3	573	3	filmily
filming	13	32	1035	3	filming
filmlike	17	3	444	3	filmlike
films	10	56	1796	3	fi_lms
filmy	13	61	1404	3	fi_lmy
filo	7	60	3428	3	fi_l_o
filos	8	61	2538	3	fi_los
filose	9	61	1250	3	filose
fils	7	58	3869	3	fi_l_s
filter	9	45	1763	3	filter
filth	11	50	1582	3	fi_lth
filths	12	38	978	3	filths
filthy	15	35	642	3	filthy
filum	10	50	1543	3	fi_lum
finalis	10	33	1366	3	finalis
finis	8	68	2426	3	fi_nis
finlike	14	27	906	3	finlike
firelit	10	3	1086	3	firelit
firkin	13	3	782	3	firkin
fistic	11	8	1257	3	fistic
fitly	11	51	1497	3	fitl_y
fixit	15	48	1930	3	fi_xit
fizgig	20	3	297	3	fizgig
flail	8	53	1618	3	f_lail
flair	8	61	1412	3	f_lair
flap	9	61	2870	3	f__lap
flic	9	62	2373	3	f__lic
flips	10	51	1774	3	f__lips
flir	7	64	2220	3	f__lir
flit	7	65	3927	3	f__lit
flop	9	69	2545	3	f__lop
fluid	9	40	1396	3	f_luid
flump	12	46	1472	3	f_lump
foldup	12	3	381	3	foldup
folia	8	36	1893	3	f_olia
folic	10	53	1932	3	f_olic
folio	8	38	2088	3	f_olio
folkie	13	36	961	3	folkie
folles	9	38	2047	3	folles
follies	10	36	1894	3	follies
follow	12	40	1035	3	follow
folly	11	50	2260	3	foll_y
frill	8	49	1756	3	frill__
frilled	11	39	1160	3	frilled
friller	10	41	1174	3	friller
frillier	11	3	651	3	frillier
frilling	12	30	1149	3	frilling
frills	9	44	1422	3	frill_s
frilly	12	41	1144	3	frill_y
frolic	11	4	920	3	frolic
fulfil	12	4	642	3	fulfil
fulgid	11	3	704	3	fulgid
full	7	52	2915	3	full__
fullam	11	3	836	3	fullam
fulled	10	38	2065	3	fulled
fuller	9	42	2038	3	fuller
fulling	11	40	1970	3	fulling
fulls	8	46	2352	3	full_s
fully	11	48	2086	3	full_y
fusilli	10	4	423	3	fusilli_
fusillis	11	4	356	3	fusillis
gallic	9	4	1164	3	gallic
gallop	9	33	1138	3	gallop
ghillie	11	32	635	3	ghillie
gill	5	63	3618	3	gill__
gilled	8	45	2163	3	gilled
giller	7	45	1973	3	giller
gillied	9	55	1231	3	gillied
gillies	8	41	2096	3	gillies
gilling	9	35	2038	3	gilling
gills	6	47	2819	3	gill_s
gilly	9	43	2163	3	gill_y
girlie	7	37	1146	3	girlie
hili	7	56	2663	3	hi_li_
hill	7	64	3949	3	hill__
hilled	10	40	2222	3	hilled
hiller	9	44	2163	3	hiller
hillier	10	34	1396	3	hillier
hilling	11	38	2177	3	hilling
hillo	8	47	2165	3	hill_o
hilloa	9	47	1303	3	hilloa
hillos	9	46	1889	3	hillos
hills	8	54	3135	3	hill_s
hilltop	12	4	478	3	hilltop
hilly	11	44	2216	3	hill_y
ilia	4	60	2682	3	_i_lia
ill	3	74	3709	3	_ill__
iller	5	48	2129	3	_iller
illite	6	34	1492	3	_illite
ills	4	70	3042	3	_ill_s
illy	7	69	2533	3	_ill_y
inclip	10	3	682	3	inclip
jill	11	64	3026	3	jill__
jillion	14	18	893	3	jillion
jills	12	51	2282	3	jill_s
kilim	11	7	1189	3	ki_lim
kill	8	55	3318	3	kill__
killed	11	39	1877	3	killed
killer	10	49	1795	3	killer
killick	12	9	531	3	killick
killies	11	33	1811	3	killies
killing	12	31	1872	3	killing
kills	9	45	2617	3	kill_s
kiltie	10	32	1096	3	kiltie
lilliput	10	4	419	3	lilliput
lip	5	147	5580	3	___lip
lollop	8	23	878	3	lollop
milia	7	27	1957	3	mi_lia
mill	6	65	4148	3	mill__
mille	7	50	2913	3	mill_e
milled	9	43	2617	3	milled
miller	8	46	2541	3	miller
milles	8	45	2656	3	milles
millet	8	40	3074	3	millet
millier	9	37	1670	3	millier
millime	11	25	1140	3	millime
milline	9	25	1911	3	milline
milling	10	32	2368	3	milling
million	9	18	1314	3	million
milliped	13	3	738	3	milliped
mills	7	54	3505	3	mill_s
mislie	8	32	1915	3	mislie
mislit	8	30	1969	3	mislit
mollie	8	35	1710	3	mollie
nellie	6	36	1481	3	nellie
nielli	6	3	630	3	nielli_
nill	4	56	3430	3	nill__
nilled	7	39	1945	3	nilled
nilling	8	36	1956	3	nilling
nills	5	49	2667	3	nill_s
oilcup	10	4	425	3	oilcup
oilily	9	31	1172	3	oilily
oxlip	14	5	688	3	_oxlip
pallia	8	30	1559	3	pallia
pallid	9	39	1528	3	pallid
pilei	7	40	2178	3	pilei_
pileup	10	43	792	3	pileup
pili	6	61	3035	3	pi_li_
pilis	7	58	2520	3	pi_lis
pill	6	53	3946	3	pill__
pillar	8	3	1402	3	pillar
pilled	9	42	2275	3	pilled
pilling	10	37	2256	3	pilling
pillion	9	20	1170	3	pillion
pillow	11	31	1057	3	pillow
pills	7	41	3097	3	pill_s
pullup	10	4	589	3	pullup
riflips	12	3	416	3	riflips
rill	4	51	4090	3	rill__
rille	5	57	2873	3	rill_e
rilled	7	45	2565	3	rilled
rilles	6	47	2550	3	rilles
rillet	6	48	2885	3	rillet
rilling	8	40	2362	3	rilling
rills	5	50	3271	3	rill_s
sialic	8	3	1363	3	sialic
sialid	7	3	1494	3	sialid
silkie	10	33	1340	3	silkie
sill	4	55	4515	3	sill__
siller	6	40	2606	3	siller
sillier	7	40	1759	3	sillier
sillies	7	34	2508	3	sillies
sillily	10	20	978	3	sillily
sills	5	51	3599	3	sill_s
silly	8	45	2762	3	sill_y
simlin	8	3	1173	3	simlin
slip	6	70	3173	3	__slip
tallis	6	33	1996	3	tallis
tallit	6	34	2273	3	tallit
tefillin	11	4	392	3	tefillin
till	4	59	4120	3	till__
tilled	7	47	2295	3	tilled
tiller	6	42	2254	3	tiller
tilling	8	35	2278	3	tilling
tillite	7	3	1356	3	tillite
tills	5	46	3171	3	till_s
tulip	7	11	1169	3	_tulip
unclip	10	4	699	3	unclip
vill	7	52	3507	3	vill__
villa	8	53	2123	3	vill_a
villae	9	56	1538	3	villae
villain	10	3	848	3	villain
villas	9	61	1726	3	villas
villein	10	3	675	3	villein
vills	8	64	2932	3	vill_s
villus	9	36	1122	3	villus
violin	9	3	1198	3	violin
wallie	9	32	1680	3	wallie
wallop	11	33	1029	3	wallop
wellie	9	28	1491	3	wellie
wilily	12	33	1076	3	wilily
will	7	57	3751	3	will__
willed	10	47	2245	3	willed
willer	9	40	2106	3	willer
willet	9	51	2483	3	willet
willied	11	46	1156	3	willied
willies	10	39	2015	3	willies
willing	11	38	2161	3	willing
willow	12	36	969	3	willow
wills	8	45	2896	3	will_s
willy	11	53	2191	3	will_y
yill	7	56	2897	3	yill__
yills	8	39	2155	3	yill_s
zill	13	57	2761	3	zill__
zillah	18	3	656	3	zillah
zillion	16	18	877	3	zillion
zills	14	40	2078	3	zill_s

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.373	479064.3
2	DLD Change Limit	112716	316	5.173	21789.3
3	Display Results	316	316	0.093	3397.8
	(SQL Overall)	178691	316	5.639	31688.4