History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bostons"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
973 | 2025-01-02 15:15:59 | bostons | 1 | 69583 | 4 | 3.390 | 20526.0 |
972 | 2024-12-28 13:52:51 | bostons | 3 | 134027 | 397 | 22.843 | 5867.3 |
971 | 2024-12-10 22:10:19 | bostons | 3 | 134027 | 397 | 43.346 | 3092.0 |
970 | 2024-12-10 22:10:19 | bostons | 2 | 107671 | 30 | 24.423 | 4408.6 |
969 | 2024-12-10 17:52:13 | bostons | 2 | 107671 | 30 | 20.076 | 5363.2 |
968 | 2024-12-10 17:48:26 | bostons | 3 | 134027 | 397 | 6.626 | 20227.4 |
967 | 2024-12-10 01:45:46 | bostons | 3 | 134027 | 397 | 17.343 | 7728.0 |
966 | 2024-12-10 00:29:01 | bostons | 3 | 134027 | 397 | 7.826 | 17125.9 |
965 | 2024-12-09 22:15:13 | bostons | 3 | 134027 | 397 | 23.893 | 5609.5 |
964 | 2024-12-09 16:54:07 | bostons | 1 | 69583 | 4 | 5.843 | 11908.8 |
963 | 2024-12-09 15:25:10 | bostons | 1 | 69583 | 4 | 6.686 | 10407.3 |
962 | 2024-12-02 13:00:45 | bostons | 1 | 69583 | 4 | 7.360 | 9454.2 |
961 | 2024-11-08 03:09:27 | bostons | 1 | 69583 | 4 | 7.110 | 9786.6 |
960 | 2024-11-06 02:29:34 | bostons | 3 | 134027 | 397 | 22.690 | 5906.9 |
959 | 2024-11-04 23:13:17 | bostons | 1 | 69583 | 4 | 3.750 | 18555.5 |
958 | 2024-10-23 14:26:50 | bostons | 1 | 69583 | 4 | 3.190 | 21812.9 |
957 | 2024-10-22 12:01:12 | bostons | 3 | 134027 | 397 | 37.033 | 3619.1 |
956 | 2024-10-22 12:01:28 | bostons | 2 | 107671 | 30 | 16.673 | 6457.8 |
955 | 2024-10-21 00:02:29 | bostons | 3 | 134027 | 397 | 36.283 | 3693.9 |
954 | 2024-10-20 23:59:30 | bostons | 3 | 134027 | 397 | 36.644 | 3657.5 |
953 | 2024-10-20 19:18:42 | bostons | 3 | 134027 | 397 | 42.626 | 3144.3 |
952 | 2024-10-20 19:18:40 | bostons | 2 | 107671 | 30 | 15.063 | 7148.0 |
951 | 2024-10-20 19:14:03 | bostons | 1 | 69583 | 4 | 5.920 | 11753.9 |
950 | 2024-09-29 20:54:20 | bostons | 1 | 69583 | 4 | 6.546 | 10629.9 |
949 | 2024-09-08 09:46:10 | bostons | 1 | 69583 | 4 | 7.733 | 8998.2 |
948 | 2024-09-05 05:31:24 | bostons | 1 | 69583 | 4 | 4.356 | 15974.1 |
947 | 2024-08-16 06:33:55 | bostons | 1 | 69583 | 4 | 7.876 | 8834.8 |
946 | 2024-08-15 16:38:42 | bostons | 1 | 69583 | 4 | 8.736 | 7965.1 |
945 | 2024-08-14 10:55:04 | bostons | 1 | 69583 | 4 | 5.156 | 13495.5 |
944 | 2024-07-31 14:54:13 | bostons | 1 | 69583 | 4 | 6.000 | 11597.2 |
943 | 2024-07-19 00:26:26 | bostons | 1 | 69583 | 4 | 5.640 | 12337.4 |
942 | 2024-07-17 15:09:08 | bostons | 1 | 69583 | 4 | 5.356 | 12991.6 |
941 | 2024-07-17 06:39:23 | bostons | 1 | 69583 | 4 | 4.720 | 14742.2 |
940 | 2024-07-06 15:34:48 | bostons | 1 | 69583 | 4 | 5.016 | 13872.2 |
939 | 2024-07-01 16:24:37 | bostons | 1 | 69583 | 4 | 4.360 | 15959.4 |
938 | 2024-07-01 08:43:44 | bostons | 1 | 69583 | 4 | 6.250 | 11133.3 |
937 | 2024-06-30 01:39:11 | bostons | 1 | 69583 | 4 | 3.860 | 18026.7 |
936 | 2024-06-27 14:22:30 | bostons | 1 | 69583 | 4 | 6.250 | 11133.3 |
935 | 2024-06-25 09:42:26 | bostons | 1 | 69583 | 4 | 3.610 | 19275.1 |
934 | 2024-06-23 13:19:53 | bostons | 1 | 69583 | 4 | 4.376 | 15901.1 |
933 | 2024-06-22 02:28:15 | bostons | 3 | 134027 | 397 | 22.296 | 6011.3 |
932 | 2024-06-21 11:26:20 | bostons | 3 | 134027 | 397 | 25.050 | 5350.4 |
931 | 2024-06-21 04:04:45 | bostons | 3 | 134027 | 397 | 36.173 | 3705.2 |
930 | 2024-06-21 03:36:19 | bostons | 3 | 134027 | 397 | 37.410 | 3582.7 |
929 | 2024-06-21 01:17:29 | bostons | 3 | 134027 | 397 | 7.763 | 17264.8 |
928 | 2024-06-19 15:33:54 | bostons | 1 | 69583 | 4 | 4.080 | 17054.7 |
927 | 2024-06-08 17:53:29 | bostons | 1 | 69583 | 4 | 3.206 | 21704.0 |
926 | 2024-05-06 23:15:50 | bostons | 1 | 69583 | 4 | 2.626 | 26497.7 |
925 | 2024-04-28 04:45:48 | bostons | 1 | 69583 | 4 | 2.813 | 24736.2 |
924 | 2024-04-08 04:21:21 | bostons | 1 | 69583 | 4 | 1.126 | 61796.6 |
923 | 2024-04-06 19:33:30 | bostons | 1 | 69583 | 4 | 3.436 | 20251.2 |
922 | 2024-03-19 15:28:33 | bostons | 2 | 107671 | 30 | 3.203 | 33615.7 |
921 | 2024-02-27 11:35:08 | bostons | 1 | 69583 | 4 | 1.283 | 54234.6 |
920 | 2024-02-01 03:51:55 | bostons | 3 | 134027 | 397 | 14.263 | 9396.8 |
919 | 2024-01-29 14:08:32 | bostons | 3 | 134027 | 397 | 12.750 | 10511.9 |
918 | 2024-01-26 12:09:45 | bostons | 3 | 134027 | 397 | 6.486 | 20664.0 |
917 | 2024-01-26 11:35:01 | bostons | 3 | 134027 | 397 | 11.190 | 11977.4 |
916 | 2024-01-17 03:45:16 | bostons | 1 | 69583 | 4 | 1.076 | 64668.2 |
915 | 2024-01-09 09:55:14 | bostons | 1 | 69583 | 4 | 1.110 | 62687.4 |
914 | 2024-01-09 06:45:11 | bostons | 3 | 134027 | 397 | 6.186 | 21666.2 |
913 | 2024-01-06 03:04:44 | bostons | 1 | 69583 | 4 | 1.250 | 55666.4 |
912 | 2023-11-29 23:05:12 | bostons | 2 | 107671 | 30 | 3.170 | 33965.6 |
911 | 2023-11-27 12:50:04 | bostons | 1 | 69583 | 4 | 1.126 | 61796.6 |
910 | 2023-11-27 08:43:52 | bostons | 2 | 107671 | 30 | 2.906 | 37051.3 |
909 | 2023-11-24 02:25:26 | bostons | 1 | 69583 | 4 | 1.203 | 57841.2 |
908 | 2023-11-22 13:45:05 | bostons | 1 | 69583 | 4 | 1.080 | 64428.7 |
907 | 2023-11-16 00:03:31 | bostons | 3 | 134027 | 397 | 6.966 | 19240.2 |
906 | 2023-11-12 20:16:13 | bostons | 1 | 69583 | 4 | 2.173 | 32021.6 |
905 | 2023-11-12 03:47:12 | bostons | 1 | 69583 | 4 | 1.063 | 65459.1 |
904 | 2023-11-09 23:12:57 | bostons | 3 | 134027 | 397 | 7.576 | 17691.0 |
903 | 2023-11-07 06:42:49 | bostons | 3 | 134027 | 397 | 16.343 | 8200.9 |
902 | 2023-11-07 06:42:12 | bostons | 3 | 134027 | 397 | 16.156 | 8295.8 |
901 | 2023-11-06 07:26:29 | bostons | 3 | 134027 | 397 | 7.250 | 18486.5 |
900 | 2023-11-05 02:49:50 | bostons | 1 | 69583 | 4 | 1.140 | 61037.7 |
899 | 2023-10-12 07:39:17 | bostons | 1 | 69583 | 4 | 1.060 | 65644.3 |
898 | 2023-10-09 17:30:31 | bostons | 1 | 69583 | 4 | 1.203 | 57841.2 |
897 | 2023-09-25 04:57:58 | bostons | 1 | 69583 | 4 | 1.453 | 47889.2 |
896 | 2023-09-25 01:57:22 | bostons | 1 | 69583 | 4 | 1.080 | 64428.7 |
895 | 2023-09-23 17:15:12 | bostons | 1 | 69583 | 4 | 1.076 | 64668.2 |
894 | 2023-08-31 07:29:17 | bostons | 1 | 69583 | 4 | 1.123 | 61961.7 |
893 | 2023-08-27 07:30:08 | bostons | 2 | 107671 | 30 | 3.156 | 34116.3 |
892 | 2023-08-11 14:42:20 | bostons | 3 | 134027 | 397 | 5.766 | 23244.4 |
891 | 2023-08-08 12:47:30 | bostons | 3 | 134027 | 397 | 6.563 | 20421.6 |
890 | 2023-08-06 15:42:52 | bostons | 3 | 134027 | 397 | 6.890 | 19452.4 |
889 | 2023-06-19 16:27:25 | bostons | 1 | 69583 | 4 | 1.280 | 54361.7 |
888 | 2023-06-03 18:53:58 | bostons | 1 | 69583 | 4 | 1.046 | 66522.9 |
887 | 2023-05-11 10:17:59 | bostons | 2 | 107671 | 30 | 2.876 | 37437.8 |
886 | 2023-04-25 07:15:19 | bostons | 3 | 134027 | 397 | 6.640 | 20184.8 |
885 | 2023-04-21 08:36:04 | bostons | 2 | 107671 | 30 | 2.813 | 38276.2 |
884 | 2023-03-27 21:29:40 | bostons | 1 | 69583 | 4 | 1.200 | 57985.8 |
883 | 2023-03-17 10:58:18 | bostons | 2 | 107671 | 30 | 2.830 | 38046.3 |
882 | 2023-03-17 08:58:57 | bostons | 1 | 69583 | 4 | 1.186 | 58670.3 |
881 | 2023-03-03 00:57:02 | bostons | 3 | 134027 | 397 | 6.610 | 20276.4 |
880 | 2023-02-21 07:49:00 | bostons | 3 | 134027 | 397 | 5.736 | 23365.9 |
879 | 2023-02-17 21:51:34 | bostons | 3 | 134027 | 397 | 6.300 | 21274.1 |
878 | 2023-02-16 13:25:17 | bostons | 2 | 107671 | 30 | 2.813 | 38276.2 |
877 | 2023-02-01 06:45:02 | bostons | 1 | 69583 | 4 | 1.046 | 66522.9 |
876 | 2023-01-28 03:13:00 | bostons | 3 | 134027 | 397 | 5.843 | 22938.0 |
875 | 2023-01-11 02:53:40 | bostons | 1 | 69583 | 4 | 1.063 | 65459.1 |
874 | 2023-01-01 10:57:58 | bostons | 3 | 134027 | 397 | 5.810 | 23068.3 |