History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lectern"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
472 | 2024-03-31 03:52:41 | lectern | 1 | 69583 | 2 | 1.203 | 57841.2 |
471 | 2024-03-29 12:38:41 | lectern | 1 | 69583 | 2 | 2.953 | 23563.5 |
470 | 2024-03-01 16:03:23 | lectern | 3 | 134027 | 313 | 12.670 | 10578.3 |
469 | 2024-02-28 10:28:45 | lectern | 1 | 69583 | 2 | 2.046 | 34009.3 |
468 | 2024-02-28 08:26:18 | lectern | 3 | 134027 | 313 | 21.423 | 6256.2 |
467 | 2024-02-26 02:09:50 | lectern | 3 | 134027 | 313 | 19.033 | 7041.8 |
466 | 2024-02-26 02:09:52 | lectern | 2 | 107671 | 24 | 5.423 | 19854.5 |
465 | 2024-02-26 02:09:45 | lectern | 1 | 69583 | 2 | 1.420 | 49002.1 |
464 | 2024-02-18 06:37:58 | lectern | 1 | 69583 | 2 | 2.720 | 25582.0 |
463 | 2024-02-01 16:32:57 | lectern | 2 | 107671 | 24 | 2.843 | 37872.3 |
462 | 2024-01-15 00:29:05 | lectern | 1 | 69583 | 2 | 1.076 | 64668.2 |
461 | 2023-12-24 23:04:55 | lectern | 3 | 134027 | 313 | 5.766 | 23244.4 |
460 | 2023-12-19 10:54:58 | lectern | 1 | 69583 | 2 | 1.220 | 57035.2 |
459 | 2023-12-10 07:00:33 | lectern | 2 | 107671 | 24 | 2.830 | 38046.3 |
458 | 2023-12-10 06:49:42 | lectern | 3 | 134027 | 313 | 7.453 | 17983.0 |
457 | 2023-12-09 12:33:41 | lectern | 3 | 134027 | 313 | 6.686 | 20045.9 |
456 | 2023-12-08 10:05:05 | lectern | 2 | 107671 | 24 | 3.173 | 33933.5 |
455 | 2023-11-29 20:24:17 | lectern | 3 | 134027 | 313 | 7.156 | 18729.3 |
454 | 2023-11-29 20:24:18 | lectern | 2 | 107671 | 24 | 3.483 | 30913.3 |
453 | 2023-11-13 01:58:58 | lectern | 1 | 69583 | 2 | 1.186 | 58670.3 |
452 | 2023-11-10 23:17:20 | lectern | 1 | 69583 | 2 | 1.076 | 64668.2 |
451 | 2023-11-10 06:19:21 | lectern | 2 | 107671 | 24 | 3.920 | 27467.1 |
450 | 2023-11-07 21:40:34 | lectern | 1 | 69583 | 2 | 1.106 | 62914.1 |
449 | 2023-11-07 09:28:23 | lectern | 1 | 69583 | 2 | 1.250 | 55666.4 |
448 | 2023-10-29 15:19:57 | lectern | 3 | 134027 | 313 | 6.893 | 19443.9 |
447 | 2023-10-29 15:19:50 | lectern | 2 | 107671 | 24 | 3.296 | 32667.2 |
446 | 2023-10-27 16:23:58 | lectern | 1 | 69583 | 2 | 1.123 | 61961.7 |
445 | 2023-10-20 18:06:21 | lectern | 1 | 69583 | 2 | 1.063 | 65459.1 |
444 | 2023-10-17 23:56:57 | lectern | 1 | 69583 | 2 | 1.216 | 57222.9 |
443 | 2023-10-11 19:43:55 | lectern | 1 | 69583 | 2 | 1.220 | 57035.2 |
442 | 2023-10-04 13:00:17 | lectern | 1 | 69583 | 2 | 1.313 | 52995.4 |
441 | 2023-09-25 20:45:58 | lectern | 3 | 134027 | 313 | 6.483 | 20673.6 |
440 | 2023-09-25 20:45:59 | lectern | 2 | 107671 | 24 | 3.173 | 33933.5 |
439 | 2023-09-21 18:34:20 | lectern | 1 | 69583 | 2 | 1.046 | 66522.9 |
438 | 2023-09-19 14:34:04 | lectern | 1 | 69583 | 2 | 2.283 | 30478.8 |
437 | 2023-09-10 14:41:34 | lectern | 3 | 134027 | 313 | 9.016 | 14865.5 |
436 | 2023-09-08 07:17:13 | lectern | 3 | 134027 | 313 | 5.750 | 23309.0 |
435 | 2023-08-29 02:58:55 | lectern | 1 | 69583 | 2 | 1.096 | 63488.1 |
434 | 2023-08-16 15:10:58 | lectern | 1 | 69583 | 2 | 1.076 | 64668.2 |
433 | 2023-08-12 17:31:23 | lectern | 2 | 107671 | 24 | 2.843 | 37872.3 |
432 | 2023-05-31 16:21:33 | lectern | 1 | 69583 | 2 | 1.156 | 60192.9 |
431 | 2023-05-26 01:14:32 | lectern | 3 | 134027 | 313 | 5.653 | 23709.0 |
430 | 2023-05-17 01:12:50 | lectern | 1 | 69583 | 2 | 1.046 | 66522.9 |
429 | 2023-04-28 13:11:37 | lectern | 1 | 69583 | 2 | 1.046 | 66522.9 |
428 | 2023-04-28 05:11:47 | lectern | 2 | 107671 | 24 | 2.826 | 38100.1 |
427 | 2023-04-27 06:57:37 | lectern | 3 | 134027 | 313 | 6.186 | 21666.2 |
426 | 2023-04-24 20:36:31 | lectern | 1 | 69583 | 2 | 1.063 | 65459.1 |
425 | 2023-03-31 03:36:43 | lectern | 3 | 134027 | 313 | 5.750 | 23309.0 |
424 | 2023-03-27 18:16:09 | lectern | 1 | 69583 | 2 | 1.046 | 66522.9 |
423 | 2023-03-25 09:50:00 | lectern | 1 | 69583 | 2 | 2.610 | 26660.2 |
422 | 2023-03-05 02:26:55 | lectern | 3 | 134027 | 313 | 5.860 | 22871.5 |
421 | 2023-02-04 14:36:23 | lectern | 2 | 107671 | 24 | 3.296 | 32667.2 |
420 | 2023-01-10 22:04:33 | lectern | 1 | 69583 | 2 | 1.046 | 66522.9 |
419 | 2023-01-05 00:13:44 | lectern | 1 | 69583 | 2 | 2.436 | 28564.4 |
418 | 2022-12-12 02:59:30 | lectern | 3 | 134027 | 313 | 5.720 | 23431.3 |
417 | 2022-11-17 15:29:28 | lectern | 2 | 107671 | 24 | 3.280 | 32826.5 |
416 | 2022-10-13 03:59:29 | lectern | 1 | 69583 | 2 | 1.110 | 62687.4 |
415 | 2022-08-31 10:04:52 | lectern | 1 | 69583 | 2 | 1.093 | 63662.4 |
414 | 2022-08-28 02:52:07 | lectern | 1 | 69583 | 2 | 1.216 | 57222.9 |
413 | 2022-07-19 21:09:05 | lectern | 3 | 134027 | 313 | 14.940 | 8971.0 |
412 | 2022-07-17 14:06:55 | lectern | 3 | 134027 | 313 | 6.500 | 20619.5 |
411 | 2022-07-15 05:54:42 | lectern | 3 | 134027 | 313 | 5.703 | 23501.1 |
410 | 2022-05-29 06:40:18 | lectern | 1 | 69583 | 2 | 1.033 | 67360.1 |
409 | 2022-05-18 15:06:13 | lectern | 1 | 69583 | 2 | 1.233 | 56433.9 |
408 | 2022-05-06 12:11:21 | lectern | 2 | 107671 | 24 | 3.046 | 35348.3 |
407 | 2022-04-23 22:55:09 | lectern | 1 | 69583 | 2 | 1.076 | 64668.2 |
406 | 2022-02-23 16:34:31 | lectern | 3 | 134027 | 313 | 7.766 | 17258.2 |
405 | 2022-02-12 14:39:45 | lectern | 1 | 69583 | 2 | 1.233 | 56433.9 |
404 | 2021-12-29 00:51:33 | lectern | 1 | 69583 | 2 | 1.080 | 64428.7 |
403 | 2021-12-18 20:40:26 | lectern | 1 | 69583 | 2 | 1.300 | 53525.4 |
402 | 2021-09-12 07:01:22 | lectern | 1 | 69583 | 2 | 1.076 | 64668.2 |
401 | 2021-07-06 04:30:24 | lectern | 1 | 69583 | 2 | 1.203 | 57841.2 |
400 | 2021-06-12 00:49:38 | lectern | 1 | 69583 | 2 | 1.060 | 65644.3 |
399 | 2021-05-26 17:22:36 | lectern | 1 | 69583 | 2 | 1.186 | 58670.3 |
398 | 2021-04-30 22:13:20 | lectern | 1 | 69583 | 2 | 2.453 | 28366.5 |
397 | 2021-03-12 15:18:49 | lectern | 1 | 69583 | 2 | 1.233 | 56433.9 |
396 | 2021-02-08 00:35:08 | lectern | 1 | 69583 | 2 | 1.063 | 65459.1 |
395 | 2020-12-15 02:26:39 | lectern | 1 | 69583 | 2 | 1.093 | 63662.4 |
394 | 2020-12-09 11:12:25 | lectern | 1 | 69583 | 2 | 1.063 | 65459.1 |
393 | 2020-11-13 05:42:03 | lectern | 1 | 69583 | 2 | 1.080 | 64428.7 |
392 | 2020-10-27 00:20:42 | lectern | 1 | 69583 | 2 | 2.516 | 27656.2 |
391 | 2020-10-17 03:21:47 | lectern | 1 | 69583 | 2 | 1.110 | 62687.4 |
390 | 2020-09-06 10:14:25 | lectern | 1 | 69583 | 2 | 1.173 | 59320.5 |
389 | 2020-05-28 20:20:57 | lectern | 1 | 69583 | 2 | 1.046 | 66522.9 |
388 | 2020-03-28 17:44:09 | lectern | 1 | 69583 | 2 | 2.516 | 27656.2 |
387 | 2020-03-28 05:11:10 | lectern | 1 | 69583 | 2 | 1.220 | 57035.2 |
386 | 2020-03-24 19:09:19 | lectern | 1 | 69583 | 2 | 1.140 | 61037.7 |
385 | 2020-03-24 06:14:04 | lectern | 1 | 69583 | 2 | 1.190 | 58473.1 |
384 | 2020-03-21 01:44:54 | lectern | 1 | 69583 | 2 | 1.156 | 60192.9 |
383 | 2020-03-05 19:31:53 | lectern | 3 | 134027 | 313 | 7.220 | 18563.3 |
382 | 2020-03-05 15:33:06 | lectern | 1 | 69583 | 2 | 1.436 | 48456.1 |
381 | 2020-03-04 22:14:00 | lectern | 3 | 134027 | 313 | 7.423 | 18055.6 |
380 | 2020-03-03 05:56:13 | lectern | 3 | 134027 | 313 | 7.236 | 18522.2 |
379 | 2020-02-25 05:51:25 | lectern | 3 | 134027 | 313 | 12.893 | 10395.3 |
378 | 2020-02-22 15:03:13 | lectern | 1 | 69583 | 2 | 1.250 | 55666.4 |
377 | 2020-02-21 10:00:37 | lectern | 1 | 69583 | 2 | 2.720 | 25582.0 |
376 | 2020-02-17 06:06:03 | lectern | 3 | 134027 | 313 | 13.296 | 10080.2 |
375 | 2020-02-15 12:54:51 | lectern | 1 | 69583 | 2 | 2.703 | 25742.9 |
374 | 2020-02-12 04:27:29 | lectern | 1 | 69583 | 2 | 1.093 | 63662.4 |
373 | 2020-02-10 20:43:52 | lectern | 3 | 134027 | 313 | 7.466 | 17951.6 |