Annotation of embedaddon/sqlite3/test/fuzzer1.test, revision 1.1.1.1
1.1 misho 1: # 2011 March 25
2: #
3: # The author disclaims copyright to this source code. In place of
4: # a legal notice, here is a blessing:
5: #
6: # May you do good and not evil.
7: # May you find forgiveness for yourself and forgive others.
8: # May you share freely, never taking more than you give.
9: #
10: #***********************************************************************
11: # This file implements regression tests for TCL interface to the
12: # SQLite library.
13: #
14: # The focus of the tests is the word-fuzzer virtual table.
15: #
16:
17: set testdir [file dirname $argv0]
18: source $testdir/tester.tcl
19:
20: ifcapable !vtab {
21: finish_test
22: return
23: }
24:
25: register_fuzzer_module db
26: do_test fuzzer1-1.0 {
27: catchsql {CREATE VIRTUAL TABLE fault1 USING fuzzer;}
28: } {1 {fuzzer virtual tables must be TEMP}}
29: do_test fuzzer1-1.1 {
30: db eval {CREATE VIRTUAL TABLE temp.f1 USING fuzzer;}
31: } {}
32: do_test fuzzer1-1.2 {
33: db eval {
34: INSERT INTO f1(cfrom, cto, cost) VALUES('e','a',1);
35: INSERT INTO f1(cfrom, cto, cost) VALUES('a','e',10);
36: INSERT INTO f1(cfrom, cto, cost) VALUES('e','o',100);
37: }
38: } {}
39:
40: do_test fuzzer1-1.3 {
41: db eval {
42: SELECT word, distance FROM f1 WHERE word MATCH 'abcde'
43: }
44: } {abcde 0 abcda 1 ebcde 10 ebcda 11 abcdo 100 ebcdo 110 obcde 110 obcda 111 obcdo 210}
45:
46: do_test fuzzer1-2.0 {
47: execsql {
48: CREATE VIRTUAL TABLE temp.f2 USING fuzzer;
49: -- costs based on English letter frequencies
50: INSERT INTO f2(cFrom,cTo,cost) VALUES('a','e',24);
51: INSERT INTO f2(cFrom,cTo,cost) VALUES('a','o',47);
52: INSERT INTO f2(cFrom,cTo,cost) VALUES('a','u',50);
53: INSERT INTO f2(cFrom,cTo,cost) VALUES('e','a',23);
54: INSERT INTO f2(cFrom,cTo,cost) VALUES('e','i',33);
55: INSERT INTO f2(cFrom,cTo,cost) VALUES('e','o',37);
56: INSERT INTO f2(cFrom,cTo,cost) VALUES('i','e',33);
57: INSERT INTO f2(cFrom,cTo,cost) VALUES('i','y',33);
58: INSERT INTO f2(cFrom,cTo,cost) VALUES('o','a',41);
59: INSERT INTO f2(cFrom,cTo,cost) VALUES('o','e',46);
60: INSERT INTO f2(cFrom,cTo,cost) VALUES('o','u',57);
61: INSERT INTO f2(cFrom,cTo,cost) VALUES('u','o',58);
62: INSERT INTO f2(cFrom,cTo,cost) VALUES('y','i',33);
63:
64: INSERT INTO f2(cFrom,cTo,cost) VALUES('t','th',70);
65: INSERT INTO f2(cFrom,cTo,cost) VALUES('th','t',66);
66:
67:
68: INSERT INTO f2(cFrom,cTo,cost) VALUES('a','',84);
69: INSERT INTO f2(cFrom,cTo,cost) VALUES('','b',106);
70: INSERT INTO f2(cFrom,cTo,cost) VALUES('b','',106);
71: INSERT INTO f2(cFrom,cTo,cost) VALUES('','c',94);
72: INSERT INTO f2(cFrom,cTo,cost) VALUES('c','',94);
73: INSERT INTO f2(cFrom,cTo,cost) VALUES('','d',89);
74: INSERT INTO f2(cFrom,cTo,cost) VALUES('d','',89);
75: INSERT INTO f2(cFrom,cTo,cost) VALUES('','e',83);
76: INSERT INTO f2(cFrom,cTo,cost) VALUES('e','',83);
77: INSERT INTO f2(cFrom,cTo,cost) VALUES('','f',97);
78: INSERT INTO f2(cFrom,cTo,cost) VALUES('f','',97);
79: INSERT INTO f2(cFrom,cTo,cost) VALUES('','g',99);
80: INSERT INTO f2(cFrom,cTo,cost) VALUES('g','',99);
81: INSERT INTO f2(cFrom,cTo,cost) VALUES('','h',86);
82: INSERT INTO f2(cFrom,cTo,cost) VALUES('h','',86);
83: INSERT INTO f2(cFrom,cTo,cost) VALUES('','i',85);
84: INSERT INTO f2(cFrom,cTo,cost) VALUES('i','',85);
85: INSERT INTO f2(cFrom,cTo,cost) VALUES('','j',120);
86: INSERT INTO f2(cFrom,cTo,cost) VALUES('j','',120);
87: INSERT INTO f2(cFrom,cTo,cost) VALUES('','k',120);
88: INSERT INTO f2(cFrom,cTo,cost) VALUES('k','',120);
89: INSERT INTO f2(cFrom,cTo,cost) VALUES('','l',89);
90: INSERT INTO f2(cFrom,cTo,cost) VALUES('l','',89);
91: INSERT INTO f2(cFrom,cTo,cost) VALUES('','m',96);
92: INSERT INTO f2(cFrom,cTo,cost) VALUES('m','',96);
93: INSERT INTO f2(cFrom,cTo,cost) VALUES('','n',85);
94: INSERT INTO f2(cFrom,cTo,cost) VALUES('n','',85);
95: INSERT INTO f2(cFrom,cTo,cost) VALUES('','o',85);
96: INSERT INTO f2(cFrom,cTo,cost) VALUES('o','',85);
97: INSERT INTO f2(cFrom,cTo,cost) VALUES('','p',100);
98: INSERT INTO f2(cFrom,cTo,cost) VALUES('p','',100);
99: INSERT INTO f2(cFrom,cTo,cost) VALUES('','q',120);
100: INSERT INTO f2(cFrom,cTo,cost) VALUES('q','',120);
101: INSERT INTO f2(cFrom,cTo,cost) VALUES('','r',86);
102: INSERT INTO f2(cFrom,cTo,cost) VALUES('r','',86);
103: INSERT INTO f2(cFrom,cTo,cost) VALUES('','s',86);
104: INSERT INTO f2(cFrom,cTo,cost) VALUES('s','',86);
105: INSERT INTO f2(cFrom,cTo,cost) VALUES('','t',84);
106: INSERT INTO f2(cFrom,cTo,cost) VALUES('t','',84);
107: INSERT INTO f2(cFrom,cTo,cost) VALUES('','u',94);
108: INSERT INTO f2(cFrom,cTo,cost) VALUES('u','',94);
109: INSERT INTO f2(cFrom,cTo,cost) VALUES('','v',120);
110: INSERT INTO f2(cFrom,cTo,cost) VALUES('v','',120);
111: INSERT INTO f2(cFrom,cTo,cost) VALUES('','w',96);
112: INSERT INTO f2(cFrom,cTo,cost) VALUES('w','',96);
113: INSERT INTO f2(cFrom,cTo,cost) VALUES('','x',120);
114: INSERT INTO f2(cFrom,cTo,cost) VALUES('x','',120);
115: INSERT INTO f2(cFrom,cTo,cost) VALUES('','y',100);
116: INSERT INTO f2(cFrom,cTo,cost) VALUES('y','',100);
117: INSERT INTO f2(cFrom,cTo,cost) VALUES('','z',120);
118: INSERT INTO f2(cFrom,cTo,cost) VALUES('z','',120);
119:
120: -- Street names for the 28269 ZIPCODE.
121: --
122: CREATE TEMP TABLE streetname(n TEXT UNIQUE);
123: INSERT INTO streetname VALUES('abbotsinch');
124: INSERT INTO streetname VALUES('abbottsgate');
125: INSERT INTO streetname VALUES('abbywood');
126: INSERT INTO streetname VALUES('abner');
127: INSERT INTO streetname VALUES('acacia ridge');
128: INSERT INTO streetname VALUES('acorn creek');
129: INSERT INTO streetname VALUES('acorn forest');
130: INSERT INTO streetname VALUES('adel');
131: INSERT INTO streetname VALUES('ainslie');
132: INSERT INTO streetname VALUES('airways');
133: INSERT INTO streetname VALUES('alabaster');
134: INSERT INTO streetname VALUES('alba');
135: INSERT INTO streetname VALUES('albertine');
136: INSERT INTO streetname VALUES('alden glen');
137: INSERT INTO streetname VALUES('alderson');
138: INSERT INTO streetname VALUES('allen');
139: INSERT INTO streetname VALUES('allen a brown');
140: INSERT INTO streetname VALUES('allness glen');
141: INSERT INTO streetname VALUES('aloysia');
142: INSERT INTO streetname VALUES('alpine');
143: INSERT INTO streetname VALUES('alwyn');
144: INSERT INTO streetname VALUES('amaranthus');
145: INSERT INTO streetname VALUES('amber glen');
146: INSERT INTO streetname VALUES('amber leigh way');
147: INSERT INTO streetname VALUES('amber meadows');
148: INSERT INTO streetname VALUES('amberway');
149: INSERT INTO streetname VALUES('ame');
150: INSERT INTO streetname VALUES('amesbury hill');
151: INSERT INTO streetname VALUES('anderson');
152: INSERT INTO streetname VALUES('andrew thomas');
153: INSERT INTO streetname VALUES('anduin falls');
154: INSERT INTO streetname VALUES('ankeny');
155: INSERT INTO streetname VALUES('annandale');
156: INSERT INTO streetname VALUES('annbick');
157: INSERT INTO streetname VALUES('antelope');
158: INSERT INTO streetname VALUES('anzack');
159: INSERT INTO streetname VALUES('apple glen');
160: INSERT INTO streetname VALUES('applevalley');
161: INSERT INTO streetname VALUES('appley mead');
162: INSERT INTO streetname VALUES('aragorn');
163: INSERT INTO streetname VALUES('arbor creek');
164: INSERT INTO streetname VALUES('arbor day');
165: INSERT INTO streetname VALUES('arbor meadows');
166: INSERT INTO streetname VALUES('arbor spring');
167: INSERT INTO streetname VALUES('arborview');
168: INSERT INTO streetname VALUES('arklow');
169: INSERT INTO streetname VALUES('armitage');
170: INSERT INTO streetname VALUES('arvin');
171: INSERT INTO streetname VALUES('ash cove');
172: INSERT INTO streetname VALUES('ashford leigh');
173: INSERT INTO streetname VALUES('ashmont');
174: INSERT INTO streetname VALUES('atlas');
175: INSERT INTO streetname VALUES('atwater');
176: INSERT INTO streetname VALUES('auburn hill');
177: INSERT INTO streetname VALUES('aulton link');
178: INSERT INTO streetname VALUES('austin dekota');
179: INSERT INTO streetname VALUES('austin knoll');
180: INSERT INTO streetname VALUES('auten');
181: INSERT INTO streetname VALUES('autumn harvest');
182: INSERT INTO streetname VALUES('autumn oak');
183: INSERT INTO streetname VALUES('autumn ridge');
184: INSERT INTO streetname VALUES('avalon forest');
185: INSERT INTO streetname VALUES('avalon loop');
186: INSERT INTO streetname VALUES('avon farm');
187: INSERT INTO streetname VALUES('avonhurst');
188: INSERT INTO streetname VALUES('avonlea');
189: INSERT INTO streetname VALUES('aynrand');
190: INSERT INTO streetname VALUES('azure valley');
191: INSERT INTO streetname VALUES('baberton');
192: INSERT INTO streetname VALUES('baffin');
193: INSERT INTO streetname VALUES('baggins');
194: INSERT INTO streetname VALUES('balata');
195: INSERT INTO streetname VALUES('ballantray');
196: INSERT INTO streetname VALUES('ballston');
197: INSERT INTO streetname VALUES('balsam tree');
198: INSERT INTO streetname VALUES('bambi');
199: INSERT INTO streetname VALUES('banwell');
200: INSERT INTO streetname VALUES('barbee');
201: INSERT INTO streetname VALUES('barefoot forest');
202: INSERT INTO streetname VALUES('barnview');
203: INSERT INTO streetname VALUES('baroda');
204: INSERT INTO streetname VALUES('barson');
205: INSERT INTO streetname VALUES('baskerville');
206: INSERT INTO streetname VALUES('battle creek');
207: INSERT INTO streetname VALUES('baucom');
208: INSERT INTO streetname VALUES('bay pines');
209: INSERT INTO streetname VALUES('beaker');
210: INSERT INTO streetname VALUES('beard');
211: INSERT INTO streetname VALUES('beardsley');
212: INSERT INTO streetname VALUES('bearoak');
213: INSERT INTO streetname VALUES('beauvista');
214: INSERT INTO streetname VALUES('beaver creek');
215: INSERT INTO streetname VALUES('beaver hollow');
216: INSERT INTO streetname VALUES('bedlington');
217: INSERT INTO streetname VALUES('beech cove');
218: INSERT INTO streetname VALUES('beech crest');
219: INSERT INTO streetname VALUES('beith');
220: INSERT INTO streetname VALUES('bell glen');
221: INSERT INTO streetname VALUES('bellmore');
222: INSERT INTO streetname VALUES('bells mill');
223: INSERT INTO streetname VALUES('bellville');
224: INSERT INTO streetname VALUES('belmar place');
225: INSERT INTO streetname VALUES('bembridge');
226: INSERT INTO streetname VALUES('bennett neely');
227: INSERT INTO streetname VALUES('bentgrass run');
228: INSERT INTO streetname VALUES('benthaven');
229: INSERT INTO streetname VALUES('bernardy');
230: INSERT INTO streetname VALUES('bernbrook shadow');
231: INSERT INTO streetname VALUES('berrybrook');
232: INSERT INTO streetname VALUES('berrybush');
233: INSERT INTO streetname VALUES('berwick');
234: INSERT INTO streetname VALUES('betterton');
235: INSERT INTO streetname VALUES('bickham');
236: INSERT INTO streetname VALUES('billingham');
237: INSERT INTO streetname VALUES('birchcroft');
238: INSERT INTO streetname VALUES('birchstone');
239: INSERT INTO streetname VALUES('birdwell');
240: INSERT INTO streetname VALUES('bisaner');
241: INSERT INTO streetname VALUES('bitterbush');
242: INSERT INTO streetname VALUES('bitterroot');
243: INSERT INTO streetname VALUES('black fox');
244: INSERT INTO streetname VALUES('black maple');
245: INSERT INTO streetname VALUES('black trail');
246: INSERT INTO streetname VALUES('blackbird');
247: INSERT INTO streetname VALUES('blake a dare');
248: INSERT INTO streetname VALUES('blasdell');
249: INSERT INTO streetname VALUES('blue aster');
250: INSERT INTO streetname VALUES('blue finch');
251: INSERT INTO streetname VALUES('blue lilac');
252: INSERT INTO streetname VALUES('blue sky');
253: INSERT INTO streetname VALUES('blue tick');
254: INSERT INTO streetname VALUES('bob beatty');
255: INSERT INTO streetname VALUES('bobcat');
256: INSERT INTO streetname VALUES('bolton');
257: INSERT INTO streetname VALUES('boomerang');
258: INSERT INTO streetname VALUES('boulder');
259: INSERT INTO streetname VALUES('boxer');
260: INSERT INTO streetname VALUES('boxmeer');
261: INSERT INTO streetname VALUES('brachnell view');
262: INSERT INTO streetname VALUES('bradford lake');
263: INSERT INTO streetname VALUES('bradwell');
264: INSERT INTO streetname VALUES('brady');
265: INSERT INTO streetname VALUES('braids bend');
266: INSERT INTO streetname VALUES('bralers');
267: INSERT INTO streetname VALUES('brandie glen');
268: INSERT INTO streetname VALUES('brandy ridge');
269: INSERT INTO streetname VALUES('brandybuck');
270: INSERT INTO streetname VALUES('branthurst');
271: INSERT INTO streetname VALUES('brassy creek');
272: INSERT INTO streetname VALUES('brathay');
273: INSERT INTO streetname VALUES('brawer farm');
274: INSERT INTO streetname VALUES('breezy morn');
275: INSERT INTO streetname VALUES('brenda');
276: INSERT INTO streetname VALUES('brenly');
277: INSERT INTO streetname VALUES('brenock');
278: INSERT INTO streetname VALUES('brianwood');
279: INSERT INTO streetname VALUES('briar rose');
280: INSERT INTO streetname VALUES('briarcrest');
281: INSERT INTO streetname VALUES('briarthorne');
282: INSERT INTO streetname VALUES('brick dust');
283: INSERT INTO streetname VALUES('bridgepath');
284: INSERT INTO streetname VALUES('bridle ridge');
285: INSERT INTO streetname VALUES('briggs');
286: INSERT INTO streetname VALUES('brightleaf');
287: INSERT INTO streetname VALUES('brigstock');
288: INSERT INTO streetname VALUES('broad ridge');
289: INSERT INTO streetname VALUES('brock');
290: INSERT INTO streetname VALUES('brockhampton');
291: INSERT INTO streetname VALUES('broken pine');
292: INSERT INTO streetname VALUES('brompton');
293: INSERT INTO streetname VALUES('brook falls');
294: INSERT INTO streetname VALUES('brookings');
295: INSERT INTO streetname VALUES('browne');
296: INSERT INTO streetname VALUES('brownes creek');
297: INSERT INTO streetname VALUES('brownes ferry');
298: INSERT INTO streetname VALUES('brownestone view');
299: INSERT INTO streetname VALUES('brumit');
300: INSERT INTO streetname VALUES('bryn athyn');
301: INSERT INTO streetname VALUES('buck');
302: INSERT INTO streetname VALUES('bucklebury');
303: INSERT INTO streetname VALUES('buckminister');
304: INSERT INTO streetname VALUES('buckspring');
305: INSERT INTO streetname VALUES('burch');
306: INSERT INTO streetname VALUES('burch shire');
307: INSERT INTO streetname VALUES('burkston');
308: INSERT INTO streetname VALUES('burmith');
309: INSERT INTO streetname VALUES('burnaby');
310: INSERT INTO streetname VALUES('butterfly');
311: INSERT INTO streetname VALUES('cabin creek');
312: INSERT INTO streetname VALUES('cairns mill');
313: INSERT INTO streetname VALUES('callender');
314: INSERT INTO streetname VALUES('cambellton');
315: INSERT INTO streetname VALUES('cambridge bay');
316: INSERT INTO streetname VALUES('canary');
317: INSERT INTO streetname VALUES('canbury');
318: INSERT INTO streetname VALUES('candle leaf');
319: INSERT INTO streetname VALUES('canipe');
320: INSERT INTO streetname VALUES('canipe farm');
321: INSERT INTO streetname VALUES('cannon');
322: INSERT INTO streetname VALUES('canopy');
323: INSERT INTO streetname VALUES('canso');
324: INSERT INTO streetname VALUES('canterbrook');
325: INSERT INTO streetname VALUES('cardinal glen');
326: INSERT INTO streetname VALUES('cardinal point');
327: INSERT INTO streetname VALUES('cardinals nest');
328: INSERT INTO streetname VALUES('carlota');
329: INSERT INTO streetname VALUES('carmathen');
330: INSERT INTO streetname VALUES('carver');
331: INSERT INTO streetname VALUES('carver pond');
332: INSERT INTO streetname VALUES('casa loma');
333: INSERT INTO streetname VALUES('caselton');
334: INSERT INTO streetname VALUES('castello');
335: INSERT INTO streetname VALUES('castle ridge');
336: INSERT INTO streetname VALUES('castleglen');
337: INSERT INTO streetname VALUES('castlemaine');
338: INSERT INTO streetname VALUES('cavett');
339: INSERT INTO streetname VALUES('caymus');
340: INSERT INTO streetname VALUES('cedardale ridge');
341: INSERT INTO streetname VALUES('cedarhurst');
342: INSERT INTO streetname VALUES('cemkey way');
343: INSERT INTO streetname VALUES('cerise');
344: INSERT INTO streetname VALUES('chaceview');
345: INSERT INTO streetname VALUES('chadsworth');
346: INSERT INTO streetname VALUES('chadwell');
347: INSERT INTO streetname VALUES('champions crest');
348: INSERT INTO streetname VALUES('chandler haven');
349: INSERT INTO streetname VALUES('chapel crossing');
350: INSERT INTO streetname VALUES('chapel ridge');
351: INSERT INTO streetname VALUES('charles crawford');
352: INSERT INTO streetname VALUES('charminster');
353: INSERT INTO streetname VALUES('chasewind');
354: INSERT INTO streetname VALUES('chavel');
355: INSERT INTO streetname VALUES('chelsea jade');
356: INSERT INTO streetname VALUES('chestnut knoll');
357: INSERT INTO streetname VALUES('cheviot');
358: INSERT INTO streetname VALUES('chickadee');
359: INSERT INTO streetname VALUES('chidley');
360: INSERT INTO streetname VALUES('chimney ridge');
361: INSERT INTO streetname VALUES('chimney springs');
362: INSERT INTO streetname VALUES('chinaberry');
363: INSERT INTO streetname VALUES('chinemist');
364: INSERT INTO streetname VALUES('chinquapin');
365: INSERT INTO streetname VALUES('chiswell');
366: INSERT INTO streetname VALUES('christenbury');
367: INSERT INTO streetname VALUES('christenbury hills');
368: INSERT INTO streetname VALUES('churchill');
369: INSERT INTO streetname VALUES('cindy');
370: INSERT INTO streetname VALUES('cinnamon teal');
371: INSERT INTO streetname VALUES('citadel');
372: INSERT INTO streetname VALUES('clare olivia');
373: INSERT INTO streetname VALUES('clarke creek');
374: INSERT INTO streetname VALUES('clarke ridge');
375: INSERT INTO streetname VALUES('clear day');
376: INSERT INTO streetname VALUES('clear stream');
377: INSERT INTO streetname VALUES('cleve brown');
378: INSERT INTO streetname VALUES('cliff cameron');
379: INSERT INTO streetname VALUES('cliffvale');
380: INSERT INTO streetname VALUES('cloverside');
381: INSERT INTO streetname VALUES('clymer');
382: INSERT INTO streetname VALUES('coatbridge');
383: INSERT INTO streetname VALUES('cobble glen');
384: INSERT INTO streetname VALUES('cochran farm');
385: INSERT INTO streetname VALUES('cochrane');
386: INSERT INTO streetname VALUES('coleridge');
387: INSERT INTO streetname VALUES('coleshire');
388: INSERT INTO streetname VALUES('collins');
389: INSERT INTO streetname VALUES('colvard');
390: INSERT INTO streetname VALUES('colvard park');
391: INSERT INTO streetname VALUES('condor');
392: INSERT INTO streetname VALUES('conner ridge');
393: INSERT INTO streetname VALUES('connery');
394: INSERT INTO streetname VALUES('cooper run');
395: INSERT INTO streetname VALUES('coopers ridge');
396: INSERT INTO streetname VALUES('copper hill');
397: INSERT INTO streetname VALUES('coppermine');
398: INSERT INTO streetname VALUES('cornelia');
399: INSERT INTO streetname VALUES('corner');
400: INSERT INTO streetname VALUES('cornerstone');
401: INSERT INTO streetname VALUES('cottage oaks');
402: INSERT INTO streetname VALUES('cougar');
403: INSERT INTO streetname VALUES('coves end');
404: INSERT INTO streetname VALUES('cragland');
405: INSERT INTO streetname VALUES('crail');
406: INSERT INTO streetname VALUES('cranberry nook');
407: INSERT INTO streetname VALUES('crawford brook');
408: INSERT INTO streetname VALUES('crayton');
409: INSERT INTO streetname VALUES('creek breeze');
410: INSERT INTO streetname VALUES('crescent ridge');
411: INSERT INTO streetname VALUES('crescent view');
412: INSERT INTO streetname VALUES('cresta');
413: INSERT INTO streetname VALUES('crestfield');
414: INSERT INTO streetname VALUES('crestland');
415: INSERT INTO streetname VALUES('crestwick');
416: INSERT INTO streetname VALUES('crisfield');
417: INSERT INTO streetname VALUES('crisp wood');
418: INSERT INTO streetname VALUES('croft haven');
419: INSERT INTO streetname VALUES('crofton springs');
420: INSERT INTO streetname VALUES('cross');
421: INSERT INTO streetname VALUES('crosspoint center');
422: INSERT INTO streetname VALUES('crownvista');
423: INSERT INTO streetname VALUES('crystal arms');
424: INSERT INTO streetname VALUES('crystal crest');
425: INSERT INTO streetname VALUES('crystal leaf');
426: INSERT INTO streetname VALUES('cunningham park');
427: INSERT INTO streetname VALUES('cypress pond');
428: INSERT INTO streetname VALUES('daffodil');
429: INSERT INTO streetname VALUES('daisyfield');
430: INSERT INTO streetname VALUES('dalecrest');
431: INSERT INTO streetname VALUES('dannelly park');
432: INSERT INTO streetname VALUES('daphne');
433: INSERT INTO streetname VALUES('daria');
434: INSERT INTO streetname VALUES('dartmouth');
435: INSERT INTO streetname VALUES('datha');
436: INSERT INTO streetname VALUES('david cox');
437: INSERT INTO streetname VALUES('davis');
438: INSERT INTO streetname VALUES('davis crossing');
439: INSERT INTO streetname VALUES('davis lake');
440: INSERT INTO streetname VALUES('davis ridge');
441: INSERT INTO streetname VALUES('dawnmist');
442: INSERT INTO streetname VALUES('daybreak');
443: INSERT INTO streetname VALUES('dearmon');
444: INSERT INTO streetname VALUES('dearview');
445: INSERT INTO streetname VALUES('deaton hill');
446: INSERT INTO streetname VALUES('deer cross');
447: INSERT INTO streetname VALUES('deerton');
448: INSERT INTO streetname VALUES('degrasse');
449: INSERT INTO streetname VALUES('delamere');
450: INSERT INTO streetname VALUES('dellfield');
451: INSERT INTO streetname VALUES('dellinger');
452: INSERT INTO streetname VALUES('demington');
453: INSERT INTO streetname VALUES('denmeade');
454: INSERT INTO streetname VALUES('derita');
455: INSERT INTO streetname VALUES('derita woods');
456: INSERT INTO streetname VALUES('deruyter');
457: INSERT INTO streetname VALUES('dervish');
458: INSERT INTO streetname VALUES('devas');
459: INSERT INTO streetname VALUES('devon croft');
460: INSERT INTO streetname VALUES('devonbridge');
461: INSERT INTO streetname VALUES('devongate');
462: INSERT INTO streetname VALUES('devonhill');
463: INSERT INTO streetname VALUES('dewmorn');
464: INSERT INTO streetname VALUES('distribution center');
465: INSERT INTO streetname VALUES('dominion crest');
466: INSERT INTO streetname VALUES('dominion green');
467: INSERT INTO streetname VALUES('dominion village');
468: INSERT INTO streetname VALUES('dorshire');
469: INSERT INTO streetname VALUES('double creek crossing');
470: INSERT INTO streetname VALUES('dow');
471: INSERT INTO streetname VALUES('downfield wood');
472: INSERT INTO streetname VALUES('downing creek');
473: INSERT INTO streetname VALUES('driscol');
474: INSERT INTO streetname VALUES('driwood');
475: INSERT INTO streetname VALUES('dry brook');
476: INSERT INTO streetname VALUES('dumont');
477: INSERT INTO streetname VALUES('dunblane');
478: INSERT INTO streetname VALUES('dunfield');
479: INSERT INTO streetname VALUES('dunoon');
480: INSERT INTO streetname VALUES('dunslow');
481: INSERT INTO streetname VALUES('dunstaff');
482: INSERT INTO streetname VALUES('durham');
483: INSERT INTO streetname VALUES('durston');
484: INSERT INTO streetname VALUES('dusty cedar');
485: INSERT INTO streetname VALUES('dusty trail');
486: INSERT INTO streetname VALUES('dutchess');
487: INSERT INTO streetname VALUES('duxford');
488: INSERT INTO streetname VALUES('eagle creek');
489: INSERT INTO streetname VALUES('eagles field');
490: INSERT INTO streetname VALUES('eargle');
491: INSERT INTO streetname VALUES('earlswood');
492: INSERT INTO streetname VALUES('early mist');
493: INSERT INTO streetname VALUES('earthenware');
494: INSERT INTO streetname VALUES('eastfield park');
495: INSERT INTO streetname VALUES('eastfield village');
496: INSERT INTO streetname VALUES('easy');
497: INSERT INTO streetname VALUES('eben');
498: INSERT INTO streetname VALUES('edgepine');
499: INSERT INTO streetname VALUES('edgewier');
500: INSERT INTO streetname VALUES('edinburgh');
501: INSERT INTO streetname VALUES('edinmeadow');
502: INSERT INTO streetname VALUES('edmonton');
503: INSERT INTO streetname VALUES('edwin jones');
504: INSERT INTO streetname VALUES('elberon');
505: INSERT INTO streetname VALUES('elderslie');
506: INSERT INTO streetname VALUES('elementary view');
507: INSERT INTO streetname VALUES('elendil');
508: INSERT INTO streetname VALUES('elizabeth');
509: INSERT INTO streetname VALUES('elm cove');
510: INSERT INTO streetname VALUES('elrond');
511: INSERT INTO streetname VALUES('elsenham');
512: INSERT INTO streetname VALUES('elven');
513: INSERT INTO streetname VALUES('emma lynn');
514: INSERT INTO streetname VALUES('english setter');
515: INSERT INTO streetname VALUES('enoch');
516: INSERT INTO streetname VALUES('equipment');
517: INSERT INTO streetname VALUES('ernest russell');
518: INSERT INTO streetname VALUES('ernie');
519: INSERT INTO streetname VALUES('esmeralda');
520: INSERT INTO streetname VALUES('evergreen hollow');
521: INSERT INTO streetname VALUES('eversfield');
522: INSERT INTO streetname VALUES('ewen');
523: INSERT INTO streetname VALUES('ewert cut');
524: INSERT INTO streetname VALUES('exbury');
525: INSERT INTO streetname VALUES('fair grounds park');
526: INSERT INTO streetname VALUES('fairbourne');
527: INSERT INTO streetname VALUES('fairchase');
528: INSERT INTO streetname VALUES('faircreek');
529: INSERT INTO streetname VALUES('fairglen');
530: INSERT INTO streetname VALUES('fairlea');
531: INSERT INTO streetname VALUES('fairmead');
532: INSERT INTO streetname VALUES('fairmeadows');
533: INSERT INTO streetname VALUES('fairstone');
534: INSERT INTO streetname VALUES('fairvista');
535: INSERT INTO streetname VALUES('fairway point');
536: INSERT INTO streetname VALUES('falconcrest');
537: INSERT INTO streetname VALUES('falls ridge');
538: INSERT INTO streetname VALUES('falmouth');
539: INSERT INTO streetname VALUES('far west');
540: INSERT INTO streetname VALUES('farlow');
541: INSERT INTO streetname VALUES('farris wheel');
542: INSERT INTO streetname VALUES('fawndale');
543: INSERT INTO streetname VALUES('feather bend');
544: INSERT INTO streetname VALUES('fernledge');
545: INSERT INTO streetname VALUES('fernmoss');
546: INSERT INTO streetname VALUES('ferrell commons');
547: INSERT INTO streetname VALUES('fieldstone');
548: INSERT INTO streetname VALUES('fillian');
549: INSERT INTO streetname VALUES('fincher');
550: INSERT INTO streetname VALUES('foggy meadow');
551: INSERT INTO streetname VALUES('fordyce');
552: INSERT INTO streetname VALUES('forest grove');
553: INSERT INTO streetname VALUES('forest path');
554: INSERT INTO streetname VALUES('forestridge commons');
555: INSERT INTO streetname VALUES('forestrock');
556: INSERT INTO streetname VALUES('fortunes ridge');
557: INSERT INTO streetname VALUES('founders club');
558: INSERT INTO streetname VALUES('fountaingrass');
559: INSERT INTO streetname VALUES('fox chase');
560: INSERT INTO streetname VALUES('fox glen');
561: INSERT INTO streetname VALUES('fox hill');
562: INSERT INTO streetname VALUES('fox point');
563: INSERT INTO streetname VALUES('fox trot');
564: INSERT INTO streetname VALUES('foxbriar');
565: INSERT INTO streetname VALUES('frank little');
566: INSERT INTO streetname VALUES('franzia');
567: INSERT INTO streetname VALUES('french woods');
568: INSERT INTO streetname VALUES('frostmoor');
569: INSERT INTO streetname VALUES('frye');
570: INSERT INTO streetname VALUES('furlong');
571: INSERT INTO streetname VALUES('galena view');
572: INSERT INTO streetname VALUES('gallery pointe');
573: INSERT INTO streetname VALUES('gammon');
574: INSERT INTO streetname VALUES('garden grove');
575: INSERT INTO streetname VALUES('gardendale');
576: INSERT INTO streetname VALUES('garganey');
577: INSERT INTO streetname VALUES('garnet field');
578: INSERT INTO streetname VALUES('garrison');
579: INSERT INTO streetname VALUES('garvin');
580: INSERT INTO streetname VALUES('garvis');
581: INSERT INTO streetname VALUES('gaskill');
582: INSERT INTO streetname VALUES('gemstone');
583: INSERT INTO streetname VALUES('gibbon');
584: INSERT INTO streetname VALUES('gibbon terrace');
585: INSERT INTO streetname VALUES('gibbons link');
586: INSERT INTO streetname VALUES('gillman');
587: INSERT INTO streetname VALUES('gladwood');
588: INSERT INTO streetname VALUES('gladwyne');
589: INSERT INTO streetname VALUES('glamorgan');
590: INSERT INTO streetname VALUES('glaze');
591: INSERT INTO streetname VALUES('glen brook');
592: INSERT INTO streetname VALUES('glen cove');
593: INSERT INTO streetname VALUES('glen hope');
594: INSERT INTO streetname VALUES('glen manor');
595: INSERT INTO streetname VALUES('glen olden');
596: INSERT INTO streetname VALUES('glencairn');
597: INSERT INTO streetname VALUES('glendock');
598: INSERT INTO streetname VALUES('glenolden');
599: INSERT INTO streetname VALUES('glenover');
600: INSERT INTO streetname VALUES('glenshire');
601: INSERT INTO streetname VALUES('glenstone');
602: INSERT INTO streetname VALUES('gold dust');
603: INSERT INTO streetname VALUES('golden pond');
604: INSERT INTO streetname VALUES('goldenblush');
605: INSERT INTO streetname VALUES('goldenfield');
606: INSERT INTO streetname VALUES('goose landing');
607: INSERT INTO streetname VALUES('gorham gate');
608: INSERT INTO streetname VALUES('grabill');
609: INSERT INTO streetname VALUES('graburns ford');
610: INSERT INTO streetname VALUES('graham');
611: INSERT INTO streetname VALUES('grahamson');
612: INSERT INTO streetname VALUES('granard');
613: INSERT INTO streetname VALUES('grand teton');
614: INSERT INTO streetname VALUES('grande heights');
615: INSERT INTO streetname VALUES('grandeur');
616: INSERT INTO streetname VALUES('granite creek');
617: INSERT INTO streetname VALUES('grasset');
618: INSERT INTO streetname VALUES('graypark');
619: INSERT INTO streetname VALUES('grays ridge');
620: INSERT INTO streetname VALUES('great bear');
621: INSERT INTO streetname VALUES('green clover');
622: INSERT INTO streetname VALUES('green hedge');
623: INSERT INTO streetname VALUES('green meadow');
624: INSERT INTO streetname VALUES('green pasture');
625: INSERT INTO streetname VALUES('greene');
626: INSERT INTO streetname VALUES('greenloch');
627: INSERT INTO streetname VALUES('greenock ridge');
628: INSERT INTO streetname VALUES('greenware');
629: INSERT INTO streetname VALUES('greenway village');
630: INSERT INTO streetname VALUES('grenelefe village');
631: INSERT INTO streetname VALUES('grey dogwood');
632: INSERT INTO streetname VALUES('greyhound');
633: INSERT INTO streetname VALUES('greylock ridge');
634: INSERT INTO streetname VALUES('grosbeak');
635: INSERT INTO streetname VALUES('grove');
636: INSERT INTO streetname VALUES('groveton');
637: INSERT INTO streetname VALUES('groveview');
638: INSERT INTO streetname VALUES('hackberry creek');
639: INSERT INTO streetname VALUES('hackberry grove');
640: INSERT INTO streetname VALUES('hackett');
641: INSERT INTO streetname VALUES('haddington');
642: INSERT INTO streetname VALUES('hagler');
643: INSERT INTO streetname VALUES('halcott');
644: INSERT INTO streetname VALUES('half dome');
645: INSERT INTO streetname VALUES('hallam');
646: INSERT INTO streetname VALUES('hamilton russell');
647: INSERT INTO streetname VALUES('hampton place');
648: INSERT INTO streetname VALUES('hankins');
649: INSERT INTO streetname VALUES('harburn forest');
650: INSERT INTO streetname VALUES('harringham');
651: INSERT INTO streetname VALUES('harrington woods');
652: INSERT INTO streetname VALUES('harris corners');
653: INSERT INTO streetname VALUES('harris cove');
654: INSERT INTO streetname VALUES('harris glen');
655: INSERT INTO streetname VALUES('harris hill');
656: INSERT INTO streetname VALUES('harris oak');
657: INSERT INTO streetname VALUES('harris pointe');
658: INSERT INTO streetname VALUES('harris pond');
659: INSERT INTO streetname VALUES('harris ridge');
660: INSERT INTO streetname VALUES('harris technology');
661: INSERT INTO streetname VALUES('harris woods');
662: INSERT INTO streetname VALUES('hartfield downs');
663: INSERT INTO streetname VALUES('hattie little');
664: INSERT INTO streetname VALUES('hatwynn');
665: INSERT INTO streetname VALUES('hawkins');
666: INSERT INTO streetname VALUES('hawksnest');
667: INSERT INTO streetname VALUES('haybridge');
668: INSERT INTO streetname VALUES('hayden');
669: INSERT INTO streetname VALUES('hazelcroft');
670: INSERT INTO streetname VALUES('hazlitt');
671: INSERT INTO streetname VALUES('hazy valley');
672: INSERT INTO streetname VALUES('hearst');
673: INSERT INTO streetname VALUES('heathcrest');
674: INSERT INTO streetname VALUES('heathcroft');
675: INSERT INTO streetname VALUES('hedge maple');
676: INSERT INTO streetname VALUES('hedgecrest');
677: INSERT INTO streetname VALUES('hedingham');
678: INSERT INTO streetname VALUES('heman');
679: INSERT INTO streetname VALUES('henderson');
680: INSERT INTO streetname VALUES('henderson oaks');
681: INSERT INTO streetname VALUES('henderson valley');
682: INSERT INTO streetname VALUES('hendry');
683: INSERT INTO streetname VALUES('heritage hills');
684: INSERT INTO streetname VALUES('heritage woods');
685: INSERT INTO streetname VALUES('heron cove');
686: INSERT INTO streetname VALUES('heron glen');
687: INSERT INTO streetname VALUES('hewitt');
688: INSERT INTO streetname VALUES('hey rock');
689: INSERT INTO streetname VALUES('heysham');
690: INSERT INTO streetname VALUES('hickory cove');
691: INSERT INTO streetname VALUES('hidden meadow');
692: INSERT INTO streetname VALUES('high glen');
693: INSERT INTO streetname VALUES('high laurel');
694: INSERT INTO streetname VALUES('high valley');
695: INSERT INTO streetname VALUES('highcroft');
696: INSERT INTO streetname VALUES('highland');
697: INSERT INTO streetname VALUES('highland commons');
698: INSERT INTO streetname VALUES('highland creek');
699: INSERT INTO streetname VALUES('highland glen');
700: INSERT INTO streetname VALUES('highland park');
701: INSERT INTO streetname VALUES('highlander');
702: INSERT INTO streetname VALUES('highstream');
703: INSERT INTO streetname VALUES('hilltop');
704: INSERT INTO streetname VALUES('hobbitshire');
705: INSERT INTO streetname VALUES('hoffman');
706: INSERT INTO streetname VALUES('hogans way');
707: INSERT INTO streetname VALUES('holbert');
708: INSERT INTO streetname VALUES('hollow ridge');
709: INSERT INTO streetname VALUES('holly vista');
710: INSERT INTO streetname VALUES('hollywood');
711: INSERT INTO streetname VALUES('hoover');
712: INSERT INTO streetname VALUES('hopkins');
713: INSERT INTO streetname VALUES('horace mann');
714: INSERT INTO streetname VALUES('hornbeam');
715: INSERT INTO streetname VALUES('horse pasture');
716: INSERT INTO streetname VALUES('hosta');
717: INSERT INTO streetname VALUES('howard');
718: INSERT INTO streetname VALUES('hubbard');
719: INSERT INTO streetname VALUES('hubbard falls');
720: INSERT INTO streetname VALUES('hubbard woods');
721: INSERT INTO streetname VALUES('hucks');
722: INSERT INTO streetname VALUES('hunters creek');
723: INSERT INTO streetname VALUES('hunters pointe');
724: INSERT INTO streetname VALUES('hunters spring');
725: INSERT INTO streetname VALUES('hunters whip');
726: INSERT INTO streetname VALUES('huntmeadow');
727: INSERT INTO streetname VALUES('hutchison mcdonald');
728: INSERT INTO streetname VALUES('ingleton');
729: INSERT INTO streetname VALUES('insdale');
730: INSERT INTO streetname VALUES('interstate 85 service');
731: INSERT INTO streetname VALUES('iola');
732: INSERT INTO streetname VALUES('iredell');
733: INSERT INTO streetname VALUES('iron brigade');
734: INSERT INTO streetname VALUES('irwin valley');
735: INSERT INTO streetname VALUES('irwin wood');
736: INSERT INTO streetname VALUES('ivy brook');
737: INSERT INTO streetname VALUES('ivy ridge');
738: INSERT INTO streetname VALUES('jack russell');
739: INSERT INTO streetname VALUES('jackson');
740: INSERT INTO streetname VALUES('jacob martin');
741: INSERT INTO streetname VALUES('jamison');
742: INSERT INTO streetname VALUES('jane');
743: INSERT INTO streetname VALUES('jaspar crest');
744: INSERT INTO streetname VALUES('jessica');
745: INSERT INTO streetname VALUES('jimmy oehler');
746: INSERT INTO streetname VALUES('jocelyn');
747: INSERT INTO streetname VALUES('johnston mill');
748: INSERT INTO streetname VALUES('johnston oehler');
749: INSERT INTO streetname VALUES('judal');
750: INSERT INTO streetname VALUES('junipeous');
751: INSERT INTO streetname VALUES('juniper');
752: INSERT INTO streetname VALUES('juniperus');
753: INSERT INTO streetname VALUES('kalispell');
754: INSERT INTO streetname VALUES('karylsturn');
755: INSERT INTO streetname VALUES('katelyn');
756: INSERT INTO streetname VALUES('kayron');
757: INSERT INTO streetname VALUES('keaton');
758: INSERT INTO streetname VALUES('keble');
759: INSERT INTO streetname VALUES('keels');
760: INSERT INTO streetname VALUES('keith');
761: INSERT INTO streetname VALUES('keithwood');
762: INSERT INTO streetname VALUES('kelden walker');
763: INSERT INTO streetname VALUES('kelsey emma');
764: INSERT INTO streetname VALUES('kendrick');
765: INSERT INTO streetname VALUES('kenmont');
766: INSERT INTO streetname VALUES('kennerly cove');
767: INSERT INTO streetname VALUES('kenninghall');
768: INSERT INTO streetname VALUES('kent village');
769: INSERT INTO streetname VALUES('kestral ridge');
770: INSERT INTO streetname VALUES('kestrel');
771: INSERT INTO streetname VALUES('kilmartin');
772: INSERT INTO streetname VALUES('kilty');
773: INSERT INTO streetname VALUES('kinglet');
774: INSERT INTO streetname VALUES('kingsland');
775: INSERT INTO streetname VALUES('kingsnorth');
776: INSERT INTO streetname VALUES('kinsmore');
777: INSERT INTO streetname VALUES('kirkgard');
778: INSERT INTO streetname VALUES('kirkmont');
779: INSERT INTO streetname VALUES('knightsgate');
780: INSERT INTO streetname VALUES('kobuk');
781: INSERT INTO streetname VALUES('kotlik');
782: INSERT INTO streetname VALUES('kotz');
783: INSERT INTO streetname VALUES('kyndall walk');
784: INSERT INTO streetname VALUES('laborde');
785: INSERT INTO streetname VALUES('lady bank');
786: INSERT INTO streetname VALUES('lagrande');
787: INSERT INTO streetname VALUES('lake');
788: INSERT INTO streetname VALUES('lakeridge commons');
789: INSERT INTO streetname VALUES('lakeview');
790: INSERT INTO streetname VALUES('lakewood edge');
791: INSERT INTO streetname VALUES('lakota');
792: INSERT INTO streetname VALUES('lambrook');
793: INSERT INTO streetname VALUES('lampkin');
794: INSERT INTO streetname VALUES('lampkin park');
795: INSERT INTO streetname VALUES('langham');
796: INSERT INTO streetname VALUES('lanzerac manor');
797: INSERT INTO streetname VALUES('larkmead forest');
798: INSERT INTO streetname VALUES('lattice');
799: INSERT INTO streetname VALUES('laurel crest');
800: INSERT INTO streetname VALUES('laurel ridge');
801: INSERT INTO streetname VALUES('laurel run');
802: INSERT INTO streetname VALUES('laurenfield');
803: INSERT INTO streetname VALUES('laveta');
804: INSERT INTO streetname VALUES('lazy day');
805: INSERT INTO streetname VALUES('leawood run');
806: INSERT INTO streetname VALUES('lee marie');
807: INSERT INTO streetname VALUES('legacy lake');
808: INSERT INTO streetname VALUES('legacy park');
809: INSERT INTO streetname VALUES('legato');
810: INSERT INTO streetname VALUES('legolas');
811: INSERT INTO streetname VALUES('leigh glen');
812: INSERT INTO streetname VALUES('lence');
813: INSERT INTO streetname VALUES('lenox hill');
814: INSERT INTO streetname VALUES('leonine');
815: INSERT INTO streetname VALUES('leslie');
816: INSERT INTO streetname VALUES('lester hill');
817: INSERT INTO streetname VALUES('levisey');
818: INSERT INTO streetname VALUES('liberty bell');
819: INSERT INTO streetname VALUES('linden berry');
820: INSERT INTO streetname VALUES('lisbon');
821: INSERT INTO streetname VALUES('little stoney');
822: INSERT INTO streetname VALUES('livengood');
823: INSERT INTO streetname VALUES('lochway');
824: INSERT INTO streetname VALUES('lockman');
825: INSERT INTO streetname VALUES('loganville');
826: INSERT INTO streetname VALUES('lone tree');
827: INSERT INTO streetname VALUES('long creek park');
828: INSERT INTO streetname VALUES('long forest');
829: INSERT INTO streetname VALUES('looking glass');
830: INSERT INTO streetname VALUES('lookout point');
831: INSERT INTO streetname VALUES('lowen');
832: INSERT INTO streetname VALUES('lusby');
833: INSERT INTO streetname VALUES('lyleton');
834: INSERT INTO streetname VALUES('lynn lee');
835: INSERT INTO streetname VALUES('lynnewood glen');
836: INSERT INTO streetname VALUES('machrie');
837: INSERT INTO streetname VALUES('mackinac');
838: INSERT INTO streetname VALUES('maddox');
839: INSERT INTO streetname VALUES('madison park');
840: INSERT INTO streetname VALUES('mallard');
841: INSERT INTO streetname VALUES('mallard cove');
842: INSERT INTO streetname VALUES('mallard forest');
843: INSERT INTO streetname VALUES('mallard grove');
844: INSERT INTO streetname VALUES('mallard hill');
845: INSERT INTO streetname VALUES('mallard park');
846: INSERT INTO streetname VALUES('mallard ridge');
847: INSERT INTO streetname VALUES('mallard view');
848: INSERT INTO streetname VALUES('manbey');
849: INSERT INTO streetname VALUES('manning');
850: INSERT INTO streetname VALUES('mantario');
851: INSERT INTO streetname VALUES('maple');
852: INSERT INTO streetname VALUES('maple cove');
853: INSERT INTO streetname VALUES('maple park');
854: INSERT INTO streetname VALUES('marathon hill');
855: INSERT INTO streetname VALUES('marbury');
856: INSERT INTO streetname VALUES('marett');
857: INSERT INTO streetname VALUES('marigold');
858: INSERT INTO streetname VALUES('marionwood');
859: INSERT INTO streetname VALUES('marshbank');
860: INSERT INTO streetname VALUES('mason');
861: INSERT INTO streetname VALUES('mayapple');
862: INSERT INTO streetname VALUES('maylandia');
863: INSERT INTO streetname VALUES('mayspring');
864: INSERT INTO streetname VALUES('mcadam');
865: INSERT INTO streetname VALUES('mcchesney');
866: INSERT INTO streetname VALUES('mccurdy');
867: INSERT INTO streetname VALUES('mcgrath');
868: INSERT INTO streetname VALUES('mckendree');
869: INSERT INTO streetname VALUES('mclaughlin');
870: INSERT INTO streetname VALUES('mctaggart');
871: INSERT INTO streetname VALUES('meadow green');
872: INSERT INTO streetname VALUES('meadow knoll');
873: INSERT INTO streetname VALUES('meadow post');
874: INSERT INTO streetname VALUES('meadowmont');
875: INSERT INTO streetname VALUES('meadowmont view');
876: INSERT INTO streetname VALUES('meadowview hills');
877: INSERT INTO streetname VALUES('melshire');
878: INSERT INTO streetname VALUES('melstrand');
879: INSERT INTO streetname VALUES('mentone');
880: INSERT INTO streetname VALUES('meridale crossing');
881: INSERT INTO streetname VALUES('merion hills');
882: INSERT INTO streetname VALUES('merlot');
883: INSERT INTO streetname VALUES('mersham');
884: INSERT INTO streetname VALUES('metromont');
885: INSERT INTO streetname VALUES('metromont industrial');
886: INSERT INTO streetname VALUES('michaw');
887: INSERT INTO streetname VALUES('milhaven');
888: INSERT INTO streetname VALUES('milhof');
889: INSERT INTO streetname VALUES('millstream ridge');
890: INSERT INTO streetname VALUES('mineral ridge');
891: INSERT INTO streetname VALUES('mint thistle');
892: INSERT INTO streetname VALUES('mintleaf');
893: INSERT INTO streetname VALUES('mintvale');
894: INSERT INTO streetname VALUES('misty');
895: INSERT INTO streetname VALUES('misty arbor');
896: INSERT INTO streetname VALUES('misty creek');
897: INSERT INTO streetname VALUES('misty oaks');
898: INSERT INTO streetname VALUES('misty wood');
899: INSERT INTO streetname VALUES('mitzi deborah');
900: INSERT INTO streetname VALUES('mobile');
901: INSERT INTO streetname VALUES('molly elizabeth');
902: INSERT INTO streetname VALUES('monmouth');
903: INSERT INTO streetname VALUES('montrose');
904: INSERT INTO streetname VALUES('moonlight');
905: INSERT INTO streetname VALUES('moose');
906: INSERT INTO streetname VALUES('morning dew');
907: INSERT INTO streetname VALUES('morningsong');
908: INSERT INTO streetname VALUES('morningview');
909: INSERT INTO streetname VALUES('morsey');
910: INSERT INTO streetname VALUES('moss glen');
911: INSERT INTO streetname VALUES('mossy bank');
912: INSERT INTO streetname VALUES('motor sport');
913: INSERT INTO streetname VALUES('mountain laurel');
914: INSERT INTO streetname VALUES('mourning dove');
915: INSERT INTO streetname VALUES('mozart');
916: INSERT INTO streetname VALUES('munsing');
917: INSERT INTO streetname VALUES('murray');
918: INSERT INTO streetname VALUES('nathan');
919: INSERT INTO streetname VALUES('netherhall');
920: INSERT INTO streetname VALUES('netherton');
921: INSERT INTO streetname VALUES('neuhoff');
922: INSERT INTO streetname VALUES('nevin');
923: INSERT INTO streetname VALUES('nevin brook');
924: INSERT INTO streetname VALUES('nevin glen');
925: INSERT INTO streetname VALUES('nevin place');
926: INSERT INTO streetname VALUES('new england');
927: INSERT INTO streetname VALUES('new house');
928: INSERT INTO streetname VALUES('newbary');
929: INSERT INTO streetname VALUES('newchurch');
930: INSERT INTO streetname VALUES('newfane');
931: INSERT INTO streetname VALUES('newgard');
932: INSERT INTO streetname VALUES('nicholas');
933: INSERT INTO streetname VALUES('nicole');
934: INSERT INTO streetname VALUES('nobility');
935: INSERT INTO streetname VALUES('norcroft');
936: INSERT INTO streetname VALUES('northridge');
937: INSERT INTO streetname VALUES('northside');
938: INSERT INTO streetname VALUES('northwoods business');
939: INSERT INTO streetname VALUES('norway');
940: INSERT INTO streetname VALUES('nottinghill');
941: INSERT INTO streetname VALUES('numenore');
942: INSERT INTO streetname VALUES('nyewood');
943: INSERT INTO streetname VALUES('oak');
944: INSERT INTO streetname VALUES('oak cove');
945: INSERT INTO streetname VALUES('oak pasture');
946: INSERT INTO streetname VALUES('oakburn');
947: INSERT INTO streetname VALUES('oakwinds');
948: INSERT INTO streetname VALUES('oakwood');
949: INSERT INTO streetname VALUES('obrien');
950: INSERT INTO streetname VALUES('ocala');
951: INSERT INTO streetname VALUES('old bridge');
952: INSERT INTO streetname VALUES('old fox');
953: INSERT INTO streetname VALUES('old potters');
954: INSERT INTO streetname VALUES('old statesville');
955: INSERT INTO streetname VALUES('old steine');
956: INSERT INTO streetname VALUES('old stoney creek');
957: INSERT INTO streetname VALUES('old sugar creek');
958: INSERT INTO streetname VALUES('old timber');
959: INSERT INTO streetname VALUES('old wagon');
960: INSERT INTO streetname VALUES('old willow');
961: INSERT INTO streetname VALUES('oldenway');
962: INSERT INTO streetname VALUES('oneida');
963: INSERT INTO streetname VALUES('ontario');
964: INSERT INTO streetname VALUES('oriole');
965: INSERT INTO streetname VALUES('orofino');
966: INSERT INTO streetname VALUES('orr');
967: INSERT INTO streetname VALUES('osage');
968: INSERT INTO streetname VALUES('osceola');
969: INSERT INTO streetname VALUES('osprey knoll');
970: INSERT INTO streetname VALUES('oxford hill');
971: INSERT INTO streetname VALUES('painted fern');
972: INSERT INTO streetname VALUES('painted pony');
973: INSERT INTO streetname VALUES('paisley');
974: INSERT INTO streetname VALUES('pale moss');
975: INSERT INTO streetname VALUES('palladium');
976: INSERT INTO streetname VALUES('palmutum');
977: INSERT INTO streetname VALUES('palustris');
978: INSERT INTO streetname VALUES('panglemont');
979: INSERT INTO streetname VALUES('panther');
980: INSERT INTO streetname VALUES('panthersville');
981: INSERT INTO streetname VALUES('paper whites');
982: INSERT INTO streetname VALUES('park');
983: INSERT INTO streetname VALUES('parker green');
984: INSERT INTO streetname VALUES('parkhouse');
985: INSERT INTO streetname VALUES('passour ridge');
986: INSERT INTO streetname VALUES('pasture view');
987: INSERT INTO streetname VALUES('patricia ann');
988: INSERT INTO streetname VALUES('patton');
989: INSERT INTO streetname VALUES('patton ridge');
990: INSERT INTO streetname VALUES('pawpaw');
991: INSERT INTO streetname VALUES('peach');
992: INSERT INTO streetname VALUES('peakwood');
993: INSERT INTO streetname VALUES('pebble creek');
994: INSERT INTO streetname VALUES('pecan cove');
995: INSERT INTO streetname VALUES('pedigree');
996: INSERT INTO streetname VALUES('pelorus');
997: INSERT INTO streetname VALUES('penmore');
998: INSERT INTO streetname VALUES('pensfold');
999: INSERT INTO streetname VALUES('pepperstone');
1000: INSERT INTO streetname VALUES('peregrine');
1001: INSERT INTO streetname VALUES('periwinkle');
1002: INSERT INTO streetname VALUES('perkins');
1003: INSERT INTO streetname VALUES('pete brown');
1004: INSERT INTO streetname VALUES('phillips');
1005: INSERT INTO streetname VALUES('pickway');
1006: INSERT INTO streetname VALUES('piercy woods');
1007: INSERT INTO streetname VALUES('pierpoint');
1008: INSERT INTO streetname VALUES('pine');
1009: INSERT INTO streetname VALUES('pine branch');
1010: INSERT INTO streetname VALUES('pine meadow');
1011: INSERT INTO streetname VALUES('pineleaf');
1012: INSERT INTO streetname VALUES('pinewood');
1013: INSERT INTO streetname VALUES('pintail');
1014: INSERT INTO streetname VALUES('pipestone');
1015: INSERT INTO streetname VALUES('placer maple');
1016: INSERT INTO streetname VALUES('plover');
1017: INSERT INTO streetname VALUES('plum');
1018: INSERT INTO streetname VALUES('po box');
1019: INSERT INTO streetname VALUES('pochard');
1020: INSERT INTO streetname VALUES('pointview');
1021: INSERT INTO streetname VALUES('polk and white');
1022: INSERT INTO streetname VALUES('pond valley');
1023: INSERT INTO streetname VALUES('pondridge');
1024: INSERT INTO streetname VALUES('pope farm');
1025: INSERT INTO streetname VALUES('poplar grove');
1026: INSERT INTO streetname VALUES('poplar springs');
1027: INSERT INTO streetname VALUES('portola');
1028: INSERT INTO streetname VALUES('potters glen');
1029: INSERT INTO streetname VALUES('powatan');
1030: INSERT INTO streetname VALUES('prairie valley');
1031: INSERT INTO streetname VALUES('prescott');
1032: INSERT INTO streetname VALUES('presmann');
1033: INSERT INTO streetname VALUES('prestigious');
1034: INSERT INTO streetname VALUES('princess');
1035: INSERT INTO streetname VALUES('prosperity');
1036: INSERT INTO streetname VALUES('prosperity church');
1037: INSERT INTO streetname VALUES('prosperity commons');
1038: INSERT INTO streetname VALUES('prosperity park');
1039: INSERT INTO streetname VALUES('prosperity point');
1040: INSERT INTO streetname VALUES('prosperity ridge');
1041: INSERT INTO streetname VALUES('prosperity view');
1042: INSERT INTO streetname VALUES('purple finch');
1043: INSERT INTO streetname VALUES('quail');
1044: INSERT INTO streetname VALUES('queensbury');
1045: INSERT INTO streetname VALUES('quinn');
1046: INSERT INTO streetname VALUES('racine');
1047: INSERT INTO streetname VALUES('radbourne');
1048: INSERT INTO streetname VALUES('raddington');
1049: INSERT INTO streetname VALUES('raku');
1050: INSERT INTO streetname VALUES('rancliffe');
1051: INSERT INTO streetname VALUES('ravencrest');
1052: INSERT INTO streetname VALUES('reames');
1053: INSERT INTO streetname VALUES('rebecca run');
1054: INSERT INTO streetname VALUES('red bluff');
1055: INSERT INTO streetname VALUES('red clay');
1056: INSERT INTO streetname VALUES('red clover');
1057: INSERT INTO streetname VALUES('red rose');
1058: INSERT INTO streetname VALUES('red shed');
1059: INSERT INTO streetname VALUES('red tail');
1060: INSERT INTO streetname VALUES('redbridge');
1061: INSERT INTO streetname VALUES('redstart');
1062: INSERT INTO streetname VALUES('redstone view');
1063: INSERT INTO streetname VALUES('reedmont');
1064: INSERT INTO streetname VALUES('reeves');
1065: INSERT INTO streetname VALUES('regal');
1066: INSERT INTO streetname VALUES('reinbeck');
1067: INSERT INTO streetname VALUES('retriever');
1068: INSERT INTO streetname VALUES('ribbonwalk');
1069: INSERT INTO streetname VALUES('richardson park');
1070: INSERT INTO streetname VALUES('richfield');
1071: INSERT INTO streetname VALUES('riddings');
1072: INSERT INTO streetname VALUES('ridge');
1073: INSERT INTO streetname VALUES('ridge cliff');
1074: INSERT INTO streetname VALUES('ridge path');
1075: INSERT INTO streetname VALUES('ridge peak');
1076: INSERT INTO streetname VALUES('ridgefield');
1077: INSERT INTO streetname VALUES('ridgeline');
1078: INSERT INTO streetname VALUES('ridgeview commons');
1079: INSERT INTO streetname VALUES('riley');
1080: INSERT INTO streetname VALUES('riley woods');
1081: INSERT INTO streetname VALUES('rillet');
1082: INSERT INTO streetname VALUES('rindle');
1083: INSERT INTO streetname VALUES('rivendell');
1084: INSERT INTO streetname VALUES('robin');
1085: INSERT INTO streetname VALUES('robins nest');
1086: INSERT INTO streetname VALUES('robur');
1087: INSERT INTO streetname VALUES('robyns glen');
1088: INSERT INTO streetname VALUES('rock stream');
1089: INSERT INTO streetname VALUES('rockwell');
1090: INSERT INTO streetname VALUES('rockwell church');
1091: INSERT INTO streetname VALUES('rocky brook');
1092: INSERT INTO streetname VALUES('rocky ford club');
1093: INSERT INTO streetname VALUES('rotary');
1094: INSERT INTO streetname VALUES('rouda');
1095: INSERT INTO streetname VALUES('royal bluff');
1096: INSERT INTO streetname VALUES('royal celadon');
1097: INSERT INTO streetname VALUES('rubin lura');
1098: INSERT INTO streetname VALUES('runswyck');
1099: INSERT INTO streetname VALUES('ruth ferrell');
1100: INSERT INTO streetname VALUES('ruth polk');
1101: INSERT INTO streetname VALUES('ryan jay');
1102: INSERT INTO streetname VALUES('sackett');
1103: INSERT INTO streetname VALUES('saddle pace');
1104: INSERT INTO streetname VALUES('saddle run');
1105: INSERT INTO streetname VALUES('saddle trail');
1106: INSERT INTO streetname VALUES('saguaro');
1107: INSERT INTO streetname VALUES('saint audrey');
1108: INSERT INTO streetname VALUES('saint bernard');
1109: INSERT INTO streetname VALUES('saint frances');
1110: INSERT INTO streetname VALUES('sam roper');
1111: INSERT INTO streetname VALUES('samara');
1112: INSERT INTO streetname VALUES('sanders creek');
1113: INSERT INTO streetname VALUES('saquache');
1114: INSERT INTO streetname VALUES('sarnia');
1115: INSERT INTO streetname VALUES('savannah springs');
1116: INSERT INTO streetname VALUES('sawgrass ridge');
1117: INSERT INTO streetname VALUES('saxonbury');
1118: INSERT INTO streetname VALUES('scotch moss');
1119: INSERT INTO streetname VALUES('seasons');
1120: INSERT INTO streetname VALUES('serenity');
1121: INSERT INTO streetname VALUES('seths');
1122: INSERT INTO streetname VALUES('shadow lawn');
1123: INSERT INTO streetname VALUES('shadow oaks');
1124: INSERT INTO streetname VALUES('shadow pine');
1125: INSERT INTO streetname VALUES('shadyside');
1126: INSERT INTO streetname VALUES('shallow oak');
1127: INSERT INTO streetname VALUES('shelley');
1128: INSERT INTO streetname VALUES('shining oak');
1129: INSERT INTO streetname VALUES('ship');
1130: INSERT INTO streetname VALUES('shore haven');
1131: INSERT INTO streetname VALUES('shuman');
1132: INSERT INTO streetname VALUES('sidney');
1133: INSERT INTO streetname VALUES('silver birch');
1134: INSERT INTO streetname VALUES('silvermere');
1135: INSERT INTO streetname VALUES('simonton');
1136: INSERT INTO streetname VALUES('singing hills');
1137: INSERT INTO streetname VALUES('singing oak');
1138: INSERT INTO streetname VALUES('sipes');
1139: INSERT INTO streetname VALUES('six point');
1140: INSERT INTO streetname VALUES('skycrest');
1141: INSERT INTO streetname VALUES('skyline');
1142: INSERT INTO streetname VALUES('small');
1143: INSERT INTO streetname VALUES('smith corners');
1144: INSERT INTO streetname VALUES('smithwood');
1145: INSERT INTO streetname VALUES('snow hill');
1146: INSERT INTO streetname VALUES('soapstone');
1147: INSERT INTO streetname VALUES('sobeck');
1148: INSERT INTO streetname VALUES('socata');
1149: INSERT INTO streetname VALUES('solace');
1150: INSERT INTO streetname VALUES('solway');
1151: INSERT INTO streetname VALUES('song sparrow');
1152: INSERT INTO streetname VALUES('sorrento');
1153: INSERT INTO streetname VALUES('spector');
1154: INSERT INTO streetname VALUES('spin drift');
1155: INSERT INTO streetname VALUES('spring crest');
1156: INSERT INTO streetname VALUES('spring lee');
1157: INSERT INTO streetname VALUES('spring park');
1158: INSERT INTO streetname VALUES('spring terrace');
1159: INSERT INTO streetname VALUES('spring trace');
1160: INSERT INTO streetname VALUES('springhaven');
1161: INSERT INTO streetname VALUES('squirrel trail');
1162: INSERT INTO streetname VALUES('stardust');
1163: INSERT INTO streetname VALUES('stargaze');
1164: INSERT INTO streetname VALUES('starita');
1165: INSERT INTO streetname VALUES('starmount');
1166: INSERT INTO streetname VALUES('statesville');
1167: INSERT INTO streetname VALUES('steed');
1168: INSERT INTO streetname VALUES('steelewood');
1169: INSERT INTO streetname VALUES('steepleglen');
1170: INSERT INTO streetname VALUES('stephens farm');
1171: INSERT INTO streetname VALUES('stewarton');
1172: INSERT INTO streetname VALUES('stone park');
1173: INSERT INTO streetname VALUES('stonebrook');
1174: INSERT INTO streetname VALUES('stonefield');
1175: INSERT INTO streetname VALUES('stoneglen');
1176: INSERT INTO streetname VALUES('stonemarsh');
1177: INSERT INTO streetname VALUES('stoney garden');
1178: INSERT INTO streetname VALUES('stoney run');
1179: INSERT INTO streetname VALUES('stoney valley');
1180: INSERT INTO streetname VALUES('stoneykirk');
1181: INSERT INTO streetname VALUES('stream bank');
1182: INSERT INTO streetname VALUES('stream ridge');
1183: INSERT INTO streetname VALUES('suburban');
1184: INSERT INTO streetname VALUES('suffield');
1185: INSERT INTO streetname VALUES('sugar creek');
1186: INSERT INTO streetname VALUES('sugarberry');
1187: INSERT INTO streetname VALUES('sugarstone');
1188: INSERT INTO streetname VALUES('summer creek');
1189: INSERT INTO streetname VALUES('summer valley');
1190: INSERT INTO streetname VALUES('summercrest');
1191: INSERT INTO streetname VALUES('summercroft');
1192: INSERT INTO streetname VALUES('summerford');
1193: INSERT INTO streetname VALUES('summergold');
1194: INSERT INTO streetname VALUES('sunbeam');
1195: INSERT INTO streetname VALUES('sunbridge');
1196: INSERT INTO streetname VALUES('sunpath');
1197: INSERT INTO streetname VALUES('sunset');
1198: INSERT INTO streetname VALUES('sunset ridge');
1199: INSERT INTO streetname VALUES('sunstone');
1200: INSERT INTO streetname VALUES('suntrace');
1201: INSERT INTO streetname VALUES('sunwalk');
1202: INSERT INTO streetname VALUES('sutters hill');
1203: INSERT INTO streetname VALUES('suttonview');
1204: INSERT INTO streetname VALUES('swallow tail');
1205: INSERT INTO streetname VALUES('swanston');
1206: INSERT INTO streetname VALUES('sweet grove');
1207: INSERT INTO streetname VALUES('sweet rose');
1208: INSERT INTO streetname VALUES('sweetbriar ridge');
1209: INSERT INTO streetname VALUES('sweetfield');
1210: INSERT INTO streetname VALUES('sydney overlook');
1211: INSERT INTO streetname VALUES('sylvan');
1212: INSERT INTO streetname VALUES('symphony woods');
1213: INSERT INTO streetname VALUES('tallia');
1214: INSERT INTO streetname VALUES('tallu');
1215: INSERT INTO streetname VALUES('talwyn');
1216: INSERT INTO streetname VALUES('tanager');
1217: INSERT INTO streetname VALUES('tanager park');
1218: INSERT INTO streetname VALUES('tangley');
1219: INSERT INTO streetname VALUES('taranasay');
1220: INSERT INTO streetname VALUES('tarby');
1221: INSERT INTO streetname VALUES('tarland');
1222: INSERT INTO streetname VALUES('tarpway');
1223: INSERT INTO streetname VALUES('tauten');
1224: INSERT INTO streetname VALUES('taymouth');
1225: INSERT INTO streetname VALUES('ten trees');
1226: INSERT INTO streetname VALUES('terrace view');
1227: INSERT INTO streetname VALUES('terrier');
1228: INSERT INTO streetname VALUES('tesh');
1229: INSERT INTO streetname VALUES('teton');
1230: INSERT INTO streetname VALUES('tewkesbury');
1231: INSERT INTO streetname VALUES('thelema');
1232: INSERT INTO streetname VALUES('thistle bloom');
1233: INSERT INTO streetname VALUES('thistledown');
1234: INSERT INTO streetname VALUES('thomas ridge');
1235: INSERT INTO streetname VALUES('thornbrook');
1236: INSERT INTO streetname VALUES('tifton grass');
1237: INSERT INTO streetname VALUES('tigerton');
1238: INSERT INTO streetname VALUES('tomsie efird');
1239: INSERT INTO streetname VALUES('tor');
1240: INSERT INTO streetname VALUES('torphin');
1241: INSERT INTO streetname VALUES('torrence');
1242: INSERT INTO streetname VALUES('towering pine');
1243: INSERT INTO streetname VALUES('towhee');
1244: INSERT INTO streetname VALUES('toxaway');
1245: INSERT INTO streetname VALUES('tracy glenn');
1246: INSERT INTO streetname VALUES('tradition view');
1247: INSERT INTO streetname VALUES('trailer');
1248: INSERT INTO streetname VALUES('transport');
1249: INSERT INTO streetname VALUES('trehurst');
1250: INSERT INTO streetname VALUES('trexler');
1251: INSERT INTO streetname VALUES('trillium fields');
1252: INSERT INTO streetname VALUES('trimbach');
1253: INSERT INTO streetname VALUES('tucker');
1254: INSERT INTO streetname VALUES('tullamore');
1255: INSERT INTO streetname VALUES('tullock creek');
1256: INSERT INTO streetname VALUES('tunston');
1257: INSERT INTO streetname VALUES('tupelo');
1258: INSERT INTO streetname VALUES('turnabout');
1259: INSERT INTO streetname VALUES('turney');
1260: INSERT INTO streetname VALUES('turtle cross');
1261: INSERT INTO streetname VALUES('turtleback');
1262: INSERT INTO streetname VALUES('twelvestone');
1263: INSERT INTO streetname VALUES('twin');
1264: INSERT INTO streetname VALUES('twin brook');
1265: INSERT INTO streetname VALUES('twin lakes');
1266: INSERT INTO streetname VALUES('twisted pine');
1267: INSERT INTO streetname VALUES('tyler finley');
1268: INSERT INTO streetname VALUES('university station');
1269: INSERT INTO streetname VALUES('uphill');
1270: INSERT INTO streetname VALUES('valeview');
1271: INSERT INTO streetname VALUES('valhalla');
1272: INSERT INTO streetname VALUES('van');
1273: INSERT INTO streetname VALUES('vance davis');
1274: INSERT INTO streetname VALUES('vanhoy');
1275: INSERT INTO streetname VALUES('veckman');
1276: INSERT INTO streetname VALUES('victoria');
1277: INSERT INTO streetname VALUES('victory');
1278: INSERT INTO streetname VALUES('village glen');
1279: INSERT INTO streetname VALUES('vireo');
1280: INSERT INTO streetname VALUES('viscount');
1281: INSERT INTO streetname VALUES('voeltz');
1282: INSERT INTO streetname VALUES('wade e morgan');
1283: INSERT INTO streetname VALUES('wake');
1284: INSERT INTO streetname VALUES('wales');
1285: INSERT INTO streetname VALUES('wallace ridge');
1286: INSERT INTO streetname VALUES('waltham');
1287: INSERT INTO streetname VALUES('wanamassa');
1288: INSERT INTO streetname VALUES('warbler wood');
1289: INSERT INTO streetname VALUES('washington');
1290: INSERT INTO streetname VALUES('water');
1291: INSERT INTO streetname VALUES('waterelm');
1292: INSERT INTO streetname VALUES('waterford hills');
1293: INSERT INTO streetname VALUES('waterford valley');
1294: INSERT INTO streetname VALUES('waterloo');
1295: INSERT INTO streetname VALUES('waterton leas');
1296: INSERT INTO streetname VALUES('waverly lynn');
1297: INSERT INTO streetname VALUES('waverlyglen');
1298: INSERT INTO streetname VALUES('wayside');
1299: INSERT INTO streetname VALUES('westbury lake');
1300: INSERT INTO streetname VALUES('westray');
1301: INSERT INTO streetname VALUES('whistlers chase');
1302: INSERT INTO streetname VALUES('whistley green');
1303: INSERT INTO streetname VALUES('whistling oak');
1304: INSERT INTO streetname VALUES('whitcomb');
1305: INSERT INTO streetname VALUES('white aspen');
1306: INSERT INTO streetname VALUES('white cascade');
1307: INSERT INTO streetname VALUES('white mist');
1308: INSERT INTO streetname VALUES('white rock');
1309: INSERT INTO streetname VALUES('white stag');
1310: INSERT INTO streetname VALUES('whitegate');
1311: INSERT INTO streetname VALUES('whitehill');
1312: INSERT INTO streetname VALUES('whitetail');
1313: INSERT INTO streetname VALUES('whitewood');
1314: INSERT INTO streetname VALUES('wilburn park');
1315: INSERT INTO streetname VALUES('wild garden');
1316: INSERT INTO streetname VALUES('wild rose');
1317: INSERT INTO streetname VALUES('wilkins terrace');
1318: INSERT INTO streetname VALUES('william ficklen');
1319: INSERT INTO streetname VALUES('wiltshire ridge');
1320: INSERT INTO streetname VALUES('windchase');
1321: INSERT INTO streetname VALUES('winding jordan');
1322: INSERT INTO streetname VALUES('windy meadow');
1323: INSERT INTO streetname VALUES('winghaven');
1324: INSERT INTO streetname VALUES('wingmont');
1325: INSERT INTO streetname VALUES('winslow');
1326: INSERT INTO streetname VALUES('winter pine');
1327: INSERT INTO streetname VALUES('winter view');
1328: INSERT INTO streetname VALUES('wolf creek');
1329: INSERT INTO streetname VALUES('wondering oak');
1330: INSERT INTO streetname VALUES('woodard');
1331: INSERT INTO streetname VALUES('woodfire');
1332: INSERT INTO streetname VALUES('woodland commons');
1333: INSERT INTO streetname VALUES('woodland hills');
1334: INSERT INTO streetname VALUES('woodnotch');
1335: INSERT INTO streetname VALUES('woodstone');
1336: INSERT INTO streetname VALUES('worsley');
1337: INSERT INTO streetname VALUES('wren creek');
1338: INSERT INTO streetname VALUES('wrens nest');
1339: INSERT INTO streetname VALUES('wrexham');
1340: INSERT INTO streetname VALUES('wt harris');
1341: INSERT INTO streetname VALUES('wylie meadow');
1342: INSERT INTO streetname VALUES('wynborough');
1343: INSERT INTO streetname VALUES('wynbrook');
1344: INSERT INTO streetname VALUES('wyndham hill');
1345: INSERT INTO streetname VALUES('yandem');
1346: INSERT INTO streetname VALUES('yellow rose');
1347: INSERT INTO streetname VALUES('yellow spaniel');
1348: INSERT INTO streetname VALUES('yorkford');
1349: INSERT INTO streetname VALUES('ziegler');
1350: INSERT INTO streetname VALUES('zion renaissance');
1351:
1352: SELECT count(*) FROM streetname;
1353: }
1354: } {1228}
1355:
1356: do_test fuzzer1-2.1 {
1357: execsql {
1358: SELECT n, distance FROM f2, streetname
1359: WHERE f2.word MATCH 'wersley'
1360: AND f2.distance<=150
1361: AND f2.word=streetname.n
1362: }
1363: } {worsley 37}
1364: do_test fuzzer1-2.2 {
1365: execsql {
1366: SELECT n, distance FROM f2, streetname
1367: WHERE f2.word MATCH 'testledown'
1368: AND f2.distance<=150
1369: AND f2.word=streetname.n
1370: }
1371: } {thistledown 103}
1372: do_test fuzzer1-2.3 {
1373: execsql {
1374: SELECT DISTINCT streetname.n FROM f2, streetname
1375: WHERE f2.word MATCH 'tayle'
1376: AND f2.distance<=200
1377: AND streetname.n>=f2.word AND streetname.n<=(f2.word || x'F7BFBFBF')
1378: }
1379: } {{tyler finley} trailer taymouth steelewood tallia tallu talwyn thelema}
1380:
1381:
1382: finish_test
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to fuzzer1.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test