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

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

286 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
fagoting	13	3	628	(None)
faggoting	15	4	331	1	faggoting
fagotings	14	4	315	1	fagotings
faceting	14	3	878	2	faceting
fagging	13	37	1476	2	fag_ging
faggotings	16	4	163	2	faggotings
fainting	12	33	1216	2	fainting
farting	11	41	2075	2	fa_rting
fasting	11	45	2283	2	fa_sting
fating	10	53	2867	2	fa__ting
fatting	11	38	1870	2	fa_tting
faulting	12	23	773	2	faulting
favoring	15	9	667	2	favoring
fighting	16	27	1008	2	fighting
footing	11	50	1759	2	f_ooting
garoting	10	5	1070	2	garoting
ingoting	10	3	986	2	ingoting
ragouting	11	3	489	2	ragouting
wagoning	13	3	692	2	wagoning
abating	10	4	1397	3	_abating
aboding	11	4	1012	3	_aboding
aborting	11	7	1025	3	_aborting
acting	9	59	2098	3	_a_cting
adopting	12	3	745	3	_adopting
adoring	9	4	1252	3	_adoring
ageing	8	42	1340	3	_ag_eing
agenting	10	3	938	3	_agenting
aging	7	70	2635	3	_ag__ing
agisting	10	3	824	3	_agisting
airting	8	36	1630	3	_airting
anting	7	58	2702	3	_a_nting
atoning	8	35	1487	3	_atoning
autoing	8	3	1404	3	_autoing
avowing	14	6	660	3	_avowing
bagging	12	33	1698	3	bag_ging
baiting	10	39	1888	3	ba_iting
balloting	12	3	839	3	balloting
basting	10	42	2720	3	ba_sting
bating	9	51	3225	3	ba__ting
batting	10	44	2227	3	ba_tting
bighting	15	26	945	3	bighting
booting	10	38	2136	3	_booting
cageling	12	3	1084	3	cageling
caging	10	53	2102	3	cag__ing
cajoling	18	31	842	3	cajoling
canoeing	11	3	1021	3	canoeing
canting	10	47	2590	3	ca_nting
caroling	11	33	1700	3	caroling
caroming	13	33	1296	3	caroming
carotin	9	22	1673	3	carotin_
carotins	10	23	1558	3	carotins
carting	10	42	2828	3	ca_rting
casting	10	46	2834	3	ca_sting
catting	10	39	2264	3	ca_tting
cavorting	15	3	606	3	cavorting
coting	9	46	2925	3	__coting
dadoing	10	3	852	3	dado_ing
daggling	12	23	706	3	daggling
darting	9	40	2066	3	da_rting
dating	8	53	2648	3	da__ting
daunting	10	33	1040	3	daunting
dauting	9	38	1476	3	da_uting
dawting	12	36	1067	3	da_wting
demoting	12	3	1142	3	demoting
denoting	10	3	1175	3	denoting
devoting	13	3	882	3	devoting
dighting	14	25	1084	3	dighting
doting	8	48	2191	3	__doting
eagling	9	11	1360	3	eag_ling
easting	8	49	2430	3	ea_sting
eating	7	51	3440	3	ea__ting
emoting	10	3	1356	3	_emoting
escoting	11	5	871	3	escoting
fabling	13	34	1362	3	fa_bling
facetting	15	3	528	3	facetting
facing	12	53	2157	3	fa__cing
factoring	15	3	754	3	factoring
fadging	13	42	1024	3	fa_dging
fading	11	48	2111	3	fa__ding
fagin	9	2	1657	3	fag__in_
fagins	10	5	1386	3	fag__ins
fagot	9	3	2340	3	fagot___
fagoted	12	3	607	3	fagot_ed
fagoter	11	3	588	3	fagot_er
fagoters	12	3	486	3	fagoters
fagots	10	3	996	3	fagot__s
failing	11	35	2133	3	fa_iling
fairing	11	36	1401	3	fa_iring
faithing	15	3	715	3	faithing
faking	14	55	2098	3	fa__king
falling	11	36	2158	3	fa_lling
fallowing	16	6	643	3	fallowing
faming	12	49	2297	3	fa__ming
fancying	17	3	535	3	fancying
fanning	11	36	1507	3	fa_nning
farcing	13	35	1400	3	fa_rcing
farding	12	37	1674	3	fa_rding
faring	10	52	3128	3	fa__ring
farming	13	35	1508	3	fa_rming
farrowing	16	4	587	3	farrowing
farthing	15	3	807	3	farthing
fashing	14	49	1879	3	fa_shing
fastings	12	40	1194	3	fa_stings
fathoming	18	4	469	3	fathoming
fatling	11	38	1568	3	fa_tling
favouring	16	4	402	3	favouring
fawning	14	40	913	3	fa_wning
faxing	17	51	1705	3	fa__xing
faying	13	45	2107	3	fa__ying
fazing	19	44	1864	3	fa__zing
feasting	12	20	1132	3	feasting
feinting	12	34	1083	3	feinting
felting	11	35	1521	3	f_elting
feting	10	44	1779	3	f__eting
fetting	11	35	1787	3	f_etting
fidgeting	15	4	452	3	fidgeting
figging	13	33	1356	3	fig_ging
fightings	17	27	650	3	fightings
figuring	13	3	628	3	figuring
fileting	12	3	930	3	fileting
fisting	11	38	1812	3	f_isting
fitting	11	35	1656	3	f_itting
fixating	19	3	618	3	fixating
flagging	14	32	923	3	flag_ging
flatting	12	35	1125	3	flatting
flaunting	13	3	504	3	flaunting
flavoring	16	6	511	3	flavoring
fleeting	12	29	1032	3	fleeting
flighting	17	3	610	3	flighting
flinting	12	34	1234	3	flinting
flirting	12	31	901	3	flirting
fliting	11	35	1461	3	f_liting
flitting	12	30	1088	3	flitting
floating	12	31	1188	3	floating
flogging	14	32	917	3	flogging
flooding	13	23	896	3	flooding
flooring	12	25	988	3	flooring
flouting	12	26	1047	3	flouting
flowing	14	34	1176	3	f_lowing
fluting	11	38	1509	3	f_luting
flyting	14	37	855	3	f_lyting
fogging	13	35	1373	3	fog_ging
foisting	12	29	1050	3	foisting
fooling	11	31	1737	3	f_ooling
footings	12	24	883	3	f_ootings
footling	12	23	992	3	f_ootling
forgoing	13	6	685	3	forgo_ing
foxing	17	50	1243	3	f__oxing
fragging	14	32	942	3	frag_ging
fraughting	18	4	306	3	fraughting
fretting	12	27	1152	3	fretting
frighting	17	3	602	3	frighting
fritting	12	35	1070	3	fritting
frogging	14	35	873	3	frogging
fronting	12	3	1044	3	fronting
frosting	12	3	1118	3	frosting
frothing	15	20	853	3	f_rothing
fruiting	12	22	906	3	fruiting
fugging	13	39	1291	3	fug_ging
fugling	12	42	1251	3	fug_ling
fuguing	12	33	748	3	fug_uing
gagging	9	30	1353	3	gag_ging
gaggling	10	21	746	3	gaggling
gaging	9	47	1840	3	gag__ing
gaiting	9	37	1658	3	ga_iting
galoping	12	5	802	3	galoping
gaoling	9	33	1465	3	ga_oling
garotting	11	3	611	3	garotting
garroting	11	3	695	3	garroting
gasting	9	50	2276	3	ga_sting
gating	8	48	2695	3	__gating
gavotting	14	4	319	3	gavotting
going	7	52	1849	3	__go_ing
goring	8	41	1957	3	__goring
habiting	14	3	753	3	habiting
hafting	14	40	1417	3	ha_fting
hagging	13	31	1468	3	hag_ging
haggling	14	22	727	3	haggling
haloing	11	38	1413	3	halo_ing
halting	11	44	1907	3	ha_lting
hanting	11	41	2448	3	ha_nting
hasting	11	47	2519	3	ha_sting
hating	10	49	2971	3	ha__ting
hatting	11	39	2023	3	ha_tting
haunting	12	35	1005	3	haunting
highting	16	25	972	3	highting
hooting	11	39	1988	3	_hooting
ingoing	9	3	1102	3	ingo_ing
jagging	17	33	1199	3	jag_ging
jargoning	18	4	598	3	jargoning
jaunting	16	32	863	3	jaunting
karting	12	37	1606	3	ka_rting
kayoing	15	3	540	3	kayo_ing
laboring	11	21	1014	3	laboring
lagering	10	22	1231	3	lagering
lagging	10	33	1674	3	lag_ging
lasting	8	47	2524	3	la_sting
legating	10	23	1311	3	legating
ligating	10	22	1228	3	ligating
lighting	13	28	1183	3	lighting
looting	8	30	1964	3	_looting
majoring	18	3	636	3	majoring
malting	10	32	1908	3	ma_lting
marting	10	33	2501	3	ma_rting
masoning	11	3	976	3	masoning
masting	10	43	2582	3	ma_sting
mating	9	48	3291	3	ma__ting
matting	10	36	2014	3	ma_tting
mooting	10	30	1936	3	_mooting
nagging	10	26	1304	3	nag_ging
negating	10	20	1283	3	negating
noting	7	41	2015	3	__noting
ongoing	9	3	879	3	ongo_ing
oughting	13	3	595	3	oughting
paging	10	40	2040	3	pag__ing
painting	11	36	1442	3	painting
panting	10	40	2542	3	pa_nting
pargeting	13	3	828	3	pargeting
paroling	11	33	1621	3	paroling
parroting	12	3	915	3	parroting
parting	10	35	2738	3	pa_rting
pasting	10	38	2655	3	pa_sting
patting	10	37	2234	3	pa_tting
picoting	13	3	888	3	picoting
piloting	11	3	969	3	piloting
pivoting	14	3	618	3	pivoting
quoting	17	3	1004	3	_quoting
rafting	11	38	1575	3	ra_fting
ragging	10	35	1668	3	rag_ging
raging	8	51	2643	3	rag__ing
ranting	8	40	2541	3	ra_nting
rating	7	49	3870	3	ra__ting
ratting	8	38	2236	3	ra_tting
razoring	18	3	644	3	razoring
revoting	12	3	1203	3	revoting
righting	13	26	1085	3	righting
rioting	8	27	1639	3	_rioting
rooting	8	35	2243	3	_rooting
sagging	10	31	1610	3	sag_ging
sainting	9	32	1573	3	sainting
salting	8	41	2079	3	sa_lting
saluting	9	3	1055	3	saluting
sating	7	47	3545	3	sa__ting
savoring	12	6	948	3	savoring
scooting	11	30	1264	3	scooting
seagoing	10	3	819	3	seago_ing
shooting	12	28	1286	3	shooting
sighting	13	31	1086	3	sighting
snooting	9	28	1320	3	snooting
sooting	8	28	2096	3	_sooting
tabooing	11	18	631	3	tabooing
taboring	11	30	1019	3	taboring
tagging	10	30	1491	3	tag_ging
tainting	9	36	1358	3	tainting
tangoing	10	17	789	3	tango_ing
targeting	11	3	730	3	targeting
tarting	8	42	2265	3	ta_rting
tasting	8	46	2421	3	ta_sting
tatting	8	40	1952	3	ta_tting
taunting	9	35	1093	3	taunting
tauting	8	33	1638	3	ta_uting
tooting	8	30	1942	3	_tooting
toting	7	41	2379	3	__toting
upgoing	11	3	535	3	upgo_ing
vacating	14	3	1036	3	vacating
valeting	12	3	885	3	valeting
vamosing	14	3	559	3	vamosing
vaporing	14	3	765	3	vaporing
vatting	11	36	1485	3	va_tting
vaulting	12	22	723	3	vaulting
vaunting	12	33	875	3	vaunting
voting	10	39	1603	3	__voting
wafting	14	39	1166	3	wa_fting
wagering	13	21	952	3	wagering
wagging	13	33	1335	3	wag_ging
waggling	14	19	706	3	waggling
waggoning	15	4	359	3	waggoning
waging	11	43	1838	3	wag__ing
waisting	12	36	1521	3	waisting
waiting	11	36	1895	3	wa_iting
wanting	11	42	2017	3	wa_nting
wasting	11	44	2284	3	wa_sting
waughting	17	4	312	3	waughting
waygoing	16	3	327	3	waygo_ing
yachting	17	3	493	3	yachting
zagging	19	32	1045	3	zag_ging

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.420	425454.8
2	DLD Change Limit	146162	286	6.830	21400.0
3	Display Results	286	286	0.123	2325.2
	(SQL Overall)	178691	286	7.373	24235.9