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

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

250 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
floccing	16	30	603	(None)
flocking	18	34	1087	1	flocking
blocking	17	45	1057	2	blocking
clocking	17	43	1241	2	clocking
flacking	18	43	1179	2	flacking
flecking	18	40	823	2	flecking
fleecing	14	34	757	2	fleecing
flicking	18	41	1004	2	flicking
floating	12	31	1188	2	floating
flocci	13	3	502	2	flocci__
flockings	19	31	434	2	flockings
flogging	14	32	917	2	flogging
flooding	13	23	896	2	flooding
flooring	12	25	988	2	flooring
flopping	16	38	877	2	flopping
flossing	12	24	790	2	flossing
flouncing	15	3	390	2	flouncing
flouring	12	30	1014	2	flouring
flouting	12	26	1047	2	flouting
flowing	14	34	1176	2	flo_wing
forcing	13	40	1375	2	f_orcing
frocking	18	30	957	2	frocking
locking	14	37	1815	2	_locking
locoing	10	28	1097	2	_locoing
blacking	17	42	1360	3	blacking
bloating	11	35	1281	3	bloating
blobbing	12	24	692	3	blobbing
blogging	13	36	901	3	blogging
blooding	12	24	1065	3	blooding
blooming	13	29	943	3	blooming
blooping	13	24	884	3	blooping
blotching	17	3	496	3	blotching
blotting	11	39	1043	3	blotting
blousing	11	3	879	3	blousing
blowing	13	38	1305	3	blo_wing
chocking	20	40	1101	3	chocking
clacking	17	33	1349	3	clacking
clicking	17	36	1098	3	clicking
cloaking	15	29	971	3	cloaking
clogging	13	36	850	3	clogging
clomping	15	32	965	3	clomping
cloning	10	32	1547	3	clo_ning
clonking	15	38	1015	3	clonking
clopping	15	35	1108	3	clopping
closing	10	31	1484	3	clo_sing
clothing	14	27	878	3	clothing
clotting	11	31	1064	3	clotting
clouding	12	26	949	3	clouding
clouring	11	28	1127	3	clouring
clouting	11	30	1168	3	clouting
clowning	14	30	725	3	clowning
cloying	13	35	1175	3	clo_ying
clucking	17	42	999	3	clucking
cocking	16	36	1998	3	_cocking
crocking	17	43	1344	3	crocking
docking	15	36	1501	3	_docking
electing	11	21	1378	3	electing
eloining	9	3	1044	3	eloining
eloping	10	35	1283	3	elo_ping
facing	12	53	2157	3	f__acing
fancying	17	3	535	3	fancying
farcing	13	35	1400	3	f_arcing
fencing	13	24	1113	3	f_encing
feoffing	14	3	296	3	feoffing
fetching	17	29	841	3	fetching
filching	17	3	611	3	filching
flaccid	15	4	439	3	flacci_d
flagging	14	32	923	3	flagging
flailing	12	29	892	3	flailing
flaking	15	41	1449	3	fl_aking
flaming	13	42	1644	3	fl_aming
flamming	16	35	715	3	flamming
flanging	13	27	1058	3	flanging
flanking	16	42	1108	3	flanking
flapping	16	29	815	3	flapping
flaring	11	41	1680	3	fl_aring
flashing	15	37	1155	3	flashing
flatling	12	34	1001	3	flatling
flatting	12	35	1125	3	flatting
flawing	14	38	1256	3	fl_awing
flaying	14	39	1446	3	fl_aying
fledging	14	27	652	3	fledging
fleeching	18	30	501	3	fleeching
fleeing	11	35	1129	3	fl_eeing
fleering	12	38	1128	3	fleering
fleeting	12	29	1032	3	fleeting
flenching	18	29	670	3	flenching
flensing	12	4	697	3	flensing
fleshing	15	33	930	3	fleshing
fletching	18	25	614	3	fletching
flexing	18	35	899	3	fl_exing
fleying	14	32	987	3	fl_eying
flinching	18	24	583	3	flinching
fling	9	70	2351	3	fl___ing
flinging	13	33	1005	3	flinging
flinting	12	34	1234	3	flinting
flipping	16	30	766	3	flipping
flirting	12	31	901	3	flirting
flitching	18	26	534	3	flitching
fliting	11	35	1461	3	fl_iting
flitting	12	30	1088	3	flitting
flocced	15	36	548	3	flocc_ed
floccose	15	4	313	3	floccose
floccule	15	4	281	3	floccule
flocculi	15	4	237	3	flocculi
floccus	14	4	365	3	flocc_us
flockier	17	4	534	3	flockier
floggings	15	31	412	3	floggings
flong	9	58	1568	3	flo___ng
floorings	13	24	509	3	floorings
florin	9	3	1265	3	flo_rin_
florins	10	3	1164	3	flo_rins
flouncings	16	4	167	3	flouncings
flowering	16	3	605	3	flowering
flubbing	16	27	588	3	flubbing
fluffing	14	27	541	3	fluffing
fluking	15	44	1051	3	fl_uking
fluming	13	35	1279	3	fl_uming
flumping	16	28	758	3	flumping
flunking	16	31	777	3	flunking
flushing	15	28	883	3	flushing
fluting	11	38	1509	3	fl_uting
fluxing	18	39	892	3	fl_uxing
flying	13	46	1215	3	fl__ying
flyting	14	37	855	3	fl_yting
foaling	11	35	1584	3	f_oaling
foaming	13	36	1299	3	f_oaming
fobbing	15	34	1027	3	f_obbing
focusing	14	3	660	3	f_ocusing
fogging	13	35	1373	3	f_ogging
foiling	11	33	1765	3	f_oiling
foining	11	30	1345	3	f_oining
folacin	12	3	805	3	folacin_
folacins	13	3	720	3	folacins
folding	12	39	1244	3	f_olding
folioing	12	3	757	3	folioing
fonding	12	38	1542	3	f_onding
fooling	11	31	1737	3	f_ooling
footing	11	50	1759	3	f_ooting
footling	12	23	992	3	footling
foozling	21	27	572	3	foozling
fopping	15	35	1113	3	f_opping
fording	12	37	1704	3	f_ording
forging	12	41	1472	3	f_orging
forking	15	40	1484	3	f_orking
forming	13	36	1573	3	f_orming
fouling	11	33	1537	3	f_ouling
fowling	14	37	1311	3	f_owling
foxing	17	50	1243	3	f_o_xing
frogging	14	35	873	3	frogging
fronting	12	3	1044	3	fronting
frosting	12	3	1118	3	frosting
frothing	15	20	853	3	frothing
frouncing	15	3	476	3	frouncing
frowning	15	30	783	3	frowning
fucking	17	32	1228	3	f_ucking
glaceing	12	3	653	3	glaceing
glancing	12	4	706	3	glancing
gloaming	12	26	801	3	gloaming
gloating	10	26	1146	3	gloating
globing	11	32	1000	3	glo_bing
glomming	14	27	592	3	glomming
glooming	12	35	801	3	glooming
glopping	14	30	775	3	glopping
glorying	13	3	554	3	glorying
glossing	10	27	888	3	glossing
glouting	10	37	969	3	glouting
gloving	12	30	844	3	glo_ving
glowing	12	32	1179	3	glo_wing
glozing	18	33	889	3	glo_zing
hocking	17	34	1724	3	_hocking
knocking	14	24	594	3	knocking
lacing	9	46	2623	3	_l_acing
lacking	14	38	2154	3	_lacking
lancing	10	33	1412	3	_lancing
leching	13	46	1365	3	_leching
licking	14	41	1828	3	_licking
loading	9	41	1461	3	_loading
loafing	11	31	979	3	_loafing
loaming	10	36	1373	3	_loaming
loaning	8	36	1483	3	_loaning
lobbing	12	31	1091	3	_lobbing
locating	11	3	1150	3	_locating
lodging	10	31	1081	3	_lodging
lofting	11	33	1131	3	_lofting
logging	10	33	1681	3	_logging
loiding	9	33	1340	3	_loiding
lolling	8	34	1578	3	_lolling
longing	9	39	1578	3	_longing
looing	7	36	2104	3	_lo_oing
looking	12	34	1504	3	_looking
looming	10	28	1485	3	_looming
looping	10	36	1528	3	_looping
loosing	8	35	1596	3	_loosing
looting	8	30	1964	3	_looting
loping	9	39	2141	3	_lo_ping
lopping	12	38	1522	3	_lopping
lording	9	31	1523	3	_lording
losing	7	40	2287	3	_lo_sing
lotting	8	29	1775	3	_lotting
louping	10	43	1398	3	_louping
louring	8	39	1650	3	_louring
lousing	8	38	1773	3	_lousing
louting	8	37	1938	3	_louting
loving	10	44	1672	3	_lo_ving
lowing	10	46	2327	3	_lo_wing
loxing	14	36	1527	3	_lo_xing
lucking	14	36	1583	3	_lucking
mocking	16	36	1445	3	_mocking
mooching	16	25	906	3	mooching
nocking	14	36	1511	3	_nocking
placing	12	38	1528	3	pl_acing
plodding	13	16	634	3	plodding
plonking	15	35	856	3	plonking
plopping	12	31	870	3	plopping
plotting	11	30	1101	3	plotting
plotzing	20	27	615	3	plotzing
plowing	13	31	1172	3	plo_wing
ploying	13	28	1157	3	plo_ying
plucking	17	35	772	3	plucking
pocking	16	39	1676	3	_pocking
policing	13	3	1167	3	policing
poncing	12	29	1358	3	_poncing
pooching	16	32	898	3	pooching
relocking	16	13	768	3	relocking
rocking	14	36	1963	3	_rocking
sconcing	13	3	826	3	sconcing
shocking	18	43	1154	3	shocking
siccing	12	31	951	3	_siccing
slacking	15	39	1413	3	slacking
slicing	10	35	1464	3	sl_icing
slicking	15	37	1259	3	slicking
slogging	11	34	1049	3	slogging
sloping	10	41	1407	3	slo_ping
slopping	13	38	1142	3	slopping
sloshing	12	25	882	3	sloshing
slotting	9	26	1261	3	slotting
slouching	15	19	572	3	slouching
slowing	11	28	1474	3	slo_wing
sluicing	11	3	706	3	sluicing
smocking	17	34	910	3	smocking
socking	14	35	1860	3	_socking
solacing	11	3	1013	3	solacing
speccing	15	30	664	3	speccing
stocking	15	29	1250	3	stocking
ticcing	12	30	863	3	_ticcing
trocking	15	36	1242	3	trocking
unlocking	16	3	607	3	unlocking
voicing	13	27	908	3	_voicing
yocking	17	37	1237	3	_yocking

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	146162	0.406	440125.6
2	DLD Change Limit	146162	250	6.516	22431.2
3	Display Results	250	250	0.093	2688.2
	(SQL Overall)	178691	250	7.015	25472.7