History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stations"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
618 | 2024-05-08 00:14:14 | stations | 2 | 121059 | 55 | 13.266 | 9125.5 |
617 | 2024-05-07 08:12:11 | stations | 2 | 121059 | 55 | 4.263 | 28397.6 |
616 | 2024-05-06 21:56:21 | stations | 2 | 121059 | 55 | 4.263 | 28397.6 |
615 | 2024-05-05 10:39:13 | stations | 3 | 146162 | 379 | 11.266 | 12973.7 |
614 | 2024-05-05 01:27:59 | stations | 2 | 121059 | 55 | 4.283 | 28265.0 |
613 | 2024-05-05 01:25:31 | stations | 3 | 146162 | 379 | 8.360 | 17483.5 |
612 | 2024-05-04 22:08:55 | stations | 2 | 121059 | 55 | 4.686 | 25834.2 |
611 | 2024-05-04 08:26:56 | stations | 3 | 146162 | 379 | 8.016 | 18233.8 |
610 | 2024-05-04 03:51:41 | stations | 1 | 82945 | 3 | 1.623 | 51106.0 |
609 | 2024-05-04 01:20:56 | stations | 2 | 121059 | 55 | 5.206 | 23253.7 |
608 | 2024-05-04 01:20:27 | stations | 1 | 82945 | 3 | 1.670 | 49667.7 |
607 | 2024-05-03 21:35:48 | stations | 3 | 146162 | 379 | 16.796 | 8702.2 |
606 | 2024-05-03 19:11:12 | stations | 3 | 146162 | 379 | 7.456 | 19603.3 |
605 | 2024-05-03 12:28:10 | stations | 3 | 146162 | 379 | 13.580 | 10763.0 |
604 | 2024-04-29 05:12:20 | stations | 1 | 82945 | 3 | 1.500 | 55296.7 |
603 | 2024-04-27 06:11:18 | stations | 1 | 82945 | 3 | 1.860 | 44594.1 |
602 | 2024-04-21 15:25:32 | stations | 2 | 121059 | 55 | 11.093 | 10913.1 |
601 | 2024-04-04 06:52:24 | stations | 3 | 146162 | 379 | 9.313 | 15694.4 |
600 | 2024-03-31 21:16:18 | stations | 2 | 121059 | 55 | 4.576 | 26455.2 |
599 | 2024-03-30 06:46:17 | stations | 2 | 121059 | 55 | 9.096 | 13309.0 |
598 | 2024-03-30 05:37:55 | stations | 1 | 82945 | 3 | 1.530 | 54212.4 |
597 | 2024-03-29 19:43:24 | stations | 1 | 82945 | 3 | 1.686 | 49196.3 |
596 | 2024-03-27 16:56:52 | stations | 3 | 146162 | 379 | 13.670 | 10692.2 |
595 | 2024-03-26 08:37:33 | stations | 2 | 121059 | 55 | 11.453 | 10570.1 |
594 | 2024-03-25 23:43:35 | stations | 3 | 146162 | 379 | 20.330 | 7189.5 |
593 | 2024-03-25 05:03:29 | stations | 2 | 121059 | 55 | 3.280 | 36908.2 |
592 | 2024-03-25 04:48:14 | stations | 3 | 146162 | 379 | 8.250 | 17716.6 |
591 | 2024-03-23 06:53:40 | stations | 1 | 82945 | 3 | 1.423 | 58288.8 |
590 | 2024-03-23 06:51:54 | stations | 3 | 146162 | 379 | 7.986 | 18302.3 |
589 | 2024-03-23 06:51:54 | stations | 2 | 121059 | 55 | 4.156 | 29128.7 |
588 | 2024-03-05 22:41:09 | stations | 1 | 82945 | 3 | 5.000 | 16589.0 |
587 | 2024-03-01 18:44:02 | stations | 3 | 146162 | 379 | 18.706 | 7813.6 |
586 | 2024-03-01 13:55:02 | stations | 3 | 146162 | 379 | 15.750 | 9280.1 |
585 | 2024-03-01 08:25:41 | stations | 3 | 146162 | 379 | 8.576 | 17043.1 |
584 | 2024-02-28 07:00:49 | stations | 1 | 82945 | 3 | 3.000 | 27648.3 |
583 | 2024-02-08 01:04:42 | stations | 2 | 121059 | 55 | 4.343 | 27874.5 |
582 | 2024-02-06 01:49:54 | stations | 2 | 121059 | 55 | 3.673 | 32959.2 |
581 | 2024-02-06 01:49:14 | stations | 3 | 146162 | 379 | 7.483 | 19532.5 |
580 | 2024-02-04 20:29:02 | stations | 3 | 146162 | 379 | 9.076 | 16104.2 |
579 | 2024-02-04 07:08:59 | stations | 3 | 146162 | 379 | 6.733 | 21708.3 |
578 | 2024-02-04 07:08:55 | stations | 2 | 121059 | 55 | 3.936 | 30756.9 |
577 | 2024-01-31 06:13:59 | stations | 2 | 121059 | 55 | 3.470 | 34887.3 |
576 | 2024-01-31 04:21:10 | stations | 3 | 146162 | 379 | 6.983 | 20931.1 |
575 | 2024-01-30 22:44:23 | stations | 2 | 121059 | 55 | 4.013 | 30166.7 |
574 | 2024-01-30 22:38:43 | stations | 3 | 146162 | 379 | 8.673 | 16852.5 |
573 | 2024-01-15 19:34:58 | stations | 1 | 82945 | 3 | 2.203 | 37650.9 |
572 | 2024-01-09 11:36:51 | stations | 3 | 146162 | 379 | 7.360 | 19859.0 |
571 | 2024-01-05 03:46:30 | stations | 3 | 146162 | 379 | 6.576 | 22226.6 |
570 | 2024-01-05 03:46:28 | stations | 2 | 121059 | 55 | 3.530 | 34294.3 |
569 | 2024-01-02 00:52:29 | stations | 1 | 82945 | 3 | 1.390 | 59672.7 |
568 | 2023-12-27 12:38:00 | stations | 1 | 82945 | 3 | 1.516 | 54713.1 |
567 | 2023-12-24 08:00:16 | stations | 1 | 82945 | 3 | 1.516 | 54713.1 |
566 | 2023-12-15 06:43:44 | stations | 2 | 121059 | 55 | 3.483 | 34757.1 |
565 | 2023-12-14 16:09:56 | stations | 3 | 146162 | 379 | 14.436 | 10124.8 |
564 | 2023-12-13 15:06:02 | stations | 3 | 146162 | 379 | 6.640 | 22012.3 |
563 | 2023-12-13 13:33:32 | stations | 1 | 82945 | 3 | 1.313 | 63172.1 |
562 | 2023-12-11 22:57:32 | stations | 3 | 146162 | 379 | 6.470 | 22590.7 |
561 | 2023-12-08 11:53:51 | stations | 3 | 146162 | 379 | 7.546 | 19369.5 |
560 | 2023-12-06 00:36:01 | stations | 3 | 146162 | 379 | 8.296 | 17618.4 |
559 | 2023-11-28 04:38:31 | stations | 1 | 82945 | 3 | 1.280 | 64800.8 |
558 | 2023-11-26 01:42:08 | stations | 1 | 82945 | 3 | 1.280 | 64800.8 |
557 | 2023-11-20 02:52:17 | stations | 3 | 146162 | 379 | 6.623 | 22068.9 |
556 | 2023-11-15 12:38:46 | stations | 1 | 82945 | 3 | 1.326 | 62552.8 |
555 | 2023-11-15 03:48:00 | stations | 1 | 82945 | 3 | 1.313 | 63172.1 |
554 | 2023-11-11 11:29:49 | stations | 1 | 82945 | 3 | 1.483 | 55930.5 |
553 | 2023-11-05 05:09:54 | stations | 3 | 146162 | 379 | 6.420 | 22766.7 |
552 | 2023-11-01 06:10:04 | stations | 1 | 82945 | 3 | 1.280 | 64800.8 |
551 | 2023-10-22 17:03:03 | stations | 3 | 146162 | 379 | 7.250 | 20160.3 |
550 | 2023-10-14 14:39:30 | stations | 1 | 82945 | 3 | 1.560 | 53169.9 |
549 | 2023-10-06 11:17:44 | stations | 1 | 82945 | 3 | 1.343 | 61761.0 |
548 | 2023-09-29 00:18:30 | stations | 1 | 82945 | 3 | 1.313 | 63172.1 |
547 | 2023-09-22 02:15:58 | stations | 1 | 82945 | 3 | 1.296 | 64000.8 |
546 | 2023-09-21 04:45:49 | stations | 1 | 82945 | 3 | 1.296 | 64000.8 |
545 | 2023-09-15 08:52:55 | stations | 2 | 121059 | 55 | 3.703 | 32692.1 |
544 | 2023-09-11 13:39:20 | stations | 3 | 146162 | 379 | 8.203 | 17818.1 |
543 | 2023-09-07 05:32:35 | stations | 3 | 146162 | 379 | 7.453 | 19611.2 |
542 | 2023-09-01 10:53:33 | stations | 3 | 146162 | 379 | 7.203 | 20291.8 |
541 | 2023-08-30 23:38:01 | stations | 1 | 82945 | 3 | 1.296 | 64000.8 |
540 | 2023-06-15 00:53:34 | stations | 2 | 121059 | 55 | 3.686 | 32842.9 |
539 | 2023-06-11 16:03:54 | stations | 3 | 146162 | 379 | 7.453 | 19611.2 |
538 | 2023-06-07 08:22:29 | stations | 1 | 82945 | 3 | 1.296 | 64000.8 |
537 | 2023-06-04 06:38:36 | stations | 1 | 82945 | 3 | 1.250 | 66356.0 |
536 | 2023-05-28 21:03:45 | stations | 3 | 146162 | 379 | 6.280 | 23274.2 |
535 | 2023-04-17 06:58:11 | stations | 3 | 146162 | 379 | 6.703 | 21805.5 |
534 | 2023-04-13 08:38:09 | stations | 3 | 146162 | 379 | 6.983 | 20931.1 |
533 | 2023-04-12 08:35:07 | stations | 3 | 146162 | 379 | 7.280 | 20077.2 |
532 | 2023-04-11 08:30:52 | stations | 3 | 146162 | 379 | 8.126 | 17987.0 |
531 | 2023-04-10 08:27:58 | stations | 3 | 146162 | 379 | 6.703 | 21805.5 |
530 | 2023-04-09 08:29:41 | stations | 3 | 146162 | 379 | 7.076 | 20656.0 |
529 | 2023-04-08 08:37:08 | stations | 3 | 146162 | 379 | 7.596 | 19242.0 |
528 | 2023-04-07 08:24:39 | stations | 3 | 146162 | 379 | 7.843 | 18636.0 |
527 | 2023-04-06 09:50:43 | stations | 3 | 146162 | 379 | 6.783 | 21548.3 |
526 | 2023-04-05 09:49:36 | stations | 3 | 146162 | 379 | 6.720 | 21750.3 |
525 | 2023-04-04 09:04:23 | stations | 3 | 146162 | 379 | 6.533 | 22372.9 |
524 | 2023-04-03 23:17:39 | stations | 3 | 146162 | 379 | 6.846 | 21350.0 |
523 | 2023-04-03 08:26:35 | stations | 3 | 146162 | 379 | 6.313 | 23152.5 |
522 | 2023-04-02 08:20:00 | stations | 3 | 146162 | 379 | 7.606 | 19216.7 |
521 | 2023-04-01 08:19:55 | stations | 3 | 146162 | 379 | 7.860 | 18595.7 |
520 | 2023-03-31 08:17:48 | stations | 3 | 146162 | 379 | 6.373 | 22934.6 |
519 | 2023-03-30 08:09:12 | stations | 3 | 146162 | 379 | 7.626 | 19166.3 |