History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spray"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
778 | 2024-05-04 02:27:03 | spray | 1 | 28756 | 9 | 0.513 | 56054.6 |
777 | 2024-04-30 17:26:23 | spray | 1 | 28756 | 9 | 1.190 | 24164.7 |
776 | 2024-04-28 02:58:26 | spray | 1 | 28756 | 9 | 1.093 | 26309.2 |
775 | 2024-04-25 18:30:43 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
774 | 2024-04-20 18:53:13 | spray | 1 | 28756 | 9 | 1.626 | 17685.1 |
773 | 2024-04-12 17:42:08 | spray | 2 | 53800 | 113 | 1.640 | 32804.9 |
772 | 2024-04-04 19:55:13 | spray | 1 | 28756 | 9 | 2.220 | 12953.2 |
771 | 2024-04-04 04:35:05 | spray | 1 | 28756 | 9 | 0.546 | 52666.7 |
770 | 2024-04-03 05:47:16 | spray | 1 | 28756 | 9 | 1.110 | 25906.3 |
769 | 2024-03-31 18:05:05 | spray | 2 | 53800 | 113 | 10.126 | 5313.1 |
768 | 2024-03-31 13:51:40 | spray | 2 | 53800 | 113 | 5.860 | 9180.9 |
767 | 2024-03-31 13:49:15 | spray | 1 | 28756 | 9 | 1.750 | 16432.0 |
766 | 2024-03-28 18:45:32 | spray | 2 | 53800 | 113 | 1.860 | 28924.7 |
765 | 2024-03-28 18:21:02 | spray | 1 | 28756 | 9 | 1.080 | 26625.9 |
764 | 2024-03-15 22:36:29 | spray | 1 | 28756 | 9 | 1.343 | 21411.8 |
763 | 2024-03-15 22:35:59 | spray | 2 | 53800 | 113 | 3.623 | 14849.6 |
762 | 2024-03-15 22:35:41 | spray | 1 | 28756 | 9 | 0.533 | 53951.2 |
761 | 2024-03-05 17:53:09 | spray | 1 | 28756 | 9 | 1.106 | 26000.0 |
760 | 2024-03-04 04:23:56 | spray | 2 | 53800 | 113 | 1.656 | 32487.9 |
759 | 2024-03-04 00:35:14 | spray | 1 | 28756 | 9 | 0.533 | 53951.2 |
758 | 2024-03-01 11:50:21 | spray | 1 | 28756 | 9 | 0.546 | 52666.7 |
757 | 2024-02-25 18:07:24 | spray | 1 | 28756 | 9 | 0.593 | 48492.4 |
756 | 2024-02-13 13:27:34 | spray | 2 | 53800 | 113 | 2.453 | 21932.3 |
755 | 2024-02-13 10:54:16 | spray | 1 | 28756 | 9 | 0.546 | 52666.7 |
754 | 2024-02-02 21:21:31 | spray | 1 | 28756 | 9 | 0.466 | 61708.2 |
753 | 2024-01-28 23:25:43 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
752 | 2024-01-25 23:10:13 | spray | 1 | 28756 | 9 | 0.516 | 55728.7 |
751 | 2024-01-13 23:10:00 | spray | 1 | 28756 | 9 | 0.513 | 56054.6 |
750 | 2023-12-25 06:04:19 | spray | 1 | 28756 | 9 | 0.516 | 55728.7 |
749 | 2023-12-25 04:34:41 | spray | 1 | 28756 | 9 | 0.450 | 63902.2 |
748 | 2023-12-24 00:48:46 | spray | 2 | 53800 | 113 | 1.390 | 38705.0 |
747 | 2023-12-13 15:58:33 | spray | 2 | 53800 | 113 | 1.483 | 36277.8 |
746 | 2023-12-03 09:42:39 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
745 | 2023-12-03 09:42:38 | spray | 1 | 28756 | 9 | 0.450 | 63902.2 |
744 | 2023-11-26 17:51:47 | spray | 2 | 53800 | 113 | 1.373 | 39184.3 |
743 | 2023-11-25 14:15:49 | spray | 1 | 28756 | 9 | 0.453 | 63479.0 |
742 | 2023-11-12 20:20:26 | spray | 1 | 28756 | 9 | 0.440 | 65354.5 |
741 | 2023-11-04 10:38:16 | spray | 1 | 28756 | 9 | 0.516 | 55728.7 |
740 | 2023-10-27 11:30:36 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
739 | 2023-10-20 20:50:19 | spray | 2 | 53800 | 113 | 3.686 | 14595.8 |
738 | 2023-10-20 20:40:59 | spray | 1 | 28756 | 9 | 0.720 | 39938.9 |
737 | 2023-10-17 22:05:20 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
736 | 2023-10-17 21:57:02 | spray | 2 | 53800 | 113 | 3.686 | 14595.8 |
735 | 2023-10-16 07:43:56 | spray | 2 | 53800 | 113 | 1.563 | 34421.0 |
734 | 2023-10-13 02:50:19 | spray | 1 | 28756 | 9 | 0.513 | 56054.6 |
733 | 2023-10-12 13:28:30 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
732 | 2023-10-04 10:05:24 | spray | 1 | 28756 | 9 | 0.483 | 59536.2 |
731 | 2023-09-22 16:39:40 | spray | 1 | 28756 | 9 | 0.483 | 59536.2 |
730 | 2023-09-12 11:15:16 | spray | 1 | 28756 | 9 | 0.440 | 65354.5 |
729 | 2023-09-10 23:39:41 | spray | 2 | 53800 | 113 | 1.390 | 38705.0 |
728 | 2023-08-22 16:13:14 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
727 | 2023-08-18 05:43:26 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
726 | 2023-08-08 12:31:16 | spray | 1 | 28756 | 9 | 0.453 | 63479.0 |
725 | 2023-05-24 02:55:46 | spray | 2 | 53800 | 113 | 1.436 | 37465.2 |
724 | 2023-05-09 02:42:24 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
723 | 2023-05-01 13:31:37 | spray | 1 | 28756 | 9 | 0.440 | 65354.5 |
722 | 2023-03-05 17:59:44 | spray | 1 | 28756 | 9 | 0.483 | 59536.2 |
721 | 2023-03-01 17:36:13 | spray | 2 | 53800 | 113 | 1.343 | 40059.6 |
720 | 2023-01-11 20:00:39 | spray | 1 | 28756 | 9 | 0.470 | 61183.0 |
719 | 2022-12-27 19:59:40 | spray | 1 | 28756 | 9 | 0.440 | 65354.5 |
718 | 2022-12-09 11:08:12 | spray | 2 | 53800 | 113 | 1.513 | 35558.5 |
717 | 2022-09-14 05:37:00 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
716 | 2022-09-10 21:27:43 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
715 | 2022-09-06 09:46:12 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
714 | 2022-08-26 10:14:26 | spray | 1 | 28756 | 9 | 0.470 | 61183.0 |
713 | 2022-07-29 07:03:02 | spray | 1 | 28756 | 9 | 0.470 | 61183.0 |
712 | 2022-07-27 13:50:37 | spray | 1 | 28756 | 9 | 0.453 | 63479.0 |
711 | 2022-07-22 09:21:16 | spray | 2 | 53800 | 113 | 1.360 | 39558.8 |
710 | 2022-07-13 23:07:52 | spray | 1 | 28756 | 9 | 0.453 | 63479.0 |
709 | 2022-07-02 21:58:23 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
708 | 2022-06-08 03:55:05 | spray | 1 | 28756 | 9 | 0.453 | 63479.0 |
707 | 2022-06-07 08:58:57 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
706 | 2022-04-30 13:17:09 | spray | 1 | 28756 | 9 | 0.440 | 65354.5 |
705 | 2022-04-26 23:39:43 | spray | 1 | 28756 | 9 | 0.546 | 52666.7 |
704 | 2022-03-11 21:04:23 | spray | 1 | 28756 | 9 | 0.453 | 63479.0 |
703 | 2022-01-10 07:45:21 | spray | 1 | 28756 | 9 | 0.450 | 63902.2 |
702 | 2021-12-22 06:07:26 | spray | 1 | 28756 | 9 | 0.470 | 61183.0 |
701 | 2021-10-23 02:39:37 | spray | 1 | 28756 | 9 | 0.516 | 55728.7 |
700 | 2021-09-27 18:24:08 | spray | 1 | 28756 | 9 | 0.483 | 59536.2 |
699 | 2021-09-15 08:19:43 | spray | 1 | 28756 | 9 | 0.486 | 59168.7 |
698 | 2021-08-28 18:43:12 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
697 | 2021-08-26 13:56:59 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
696 | 2021-06-28 02:13:30 | spray | 1 | 28756 | 9 | 0.530 | 54256.6 |
695 | 2021-06-16 22:06:52 | spray | 1 | 28756 | 9 | 0.576 | 49923.6 |
694 | 2021-04-06 10:15:48 | spray | 1 | 28756 | 9 | 0.516 | 55728.7 |
693 | 2021-04-05 10:00:31 | spray | 1 | 28756 | 9 | 0.516 | 55728.7 |
692 | 2021-04-04 19:43:46 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
691 | 2021-04-01 18:29:21 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
690 | 2021-03-31 15:44:04 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
689 | 2021-03-31 00:33:46 | spray | 1 | 28756 | 9 | 0.483 | 59536.2 |
688 | 2021-03-30 08:30:23 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
687 | 2021-03-29 18:03:10 | spray | 1 | 28756 | 9 | 0.530 | 54256.6 |
686 | 2021-03-27 09:14:18 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |
685 | 2021-03-23 00:24:07 | spray | 1 | 28756 | 9 | 0.486 | 59168.7 |
684 | 2021-03-19 02:11:01 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
683 | 2021-03-07 18:47:12 | spray | 2 | 53800 | 113 | 1.373 | 39184.3 |
682 | 2021-03-01 17:44:13 | spray | 1 | 28756 | 9 | 0.483 | 59536.2 |
681 | 2021-02-21 16:19:29 | spray | 2 | 53800 | 113 | 1.393 | 38621.7 |
680 | 2021-02-18 10:04:16 | spray | 1 | 28756 | 9 | 0.500 | 57512.0 |
679 | 2021-02-17 20:24:28 | spray | 1 | 28756 | 9 | 0.436 | 65954.1 |