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