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

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

162 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
grapnels	11	3	439	(None)
grapnel	10	3	560	1	grapnel_
grainers	9	30	1207	2	grainers
grapes	9	51	2312	2	grap_e_s
grapiness	12	3	825	2	grapiness
grapples	13	34	812	2	grapples
graupels	11	3	310	2	graupels
gravels	11	36	1114	2	gra_vels
grayness	12	3	593	2	grayness
rappels	11	44	880	2	_rappels
apneas	8	32	1138	3	__apneas
appels	10	43	1279	3	__appels
branners	10	40	1092	3	branners
cannels	9	34	1336	3	_cannels
carpels	11	53	1546	3	carp_els
channels	13	38	849	3	channels
chapels	14	42	915	3	chap_els
charnels	13	32	817	3	charnels
cracknels	17	4	343	3	cracknels
cranes	8	43	3075	3	cra_ne_s
crapes	10	47	2769	3	crap_e_s
crappers	14	40	1102	3	crappers
crenels	9	37	1101	3	cr_enels
darnels	8	37	1043	3	_darnels
drabness	11	3	580	3	drabness
dragnets	10	13	656	3	dragnets
drainers	9	28	1125	3	drainers
drapers	10	53	1335	3	drap_ers
drapes	9	54	1965	3	drap_e_s
empanels	12	4	482	3	empanels
flannels	11	3	484	3	flannels
frappes	14	32	838	3	frappe_s
fresnels	11	3	523	3	fresnels
gainers	8	42	1459	3	g_ainers
ganefs	10	48	920	3	g_a_nefs
ganevs	10	45	691	3	g_a_nevs
gannets	8	38	1144	3	g_annets
gapers	9	45	2047	3	g_ap_ers
gapes	8	60	3082	3	g_ap_e_s
gapless	10	34	999	3	g_apless
garners	8	38	1598	3	g_arners
garnets	8	41	1540	3	g_arnets
gavels	10	59	1109	3	g_a_vels
gayness	11	3	684	3	g_ayness
gladness	10	3	615	3	gladness
gospels	10	3	559	3	gosp_els
graals	7	41	1291	3	gra__als
grabbers	13	33	788	3	grabbers
grabbles	13	33	989	3	grabbles
grabens	10	36	700	3	gra_bens
graces	9	45	2349	3	gra_ce_s
graciles	11	25	1161	3	graciles
grackles	15	30	918	3	grackles
graders	9	47	1601	3	gra_ders
grades	8	49	2631	3	gra_de_s
gradines	10	36	1525	3	gradine_s
graduals	10	4	620	3	graduals
grafters	12	40	919	3	grafters
grails	7	75	1878	3	gra__ils
grained	9	38	1427	3	graine_d
grainer	8	37	1406	3	graine_r
grainless	10	3	589	3	grainless
grains	7	42	2309	3	grain__s
grammes	12	36	1132	3	gramme_s
grandees	10	32	1128	3	grandees
grandly	12	3	874	3	gra_ndly
grandness	11	3	830	3	grandness
grands	8	42	1824	3	gra_n_ds
grangers	10	30	1197	3	grangers
granges	9	35	1652	3	gra_nges
grannies	9	3	1261	3	grannies
granola	8	3	791	3	gra_nola
granolas	9	3	805	3	gra_nolas
grans	6	48	3254	3	gra_n__s
grantees	9	25	1097	3	grantees
granters	9	36	1414	3	granters
grants	7	37	2247	3	gra_n_ts
granule	8	3	947	3	gra_nule
granules	9	3	993	3	gra_nules
grape	8	48	2466	3	grap_e__
grapery	13	45	795	3	grap_ery
grapey	12	60	1230	3	grap_e_y
graphed	14	9	847	3	graphe_d
grapheme	16	4	401	3	grapheme
graphemes	17	4	363	3	graphemes
graphics	16	4	565	3	graphics
graphs	12	45	1015	3	grap__hs
grapier	10	37	1260	3	grapie_r
grapiest	11	22	1192	3	grapiest
graplines	12	3	735	3	grapline_s
graplins	11	4	826	3	graplins
grappas	12	35	710	3	grap_pas
grapple	12	37	800	3	grap_ple
grappled	14	33	609	3	grappled
grappler	13	33	619	3	grappler
grapplers	14	27	430	3	grapplers
graspers	11	33	840	3	graspers
grasses	8	41	1734	3	grasse_s
graters	8	54	1974	3	gra_ters
grates	7	54	2989	3	gra_te_s
gratinees	10	30	732	3	gratinees
graupel	10	3	413	3	graupel_
gravel	10	53	1382	3	gra_vel_
gravely	14	46	906	3	gra_vely
graveness	13	28	838	3	graveness
gravers	11	45	1527	3	gra_vers
graves	10	46	2400	3	gra_ve_s
gravies	11	3	1409	3	gravie_s
grazers	17	51	1245	3	gra_zers
grazes	16	45	1964	3	gra_ze_s
graziers	18	38	712	3	graziers
greatness	10	3	690	3	greatness
greyness	12	3	524	3	greyness
grimness	11	7	599	3	grimness
grinners	9	28	804	3	grinners
gripers	10	40	1146	3	grip_ers
gripes	9	46	1987	3	grip_e_s
grippers	13	35	813	3	grippers
grippes	12	48	1037	3	grippe_s
groaners	9	24	850	3	groaners
gropers	10	48	1385	3	grop_ers
gropes	9	52	2040	3	grop_e_s
grovels	11	42	781	3	gr_ovels
groynes	11	3	782	3	groyne_s
gruels	7	39	1015	3	gr__uels
gunnels	8	35	856	3	g_unnels
impanels	12	4	523	3	impanels
lapels	8	37	1204	3	_lap_els
panels	8	47	1652	3	_pa_nels
prawners	13	4	600	3	prawners
propels	11	34	1284	3	prop_els
ranees	6	46	2396	3	_ra_nees
rapers	8	43	2718	3	_rap_ers
rapes	7	57	4072	3	_rap_e_s
raphes	11	51	1745	3	_raphe_s
rapiers	9	50	1287	3	_rapiers
rapines	9	51	2086	3	_rapine_s
rappees	11	36	1145	3	_rappees
rappel	10	42	1195	3	_rappel_
rappers	11	36	1844	3	_rappers
raptness	10	4	673	3	_raptness
ratels	6	45	1821	3	_ra_tels
ravels	9	47	1707	3	_ra_vels
rawness	10	3	815	3	_rawness
repanels	10	3	678	3	_repanels
repels	8	43	1876	3	_rep_els
ronnels	7	31	861	3	_ronnels
runnels	7	32	915	3	_runnels
scrannels	11	4	351	3	scrannels
shrapnel	13	4	213	3	shrapnel_
trainees	8	27	1206	3	trainees
trainers	8	31	1464	3	trainers
tramels	9	38	1249	3	tra_mels
trammels	12	29	541	3	trammels
trapes	8	50	2446	3	trap_e_s
trapnest	10	3	1092	3	trapnest
trapnests	11	4	443	3	trapnests
trappers	12	37	1104	3	trappers
travels	10	47	1129	3	tra_vels
trunnels	8	4	451	3	trunnels
uranyls	10	3	445	3	ura_nyls
wrappers	15	30	693	3	wrappers

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.436	409841.7
2	DLD Change Limit	146162	162	7.440	19645.4
3	Display Results	162	162	0.063	2571.4
	(SQL Overall)	178691	162	7.939	22508.0