History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roads"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
705 | 2024-04-19 08:07:29 | roads | 1 | 28756 | 14 | 0.580 | 49579.3 |
704 | 2024-04-14 23:05:26 | roads | 1 | 28756 | 14 | 1.766 | 16283.1 |
703 | 2024-04-04 23:01:52 | roads | 1 | 28756 | 14 | 2.390 | 12031.8 |
702 | 2024-04-03 09:10:49 | roads | 1 | 28756 | 14 | 1.186 | 24246.2 |
701 | 2024-04-03 09:10:35 | roads | 2 | 53800 | 225 | 1.953 | 27547.4 |
700 | 2024-04-03 04:46:06 | roads | 2 | 53800 | 225 | 4.313 | 12473.9 |
699 | 2024-04-03 04:15:53 | roads | 1 | 28756 | 14 | 1.830 | 15713.7 |
698 | 2024-03-31 06:18:30 | roads | 2 | 53800 | 225 | 5.923 | 9083.2 |
697 | 2024-03-31 06:10:35 | roads | 1 | 28756 | 14 | 0.656 | 43835.4 |
696 | 2024-03-27 06:05:39 | roads | 1 | 28756 | 14 | 0.513 | 56054.6 |
695 | 2024-03-27 01:13:23 | roads | 2 | 53800 | 225 | 1.826 | 29463.3 |
694 | 2024-03-20 15:42:21 | roads | 1 | 28756 | 14 | 0.436 | 65954.1 |
693 | 2024-03-04 01:29:07 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
692 | 2024-03-01 10:41:05 | roads | 1 | 28756 | 14 | 1.483 | 19390.4 |
691 | 2024-03-01 02:58:56 | roads | 1 | 28756 | 14 | 0.563 | 51076.4 |
690 | 2024-02-29 07:59:42 | roads | 1 | 28756 | 14 | 0.530 | 54256.6 |
689 | 2024-02-28 13:39:32 | roads | 1 | 28756 | 14 | 0.530 | 54256.6 |
688 | 2024-02-28 12:35:07 | roads | 2 | 53800 | 225 | 1.420 | 37887.3 |
687 | 2024-02-27 12:18:15 | roads | 2 | 53800 | 225 | 1.546 | 34799.5 |
686 | 2024-02-27 01:32:56 | roads | 1 | 28756 | 14 | 0.560 | 51350.0 |
685 | 2024-02-26 04:22:51 | roads | 1 | 28756 | 14 | 0.563 | 51076.4 |
684 | 2024-02-26 03:58:45 | roads | 2 | 53800 | 225 | 2.423 | 22203.9 |
683 | 2024-02-26 03:35:50 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
682 | 2024-02-25 15:23:34 | roads | 1 | 28756 | 14 | 0.436 | 65954.1 |
681 | 2024-02-24 19:34:43 | roads | 1 | 28756 | 14 | 0.580 | 49579.3 |
680 | 2024-02-23 23:19:41 | roads | 1 | 28756 | 14 | 1.126 | 25538.2 |
679 | 2024-02-14 16:48:18 | roads | 2 | 53800 | 225 | 4.766 | 11288.3 |
678 | 2024-02-14 05:06:34 | roads | 2 | 53800 | 225 | 2.076 | 25915.2 |
677 | 2024-02-03 02:31:59 | roads | 1 | 28756 | 14 | 1.076 | 26724.9 |
676 | 2024-01-26 21:12:52 | roads | 1 | 28756 | 14 | 1.123 | 25606.4 |
675 | 2024-01-14 16:43:08 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
674 | 2024-01-02 20:12:12 | roads | 2 | 53800 | 225 | 1.436 | 37465.2 |
673 | 2023-12-25 01:54:47 | roads | 1 | 28756 | 14 | 0.516 | 55728.7 |
672 | 2023-12-23 08:29:13 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
671 | 2023-12-18 15:12:15 | roads | 2 | 53800 | 225 | 1.890 | 28465.6 |
670 | 2023-12-18 08:51:21 | roads | 1 | 28756 | 14 | 0.516 | 55728.7 |
669 | 2023-12-13 18:21:31 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
668 | 2023-12-13 09:38:42 | roads | 2 | 53800 | 225 | 1.470 | 36598.6 |
667 | 2023-12-05 09:45:30 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
666 | 2023-12-04 00:11:33 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
665 | 2023-12-03 06:37:07 | roads | 2 | 53800 | 225 | 1.423 | 37807.4 |
664 | 2023-12-03 06:37:05 | roads | 2 | 53800 | 225 | 1.580 | 34050.6 |
663 | 2023-12-02 19:48:36 | roads | 1 | 28756 | 14 | 0.530 | 54256.6 |
662 | 2023-12-01 18:53:50 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
661 | 2023-11-24 03:52:08 | roads | 1 | 28756 | 14 | 0.486 | 59168.7 |
660 | 2023-11-23 03:55:14 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
659 | 2023-11-21 08:01:21 | roads | 2 | 53800 | 225 | 1.453 | 37026.8 |
658 | 2023-11-13 15:48:29 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
657 | 2023-11-12 10:41:41 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
656 | 2023-11-07 00:54:01 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
655 | 2023-11-04 23:05:55 | roads | 1 | 28756 | 14 | 0.440 | 65354.5 |
654 | 2023-11-02 06:57:39 | roads | 1 | 28756 | 14 | 0.440 | 65354.5 |
653 | 2023-11-01 00:38:32 | roads | 1 | 28756 | 14 | 0.533 | 53951.2 |
652 | 2023-10-30 20:46:54 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
651 | 2023-10-28 18:09:25 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
650 | 2023-10-19 22:55:05 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
649 | 2023-10-19 21:42:18 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
648 | 2023-10-16 20:24:51 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
647 | 2023-10-06 07:15:56 | roads | 1 | 28756 | 14 | 0.483 | 59536.2 |
646 | 2023-09-27 01:52:30 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
645 | 2023-09-23 12:14:05 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
644 | 2023-09-18 05:13:39 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
643 | 2023-09-12 05:16:45 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
642 | 2023-08-21 14:52:34 | roads | 2 | 53800 | 225 | 1.546 | 34799.5 |
641 | 2023-07-15 16:56:07 | roads | 1 | 28756 | 14 | 0.516 | 55728.7 |
640 | 2023-07-14 22:45:04 | roads | 1 | 28756 | 14 | 0.500 | 57512.0 |
639 | 2023-07-11 21:18:46 | roads | 2 | 53800 | 225 | 1.436 | 37465.2 |
638 | 2023-06-04 08:28:06 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
637 | 2023-05-07 01:33:29 | roads | 2 | 53800 | 225 | 1.436 | 37465.2 |
636 | 2023-05-03 13:41:35 | roads | 2 | 53800 | 225 | 1.623 | 33148.5 |
635 | 2023-03-31 12:28:09 | roads | 2 | 53800 | 225 | 1.423 | 37807.4 |
634 | 2023-03-26 17:30:11 | roads | 2 | 53800 | 225 | 1.406 | 38264.6 |
633 | 2023-03-21 12:26:03 | roads | 2 | 53800 | 225 | 1.626 | 33087.3 |
632 | 2023-02-22 19:41:39 | roads | 1 | 28756 | 14 | 0.436 | 65954.1 |
631 | 2023-02-14 21:42:43 | roads | 2 | 53800 | 225 | 1.420 | 37887.3 |
630 | 2022-12-17 14:04:07 | roads | 1 | 28756 | 14 | 0.436 | 65954.1 |
629 | 2022-11-27 18:58:33 | roads | 2 | 53800 | 225 | 1.420 | 37887.3 |
628 | 2022-11-20 01:55:31 | roads | 1 | 28756 | 14 | 0.486 | 59168.7 |
627 | 2022-11-17 12:06:13 | roads | 1 | 28756 | 14 | 0.580 | 49579.3 |
626 | 2022-11-02 10:00:49 | roads | 1 | 28756 | 14 | 0.610 | 47141.0 |
625 | 2022-09-12 12:13:30 | roads | 1 | 28756 | 14 | 0.466 | 61708.2 |
624 | 2022-08-31 03:01:43 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
623 | 2022-08-26 11:07:42 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
622 | 2022-08-07 04:24:03 | roads | 1 | 28756 | 14 | 0.436 | 65954.1 |
621 | 2022-07-30 04:55:47 | roads | 1 | 28756 | 14 | 0.533 | 53951.2 |
620 | 2022-07-16 08:32:12 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
619 | 2022-07-03 11:48:59 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |
618 | 2022-06-16 11:48:28 | roads | 1 | 28756 | 14 | 0.450 | 63902.2 |
617 | 2022-05-26 03:42:32 | roads | 1 | 28756 | 14 | 0.450 | 63902.2 |
616 | 2022-04-19 11:11:54 | roads | 2 | 53800 | 225 | 1.436 | 37465.2 |
615 | 2022-04-17 07:34:18 | roads | 2 | 53800 | 225 | 1.423 | 37807.4 |
614 | 2022-04-15 18:37:58 | roads | 1 | 28756 | 14 | 0.470 | 61183.0 |
613 | 2022-03-19 02:13:16 | roads | 1 | 28756 | 14 | 0.483 | 59536.2 |
612 | 2022-01-13 14:56:38 | roads | 1 | 28756 | 14 | 0.483 | 59536.2 |
611 | 2021-12-22 18:38:02 | roads | 2 | 53800 | 225 | 1.610 | 33416.1 |
610 | 2021-12-11 12:10:38 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
609 | 2021-12-08 14:20:24 | roads | 1 | 28756 | 14 | 0.546 | 52666.7 |
608 | 2021-11-11 14:31:54 | roads | 1 | 28756 | 14 | 0.530 | 54256.6 |
607 | 2021-10-07 02:18:24 | roads | 2 | 53800 | 225 | 1.403 | 38346.4 |
606 | 2021-09-29 05:43:14 | roads | 1 | 28756 | 14 | 0.453 | 63479.0 |