History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"book"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1160 | 2024-04-14 11:10:08 | book | 2 | 29872 | 282 | 0.843 | 35435.3 |
1159 | 2024-04-05 00:26:14 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1158 | 2024-04-02 18:43:31 | book | 1 | 13983 | 24 | 0.530 | 26383.0 |
1157 | 2024-03-30 23:53:28 | book | 1 | 13983 | 24 | 0.516 | 27098.8 |
1156 | 2024-03-26 23:48:47 | book | 1 | 13983 | 24 | 0.263 | 53167.3 |
1155 | 2024-03-20 10:15:16 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1154 | 2024-03-19 13:25:58 | book | 2 | 29872 | 282 | 2.076 | 14389.2 |
1153 | 2024-03-19 13:25:32 | book | 1 | 13983 | 24 | 0.563 | 24836.6 |
1152 | 2024-03-05 20:06:15 | book | 1 | 13983 | 24 | 0.906 | 15433.8 |
1151 | 2024-03-02 18:34:45 | book | 2 | 29872 | 282 | 3.033 | 9849.0 |
1150 | 2024-03-02 16:54:58 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1149 | 2024-02-29 23:00:48 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1148 | 2024-02-25 16:50:50 | book | 1 | 13983 | 24 | 0.783 | 17858.2 |
1147 | 2024-02-18 10:08:08 | book | 1 | 13983 | 24 | 0.796 | 17566.6 |
1146 | 2024-01-28 17:02:35 | book | 1 | 13983 | 24 | 0.236 | 59250.0 |
1145 | 2024-01-17 04:34:31 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1144 | 2024-01-16 13:57:57 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1143 | 2024-01-09 02:51:35 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1142 | 2023-12-31 06:02:40 | book | 2 | 29872 | 282 | 0.843 | 35435.3 |
1141 | 2023-12-25 10:11:50 | book | 2 | 29872 | 282 | 1.763 | 16943.8 |
1140 | 2023-12-13 09:59:55 | book | 2 | 29872 | 282 | 0.800 | 37340.0 |
1139 | 2023-12-03 14:27:41 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1138 | 2023-12-03 14:27:40 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1137 | 2023-11-29 06:49:41 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1136 | 2023-11-27 01:31:40 | book | 2 | 29872 | 282 | 0.780 | 38297.4 |
1135 | 2023-11-18 09:22:07 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1134 | 2023-11-13 07:39:04 | book | 2 | 29872 | 282 | 1.936 | 15429.8 |
1133 | 2023-11-09 22:48:01 | book | 1 | 13983 | 24 | 0.236 | 59250.0 |
1132 | 2023-11-02 08:03:22 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1131 | 2023-11-01 20:15:11 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1130 | 2023-10-31 22:00:55 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1129 | 2023-10-28 18:37:06 | book | 2 | 29872 | 282 | 0.826 | 36164.6 |
1128 | 2023-10-26 18:39:16 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1127 | 2023-10-19 20:58:09 | book | 1 | 13983 | 24 | 0.236 | 59250.0 |
1126 | 2023-10-17 07:00:20 | book | 1 | 13983 | 24 | 0.263 | 53167.3 |
1125 | 2023-10-11 16:35:50 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1124 | 2023-10-06 00:16:08 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1123 | 2023-10-03 17:43:22 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1122 | 2023-09-25 07:09:35 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1121 | 2023-09-13 01:14:52 | book | 2 | 29872 | 282 | 0.750 | 39829.3 |
1120 | 2023-08-25 17:36:36 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1119 | 2023-08-11 15:19:31 | book | 2 | 29872 | 282 | 0.733 | 40753.1 |
1118 | 2023-07-08 18:42:47 | book | 2 | 29872 | 282 | 0.766 | 38997.4 |
1117 | 2023-06-30 03:30:09 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1116 | 2023-06-29 11:54:40 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1115 | 2023-06-06 07:16:24 | book | 2 | 29872 | 282 | 0.716 | 41720.7 |
1114 | 2023-05-28 16:12:01 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1113 | 2023-03-31 12:23:21 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1112 | 2023-03-26 18:42:55 | book | 1 | 13983 | 24 | 0.236 | 59250.0 |
1111 | 2023-03-24 06:00:10 | book | 1 | 13983 | 24 | 0.203 | 68881.8 |
1110 | 2023-03-09 17:05:12 | book | 2 | 29872 | 282 | 0.736 | 40587.0 |
1109 | 2023-02-07 13:24:26 | book | 2 | 29872 | 282 | 0.733 | 40753.1 |
1108 | 2023-01-09 00:06:49 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1107 | 2022-12-22 02:05:25 | book | 2 | 29872 | 282 | 0.733 | 40753.1 |
1106 | 2022-12-21 15:06:52 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1105 | 2022-12-15 08:13:02 | book | 2 | 29872 | 282 | 0.813 | 36742.9 |
1104 | 2022-12-10 19:52:43 | book | 2 | 29872 | 282 | 0.860 | 34734.9 |
1103 | 2022-11-05 02:24:15 | book | 2 | 29872 | 282 | 0.890 | 33564.0 |
1102 | 2022-11-03 19:36:27 | book | 2 | 29872 | 282 | 0.826 | 36164.6 |
1101 | 2022-10-25 19:41:09 | book | 2 | 29872 | 282 | 0.810 | 36879.0 |
1100 | 2022-10-24 13:17:13 | book | 2 | 29872 | 282 | 0.830 | 35990.4 |
1099 | 2022-10-08 17:44:04 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1098 | 2022-09-21 08:43:18 | book | 2 | 29872 | 282 | 0.750 | 39829.3 |
1097 | 2022-09-15 02:42:18 | book | 2 | 29872 | 282 | 0.750 | 39829.3 |
1096 | 2022-09-14 15:03:40 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1095 | 2022-09-02 12:09:59 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1094 | 2022-09-01 15:00:26 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1093 | 2022-08-30 04:28:00 | book | 2 | 29872 | 282 | 0.826 | 36164.6 |
1092 | 2022-08-04 22:12:37 | book | 2 | 29872 | 282 | 0.750 | 39829.3 |
1091 | 2022-06-12 00:27:04 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1090 | 2022-05-30 17:25:42 | book | 1 | 13983 | 24 | 0.236 | 59250.0 |
1089 | 2022-05-25 07:19:07 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1088 | 2022-05-06 23:04:02 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1087 | 2022-05-05 17:13:33 | book | 1 | 13983 | 24 | 0.266 | 52567.7 |
1086 | 2022-05-04 16:03:04 | book | 1 | 13983 | 24 | 0.296 | 47239.9 |
1085 | 2022-05-03 16:31:14 | book | 1 | 13983 | 24 | 0.330 | 42372.7 |
1084 | 2022-03-10 13:50:46 | book | 1 | 13983 | 24 | 0.343 | 40766.8 |
1083 | 2022-03-08 10:49:17 | book | 2 | 29872 | 282 | 0.970 | 30795.9 |
1082 | 2022-02-08 18:07:29 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1081 | 2022-01-20 22:31:28 | book | 1 | 13983 | 24 | 0.436 | 32071.1 |
1080 | 2022-01-06 05:22:25 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1079 | 2022-01-05 15:52:03 | book | 1 | 13983 | 24 | 0.263 | 53167.3 |
1078 | 2022-01-05 07:34:23 | book | 1 | 13983 | 24 | 0.236 | 59250.0 |
1077 | 2022-01-04 17:11:11 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1076 | 2022-01-02 20:57:22 | book | 1 | 13983 | 24 | 0.423 | 33056.7 |
1075 | 2022-01-01 18:11:44 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1074 | 2021-12-10 05:21:26 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1073 | 2021-12-07 15:06:09 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1072 | 2021-12-07 03:31:48 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1071 | 2021-12-06 22:44:11 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1070 | 2021-12-06 18:34:59 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1069 | 2021-12-06 04:25:33 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1068 | 2021-12-05 18:28:45 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1067 | 2021-12-05 01:22:30 | book | 1 | 13983 | 24 | 0.220 | 63559.1 |
1066 | 2021-12-04 18:14:13 | book | 2 | 29872 | 282 | 0.843 | 35435.3 |
1065 | 2021-12-04 15:33:55 | book | 1 | 13983 | 24 | 0.250 | 55932.0 |
1064 | 2021-12-04 05:20:56 | book | 1 | 13983 | 24 | 0.216 | 64736.1 |
1063 | 2021-12-03 11:37:34 | book | 1 | 13983 | 24 | 0.343 | 40766.8 |
1062 | 2021-12-03 02:54:02 | book | 1 | 13983 | 24 | 0.233 | 60012.9 |
1061 | 2021-12-02 19:36:39 | book | 1 | 13983 | 24 | 0.546 | 25609.9 |