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

Here are the results of your fuzzy-string dictionary search for “nongolfers” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

152 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
nongolfers	14	4	339	(None)
nongolfer	13	4	359	1	nongolfer_
condolers	12	27	1057	3	condol_ers
consolers	11	25	1092	3	consol_ers
golfers	11	44	1008	3	___golfers
gondoliers	12	4	369	3	gondoliers
noncolors	11	4	703	3	noncol_ors
nonglares	10	4	641	3	nong_lares
nonjoiners	17	6	493	3	nonjoiners
nonkoshers	17	4	364	3	nonkoshers
nonowners	12	4	512	3	non_owners
nontalkers	14	4	414	3	nontalkers
nonvoters	12	13	646	3	nonvo_ters
nonworkers	17	4	441	3	nonworkers
anglers	8	40	1482	4	_ang_l_ers
bandoleers	13	4	356	4	bandoleers
bandoliers	13	4	414	4	bandoliers
bogglers	12	34	760	4	bo_ggl_ers
bondholders	18	5	283	4	bondholders
bongoes	10	43	1411	4	bongo__e_s
bunglers	11	39	848	4	bung_l_ers
coholders	15	3	562	4	co_holders
concocters	13	4	675	4	concocters
condoler	11	34	1212	4	condol_er_
condoles	11	30	1580	4	condol_e_s
condoners	12	28	1151	4	condo_ners
confers	12	41	2009	4	con___fers
conformers	17	4	655	4	conformers
congealers	13	6	567	4	congealers
congeners	12	25	1113	4	cong_eners
congers	10	42	2323	4	cong___ers
conglobes	14	4	422	4	conglobe_s
congoes	10	36	1730	4	congo__e_s
conifers	13	36	1170	4	con__ifers
conjoiners	19	5	540	4	conjoiners
consoler	10	28	1261	4	consol_er_
consoles	10	32	1615	4	consol_e_s
consulters	12	9	721	4	consulters
controllers	13	4	478	4	controllers
convokers	18	24	610	4	convo_kers
convolves	17	4	532	4	convolve_s
coolers	9	35	2249	4	co__ol_ers
danglers	10	36	1059	4	dang_l_ers
dongles	9	32	1287	4	dong_l_e_s
dongolas	10	4	534	4	dongol__as
enfolders	13	9	509	4	_enfolders
enrollers	9	7	617	4	_enrollers
fondlers	12	33	802	4	fon_dl_ers
forgoers	12	3	641	4	forgo__ers
gofers	10	47	1151	4	___go_fers
goffers	14	40	921	4	___goffers
gogglers	11	27	671	4	go_ggl_ers
golfer	10	44	1118	4	___golfer_
gondolier	11	4	472	4	gondolier_
hangovers	16	14	416	4	hango_vers
honorers	11	3	926	4	hon_o_rers
honourers	12	4	557	4	hon_ourers
hoofers	13	45	1332	4	ho__o_fers
infolders	13	8	517	4	_infolders
inholders	13	4	535	4	_inholders
involvers	15	4	403	4	_involvers
ionomers	10	3	850	4	ion_o_mers
janglers	16	31	937	4	jang_l_ers
jinglers	16	40	876	4	jing_l_ers
jobholders	23	5	217	4	jobholders
jogglers	17	35	688	4	jo_ggl_ers
jongleurs	17	4	181	4	jong_leurs
knollers	12	25	514	4	_kn_ollers
logrollers	11	4	222	4	logrollers
longers	8	48	1954	4	long___ers
manglers	11	33	1190	4	mang_l_ers
minglers	11	30	1129	4	ming_l_ers
mongers	10	42	1727	4	mong___ers
mongoes	10	34	1571	4	mongo__e_s
mongolisms	15	4	404	4	mongolisms
mongoloids	14	5	301	4	mongoloids
mongols	10	33	1082	4	mongol___s
mongooses	12	8	560	4	mongoose_s
monolayers	15	4	392	4	mon_olayers
monomers	12	3	1103	4	mon_o_mers
nigglers	10	30	725	4	n_iggl_ers
nobblers	12	31	856	4	no_bbl_ers
nonanswers	13	5	284	4	nonanswers
nonbeliefs	15	5	298	4	nonbeliefs
nonbodies	12	4	602	4	nonbodie_s
noncolas	10	4	861	4	noncol__as
noncollege	13	5	328	4	noncollege
noncolor	10	4	651	4	noncol_or_
noncolored	13	5	473	4	noncolored
nonconcern	14	5	471	4	nonconcern
nonconcerns	15	5	449	4	nonconcerns
nonconcurs	14	5	456	4	nonconcurs
nonconform	17	5	396	4	nonconform
nonconforms	18	5	366	4	nonconforms
nondancers	13	4	464	4	nondancers
nondoctors	13	4	529	4	nondoctors
nondollar	10	4	371	4	nondollar_
nondrivers	14	4	426	4	nondrivers
nonfarmers	15	4	417	4	nonfarmers
nonglare	9	4	637	4	nong_l_are
nonhunters	13	4	473	4	nonhunters
nonjoinders	19	5	277	4	nonjoinders
nonjoiner	16	6	533	4	nonjoiner_
nonkosher	16	4	341	4	nonkosher_
nonlawyers	16	5	206	4	nonlawyers
nonmembers	16	4	315	4	nonmembers
nonmodern	12	4	418	4	nonmo_dern
nonmoderns	13	5	348	4	nonmo_derns
nonnovels	12	4	344	4	nonno_vels
nonowner	11	4	525	4	non_owner_
nonplayers	15	4	394	4	nonplayers
nonpolar	10	4	628	4	nonpol_ar_
nonreaders	11	4	543	4	nonreaders
nonrioters	10	4	551	4	nonrioters
nonselves	12	4	650	4	nonselve_s
nonsigners	11	4	514	4	nonsigners
nonskaters	14	4	448	4	nonskaters
nonskiers	13	4	501	4	non_skiers
nonsmokers	16	4	397	4	nonsmokers
nonsolar	8	4	708	4	nonsol_ar_
nonsolids	10	4	538	4	nonsol_ids
nontalker	13	4	426	4	nontalker_
nonuples	10	5	653	4	nonupl_e_s
nonusers	8	26	800	4	non__users
nonviewers	16	4	249	4	nonviewers
nonvoter	11	8	689	4	nonvo_ter_
nonworker	16	4	482	4	nonworker_
nonwovens	15	4	379	4	nonwo_vens
nonwriters	13	4	509	4	nonwriters
noosers	7	49	1392	4	no__o_sers
oglers	7	43	1318	4	_o_g_l_ers
onlookers	13	4	310	4	_onlookers
penholders	16	4	379	4	penholders
pontoniers	12	4	532	4	pontoniers
poolers	9	42	1742	4	po__ol_ers
potholders	16	4	434	4	potholders
rolfers	10	40	1181	4	___rolfers
roofers	10	50	1390	4	ro__o_fers
songless	9	21	882	4	song_l_ess
songsters	10	4	611	4	song_sters
tanglers	9	29	1197	4	tang_l_ers
tinglers	9	37	1059	4	ting_l_ers
togglers	10	27	695	4	to_ggl_ers
tongers	8	41	1601	4	tong___ers
toolers	7	44	1650	4	to__ol_ers
unfolders	13	4	472	4	_unfolders
unsolders	10	6	469	4	_unsolders
wanglers	12	33	1003	4	wang_l_ers
wingovers	16	4	355	4	wingo_vers
wolfers	13	40	963	4	___wolfers
woofers	13	38	1058	4	wo__o_fers
woolers	10	42	1402	4	wo__ol_ers

Search took 10 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	161450	0.423	422437.4
2	DLD Change Limit	161450	152	9.343	17280.3
3	Display Results	152	152	0.076	2000.0
	(SQL Overall)	178691	152	9.842	18156.0