History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"authors"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
412 | 2024-04-19 10:15:34 | authors | 1 | 69583 | 2 | 1.470 | 47335.4 |
411 | 2024-04-09 09:53:49 | authors | 1 | 69583 | 2 | 1.140 | 61037.7 |
410 | 2024-03-30 07:47:09 | authors | 1 | 69583 | 2 | 4.140 | 16807.5 |
409 | 2024-03-23 17:29:33 | authors | 1 | 69583 | 2 | 1.266 | 54962.9 |
408 | 2024-02-27 12:04:13 | authors | 1 | 69583 | 2 | 2.813 | 24736.2 |
407 | 2024-01-24 05:58:46 | authors | 1 | 69583 | 2 | 1.200 | 57985.8 |
406 | 2023-12-27 11:07:40 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |
405 | 2023-12-20 20:45:47 | authors | 2 | 107671 | 21 | 3.013 | 35735.5 |
404 | 2023-11-26 23:04:26 | authors | 1 | 69583 | 2 | 2.580 | 26970.2 |
403 | 2023-11-26 08:16:39 | authors | 1 | 69583 | 2 | 1.296 | 53690.6 |
402 | 2023-11-20 15:25:27 | authors | 3 | 134027 | 261 | 5.920 | 22639.7 |
401 | 2023-11-20 15:25:24 | authors | 2 | 107671 | 21 | 2.830 | 38046.3 |
400 | 2023-11-12 08:46:17 | authors | 1 | 69583 | 2 | 1.220 | 57035.2 |
399 | 2023-11-09 00:47:02 | authors | 1 | 69583 | 2 | 2.356 | 29534.4 |
398 | 2023-11-05 06:17:20 | authors | 1 | 69583 | 2 | 1.220 | 57035.2 |
397 | 2023-10-17 08:06:29 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |
396 | 2023-10-15 00:02:04 | authors | 1 | 69583 | 2 | 2.016 | 34515.4 |
395 | 2023-10-09 10:25:57 | authors | 1 | 69583 | 2 | 1.233 | 56433.9 |
394 | 2023-09-25 09:35:28 | authors | 1 | 69583 | 2 | 1.453 | 47889.2 |
393 | 2023-09-20 22:29:25 | authors | 2 | 107671 | 21 | 2.873 | 37476.9 |
392 | 2023-09-14 11:20:58 | authors | 1 | 69583 | 2 | 1.250 | 55666.4 |
391 | 2023-09-03 06:38:04 | authors | 1 | 69583 | 2 | 1.216 | 57222.9 |
390 | 2023-08-09 20:20:15 | authors | 1 | 69583 | 2 | 1.110 | 62687.4 |
389 | 2023-08-03 22:56:37 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
388 | 2023-07-03 09:50:15 | authors | 1 | 69583 | 2 | 1.080 | 64428.7 |
387 | 2023-06-24 06:10:46 | authors | 2 | 107671 | 21 | 3.220 | 33438.2 |
386 | 2023-06-21 18:19:11 | authors | 1 | 69583 | 2 | 1.126 | 61796.6 |
385 | 2023-06-09 05:47:19 | authors | 1 | 69583 | 2 | 0.970 | 71735.1 |
384 | 2023-05-10 06:39:14 | authors | 1 | 69583 | 2 | 1.106 | 62914.1 |
383 | 2023-05-03 07:22:19 | authors | 1 | 69583 | 2 | 1.110 | 62687.4 |
382 | 2023-04-23 00:58:54 | authors | 1 | 69583 | 2 | 1.186 | 58670.3 |
381 | 2023-03-30 14:55:14 | authors | 1 | 69583 | 2 | 1.186 | 58670.3 |
380 | 2023-03-17 15:43:50 | authors | 2 | 107671 | 21 | 2.830 | 38046.3 |
379 | 2023-03-12 17:44:58 | authors | 1 | 69583 | 2 | 1.156 | 60192.9 |
378 | 2023-03-04 23:23:35 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
377 | 2023-03-01 04:57:41 | authors | 1 | 69583 | 2 | 2.140 | 32515.4 |
376 | 2023-01-18 21:54:51 | authors | 1 | 69583 | 2 | 1.080 | 64428.7 |
375 | 2023-01-17 08:49:38 | authors | 1 | 69583 | 2 | 1.220 | 57035.2 |
374 | 2023-01-01 17:29:35 | authors | 1 | 69583 | 2 | 1.283 | 54234.6 |
373 | 2022-12-27 01:21:07 | authors | 1 | 69583 | 2 | 1.250 | 55666.4 |
372 | 2022-12-21 18:35:54 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |
371 | 2022-12-20 04:54:15 | authors | 2 | 107671 | 21 | 2.970 | 36252.9 |
370 | 2022-12-04 23:50:07 | authors | 1 | 69583 | 2 | 1.186 | 58670.3 |
369 | 2022-11-17 09:03:19 | authors | 1 | 69583 | 2 | 1.266 | 54962.9 |
368 | 2022-10-02 03:46:35 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |
367 | 2022-09-14 16:33:45 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
366 | 2022-09-13 22:26:48 | authors | 1 | 69583 | 2 | 1.080 | 64428.7 |
365 | 2022-09-05 07:15:15 | authors | 1 | 69583 | 2 | 1.093 | 63662.4 |
364 | 2022-09-04 03:55:17 | authors | 1 | 69583 | 2 | 1.080 | 64428.7 |
363 | 2022-08-27 23:31:42 | authors | 1 | 69583 | 2 | 1.266 | 54962.9 |
362 | 2022-08-19 06:36:49 | authors | 1 | 69583 | 2 | 1.186 | 58670.3 |
361 | 2022-08-14 21:04:34 | authors | 2 | 107671 | 21 | 2.846 | 37832.4 |
360 | 2022-07-13 19:56:49 | authors | 1 | 69583 | 2 | 1.190 | 58473.1 |
359 | 2022-06-29 01:39:43 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
358 | 2022-06-28 15:48:09 | authors | 1 | 69583 | 2 | 1.313 | 52995.4 |
357 | 2022-05-26 18:08:56 | authors | 1 | 69583 | 2 | 1.093 | 63662.4 |
356 | 2022-05-26 08:07:32 | authors | 1 | 69583 | 2 | 1.110 | 62687.4 |
355 | 2022-05-11 05:17:28 | authors | 1 | 69583 | 2 | 1.093 | 63662.4 |
354 | 2022-04-08 05:10:07 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
353 | 2022-03-26 03:20:06 | authors | 2 | 107671 | 21 | 3.516 | 30623.2 |
352 | 2022-03-23 12:03:58 | authors | 1 | 69583 | 2 | 1.610 | 43219.3 |
351 | 2022-03-08 09:39:01 | authors | 1 | 69583 | 2 | 1.906 | 36507.3 |
350 | 2022-02-18 07:46:57 | authors | 1 | 69583 | 2 | 1.110 | 62687.4 |
349 | 2021-12-20 21:23:22 | authors | 1 | 69583 | 2 | 1.220 | 57035.2 |
348 | 2021-12-07 21:34:43 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |
347 | 2021-11-13 15:43:38 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |
346 | 2021-11-01 12:40:46 | authors | 1 | 69583 | 2 | 1.250 | 55666.4 |
345 | 2021-11-01 11:39:14 | authors | 1 | 69583 | 2 | 1.250 | 55666.4 |
344 | 2021-10-23 20:18:24 | authors | 1 | 69583 | 2 | 1.233 | 56433.9 |
343 | 2021-10-21 18:41:51 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
342 | 2021-09-07 11:55:42 | authors | 1 | 69583 | 2 | 2.173 | 32021.6 |
341 | 2021-08-20 19:50:08 | authors | 1 | 69583 | 2 | 1.093 | 63662.4 |
340 | 2021-08-14 01:40:35 | authors | 1 | 69583 | 2 | 1.110 | 62687.4 |
339 | 2021-06-04 11:23:00 | authors | 1 | 69583 | 2 | 1.610 | 43219.3 |
338 | 2021-05-20 21:29:03 | authors | 1 | 69583 | 2 | 1.233 | 56433.9 |
337 | 2021-05-13 08:50:10 | authors | 1 | 69583 | 2 | 1.173 | 59320.5 |
336 | 2021-05-10 05:25:40 | authors | 1 | 69583 | 2 | 1.283 | 54234.6 |
335 | 2021-05-09 19:12:46 | authors | 1 | 69583 | 2 | 1.126 | 61796.6 |
334 | 2021-04-08 22:11:57 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
333 | 2021-04-07 09:52:09 | authors | 3 | 134027 | 261 | 7.406 | 18097.1 |
332 | 2021-03-24 14:35:17 | authors | 3 | 134027 | 261 | 6.796 | 19721.5 |
331 | 2021-03-23 19:50:34 | authors | 1 | 69583 | 2 | 1.313 | 52995.4 |
330 | 2021-03-13 03:22:17 | authors | 1 | 69583 | 2 | 1.096 | 63488.1 |
329 | 2021-02-04 06:26:57 | authors | 1 | 69583 | 2 | 1.330 | 52318.0 |
328 | 2021-02-03 00:13:29 | authors | 3 | 134027 | 261 | 5.813 | 23056.4 |
327 | 2021-01-06 00:44:20 | authors | 1 | 69583 | 2 | 1.220 | 57035.2 |
326 | 2020-12-25 07:27:51 | authors | 1 | 69583 | 2 | 1.096 | 63488.1 |
325 | 2020-12-09 10:16:44 | authors | 3 | 134027 | 261 | 6.580 | 20368.8 |
324 | 2020-12-09 10:16:41 | authors | 2 | 107671 | 21 | 2.856 | 37699.9 |
323 | 2020-12-09 10:16:40 | authors | 1 | 69583 | 2 | 1.093 | 63662.4 |
322 | 2020-12-08 14:26:06 | authors | 1 | 69583 | 2 | 1.076 | 64668.2 |
321 | 2020-11-02 19:54:05 | authors | 1 | 69583 | 2 | 1.110 | 62687.4 |
320 | 2020-09-17 20:08:44 | authors | 1 | 69583 | 2 | 1.093 | 63662.4 |
319 | 2020-07-30 19:44:49 | authors | 1 | 69583 | 2 | 1.250 | 55666.4 |
318 | 2020-07-26 19:38:05 | authors | 1 | 69583 | 2 | 1.120 | 62127.7 |
317 | 2020-07-23 16:20:34 | authors | 1 | 69583 | 2 | 1.640 | 42428.7 |
316 | 2020-07-11 01:05:06 | authors | 1 | 69583 | 2 | 1.140 | 61037.7 |
315 | 2020-05-01 15:11:36 | authors | 1 | 69583 | 2 | 1.200 | 57985.8 |
314 | 2020-04-18 06:23:23 | authors | 1 | 69583 | 2 | 1.096 | 63488.1 |
313 | 2020-04-17 06:22:14 | authors | 1 | 69583 | 2 | 1.203 | 57841.2 |