History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"assays"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
950 | 2025-04-20 21:31:29 | assays | 3 | 112716 | 428 | 38.173 | 2952.8 |
949 | 2025-04-20 09:58:15 | assays | 1 | 48755 | 4 | 2.750 | 17729.1 |
948 | 2025-04-16 10:53:01 | assays | 3 | 112716 | 428 | 14.770 | 7631.4 |
947 | 2025-04-14 21:37:50 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |
946 | 2025-04-11 05:38:55 | assays | 1 | 48755 | 4 | 4.403 | 11073.1 |
945 | 2025-04-11 03:52:11 | assays | 3 | 112716 | 428 | 39.313 | 2867.1 |
944 | 2025-04-10 23:39:45 | assays | 3 | 112716 | 428 | 22.126 | 5094.3 |
943 | 2025-04-09 12:27:48 | assays | 3 | 112716 | 428 | 16.720 | 6741.4 |
942 | 2025-04-09 03:55:10 | assays | 2 | 82551 | 31 | 6.893 | 11976.1 |
941 | 2025-04-07 20:11:42 | assays | 1 | 48755 | 4 | 0.796 | 61250.0 |
940 | 2025-03-20 11:18:00 | assays | 3 | 112716 | 428 | 19.096 | 5902.6 |
939 | 2025-03-19 23:28:41 | assays | 2 | 82551 | 31 | 11.966 | 6898.8 |
938 | 2025-03-19 12:25:47 | assays | 1 | 48755 | 4 | 0.873 | 55847.7 |
937 | 2025-03-07 03:38:00 | assays | 1 | 48755 | 4 | 3.720 | 13106.2 |
936 | 2025-03-06 21:12:46 | assays | 1 | 48755 | 4 | 2.610 | 18680.1 |
935 | 2025-03-03 10:57:55 | assays | 1 | 48755 | 4 | 4.546 | 10724.8 |
934 | 2025-03-02 05:01:10 | assays | 3 | 112716 | 428 | 16.626 | 6779.5 |
933 | 2025-03-02 02:23:18 | assays | 2 | 82551 | 31 | 16.673 | 4951.2 |
932 | 2025-03-02 02:23:19 | assays | 3 | 112716 | 428 | 15.596 | 7227.2 |
931 | 2025-02-28 01:23:15 | assays | 2 | 82551 | 31 | 10.156 | 8128.3 |
930 | 2025-02-27 22:29:01 | assays | 1 | 48755 | 4 | 7.156 | 6813.2 |
929 | 2025-02-27 22:10:31 | assays | 2 | 82551 | 31 | 8.393 | 9835.7 |
928 | 2025-02-27 21:47:41 | assays | 3 | 112716 | 428 | 26.530 | 4248.6 |
927 | 2025-02-27 20:15:33 | assays | 3 | 112716 | 428 | 13.156 | 8567.6 |
926 | 2025-02-27 16:54:20 | assays | 3 | 112716 | 428 | 27.673 | 4073.1 |
925 | 2025-02-27 16:54:21 | assays | 2 | 82551 | 31 | 17.673 | 4671.0 |
924 | 2025-02-27 16:53:31 | assays | 1 | 48755 | 4 | 3.513 | 13878.5 |
923 | 2025-02-10 16:37:49 | assays | 1 | 48755 | 4 | 4.330 | 11259.8 |
922 | 2025-02-05 11:01:51 | assays | 1 | 48755 | 4 | 0.750 | 65006.7 |
921 | 2025-02-04 17:07:58 | assays | 1 | 48755 | 4 | 2.203 | 22131.2 |
920 | 2025-02-03 17:17:16 | assays | 1 | 48755 | 4 | 4.360 | 11182.3 |
919 | 2025-01-30 13:53:34 | assays | 1 | 48755 | 4 | 4.063 | 11999.8 |
918 | 2025-01-26 12:28:15 | assays | 2 | 82551 | 31 | 9.780 | 8440.8 |
917 | 2025-01-26 12:12:04 | assays | 2 | 82551 | 31 | 7.720 | 10693.1 |
916 | 2025-01-26 08:25:16 | assays | 1 | 48755 | 4 | 6.296 | 7743.8 |
915 | 2025-01-26 08:24:50 | assays | 3 | 112716 | 428 | 30.406 | 3707.0 |
914 | 2025-01-26 08:22:07 | assays | 2 | 82551 | 31 | 5.000 | 16510.2 |
913 | 2025-01-25 22:27:54 | assays | 3 | 112716 | 428 | 29.390 | 3835.2 |
912 | 2025-01-25 20:02:16 | assays | 3 | 112716 | 428 | 17.563 | 6417.8 |
911 | 2025-01-25 19:08:18 | assays | 2 | 82551 | 31 | 2.576 | 32046.2 |
910 | 2025-01-25 19:07:57 | assays | 3 | 112716 | 428 | 5.906 | 19085.0 |
909 | 2025-01-12 12:28:35 | assays | 2 | 82551 | 31 | 11.406 | 7237.5 |
908 | 2025-01-11 00:49:10 | assays | 3 | 112716 | 428 | 17.030 | 6618.7 |
907 | 2025-01-04 16:31:32 | assays | 1 | 48755 | 4 | 2.266 | 21515.9 |
906 | 2025-01-02 18:17:59 | assays | 1 | 48755 | 4 | 3.706 | 13155.7 |
905 | 2024-12-28 23:47:09 | assays | 1 | 48755 | 4 | 3.660 | 13321.0 |
904 | 2024-12-26 19:47:01 | assays | 2 | 82551 | 31 | 12.470 | 6620.0 |
903 | 2024-12-26 19:46:43 | assays | 1 | 48755 | 4 | 2.030 | 24017.2 |
902 | 2024-12-24 10:46:02 | assays | 2 | 82551 | 31 | 11.050 | 7470.7 |
901 | 2024-12-21 02:25:19 | assays | 2 | 82551 | 31 | 5.406 | 15270.3 |
900 | 2024-12-19 14:59:08 | assays | 2 | 82551 | 31 | 16.860 | 4896.3 |
899 | 2024-12-19 14:54:47 | assays | 3 | 112716 | 428 | 5.593 | 20153.0 |
898 | 2024-12-17 23:00:42 | assays | 3 | 112716 | 428 | 35.876 | 3141.8 |
897 | 2024-12-16 00:24:08 | assays | 3 | 112716 | 428 | 27.596 | 4084.5 |
896 | 2024-12-15 16:25:21 | assays | 3 | 112716 | 428 | 16.326 | 6904.1 |
895 | 2024-12-04 19:40:21 | assays | 1 | 48755 | 4 | 4.766 | 10229.8 |
894 | 2024-12-03 03:54:32 | assays | 1 | 48755 | 4 | 4.906 | 9937.8 |
893 | 2024-11-25 04:15:39 | assays | 3 | 112716 | 428 | 27.533 | 4093.9 |
892 | 2024-11-13 16:00:47 | assays | 3 | 112716 | 428 | 4.876 | 23116.5 |
891 | 2024-11-06 04:48:18 | assays | 3 | 112716 | 428 | 13.860 | 8132.5 |
890 | 2024-11-04 11:42:05 | assays | 1 | 48755 | 4 | 3.673 | 13273.9 |
889 | 2024-11-03 14:00:33 | assays | 3 | 112716 | 428 | 30.000 | 3757.2 |
888 | 2024-11-02 14:09:20 | assays | 3 | 112716 | 428 | 26.250 | 4293.9 |
887 | 2024-11-01 02:42:43 | assays | 1 | 48755 | 4 | 5.546 | 8791.0 |
886 | 2024-10-27 09:40:02 | assays | 2 | 82551 | 31 | 11.720 | 7043.6 |
885 | 2024-10-27 09:39:35 | assays | 1 | 48755 | 4 | 5.296 | 9206.0 |
884 | 2024-10-27 05:29:44 | assays | 1 | 48755 | 4 | 4.093 | 11911.8 |
883 | 2024-10-12 03:19:29 | assays | 1 | 48755 | 4 | 4.546 | 10724.8 |
882 | 2024-10-11 04:15:33 | assays | 3 | 112716 | 428 | 25.580 | 4406.4 |
881 | 2024-10-10 19:36:44 | assays | 2 | 82551 | 31 | 9.003 | 9169.3 |
880 | 2024-10-10 19:34:27 | assays | 3 | 112716 | 428 | 5.780 | 19501.0 |
879 | 2024-10-04 13:48:26 | assays | 1 | 48755 | 4 | 5.250 | 9286.7 |
878 | 2024-10-01 17:59:35 | assays | 2 | 82551 | 31 | 18.893 | 4369.4 |
877 | 2024-10-01 17:59:25 | assays | 1 | 48755 | 4 | 5.736 | 8499.8 |
876 | 2024-09-27 02:05:57 | assays | 1 | 48755 | 4 | 10.280 | 4742.7 |
875 | 2024-09-16 08:52:17 | assays | 1 | 48755 | 4 | 9.563 | 5098.3 |
874 | 2024-09-10 04:45:56 | assays | 3 | 112716 | 428 | 42.730 | 2637.9 |
873 | 2024-09-04 05:48:27 | assays | 3 | 112716 | 428 | 41.723 | 2701.5 |
872 | 2024-09-04 05:36:06 | assays | 3 | 112716 | 428 | 45.206 | 2493.4 |
871 | 2024-09-03 19:29:55 | assays | 3 | 112716 | 428 | 59.380 | 1898.2 |
870 | 2024-09-03 19:29:57 | assays | 2 | 82551 | 31 | 19.500 | 4233.4 |
869 | 2024-09-03 19:26:49 | assays | 1 | 48755 | 4 | 2.923 | 16679.8 |
868 | 2024-09-01 15:46:48 | assays | 1 | 48755 | 4 | 5.560 | 8768.9 |
867 | 2024-09-01 15:25:44 | assays | 1 | 48755 | 4 | 3.123 | 15611.6 |
866 | 2024-08-13 23:52:01 | assays | 1 | 48755 | 4 | 8.030 | 6071.6 |
865 | 2024-08-13 08:03:40 | assays | 1 | 48755 | 4 | 6.000 | 8125.8 |
864 | 2024-08-11 18:43:30 | assays | 1 | 48755 | 4 | 4.830 | 10094.2 |
863 | 2024-08-01 06:12:51 | assays | 1 | 48755 | 4 | 1.393 | 35000.0 |
862 | 2024-07-31 06:09:14 | assays | 1 | 48755 | 4 | 4.780 | 10199.8 |
861 | 2024-07-30 22:25:20 | assays | 1 | 48755 | 4 | 1.936 | 25183.4 |
860 | 2024-07-17 13:07:24 | assays | 3 | 112716 | 428 | 27.703 | 4068.7 |
859 | 2024-07-14 19:07:05 | assays | 3 | 112716 | 428 | 25.876 | 4356.0 |
858 | 2024-07-14 07:12:32 | assays | 3 | 112716 | 428 | 19.876 | 5671.0 |
857 | 2024-07-13 11:54:16 | assays | 3 | 112716 | 428 | 18.953 | 5947.1 |
856 | 2024-07-11 22:52:31 | assays | 1 | 48755 | 4 | 1.656 | 29441.4 |
855 | 2024-07-11 22:52:05 | assays | 3 | 112716 | 428 | 10.186 | 11065.8 |
854 | 2024-07-11 22:52:05 | assays | 2 | 82551 | 31 | 9.046 | 9125.7 |
853 | 2024-07-01 23:04:33 | assays | 1 | 48755 | 4 | 4.376 | 11141.5 |
852 | 2024-07-01 04:37:01 | assays | 1 | 48755 | 4 | 2.576 | 18926.6 |
851 | 2024-06-30 21:13:18 | assays | 1 | 48755 | 4 | 4.546 | 10724.8 |