History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"combat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1032 | 2024-04-13 16:47:13 | combat | 1 | 48755 | 3 | 0.873 | 55847.7 |
1031 | 2024-04-07 17:42:59 | combat | 3 | 112716 | 398 | 16.220 | 6949.2 |
1030 | 2024-04-06 02:53:39 | combat | 3 | 112716 | 398 | 11.343 | 9937.1 |
1029 | 2024-04-06 01:31:04 | combat | 2 | 82551 | 42 | 8.376 | 9855.7 |
1028 | 2024-04-06 01:25:38 | combat | 1 | 48755 | 3 | 3.080 | 15829.5 |
1027 | 2024-04-05 18:55:51 | combat | 3 | 112716 | 398 | 6.530 | 17261.3 |
1026 | 2024-04-05 04:11:41 | combat | 3 | 112716 | 398 | 7.516 | 14996.8 |
1025 | 2024-04-05 04:11:42 | combat | 2 | 82551 | 42 | 3.360 | 24568.8 |
1024 | 2024-04-05 04:11:30 | combat | 3 | 112716 | 398 | 8.690 | 12970.8 |
1023 | 2024-04-05 04:11:36 | combat | 1 | 48755 | 3 | 1.863 | 26170.2 |
1022 | 2024-04-05 04:11:31 | combat | 2 | 82551 | 42 | 2.673 | 30883.3 |
1021 | 2024-04-05 04:11:29 | combat | 1 | 48755 | 3 | 1.063 | 45865.5 |
1020 | 2024-03-06 23:18:30 | combat | 1 | 48755 | 3 | 2.080 | 23439.9 |
1019 | 2024-03-01 04:16:16 | combat | 2 | 82551 | 42 | 2.643 | 31233.8 |
1018 | 2024-03-01 04:15:57 | combat | 3 | 112716 | 398 | 6.966 | 16180.9 |
1017 | 2024-02-28 11:49:02 | combat | 3 | 112716 | 398 | 6.736 | 16733.4 |
1016 | 2024-02-28 11:49:02 | combat | 2 | 82551 | 42 | 4.280 | 19287.6 |
1015 | 2024-02-27 09:11:50 | combat | 2 | 82551 | 42 | 2.606 | 31677.3 |
1014 | 2024-02-27 08:28:12 | combat | 3 | 112716 | 398 | 9.826 | 11471.2 |
1013 | 2024-02-26 20:14:14 | combat | 3 | 112716 | 398 | 5.250 | 21469.7 |
1012 | 2024-02-26 20:14:13 | combat | 2 | 82551 | 42 | 2.686 | 30733.8 |
1011 | 2024-02-26 20:14:12 | combat | 1 | 48755 | 3 | 0.936 | 52088.7 |
1010 | 2023-12-28 06:15:36 | combat | 1 | 48755 | 3 | 0.763 | 63899.1 |
1009 | 2023-12-24 22:40:03 | combat | 1 | 48755 | 3 | 0.813 | 59969.2 |
1008 | 2023-12-14 14:21:39 | combat | 3 | 112716 | 398 | 4.843 | 23274.0 |
1007 | 2023-12-12 20:52:29 | combat | 3 | 112716 | 398 | 5.000 | 22543.2 |
1006 | 2023-12-12 20:52:28 | combat | 2 | 82551 | 42 | 2.420 | 34112.0 |
1005 | 2023-12-03 17:39:17 | combat | 3 | 112716 | 398 | 5.686 | 19823.4 |
1004 | 2023-12-03 17:39:14 | combat | 2 | 82551 | 42 | 2.373 | 34787.6 |
1003 | 2023-11-26 19:07:10 | combat | 2 | 82551 | 42 | 2.436 | 33887.9 |
1002 | 2023-11-26 19:07:07 | combat | 3 | 112716 | 398 | 5.000 | 22543.2 |
1001 | 2023-11-11 04:49:13 | combat | 1 | 48755 | 3 | 0.876 | 55656.4 |
1000 | 2023-11-11 03:26:56 | combat | 1 | 48755 | 3 | 0.846 | 57630.0 |
999 | 2023-11-10 02:07:35 | combat | 1 | 48755 | 3 | 0.750 | 65006.7 |
998 | 2023-10-27 23:55:00 | combat | 1 | 48755 | 3 | 0.796 | 61250.0 |
997 | 2023-10-27 13:41:32 | combat | 1 | 48755 | 3 | 0.846 | 57630.0 |
996 | 2023-10-20 04:09:14 | combat | 1 | 48755 | 3 | 0.860 | 56691.9 |
995 | 2023-10-18 15:15:52 | combat | 1 | 48755 | 3 | 0.860 | 56691.9 |
994 | 2023-10-18 01:04:41 | combat | 1 | 48755 | 3 | 0.783 | 62266.9 |
993 | 2023-10-11 13:56:16 | combat | 1 | 48755 | 3 | 0.750 | 65006.7 |
992 | 2023-10-04 05:47:31 | combat | 1 | 48755 | 3 | 0.843 | 57835.1 |
991 | 2023-09-23 01:06:10 | combat | 1 | 48755 | 3 | 0.766 | 63648.8 |
990 | 2023-09-12 05:42:50 | combat | 1 | 48755 | 3 | 0.783 | 62266.9 |
989 | 2023-08-13 00:42:47 | combat | 1 | 48755 | 3 | 0.766 | 63648.8 |
988 | 2023-07-22 15:46:51 | combat | 1 | 48755 | 3 | 0.873 | 55847.7 |
987 | 2023-05-28 17:37:55 | combat | 1 | 48755 | 3 | 0.780 | 62506.4 |
986 | 2023-05-13 13:25:46 | combat | 1 | 48755 | 3 | 0.766 | 63648.8 |
985 | 2023-04-10 23:13:17 | combat | 1 | 48755 | 3 | 0.860 | 56691.9 |
984 | 2023-03-09 14:44:59 | combat | 1 | 48755 | 3 | 0.750 | 65006.7 |
983 | 2023-01-02 01:24:09 | combat | 1 | 48755 | 3 | 0.876 | 55656.4 |
982 | 2022-12-27 19:39:13 | combat | 1 | 48755 | 3 | 0.733 | 66514.3 |
981 | 2022-09-16 01:16:31 | combat | 1 | 48755 | 3 | 0.936 | 52088.7 |
980 | 2022-09-14 22:04:44 | combat | 1 | 48755 | 3 | 0.783 | 62266.9 |
979 | 2022-06-29 07:53:31 | combat | 1 | 48755 | 3 | 0.750 | 65006.7 |
978 | 2022-05-29 16:37:58 | combat | 1 | 48755 | 3 | 1.516 | 32160.3 |
977 | 2022-05-18 14:03:19 | combat | 1 | 48755 | 3 | 0.780 | 62506.4 |
976 | 2022-03-21 18:02:24 | combat | 2 | 82551 | 42 | 2.720 | 30349.6 |
975 | 2022-03-20 19:18:24 | combat | 2 | 82551 | 42 | 2.123 | 38884.1 |
974 | 2022-03-10 17:41:37 | combat | 1 | 48755 | 3 | 1.000 | 48755.0 |
973 | 2022-03-08 15:14:22 | combat | 1 | 48755 | 3 | 0.953 | 51159.5 |
972 | 2022-02-21 20:17:22 | combat | 1 | 48755 | 3 | 0.796 | 61250.0 |
971 | 2021-12-21 01:42:34 | combat | 1 | 48755 | 3 | 0.873 | 55847.7 |
970 | 2021-11-23 16:42:36 | combat | 2 | 82551 | 42 | 2.203 | 37472.1 |
969 | 2021-11-22 04:34:35 | combat | 2 | 82551 | 42 | 2.143 | 38521.2 |
968 | 2021-11-21 09:36:20 | combat | 2 | 82551 | 42 | 2.580 | 31996.5 |
967 | 2021-11-20 22:53:05 | combat | 2 | 82551 | 42 | 2.173 | 37989.4 |
966 | 2021-11-19 09:30:04 | combat | 1 | 48755 | 3 | 0.766 | 63648.8 |
965 | 2021-11-18 16:38:24 | combat | 2 | 82551 | 42 | 2.610 | 31628.7 |
964 | 2021-11-17 19:26:51 | combat | 2 | 82551 | 42 | 2.513 | 32849.6 |
963 | 2021-11-14 06:24:26 | combat | 1 | 48755 | 3 | 0.780 | 62506.4 |
962 | 2021-11-13 19:46:48 | combat | 1 | 48755 | 3 | 0.906 | 53813.5 |
961 | 2021-11-11 11:27:04 | combat | 1 | 48755 | 3 | 0.906 | 53813.5 |
960 | 2021-09-22 21:08:31 | combat | 2 | 82551 | 42 | 2.173 | 37989.4 |
959 | 2021-09-21 13:29:17 | combat | 2 | 82551 | 42 | 2.186 | 37763.5 |
958 | 2021-09-20 20:14:26 | combat | 2 | 82551 | 42 | 2.250 | 36689.3 |
957 | 2021-09-19 17:58:33 | combat | 2 | 82551 | 42 | 2.436 | 33887.9 |
956 | 2021-08-07 11:20:46 | combat | 1 | 48755 | 3 | 0.856 | 56956.8 |
955 | 2021-07-25 06:00:43 | combat | 2 | 82551 | 42 | 2.140 | 38575.2 |
954 | 2021-07-21 03:29:14 | combat | 1 | 48755 | 3 | 0.796 | 61250.0 |
953 | 2021-06-24 02:12:34 | combat | 1 | 48755 | 3 | 0.766 | 63648.8 |
952 | 2021-06-23 05:36:32 | combat | 1 | 48755 | 3 | 0.860 | 56691.9 |
951 | 2021-06-22 09:53:13 | combat | 1 | 48755 | 3 | 0.780 | 62506.4 |
950 | 2021-06-19 18:50:18 | combat | 1 | 48755 | 3 | 0.856 | 56956.8 |
949 | 2021-06-18 17:24:02 | combat | 1 | 48755 | 3 | 0.766 | 63648.8 |
948 | 2021-06-17 13:30:31 | combat | 1 | 48755 | 3 | 0.763 | 63899.1 |
947 | 2021-06-07 14:12:54 | combat | 2 | 82551 | 42 | 2.140 | 38575.2 |
946 | 2021-05-18 20:15:50 | combat | 1 | 48755 | 3 | 0.906 | 53813.5 |
945 | 2021-05-18 06:00:53 | combat | 1 | 48755 | 3 | 1.110 | 43923.4 |
944 | 2021-05-17 05:25:06 | combat | 1 | 48755 | 3 | 0.750 | 65006.7 |
943 | 2021-05-16 17:46:14 | combat | 2 | 82551 | 42 | 2.233 | 36968.7 |
942 | 2021-05-16 15:21:31 | combat | 1 | 48755 | 3 | 1.593 | 30605.8 |
941 | 2021-05-15 22:47:50 | combat | 1 | 48755 | 3 | 0.763 | 63899.1 |
940 | 2021-05-15 12:02:12 | combat | 2 | 82551 | 42 | 2.186 | 37763.5 |
939 | 2021-05-10 23:52:20 | combat | 2 | 82551 | 42 | 2.203 | 37472.1 |
938 | 2021-05-10 11:13:49 | combat | 1 | 48755 | 3 | 0.936 | 52088.7 |
937 | 2021-05-09 00:35:41 | combat | 2 | 82551 | 42 | 2.660 | 31034.2 |
936 | 2021-05-06 14:32:18 | combat | 1 | 48755 | 3 | 0.843 | 57835.1 |
935 | 2021-04-23 17:17:22 | combat | 1 | 48755 | 3 | 0.860 | 56691.9 |
934 | 2021-04-23 02:29:58 | combat | 1 | 48755 | 3 | 0.843 | 57835.1 |
933 | 2021-04-22 13:10:02 | combat | 1 | 48755 | 3 | 0.813 | 59969.2 |