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 |
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 |
873 | 2022-12-26 14:39:47 | bostons | 3 | 134027 | 397 | 5.860 | 22871.5 |
872 | 2022-12-16 13:30:50 | bostons | 1 | 69583 | 4 | 1.080 | 64428.7 |
871 | 2022-12-05 19:53:25 | bostons | 1 | 69583 | 4 | 1.063 | 65459.1 |
870 | 2022-11-27 12:55:34 | bostons | 2 | 107671 | 30 | 2.780 | 38730.6 |
869 | 2022-11-27 10:49:22 | bostons | 1 | 69583 | 4 | 1.063 | 65459.1 |
868 | 2022-11-25 00:01:30 | bostons | 3 | 134027 | 397 | 6.983 | 19193.3 |
867 | 2022-11-14 17:34:21 | bostons | 1 | 69583 | 4 | 1.250 | 55666.4 |
866 | 2022-11-13 22:19:47 | bostons | 3 | 134027 | 397 | 5.673 | 23625.4 |
865 | 2022-11-10 03:02:15 | bostons | 3 | 134027 | 397 | 6.580 | 20368.8 |
864 | 2022-11-05 10:25:47 | bostons | 1 | 69583 | 4 | 1.170 | 59472.6 |
863 | 2022-11-01 20:31:38 | bostons | 3 | 134027 | 397 | 5.903 | 22704.9 |
862 | 2022-10-15 20:42:38 | bostons | 1 | 69583 | 4 | 1.110 | 62687.4 |
861 | 2022-10-13 14:57:22 | bostons | 3 | 134027 | 397 | 5.686 | 23571.4 |
860 | 2022-10-08 03:31:19 | bostons | 3 | 134027 | 397 | 5.796 | 23124.1 |
859 | 2022-08-28 05:26:18 | bostons | 3 | 134027 | 397 | 5.826 | 23005.0 |
858 | 2022-08-27 20:43:39 | bostons | 1 | 69583 | 4 | 2.390 | 29114.2 |
857 | 2022-08-22 03:51:32 | bostons | 1 | 69583 | 4 | 1.110 | 62687.4 |
856 | 2022-07-20 13:11:39 | bostons | 3 | 134027 | 397 | 5.720 | 23431.3 |
855 | 2022-07-15 01:32:59 | bostons | 3 | 134027 | 397 | 5.953 | 22514.2 |
854 | 2022-07-10 20:24:49 | bostons | 1 | 69583 | 4 | 1.076 | 64668.2 |
853 | 2022-07-05 12:34:09 | bostons | 2 | 107671 | 30 | 2.940 | 36622.8 |
852 | 2022-07-03 06:42:09 | bostons | 2 | 107671 | 30 | 2.893 | 37217.8 |
851 | 2022-06-26 18:03:17 | bostons | 3 | 134027 | 397 | 5.780 | 23188.1 |
850 | 2022-06-19 12:49:56 | bostons | 3 | 134027 | 397 | 5.733 | 23378.2 |
849 | 2022-06-13 09:39:36 | bostons | 3 | 134027 | 397 | 5.953 | 22514.2 |
848 | 2022-06-05 14:57:05 | bostons | 1 | 69583 | 4 | 1.080 | 64428.7 |
847 | 2022-06-03 10:14:58 | bostons | 1 | 69583 | 4 | 1.093 | 63662.4 |
846 | 2022-06-01 04:02:45 | bostons | 1 | 69583 | 4 | 1.203 | 57841.2 |
845 | 2022-05-18 14:26:59 | bostons | 1 | 69583 | 4 | 1.093 | 63662.4 |
844 | 2022-05-16 12:43:54 | bostons | 1 | 69583 | 4 | 1.216 | 57222.9 |
843 | 2022-02-12 08:32:50 | bostons | 2 | 107671 | 30 | 2.983 | 36094.9 |
842 | 2022-02-11 20:55:43 | bostons | 1 | 69583 | 4 | 1.266 | 54962.9 |
841 | 2022-02-06 19:14:48 | bostons | 1 | 69583 | 4 | 1.296 | 53690.6 |
840 | 2022-01-21 22:17:36 | bostons | 1 | 69583 | 4 | 1.173 | 59320.5 |
839 | 2022-01-21 10:57:43 | bostons | 1 | 69583 | 4 | 2.516 | 27656.2 |
838 | 2022-01-21 01:26:04 | bostons | 1 | 69583 | 4 | 1.220 | 57035.2 |
837 | 2022-01-20 16:01:19 | bostons | 1 | 69583 | 4 | 1.170 | 59472.6 |
836 | 2022-01-20 05:32:53 | bostons | 1 | 69583 | 4 | 1.080 | 64428.7 |
835 | 2022-01-19 21:38:48 | bostons | 1 | 69583 | 4 | 1.266 | 54962.9 |
834 | 2022-01-19 10:59:15 | bostons | 1 | 69583 | 4 | 2.440 | 28517.6 |
833 | 2022-01-18 21:30:43 | bostons | 1 | 69583 | 4 | 1.266 | 54962.9 |
832 | 2022-01-18 12:43:38 | bostons | 1 | 69583 | 4 | 1.093 | 63662.4 |
831 | 2022-01-13 06:52:54 | bostons | 1 | 69583 | 4 | 1.263 | 55093.4 |
830 | 2022-01-12 11:36:17 | bostons | 1 | 69583 | 4 | 1.330 | 52318.0 |
829 | 2022-01-11 23:41:55 | bostons | 1 | 69583 | 4 | 1.283 | 54234.6 |
828 | 2022-01-11 06:45:24 | bostons | 1 | 69583 | 4 | 1.156 | 60192.9 |
827 | 2022-01-10 16:18:29 | bostons | 1 | 69583 | 4 | 1.220 | 57035.2 |
826 | 2022-01-09 22:05:30 | bostons | 1 | 69583 | 4 | 1.266 | 54962.9 |