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

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

84 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
gippers	12	32	1208	(None)
dippers	12	36	1518	1	dippers
gipper	11	42	1530	1	gipper_
grippers	13	35	813	1	grippers
gyppers	15	23	550	1	gyppers
kippers	15	32	1143	1	kippers
lippers	11	34	1644	1	lippers
nippers	11	30	1262	1	nippers
rippers	11	41	1503	1	rippers
sippers	11	31	1775	1	sippers
tippers	11	34	1435	1	tippers
zippers	20	33	1038	1	zippers
boppers	13	39	1192	2	boppers
cappers	13	44	1940	2	cappers
chippers	17	35	1088	2	chippers
ciphers	14	37	999	2	ciphers
clippers	14	36	884	2	clippers
coppers	13	35	1975	2	coppers
cuppers	13	37	1221	2	cuppers
diapers	10	47	1391	2	diapers
dipper	11	40	1779	2	dipper_
drippers	13	32	794	2	drippers
flippers	15	33	800	2	flippers
gapers	9	45	2047	2	g_apers
gaspers	10	50	1413	2	gaspers
gawpers	13	44	831	2	gawpers
gibbers	12	47	1098	2	gibbers
gibers	9	51	1466	2	gi_bers
gilders	9	42	1246	2	gilders
gillers	8	42	1690	2	gillers
gingers	9	41	1864	2	gingers
ginners	8	43	1422	2	ginners
gipped	12	48	1590	2	gippe_d
girders	9	37	994	2	girders
givers	10	48	1771	2	gi_vers
gophers	13	3	898	2	gophers
gripers	10	40	1146	2	gripers
gripper	12	44	1071	2	gripper_
grippes	12	48	1037	2	grippe_s
gropers	10	48	1385	2	gropers
gulpers	10	29	901	2	gulpers
gypper	14	34	729	2	gypper_
hipper	13	38	1802	2	hipper_
hoppers	14	31	1514	2	hoppers
kipper	14	34	1421	2	kipper_
lappers	11	37	1746	2	lappers
limpers	11	38	1522	2	limpers
lippens	11	32	853	2	lippens
lipper	10	42	1963	2	lipper_
lispers	9	45	1432	2	lispers
loppers	11	30	1410	2	loppers
mappers	13	33	1378	2	mappers
moppers	13	34	1246	2	moppers
nappers	11	42	1486	2	nappers
nipper	10	37	1571	2	nipper_
peppers	10	33	1144	2	peppers
pipers	10	43	1866	2	pi_pers
poppers	10	34	1486	2	poppers
quippers	21	8	481	2	quippers
rappers	11	36	1844	2	rappers
ripper	10	35	1865	2	ripper_
ripplers	12	33	711	2	ripplers
sappers	11	35	1890	2	sappers
shippers	15	30	1231	2	shippers
simpers	11	30	1412	2	simpers
sipper	10	39	2099	2	sipper_
sippets	11	33	1018	2	sippets
skippers	16	31	820	2	skippers
slippers	12	37	1123	2	slippers
snippers	12	29	972	2	snippers
suppers	11	33	1470	2	suppers
tappers	11	34	1654	2	tappers
tipper	10	39	1841	2	tipper_
tippets	11	33	937	2	tippets
tipplers	12	33	635	2	tipplers
toppers	11	39	1460	2	toppers
trippers	12	32	1016	2	trippers
uppers	10	29	1229	2	_uppers
vipers	11	49	1453	2	vi_pers
whippers	18	32	904	2	whippers
wipers	11	54	1608	2	wi_pers
yappers	14	40	1225	2	yappers
zappers	20	39	1163	2	zappers
zipper	19	38	1312	2	zipper_

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	107671	0.356	501941.0
2	DLD Change Limit	107671	84	3.173	33933.5
3	Display Results	84	84	0.016	5250.0
	(SQL Overall)	178691	84	3.545	50406.5