History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lesson"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
529 | 2024-04-27 22:38:12 | lesson | 1 | 48755 | 5 | 1.156 | 42175.6 |
528 | 2024-04-03 11:15:25 | lesson | 1 | 48755 | 5 | 0.966 | 50471.0 |
527 | 2024-03-29 21:34:52 | lesson | 1 | 48755 | 5 | 1.983 | 24586.5 |
526 | 2024-03-29 08:30:18 | lesson | 1 | 48755 | 5 | 2.783 | 17518.9 |
525 | 2024-03-06 03:02:00 | lesson | 2 | 82551 | 38 | 5.266 | 15676.2 |
524 | 2024-03-05 03:38:19 | lesson | 3 | 112716 | 353 | 18.766 | 6006.4 |
523 | 2024-03-05 00:03:17 | lesson | 2 | 82551 | 38 | 2.343 | 35233.0 |
522 | 2024-03-05 00:03:09 | lesson | 1 | 48755 | 5 | 0.846 | 57630.0 |
521 | 2024-03-05 00:02:56 | lesson | 3 | 112716 | 353 | 5.093 | 22131.6 |
520 | 2024-03-04 02:36:16 | lesson | 1 | 48755 | 5 | 0.873 | 55847.7 |
519 | 2024-03-02 21:10:32 | lesson | 2 | 82551 | 38 | 2.716 | 30394.3 |
518 | 2024-03-02 21:07:54 | lesson | 3 | 112716 | 353 | 6.626 | 17011.2 |
517 | 2024-03-02 18:04:58 | lesson | 2 | 82551 | 38 | 7.860 | 10502.7 |
516 | 2024-03-02 07:13:45 | lesson | 3 | 112716 | 353 | 6.096 | 18490.2 |
515 | 2024-03-02 07:13:37 | lesson | 2 | 82551 | 38 | 2.936 | 28116.8 |
514 | 2024-03-02 01:06:20 | lesson | 2 | 82551 | 38 | 2.483 | 33246.5 |
513 | 2024-02-28 04:50:02 | lesson | 1 | 48755 | 5 | 2.296 | 21234.8 |
512 | 2024-02-25 15:51:59 | lesson | 1 | 48755 | 5 | 0.876 | 55656.4 |
511 | 2023-12-14 20:23:09 | lesson | 3 | 112716 | 353 | 5.423 | 20784.8 |
510 | 2023-12-14 20:23:11 | lesson | 2 | 82551 | 38 | 2.546 | 32423.8 |
509 | 2023-12-05 03:48:57 | lesson | 1 | 48755 | 5 | 0.876 | 55656.4 |
508 | 2023-11-29 08:09:19 | lesson | 3 | 112716 | 353 | 5.800 | 19433.8 |
507 | 2023-11-25 02:30:09 | lesson | 1 | 48755 | 5 | 1.906 | 25579.7 |
506 | 2023-11-22 10:17:14 | lesson | 2 | 82551 | 38 | 2.250 | 36689.3 |
505 | 2023-11-11 21:12:04 | lesson | 1 | 48755 | 5 | 0.903 | 53992.2 |
504 | 2023-11-10 20:40:32 | lesson | 1 | 48755 | 5 | 0.843 | 57835.1 |
503 | 2023-11-07 01:25:01 | lesson | 1 | 48755 | 5 | 0.733 | 66514.3 |
502 | 2023-11-03 15:41:04 | lesson | 1 | 48755 | 5 | 0.890 | 54780.9 |
501 | 2023-10-27 10:27:35 | lesson | 3 | 112716 | 353 | 10.610 | 10623.6 |
500 | 2023-10-19 17:25:24 | lesson | 1 | 48755 | 5 | 0.826 | 59025.4 |
499 | 2023-10-17 06:53:03 | lesson | 3 | 112716 | 353 | 5.673 | 19868.9 |
498 | 2023-10-16 01:47:01 | lesson | 3 | 112716 | 353 | 5.233 | 21539.5 |
497 | 2023-10-14 14:35:39 | lesson | 2 | 82551 | 38 | 2.343 | 35233.0 |
496 | 2023-10-10 19:54:55 | lesson | 1 | 48755 | 5 | 0.873 | 55847.7 |
495 | 2023-09-25 00:27:37 | lesson | 1 | 48755 | 5 | 0.813 | 59969.2 |
494 | 2023-09-18 19:11:01 | lesson | 1 | 48755 | 5 | 0.843 | 57835.1 |
493 | 2023-09-14 19:43:44 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
492 | 2023-08-23 15:52:58 | lesson | 2 | 82551 | 38 | 2.140 | 38575.2 |
491 | 2023-07-20 19:46:58 | lesson | 1 | 48755 | 5 | 0.813 | 59969.2 |
490 | 2023-07-16 03:12:35 | lesson | 1 | 48755 | 5 | 0.890 | 54780.9 |
489 | 2023-07-10 11:20:59 | lesson | 1 | 48755 | 5 | 0.813 | 59969.2 |
488 | 2023-05-05 11:06:03 | lesson | 2 | 82551 | 38 | 2.300 | 35891.7 |
487 | 2023-04-13 16:35:09 | lesson | 1 | 48755 | 5 | 1.610 | 30282.6 |
486 | 2023-03-28 06:17:14 | lesson | 1 | 48755 | 5 | 1.106 | 44082.3 |
485 | 2023-02-12 04:25:21 | lesson | 2 | 82551 | 38 | 2.373 | 34787.6 |
484 | 2023-02-02 23:40:33 | lesson | 1 | 48755 | 5 | 0.716 | 68093.6 |
483 | 2022-12-09 19:01:14 | lesson | 1 | 48755 | 5 | 0.736 | 66243.2 |
482 | 2022-12-01 04:00:23 | lesson | 1 | 48755 | 5 | 0.813 | 59969.2 |
481 | 2022-11-25 23:33:09 | lesson | 1 | 48755 | 5 | 0.906 | 53813.5 |
480 | 2022-11-23 00:24:56 | lesson | 2 | 82551 | 38 | 2.140 | 38575.2 |
479 | 2022-09-19 10:48:58 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
478 | 2022-08-23 06:37:38 | lesson | 1 | 48755 | 5 | 0.720 | 67715.3 |
477 | 2022-08-14 15:03:35 | lesson | 1 | 48755 | 5 | 0.923 | 52822.3 |
476 | 2022-08-09 13:33:51 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
475 | 2022-08-06 19:32:07 | lesson | 1 | 48755 | 5 | 0.780 | 62506.4 |
474 | 2022-07-30 00:31:58 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
473 | 2022-07-28 23:16:14 | lesson | 1 | 48755 | 5 | 1.486 | 32809.6 |
472 | 2022-07-25 01:50:03 | lesson | 1 | 48755 | 5 | 0.780 | 62506.4 |
471 | 2022-07-22 17:42:54 | lesson | 1 | 48755 | 5 | 0.856 | 56956.8 |
470 | 2022-07-10 15:05:15 | lesson | 1 | 48755 | 5 | 0.843 | 57835.1 |
469 | 2022-06-25 18:25:32 | lesson | 1 | 48755 | 5 | 0.813 | 59969.2 |
468 | 2022-05-04 10:23:56 | lesson | 2 | 82551 | 38 | 2.596 | 31799.3 |
467 | 2022-04-08 09:50:32 | lesson | 1 | 48755 | 5 | 0.860 | 56691.9 |
466 | 2022-04-04 23:20:44 | lesson | 1 | 48755 | 5 | 0.936 | 52088.7 |
465 | 2022-03-19 22:17:45 | lesson | 1 | 48755 | 5 | 0.796 | 61250.0 |
464 | 2022-01-16 23:25:25 | lesson | 2 | 82551 | 38 | 2.203 | 37472.1 |
463 | 2021-12-30 03:42:26 | lesson | 1 | 48755 | 5 | 0.890 | 54780.9 |
462 | 2021-12-17 22:32:05 | lesson | 1 | 48755 | 5 | 0.890 | 54780.9 |
461 | 2021-11-07 22:47:15 | lesson | 1 | 48755 | 5 | 0.733 | 66514.3 |
460 | 2021-11-05 21:36:03 | lesson | 1 | 48755 | 5 | 1.343 | 36303.1 |
459 | 2021-09-21 05:30:00 | lesson | 1 | 48755 | 5 | 0.843 | 57835.1 |
458 | 2021-09-19 01:53:51 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
457 | 2021-09-07 11:12:34 | lesson | 1 | 48755 | 5 | 0.800 | 60943.8 |
456 | 2021-08-28 04:20:11 | lesson | 1 | 48755 | 5 | 0.733 | 66514.3 |
455 | 2021-06-14 04:24:21 | lesson | 3 | 112716 | 353 | 5.343 | 21096.0 |
454 | 2021-06-06 13:19:20 | lesson | 1 | 48755 | 5 | 0.936 | 52088.7 |
453 | 2021-06-03 08:47:48 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
452 | 2021-05-21 13:32:45 | lesson | 1 | 48755 | 5 | 0.843 | 57835.1 |
451 | 2021-04-22 04:12:39 | lesson | 1 | 48755 | 5 | 0.826 | 59025.4 |
450 | 2021-03-24 13:03:55 | lesson | 1 | 48755 | 5 | 0.860 | 56691.9 |
449 | 2021-03-24 08:39:34 | lesson | 3 | 112716 | 353 | 4.923 | 22895.8 |
448 | 2021-02-28 22:33:47 | lesson | 1 | 48755 | 5 | 0.843 | 57835.1 |
447 | 2021-02-02 22:03:03 | lesson | 1 | 48755 | 5 | 0.810 | 60191.4 |
446 | 2021-02-02 18:03:12 | lesson | 3 | 112716 | 353 | 4.750 | 23729.7 |
445 | 2021-02-02 09:16:22 | lesson | 1 | 48755 | 5 | 0.746 | 65355.2 |
444 | 2021-01-07 05:43:45 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
443 | 2020-12-29 02:32:27 | lesson | 2 | 82551 | 38 | 2.140 | 38575.2 |
442 | 2020-11-29 04:04:03 | lesson | 1 | 48755 | 5 | 0.766 | 63648.8 |
441 | 2020-11-12 06:19:04 | lesson | 3 | 112716 | 353 | 4.750 | 23729.7 |
440 | 2020-11-11 02:33:17 | lesson | 3 | 112716 | 353 | 4.750 | 23729.7 |
439 | 2020-11-05 10:47:02 | lesson | 2 | 82551 | 38 | 2.296 | 35954.3 |
438 | 2020-11-01 08:19:41 | lesson | 3 | 112716 | 353 | 4.936 | 22835.5 |
437 | 2020-10-29 16:05:36 | lesson | 3 | 112716 | 353 | 5.970 | 18880.4 |
436 | 2020-10-29 15:05:54 | lesson | 1 | 48755 | 5 | 0.813 | 59969.2 |
435 | 2020-10-24 14:09:25 | lesson | 3 | 112716 | 353 | 5.310 | 21227.1 |
434 | 2020-10-20 13:25:48 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |
433 | 2020-10-05 07:35:03 | lesson | 2 | 82551 | 38 | 2.233 | 36968.7 |
432 | 2020-09-26 14:15:50 | lesson | 3 | 112716 | 353 | 4.753 | 23714.7 |
431 | 2020-09-02 04:18:36 | lesson | 1 | 48755 | 5 | 0.826 | 59025.4 |
430 | 2020-08-29 00:34:50 | lesson | 1 | 48755 | 5 | 0.750 | 65006.7 |