History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trigram"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1053 | 2024-05-04 06:43:28 | trigram | 1 | 69583 | 2 | 2.670 | 26061.0 |
1052 | 2024-05-03 22:59:48 | trigram | 1 | 69583 | 2 | 1.283 | 54234.6 |
1051 | 2024-05-01 21:28:54 | trigram | 4 | 151207 | 817 | 18.236 | 8291.7 |
1050 | 2024-04-19 01:33:51 | trigram | 4 | 151207 | 817 | 36.253 | 4170.9 |
1049 | 2024-04-18 20:06:04 | trigram | 4 | 151207 | 817 | 9.796 | 15435.6 |
1048 | 2024-04-09 23:08:49 | trigram | 3 | 134027 | 80 | 19.953 | 6717.1 |
1047 | 2024-04-08 15:52:45 | trigram | 2 | 107671 | 8 | 4.063 | 26500.4 |
1046 | 2024-04-08 15:52:21 | trigram | 3 | 134027 | 80 | 8.500 | 15767.9 |
1045 | 2024-04-08 10:12:51 | trigram | 4 | 151207 | 817 | 28.673 | 5273.5 |
1044 | 2024-04-08 07:43:44 | trigram | 3 | 134027 | 80 | 13.470 | 9950.0 |
1043 | 2024-04-07 19:14:34 | trigram | 4 | 151207 | 817 | 17.343 | 8718.6 |
1042 | 2024-04-05 10:54:14 | trigram | 4 | 151207 | 817 | 21.580 | 7006.8 |
1041 | 2024-04-05 09:13:52 | trigram | 1 | 69583 | 2 | 2.736 | 25432.4 |
1040 | 2024-04-05 09:13:35 | trigram | 2 | 107671 | 8 | 7.766 | 13864.4 |
1039 | 2024-04-05 07:38:59 | trigram | 4 | 151207 | 817 | 22.530 | 6711.4 |
1038 | 2024-04-05 07:39:00 | trigram | 3 | 134027 | 80 | 12.876 | 10409.1 |
1037 | 2024-04-04 04:39:34 | trigram | 3 | 134027 | 80 | 17.673 | 7583.7 |
1036 | 2024-04-04 04:39:35 | trigram | 2 | 107671 | 8 | 3.923 | 27446.1 |
1035 | 2024-04-04 04:38:47 | trigram | 1 | 69583 | 2 | 3.986 | 17456.8 |
1034 | 2024-04-04 00:29:45 | trigram | 4 | 151207 | 817 | 40.516 | 3732.0 |
1033 | 2024-04-01 03:49:35 | trigram | 2 | 107671 | 8 | 9.970 | 10799.5 |
1032 | 2024-03-31 15:17:16 | trigram | 2 | 107671 | 8 | 3.466 | 31064.9 |
1031 | 2024-03-30 06:26:11 | trigram | 1 | 69583 | 2 | 2.670 | 26061.0 |
1030 | 2024-03-28 16:27:18 | trigram | 4 | 151207 | 817 | 12.186 | 12408.3 |
1029 | 2024-03-15 23:51:18 | trigram | 4 | 151207 | 817 | 11.110 | 13610.0 |
1028 | 2024-03-08 02:22:13 | trigram | 1 | 69583 | 2 | 1.203 | 57841.2 |
1027 | 2024-03-07 03:17:55 | trigram | 4 | 151207 | 817 | 39.486 | 3829.4 |
1026 | 2024-03-06 00:40:30 | trigram | 4 | 151207 | 817 | 24.206 | 6246.7 |
1025 | 2024-03-05 10:07:25 | trigram | 4 | 151207 | 817 | 33.643 | 4494.5 |
1024 | 2024-03-04 16:14:45 | trigram | 3 | 134027 | 80 | 11.920 | 11243.9 |
1023 | 2024-03-04 16:14:45 | trigram | 2 | 107671 | 8 | 7.813 | 13781.0 |
1022 | 2024-03-04 16:01:02 | trigram | 1 | 69583 | 2 | 2.626 | 26497.7 |
1021 | 2024-03-04 09:55:05 | trigram | 3 | 134027 | 80 | 15.860 | 8450.6 |
1020 | 2024-03-04 09:23:02 | trigram | 4 | 151207 | 817 | 32.436 | 4661.7 |
1019 | 2024-03-04 09:22:57 | trigram | 3 | 134027 | 80 | 21.626 | 6197.5 |
1018 | 2024-03-04 09:22:57 | trigram | 2 | 107671 | 8 | 11.593 | 9287.6 |
1017 | 2024-03-04 09:22:17 | trigram | 1 | 69583 | 2 | 4.190 | 16606.9 |
1016 | 2024-02-04 19:40:38 | trigram | 4 | 151207 | 817 | 20.343 | 7432.9 |
1015 | 2024-01-29 19:16:32 | trigram | 4 | 151207 | 817 | 11.893 | 12713.9 |
1014 | 2024-01-27 10:28:01 | trigram | 4 | 151207 | 817 | 12.440 | 12154.9 |
1013 | 2024-01-27 10:11:51 | trigram | 4 | 151207 | 817 | 12.813 | 11801.1 |
1012 | 2024-01-12 08:06:54 | trigram | 1 | 69583 | 2 | 1.173 | 59320.5 |
1011 | 2023-12-21 13:27:57 | trigram | 4 | 151207 | 817 | 11.360 | 13310.5 |
1010 | 2023-12-11 04:39:00 | trigram | 4 | 151207 | 817 | 9.750 | 15508.4 |
1009 | 2023-12-05 03:35:34 | trigram | 1 | 69583 | 2 | 1.250 | 55666.4 |
1008 | 2023-12-05 00:30:43 | trigram | 1 | 69583 | 2 | 1.046 | 66522.9 |
1007 | 2023-12-04 22:11:15 | trigram | 2 | 107671 | 8 | 2.923 | 36835.8 |
1006 | 2023-11-03 17:27:37 | trigram | 1 | 69583 | 2 | 1.093 | 63662.4 |
1005 | 2023-10-14 15:05:08 | trigram | 1 | 69583 | 2 | 1.220 | 57035.2 |
1004 | 2023-09-26 09:20:41 | trigram | 1 | 69583 | 2 | 1.143 | 60877.5 |
1003 | 2023-09-23 06:35:17 | trigram | 1 | 69583 | 2 | 1.170 | 59472.6 |
1002 | 2023-09-13 07:19:25 | trigram | 4 | 151207 | 817 | 10.016 | 15096.5 |
1001 | 2023-09-10 14:17:44 | trigram | 4 | 151207 | 817 | 18.326 | 8251.0 |
1000 | 2023-09-07 12:05:20 | trigram | 4 | 151207 | 817 | 9.923 | 15238.0 |
999 | 2023-09-03 02:17:31 | trigram | 2 | 107671 | 8 | 2.936 | 36672.7 |
998 | 2023-08-29 11:57:27 | trigram | 1 | 69583 | 2 | 1.203 | 57841.2 |
997 | 2023-08-24 23:13:13 | trigram | 4 | 151207 | 817 | 11.923 | 12682.0 |
996 | 2023-07-21 03:15:21 | trigram | 1 | 69583 | 2 | 1.250 | 55666.4 |
995 | 2023-05-27 09:12:24 | trigram | 1 | 69583 | 2 | 1.030 | 67556.3 |
994 | 2023-05-24 23:41:51 | trigram | 4 | 151207 | 817 | 11.046 | 13688.8 |
993 | 2023-05-24 04:29:25 | trigram | 2 | 107671 | 8 | 2.810 | 38317.1 |
992 | 2023-04-24 14:51:19 | trigram | 4 | 151207 | 817 | 9.686 | 15610.9 |
991 | 2023-04-13 01:10:51 | trigram | 4 | 151207 | 817 | 11.376 | 13291.8 |
990 | 2023-03-26 21:50:36 | trigram | 4 | 151207 | 817 | 12.000 | 12600.6 |
989 | 2023-03-24 07:16:40 | trigram | 1 | 69583 | 2 | 1.063 | 65459.1 |
988 | 2023-03-22 02:54:47 | trigram | 1 | 69583 | 2 | 1.060 | 65644.3 |
987 | 2023-03-15 18:17:54 | trigram | 1 | 69583 | 2 | 1.046 | 66522.9 |
986 | 2023-03-03 19:50:53 | trigram | 4 | 151207 | 817 | 11.503 | 13145.0 |
985 | 2023-03-03 18:03:34 | trigram | 2 | 107671 | 8 | 2.890 | 37256.4 |
984 | 2023-02-22 19:28:25 | trigram | 4 | 151207 | 817 | 10.860 | 13923.3 |
983 | 2023-01-10 01:14:59 | trigram | 1 | 69583 | 2 | 1.186 | 58670.3 |
982 | 2023-01-02 09:20:34 | trigram | 4 | 151207 | 817 | 10.203 | 14819.9 |
981 | 2022-12-19 03:30:05 | trigram | 4 | 151207 | 817 | 10.080 | 15000.7 |
980 | 2022-12-11 06:48:08 | trigram | 4 | 151207 | 817 | 10.626 | 14229.9 |
979 | 2022-12-10 00:49:09 | trigram | 2 | 107671 | 8 | 3.000 | 35890.3 |
978 | 2022-11-10 10:18:37 | trigram | 4 | 151207 | 817 | 11.516 | 13130.2 |
977 | 2022-11-06 15:51:28 | trigram | 1 | 69583 | 2 | 1.173 | 59320.5 |
976 | 2022-11-01 20:33:03 | trigram | 4 | 151207 | 817 | 9.906 | 15264.2 |
975 | 2022-10-10 20:15:15 | trigram | 1 | 69583 | 2 | 1.063 | 65459.1 |
974 | 2022-09-11 23:05:50 | trigram | 4 | 151207 | 817 | 10.640 | 14211.2 |
973 | 2022-08-15 04:27:17 | trigram | 4 | 151207 | 817 | 10.173 | 14863.6 |
972 | 2022-07-29 11:26:56 | trigram | 4 | 151207 | 817 | 11.376 | 13291.8 |
971 | 2022-07-26 23:10:59 | trigram | 4 | 151207 | 817 | 11.250 | 13440.6 |
970 | 2022-07-26 14:32:54 | trigram | 2 | 107671 | 8 | 2.783 | 38688.8 |
969 | 2022-06-26 05:51:13 | trigram | 4 | 151207 | 817 | 9.830 | 15382.2 |
968 | 2022-06-22 01:36:53 | trigram | 1 | 69583 | 2 | 1.046 | 66522.9 |
967 | 2022-05-29 23:15:10 | trigram | 1 | 69583 | 2 | 1.093 | 63662.4 |
966 | 2022-05-27 18:42:34 | trigram | 1 | 69583 | 2 | 1.046 | 66522.9 |
965 | 2022-04-02 08:50:11 | trigram | 4 | 151207 | 817 | 9.876 | 15310.6 |
964 | 2022-03-25 00:52:50 | trigram | 4 | 151207 | 817 | 10.516 | 14378.8 |
963 | 2022-03-02 08:05:34 | trigram | 4 | 151207 | 817 | 9.953 | 15192.1 |
962 | 2022-02-10 01:19:43 | trigram | 1 | 69583 | 2 | 1.156 | 60192.9 |
961 | 2022-02-09 00:39:21 | trigram | 1 | 69583 | 2 | 1.250 | 55666.4 |
960 | 2022-02-03 04:42:12 | trigram | 4 | 151207 | 817 | 10.686 | 14150.0 |
959 | 2022-01-10 16:10:57 | trigram | 4 | 151207 | 817 | 10.686 | 14150.0 |
958 | 2021-12-26 15:31:52 | trigram | 4 | 151207 | 817 | 11.940 | 12663.9 |
957 | 2021-12-19 10:19:06 | trigram | 4 | 151207 | 817 | 15.376 | 9834.0 |
956 | 2021-12-18 20:14:45 | trigram | 4 | 151207 | 817 | 12.330 | 12263.3 |
955 | 2021-12-02 22:58:17 | trigram | 4 | 151207 | 817 | 11.530 | 13114.2 |
954 | 2021-12-02 18:21:53 | trigram | 1 | 69583 | 2 | 1.063 | 65459.1 |