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

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

144 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
grapplers	14	27	430	(None)
grappler	13	33	619	1	grappler_
grapples	13	34	812	1	grapple_s
crappers	14	40	1102	2	crapp_ers
cripplers	15	31	499	2	cripplers
grabblers	14	34	551	2	grabblers
grapple	12	37	800	2	grapple__
grappled	14	33	609	2	grapple_d
graspers	11	33	840	2	grasp_ers
grippers	13	35	813	2	gripp_ers
rappers	11	36	1844	2	_rapp_ers
ripplers	12	33	711	2	_ripplers
tramplers	13	30	588	2	tramplers
trappers	12	37	1104	2	trapp_ers
wrappers	15	30	693	2	wrapp_ers
apples	10	43	1576	3	__apple_s
applets	11	57	1006	3	__applets
appliers	12	3	557	3	__appliers
brabblers	12	33	556	3	brabblers
braillers	11	3	556	3	braillers
brawlers	13	40	864	3	bra_wlers
cappers	13	44	1940	3	_capp_ers
clappers	14	33	1083	3	clapp_ers
cradlers	11	30	920	3	cra_dlers
crapper	13	39	1319	3	crapp_er_
crappier	14	28	814	3	crappier_
crappies	14	29	1117	3	crappie_s
crawlers	13	30	901	3	cra_wlers
crippler	14	82	671	3	crippler_
cripples	14	29	840	3	cripple_s
croppers	14	33	1148	3	cropp_ers
cruppers	14	31	732	3	crupp_ers
dapples	12	3	899	3	_dapple_s
drapers	10	53	1335	3	dra_p_ers
drawlers	12	30	731	3	dra_wlers
drippers	13	32	794	3	dripp_ers
droppers	13	31	860	3	dropp_ers
flappers	15	38	838	3	flapp_ers
frappes	14	32	838	3	frapp_e_s
gabblers	13	41	1008	3	g_abblers
gamblers	13	36	973	3	g_amblers
gaolers	8	35	1156	3	g_a_olers
gapers	9	45	2047	3	g_a_p_ers
gapless	10	34	999	3	g_a_pless
gappier	12	36	984	3	g_appier_
garblers	11	38	1028	3	g_arblers
garglers	10	41	826	3	g_arglers
gaspers	10	50	1413	3	g_asp_ers
gawpers	13	44	831	3	g_awp_ers
gippers	12	32	1208	3	g_ipp_ers
gospelers	12	7	368	3	gospelers
grabbers	13	33	788	3	gra_bbers
grabbler	13	37	769	3	grabbler_
grabbles	13	33	989	3	grabble_s
graceless	12	22	689	3	graceless
graciles	11	25	1161	3	gracile_s
grackles	15	30	918	3	grackle_s
gradeless	11	23	670	3	gradeless
graders	9	47	1601	3	gra__ders
grafters	12	40	919	3	gra_fters
grainers	9	30	1208	3	gra_iners
grainless	10	3	590	3	grainless
grangers	10	30	1197	3	gra_ngers
granters	9	36	1415	3	gra_nters
granules	9	3	994	3	granule_s
grapery	13	45	795	3	gra_p_ery
grapes	9	51	2312	3	gra_p_e_s
grapier	10	37	1260	3	gra_pier_
grapiness	12	3	826	3	grapiness
graplins	11	4	826	3	gra_plins
grapnels	11	3	439	3	gra_pnels
grappas	12	35	710	3	grapp__as
grappling	15	4	499	3	grappling
grapplings	16	4	232	3	grapplings
grasper	10	38	979	3	grasp_er_
grassless	10	3	430	3	grassless
grateless	10	27	758	3	grateless
graters	8	54	1974	3	gra__ters
graupels	11	3	310	3	graup_els
graveless	13	22	669	3	graveless
gravers	11	45	1527	3	gra__vers
grazers	17	51	1245	3	gra__zers
graziers	18	38	712	3	gra_ziers
grillers	9	38	1081	3	gr_illers
gripers	10	40	1146	3	gr_ip_ers
gripper	12	44	1071	3	gripp_er_
grippes	12	48	1037	3	gripp_e_s
grippier	13	5	520	3	grippier_
gripple	12	41	661	3	gripple__
grizzlers	18	25	323	3	grizzlers
gropers	10	48	1385	3	gr_op_ers
groupers	11	35	864	3	group_ers
grovelers	13	30	516	3	grovelers
growlers	12	32	709	3	gr_owlers
gruelers	9	3	617	3	gr_uelers
gruellers	10	3	418	3	gruellers
grumblers	14	24	502	3	grumblers
gyppers	15	23	550	3	g_ypp_ers
knappers	16	31	564	3	knapp_ers
lappers	11	37	1746	3	_lapp_ers
mappers	13	33	1378	3	_mapp_ers
nappers	11	42	1486	3	_napp_ers
prattlers	11	19	533	3	prattlers
rabblers	12	38	1085	3	_rabblers
rafflers	14	31	737	3	_rafflers
railers	7	44	2067	3	_ra_ilers
ramblers	12	40	1037	3	_ramblers
rapers	8	43	2718	3	_ra_p_ers
rapiers	9	50	1287	3	_ra_piers
rappees	11	36	1145	3	_rapp_ees
rappels	11	44	880	3	_rapp_els
rapper	10	46	2157	3	_rapp_er_
raspers	9	44	1592	3	_rasp_ers
rattlers	8	35	1029	3	_rattlers
ravelers	11	33	1086	3	_ravelers
rippers	11	41	1503	3	_ripp_ers
rippler	11	32	1010	3	_rippler_
ripples	11	35	1329	3	_ripple_s
ripplets	12	31	673	3	_ripplets
samplers	12	29	940	3	_samplers
sappers	11	35	1890	3	_sapp_ers
scrappers	15	4	586	3	scrapp_ers
scrapples	15	3	480	3	scrapple_s
slappers	12	37	1095	3	slapp_ers
snappers	12	35	1017	3	snapp_ers
staplers	10	31	1120	3	sta_plers
stipplers	13	3	445	3	stipplers
strappers	13	4	674	3	strapp_ers
swappers	15	35	808	3	swapp_ers
tappers	11	34	1654	3	_tapp_ers
tipplers	12	33	635	3	_tipplers
trailers	8	29	1293	3	tra_ilers
trampers	12	32	1039	3	tramp_ers
trampler	12	27	801	3	trampler_
tramples	12	26	1020	3	trample_s
trapper	11	39	1280	3	trapp_er_
travelers	12	26	677	3	travelers
trawlers	11	33	1020	3	tra_wlers
trippers	12	32	1016	3	tripp_ers
whappers	18	27	674	3	whapp_ers
wranglers	13	4	428	3	wranglers
wrapper	14	36	833	3	wrapp_er_
yappers	14	40	1225	3	_yapp_ers
zappers	20	39	1163	3	_zapp_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	148641	0.440	406115.9
2	DLD Change Limit	148641	144	8.466	17557.4
3	Display Results	144	144	0.063	2285.7
	(SQL Overall)	178691	144	8.969	19923.2