• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
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
17set testdir [file dirname $argv0]
18source $testdir/tester.tcl
19
20ifcapable !vtab {
21  finish_test
22  return
23}
24
25register_fuzzer_module db
26do_test fuzzer1-1.0 {
27  catchsql {CREATE VIRTUAL TABLE fault1 USING fuzzer;}
28} {1 {fuzzer virtual tables must be TEMP}}
29do_test fuzzer1-1.1 {
30  db eval {CREATE VIRTUAL TABLE temp.f1 USING fuzzer;}
31} {}
32do_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
40do_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
46do_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
1356do_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}
1364do_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}
1372do_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} {steelewood tallia tallu talwyn taymouth thelema trailer {tyler finley}}
1380
1381
1382finish_test
1383