History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wigan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
970 | 2024-04-26 07:13:41 | wigan | 1 | 28756 | 4 | 1.076 | 26724.9 |
969 | 2024-04-04 20:02:25 | wigan | 3 | 83667 | 785 | 8.716 | 9599.2 |
968 | 2024-04-04 10:57:30 | wigan | 3 | 83667 | 785 | 3.406 | 24564.6 |
967 | 2024-04-03 06:56:11 | wigan | 1 | 28756 | 4 | 0.423 | 67981.1 |
966 | 2024-03-31 14:23:46 | wigan | 3 | 83667 | 785 | 10.860 | 7704.1 |
965 | 2024-03-31 14:23:41 | wigan | 2 | 53800 | 49 | 4.393 | 12246.8 |
964 | 2024-03-31 14:16:09 | wigan | 1 | 28756 | 4 | 0.530 | 54256.6 |
963 | 2024-03-29 09:28:55 | wigan | 1 | 28756 | 4 | 1.016 | 28303.1 |
962 | 2024-03-04 16:18:59 | wigan | 3 | 83667 | 785 | 10.173 | 8224.4 |
961 | 2024-03-03 23:49:43 | wigan | 3 | 83667 | 785 | 15.736 | 5316.9 |
960 | 2024-03-03 23:49:43 | wigan | 2 | 53800 | 49 | 1.860 | 28924.7 |
959 | 2024-03-03 22:03:47 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
958 | 2024-03-01 07:46:56 | wigan | 1 | 28756 | 4 | 0.533 | 53951.2 |
957 | 2024-02-28 11:23:52 | wigan | 2 | 53800 | 49 | 1.563 | 34421.0 |
956 | 2024-02-28 11:23:01 | wigan | 3 | 83667 | 785 | 3.936 | 21256.9 |
955 | 2024-02-28 08:58:34 | wigan | 3 | 83667 | 785 | 4.953 | 16892.2 |
954 | 2024-02-28 08:58:32 | wigan | 2 | 53800 | 49 | 5.283 | 10183.6 |
953 | 2024-02-28 08:09:52 | wigan | 1 | 28756 | 4 | 1.063 | 27051.7 |
952 | 2024-02-06 20:28:42 | wigan | 1 | 28756 | 4 | 0.423 | 67981.1 |
951 | 2024-02-03 01:14:21 | wigan | 1 | 28756 | 4 | 0.483 | 59536.2 |
950 | 2024-02-02 19:46:23 | wigan | 1 | 28756 | 4 | 0.546 | 52666.7 |
949 | 2024-01-29 04:52:43 | wigan | 1 | 28756 | 4 | 0.516 | 55728.7 |
948 | 2024-01-29 04:10:25 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
947 | 2024-01-18 06:24:16 | wigan | 1 | 28756 | 4 | 0.516 | 55728.7 |
946 | 2023-12-07 22:10:26 | wigan | 3 | 83667 | 785 | 3.716 | 22515.3 |
945 | 2023-12-07 18:31:01 | wigan | 1 | 28756 | 4 | 0.453 | 63479.0 |
944 | 2023-12-07 18:31:00 | wigan | 1 | 28756 | 4 | 0.516 | 55728.7 |
943 | 2023-11-22 08:15:54 | wigan | 1 | 28756 | 4 | 0.466 | 61708.2 |
942 | 2023-11-19 18:05:47 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
941 | 2023-11-12 20:38:03 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
940 | 2023-11-08 08:38:55 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
939 | 2023-11-03 16:11:18 | wigan | 1 | 28756 | 4 | 0.483 | 59536.2 |
938 | 2023-10-19 08:11:30 | wigan | 1 | 28756 | 4 | 0.440 | 65354.5 |
937 | 2023-10-14 14:31:15 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
936 | 2023-10-05 11:04:15 | wigan | 3 | 83667 | 785 | 3.186 | 26260.8 |
935 | 2023-10-05 04:50:03 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
934 | 2023-10-01 08:00:20 | wigan | 3 | 83667 | 785 | 4.186 | 19987.3 |
933 | 2023-09-28 04:46:48 | wigan | 3 | 83667 | 785 | 3.170 | 26393.4 |
932 | 2023-09-28 04:46:46 | wigan | 2 | 53800 | 49 | 1.356 | 39675.5 |
931 | 2023-09-26 12:42:41 | wigan | 1 | 28756 | 4 | 0.483 | 59536.2 |
930 | 2023-09-24 14:18:56 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
929 | 2023-09-05 11:23:40 | wigan | 3 | 83667 | 785 | 3.203 | 26121.4 |
928 | 2023-09-05 03:36:14 | wigan | 1 | 28756 | 4 | 0.420 | 68466.7 |
927 | 2023-09-02 11:08:07 | wigan | 3 | 83667 | 785 | 3.800 | 22017.6 |
926 | 2023-09-01 02:21:52 | wigan | 1 | 28756 | 4 | 0.420 | 68466.7 |
925 | 2023-06-05 05:31:53 | wigan | 1 | 28756 | 4 | 0.486 | 59168.7 |
924 | 2023-05-17 09:17:59 | wigan | 3 | 83667 | 785 | 3.156 | 26510.5 |
923 | 2023-05-12 08:39:40 | wigan | 3 | 83667 | 785 | 3.406 | 24564.6 |
922 | 2023-04-13 11:40:16 | wigan | 3 | 83667 | 785 | 3.156 | 26510.5 |
921 | 2023-04-13 00:33:05 | wigan | 1 | 28756 | 4 | 0.423 | 67981.1 |
920 | 2023-03-27 05:03:40 | wigan | 1 | 28756 | 4 | 0.423 | 67981.1 |
919 | 2023-03-17 04:03:36 | wigan | 3 | 83667 | 785 | 5.750 | 14550.8 |
918 | 2023-02-23 01:09:46 | wigan | 3 | 83667 | 785 | 3.110 | 26902.6 |
917 | 2023-01-10 18:16:00 | wigan | 1 | 28756 | 4 | 0.420 | 68466.7 |
916 | 2023-01-02 21:20:18 | wigan | 3 | 83667 | 785 | 3.673 | 22778.9 |
915 | 2022-12-04 14:43:30 | wigan | 3 | 83667 | 785 | 3.123 | 26790.6 |
914 | 2022-11-30 18:47:23 | wigan | 1 | 28756 | 4 | 0.420 | 68466.7 |
913 | 2022-11-29 02:28:20 | wigan | 3 | 83667 | 785 | 3.436 | 24350.1 |
912 | 2022-11-27 12:02:57 | wigan | 1 | 28756 | 4 | 0.470 | 61183.0 |
911 | 2022-11-18 22:56:44 | wigan | 3 | 83667 | 785 | 3.670 | 22797.5 |
910 | 2022-11-05 18:28:06 | wigan | 3 | 83667 | 785 | 7.280 | 11492.7 |
909 | 2022-10-14 04:57:33 | wigan | 1 | 28756 | 4 | 0.423 | 67981.1 |
908 | 2022-10-07 21:49:07 | wigan | 3 | 83667 | 785 | 3.423 | 24442.6 |
907 | 2022-09-01 02:12:44 | wigan | 3 | 83667 | 785 | 3.940 | 21235.3 |
906 | 2022-07-03 09:48:23 | wigan | 1 | 28756 | 4 | 0.436 | 65954.1 |
905 | 2022-06-05 20:31:53 | wigan | 3 | 83667 | 785 | 3.173 | 26368.4 |
904 | 2022-05-31 20:24:14 | wigan | 1 | 28756 | 4 | 0.440 | 65354.5 |
903 | 2022-05-08 08:20:17 | wigan | 3 | 83667 | 785 | 3.423 | 24442.6 |
902 | 2022-04-25 14:40:10 | wigan | 3 | 83667 | 785 | 3.843 | 21771.3 |
901 | 2022-04-18 21:11:37 | wigan | 3 | 83667 | 785 | 3.343 | 25027.5 |
900 | 2022-04-06 14:48:11 | wigan | 3 | 83667 | 785 | 3.826 | 21868.0 |
899 | 2022-03-20 18:27:30 | wigan | 3 | 83667 | 785 | 3.593 | 23286.1 |
898 | 2022-02-15 04:10:31 | wigan | 1 | 28756 | 4 | 0.470 | 61183.0 |
897 | 2022-02-06 12:24:27 | wigan | 1 | 28756 | 4 | 0.420 | 68466.7 |
896 | 2022-02-05 00:19:38 | wigan | 3 | 83667 | 785 | 4.656 | 17969.7 |
895 | 2022-02-01 11:41:02 | wigan | 3 | 83667 | 785 | 4.016 | 20833.4 |
894 | 2022-02-01 00:13:49 | wigan | 3 | 83667 | 785 | 3.123 | 26790.6 |
893 | 2022-01-28 00:15:52 | wigan | 3 | 83667 | 785 | 3.360 | 24900.9 |
892 | 2022-01-14 00:26:28 | wigan | 3 | 83667 | 785 | 3.576 | 23396.8 |
891 | 2021-12-31 05:02:08 | wigan | 3 | 83667 | 785 | 4.030 | 20761.0 |
890 | 2021-12-30 06:36:00 | wigan | 3 | 83667 | 785 | 7.266 | 11514.9 |
889 | 2021-12-29 05:24:56 | wigan | 3 | 83667 | 785 | 4.313 | 19398.8 |
888 | 2021-12-28 07:12:21 | wigan | 3 | 83667 | 785 | 4.110 | 20356.9 |
887 | 2021-12-27 05:32:08 | wigan | 3 | 83667 | 785 | 4.093 | 20441.5 |
886 | 2021-12-26 06:22:13 | wigan | 3 | 83667 | 785 | 4.360 | 19189.7 |
885 | 2021-12-25 06:14:35 | wigan | 3 | 83667 | 785 | 4.310 | 19412.3 |
884 | 2021-12-24 02:27:43 | wigan | 3 | 83667 | 785 | 3.860 | 21675.4 |
883 | 2021-12-18 03:00:46 | wigan | 3 | 83667 | 785 | 4.110 | 20356.9 |
882 | 2021-12-15 21:41:23 | wigan | 3 | 83667 | 785 | 3.766 | 22216.4 |
881 | 2021-12-02 09:39:47 | wigan | 1 | 28756 | 4 | 0.483 | 59536.2 |
880 | 2021-11-10 22:16:37 | wigan | 3 | 83667 | 785 | 4.250 | 19686.4 |
879 | 2021-10-26 20:02:43 | wigan | 3 | 83667 | 785 | 3.936 | 21256.9 |
878 | 2021-10-25 12:41:40 | wigan | 3 | 83667 | 785 | 3.596 | 23266.7 |
877 | 2021-10-24 12:48:54 | wigan | 3 | 83667 | 785 | 3.610 | 23176.5 |
876 | 2021-10-24 04:31:40 | wigan | 1 | 28756 | 4 | 1.016 | 28303.1 |
875 | 2021-10-23 09:44:26 | wigan | 3 | 83667 | 785 | 3.750 | 22311.2 |
874 | 2021-10-22 16:13:27 | wigan | 3 | 83667 | 785 | 3.660 | 22859.8 |
873 | 2021-10-02 08:34:16 | wigan | 3 | 83667 | 785 | 3.656 | 22884.8 |
872 | 2021-09-30 15:23:45 | wigan | 3 | 83667 | 785 | 3.233 | 25879.1 |
871 | 2021-09-29 16:29:30 | wigan | 3 | 83667 | 785 | 3.560 | 23502.0 |