Index: third_party/sqlite/src/test/fuzzer1.test |
diff --git a/third_party/sqlite/src/test/fuzzer1.test b/third_party/sqlite/src/test/fuzzer1.test |
new file mode 100644 |
index 0000000000000000000000000000000000000000..d0575d2d00cdb27bfeb39d70963bbb66eec41625 |
--- /dev/null |
+++ b/third_party/sqlite/src/test/fuzzer1.test |
@@ -0,0 +1,1382 @@ |
+# 2011 March 25 |
+# |
+# The author disclaims copyright to this source code. In place of |
+# a legal notice, here is a blessing: |
+# |
+# May you do good and not evil. |
+# May you find forgiveness for yourself and forgive others. |
+# May you share freely, never taking more than you give. |
+# |
+#*********************************************************************** |
+# This file implements regression tests for TCL interface to the |
+# SQLite library. |
+# |
+# The focus of the tests is the word-fuzzer virtual table. |
+# |
+ |
+set testdir [file dirname $argv0] |
+source $testdir/tester.tcl |
+ |
+ifcapable !vtab { |
+ finish_test |
+ return |
+} |
+ |
+register_fuzzer_module db |
+do_test fuzzer1-1.0 { |
+ catchsql {CREATE VIRTUAL TABLE fault1 USING fuzzer;} |
+} {1 {fuzzer virtual tables must be TEMP}} |
+do_test fuzzer1-1.1 { |
+ db eval {CREATE VIRTUAL TABLE temp.f1 USING fuzzer;} |
+} {} |
+do_test fuzzer1-1.2 { |
+ db eval { |
+ INSERT INTO f1(cfrom, cto, cost) VALUES('e','a',1); |
+ INSERT INTO f1(cfrom, cto, cost) VALUES('a','e',10); |
+ INSERT INTO f1(cfrom, cto, cost) VALUES('e','o',100); |
+ } |
+} {} |
+ |
+do_test fuzzer1-1.3 { |
+ db eval { |
+ SELECT word, distance FROM f1 WHERE word MATCH 'abcde' |
+ } |
+} {abcde 0 abcda 1 ebcde 10 ebcda 11 abcdo 100 ebcdo 110 obcde 110 obcda 111 obcdo 210} |
+ |
+do_test fuzzer1-2.0 { |
+ execsql { |
+ CREATE VIRTUAL TABLE temp.f2 USING fuzzer; |
+ -- costs based on English letter frequencies |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('a','e',24); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('a','o',47); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('a','u',50); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('e','a',23); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('e','i',33); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('e','o',37); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('i','e',33); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('i','y',33); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('o','a',41); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('o','e',46); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('o','u',57); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('u','o',58); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('y','i',33); |
+ |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('t','th',70); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('th','t',66); |
+ |
+ |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('a','',84); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','b',106); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('b','',106); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','c',94); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('c','',94); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','d',89); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('d','',89); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','e',83); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('e','',83); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','f',97); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('f','',97); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','g',99); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('g','',99); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','h',86); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('h','',86); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','i',85); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('i','',85); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','j',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('j','',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','k',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('k','',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','l',89); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('l','',89); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','m',96); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('m','',96); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','n',85); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('n','',85); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','o',85); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('o','',85); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','p',100); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('p','',100); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','q',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('q','',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','r',86); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('r','',86); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','s',86); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('s','',86); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','t',84); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('t','',84); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','u',94); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('u','',94); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','v',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('v','',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','w',96); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('w','',96); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','x',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('x','',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','y',100); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('y','',100); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('','z',120); |
+ INSERT INTO f2(cFrom,cTo,cost) VALUES('z','',120); |
+ |
+ -- Street names for the 28269 ZIPCODE. |
+ -- |
+ CREATE TEMP TABLE streetname(n TEXT UNIQUE); |
+ INSERT INTO streetname VALUES('abbotsinch'); |
+ INSERT INTO streetname VALUES('abbottsgate'); |
+ INSERT INTO streetname VALUES('abbywood'); |
+ INSERT INTO streetname VALUES('abner'); |
+ INSERT INTO streetname VALUES('acacia ridge'); |
+ INSERT INTO streetname VALUES('acorn creek'); |
+ INSERT INTO streetname VALUES('acorn forest'); |
+ INSERT INTO streetname VALUES('adel'); |
+ INSERT INTO streetname VALUES('ainslie'); |
+ INSERT INTO streetname VALUES('airways'); |
+ INSERT INTO streetname VALUES('alabaster'); |
+ INSERT INTO streetname VALUES('alba'); |
+ INSERT INTO streetname VALUES('albertine'); |
+ INSERT INTO streetname VALUES('alden glen'); |
+ INSERT INTO streetname VALUES('alderson'); |
+ INSERT INTO streetname VALUES('allen'); |
+ INSERT INTO streetname VALUES('allen a brown'); |
+ INSERT INTO streetname VALUES('allness glen'); |
+ INSERT INTO streetname VALUES('aloysia'); |
+ INSERT INTO streetname VALUES('alpine'); |
+ INSERT INTO streetname VALUES('alwyn'); |
+ INSERT INTO streetname VALUES('amaranthus'); |
+ INSERT INTO streetname VALUES('amber glen'); |
+ INSERT INTO streetname VALUES('amber leigh way'); |
+ INSERT INTO streetname VALUES('amber meadows'); |
+ INSERT INTO streetname VALUES('amberway'); |
+ INSERT INTO streetname VALUES('ame'); |
+ INSERT INTO streetname VALUES('amesbury hill'); |
+ INSERT INTO streetname VALUES('anderson'); |
+ INSERT INTO streetname VALUES('andrew thomas'); |
+ INSERT INTO streetname VALUES('anduin falls'); |
+ INSERT INTO streetname VALUES('ankeny'); |
+ INSERT INTO streetname VALUES('annandale'); |
+ INSERT INTO streetname VALUES('annbick'); |
+ INSERT INTO streetname VALUES('antelope'); |
+ INSERT INTO streetname VALUES('anzack'); |
+ INSERT INTO streetname VALUES('apple glen'); |
+ INSERT INTO streetname VALUES('applevalley'); |
+ INSERT INTO streetname VALUES('appley mead'); |
+ INSERT INTO streetname VALUES('aragorn'); |
+ INSERT INTO streetname VALUES('arbor creek'); |
+ INSERT INTO streetname VALUES('arbor day'); |
+ INSERT INTO streetname VALUES('arbor meadows'); |
+ INSERT INTO streetname VALUES('arbor spring'); |
+ INSERT INTO streetname VALUES('arborview'); |
+ INSERT INTO streetname VALUES('arklow'); |
+ INSERT INTO streetname VALUES('armitage'); |
+ INSERT INTO streetname VALUES('arvin'); |
+ INSERT INTO streetname VALUES('ash cove'); |
+ INSERT INTO streetname VALUES('ashford leigh'); |
+ INSERT INTO streetname VALUES('ashmont'); |
+ INSERT INTO streetname VALUES('atlas'); |
+ INSERT INTO streetname VALUES('atwater'); |
+ INSERT INTO streetname VALUES('auburn hill'); |
+ INSERT INTO streetname VALUES('aulton link'); |
+ INSERT INTO streetname VALUES('austin dekota'); |
+ INSERT INTO streetname VALUES('austin knoll'); |
+ INSERT INTO streetname VALUES('auten'); |
+ INSERT INTO streetname VALUES('autumn harvest'); |
+ INSERT INTO streetname VALUES('autumn oak'); |
+ INSERT INTO streetname VALUES('autumn ridge'); |
+ INSERT INTO streetname VALUES('avalon forest'); |
+ INSERT INTO streetname VALUES('avalon loop'); |
+ INSERT INTO streetname VALUES('avon farm'); |
+ INSERT INTO streetname VALUES('avonhurst'); |
+ INSERT INTO streetname VALUES('avonlea'); |
+ INSERT INTO streetname VALUES('aynrand'); |
+ INSERT INTO streetname VALUES('azure valley'); |
+ INSERT INTO streetname VALUES('baberton'); |
+ INSERT INTO streetname VALUES('baffin'); |
+ INSERT INTO streetname VALUES('baggins'); |
+ INSERT INTO streetname VALUES('balata'); |
+ INSERT INTO streetname VALUES('ballantray'); |
+ INSERT INTO streetname VALUES('ballston'); |
+ INSERT INTO streetname VALUES('balsam tree'); |
+ INSERT INTO streetname VALUES('bambi'); |
+ INSERT INTO streetname VALUES('banwell'); |
+ INSERT INTO streetname VALUES('barbee'); |
+ INSERT INTO streetname VALUES('barefoot forest'); |
+ INSERT INTO streetname VALUES('barnview'); |
+ INSERT INTO streetname VALUES('baroda'); |
+ INSERT INTO streetname VALUES('barson'); |
+ INSERT INTO streetname VALUES('baskerville'); |
+ INSERT INTO streetname VALUES('battle creek'); |
+ INSERT INTO streetname VALUES('baucom'); |
+ INSERT INTO streetname VALUES('bay pines'); |
+ INSERT INTO streetname VALUES('beaker'); |
+ INSERT INTO streetname VALUES('beard'); |
+ INSERT INTO streetname VALUES('beardsley'); |
+ INSERT INTO streetname VALUES('bearoak'); |
+ INSERT INTO streetname VALUES('beauvista'); |
+ INSERT INTO streetname VALUES('beaver creek'); |
+ INSERT INTO streetname VALUES('beaver hollow'); |
+ INSERT INTO streetname VALUES('bedlington'); |
+ INSERT INTO streetname VALUES('beech cove'); |
+ INSERT INTO streetname VALUES('beech crest'); |
+ INSERT INTO streetname VALUES('beith'); |
+ INSERT INTO streetname VALUES('bell glen'); |
+ INSERT INTO streetname VALUES('bellmore'); |
+ INSERT INTO streetname VALUES('bells mill'); |
+ INSERT INTO streetname VALUES('bellville'); |
+ INSERT INTO streetname VALUES('belmar place'); |
+ INSERT INTO streetname VALUES('bembridge'); |
+ INSERT INTO streetname VALUES('bennett neely'); |
+ INSERT INTO streetname VALUES('bentgrass run'); |
+ INSERT INTO streetname VALUES('benthaven'); |
+ INSERT INTO streetname VALUES('bernardy'); |
+ INSERT INTO streetname VALUES('bernbrook shadow'); |
+ INSERT INTO streetname VALUES('berrybrook'); |
+ INSERT INTO streetname VALUES('berrybush'); |
+ INSERT INTO streetname VALUES('berwick'); |
+ INSERT INTO streetname VALUES('betterton'); |
+ INSERT INTO streetname VALUES('bickham'); |
+ INSERT INTO streetname VALUES('billingham'); |
+ INSERT INTO streetname VALUES('birchcroft'); |
+ INSERT INTO streetname VALUES('birchstone'); |
+ INSERT INTO streetname VALUES('birdwell'); |
+ INSERT INTO streetname VALUES('bisaner'); |
+ INSERT INTO streetname VALUES('bitterbush'); |
+ INSERT INTO streetname VALUES('bitterroot'); |
+ INSERT INTO streetname VALUES('black fox'); |
+ INSERT INTO streetname VALUES('black maple'); |
+ INSERT INTO streetname VALUES('black trail'); |
+ INSERT INTO streetname VALUES('blackbird'); |
+ INSERT INTO streetname VALUES('blake a dare'); |
+ INSERT INTO streetname VALUES('blasdell'); |
+ INSERT INTO streetname VALUES('blue aster'); |
+ INSERT INTO streetname VALUES('blue finch'); |
+ INSERT INTO streetname VALUES('blue lilac'); |
+ INSERT INTO streetname VALUES('blue sky'); |
+ INSERT INTO streetname VALUES('blue tick'); |
+ INSERT INTO streetname VALUES('bob beatty'); |
+ INSERT INTO streetname VALUES('bobcat'); |
+ INSERT INTO streetname VALUES('bolton'); |
+ INSERT INTO streetname VALUES('boomerang'); |
+ INSERT INTO streetname VALUES('boulder'); |
+ INSERT INTO streetname VALUES('boxer'); |
+ INSERT INTO streetname VALUES('boxmeer'); |
+ INSERT INTO streetname VALUES('brachnell view'); |
+ INSERT INTO streetname VALUES('bradford lake'); |
+ INSERT INTO streetname VALUES('bradwell'); |
+ INSERT INTO streetname VALUES('brady'); |
+ INSERT INTO streetname VALUES('braids bend'); |
+ INSERT INTO streetname VALUES('bralers'); |
+ INSERT INTO streetname VALUES('brandie glen'); |
+ INSERT INTO streetname VALUES('brandy ridge'); |
+ INSERT INTO streetname VALUES('brandybuck'); |
+ INSERT INTO streetname VALUES('branthurst'); |
+ INSERT INTO streetname VALUES('brassy creek'); |
+ INSERT INTO streetname VALUES('brathay'); |
+ INSERT INTO streetname VALUES('brawer farm'); |
+ INSERT INTO streetname VALUES('breezy morn'); |
+ INSERT INTO streetname VALUES('brenda'); |
+ INSERT INTO streetname VALUES('brenly'); |
+ INSERT INTO streetname VALUES('brenock'); |
+ INSERT INTO streetname VALUES('brianwood'); |
+ INSERT INTO streetname VALUES('briar rose'); |
+ INSERT INTO streetname VALUES('briarcrest'); |
+ INSERT INTO streetname VALUES('briarthorne'); |
+ INSERT INTO streetname VALUES('brick dust'); |
+ INSERT INTO streetname VALUES('bridgepath'); |
+ INSERT INTO streetname VALUES('bridle ridge'); |
+ INSERT INTO streetname VALUES('briggs'); |
+ INSERT INTO streetname VALUES('brightleaf'); |
+ INSERT INTO streetname VALUES('brigstock'); |
+ INSERT INTO streetname VALUES('broad ridge'); |
+ INSERT INTO streetname VALUES('brock'); |
+ INSERT INTO streetname VALUES('brockhampton'); |
+ INSERT INTO streetname VALUES('broken pine'); |
+ INSERT INTO streetname VALUES('brompton'); |
+ INSERT INTO streetname VALUES('brook falls'); |
+ INSERT INTO streetname VALUES('brookings'); |
+ INSERT INTO streetname VALUES('browne'); |
+ INSERT INTO streetname VALUES('brownes creek'); |
+ INSERT INTO streetname VALUES('brownes ferry'); |
+ INSERT INTO streetname VALUES('brownestone view'); |
+ INSERT INTO streetname VALUES('brumit'); |
+ INSERT INTO streetname VALUES('bryn athyn'); |
+ INSERT INTO streetname VALUES('buck'); |
+ INSERT INTO streetname VALUES('bucklebury'); |
+ INSERT INTO streetname VALUES('buckminister'); |
+ INSERT INTO streetname VALUES('buckspring'); |
+ INSERT INTO streetname VALUES('burch'); |
+ INSERT INTO streetname VALUES('burch shire'); |
+ INSERT INTO streetname VALUES('burkston'); |
+ INSERT INTO streetname VALUES('burmith'); |
+ INSERT INTO streetname VALUES('burnaby'); |
+ INSERT INTO streetname VALUES('butterfly'); |
+ INSERT INTO streetname VALUES('cabin creek'); |
+ INSERT INTO streetname VALUES('cairns mill'); |
+ INSERT INTO streetname VALUES('callender'); |
+ INSERT INTO streetname VALUES('cambellton'); |
+ INSERT INTO streetname VALUES('cambridge bay'); |
+ INSERT INTO streetname VALUES('canary'); |
+ INSERT INTO streetname VALUES('canbury'); |
+ INSERT INTO streetname VALUES('candle leaf'); |
+ INSERT INTO streetname VALUES('canipe'); |
+ INSERT INTO streetname VALUES('canipe farm'); |
+ INSERT INTO streetname VALUES('cannon'); |
+ INSERT INTO streetname VALUES('canopy'); |
+ INSERT INTO streetname VALUES('canso'); |
+ INSERT INTO streetname VALUES('canterbrook'); |
+ INSERT INTO streetname VALUES('cardinal glen'); |
+ INSERT INTO streetname VALUES('cardinal point'); |
+ INSERT INTO streetname VALUES('cardinals nest'); |
+ INSERT INTO streetname VALUES('carlota'); |
+ INSERT INTO streetname VALUES('carmathen'); |
+ INSERT INTO streetname VALUES('carver'); |
+ INSERT INTO streetname VALUES('carver pond'); |
+ INSERT INTO streetname VALUES('casa loma'); |
+ INSERT INTO streetname VALUES('caselton'); |
+ INSERT INTO streetname VALUES('castello'); |
+ INSERT INTO streetname VALUES('castle ridge'); |
+ INSERT INTO streetname VALUES('castleglen'); |
+ INSERT INTO streetname VALUES('castlemaine'); |
+ INSERT INTO streetname VALUES('cavett'); |
+ INSERT INTO streetname VALUES('caymus'); |
+ INSERT INTO streetname VALUES('cedardale ridge'); |
+ INSERT INTO streetname VALUES('cedarhurst'); |
+ INSERT INTO streetname VALUES('cemkey way'); |
+ INSERT INTO streetname VALUES('cerise'); |
+ INSERT INTO streetname VALUES('chaceview'); |
+ INSERT INTO streetname VALUES('chadsworth'); |
+ INSERT INTO streetname VALUES('chadwell'); |
+ INSERT INTO streetname VALUES('champions crest'); |
+ INSERT INTO streetname VALUES('chandler haven'); |
+ INSERT INTO streetname VALUES('chapel crossing'); |
+ INSERT INTO streetname VALUES('chapel ridge'); |
+ INSERT INTO streetname VALUES('charles crawford'); |
+ INSERT INTO streetname VALUES('charminster'); |
+ INSERT INTO streetname VALUES('chasewind'); |
+ INSERT INTO streetname VALUES('chavel'); |
+ INSERT INTO streetname VALUES('chelsea jade'); |
+ INSERT INTO streetname VALUES('chestnut knoll'); |
+ INSERT INTO streetname VALUES('cheviot'); |
+ INSERT INTO streetname VALUES('chickadee'); |
+ INSERT INTO streetname VALUES('chidley'); |
+ INSERT INTO streetname VALUES('chimney ridge'); |
+ INSERT INTO streetname VALUES('chimney springs'); |
+ INSERT INTO streetname VALUES('chinaberry'); |
+ INSERT INTO streetname VALUES('chinemist'); |
+ INSERT INTO streetname VALUES('chinquapin'); |
+ INSERT INTO streetname VALUES('chiswell'); |
+ INSERT INTO streetname VALUES('christenbury'); |
+ INSERT INTO streetname VALUES('christenbury hills'); |
+ INSERT INTO streetname VALUES('churchill'); |
+ INSERT INTO streetname VALUES('cindy'); |
+ INSERT INTO streetname VALUES('cinnamon teal'); |
+ INSERT INTO streetname VALUES('citadel'); |
+ INSERT INTO streetname VALUES('clare olivia'); |
+ INSERT INTO streetname VALUES('clarke creek'); |
+ INSERT INTO streetname VALUES('clarke ridge'); |
+ INSERT INTO streetname VALUES('clear day'); |
+ INSERT INTO streetname VALUES('clear stream'); |
+ INSERT INTO streetname VALUES('cleve brown'); |
+ INSERT INTO streetname VALUES('cliff cameron'); |
+ INSERT INTO streetname VALUES('cliffvale'); |
+ INSERT INTO streetname VALUES('cloverside'); |
+ INSERT INTO streetname VALUES('clymer'); |
+ INSERT INTO streetname VALUES('coatbridge'); |
+ INSERT INTO streetname VALUES('cobble glen'); |
+ INSERT INTO streetname VALUES('cochran farm'); |
+ INSERT INTO streetname VALUES('cochrane'); |
+ INSERT INTO streetname VALUES('coleridge'); |
+ INSERT INTO streetname VALUES('coleshire'); |
+ INSERT INTO streetname VALUES('collins'); |
+ INSERT INTO streetname VALUES('colvard'); |
+ INSERT INTO streetname VALUES('colvard park'); |
+ INSERT INTO streetname VALUES('condor'); |
+ INSERT INTO streetname VALUES('conner ridge'); |
+ INSERT INTO streetname VALUES('connery'); |
+ INSERT INTO streetname VALUES('cooper run'); |
+ INSERT INTO streetname VALUES('coopers ridge'); |
+ INSERT INTO streetname VALUES('copper hill'); |
+ INSERT INTO streetname VALUES('coppermine'); |
+ INSERT INTO streetname VALUES('cornelia'); |
+ INSERT INTO streetname VALUES('corner'); |
+ INSERT INTO streetname VALUES('cornerstone'); |
+ INSERT INTO streetname VALUES('cottage oaks'); |
+ INSERT INTO streetname VALUES('cougar'); |
+ INSERT INTO streetname VALUES('coves end'); |
+ INSERT INTO streetname VALUES('cragland'); |
+ INSERT INTO streetname VALUES('crail'); |
+ INSERT INTO streetname VALUES('cranberry nook'); |
+ INSERT INTO streetname VALUES('crawford brook'); |
+ INSERT INTO streetname VALUES('crayton'); |
+ INSERT INTO streetname VALUES('creek breeze'); |
+ INSERT INTO streetname VALUES('crescent ridge'); |
+ INSERT INTO streetname VALUES('crescent view'); |
+ INSERT INTO streetname VALUES('cresta'); |
+ INSERT INTO streetname VALUES('crestfield'); |
+ INSERT INTO streetname VALUES('crestland'); |
+ INSERT INTO streetname VALUES('crestwick'); |
+ INSERT INTO streetname VALUES('crisfield'); |
+ INSERT INTO streetname VALUES('crisp wood'); |
+ INSERT INTO streetname VALUES('croft haven'); |
+ INSERT INTO streetname VALUES('crofton springs'); |
+ INSERT INTO streetname VALUES('cross'); |
+ INSERT INTO streetname VALUES('crosspoint center'); |
+ INSERT INTO streetname VALUES('crownvista'); |
+ INSERT INTO streetname VALUES('crystal arms'); |
+ INSERT INTO streetname VALUES('crystal crest'); |
+ INSERT INTO streetname VALUES('crystal leaf'); |
+ INSERT INTO streetname VALUES('cunningham park'); |
+ INSERT INTO streetname VALUES('cypress pond'); |
+ INSERT INTO streetname VALUES('daffodil'); |
+ INSERT INTO streetname VALUES('daisyfield'); |
+ INSERT INTO streetname VALUES('dalecrest'); |
+ INSERT INTO streetname VALUES('dannelly park'); |
+ INSERT INTO streetname VALUES('daphne'); |
+ INSERT INTO streetname VALUES('daria'); |
+ INSERT INTO streetname VALUES('dartmouth'); |
+ INSERT INTO streetname VALUES('datha'); |
+ INSERT INTO streetname VALUES('david cox'); |
+ INSERT INTO streetname VALUES('davis'); |
+ INSERT INTO streetname VALUES('davis crossing'); |
+ INSERT INTO streetname VALUES('davis lake'); |
+ INSERT INTO streetname VALUES('davis ridge'); |
+ INSERT INTO streetname VALUES('dawnmist'); |
+ INSERT INTO streetname VALUES('daybreak'); |
+ INSERT INTO streetname VALUES('dearmon'); |
+ INSERT INTO streetname VALUES('dearview'); |
+ INSERT INTO streetname VALUES('deaton hill'); |
+ INSERT INTO streetname VALUES('deer cross'); |
+ INSERT INTO streetname VALUES('deerton'); |
+ INSERT INTO streetname VALUES('degrasse'); |
+ INSERT INTO streetname VALUES('delamere'); |
+ INSERT INTO streetname VALUES('dellfield'); |
+ INSERT INTO streetname VALUES('dellinger'); |
+ INSERT INTO streetname VALUES('demington'); |
+ INSERT INTO streetname VALUES('denmeade'); |
+ INSERT INTO streetname VALUES('derita'); |
+ INSERT INTO streetname VALUES('derita woods'); |
+ INSERT INTO streetname VALUES('deruyter'); |
+ INSERT INTO streetname VALUES('dervish'); |
+ INSERT INTO streetname VALUES('devas'); |
+ INSERT INTO streetname VALUES('devon croft'); |
+ INSERT INTO streetname VALUES('devonbridge'); |
+ INSERT INTO streetname VALUES('devongate'); |
+ INSERT INTO streetname VALUES('devonhill'); |
+ INSERT INTO streetname VALUES('dewmorn'); |
+ INSERT INTO streetname VALUES('distribution center'); |
+ INSERT INTO streetname VALUES('dominion crest'); |
+ INSERT INTO streetname VALUES('dominion green'); |
+ INSERT INTO streetname VALUES('dominion village'); |
+ INSERT INTO streetname VALUES('dorshire'); |
+ INSERT INTO streetname VALUES('double creek crossing'); |
+ INSERT INTO streetname VALUES('dow'); |
+ INSERT INTO streetname VALUES('downfield wood'); |
+ INSERT INTO streetname VALUES('downing creek'); |
+ INSERT INTO streetname VALUES('driscol'); |
+ INSERT INTO streetname VALUES('driwood'); |
+ INSERT INTO streetname VALUES('dry brook'); |
+ INSERT INTO streetname VALUES('dumont'); |
+ INSERT INTO streetname VALUES('dunblane'); |
+ INSERT INTO streetname VALUES('dunfield'); |
+ INSERT INTO streetname VALUES('dunoon'); |
+ INSERT INTO streetname VALUES('dunslow'); |
+ INSERT INTO streetname VALUES('dunstaff'); |
+ INSERT INTO streetname VALUES('durham'); |
+ INSERT INTO streetname VALUES('durston'); |
+ INSERT INTO streetname VALUES('dusty cedar'); |
+ INSERT INTO streetname VALUES('dusty trail'); |
+ INSERT INTO streetname VALUES('dutchess'); |
+ INSERT INTO streetname VALUES('duxford'); |
+ INSERT INTO streetname VALUES('eagle creek'); |
+ INSERT INTO streetname VALUES('eagles field'); |
+ INSERT INTO streetname VALUES('eargle'); |
+ INSERT INTO streetname VALUES('earlswood'); |
+ INSERT INTO streetname VALUES('early mist'); |
+ INSERT INTO streetname VALUES('earthenware'); |
+ INSERT INTO streetname VALUES('eastfield park'); |
+ INSERT INTO streetname VALUES('eastfield village'); |
+ INSERT INTO streetname VALUES('easy'); |
+ INSERT INTO streetname VALUES('eben'); |
+ INSERT INTO streetname VALUES('edgepine'); |
+ INSERT INTO streetname VALUES('edgewier'); |
+ INSERT INTO streetname VALUES('edinburgh'); |
+ INSERT INTO streetname VALUES('edinmeadow'); |
+ INSERT INTO streetname VALUES('edmonton'); |
+ INSERT INTO streetname VALUES('edwin jones'); |
+ INSERT INTO streetname VALUES('elberon'); |
+ INSERT INTO streetname VALUES('elderslie'); |
+ INSERT INTO streetname VALUES('elementary view'); |
+ INSERT INTO streetname VALUES('elendil'); |
+ INSERT INTO streetname VALUES('elizabeth'); |
+ INSERT INTO streetname VALUES('elm cove'); |
+ INSERT INTO streetname VALUES('elrond'); |
+ INSERT INTO streetname VALUES('elsenham'); |
+ INSERT INTO streetname VALUES('elven'); |
+ INSERT INTO streetname VALUES('emma lynn'); |
+ INSERT INTO streetname VALUES('english setter'); |
+ INSERT INTO streetname VALUES('enoch'); |
+ INSERT INTO streetname VALUES('equipment'); |
+ INSERT INTO streetname VALUES('ernest russell'); |
+ INSERT INTO streetname VALUES('ernie'); |
+ INSERT INTO streetname VALUES('esmeralda'); |
+ INSERT INTO streetname VALUES('evergreen hollow'); |
+ INSERT INTO streetname VALUES('eversfield'); |
+ INSERT INTO streetname VALUES('ewen'); |
+ INSERT INTO streetname VALUES('ewert cut'); |
+ INSERT INTO streetname VALUES('exbury'); |
+ INSERT INTO streetname VALUES('fair grounds park'); |
+ INSERT INTO streetname VALUES('fairbourne'); |
+ INSERT INTO streetname VALUES('fairchase'); |
+ INSERT INTO streetname VALUES('faircreek'); |
+ INSERT INTO streetname VALUES('fairglen'); |
+ INSERT INTO streetname VALUES('fairlea'); |
+ INSERT INTO streetname VALUES('fairmead'); |
+ INSERT INTO streetname VALUES('fairmeadows'); |
+ INSERT INTO streetname VALUES('fairstone'); |
+ INSERT INTO streetname VALUES('fairvista'); |
+ INSERT INTO streetname VALUES('fairway point'); |
+ INSERT INTO streetname VALUES('falconcrest'); |
+ INSERT INTO streetname VALUES('falls ridge'); |
+ INSERT INTO streetname VALUES('falmouth'); |
+ INSERT INTO streetname VALUES('far west'); |
+ INSERT INTO streetname VALUES('farlow'); |
+ INSERT INTO streetname VALUES('farris wheel'); |
+ INSERT INTO streetname VALUES('fawndale'); |
+ INSERT INTO streetname VALUES('feather bend'); |
+ INSERT INTO streetname VALUES('fernledge'); |
+ INSERT INTO streetname VALUES('fernmoss'); |
+ INSERT INTO streetname VALUES('ferrell commons'); |
+ INSERT INTO streetname VALUES('fieldstone'); |
+ INSERT INTO streetname VALUES('fillian'); |
+ INSERT INTO streetname VALUES('fincher'); |
+ INSERT INTO streetname VALUES('foggy meadow'); |
+ INSERT INTO streetname VALUES('fordyce'); |
+ INSERT INTO streetname VALUES('forest grove'); |
+ INSERT INTO streetname VALUES('forest path'); |
+ INSERT INTO streetname VALUES('forestridge commons'); |
+ INSERT INTO streetname VALUES('forestrock'); |
+ INSERT INTO streetname VALUES('fortunes ridge'); |
+ INSERT INTO streetname VALUES('founders club'); |
+ INSERT INTO streetname VALUES('fountaingrass'); |
+ INSERT INTO streetname VALUES('fox chase'); |
+ INSERT INTO streetname VALUES('fox glen'); |
+ INSERT INTO streetname VALUES('fox hill'); |
+ INSERT INTO streetname VALUES('fox point'); |
+ INSERT INTO streetname VALUES('fox trot'); |
+ INSERT INTO streetname VALUES('foxbriar'); |
+ INSERT INTO streetname VALUES('frank little'); |
+ INSERT INTO streetname VALUES('franzia'); |
+ INSERT INTO streetname VALUES('french woods'); |
+ INSERT INTO streetname VALUES('frostmoor'); |
+ INSERT INTO streetname VALUES('frye'); |
+ INSERT INTO streetname VALUES('furlong'); |
+ INSERT INTO streetname VALUES('galena view'); |
+ INSERT INTO streetname VALUES('gallery pointe'); |
+ INSERT INTO streetname VALUES('gammon'); |
+ INSERT INTO streetname VALUES('garden grove'); |
+ INSERT INTO streetname VALUES('gardendale'); |
+ INSERT INTO streetname VALUES('garganey'); |
+ INSERT INTO streetname VALUES('garnet field'); |
+ INSERT INTO streetname VALUES('garrison'); |
+ INSERT INTO streetname VALUES('garvin'); |
+ INSERT INTO streetname VALUES('garvis'); |
+ INSERT INTO streetname VALUES('gaskill'); |
+ INSERT INTO streetname VALUES('gemstone'); |
+ INSERT INTO streetname VALUES('gibbon'); |
+ INSERT INTO streetname VALUES('gibbon terrace'); |
+ INSERT INTO streetname VALUES('gibbons link'); |
+ INSERT INTO streetname VALUES('gillman'); |
+ INSERT INTO streetname VALUES('gladwood'); |
+ INSERT INTO streetname VALUES('gladwyne'); |
+ INSERT INTO streetname VALUES('glamorgan'); |
+ INSERT INTO streetname VALUES('glaze'); |
+ INSERT INTO streetname VALUES('glen brook'); |
+ INSERT INTO streetname VALUES('glen cove'); |
+ INSERT INTO streetname VALUES('glen hope'); |
+ INSERT INTO streetname VALUES('glen manor'); |
+ INSERT INTO streetname VALUES('glen olden'); |
+ INSERT INTO streetname VALUES('glencairn'); |
+ INSERT INTO streetname VALUES('glendock'); |
+ INSERT INTO streetname VALUES('glenolden'); |
+ INSERT INTO streetname VALUES('glenover'); |
+ INSERT INTO streetname VALUES('glenshire'); |
+ INSERT INTO streetname VALUES('glenstone'); |
+ INSERT INTO streetname VALUES('gold dust'); |
+ INSERT INTO streetname VALUES('golden pond'); |
+ INSERT INTO streetname VALUES('goldenblush'); |
+ INSERT INTO streetname VALUES('goldenfield'); |
+ INSERT INTO streetname VALUES('goose landing'); |
+ INSERT INTO streetname VALUES('gorham gate'); |
+ INSERT INTO streetname VALUES('grabill'); |
+ INSERT INTO streetname VALUES('graburns ford'); |
+ INSERT INTO streetname VALUES('graham'); |
+ INSERT INTO streetname VALUES('grahamson'); |
+ INSERT INTO streetname VALUES('granard'); |
+ INSERT INTO streetname VALUES('grand teton'); |
+ INSERT INTO streetname VALUES('grande heights'); |
+ INSERT INTO streetname VALUES('grandeur'); |
+ INSERT INTO streetname VALUES('granite creek'); |
+ INSERT INTO streetname VALUES('grasset'); |
+ INSERT INTO streetname VALUES('graypark'); |
+ INSERT INTO streetname VALUES('grays ridge'); |
+ INSERT INTO streetname VALUES('great bear'); |
+ INSERT INTO streetname VALUES('green clover'); |
+ INSERT INTO streetname VALUES('green hedge'); |
+ INSERT INTO streetname VALUES('green meadow'); |
+ INSERT INTO streetname VALUES('green pasture'); |
+ INSERT INTO streetname VALUES('greene'); |
+ INSERT INTO streetname VALUES('greenloch'); |
+ INSERT INTO streetname VALUES('greenock ridge'); |
+ INSERT INTO streetname VALUES('greenware'); |
+ INSERT INTO streetname VALUES('greenway village'); |
+ INSERT INTO streetname VALUES('grenelefe village'); |
+ INSERT INTO streetname VALUES('grey dogwood'); |
+ INSERT INTO streetname VALUES('greyhound'); |
+ INSERT INTO streetname VALUES('greylock ridge'); |
+ INSERT INTO streetname VALUES('grosbeak'); |
+ INSERT INTO streetname VALUES('grove'); |
+ INSERT INTO streetname VALUES('groveton'); |
+ INSERT INTO streetname VALUES('groveview'); |
+ INSERT INTO streetname VALUES('hackberry creek'); |
+ INSERT INTO streetname VALUES('hackberry grove'); |
+ INSERT INTO streetname VALUES('hackett'); |
+ INSERT INTO streetname VALUES('haddington'); |
+ INSERT INTO streetname VALUES('hagler'); |
+ INSERT INTO streetname VALUES('halcott'); |
+ INSERT INTO streetname VALUES('half dome'); |
+ INSERT INTO streetname VALUES('hallam'); |
+ INSERT INTO streetname VALUES('hamilton russell'); |
+ INSERT INTO streetname VALUES('hampton place'); |
+ INSERT INTO streetname VALUES('hankins'); |
+ INSERT INTO streetname VALUES('harburn forest'); |
+ INSERT INTO streetname VALUES('harringham'); |
+ INSERT INTO streetname VALUES('harrington woods'); |
+ INSERT INTO streetname VALUES('harris corners'); |
+ INSERT INTO streetname VALUES('harris cove'); |
+ INSERT INTO streetname VALUES('harris glen'); |
+ INSERT INTO streetname VALUES('harris hill'); |
+ INSERT INTO streetname VALUES('harris oak'); |
+ INSERT INTO streetname VALUES('harris pointe'); |
+ INSERT INTO streetname VALUES('harris pond'); |
+ INSERT INTO streetname VALUES('harris ridge'); |
+ INSERT INTO streetname VALUES('harris technology'); |
+ INSERT INTO streetname VALUES('harris woods'); |
+ INSERT INTO streetname VALUES('hartfield downs'); |
+ INSERT INTO streetname VALUES('hattie little'); |
+ INSERT INTO streetname VALUES('hatwynn'); |
+ INSERT INTO streetname VALUES('hawkins'); |
+ INSERT INTO streetname VALUES('hawksnest'); |
+ INSERT INTO streetname VALUES('haybridge'); |
+ INSERT INTO streetname VALUES('hayden'); |
+ INSERT INTO streetname VALUES('hazelcroft'); |
+ INSERT INTO streetname VALUES('hazlitt'); |
+ INSERT INTO streetname VALUES('hazy valley'); |
+ INSERT INTO streetname VALUES('hearst'); |
+ INSERT INTO streetname VALUES('heathcrest'); |
+ INSERT INTO streetname VALUES('heathcroft'); |
+ INSERT INTO streetname VALUES('hedge maple'); |
+ INSERT INTO streetname VALUES('hedgecrest'); |
+ INSERT INTO streetname VALUES('hedingham'); |
+ INSERT INTO streetname VALUES('heman'); |
+ INSERT INTO streetname VALUES('henderson'); |
+ INSERT INTO streetname VALUES('henderson oaks'); |
+ INSERT INTO streetname VALUES('henderson valley'); |
+ INSERT INTO streetname VALUES('hendry'); |
+ INSERT INTO streetname VALUES('heritage hills'); |
+ INSERT INTO streetname VALUES('heritage woods'); |
+ INSERT INTO streetname VALUES('heron cove'); |
+ INSERT INTO streetname VALUES('heron glen'); |
+ INSERT INTO streetname VALUES('hewitt'); |
+ INSERT INTO streetname VALUES('hey rock'); |
+ INSERT INTO streetname VALUES('heysham'); |
+ INSERT INTO streetname VALUES('hickory cove'); |
+ INSERT INTO streetname VALUES('hidden meadow'); |
+ INSERT INTO streetname VALUES('high glen'); |
+ INSERT INTO streetname VALUES('high laurel'); |
+ INSERT INTO streetname VALUES('high valley'); |
+ INSERT INTO streetname VALUES('highcroft'); |
+ INSERT INTO streetname VALUES('highland'); |
+ INSERT INTO streetname VALUES('highland commons'); |
+ INSERT INTO streetname VALUES('highland creek'); |
+ INSERT INTO streetname VALUES('highland glen'); |
+ INSERT INTO streetname VALUES('highland park'); |
+ INSERT INTO streetname VALUES('highlander'); |
+ INSERT INTO streetname VALUES('highstream'); |
+ INSERT INTO streetname VALUES('hilltop'); |
+ INSERT INTO streetname VALUES('hobbitshire'); |
+ INSERT INTO streetname VALUES('hoffman'); |
+ INSERT INTO streetname VALUES('hogans way'); |
+ INSERT INTO streetname VALUES('holbert'); |
+ INSERT INTO streetname VALUES('hollow ridge'); |
+ INSERT INTO streetname VALUES('holly vista'); |
+ INSERT INTO streetname VALUES('hollywood'); |
+ INSERT INTO streetname VALUES('hoover'); |
+ INSERT INTO streetname VALUES('hopkins'); |
+ INSERT INTO streetname VALUES('horace mann'); |
+ INSERT INTO streetname VALUES('hornbeam'); |
+ INSERT INTO streetname VALUES('horse pasture'); |
+ INSERT INTO streetname VALUES('hosta'); |
+ INSERT INTO streetname VALUES('howard'); |
+ INSERT INTO streetname VALUES('hubbard'); |
+ INSERT INTO streetname VALUES('hubbard falls'); |
+ INSERT INTO streetname VALUES('hubbard woods'); |
+ INSERT INTO streetname VALUES('hucks'); |
+ INSERT INTO streetname VALUES('hunters creek'); |
+ INSERT INTO streetname VALUES('hunters pointe'); |
+ INSERT INTO streetname VALUES('hunters spring'); |
+ INSERT INTO streetname VALUES('hunters whip'); |
+ INSERT INTO streetname VALUES('huntmeadow'); |
+ INSERT INTO streetname VALUES('hutchison mcdonald'); |
+ INSERT INTO streetname VALUES('ingleton'); |
+ INSERT INTO streetname VALUES('insdale'); |
+ INSERT INTO streetname VALUES('interstate 85 service'); |
+ INSERT INTO streetname VALUES('iola'); |
+ INSERT INTO streetname VALUES('iredell'); |
+ INSERT INTO streetname VALUES('iron brigade'); |
+ INSERT INTO streetname VALUES('irwin valley'); |
+ INSERT INTO streetname VALUES('irwin wood'); |
+ INSERT INTO streetname VALUES('ivy brook'); |
+ INSERT INTO streetname VALUES('ivy ridge'); |
+ INSERT INTO streetname VALUES('jack russell'); |
+ INSERT INTO streetname VALUES('jackson'); |
+ INSERT INTO streetname VALUES('jacob martin'); |
+ INSERT INTO streetname VALUES('jamison'); |
+ INSERT INTO streetname VALUES('jane'); |
+ INSERT INTO streetname VALUES('jaspar crest'); |
+ INSERT INTO streetname VALUES('jessica'); |
+ INSERT INTO streetname VALUES('jimmy oehler'); |
+ INSERT INTO streetname VALUES('jocelyn'); |
+ INSERT INTO streetname VALUES('johnston mill'); |
+ INSERT INTO streetname VALUES('johnston oehler'); |
+ INSERT INTO streetname VALUES('judal'); |
+ INSERT INTO streetname VALUES('junipeous'); |
+ INSERT INTO streetname VALUES('juniper'); |
+ INSERT INTO streetname VALUES('juniperus'); |
+ INSERT INTO streetname VALUES('kalispell'); |
+ INSERT INTO streetname VALUES('karylsturn'); |
+ INSERT INTO streetname VALUES('katelyn'); |
+ INSERT INTO streetname VALUES('kayron'); |
+ INSERT INTO streetname VALUES('keaton'); |
+ INSERT INTO streetname VALUES('keble'); |
+ INSERT INTO streetname VALUES('keels'); |
+ INSERT INTO streetname VALUES('keith'); |
+ INSERT INTO streetname VALUES('keithwood'); |
+ INSERT INTO streetname VALUES('kelden walker'); |
+ INSERT INTO streetname VALUES('kelsey emma'); |
+ INSERT INTO streetname VALUES('kendrick'); |
+ INSERT INTO streetname VALUES('kenmont'); |
+ INSERT INTO streetname VALUES('kennerly cove'); |
+ INSERT INTO streetname VALUES('kenninghall'); |
+ INSERT INTO streetname VALUES('kent village'); |
+ INSERT INTO streetname VALUES('kestral ridge'); |
+ INSERT INTO streetname VALUES('kestrel'); |
+ INSERT INTO streetname VALUES('kilmartin'); |
+ INSERT INTO streetname VALUES('kilty'); |
+ INSERT INTO streetname VALUES('kinglet'); |
+ INSERT INTO streetname VALUES('kingsland'); |
+ INSERT INTO streetname VALUES('kingsnorth'); |
+ INSERT INTO streetname VALUES('kinsmore'); |
+ INSERT INTO streetname VALUES('kirkgard'); |
+ INSERT INTO streetname VALUES('kirkmont'); |
+ INSERT INTO streetname VALUES('knightsgate'); |
+ INSERT INTO streetname VALUES('kobuk'); |
+ INSERT INTO streetname VALUES('kotlik'); |
+ INSERT INTO streetname VALUES('kotz'); |
+ INSERT INTO streetname VALUES('kyndall walk'); |
+ INSERT INTO streetname VALUES('laborde'); |
+ INSERT INTO streetname VALUES('lady bank'); |
+ INSERT INTO streetname VALUES('lagrande'); |
+ INSERT INTO streetname VALUES('lake'); |
+ INSERT INTO streetname VALUES('lakeridge commons'); |
+ INSERT INTO streetname VALUES('lakeview'); |
+ INSERT INTO streetname VALUES('lakewood edge'); |
+ INSERT INTO streetname VALUES('lakota'); |
+ INSERT INTO streetname VALUES('lambrook'); |
+ INSERT INTO streetname VALUES('lampkin'); |
+ INSERT INTO streetname VALUES('lampkin park'); |
+ INSERT INTO streetname VALUES('langham'); |
+ INSERT INTO streetname VALUES('lanzerac manor'); |
+ INSERT INTO streetname VALUES('larkmead forest'); |
+ INSERT INTO streetname VALUES('lattice'); |
+ INSERT INTO streetname VALUES('laurel crest'); |
+ INSERT INTO streetname VALUES('laurel ridge'); |
+ INSERT INTO streetname VALUES('laurel run'); |
+ INSERT INTO streetname VALUES('laurenfield'); |
+ INSERT INTO streetname VALUES('laveta'); |
+ INSERT INTO streetname VALUES('lazy day'); |
+ INSERT INTO streetname VALUES('leawood run'); |
+ INSERT INTO streetname VALUES('lee marie'); |
+ INSERT INTO streetname VALUES('legacy lake'); |
+ INSERT INTO streetname VALUES('legacy park'); |
+ INSERT INTO streetname VALUES('legato'); |
+ INSERT INTO streetname VALUES('legolas'); |
+ INSERT INTO streetname VALUES('leigh glen'); |
+ INSERT INTO streetname VALUES('lence'); |
+ INSERT INTO streetname VALUES('lenox hill'); |
+ INSERT INTO streetname VALUES('leonine'); |
+ INSERT INTO streetname VALUES('leslie'); |
+ INSERT INTO streetname VALUES('lester hill'); |
+ INSERT INTO streetname VALUES('levisey'); |
+ INSERT INTO streetname VALUES('liberty bell'); |
+ INSERT INTO streetname VALUES('linden berry'); |
+ INSERT INTO streetname VALUES('lisbon'); |
+ INSERT INTO streetname VALUES('little stoney'); |
+ INSERT INTO streetname VALUES('livengood'); |
+ INSERT INTO streetname VALUES('lochway'); |
+ INSERT INTO streetname VALUES('lockman'); |
+ INSERT INTO streetname VALUES('loganville'); |
+ INSERT INTO streetname VALUES('lone tree'); |
+ INSERT INTO streetname VALUES('long creek park'); |
+ INSERT INTO streetname VALUES('long forest'); |
+ INSERT INTO streetname VALUES('looking glass'); |
+ INSERT INTO streetname VALUES('lookout point'); |
+ INSERT INTO streetname VALUES('lowen'); |
+ INSERT INTO streetname VALUES('lusby'); |
+ INSERT INTO streetname VALUES('lyleton'); |
+ INSERT INTO streetname VALUES('lynn lee'); |
+ INSERT INTO streetname VALUES('lynnewood glen'); |
+ INSERT INTO streetname VALUES('machrie'); |
+ INSERT INTO streetname VALUES('mackinac'); |
+ INSERT INTO streetname VALUES('maddox'); |
+ INSERT INTO streetname VALUES('madison park'); |
+ INSERT INTO streetname VALUES('mallard'); |
+ INSERT INTO streetname VALUES('mallard cove'); |
+ INSERT INTO streetname VALUES('mallard forest'); |
+ INSERT INTO streetname VALUES('mallard grove'); |
+ INSERT INTO streetname VALUES('mallard hill'); |
+ INSERT INTO streetname VALUES('mallard park'); |
+ INSERT INTO streetname VALUES('mallard ridge'); |
+ INSERT INTO streetname VALUES('mallard view'); |
+ INSERT INTO streetname VALUES('manbey'); |
+ INSERT INTO streetname VALUES('manning'); |
+ INSERT INTO streetname VALUES('mantario'); |
+ INSERT INTO streetname VALUES('maple'); |
+ INSERT INTO streetname VALUES('maple cove'); |
+ INSERT INTO streetname VALUES('maple park'); |
+ INSERT INTO streetname VALUES('marathon hill'); |
+ INSERT INTO streetname VALUES('marbury'); |
+ INSERT INTO streetname VALUES('marett'); |
+ INSERT INTO streetname VALUES('marigold'); |
+ INSERT INTO streetname VALUES('marionwood'); |
+ INSERT INTO streetname VALUES('marshbank'); |
+ INSERT INTO streetname VALUES('mason'); |
+ INSERT INTO streetname VALUES('mayapple'); |
+ INSERT INTO streetname VALUES('maylandia'); |
+ INSERT INTO streetname VALUES('mayspring'); |
+ INSERT INTO streetname VALUES('mcadam'); |
+ INSERT INTO streetname VALUES('mcchesney'); |
+ INSERT INTO streetname VALUES('mccurdy'); |
+ INSERT INTO streetname VALUES('mcgrath'); |
+ INSERT INTO streetname VALUES('mckendree'); |
+ INSERT INTO streetname VALUES('mclaughlin'); |
+ INSERT INTO streetname VALUES('mctaggart'); |
+ INSERT INTO streetname VALUES('meadow green'); |
+ INSERT INTO streetname VALUES('meadow knoll'); |
+ INSERT INTO streetname VALUES('meadow post'); |
+ INSERT INTO streetname VALUES('meadowmont'); |
+ INSERT INTO streetname VALUES('meadowmont view'); |
+ INSERT INTO streetname VALUES('meadowview hills'); |
+ INSERT INTO streetname VALUES('melshire'); |
+ INSERT INTO streetname VALUES('melstrand'); |
+ INSERT INTO streetname VALUES('mentone'); |
+ INSERT INTO streetname VALUES('meridale crossing'); |
+ INSERT INTO streetname VALUES('merion hills'); |
+ INSERT INTO streetname VALUES('merlot'); |
+ INSERT INTO streetname VALUES('mersham'); |
+ INSERT INTO streetname VALUES('metromont'); |
+ INSERT INTO streetname VALUES('metromont industrial'); |
+ INSERT INTO streetname VALUES('michaw'); |
+ INSERT INTO streetname VALUES('milhaven'); |
+ INSERT INTO streetname VALUES('milhof'); |
+ INSERT INTO streetname VALUES('millstream ridge'); |
+ INSERT INTO streetname VALUES('mineral ridge'); |
+ INSERT INTO streetname VALUES('mint thistle'); |
+ INSERT INTO streetname VALUES('mintleaf'); |
+ INSERT INTO streetname VALUES('mintvale'); |
+ INSERT INTO streetname VALUES('misty'); |
+ INSERT INTO streetname VALUES('misty arbor'); |
+ INSERT INTO streetname VALUES('misty creek'); |
+ INSERT INTO streetname VALUES('misty oaks'); |
+ INSERT INTO streetname VALUES('misty wood'); |
+ INSERT INTO streetname VALUES('mitzi deborah'); |
+ INSERT INTO streetname VALUES('mobile'); |
+ INSERT INTO streetname VALUES('molly elizabeth'); |
+ INSERT INTO streetname VALUES('monmouth'); |
+ INSERT INTO streetname VALUES('montrose'); |
+ INSERT INTO streetname VALUES('moonlight'); |
+ INSERT INTO streetname VALUES('moose'); |
+ INSERT INTO streetname VALUES('morning dew'); |
+ INSERT INTO streetname VALUES('morningsong'); |
+ INSERT INTO streetname VALUES('morningview'); |
+ INSERT INTO streetname VALUES('morsey'); |
+ INSERT INTO streetname VALUES('moss glen'); |
+ INSERT INTO streetname VALUES('mossy bank'); |
+ INSERT INTO streetname VALUES('motor sport'); |
+ INSERT INTO streetname VALUES('mountain laurel'); |
+ INSERT INTO streetname VALUES('mourning dove'); |
+ INSERT INTO streetname VALUES('mozart'); |
+ INSERT INTO streetname VALUES('munsing'); |
+ INSERT INTO streetname VALUES('murray'); |
+ INSERT INTO streetname VALUES('nathan'); |
+ INSERT INTO streetname VALUES('netherhall'); |
+ INSERT INTO streetname VALUES('netherton'); |
+ INSERT INTO streetname VALUES('neuhoff'); |
+ INSERT INTO streetname VALUES('nevin'); |
+ INSERT INTO streetname VALUES('nevin brook'); |
+ INSERT INTO streetname VALUES('nevin glen'); |
+ INSERT INTO streetname VALUES('nevin place'); |
+ INSERT INTO streetname VALUES('new england'); |
+ INSERT INTO streetname VALUES('new house'); |
+ INSERT INTO streetname VALUES('newbary'); |
+ INSERT INTO streetname VALUES('newchurch'); |
+ INSERT INTO streetname VALUES('newfane'); |
+ INSERT INTO streetname VALUES('newgard'); |
+ INSERT INTO streetname VALUES('nicholas'); |
+ INSERT INTO streetname VALUES('nicole'); |
+ INSERT INTO streetname VALUES('nobility'); |
+ INSERT INTO streetname VALUES('norcroft'); |
+ INSERT INTO streetname VALUES('northridge'); |
+ INSERT INTO streetname VALUES('northside'); |
+ INSERT INTO streetname VALUES('northwoods business'); |
+ INSERT INTO streetname VALUES('norway'); |
+ INSERT INTO streetname VALUES('nottinghill'); |
+ INSERT INTO streetname VALUES('numenore'); |
+ INSERT INTO streetname VALUES('nyewood'); |
+ INSERT INTO streetname VALUES('oak'); |
+ INSERT INTO streetname VALUES('oak cove'); |
+ INSERT INTO streetname VALUES('oak pasture'); |
+ INSERT INTO streetname VALUES('oakburn'); |
+ INSERT INTO streetname VALUES('oakwinds'); |
+ INSERT INTO streetname VALUES('oakwood'); |
+ INSERT INTO streetname VALUES('obrien'); |
+ INSERT INTO streetname VALUES('ocala'); |
+ INSERT INTO streetname VALUES('old bridge'); |
+ INSERT INTO streetname VALUES('old fox'); |
+ INSERT INTO streetname VALUES('old potters'); |
+ INSERT INTO streetname VALUES('old statesville'); |
+ INSERT INTO streetname VALUES('old steine'); |
+ INSERT INTO streetname VALUES('old stoney creek'); |
+ INSERT INTO streetname VALUES('old sugar creek'); |
+ INSERT INTO streetname VALUES('old timber'); |
+ INSERT INTO streetname VALUES('old wagon'); |
+ INSERT INTO streetname VALUES('old willow'); |
+ INSERT INTO streetname VALUES('oldenway'); |
+ INSERT INTO streetname VALUES('oneida'); |
+ INSERT INTO streetname VALUES('ontario'); |
+ INSERT INTO streetname VALUES('oriole'); |
+ INSERT INTO streetname VALUES('orofino'); |
+ INSERT INTO streetname VALUES('orr'); |
+ INSERT INTO streetname VALUES('osage'); |
+ INSERT INTO streetname VALUES('osceola'); |
+ INSERT INTO streetname VALUES('osprey knoll'); |
+ INSERT INTO streetname VALUES('oxford hill'); |
+ INSERT INTO streetname VALUES('painted fern'); |
+ INSERT INTO streetname VALUES('painted pony'); |
+ INSERT INTO streetname VALUES('paisley'); |
+ INSERT INTO streetname VALUES('pale moss'); |
+ INSERT INTO streetname VALUES('palladium'); |
+ INSERT INTO streetname VALUES('palmutum'); |
+ INSERT INTO streetname VALUES('palustris'); |
+ INSERT INTO streetname VALUES('panglemont'); |
+ INSERT INTO streetname VALUES('panther'); |
+ INSERT INTO streetname VALUES('panthersville'); |
+ INSERT INTO streetname VALUES('paper whites'); |
+ INSERT INTO streetname VALUES('park'); |
+ INSERT INTO streetname VALUES('parker green'); |
+ INSERT INTO streetname VALUES('parkhouse'); |
+ INSERT INTO streetname VALUES('passour ridge'); |
+ INSERT INTO streetname VALUES('pasture view'); |
+ INSERT INTO streetname VALUES('patricia ann'); |
+ INSERT INTO streetname VALUES('patton'); |
+ INSERT INTO streetname VALUES('patton ridge'); |
+ INSERT INTO streetname VALUES('pawpaw'); |
+ INSERT INTO streetname VALUES('peach'); |
+ INSERT INTO streetname VALUES('peakwood'); |
+ INSERT INTO streetname VALUES('pebble creek'); |
+ INSERT INTO streetname VALUES('pecan cove'); |
+ INSERT INTO streetname VALUES('pedigree'); |
+ INSERT INTO streetname VALUES('pelorus'); |
+ INSERT INTO streetname VALUES('penmore'); |
+ INSERT INTO streetname VALUES('pensfold'); |
+ INSERT INTO streetname VALUES('pepperstone'); |
+ INSERT INTO streetname VALUES('peregrine'); |
+ INSERT INTO streetname VALUES('periwinkle'); |
+ INSERT INTO streetname VALUES('perkins'); |
+ INSERT INTO streetname VALUES('pete brown'); |
+ INSERT INTO streetname VALUES('phillips'); |
+ INSERT INTO streetname VALUES('pickway'); |
+ INSERT INTO streetname VALUES('piercy woods'); |
+ INSERT INTO streetname VALUES('pierpoint'); |
+ INSERT INTO streetname VALUES('pine'); |
+ INSERT INTO streetname VALUES('pine branch'); |
+ INSERT INTO streetname VALUES('pine meadow'); |
+ INSERT INTO streetname VALUES('pineleaf'); |
+ INSERT INTO streetname VALUES('pinewood'); |
+ INSERT INTO streetname VALUES('pintail'); |
+ INSERT INTO streetname VALUES('pipestone'); |
+ INSERT INTO streetname VALUES('placer maple'); |
+ INSERT INTO streetname VALUES('plover'); |
+ INSERT INTO streetname VALUES('plum'); |
+ INSERT INTO streetname VALUES('po box'); |
+ INSERT INTO streetname VALUES('pochard'); |
+ INSERT INTO streetname VALUES('pointview'); |
+ INSERT INTO streetname VALUES('polk and white'); |
+ INSERT INTO streetname VALUES('pond valley'); |
+ INSERT INTO streetname VALUES('pondridge'); |
+ INSERT INTO streetname VALUES('pope farm'); |
+ INSERT INTO streetname VALUES('poplar grove'); |
+ INSERT INTO streetname VALUES('poplar springs'); |
+ INSERT INTO streetname VALUES('portola'); |
+ INSERT INTO streetname VALUES('potters glen'); |
+ INSERT INTO streetname VALUES('powatan'); |
+ INSERT INTO streetname VALUES('prairie valley'); |
+ INSERT INTO streetname VALUES('prescott'); |
+ INSERT INTO streetname VALUES('presmann'); |
+ INSERT INTO streetname VALUES('prestigious'); |
+ INSERT INTO streetname VALUES('princess'); |
+ INSERT INTO streetname VALUES('prosperity'); |
+ INSERT INTO streetname VALUES('prosperity church'); |
+ INSERT INTO streetname VALUES('prosperity commons'); |
+ INSERT INTO streetname VALUES('prosperity park'); |
+ INSERT INTO streetname VALUES('prosperity point'); |
+ INSERT INTO streetname VALUES('prosperity ridge'); |
+ INSERT INTO streetname VALUES('prosperity view'); |
+ INSERT INTO streetname VALUES('purple finch'); |
+ INSERT INTO streetname VALUES('quail'); |
+ INSERT INTO streetname VALUES('queensbury'); |
+ INSERT INTO streetname VALUES('quinn'); |
+ INSERT INTO streetname VALUES('racine'); |
+ INSERT INTO streetname VALUES('radbourne'); |
+ INSERT INTO streetname VALUES('raddington'); |
+ INSERT INTO streetname VALUES('raku'); |
+ INSERT INTO streetname VALUES('rancliffe'); |
+ INSERT INTO streetname VALUES('ravencrest'); |
+ INSERT INTO streetname VALUES('reames'); |
+ INSERT INTO streetname VALUES('rebecca run'); |
+ INSERT INTO streetname VALUES('red bluff'); |
+ INSERT INTO streetname VALUES('red clay'); |
+ INSERT INTO streetname VALUES('red clover'); |
+ INSERT INTO streetname VALUES('red rose'); |
+ INSERT INTO streetname VALUES('red shed'); |
+ INSERT INTO streetname VALUES('red tail'); |
+ INSERT INTO streetname VALUES('redbridge'); |
+ INSERT INTO streetname VALUES('redstart'); |
+ INSERT INTO streetname VALUES('redstone view'); |
+ INSERT INTO streetname VALUES('reedmont'); |
+ INSERT INTO streetname VALUES('reeves'); |
+ INSERT INTO streetname VALUES('regal'); |
+ INSERT INTO streetname VALUES('reinbeck'); |
+ INSERT INTO streetname VALUES('retriever'); |
+ INSERT INTO streetname VALUES('ribbonwalk'); |
+ INSERT INTO streetname VALUES('richardson park'); |
+ INSERT INTO streetname VALUES('richfield'); |
+ INSERT INTO streetname VALUES('riddings'); |
+ INSERT INTO streetname VALUES('ridge'); |
+ INSERT INTO streetname VALUES('ridge cliff'); |
+ INSERT INTO streetname VALUES('ridge path'); |
+ INSERT INTO streetname VALUES('ridge peak'); |
+ INSERT INTO streetname VALUES('ridgefield'); |
+ INSERT INTO streetname VALUES('ridgeline'); |
+ INSERT INTO streetname VALUES('ridgeview commons'); |
+ INSERT INTO streetname VALUES('riley'); |
+ INSERT INTO streetname VALUES('riley woods'); |
+ INSERT INTO streetname VALUES('rillet'); |
+ INSERT INTO streetname VALUES('rindle'); |
+ INSERT INTO streetname VALUES('rivendell'); |
+ INSERT INTO streetname VALUES('robin'); |
+ INSERT INTO streetname VALUES('robins nest'); |
+ INSERT INTO streetname VALUES('robur'); |
+ INSERT INTO streetname VALUES('robyns glen'); |
+ INSERT INTO streetname VALUES('rock stream'); |
+ INSERT INTO streetname VALUES('rockwell'); |
+ INSERT INTO streetname VALUES('rockwell church'); |
+ INSERT INTO streetname VALUES('rocky brook'); |
+ INSERT INTO streetname VALUES('rocky ford club'); |
+ INSERT INTO streetname VALUES('rotary'); |
+ INSERT INTO streetname VALUES('rouda'); |
+ INSERT INTO streetname VALUES('royal bluff'); |
+ INSERT INTO streetname VALUES('royal celadon'); |
+ INSERT INTO streetname VALUES('rubin lura'); |
+ INSERT INTO streetname VALUES('runswyck'); |
+ INSERT INTO streetname VALUES('ruth ferrell'); |
+ INSERT INTO streetname VALUES('ruth polk'); |
+ INSERT INTO streetname VALUES('ryan jay'); |
+ INSERT INTO streetname VALUES('sackett'); |
+ INSERT INTO streetname VALUES('saddle pace'); |
+ INSERT INTO streetname VALUES('saddle run'); |
+ INSERT INTO streetname VALUES('saddle trail'); |
+ INSERT INTO streetname VALUES('saguaro'); |
+ INSERT INTO streetname VALUES('saint audrey'); |
+ INSERT INTO streetname VALUES('saint bernard'); |
+ INSERT INTO streetname VALUES('saint frances'); |
+ INSERT INTO streetname VALUES('sam roper'); |
+ INSERT INTO streetname VALUES('samara'); |
+ INSERT INTO streetname VALUES('sanders creek'); |
+ INSERT INTO streetname VALUES('saquache'); |
+ INSERT INTO streetname VALUES('sarnia'); |
+ INSERT INTO streetname VALUES('savannah springs'); |
+ INSERT INTO streetname VALUES('sawgrass ridge'); |
+ INSERT INTO streetname VALUES('saxonbury'); |
+ INSERT INTO streetname VALUES('scotch moss'); |
+ INSERT INTO streetname VALUES('seasons'); |
+ INSERT INTO streetname VALUES('serenity'); |
+ INSERT INTO streetname VALUES('seths'); |
+ INSERT INTO streetname VALUES('shadow lawn'); |
+ INSERT INTO streetname VALUES('shadow oaks'); |
+ INSERT INTO streetname VALUES('shadow pine'); |
+ INSERT INTO streetname VALUES('shadyside'); |
+ INSERT INTO streetname VALUES('shallow oak'); |
+ INSERT INTO streetname VALUES('shelley'); |
+ INSERT INTO streetname VALUES('shining oak'); |
+ INSERT INTO streetname VALUES('ship'); |
+ INSERT INTO streetname VALUES('shore haven'); |
+ INSERT INTO streetname VALUES('shuman'); |
+ INSERT INTO streetname VALUES('sidney'); |
+ INSERT INTO streetname VALUES('silver birch'); |
+ INSERT INTO streetname VALUES('silvermere'); |
+ INSERT INTO streetname VALUES('simonton'); |
+ INSERT INTO streetname VALUES('singing hills'); |
+ INSERT INTO streetname VALUES('singing oak'); |
+ INSERT INTO streetname VALUES('sipes'); |
+ INSERT INTO streetname VALUES('six point'); |
+ INSERT INTO streetname VALUES('skycrest'); |
+ INSERT INTO streetname VALUES('skyline'); |
+ INSERT INTO streetname VALUES('small'); |
+ INSERT INTO streetname VALUES('smith corners'); |
+ INSERT INTO streetname VALUES('smithwood'); |
+ INSERT INTO streetname VALUES('snow hill'); |
+ INSERT INTO streetname VALUES('soapstone'); |
+ INSERT INTO streetname VALUES('sobeck'); |
+ INSERT INTO streetname VALUES('socata'); |
+ INSERT INTO streetname VALUES('solace'); |
+ INSERT INTO streetname VALUES('solway'); |
+ INSERT INTO streetname VALUES('song sparrow'); |
+ INSERT INTO streetname VALUES('sorrento'); |
+ INSERT INTO streetname VALUES('spector'); |
+ INSERT INTO streetname VALUES('spin drift'); |
+ INSERT INTO streetname VALUES('spring crest'); |
+ INSERT INTO streetname VALUES('spring lee'); |
+ INSERT INTO streetname VALUES('spring park'); |
+ INSERT INTO streetname VALUES('spring terrace'); |
+ INSERT INTO streetname VALUES('spring trace'); |
+ INSERT INTO streetname VALUES('springhaven'); |
+ INSERT INTO streetname VALUES('squirrel trail'); |
+ INSERT INTO streetname VALUES('stardust'); |
+ INSERT INTO streetname VALUES('stargaze'); |
+ INSERT INTO streetname VALUES('starita'); |
+ INSERT INTO streetname VALUES('starmount'); |
+ INSERT INTO streetname VALUES('statesville'); |
+ INSERT INTO streetname VALUES('steed'); |
+ INSERT INTO streetname VALUES('steelewood'); |
+ INSERT INTO streetname VALUES('steepleglen'); |
+ INSERT INTO streetname VALUES('stephens farm'); |
+ INSERT INTO streetname VALUES('stewarton'); |
+ INSERT INTO streetname VALUES('stone park'); |
+ INSERT INTO streetname VALUES('stonebrook'); |
+ INSERT INTO streetname VALUES('stonefield'); |
+ INSERT INTO streetname VALUES('stoneglen'); |
+ INSERT INTO streetname VALUES('stonemarsh'); |
+ INSERT INTO streetname VALUES('stoney garden'); |
+ INSERT INTO streetname VALUES('stoney run'); |
+ INSERT INTO streetname VALUES('stoney valley'); |
+ INSERT INTO streetname VALUES('stoneykirk'); |
+ INSERT INTO streetname VALUES('stream bank'); |
+ INSERT INTO streetname VALUES('stream ridge'); |
+ INSERT INTO streetname VALUES('suburban'); |
+ INSERT INTO streetname VALUES('suffield'); |
+ INSERT INTO streetname VALUES('sugar creek'); |
+ INSERT INTO streetname VALUES('sugarberry'); |
+ INSERT INTO streetname VALUES('sugarstone'); |
+ INSERT INTO streetname VALUES('summer creek'); |
+ INSERT INTO streetname VALUES('summer valley'); |
+ INSERT INTO streetname VALUES('summercrest'); |
+ INSERT INTO streetname VALUES('summercroft'); |
+ INSERT INTO streetname VALUES('summerford'); |
+ INSERT INTO streetname VALUES('summergold'); |
+ INSERT INTO streetname VALUES('sunbeam'); |
+ INSERT INTO streetname VALUES('sunbridge'); |
+ INSERT INTO streetname VALUES('sunpath'); |
+ INSERT INTO streetname VALUES('sunset'); |
+ INSERT INTO streetname VALUES('sunset ridge'); |
+ INSERT INTO streetname VALUES('sunstone'); |
+ INSERT INTO streetname VALUES('suntrace'); |
+ INSERT INTO streetname VALUES('sunwalk'); |
+ INSERT INTO streetname VALUES('sutters hill'); |
+ INSERT INTO streetname VALUES('suttonview'); |
+ INSERT INTO streetname VALUES('swallow tail'); |
+ INSERT INTO streetname VALUES('swanston'); |
+ INSERT INTO streetname VALUES('sweet grove'); |
+ INSERT INTO streetname VALUES('sweet rose'); |
+ INSERT INTO streetname VALUES('sweetbriar ridge'); |
+ INSERT INTO streetname VALUES('sweetfield'); |
+ INSERT INTO streetname VALUES('sydney overlook'); |
+ INSERT INTO streetname VALUES('sylvan'); |
+ INSERT INTO streetname VALUES('symphony woods'); |
+ INSERT INTO streetname VALUES('tallia'); |
+ INSERT INTO streetname VALUES('tallu'); |
+ INSERT INTO streetname VALUES('talwyn'); |
+ INSERT INTO streetname VALUES('tanager'); |
+ INSERT INTO streetname VALUES('tanager park'); |
+ INSERT INTO streetname VALUES('tangley'); |
+ INSERT INTO streetname VALUES('taranasay'); |
+ INSERT INTO streetname VALUES('tarby'); |
+ INSERT INTO streetname VALUES('tarland'); |
+ INSERT INTO streetname VALUES('tarpway'); |
+ INSERT INTO streetname VALUES('tauten'); |
+ INSERT INTO streetname VALUES('taymouth'); |
+ INSERT INTO streetname VALUES('ten trees'); |
+ INSERT INTO streetname VALUES('terrace view'); |
+ INSERT INTO streetname VALUES('terrier'); |
+ INSERT INTO streetname VALUES('tesh'); |
+ INSERT INTO streetname VALUES('teton'); |
+ INSERT INTO streetname VALUES('tewkesbury'); |
+ INSERT INTO streetname VALUES('thelema'); |
+ INSERT INTO streetname VALUES('thistle bloom'); |
+ INSERT INTO streetname VALUES('thistledown'); |
+ INSERT INTO streetname VALUES('thomas ridge'); |
+ INSERT INTO streetname VALUES('thornbrook'); |
+ INSERT INTO streetname VALUES('tifton grass'); |
+ INSERT INTO streetname VALUES('tigerton'); |
+ INSERT INTO streetname VALUES('tomsie efird'); |
+ INSERT INTO streetname VALUES('tor'); |
+ INSERT INTO streetname VALUES('torphin'); |
+ INSERT INTO streetname VALUES('torrence'); |
+ INSERT INTO streetname VALUES('towering pine'); |
+ INSERT INTO streetname VALUES('towhee'); |
+ INSERT INTO streetname VALUES('toxaway'); |
+ INSERT INTO streetname VALUES('tracy glenn'); |
+ INSERT INTO streetname VALUES('tradition view'); |
+ INSERT INTO streetname VALUES('trailer'); |
+ INSERT INTO streetname VALUES('transport'); |
+ INSERT INTO streetname VALUES('trehurst'); |
+ INSERT INTO streetname VALUES('trexler'); |
+ INSERT INTO streetname VALUES('trillium fields'); |
+ INSERT INTO streetname VALUES('trimbach'); |
+ INSERT INTO streetname VALUES('tucker'); |
+ INSERT INTO streetname VALUES('tullamore'); |
+ INSERT INTO streetname VALUES('tullock creek'); |
+ INSERT INTO streetname VALUES('tunston'); |
+ INSERT INTO streetname VALUES('tupelo'); |
+ INSERT INTO streetname VALUES('turnabout'); |
+ INSERT INTO streetname VALUES('turney'); |
+ INSERT INTO streetname VALUES('turtle cross'); |
+ INSERT INTO streetname VALUES('turtleback'); |
+ INSERT INTO streetname VALUES('twelvestone'); |
+ INSERT INTO streetname VALUES('twin'); |
+ INSERT INTO streetname VALUES('twin brook'); |
+ INSERT INTO streetname VALUES('twin lakes'); |
+ INSERT INTO streetname VALUES('twisted pine'); |
+ INSERT INTO streetname VALUES('tyler finley'); |
+ INSERT INTO streetname VALUES('university station'); |
+ INSERT INTO streetname VALUES('uphill'); |
+ INSERT INTO streetname VALUES('valeview'); |
+ INSERT INTO streetname VALUES('valhalla'); |
+ INSERT INTO streetname VALUES('van'); |
+ INSERT INTO streetname VALUES('vance davis'); |
+ INSERT INTO streetname VALUES('vanhoy'); |
+ INSERT INTO streetname VALUES('veckman'); |
+ INSERT INTO streetname VALUES('victoria'); |
+ INSERT INTO streetname VALUES('victory'); |
+ INSERT INTO streetname VALUES('village glen'); |
+ INSERT INTO streetname VALUES('vireo'); |
+ INSERT INTO streetname VALUES('viscount'); |
+ INSERT INTO streetname VALUES('voeltz'); |
+ INSERT INTO streetname VALUES('wade e morgan'); |
+ INSERT INTO streetname VALUES('wake'); |
+ INSERT INTO streetname VALUES('wales'); |
+ INSERT INTO streetname VALUES('wallace ridge'); |
+ INSERT INTO streetname VALUES('waltham'); |
+ INSERT INTO streetname VALUES('wanamassa'); |
+ INSERT INTO streetname VALUES('warbler wood'); |
+ INSERT INTO streetname VALUES('washington'); |
+ INSERT INTO streetname VALUES('water'); |
+ INSERT INTO streetname VALUES('waterelm'); |
+ INSERT INTO streetname VALUES('waterford hills'); |
+ INSERT INTO streetname VALUES('waterford valley'); |
+ INSERT INTO streetname VALUES('waterloo'); |
+ INSERT INTO streetname VALUES('waterton leas'); |
+ INSERT INTO streetname VALUES('waverly lynn'); |
+ INSERT INTO streetname VALUES('waverlyglen'); |
+ INSERT INTO streetname VALUES('wayside'); |
+ INSERT INTO streetname VALUES('westbury lake'); |
+ INSERT INTO streetname VALUES('westray'); |
+ INSERT INTO streetname VALUES('whistlers chase'); |
+ INSERT INTO streetname VALUES('whistley green'); |
+ INSERT INTO streetname VALUES('whistling oak'); |
+ INSERT INTO streetname VALUES('whitcomb'); |
+ INSERT INTO streetname VALUES('white aspen'); |
+ INSERT INTO streetname VALUES('white cascade'); |
+ INSERT INTO streetname VALUES('white mist'); |
+ INSERT INTO streetname VALUES('white rock'); |
+ INSERT INTO streetname VALUES('white stag'); |
+ INSERT INTO streetname VALUES('whitegate'); |
+ INSERT INTO streetname VALUES('whitehill'); |
+ INSERT INTO streetname VALUES('whitetail'); |
+ INSERT INTO streetname VALUES('whitewood'); |
+ INSERT INTO streetname VALUES('wilburn park'); |
+ INSERT INTO streetname VALUES('wild garden'); |
+ INSERT INTO streetname VALUES('wild rose'); |
+ INSERT INTO streetname VALUES('wilkins terrace'); |
+ INSERT INTO streetname VALUES('william ficklen'); |
+ INSERT INTO streetname VALUES('wiltshire ridge'); |
+ INSERT INTO streetname VALUES('windchase'); |
+ INSERT INTO streetname VALUES('winding jordan'); |
+ INSERT INTO streetname VALUES('windy meadow'); |
+ INSERT INTO streetname VALUES('winghaven'); |
+ INSERT INTO streetname VALUES('wingmont'); |
+ INSERT INTO streetname VALUES('winslow'); |
+ INSERT INTO streetname VALUES('winter pine'); |
+ INSERT INTO streetname VALUES('winter view'); |
+ INSERT INTO streetname VALUES('wolf creek'); |
+ INSERT INTO streetname VALUES('wondering oak'); |
+ INSERT INTO streetname VALUES('woodard'); |
+ INSERT INTO streetname VALUES('woodfire'); |
+ INSERT INTO streetname VALUES('woodland commons'); |
+ INSERT INTO streetname VALUES('woodland hills'); |
+ INSERT INTO streetname VALUES('woodnotch'); |
+ INSERT INTO streetname VALUES('woodstone'); |
+ INSERT INTO streetname VALUES('worsley'); |
+ INSERT INTO streetname VALUES('wren creek'); |
+ INSERT INTO streetname VALUES('wrens nest'); |
+ INSERT INTO streetname VALUES('wrexham'); |
+ INSERT INTO streetname VALUES('wt harris'); |
+ INSERT INTO streetname VALUES('wylie meadow'); |
+ INSERT INTO streetname VALUES('wynborough'); |
+ INSERT INTO streetname VALUES('wynbrook'); |
+ INSERT INTO streetname VALUES('wyndham hill'); |
+ INSERT INTO streetname VALUES('yandem'); |
+ INSERT INTO streetname VALUES('yellow rose'); |
+ INSERT INTO streetname VALUES('yellow spaniel'); |
+ INSERT INTO streetname VALUES('yorkford'); |
+ INSERT INTO streetname VALUES('ziegler'); |
+ INSERT INTO streetname VALUES('zion renaissance'); |
+ |
+ SELECT count(*) FROM streetname; |
+ } |
+} {1228} |
+ |
+do_test fuzzer1-2.1 { |
+ execsql { |
+ SELECT n, distance FROM f2, streetname |
+ WHERE f2.word MATCH 'wersley' |
+ AND f2.distance<=150 |
+ AND f2.word=streetname.n |
+ } |
+} {worsley 37} |
+do_test fuzzer1-2.2 { |
+ execsql { |
+ SELECT n, distance FROM f2, streetname |
+ WHERE f2.word MATCH 'testledown' |
+ AND f2.distance<=150 |
+ AND f2.word=streetname.n |
+ } |
+} {thistledown 103} |
+do_test fuzzer1-2.3 { |
+ execsql { |
+ SELECT DISTINCT streetname.n FROM f2, streetname |
+ WHERE f2.word MATCH 'tayle' |
+ AND f2.distance<=200 |
+ AND streetname.n>=f2.word AND streetname.n<=(f2.word || x'F7BFBFBF') |
+ } |
+} {steelewood tallia tallu talwyn taymouth thelema trailer {tyler finley}} |
+ |
+ |
+finish_test |