History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aggie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1004 | 2025-02-05 14:29:42 | aggie | 2 | 53800 | 66 | 8.093 | 6647.7 |
1003 | 2025-02-05 14:23:38 | aggie | 3 | 83667 | 833 | 7.190 | 11636.6 |
1002 | 2025-02-04 08:42:19 | aggie | 1 | 28756 | 3 | 2.296 | 12524.4 |
1001 | 2025-02-01 08:24:49 | aggie | 1 | 28756 | 3 | 0.513 | 56054.6 |
1000 | 2025-02-01 06:43:57 | aggie | 3 | 83667 | 833 | 15.190 | 5508.0 |
999 | 2025-01-29 19:49:22 | aggie | 3 | 83667 | 833 | 15.546 | 5381.9 |
998 | 2025-01-29 15:34:28 | aggie | 3 | 83667 | 833 | 19.360 | 4321.6 |
997 | 2025-01-29 10:15:35 | aggie | 2 | 53800 | 66 | 7.250 | 7420.7 |
996 | 2025-01-28 23:21:04 | aggie | 3 | 83667 | 833 | 16.706 | 5008.2 |
995 | 2025-01-28 23:21:06 | aggie | 2 | 53800 | 66 | 4.280 | 12570.1 |
994 | 2025-01-28 23:14:32 | aggie | 1 | 28756 | 3 | 0.513 | 56054.6 |
993 | 2025-01-06 18:43:17 | aggie | 1 | 28756 | 3 | 2.376 | 12102.7 |
992 | 2025-01-01 17:07:50 | aggie | 3 | 83667 | 833 | 20.220 | 4137.8 |
991 | 2025-01-01 16:16:08 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
990 | 2024-12-30 11:34:01 | aggie | 3 | 83667 | 833 | 17.123 | 4886.2 |
989 | 2024-12-29 15:42:42 | aggie | 3 | 83667 | 833 | 19.720 | 4242.7 |
988 | 2024-12-29 15:42:40 | aggie | 2 | 53800 | 66 | 12.123 | 4437.8 |
987 | 2024-12-29 15:09:05 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
986 | 2024-12-26 14:38:18 | aggie | 1 | 28756 | 3 | 0.890 | 32310.1 |
985 | 2024-12-25 03:31:02 | aggie | 3 | 83667 | 833 | 7.763 | 10777.7 |
984 | 2024-12-11 19:47:46 | aggie | 3 | 83667 | 833 | 23.316 | 3588.4 |
983 | 2024-12-02 12:52:55 | aggie | 1 | 28756 | 3 | 1.173 | 24514.9 |
982 | 2024-12-02 12:19:45 | aggie | 3 | 83667 | 833 | 17.783 | 4704.9 |
981 | 2024-12-01 06:27:15 | aggie | 3 | 83667 | 833 | 8.690 | 9628.0 |
980 | 2024-11-30 05:52:42 | aggie | 3 | 83667 | 833 | 10.610 | 7885.7 |
979 | 2024-11-29 16:45:36 | aggie | 2 | 53800 | 66 | 4.173 | 12892.4 |
978 | 2024-11-29 14:00:01 | aggie | 3 | 83667 | 833 | 3.720 | 22491.1 |
977 | 2024-11-29 14:00:00 | aggie | 2 | 53800 | 66 | 1.436 | 37465.2 |
976 | 2024-11-29 13:59:56 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
975 | 2024-11-26 08:58:47 | aggie | 1 | 28756 | 3 | 2.470 | 11642.1 |
974 | 2024-11-07 00:05:33 | aggie | 1 | 28756 | 3 | 1.673 | 17188.3 |
973 | 2024-11-01 15:53:02 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
972 | 2024-10-30 14:22:42 | aggie | 3 | 83667 | 833 | 15.970 | 5239.0 |
971 | 2024-10-30 12:40:08 | aggie | 2 | 53800 | 66 | 4.803 | 11201.3 |
970 | 2024-10-30 11:45:13 | aggie | 3 | 83667 | 833 | 4.063 | 20592.4 |
969 | 2024-10-30 11:45:12 | aggie | 2 | 53800 | 66 | 1.720 | 31279.1 |
968 | 2024-10-30 11:45:00 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
967 | 2024-10-27 07:14:49 | aggie | 1 | 28756 | 3 | 2.733 | 10521.8 |
966 | 2024-10-07 17:26:46 | aggie | 1 | 28756 | 3 | 2.203 | 13053.1 |
965 | 2024-10-02 14:16:59 | aggie | 1 | 28756 | 3 | 5.173 | 5558.9 |
964 | 2024-10-01 02:04:30 | aggie | 3 | 83667 | 833 | 33.953 | 2464.2 |
963 | 2024-09-30 16:19:20 | aggie | 3 | 83667 | 833 | 43.033 | 1944.3 |
962 | 2024-09-30 11:04:29 | aggie | 2 | 53800 | 66 | 16.376 | 3285.3 |
961 | 2024-09-30 09:36:51 | aggie | 3 | 83667 | 833 | 26.313 | 3179.7 |
960 | 2024-09-30 09:36:57 | aggie | 2 | 53800 | 66 | 12.453 | 4320.2 |
959 | 2024-09-30 09:30:22 | aggie | 1 | 28756 | 3 | 0.453 | 63479.0 |
958 | 2024-09-27 01:58:50 | aggie | 1 | 28756 | 3 | 5.780 | 4975.1 |
957 | 2024-09-27 00:34:53 | aggie | 2 | 53800 | 66 | 9.686 | 5554.4 |
956 | 2024-09-07 21:34:27 | aggie | 1 | 28756 | 3 | 3.970 | 7243.3 |
955 | 2024-09-04 23:49:29 | aggie | 3 | 83667 | 833 | 15.156 | 5520.4 |
954 | 2024-09-04 10:02:53 | aggie | 1 | 28756 | 3 | 0.466 | 61708.2 |
953 | 2024-09-01 21:15:49 | aggie | 3 | 83667 | 833 | 18.580 | 4503.1 |
952 | 2024-09-01 02:58:28 | aggie | 1 | 28756 | 3 | 4.470 | 6433.1 |
951 | 2024-08-31 14:37:19 | aggie | 3 | 83667 | 833 | 19.923 | 4199.5 |
950 | 2024-08-31 11:35:12 | aggie | 3 | 83667 | 833 | 21.470 | 3896.9 |
949 | 2024-08-31 07:34:01 | aggie | 3 | 83667 | 833 | 17.550 | 4767.4 |
948 | 2024-08-31 07:34:04 | aggie | 2 | 53800 | 66 | 14.500 | 3710.3 |
947 | 2024-08-31 07:30:35 | aggie | 1 | 28756 | 3 | 1.810 | 15887.3 |
946 | 2024-08-30 05:24:35 | aggie | 1 | 28756 | 3 | 5.283 | 5443.1 |
945 | 2024-08-27 20:45:05 | aggie | 1 | 28756 | 3 | 3.080 | 9336.4 |
944 | 2024-08-15 17:25:17 | aggie | 2 | 53800 | 66 | 13.480 | 3991.1 |
943 | 2024-08-10 00:59:43 | aggie | 1 | 28756 | 3 | 2.516 | 11429.3 |
942 | 2024-08-08 08:53:22 | aggie | 1 | 28756 | 3 | 2.000 | 14378.0 |
941 | 2024-08-08 00:26:20 | aggie | 2 | 53800 | 66 | 6.140 | 8762.2 |
940 | 2024-08-04 10:58:24 | aggie | 1 | 28756 | 3 | 1.283 | 22413.1 |
939 | 2024-08-02 02:23:37 | aggie | 2 | 53800 | 66 | 6.660 | 8078.1 |
938 | 2024-08-01 12:01:14 | aggie | 2 | 53800 | 66 | 6.140 | 8762.2 |
937 | 2024-08-01 10:11:28 | aggie | 2 | 53800 | 66 | 1.606 | 33499.4 |
936 | 2024-08-01 10:11:00 | aggie | 3 | 83667 | 833 | 6.016 | 13907.4 |
935 | 2024-07-31 10:30:55 | aggie | 3 | 83667 | 833 | 17.830 | 4692.5 |
934 | 2024-07-31 08:57:39 | aggie | 3 | 83667 | 833 | 14.970 | 5589.0 |
933 | 2024-07-31 02:56:47 | aggie | 1 | 28756 | 3 | 0.826 | 34813.6 |
932 | 2024-07-31 01:59:39 | aggie | 3 | 83667 | 833 | 3.966 | 21096.1 |
931 | 2024-07-31 01:10:26 | aggie | 3 | 83667 | 833 | 13.780 | 6071.6 |
930 | 2024-07-31 00:33:55 | aggie | 1 | 28756 | 3 | 0.546 | 52666.7 |
929 | 2024-07-28 15:32:33 | aggie | 1 | 28756 | 3 | 1.966 | 14626.7 |
928 | 2024-07-27 06:14:34 | aggie | 1 | 28756 | 3 | 2.000 | 14378.0 |
927 | 2024-07-10 18:42:28 | aggie | 1 | 28756 | 3 | 4.110 | 6996.6 |
926 | 2024-07-01 17:06:08 | aggie | 2 | 53800 | 66 | 1.860 | 28924.7 |
925 | 2024-07-01 06:37:44 | aggie | 3 | 83667 | 833 | 17.656 | 4738.7 |
924 | 2024-06-30 23:51:19 | aggie | 3 | 83667 | 833 | 14.076 | 5943.9 |
923 | 2024-06-30 23:31:02 | aggie | 3 | 83667 | 833 | 17.410 | 4805.7 |
922 | 2024-06-30 23:29:34 | aggie | 2 | 53800 | 66 | 9.096 | 5914.7 |
921 | 2024-06-30 22:41:05 | aggie | 3 | 83667 | 833 | 5.486 | 15251.0 |
920 | 2024-06-30 22:41:04 | aggie | 2 | 53800 | 66 | 1.626 | 33087.3 |
919 | 2024-06-30 22:41:02 | aggie | 1 | 28756 | 3 | 0.470 | 61183.0 |
918 | 2024-06-30 15:48:41 | aggie | 1 | 28756 | 3 | 1.940 | 14822.7 |
917 | 2024-06-28 11:32:56 | aggie | 1 | 28756 | 3 | 1.436 | 20025.1 |
916 | 2024-06-27 23:54:32 | aggie | 1 | 28756 | 3 | 2.390 | 12031.8 |
915 | 2024-06-27 16:28:18 | aggie | 1 | 28756 | 3 | 1.766 | 16283.1 |
914 | 2024-06-08 19:15:21 | aggie | 3 | 83667 | 833 | 9.253 | 9042.1 |
913 | 2024-06-08 06:57:45 | aggie | 3 | 83667 | 833 | 22.033 | 3797.3 |
912 | 2024-06-05 04:41:16 | aggie | 1 | 28756 | 3 | 0.966 | 29768.1 |
911 | 2024-05-31 15:54:32 | aggie | 3 | 83667 | 833 | 6.766 | 12365.8 |
910 | 2024-05-31 10:21:44 | aggie | 3 | 83667 | 833 | 20.470 | 4087.3 |
909 | 2024-05-31 10:21:40 | aggie | 2 | 53800 | 66 | 3.376 | 15936.0 |
908 | 2024-05-31 10:14:33 | aggie | 1 | 28756 | 3 | 2.143 | 13418.6 |
907 | 2024-05-30 03:24:20 | aggie | 1 | 28756 | 3 | 2.046 | 14054.7 |
906 | 2024-05-16 09:53:53 | aggie | 3 | 83667 | 833 | 5.203 | 16080.5 |
905 | 2024-05-16 07:32:09 | aggie | 3 | 83667 | 833 | 5.313 | 15747.6 |