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

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

388 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
flopper	14	32	847	(None)
flapper	14	35	920	1	flapper
flipper	14	38	914	1	flipper
flopped	15	33	876	1	flopped
floppers	15	33	746	1	floppers
floppier	15	5	463	1	floppier
lopper	10	37	1720	1	_lopper
blooper	11	35	853	2	blooper
bopper	12	38	1383	2	_bopper
chopper	16	36	1189	2	chopper
clapper	13	40	1186	2	clapper
clipper	13	37	1032	2	clipper
clopped	14	36	1152	2	clopped
copper	12	43	2189	2	_copper
cropper	13	33	1296	2	cropper
dropper	12	32	987	2	dropper
eloper	8	54	1415	2	elo_per
flapped	15	32	825	2	flapped
flappers	15	38	838	2	flappers
flappier	15	4	429	2	flappier
flipped	15	35	851	2	flipped
flippers	15	33	800	2	flippers
floater	10	44	1335	2	floater
flogger	12	44	946	2	flogger
flooder	11	25	846	2	flooder
floorer	10	24	807	2	floorer
flopover	16	4	286	2	flopover
floppies	15	4	681	2	floppies
floppy	16	5	487	2	flopp_y
flosser	10	33	969	2	flosser
flouter	10	43	1134	2	flouter
flower	12	48	1550	2	flo_wer
flypaper	18	4	222	2	flypaper
fopped	14	40	1267	2	f_opped
foppery	17	38	562	2	f_oppery
glopped	13	34	761	2	glopped
gloppier	13	5	467	2	gloppier
hopper	13	42	1848	2	_hopper
lapper	10	43	1995	2	_lapper
lipper	10	42	1963	2	_lipper
looper	8	38	1711	2	_looper
loper	7	51	2923	2	_lo_per
lopped	11	42	1862	2	_lopped
loppers	11	30	1410	2	_loppers
loppier	11	36	972	2	_loppier
mopper	12	62	1500	2	_mopper
plopped	11	28	877	2	plopped
popper	9	36	1596	2	_popper
shopper	14	33	1263	2	shopper
slapper	11	35	1246	2	slapper
slipper	11	37	1298	2	slipper
sloper	8	46	1591	2	slo_per
slopped	12	35	1144	2	slopped
sloppier	12	5	570	2	sloppier
stopper	11	30	1260	2	stopper
topper	10	38	1760	2	_topper
whopper	17	32	850	2	whopper
adopter	10	3	676	3	adopter
bebopper	16	4	210	3	bebopper
bleeper	11	45	825	3	bleeper
blipped	14	37	719	3	blipped
bloater	9	40	1342	3	bloater
blocker	15	41	992	3	blocker
blogger	11	44	831	3	blogger
blonder	10	40	1194	3	blonder
bloomer	11	41	981	3	bloomer
blooped	12	39	854	3	blooped
bloopers	12	39	737	3	bloopers
blotter	9	46	1285	3	blotter
blower	11	53	1657	3	blo_wer
blowier	12	4	894	3	blowier
bopped	13	44	1340	3	_bopped
boppers	13	39	1192	3	_boppers
capper	12	44	2198	3	_capper
chipper	16	39	1258	3	chipper
chomper	16	38	1007	3	chomper
chopped	17	45	1100	3	chopped
choppers	17	41	1046	3	choppers
choppier	17	28	664	3	choppier
clamper	13	40	1299	3	clamper
clapped	14	35	1117	3	clapped
clappers	14	33	1083	3	clappers
clasper	11	38	1186	3	clasper
clipped	14	43	983	3	clipped
clippers	14	36	884	3	clippers
clobber	13	37	816	3	clobber
clocker	15	39	1087	3	clocker
clogger	11	43	880	3	clogger
clomped	14	39	897	3	clomped
cloner	8	44	1809	3	clo_ner
closer	8	49	1820	3	clo_ser
clouter	9	35	1169	3	clouter
clover	11	46	1712	3	clo_ver
clowder	13	36	794	3	clowder
cooper	10	42	2112	3	_cooper
coper	9	53	3609	3	_co_per
copier	10	37	2289	3	_copier
copped	13	52	2125	3	_copped
coppers	13	35	1975	3	_coppers
coppery	16	40	939	3	_coppery
copter	10	98	2201	3	_copter
crapper	13	39	1319	3	crapper
cropped	14	38	1206	3	cropped
croppers	14	33	1148	3	croppers
crupper	13	33	856	3	crupper
cupper	12	43	1386	3	_cupper
dapper	11	40	1663	3	_dapper
diopter	10	3	847	3	diopter
dipper	11	40	1779	3	_dipper
doper	8	61	2839	3	_do_per
dopier	9	35	1592	3	_dopier
dorper	9	43	1457	3	_dorper
dripper	12	34	923	3	dripper
dropped	13	32	928	3	dropped
droppers	13	31	860	3	droppers
eloiner	7	14	918	3	eloiner
elope	7	52	1934	3	elo_pe_
eloped	9	59	1414	3	elo_ped
elopers	9	51	1294	3	elo_pers
elopes	8	59	1816	3	elo_pes
feoffer	12	3	302	3	feoffer
flagger	12	46	935	3	flagger
flaker	13	49	1617	3	fl_aker
flakier	14	39	1020	3	flakier
flamer	11	49	1912	3	fl_amer
flamier	12	31	1214	3	flamier
flanger	11	34	1262	3	flanger
flanker	14	39	1129	3	flanker
flappy	16	5	448	3	flapp_y
flasher	13	39	1406	3	flasher
flatter	10	38	1596	3	flatter
flawier	13	37	873	3	flawier
flaxier	17	33	798	3	flaxier
flayer	12	47	1356	3	fl_ayer
fleahopper	20	5	158	3	fl~~eah~~opper
fleecer	12	36	803	3	fleecer
fleer	8	60	2077	3	fl__eer
fleeter	10	32	1036	3	fleeter
flenser	10	3	678	3	flenser
flesher	13	36	1092	3	flesher
flicker	16	36	1062	3	flicker
flier	8	60	2340	3	fl__ier
flinder	11	31	987	3	flinder
flinger	11	37	1051	3	flinger
flippest	15	3	517	3	flippest
flippy	16	5	461	3	flipp_y
flirter	10	31	867	3	flirter
flitter	10	34	1390	3	flitter
flivver	16	3	304	3	flivver
floated	11	33	1270	3	floated
floatel	10	30	801	3	floatel
floaters	11	27	1151	3	floaters
floatier	11	3	698	3	floatier
flocced	15	36	548	3	flocced
flocked	17	45	1025	3	flocked
flockier	17	4	534	3	flockier
floe	7	61	2977	3	flo__e_
floes	8	55	2814	3	flo__es
flogged	13	52	880	3	flogged
floggers	13	38	786	3	floggers
flooded	12	30	793	3	flooded
flooders	12	25	783	3	flooders
flooey	12	39	1017	3	flo_oey
flooie	9	37	1215	3	flooie_
floor	8	42	1523	3	flo__or
floored	11	26	868	3	floored
floorers	11	22	757	3	floorers
flop	9	69	2545	3	flo_p__
flopovers	17	4	256	3	flopovers
floppiest	16	5	477	3	floppiest
floppily	18	4	377	3	floppily
flopping	16	38	877	3	flopping
flops	10	59	2014	3	flo_p_s
florae	9	47	1388	3	florae_
floret	9	3	2112	3	flo_ret
flossed	11	38	853	3	flossed
flossers	11	30	786	3	flossers
flosses	10	34	1197	3	flosses
flossier	11	32	697	3	flossier
flounder	12	3	510	3	flounder
flour	8	49	1645	3	flo__ur
floured	11	28	987	3	floured
flouted	11	32	1081	3	flouted
flouters	11	41	927	3	flouters
flowed	13	35	1376	3	flo_wed
flowerer	14	3	545	3	flowerer
flowers	13	34	1317	3	flo_wers
flowery	16	32	778	3	flo_wery
flubber	14	28	771	3	flubber
fluffer	12	33	650	3	fluffer
flukier	14	39	785	3	flukier
flumped	15	37	771	3	flumped
flunker	14	38	936	3	flunker
flusher	13	30	1227	3	flusher
fluster	10	39	1306	3	fluster
fluter	9	53	1686	3	fl_uter
flutier	10	30	1155	3	flutier
flutter	10	40	1209	3	flutter
flyer	11	49	1625	3	fl__yer
flyover	16	3	351	3	flyover
flypapers	19	4	203	3	flypapers
flytier	13	35	650	3	flytier
foamer	11	47	1431	3	f_oamer
fodder	11	47	1211	3	f_odder
fogger	11	44	1478	3	f_ogger
folder	10	43	1754	3	f_older
folkier	14	35	904	3	folkier
fonder	10	41	2006	3	f_onder
footer	9	43	2077	3	f_ooter
footier	10	41	1511	3	footier
footler	10	40	1187	3	footler
foozler	19	39	759	3	foozler
forcer	11	49	1734	3	f_orcer
forger	10	48	2077	3	f_orger
forker	13	47	1790	3	f_orker
former	11	42	2140	3	f_ormer
foster	9	43	2222	3	f_oster
fouler	9	36	1490	3	f_ouler
fowler	12	37	1258	3	f_owler
foxier	16	39	1003	3	f_oxier
foyer	11	64	1655	3	f_o_yer
fozier	18	37	1066	3	f_ozier
frappe	13	28	695	3	frappe_
frapped	15	31	885	3	frapped
frappes	14	32	838	3	frappes
frippery	18	3	295	3	frippery
fronter	10	36	1158	3	fronter
frother	13	31	1015	3	frother
frowner	13	42	968	3	frowner
gipper	11	42	1530	3	_gipper
gloater	8	37	1101	3	gloater
gloppy	14	5	472	3	glopp_y
glosser	8	34	1081	3	glosser
glover	10	45	1353	3	glo_ver
glower	10	51	1493	3	glo_wer
goopier	10	39	1057	3	goopier
gopher	12	3	918	3	_gopher
gripper	12	44	1071	3	gripper
groper	9	45	1725	3	gro_per
grouper	10	42	1009	3	grouper
gypper	14	34	729	3	_gypper
hepper	13	34	1266	3	_hepper
hipper	13	38	1802	3	_hipper
hooper	11	45	1831	3	_hooper
hoper	10	58	2914	3	_ho_per
hopped	14	43	1811	3	_hopped
hoppers	14	31	1514	3	_hoppers
hoppier	14	31	1070	3	_hoppier
kipper	14	34	1421	3	_kipper
knapper	15	38	715	3	knapper
knopped	16	35	545	3	knopped
lapped	11	43	2003	3	_lapped
lappers	11	37	1746	3	_lappers
lappet	10	38	1772	3	_lappet
lapser	8	41	1314	3	_lapser
leaper	8	81	1894	3	_leaper
leper	7	48	2074	3	_l_eper
limper	10	41	1785	3	_limper
lipped	11	44	1954	3	_lipped
lippen	10	39	1140	3	_lippen
lippers	11	34	1644	3	_lippers
lippier	11	27	1057	3	_lippier
lisper	8	41	1443	3	_lisper
loader	7	43	1631	3	_loader
loafer	9	36	1094	3	_loafer
loaner	6	44	1650	3	_loaner
lobber	10	40	1660	3	_lobber
locker	12	40	1942	3	_locker
lodger	8	65	1769	3	_lodger
lofter	9	46	1472	3	_lofter
logger	8	64	2000	3	_logger
logier	7	50	1573	3	_logier
loiter	6	46	1917	3	_loiter
loller	6	33	1528	3	_loller
loner	5	54	3104	3	_lo_ner
longer	7	58	2320	3	_longer
looker	10	48	1695	3	_looker
looped	9	52	1717	3	_looped
loopers	9	39	1403	3	_loopers
loopier	9	37	1119	3	loopier
looser	6	52	1994	3	_looser
looter	6	42	2232	3	_looter
lope	6	59	4192	3	_lo_pe_
loped	8	51	2833	3	_lo_ped
lopers	8	44	2414	3	_lo_pers
lopes	7	64	3734	3	_lo_pes
loppered	13	32	675	3	_loppered
loppy	12	59	1166	3	_lopp_y
loser	5	47	2867	3	_lo_ser
lotter	6	40	2560	3	_lotter
louder	7	44	1460	3	_louder
loupe	7	53	1951	3	_loupe_
louped	9	53	1638	3	_louped
loupen	8	45	1029	3	_loupen
loupes	8	49	1805	3	_loupes
louver	9	41	1039	3	_louver
lover	8	55	2645	3	_lo_ver
lower	8	58	3041	3	_lo_wer
lumper	10	38	1665	3	_lumper
mapper	12	45	1609	3	_mapper
moper	9	49	2592	3	_mo_per
mopier	10	39	1478	3	_mopier
mopped	13	41	1432	3	_mopped
moppers	13	34	1246	3	_moppers
moppet	12	69	1509	3	_moppet
napper	10	37	1828	3	_napper
nipper	10	37	1571	3	_nipper
peopler	11	3	808	3	peopler
pepper	9	35	1294	3	_pepper
plodder	11	4	600	3	plodder
plotter	9	41	1366	3	plotter
plover	11	53	1261	3	plo_ver
plower	11	43	1506	3	plo_wer
plumper	13	31	877	3	plumper
popped	10	41	1781	3	_popped
poppers	10	34	1486	3	_poppers
poppet	9	27	1732	3	_poppet
proper	10	43	1995	3	pro_per
propped	11	33	1195	3	propped
prosper	11	40	1219	3	prosper
quipper	20	9	582	3	quipper
rapper	10	46	2157	3	_rapper
ripper	10	35	1865	3	_ripper
romper	10	42	1368	3	_romper
roper	7	54	3191	3	_ro_per
ropier	8	41	1880	3	_ropier
sapper	10	38	2235	3	_sapper
scooper	11	38	1203	3	scooper
scupper	13	6	742	3	scupper
shipper	14	35	1404	3	shipper
shoppe	13	31	1032	3	shoppe_
shopped	15	35	1221	3	shopped
shoppers	15	30	1076	3	shoppers
shoppes	14	34	1139	3	shoppes
sipper	10	39	2099	3	_sipper
skipper	15	33	957	3	skipper
slapped	12	35	1184	3	slapped
slappers	12	37	1094	3	slappers
sleeper	9	32	1156	3	sleeper
slipped	12	47	1174	3	slipped
slippers	12	37	1123	3	slippers
slippery	15	27	586	3	slippery
slippier	12	5	653	3	slippier
slobber	11	38	890	3	slobber
slogger	9	43	1048	3	slogger
slope	7	58	2356	3	slo_pe_
sloped	9	42	1685	3	slo_ped
slopers	9	42	1309	3	slo_pers
slopes	8	48	2045	3	slo_pes
sloppy	13	9	530	3	slopp_y
slotter	7	33	1445	3	slotter
slower	9	40	1615	3	slo_wer
snapper	11	35	1207	3	snapper
snipper	11	39	1133	3	snipper
snooper	9	35	1153	3	snooper
soaper	8	45	1787	3	_soaper
sopped	11	48	1990	3	_sopped
soppier	11	27	1158	3	_soppier
stepper	11	30	1085	3	stepper
stomper	11	41	1123	3	stomper
stooper	9	38	1319	3	stooper
stoper	8	43	2010	3	sto_per
stopped	12	45	1220	3	stopped
stoppers	12	39	1059	3	stoppers
stropper	12	4	776	3	stropper
supper	10	41	1543	3	_supper
swapper	14	35	970	3	swapper
swooper	12	38	917	3	swooper
swopped	15	43	767	3	swopped
tapper	10	44	1961	3	_tapper
tipper	10	39	1841	3	_tipper
toper	7	52	3102	3	_to_per
topped	11	46	1772	3	_topped
toppers	11	39	1460	3	_toppers
trapper	11	39	1280	3	trapper
tripper	11	37	1192	3	tripper
trooper	9	42	1036	3	trooper
trouper	9	38	1143	3	trouper
upper	9	37	1426	3	__upper
whapper	17	34	827	3	whapper
whipper	17	36	1138	3	whipper
whooper	15	29	715	3	whooper
whopped	18	35	800	3	whopped
whoppers	18	29	753	3	whoppers
wrapper	14	36	833	3	wrapper
yapper	13	37	1451	3	_yapper
zapper	19	34	1402	3	_zapper
zipper	19	38	1312	3	_zipper

Search took 7 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	388	6.280	21341.9
3	Display Results	388	388	0.143	2713.3
	(SQL Overall)	178691	388	6.829	26166.5