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

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

320 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
chippy	18	43	761	(None)
chirpy	16	49	891	1	chirpy
choppy	18	37	629	1	choppy
hippy	15	51	1279	1	_hippy
whippy	19	38	584	1	whippy
champy	18	50	961	2	champy
chicly	16	42	920	2	chicly
chilly	14	41	1322	2	chilly
chimp	14	52	1647	2	chimp_
chimps	15	57	1366	2	chimps
chinky	18	56	1054	2	chinky
chip	11	67	2642	2	chi_p_
chipped	17	41	1081	2	chipped
chipper	16	39	1258	2	chipper
chippie	16	29	769	2	chippie
chips	12	57	2125	2	chi_ps
chirp	12	47	1716	2	chirp_
chirps	13	54	1400	2	chirps
chitty	14	32	943	2	chitty
chivvy	20	37	443	2	chivvy
chivy	16	48	1036	2	chi_vy
chuppa	15	4	397	2	chuppa
crappy	15	44	680	2	crappy
crimpy	15	48	939	2	crimpy
crispy	13	47	856	2	crispy
cuppy	14	47	1038	2	c_uppy
dippy	13	51	1154	2	_dippy
drippy	14	44	565	2	drippy
flippy	16	5	461	2	flippy
grippy	14	44	776	2	grippy
happy	15	58	1353	2	_happy
hiply	13	41	1361	2	_hiply
hippo	12	36	906	2	_hippo
hoppy	15	49	1235	2	_hoppy
lippy	12	45	1190	2	_lippy
nippy	12	49	1111	2	_nippy
quippy	22	38	426	2	quippy
slippy	13	7	584	2	slippy
snippy	13	7	484	2	snippy
tippy	12	54	1179	2	_tippy
trippy	13	45	780	2	trippy
zippy	21	51	874	2	_zippy
buppy	14	48	1007	3	_buppy
cairny	11	55	782	3	cairny
campy	14	51	1618	3	c_ampy
canopy	13	3	772	3	canopy
chaffy	20	45	647	3	chaffy
chalky	18	46	877	3	chalky
chally	14	43	1429	3	chally
chammy	18	48	895	3	chammy
champ	14	50	1796	3	champ_
champs	15	49	1568	3	champs
chancy	16	40	1086	3	chancy
chanty	14	52	1582	3	chanty
chap	11	49	2849	3	ch_ap_
chape	12	52	2114	3	ch_ape
chapel	13	49	1137	3	chapel
chapes	13	54	2187	3	chapes
chapped	17	27	1144	3	chapped
chappie	16	29	865	3	chappie
chaps	12	53	2606	3	ch_aps
chapt	12	58	2764	3	ch_apt
charpoy	17	3	571	3	charpoy
charry	14	50	1211	3	charry
chary	13	50	2313	3	ch_ary
chasmy	16	46	854	3	chasmy
chatty	14	41	936	3	chatty
chay	12	49	2487	3	ch__ay
cheap	12	69	1594	3	cheap_
cheaply	17	3	502	3	cheaply
cheapo	13	48	1008	3	cheapo
cheaps	13	46	1368	3	cheaps
cheeky	18	44	861	3	cheeky
cheep	12	54	1650	3	cheep_
cheeps	13	53	1291	3	cheeps
cheery	14	49	1315	3	cheery
cheesy	14	41	919	3	cheesy
cherry	14	48	1076	3	cherry
cherty	14	46	1247	3	cherty
chesty	14	46	1050	3	chesty
chevy	16	47	999	3	ch_evy
chewy	16	50	1190	3	ch_ewy
chi	8	62	2865	3	chi___
chia	9	60	2662	3	chi__a
chiao	10	56	1836	3	chi_ao
chias	10	46	2551	3	chi_as
chiasm	13	44	910	3	chiasm
chiaus	11	36	1130	3	chiaus
chic	11	59	2520	3	chi__c
chica	12	58	1826	3	chi_ca
chicas	13	59	1646	3	chicas
chicer	13	45	1360	3	chicer
chichi	16	3	709	3	chichi
chick	16	54	1913	3	chi_ck
chicks	17	53	1759	3	chicks
chicle	13	43	1254	3	chicle
chico	12	42	1825	3	chi_co
chicory	17	3	599	3	chicory
chicos	13	46	1483	3	chicos
chics	12	39	2094	3	chi_cs
chid	10	66	2640	3	chi__d
chide	11	53	2101	3	chi_de
chided	13	51	1396	3	chided
chider	12	51	1605	3	chider
chides	12	46	2047	3	chides
chief	13	44	1947	3	chi_ef
chiefly	18	3	410	3	chiefly
chiefs	14	50	965	3	chiefs
chiel	10	49	1897	3	chi_el
chield	12	46	1021	3	chield
chiels	11	51	1593	3	chiels
chigoe	12	3	753	3	chigoe
child	11	45	1622	3	chi_ld
childe	12	47	1121	3	childe
childly	16	4	480	3	childly
chile	10	56	2689	3	chi_le
chiles	11	54	2530	3	chiles
chili	10	62	1848	3	chi_li
chilis	11	55	1787	3	chilis
chill	10	56	1987	3	chi_ll
chilli	11	43	1277	3	chilli
chills	11	47	1770	3	chills
chimar	13	39	1146	3	chimar
chimb	14	48	1356	3	chi_mb
chimbly	19	7	459	3	chimbly
chimbs	15	39	1030	3	chimbs
chime	12	53	2259	3	chi_me
chimed	14	58	1483	3	chimed
chimer	13	55	1720	3	chimer
chimes	13	49	2257	3	chimes
chimla	13	3	759	3	chimla
chimley	17	8	516	3	chimley
chimney	17	9	548	3	chimney
chin	9	69	3474	3	chi__n
china	10	50	2247	3	chi_na
chinas	11	51	1938	3	chinas
chinch	16	39	1122	3	chinch
chinchy	20	33	551	3	chinchy
chine	10	52	3172	3	chi_ne
chined	12	56	2006	3	chined
chines	11	50	2917	3	chines
chink	14	53	2159	3	chi_nk
chinks	15	58	1757	3	chinks
chino	10	58	2331	3	chi_no
chinos	11	50	1869	3	chinos
chins	10	56	3146	3	chi_ns
chints	11	51	1783	3	chints
chintz	20	42	1202	3	chintz
chintzy	24	36	421	3	chintzy
chippers	17	35	1087	3	chippers
chippier	17	29	767	3	chippier
chippies	17	30	975	3	chippies
chipping	18	38	979	3	chipping
chiral	11	46	1441	3	chiral
chirk	14	45	1618	3	chi_rk
chirks	15	54	1484	3	chirks
chirm	12	53	1706	3	chi_rm
chirms	13	51	1398	3	chirms
chiro	10	53	2034	3	chi_ro
chiros	11	46	1777	3	chiros
chirped	15	37	978	3	chirped
chirper	14	35	996	3	chirper
chirpily	18	4	377	3	chirpily
chirr	10	50	1590	3	chi_rr
chirre	11	41	1185	3	chirre
chirrs	11	45	1498	3	chirrs
chirrupy	18	13	202	3	chirrupy
chiru	10	53	1715	3	chi_ru
chirus	11	46	1569	3	chirus
chis	9	59	3331	3	chi__s
chisel	11	21	1194	3	chisel
chit	9	69	3746	3	chi__t
chital	11	43	1388	3	chital
chitin	11	31	1495	3	chitin
chiton	11	26	1239	3	chiton
chits	10	54	2457	3	chi_ts
chive	13	51	1762	3	chi_ve
chives	14	43	1759	3	chives
chokey	18	48	1171	3	chokey
choky	17	57	1122	3	ch_oky
chomp	14	48	1566	3	chomp_
chomps	15	51	1222	3	chomps
choosy	14	45	910	3	choosy
chop	11	60	2492	3	ch_op_
chopin	13	27	1218	3	chopin
chopped	17	45	1100	3	chopped
chopper	16	36	1189	3	chopper
choppily	20	4	413	3	choppily
chops	12	50	1987	3	ch_ops
christy	15	3	662	3	christy
chromy	16	30	990	3	chromy
chubby	18	4	412	3	chubby
chucky	20	41	800	3	chucky
chuffy	20	44	586	3	chuffy
chummy	18	38	589	3	chummy
chump	14	53	1544	3	chump_
chumps	15	43	1382	3	chumps
chunky	18	46	827	3	chunky
chuppah	19	5	245	3	chuppah
chuppas	16	4	412	3	chuppas
cissy	10	48	1107	3	c_issy
city	9	51	2262	3	c_i_ty
civvy	16	43	546	3	c_ivvy
cliffy	17	43	524	3	cliffy
clingy	12	65	906	3	clingy
clip	8	69	2400	3	cli_p_
clipped	14	43	983	3	clipped
clipper	13	37	1032	3	clipper
clips	9	60	1830	3	cli_ps
clipt	9	63	2427	3	cli_pt
cliquy	20	32	471	3	cliquy
clumpy	15	40	957	3	clumpy
comply	15	28	1038	3	comply
copay	12	65	1631	3	c_opay
copy	11	62	2980	3	c__opy
crampy	15	47	1099	3	crampy
creepy	13	41	880	3	creepy
crepey	13	51	1093	3	crepey
crepy	12	48	1270	3	c_repy
crikey	15	31	778	3	crikey
crimp	11	56	1580	3	crimp_
crimps	12	46	1345	3	crimps
cripe	9	55	2114	3	cri_pe
cripes	10	51	2087	3	cripes
cripple	13	37	858	3	cripple
crisp	9	50	1462	3	crisp_
crisply	14	42	652	3	crisply
crisps	10	44	1151	3	crisps
croupy	13	45	873	3	croupy
cuppa	11	39	852	3	c_uppa
flappy	16	5	448	3	flappy
floppy	16	5	487	3	floppy
gappy	13	62	1203	3	_gappy
gimpy	13	52	1223	3	_gimpy
gipsy	11	57	954	3	_gipsy
gloppy	14	5	472	3	gloppy
gripey	12	41	1120	3	gripey
grippe	11	53	1032	3	grippe
gripy	11	51	1525	3	gri_py
guppy	13	52	1127	3	_guppy
haply	13	59	1506	3	_haply
harpy	13	64	1820	3	_harpy
heapy	13	59	1498	3	_heapy
hempy	15	49	1276	3	_hempy
hilly	11	44	2216	3	_hilly
hinky	15	56	1875	3	_hinky
hinny	11	56	1667	3	_hinny
hip	8	67	5043	3	_hi_p_
hipped	14	43	1769	3	_hipped
hipper	13	38	1802	3	_hipper
hippie	13	28	1124	3	_hippie
hippos	13	40	843	3	_hippos
hips	9	64	3370	3	_hi_ps
hissy	11	61	1212	3	_hissy
humpy	15	51	1567	3	_humpy
jimpy	19	52	1082	3	_jimpy
loppy	12	59	1166	3	_loppy
nappy	12	63	1233	3	_nappy
pappy	11	47	1380	3	_pappy
peppy	11	43	1036	3	_peppy
pipy	11	54	2151	3	_pi_py
poppy	11	48	1319	3	_poppy
preppy	12	3	552	3	preppy
puppy	11	49	1241	3	_puppy
quippu	19	34	486	3	quippu
ripply	13	34	800	3	_ripply
sappy	12	54	1347	3	_sappy
schappe	16	3	526	3	schappe
schizy	23	11	504	3	schi_zy
schizzy	23	13	236	3	schizzy
scrappy	16	23	447	3	scrappy
scrimpy	16	48	613	3	scrimpy
sharpy	14	52	1103	3	sharpy
shifty	15	40	925	3	shifty
shily	11	52	2201	3	shi_ly
shimmy	16	30	641	3	shimmy
shindy	13	44	932	3	shindy
shinny	12	48	1078	3	shinny
shiny	11	51	2214	3	shi_ny
ship	9	52	2823	3	shi_p_
shipped	15	33	1210	3	shipped
shippen	14	29	886	3	shippen
shipper	14	35	1403	3	shipper
shippon	14	28	580	3	shippon
ships	10	51	2377	3	shi_ps
shipway	18	4	421	3	shipway
shirty	12	43	1255	3	shirty
shitty	12	41	1005	3	shitty
shoppe	13	31	1031	3	shoppe
shrimpy	17	41	540	3	shrimpy
skimpy	17	47	572	3	skimpy
sloppy	13	9	530	3	sloppy
snappy	13	6	610	3	snappy
soppy	12	51	1352	3	_soppy
thinly	12	3	866	3	thinly
thirty	12	37	840	3	thirty
tipsy	10	60	1050	3	_tipsy
triply	11	42	1102	3	triply
unhappy	17	4	280	3	unhappy
whimsy	17	37	522	3	whimsy
whiney	15	50	1264	3	whiney
whinny	15	58	749	3	whinny
whiny	14	49	1557	3	whi_ny
whip	12	55	2184	3	whi_p_
whipped	18	37	933	3	whipped
whipper	17	36	1138	3	whipper
whippet	17	32	884	3	whippet
whipray	18	4	340	3	whipray
whips	13	49	1708	3	whi_ps
whipt	13	53	1742	3	whi_pt
whirly	15	44	886	3	whirly
whirry	15	47	706	3	whirry
whisky	19	45	590	3	whisky
whitey	15	49	1188	3	whitey
whity	14	55	1347	3	whi_ty
whizzy	23	27	407	3	whizzy
wimpy	15	59	1192	3	_wimpy
wispy	13	72	1097	3	_wispy
yuppy	15	48	791	3	_yuppy
zappy	21	54	894	3	_zappy

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	320	5.533	20371.6
3	Display Results	320	320	0.093	3440.9
	(SQL Overall)	178691	320	5.766	30990.5