History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"johns"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
920 | 2024-04-17 09:04:25 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
919 | 2024-04-03 04:42:00 | johns | 1 | 28756 | 4 | 1.670 | 17219.2 |
918 | 2024-03-31 01:15:12 | johns | 1 | 28756 | 4 | 1.093 | 26309.2 |
917 | 2024-03-29 09:16:30 | johns | 1 | 28756 | 4 | 0.440 | 65354.5 |
916 | 2024-03-28 19:20:52 | johns | 1 | 28756 | 4 | 1.780 | 16155.1 |
915 | 2024-03-06 11:36:35 | johns | 3 | 83667 | 1401 | 11.530 | 7256.5 |
914 | 2024-03-04 18:48:07 | johns | 3 | 83667 | 1401 | 4.390 | 19058.5 |
913 | 2024-03-04 12:01:49 | johns | 2 | 53800 | 78 | 1.500 | 35866.7 |
912 | 2024-03-04 12:01:48 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
911 | 2024-03-04 12:01:21 | johns | 3 | 83667 | 1401 | 6.093 | 13731.7 |
910 | 2024-03-03 20:49:20 | johns | 3 | 83667 | 1401 | 4.000 | 20916.8 |
909 | 2024-03-03 17:34:06 | johns | 3 | 83667 | 1401 | 4.626 | 18086.3 |
908 | 2024-02-28 07:32:46 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
907 | 2024-02-04 08:14:22 | johns | 2 | 53800 | 78 | 3.486 | 15433.2 |
906 | 2024-02-03 20:27:27 | johns | 2 | 53800 | 78 | 1.610 | 33416.1 |
905 | 2024-02-03 10:21:18 | johns | 2 | 53800 | 78 | 1.450 | 37103.4 |
904 | 2024-02-03 10:20:41 | johns | 3 | 83667 | 1401 | 4.093 | 20441.5 |
903 | 2024-01-30 13:29:55 | johns | 2 | 53800 | 78 | 1.313 | 40974.9 |
902 | 2024-01-30 13:28:51 | johns | 3 | 83667 | 1401 | 7.500 | 11155.6 |
901 | 2024-01-29 05:46:57 | johns | 1 | 28756 | 4 | 0.486 | 59168.7 |
900 | 2024-01-28 09:12:48 | johns | 3 | 83667 | 1401 | 3.406 | 24564.6 |
899 | 2024-01-23 00:51:11 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
898 | 2024-01-10 17:38:41 | johns | 3 | 83667 | 1401 | 3.716 | 22515.3 |
897 | 2024-01-10 17:38:42 | johns | 2 | 53800 | 78 | 1.580 | 34050.6 |
896 | 2024-01-09 05:35:09 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
895 | 2024-01-07 22:45:20 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
894 | 2023-12-14 10:57:29 | johns | 3 | 83667 | 1401 | 3.126 | 26764.9 |
893 | 2023-12-03 23:42:30 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
892 | 2023-12-03 23:42:29 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
891 | 2023-11-24 00:43:37 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
890 | 2023-11-21 14:49:10 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
889 | 2023-11-15 19:51:32 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
888 | 2023-11-03 16:30:28 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
887 | 2023-11-01 17:48:02 | johns | 1 | 28756 | 4 | 0.546 | 52666.7 |
886 | 2023-10-19 22:01:31 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
885 | 2023-10-19 17:56:53 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
884 | 2023-10-12 02:40:30 | johns | 1 | 28756 | 4 | 0.450 | 63902.2 |
883 | 2023-10-07 18:37:20 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
882 | 2023-09-30 05:20:21 | johns | 3 | 83667 | 1401 | 4.533 | 18457.3 |
881 | 2023-09-29 00:07:08 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
880 | 2023-09-28 17:50:53 | johns | 1 | 28756 | 4 | 0.940 | 30591.5 |
879 | 2023-09-27 20:45:05 | johns | 3 | 83667 | 1401 | 8.200 | 10203.3 |
878 | 2023-09-16 00:21:32 | johns | 1 | 28756 | 4 | 0.516 | 55728.7 |
877 | 2023-09-14 16:24:22 | johns | 3 | 83667 | 1401 | 4.016 | 20833.4 |
876 | 2023-08-23 12:01:42 | johns | 1 | 28756 | 4 | 0.450 | 63902.2 |
875 | 2023-06-18 10:49:08 | johns | 3 | 83667 | 1401 | 3.596 | 23266.7 |
874 | 2023-06-05 01:58:13 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
873 | 2023-05-26 07:41:12 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
872 | 2023-05-19 08:41:52 | johns | 3 | 83667 | 1401 | 3.670 | 22797.5 |
871 | 2023-04-09 08:23:18 | johns | 3 | 83667 | 1401 | 3.580 | 23370.7 |
870 | 2023-03-21 03:53:57 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
869 | 2023-03-16 20:06:51 | johns | 3 | 83667 | 1401 | 3.076 | 27199.9 |
868 | 2023-02-13 08:45:36 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
867 | 2023-01-29 14:54:20 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
866 | 2022-12-18 10:15:13 | johns | 3 | 83667 | 1401 | 3.610 | 23176.5 |
865 | 2022-12-14 20:57:07 | johns | 1 | 28756 | 4 | 1.016 | 28303.1 |
864 | 2022-11-30 02:15:11 | johns | 2 | 53800 | 78 | 1.296 | 41512.3 |
863 | 2022-11-10 17:29:20 | johns | 1 | 28756 | 4 | 0.513 | 56054.6 |
862 | 2022-10-28 22:59:58 | johns | 2 | 53800 | 78 | 1.330 | 40451.1 |
861 | 2022-10-20 12:38:17 | johns | 2 | 53800 | 78 | 1.486 | 36204.6 |
860 | 2022-10-19 20:09:49 | johns | 1 | 28756 | 4 | 0.466 | 61708.2 |
859 | 2022-09-21 11:12:01 | johns | 2 | 53800 | 78 | 1.313 | 40974.9 |
858 | 2022-09-19 08:44:08 | johns | 1 | 28756 | 4 | 0.516 | 55728.7 |
857 | 2022-08-23 06:02:45 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
856 | 2022-08-19 14:11:53 | johns | 3 | 83667 | 1401 | 3.153 | 26535.7 |
855 | 2022-08-14 16:33:19 | johns | 2 | 53800 | 78 | 1.326 | 40573.2 |
854 | 2022-08-14 14:40:29 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
853 | 2022-08-06 19:17:24 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
852 | 2022-07-30 00:17:30 | johns | 1 | 28756 | 4 | 0.466 | 61708.2 |
851 | 2022-07-28 21:40:10 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
850 | 2022-07-03 07:04:17 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
849 | 2022-06-28 14:55:03 | johns | 2 | 53800 | 78 | 1.643 | 32745.0 |
848 | 2022-06-25 18:11:47 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
847 | 2022-06-18 09:01:39 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
846 | 2022-06-16 07:06:33 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
845 | 2022-05-10 17:49:18 | johns | 1 | 28756 | 4 | 0.440 | 65354.5 |
844 | 2022-05-08 15:03:08 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
843 | 2022-02-17 04:50:32 | johns | 1 | 28756 | 4 | 0.470 | 61183.0 |
842 | 2022-01-25 09:02:20 | johns | 1 | 28756 | 4 | 0.466 | 61708.2 |
841 | 2022-01-21 10:28:38 | johns | 1 | 28756 | 4 | 0.453 | 63479.0 |
840 | 2022-01-20 08:45:59 | johns | 1 | 28756 | 4 | 0.546 | 52666.7 |
839 | 2022-01-19 15:18:29 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
838 | 2022-01-18 15:38:03 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
837 | 2021-11-25 23:55:07 | johns | 1 | 28756 | 4 | 0.436 | 65954.1 |
836 | 2021-11-18 18:36:52 | johns | 1 | 28756 | 4 | 0.530 | 54256.6 |
835 | 2021-10-26 17:04:51 | johns | 1 | 28756 | 4 | 1.030 | 27918.4 |
834 | 2021-10-20 23:13:26 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
833 | 2021-09-21 17:20:26 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
832 | 2021-09-20 15:11:22 | johns | 1 | 28756 | 4 | 0.500 | 57512.0 |
831 | 2021-09-13 18:27:14 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
830 | 2021-07-19 22:46:23 | johns | 1 | 28756 | 4 | 0.420 | 68466.7 |
829 | 2021-04-28 09:35:06 | johns | 1 | 28756 | 4 | 0.513 | 56054.6 |
828 | 2021-04-17 06:19:08 | johns | 1 | 28756 | 4 | 0.966 | 29768.1 |
827 | 2021-03-28 05:56:57 | johns | 1 | 28756 | 4 | 0.483 | 59536.2 |
826 | 2021-02-18 16:33:32 | johns | 1 | 28756 | 4 | 0.623 | 46157.3 |
825 | 2021-01-11 13:03:26 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
824 | 2020-12-30 21:17:12 | johns | 1 | 28756 | 4 | 0.423 | 67981.1 |
823 | 2020-11-11 02:20:32 | johns | 1 | 28756 | 4 | 0.440 | 65354.5 |
822 | 2020-11-06 06:09:03 | johns | 1 | 28756 | 4 | 0.486 | 59168.7 |
821 | 2020-11-02 12:07:45 | johns | 1 | 28756 | 4 | 0.516 | 55728.7 |