History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lamps"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
789 | 2024-05-07 06:28:33 | lamps | 2 | 53800 | 228 | 1.923 | 27977.1 |
788 | 2024-05-07 03:58:53 | lamps | 2 | 53800 | 228 | 4.483 | 12000.9 |
787 | 2024-05-06 19:00:39 | lamps | 2 | 53800 | 228 | 2.466 | 21816.7 |
786 | 2024-05-04 07:53:15 | lamps | 1 | 28756 | 19 | 0.466 | 61708.2 |
785 | 2024-04-30 17:56:08 | lamps | 1 | 28756 | 19 | 1.093 | 26309.2 |
784 | 2024-04-28 11:12:11 | lamps | 1 | 28756 | 19 | 1.013 | 28387.0 |
783 | 2024-04-27 02:11:06 | lamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
782 | 2024-04-25 05:42:39 | lamps | 2 | 53800 | 228 | 1.563 | 34421.0 |
781 | 2024-04-14 17:51:41 | lamps | 2 | 53800 | 228 | 3.576 | 15044.7 |
780 | 2024-04-13 04:30:03 | lamps | 1 | 28756 | 19 | 0.546 | 52666.7 |
779 | 2024-04-03 04:13:49 | lamps | 1 | 28756 | 19 | 1.750 | 16432.0 |
778 | 2024-03-31 07:15:21 | lamps | 2 | 53800 | 228 | 4.530 | 11876.4 |
777 | 2024-03-31 07:08:20 | lamps | 1 | 28756 | 19 | 1.123 | 25606.4 |
776 | 2024-03-27 02:41:11 | lamps | 1 | 28756 | 19 | 1.763 | 16310.8 |
775 | 2024-03-05 13:16:16 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
774 | 2024-02-25 22:42:07 | lamps | 1 | 28756 | 19 | 1.703 | 16885.5 |
773 | 2024-01-26 20:11:37 | lamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
772 | 2024-01-13 12:35:53 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
771 | 2024-01-05 11:22:46 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
770 | 2023-12-27 11:10:11 | lamps | 2 | 53800 | 228 | 1.373 | 39184.3 |
769 | 2023-12-24 22:39:56 | lamps | 2 | 53800 | 228 | 1.690 | 31834.3 |
768 | 2023-12-15 06:33:53 | lamps | 2 | 53800 | 228 | 1.623 | 33148.5 |
767 | 2023-12-08 07:29:05 | lamps | 2 | 53800 | 228 | 1.500 | 35866.7 |
766 | 2023-12-08 07:29:03 | lamps | 2 | 53800 | 228 | 1.610 | 33416.1 |
765 | 2023-12-07 19:11:05 | lamps | 2 | 53800 | 228 | 1.440 | 37361.1 |
764 | 2023-12-07 19:11:03 | lamps | 2 | 53800 | 228 | 1.390 | 38705.0 |
763 | 2023-12-07 17:58:06 | lamps | 2 | 53800 | 228 | 1.593 | 33772.8 |
762 | 2023-11-30 06:48:03 | lamps | 2 | 53800 | 228 | 1.466 | 36698.5 |
761 | 2023-11-26 10:49:08 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
760 | 2023-11-23 19:11:19 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
759 | 2023-11-19 11:27:57 | lamps | 1 | 28756 | 19 | 0.470 | 61183.0 |
758 | 2023-11-12 16:56:43 | lamps | 1 | 28756 | 19 | 0.503 | 57169.0 |
757 | 2023-11-08 05:20:07 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
756 | 2023-10-28 06:36:25 | lamps | 1 | 28756 | 19 | 1.033 | 27837.4 |
755 | 2023-10-22 05:03:08 | lamps | 1 | 28756 | 19 | 0.486 | 59168.7 |
754 | 2023-10-20 14:30:19 | lamps | 1 | 28756 | 19 | 1.203 | 23903.6 |
753 | 2023-10-17 11:02:46 | lamps | 2 | 53800 | 228 | 6.300 | 8539.7 |
752 | 2023-10-13 02:40:09 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
751 | 2023-10-05 20:15:52 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
750 | 2023-09-27 18:51:10 | lamps | 1 | 28756 | 19 | 0.983 | 29253.3 |
749 | 2023-09-22 06:27:32 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
748 | 2023-09-14 07:56:36 | lamps | 2 | 53800 | 228 | 1.640 | 32804.9 |
747 | 2023-08-28 02:33:05 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
746 | 2023-08-02 16:50:08 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
745 | 2023-06-11 01:05:27 | lamps | 2 | 53800 | 228 | 1.406 | 38264.6 |
744 | 2023-05-31 05:41:46 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
743 | 2023-04-28 22:29:20 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
742 | 2023-03-24 18:07:36 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
741 | 2023-03-12 20:10:00 | lamps | 2 | 53800 | 228 | 1.546 | 34799.5 |
740 | 2023-01-20 09:39:41 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
739 | 2023-01-08 17:42:47 | lamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
738 | 2022-12-16 11:05:44 | lamps | 2 | 53800 | 228 | 1.546 | 34799.5 |
737 | 2022-10-15 07:26:40 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
736 | 2022-10-09 18:04:49 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
735 | 2022-09-10 16:21:47 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
734 | 2022-09-03 11:14:11 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
733 | 2022-08-10 14:08:19 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
732 | 2022-08-06 22:41:33 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
731 | 2022-08-06 21:56:06 | lamps | 2 | 53800 | 228 | 1.436 | 37465.2 |
730 | 2022-07-25 02:59:37 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
729 | 2022-07-17 23:21:54 | lamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
728 | 2022-07-03 09:03:30 | lamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
727 | 2022-06-30 18:52:12 | lamps | 1 | 28756 | 19 | 0.470 | 61183.0 |
726 | 2022-06-25 20:44:24 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
725 | 2022-06-17 03:38:49 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
724 | 2022-06-16 09:01:47 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
723 | 2022-06-08 22:31:34 | lamps | 1 | 28756 | 19 | 0.580 | 49579.3 |
722 | 2022-06-08 19:14:40 | lamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
721 | 2022-06-05 14:20:37 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
720 | 2022-06-04 02:58:28 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
719 | 2022-06-03 09:24:05 | lamps | 1 | 28756 | 19 | 0.470 | 61183.0 |
718 | 2022-06-01 21:12:49 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
717 | 2022-03-20 19:46:48 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
716 | 2022-03-17 09:10:20 | lamps | 1 | 28756 | 19 | 1.330 | 21621.1 |
715 | 2022-03-10 07:19:02 | lamps | 2 | 53800 | 228 | 1.483 | 36277.8 |
714 | 2022-02-13 07:36:51 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
713 | 2021-12-10 04:38:14 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
712 | 2021-12-06 22:05:00 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
711 | 2021-12-06 20:54:03 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
710 | 2021-10-22 10:40:35 | lamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
709 | 2021-09-12 11:45:53 | lamps | 1 | 28756 | 19 | 0.516 | 55728.7 |
708 | 2021-09-10 09:00:27 | lamps | 1 | 28756 | 19 | 0.483 | 59536.2 |
707 | 2021-09-02 20:30:28 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
706 | 2021-08-21 13:01:04 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
705 | 2021-06-14 14:23:02 | lamps | 1 | 28756 | 19 | 0.466 | 61708.2 |
704 | 2021-05-29 20:47:50 | lamps | 1 | 28756 | 19 | 0.533 | 53951.2 |
703 | 2021-03-24 20:54:20 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
702 | 2021-02-27 04:16:04 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
701 | 2021-02-16 14:30:19 | lamps | 1 | 28756 | 19 | 0.546 | 52666.7 |
700 | 2021-02-12 02:40:28 | lamps | 1 | 28756 | 19 | 0.500 | 57512.0 |
699 | 2021-02-11 12:47:09 | lamps | 1 | 28756 | 19 | 0.513 | 56054.6 |
698 | 2021-01-28 11:23:50 | lamps | 2 | 53800 | 228 | 2.876 | 18706.5 |
697 | 2021-01-07 15:33:31 | lamps | 1 | 28756 | 19 | 0.450 | 63902.2 |
696 | 2020-11-22 11:42:02 | lamps | 1 | 28756 | 19 | 0.436 | 65954.1 |
695 | 2020-10-29 16:16:54 | lamps | 1 | 28756 | 19 | 0.466 | 61708.2 |
694 | 2020-10-20 18:53:57 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
693 | 2020-10-19 08:57:18 | lamps | 2 | 53800 | 228 | 1.686 | 31909.8 |
692 | 2020-10-07 04:51:51 | lamps | 1 | 28756 | 19 | 0.453 | 63479.0 |
691 | 2020-09-05 18:35:43 | lamps | 1 | 28756 | 19 | 0.440 | 65354.5 |
690 | 2020-08-18 04:33:39 | lamps | 1 | 28756 | 19 | 0.873 | 32939.3 |