History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shops"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
771 | 2024-04-25 20:48:27 | shops | 1 | 28756 | 16 | 0.750 | 38341.3 |
770 | 2024-04-03 08:26:29 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
769 | 2024-04-03 08:26:21 | shops | 2 | 53800 | 229 | 3.453 | 15580.7 |
768 | 2024-04-03 04:45:48 | shops | 2 | 53800 | 229 | 1.956 | 27505.1 |
767 | 2024-04-03 04:38:16 | shops | 1 | 28756 | 16 | 0.576 | 49923.6 |
766 | 2024-04-01 17:38:42 | shops | 1 | 28756 | 16 | 1.716 | 16757.6 |
765 | 2024-03-31 02:42:37 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
764 | 2024-03-03 20:56:49 | shops | 1 | 28756 | 16 | 0.533 | 53951.2 |
763 | 2024-03-02 14:27:41 | shops | 1 | 28756 | 16 | 1.640 | 17534.1 |
762 | 2024-02-25 17:50:37 | shops | 1 | 28756 | 16 | 1.126 | 25538.2 |
761 | 2024-02-19 20:59:23 | shops | 1 | 28756 | 16 | 0.580 | 49579.3 |
760 | 2024-02-05 08:02:42 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
759 | 2024-01-29 20:51:13 | shops | 1 | 28756 | 16 | 0.436 | 65954.1 |
758 | 2024-01-26 11:56:53 | shops | 1 | 28756 | 16 | 1.126 | 25538.2 |
757 | 2024-01-23 05:52:00 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
756 | 2024-01-02 05:33:48 | shops | 2 | 53800 | 229 | 1.546 | 34799.5 |
755 | 2023-12-11 10:45:51 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
754 | 2023-12-04 11:44:31 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
753 | 2023-12-04 11:44:30 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
752 | 2023-12-04 08:07:05 | shops | 2 | 53800 | 229 | 1.563 | 34421.0 |
751 | 2023-11-28 17:30:20 | shops | 1 | 28756 | 16 | 0.450 | 63902.2 |
750 | 2023-11-19 10:54:24 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
749 | 2023-11-13 21:55:41 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
748 | 2023-10-28 04:24:04 | shops | 2 | 53800 | 229 | 1.423 | 37807.4 |
747 | 2023-10-28 00:29:13 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
746 | 2023-10-19 20:40:05 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
745 | 2023-10-19 08:45:33 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
744 | 2023-10-17 03:21:30 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
743 | 2023-10-13 13:39:49 | shops | 1 | 28756 | 16 | 0.436 | 65954.1 |
742 | 2023-10-09 03:50:23 | shops | 2 | 53800 | 229 | 1.563 | 34421.0 |
741 | 2023-10-03 15:21:22 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
740 | 2023-09-26 02:09:17 | shops | 1 | 28756 | 16 | 1.063 | 27051.7 |
739 | 2023-09-25 13:50:48 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
738 | 2023-09-20 11:49:26 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
737 | 2023-09-17 20:09:36 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
736 | 2023-09-15 08:49:59 | shops | 1 | 28756 | 16 | 0.466 | 61708.2 |
735 | 2023-09-12 23:15:38 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
734 | 2023-08-18 17:38:56 | shops | 1 | 28756 | 16 | 0.486 | 59168.7 |
733 | 2023-08-17 04:23:41 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
732 | 2023-07-03 17:50:06 | shops | 1 | 28756 | 16 | 0.486 | 59168.7 |
731 | 2023-05-11 17:11:07 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
730 | 2023-04-11 20:15:24 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
729 | 2023-02-03 03:07:07 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
728 | 2023-02-01 22:21:37 | shops | 1 | 28756 | 16 | 0.436 | 65954.1 |
727 | 2022-12-02 01:03:41 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
726 | 2022-10-23 22:13:16 | shops | 2 | 53800 | 229 | 1.343 | 40059.6 |
725 | 2022-10-15 07:57:40 | shops | 1 | 28756 | 16 | 0.483 | 59536.2 |
724 | 2022-09-10 08:29:23 | shops | 2 | 53800 | 229 | 1.390 | 38705.0 |
723 | 2022-09-06 00:19:42 | shops | 2 | 53800 | 229 | 1.546 | 34799.5 |
722 | 2022-09-02 14:58:48 | shops | 2 | 53800 | 229 | 1.390 | 38705.0 |
721 | 2022-07-29 06:07:34 | shops | 2 | 53800 | 229 | 1.593 | 33772.8 |
720 | 2022-07-29 05:19:34 | shops | 1 | 28756 | 16 | 0.470 | 61183.0 |
719 | 2022-07-29 04:03:38 | shops | 1 | 28756 | 16 | 0.436 | 65954.1 |
718 | 2022-07-02 17:27:37 | shops | 1 | 28756 | 16 | 0.456 | 63061.4 |
717 | 2022-05-18 17:17:21 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
716 | 2022-05-18 06:31:14 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
715 | 2022-05-17 16:09:13 | shops | 1 | 28756 | 16 | 0.513 | 56054.6 |
714 | 2022-05-16 22:28:10 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
713 | 2022-05-16 10:17:55 | shops | 1 | 28756 | 16 | 0.656 | 43835.4 |
712 | 2022-05-15 20:49:38 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
711 | 2022-05-14 03:33:13 | shops | 1 | 28756 | 16 | 0.640 | 44931.3 |
710 | 2022-05-13 20:32:24 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
709 | 2022-05-13 10:37:06 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
708 | 2022-05-13 01:21:01 | shops | 1 | 28756 | 16 | 0.703 | 40904.7 |
707 | 2022-05-12 12:12:05 | shops | 1 | 28756 | 16 | 0.560 | 51350.0 |
706 | 2022-03-25 21:33:40 | shops | 1 | 28756 | 16 | 0.470 | 61183.0 |
705 | 2022-03-15 15:44:44 | shops | 1 | 28756 | 16 | 0.440 | 65354.5 |
704 | 2022-03-11 19:17:26 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
703 | 2022-03-08 23:24:58 | shops | 1 | 28756 | 16 | 0.513 | 56054.6 |
702 | 2022-03-03 19:17:31 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
701 | 2022-03-01 16:48:12 | shops | 1 | 28756 | 16 | 0.610 | 47141.0 |
700 | 2022-03-01 00:10:25 | shops | 1 | 28756 | 16 | 1.033 | 27837.4 |
699 | 2022-02-28 10:53:24 | shops | 1 | 28756 | 16 | 0.610 | 47141.0 |
698 | 2022-02-27 16:18:24 | shops | 1 | 28756 | 16 | 0.530 | 54256.6 |
697 | 2022-02-27 02:58:47 | shops | 1 | 28756 | 16 | 0.450 | 63902.2 |
696 | 2022-02-26 10:37:05 | shops | 1 | 28756 | 16 | 0.580 | 49579.3 |
695 | 2022-02-25 19:37:01 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
694 | 2022-02-25 10:54:12 | shops | 1 | 28756 | 16 | 0.640 | 44931.3 |
693 | 2022-01-17 18:35:45 | shops | 1 | 28756 | 16 | 0.470 | 61183.0 |
692 | 2022-01-17 03:45:58 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
691 | 2022-01-16 13:17:47 | shops | 1 | 28756 | 16 | 0.953 | 30174.2 |
690 | 2022-01-16 03:39:30 | shops | 1 | 28756 | 16 | 0.436 | 65954.1 |
689 | 2022-01-15 19:36:22 | shops | 1 | 28756 | 16 | 0.516 | 55728.7 |
688 | 2022-01-15 11:46:49 | shops | 1 | 28756 | 16 | 1.050 | 27386.7 |
687 | 2022-01-14 20:33:29 | shops | 1 | 28756 | 16 | 0.516 | 55728.7 |
686 | 2022-01-14 13:03:25 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
685 | 2022-01-13 21:52:49 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
684 | 2022-01-05 02:25:41 | shops | 1 | 28756 | 16 | 0.470 | 61183.0 |
683 | 2022-01-02 23:19:37 | shops | 1 | 28756 | 16 | 0.453 | 63479.0 |
682 | 2021-12-14 06:39:12 | shops | 1 | 28756 | 16 | 0.953 | 30174.2 |
681 | 2021-12-13 20:59:56 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
680 | 2021-12-13 09:27:59 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
679 | 2021-12-12 18:23:52 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
678 | 2021-12-12 08:27:11 | shops | 1 | 28756 | 16 | 0.516 | 55728.7 |
677 | 2021-12-11 20:44:03 | shops | 1 | 28756 | 16 | 0.513 | 56054.6 |
676 | 2021-12-08 13:52:02 | shops | 1 | 28756 | 16 | 0.513 | 56054.6 |
675 | 2021-12-08 01:59:03 | shops | 1 | 28756 | 16 | 0.516 | 55728.7 |
674 | 2021-12-07 15:41:29 | shops | 1 | 28756 | 16 | 0.546 | 52666.7 |
673 | 2021-12-07 06:50:09 | shops | 1 | 28756 | 16 | 0.500 | 57512.0 |
672 | 2021-12-06 13:07:49 | shops | 1 | 28756 | 16 | 0.516 | 55728.7 |