| OLD | NEW |
|---|
| (Empty) | |
| 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 obc
do 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 } {steelewood tallia tallu talwyn taymouth thelema trailer {tyler finley}} |
| 1380 |
| 1381 |
| 1382 finish_test |
| OLD | NEW |
|---|
Chromium Code Reviews
