History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"submit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
313 | 2024-05-04 02:24:03 | submit | 1 | 48755 | 3 | 0.826 | 59025.4 |
312 | 2024-04-25 23:26:50 | submit | 3 | 112716 | 235 | 14.313 | 7875.1 |
311 | 2024-04-25 14:51:08 | submit | 2 | 82551 | 23 | 2.423 | 34069.7 |
310 | 2024-04-25 14:50:52 | submit | 3 | 112716 | 235 | 5.766 | 19548.4 |
309 | 2024-04-24 23:00:48 | submit | 3 | 112716 | 235 | 6.596 | 17088.5 |
308 | 2024-04-24 23:00:48 | submit | 2 | 82551 | 23 | 5.843 | 14128.2 |
307 | 2024-04-20 22:25:08 | submit | 3 | 112716 | 235 | 14.890 | 7569.9 |
306 | 2024-04-20 22:25:09 | submit | 2 | 82551 | 23 | 5.220 | 15814.4 |
305 | 2024-04-20 22:24:45 | submit | 3 | 112716 | 235 | 20.596 | 5472.7 |
304 | 2024-04-20 22:25:02 | submit | 1 | 48755 | 3 | 0.966 | 50471.0 |
303 | 2024-04-20 22:24:46 | submit | 2 | 82551 | 23 | 3.000 | 27517.0 |
302 | 2024-04-20 22:24:23 | submit | 1 | 48755 | 3 | 0.983 | 49598.2 |
301 | 2024-04-07 11:01:12 | submit | 1 | 48755 | 3 | 3.390 | 14382.0 |
300 | 2024-03-31 17:57:32 | submit | 1 | 48755 | 3 | 1.640 | 29728.7 |
299 | 2024-03-28 17:27:57 | submit | 1 | 48755 | 3 | 2.203 | 22131.2 |
298 | 2024-03-18 06:46:07 | submit | 1 | 48755 | 3 | 0.966 | 50471.0 |
297 | 2024-02-29 21:30:17 | submit | 2 | 82551 | 23 | 2.420 | 34112.0 |
296 | 2024-02-29 21:30:13 | submit | 3 | 112716 | 235 | 5.420 | 20796.3 |
295 | 2024-02-29 00:30:15 | submit | 1 | 48755 | 3 | 0.923 | 52822.3 |
294 | 2024-02-29 00:30:12 | submit | 2 | 82551 | 23 | 2.626 | 31436.0 |
293 | 2024-02-26 07:59:36 | submit | 3 | 112716 | 235 | 12.126 | 9295.4 |
292 | 2024-02-22 11:27:34 | submit | 2 | 82551 | 23 | 8.796 | 9385.1 |
291 | 2024-02-22 05:04:35 | submit | 3 | 112716 | 235 | 6.030 | 18692.5 |
290 | 2024-02-21 18:36:53 | submit | 3 | 112716 | 235 | 13.280 | 8487.7 |
289 | 2024-02-19 19:43:00 | submit | 3 | 112716 | 235 | 12.110 | 9307.7 |
288 | 2024-02-19 14:27:46 | submit | 1 | 48755 | 3 | 0.936 | 52088.7 |
287 | 2024-02-19 07:31:12 | submit | 2 | 82551 | 23 | 2.500 | 33020.4 |
286 | 2024-02-19 07:30:39 | submit | 3 | 112716 | 235 | 5.500 | 20493.8 |
285 | 2024-02-18 17:29:50 | submit | 3 | 112716 | 235 | 10.580 | 10653.7 |
284 | 2024-02-14 19:21:40 | submit | 2 | 82551 | 23 | 4.766 | 17320.8 |
283 | 2024-02-14 19:21:38 | submit | 1 | 48755 | 3 | 1.530 | 31866.0 |
282 | 2024-01-22 11:30:10 | submit | 3 | 112716 | 235 | 8.720 | 12926.1 |
281 | 2024-01-19 11:37:38 | submit | 3 | 112716 | 235 | 5.983 | 18839.4 |
280 | 2024-01-13 20:22:23 | submit | 1 | 48755 | 3 | 0.843 | 57835.1 |
279 | 2024-01-09 13:33:41 | submit | 2 | 82551 | 23 | 2.390 | 34540.2 |
278 | 2024-01-09 13:33:38 | submit | 3 | 112716 | 235 | 4.796 | 23502.1 |
277 | 2023-12-01 22:05:33 | submit | 1 | 48755 | 3 | 0.766 | 63648.8 |
276 | 2023-11-17 11:33:15 | submit | 3 | 112716 | 235 | 4.750 | 23729.7 |
275 | 2023-11-17 01:21:50 | submit | 1 | 48755 | 3 | 0.856 | 56956.8 |
274 | 2023-11-05 20:16:01 | submit | 1 | 48755 | 3 | 0.766 | 63648.8 |
273 | 2023-10-22 20:08:52 | submit | 1 | 48755 | 3 | 0.906 | 53813.5 |
272 | 2023-10-19 11:03:53 | submit | 1 | 48755 | 3 | 0.890 | 54780.9 |
271 | 2023-10-17 10:22:05 | submit | 1 | 48755 | 3 | 0.893 | 54596.9 |
270 | 2023-09-29 21:21:44 | submit | 1 | 48755 | 3 | 0.860 | 56691.9 |
269 | 2023-09-29 08:34:12 | submit | 1 | 48755 | 3 | 0.750 | 65006.7 |
268 | 2023-09-16 11:18:37 | submit | 1 | 48755 | 3 | 0.856 | 56956.8 |
267 | 2023-09-15 14:03:29 | submit | 1 | 48755 | 3 | 0.843 | 57835.1 |
266 | 2023-08-18 14:27:52 | submit | 3 | 112716 | 235 | 5.623 | 20045.5 |
265 | 2023-06-30 03:38:25 | submit | 1 | 48755 | 3 | 0.750 | 65006.7 |
264 | 2023-05-27 10:56:05 | submit | 1 | 48755 | 3 | 0.750 | 65006.7 |
263 | 2023-04-30 20:34:41 | submit | 3 | 112716 | 235 | 4.626 | 24365.8 |
262 | 2023-04-27 14:44:53 | submit | 1 | 48755 | 3 | 0.860 | 56691.9 |
261 | 2023-04-08 05:38:55 | submit | 1 | 48755 | 3 | 0.750 | 65006.7 |
260 | 2023-03-28 20:01:43 | submit | 1 | 48755 | 3 | 0.810 | 60191.4 |
259 | 2023-03-23 12:56:03 | submit | 1 | 48755 | 3 | 0.796 | 61250.0 |
258 | 2023-02-04 21:58:55 | submit | 3 | 112716 | 235 | 4.580 | 24610.5 |
257 | 2023-01-28 01:25:24 | submit | 1 | 48755 | 3 | 0.796 | 61250.0 |
256 | 2023-01-22 22:49:37 | submit | 1 | 48755 | 3 | 0.750 | 65006.7 |
255 | 2023-01-14 10:17:38 | submit | 3 | 112716 | 235 | 5.640 | 19985.1 |
254 | 2022-12-01 22:45:52 | submit | 3 | 112716 | 235 | 7.343 | 15350.1 |
253 | 2022-11-24 01:30:56 | submit | 3 | 112716 | 235 | 5.326 | 21163.3 |
252 | 2022-11-23 01:28:50 | submit | 2 | 82551 | 23 | 2.563 | 32208.7 |
251 | 2022-11-19 19:02:42 | submit | 1 | 48755 | 3 | 0.796 | 61250.0 |
250 | 2022-11-14 21:56:48 | submit | 3 | 112716 | 235 | 4.593 | 24540.8 |
249 | 2022-11-09 10:57:59 | submit | 3 | 112716 | 235 | 5.126 | 21989.1 |
248 | 2022-10-14 03:56:40 | submit | 3 | 112716 | 235 | 4.783 | 23566.0 |
247 | 2022-09-18 12:12:45 | submit | 1 | 48755 | 3 | 0.813 | 59969.2 |
246 | 2022-09-01 07:30:13 | submit | 3 | 112716 | 235 | 4.826 | 23356.0 |
245 | 2022-08-29 14:22:40 | submit | 3 | 112716 | 235 | 5.220 | 21593.1 |
244 | 2022-08-14 21:31:38 | submit | 3 | 112716 | 235 | 5.233 | 21539.5 |
243 | 2022-07-29 05:37:55 | submit | 1 | 48755 | 3 | 0.763 | 63899.1 |
242 | 2022-07-19 08:26:03 | submit | 2 | 82551 | 23 | 2.390 | 34540.2 |
241 | 2022-07-14 12:11:03 | submit | 3 | 112716 | 235 | 4.826 | 23356.0 |
240 | 2022-07-11 16:02:58 | submit | 1 | 48755 | 3 | 0.766 | 63648.8 |
239 | 2022-07-09 11:07:24 | submit | 1 | 48755 | 3 | 0.796 | 61250.0 |
238 | 2022-06-29 14:18:03 | submit | 2 | 82551 | 23 | 2.186 | 37763.5 |
237 | 2022-06-27 10:24:25 | submit | 2 | 82551 | 23 | 2.140 | 38575.2 |
236 | 2022-06-17 00:42:15 | submit | 3 | 112716 | 235 | 4.813 | 23419.1 |
235 | 2022-05-05 14:42:42 | submit | 1 | 48755 | 3 | 0.766 | 63648.8 |
234 | 2022-03-05 13:53:52 | submit | 1 | 48755 | 3 | 0.890 | 54780.9 |
233 | 2022-02-21 17:49:29 | submit | 2 | 82551 | 23 | 2.733 | 30205.3 |
232 | 2022-01-05 01:09:29 | submit | 1 | 48755 | 3 | 0.936 | 52088.7 |
231 | 2022-01-02 00:36:33 | submit | 1 | 48755 | 3 | 0.826 | 59025.4 |
230 | 2021-09-22 13:23:05 | submit | 1 | 48755 | 3 | 0.873 | 55847.7 |
229 | 2021-06-19 11:20:01 | submit | 1 | 48755 | 3 | 0.920 | 52994.6 |
228 | 2021-05-31 22:00:47 | submit | 1 | 48755 | 3 | 0.780 | 62506.4 |
227 | 2021-05-29 08:28:43 | submit | 2 | 82551 | 23 | 2.830 | 29170.0 |
226 | 2021-05-06 16:38:20 | submit | 1 | 48755 | 3 | 0.890 | 54780.9 |
225 | 2021-05-03 19:02:26 | submit | 2 | 82551 | 23 | 2.626 | 31436.0 |
224 | 2021-04-04 20:35:36 | submit | 1 | 48755 | 3 | 0.876 | 55656.4 |
223 | 2021-04-02 00:04:44 | submit | 2 | 82551 | 23 | 2.576 | 32046.2 |
222 | 2021-03-16 21:46:15 | submit | 1 | 48755 | 3 | 0.780 | 62506.4 |
221 | 2021-02-10 13:28:07 | submit | 2 | 82551 | 23 | 2.393 | 34496.9 |
220 | 2021-01-20 05:00:21 | submit | 1 | 48755 | 3 | 0.750 | 65006.7 |
219 | 2021-01-17 00:21:50 | submit | 2 | 82551 | 23 | 2.140 | 38575.2 |
218 | 2020-12-06 06:51:37 | submit | 1 | 48755 | 3 | 0.906 | 53813.5 |
217 | 2020-11-25 05:50:19 | submit | 1 | 48755 | 3 | 0.763 | 63899.1 |
216 | 2020-11-22 06:40:12 | submit | 2 | 82551 | 23 | 2.140 | 38575.2 |
215 | 2020-10-31 15:54:10 | submit | 2 | 82551 | 23 | 2.186 | 37763.5 |
214 | 2020-10-28 09:17:48 | submit | 2 | 82551 | 23 | 2.220 | 37185.1 |