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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

48 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
grainers	9	30	1207	(None)
drainers	9	28	1125	1	drainers
gainers	8	42	1459	1	g_ainers
grainer	8	37	1406	1	grainer_
trainers	8	31	1464	1	trainers
braiders	11	41	1057	2	braiders
branners	10	40	1092	2	branners
briners	9	43	1563	2	br_iners
drainer	8	30	1284	2	drainer_
gainer	7	41	1749	2	g_ainer_
gaiters	8	35	1654	2	g_aiters
garners	8	38	1598	2	g_arners
grabbers	13	33	788	2	grabbers
graders	9	47	1601	2	gra_ders
gradines	10	36	1525	2	gradine_s
grafters	12	40	919	2	grafters
grained	9	38	1427	2	graine_d
grainier	9	21	890	2	grainier_
grainless	10	3	589	2	grainless
grains	7	42	2309	2	grain__s
grangers	10	30	1197	2	grangers
granters	9	36	1414	2	granters
grapiness	12	3	825	2	grapiness
grapnels	11	3	439	2	grapnels
graspers	11	33	840	2	graspers
graters	8	54	1974	2	gra_ters
gratinees	10	30	732	2	gratinees
gravers	11	45	1527	2	gra_vers
grayness	12	3	593	2	grayness
grazers	17	51	1245	2	gra_zers
graziers	18	38	712	2	graziers
grinders	10	34	1042	2	gr_inders
grinners	9	28	804	2	grinners
gripers	10	40	1146	2	gr_ipers
groaners	9	24	850	2	groaners
mariners	10	31	1386	2	mariners
ordainers	10	5	511	2	ordainers
praisers	10	34	1083	2	praisers
prawners	13	4	600	2	prawners
raiders	8	46	1514	2	_raiders
railers	7	44	2066	2	_railers
raisers	7	36	1739	2	_raisers
ruiners	7	42	1302	2	_ruiners
stainers	8	32	1217	2	stainers
strainers	9	5	1038	2	strainers
trailers	8	29	1292	2	trailers
trainees	8	27	1206	2	trainees
trainer	7	33	1679	2	trainer_

Search took 4 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	121059	0.140	1276364.3
2	DLD Change Limit	121059	48	3.420	35397.4
3	Display Results	48	48	0.033	1454.5
	(SQL Overall)	178691	48	3.593	49733.1