History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roadways"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
541 | 2025-08-28 07:48:10 | roadways | 4 | 161609 | 428 | 13.406 | 12055.0 |
540 | 2025-08-26 23:53:42 | roadways | 4 | 161609 | 428 | 12.940 | 12489.1 |
539 | 2025-08-17 15:07:21 | roadways | 4 | 161609 | 428 | 39.236 | 4118.9 |
538 | 2025-08-16 23:31:50 | roadways | 1 | 82945 | 2 | 3.800 | 21827.6 |
537 | 2025-08-15 14:36:42 | roadways | 4 | 161609 | 428 | 59.236 | 2728.2 |
536 | 2025-08-14 22:11:01 | roadways | 4 | 161609 | 428 | 28.566 | 5657.4 |
535 | 2025-08-14 12:19:07 | roadways | 4 | 161609 | 428 | 13.576 | 11904.0 |
534 | 2025-08-13 11:31:50 | roadways | 4 | 161609 | 428 | 43.360 | 3727.1 |
533 | 2025-08-04 16:53:18 | roadways | 3 | 146162 | 57 | 23.233 | 6291.1 |
532 | 2025-08-04 12:43:06 | roadways | 1 | 82945 | 2 | 4.703 | 17636.6 |
531 | 2025-07-27 21:06:46 | roadways | 3 | 146162 | 57 | 29.830 | 4899.8 |
530 | 2025-07-27 04:00:24 | roadways | 1 | 82945 | 2 | 4.203 | 19734.7 |
529 | 2025-07-27 01:42:37 | roadways | 1 | 82945 | 2 | 3.483 | 23814.2 |
528 | 2025-07-24 09:26:29 | roadways | 4 | 161609 | 428 | 42.250 | 3825.1 |
527 | 2025-07-23 13:30:08 | roadways | 1 | 82945 | 2 | 3.623 | 22894.0 |
526 | 2025-07-22 20:56:36 | roadways | 1 | 82945 | 2 | 3.983 | 20824.8 |
525 | 2025-07-20 21:05:45 | roadways | 1 | 82945 | 2 | 1.390 | 59672.7 |
524 | 2025-07-20 00:03:35 | roadways | 4 | 161609 | 428 | 38.656 | 4180.7 |
523 | 2025-07-18 08:28:03 | roadways | 1 | 82945 | 2 | 4.030 | 20581.9 |
522 | 2025-07-15 21:53:18 | roadways | 3 | 146162 | 57 | 8.300 | 17609.9 |
521 | 2025-07-12 10:23:39 | roadways | 1 | 82945 | 2 | 1.483 | 55930.5 |
520 | 2025-07-10 00:41:28 | roadways | 1 | 82945 | 2 | 3.750 | 22118.7 |
519 | 2025-07-07 08:06:17 | roadways | 1 | 82945 | 2 | 9.326 | 8894.0 |
518 | 2025-07-03 22:12:42 | roadways | 3 | 146162 | 57 | 13.533 | 10800.4 |
517 | 2025-07-03 05:06:58 | roadways | 1 | 82945 | 2 | 1.483 | 55930.5 |
516 | 2025-07-01 22:56:25 | roadways | 3 | 146162 | 57 | 37.173 | 3931.9 |
515 | 2025-06-30 03:32:50 | roadways | 3 | 146162 | 57 | 33.063 | 4420.7 |
514 | 2025-06-27 02:07:38 | roadways | 3 | 146162 | 57 | 29.780 | 4908.1 |
513 | 2025-06-26 20:54:05 | roadways | 4 | 161609 | 428 | 60.753 | 2660.1 |
512 | 2025-06-26 18:45:10 | roadways | 2 | 121059 | 6 | 15.780 | 7671.7 |
511 | 2025-06-26 18:19:59 | roadways | 3 | 146162 | 57 | 25.423 | 5749.2 |
510 | 2025-06-26 12:38:09 | roadways | 1 | 82945 | 2 | 6.186 | 13408.5 |
509 | 2025-06-24 00:42:43 | roadways | 1 | 82945 | 2 | 5.046 | 16437.8 |
508 | 2025-06-21 08:36:35 | roadways | 3 | 146162 | 57 | 7.873 | 18565.0 |
507 | 2025-06-19 08:23:17 | roadways | 3 | 146162 | 57 | 7.733 | 18901.1 |
506 | 2025-06-18 01:15:09 | roadways | 1 | 82945 | 2 | 7.670 | 10814.2 |
505 | 2025-06-16 17:04:26 | roadways | 3 | 146162 | 57 | 43.190 | 3384.2 |
504 | 2025-06-14 17:14:19 | roadways | 3 | 146162 | 57 | 41.050 | 3560.6 |
503 | 2025-06-14 06:59:08 | roadways | 2 | 121059 | 6 | 17.610 | 6874.4 |
502 | 2025-06-14 06:56:06 | roadways | 3 | 146162 | 57 | 38.736 | 3773.3 |
501 | 2025-06-13 00:18:40 | roadways | 1 | 82945 | 2 | 9.660 | 8586.4 |
500 | 2025-06-11 07:57:14 | roadways | 1 | 82945 | 2 | 3.513 | 23610.9 |
499 | 2025-06-10 21:53:57 | roadways | 1 | 82945 | 2 | 1.470 | 56425.2 |
498 | 2025-06-10 15:05:10 | roadways | 1 | 82945 | 2 | 3.653 | 22706.0 |
497 | 2025-06-06 08:02:20 | roadways | 1 | 82945 | 2 | 7.640 | 10856.7 |
496 | 2025-06-03 23:47:04 | roadways | 4 | 161609 | 428 | 55.533 | 2910.1 |
495 | 2025-05-31 14:18:01 | roadways | 1 | 82945 | 2 | 6.610 | 12548.4 |
494 | 2025-05-30 12:47:33 | roadways | 1 | 82945 | 2 | 7.486 | 11080.0 |
493 | 2025-05-24 02:58:15 | roadways | 4 | 161609 | 428 | 74.690 | 2163.7 |
492 | 2025-05-23 02:55:45 | roadways | 4 | 161609 | 428 | 45.846 | 3525.0 |
491 | 2025-05-22 20:20:38 | roadways | 4 | 161609 | 428 | 60.473 | 2672.4 |
490 | 2025-05-18 05:27:08 | roadways | 1 | 82945 | 2 | 3.953 | 20982.8 |
489 | 2025-05-15 11:41:30 | roadways | 4 | 161609 | 428 | 11.576 | 13960.7 |
488 | 2025-05-14 12:12:12 | roadways | 4 | 161609 | 428 | 60.220 | 2683.6 |
487 | 2025-05-13 11:17:32 | roadways | 4 | 161609 | 428 | 39.476 | 4093.9 |
486 | 2025-05-12 15:22:09 | roadways | 1 | 82945 | 2 | 11.970 | 6929.4 |
485 | 2025-05-11 15:13:25 | roadways | 4 | 161609 | 428 | 26.110 | 6189.5 |
484 | 2025-05-11 08:08:52 | roadways | 4 | 161609 | 428 | 41.906 | 3856.5 |
483 | 2025-05-10 22:08:30 | roadways | 4 | 161609 | 428 | 82.860 | 1950.4 |
482 | 2025-05-09 15:22:47 | roadways | 4 | 161609 | 428 | 13.076 | 12359.2 |
481 | 2025-05-08 08:13:51 | roadways | 1 | 82945 | 2 | 3.330 | 24908.4 |
480 | 2025-05-06 11:55:55 | roadways | 1 | 82945 | 2 | 10.846 | 7647.5 |
479 | 2025-05-02 00:21:49 | roadways | 1 | 82945 | 2 | 5.093 | 16286.1 |
478 | 2025-04-22 23:43:49 | roadways | 1 | 82945 | 2 | 8.190 | 10127.6 |
477 | 2025-04-11 14:52:58 | roadways | 3 | 146162 | 57 | 28.076 | 5205.9 |
476 | 2025-04-08 18:25:55 | roadways | 3 | 146162 | 57 | 6.953 | 21021.4 |
475 | 2025-04-07 07:15:21 | roadways | 1 | 82945 | 2 | 1.376 | 60279.8 |
474 | 2025-04-04 07:53:14 | roadways | 1 | 82945 | 2 | 4.720 | 17573.1 |
473 | 2025-03-20 00:28:04 | roadways | 1 | 82945 | 2 | 11.890 | 6976.0 |
472 | 2025-03-13 14:00:12 | roadways | 1 | 82945 | 2 | 7.266 | 11415.5 |
471 | 2025-03-08 00:40:38 | roadways | 3 | 146162 | 57 | 36.500 | 4004.4 |
470 | 2025-03-05 10:30:27 | roadways | 1 | 82945 | 2 | 2.340 | 35446.6 |
469 | 2025-02-23 16:56:03 | roadways | 3 | 146162 | 57 | 27.156 | 5382.3 |
468 | 2025-02-22 14:55:35 | roadways | 1 | 82945 | 2 | 8.546 | 9705.7 |
467 | 2025-02-20 18:02:01 | roadways | 1 | 82945 | 2 | 7.250 | 11440.7 |
466 | 2025-02-18 16:47:47 | roadways | 1 | 82945 | 2 | 6.830 | 12144.2 |
465 | 2025-02-10 05:59:36 | roadways | 3 | 146162 | 57 | 27.940 | 5231.3 |
464 | 2025-02-09 16:23:49 | roadways | 3 | 146162 | 57 | 38.550 | 3791.5 |
463 | 2025-02-04 21:36:09 | roadways | 3 | 146162 | 57 | 17.953 | 8141.4 |
462 | 2025-02-02 07:35:50 | roadways | 3 | 146162 | 57 | 24.173 | 6046.5 |
461 | 2025-01-31 05:58:07 | roadways | 3 | 146162 | 57 | 37.656 | 3881.5 |
460 | 2025-01-30 22:53:34 | roadways | 4 | 161609 | 428 | 63.690 | 2537.4 |
459 | 2025-01-29 19:19:25 | roadways | 4 | 161609 | 428 | 45.190 | 3576.2 |
458 | 2025-01-22 19:12:23 | roadways | 4 | 161609 | 428 | 63.393 | 2549.3 |
457 | 2025-01-21 06:36:40 | roadways | 2 | 121059 | 6 | 25.203 | 4803.4 |
456 | 2025-01-21 06:36:06 | roadways | 1 | 82945 | 2 | 4.546 | 18245.7 |
455 | 2025-01-15 02:51:26 | roadways | 1 | 82945 | 2 | 3.720 | 22297.0 |
454 | 2025-01-09 20:26:55 | roadways | 3 | 146162 | 57 | 11.313 | 12919.8 |
453 | 2025-01-05 03:03:11 | roadways | 3 | 146162 | 57 | 30.283 | 4826.5 |
452 | 2025-01-02 09:20:25 | roadways | 3 | 146162 | 57 | 37.236 | 3925.3 |
451 | 2025-01-01 02:29:41 | roadways | 3 | 146162 | 57 | 36.660 | 3987.0 |
450 | 2024-12-31 10:23:04 | roadways | 4 | 161609 | 428 | 65.106 | 2482.2 |
449 | 2024-12-30 19:04:41 | roadways | 4 | 161609 | 428 | 44.423 | 3638.0 |
448 | 2024-12-30 19:04:41 | roadways | 2 | 121059 | 6 | 7.376 | 16412.6 |
447 | 2024-12-30 19:03:54 | roadways | 3 | 146162 | 57 | 7.250 | 20160.3 |
446 | 2024-12-25 11:02:56 | roadways | 1 | 82945 | 2 | 5.953 | 13933.3 |
445 | 2024-12-19 18:23:54 | roadways | 3 | 146162 | 57 | 41.016 | 3563.5 |
444 | 2024-12-19 18:23:58 | roadways | 2 | 121059 | 6 | 19.000 | 6371.5 |
443 | 2024-12-19 18:23:48 | roadways | 1 | 82945 | 2 | 3.500 | 23698.6 |
442 | 2024-11-30 23:10:13 | roadways | 1 | 82945 | 2 | 7.220 | 11488.2 |