History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lection"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
633 | 2024-04-10 16:01:54 | lection | 1 | 69583 | 6 | 4.843 | 14367.7 |
632 | 2024-03-24 08:30:47 | lection | 1 | 69583 | 6 | 1.140 | 61037.7 |
631 | 2024-03-21 22:34:40 | lection | 2 | 107671 | 44 | 3.016 | 35699.9 |
630 | 2024-03-21 22:31:50 | lection | 3 | 134027 | 291 | 8.686 | 15430.2 |
629 | 2024-03-16 01:40:53 | lection | 2 | 107671 | 44 | 6.780 | 15880.7 |
628 | 2024-03-16 01:40:22 | lection | 3 | 134027 | 291 | 6.390 | 20974.5 |
627 | 2024-03-15 19:19:40 | lection | 3 | 134027 | 291 | 6.033 | 22215.6 |
626 | 2024-03-15 10:24:45 | lection | 2 | 107671 | 44 | 3.156 | 34116.3 |
625 | 2024-03-15 10:22:48 | lection | 3 | 134027 | 291 | 6.453 | 20769.7 |
624 | 2024-03-14 04:25:39 | lection | 1 | 69583 | 6 | 2.720 | 25582.0 |
623 | 2024-03-14 04:25:38 | lection | 2 | 107671 | 44 | 3.876 | 27778.9 |
622 | 2024-03-14 04:25:18 | lection | 3 | 134027 | 291 | 8.233 | 16279.2 |
621 | 2024-03-13 12:20:30 | lection | 3 | 134027 | 291 | 22.736 | 5894.9 |
620 | 2024-03-13 03:57:59 | lection | 3 | 134027 | 291 | 5.953 | 22514.2 |
619 | 2024-01-08 19:41:57 | lection | 2 | 107671 | 44 | 2.890 | 37256.4 |
618 | 2024-01-03 08:54:35 | lection | 2 | 107671 | 44 | 2.860 | 37647.2 |
617 | 2023-12-19 11:07:06 | lection | 1 | 69583 | 6 | 1.093 | 63662.4 |
616 | 2023-12-07 12:58:14 | lection | 1 | 69583 | 6 | 1.173 | 59320.5 |
615 | 2023-11-27 10:10:23 | lection | 3 | 134027 | 291 | 5.893 | 22743.4 |
614 | 2023-11-20 11:04:29 | lection | 3 | 134027 | 291 | 6.050 | 22153.2 |
613 | 2023-11-20 09:51:04 | lection | 1 | 69583 | 6 | 1.250 | 55666.4 |
612 | 2023-11-14 10:52:32 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
611 | 2023-11-12 19:00:26 | lection | 3 | 134027 | 291 | 7.313 | 18327.2 |
610 | 2023-11-07 09:32:45 | lection | 3 | 134027 | 291 | 17.016 | 7876.5 |
609 | 2023-11-07 09:32:26 | lection | 3 | 134027 | 291 | 14.703 | 9115.6 |
608 | 2023-11-07 09:32:32 | lection | 2 | 107671 | 44 | 3.796 | 28364.3 |
607 | 2023-11-07 09:32:20 | lection | 2 | 107671 | 44 | 7.623 | 14124.5 |
606 | 2023-11-07 09:28:27 | lection | 1 | 69583 | 6 | 1.203 | 57841.2 |
605 | 2023-11-07 01:32:19 | lection | 1 | 69583 | 6 | 1.186 | 58670.3 |
604 | 2023-11-04 13:58:43 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
603 | 2023-10-15 16:20:28 | lection | 2 | 107671 | 44 | 3.360 | 32044.9 |
602 | 2023-10-14 14:38:33 | lection | 1 | 69583 | 6 | 1.156 | 60192.9 |
601 | 2023-10-06 04:54:44 | lection | 1 | 69583 | 6 | 1.143 | 60877.5 |
600 | 2023-09-29 05:53:34 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
599 | 2023-09-27 06:59:12 | lection | 1 | 69583 | 6 | 1.093 | 63662.4 |
598 | 2023-08-26 08:14:50 | lection | 3 | 134027 | 291 | 5.843 | 22938.0 |
597 | 2023-08-02 13:33:38 | lection | 1 | 69583 | 6 | 1.343 | 51811.6 |
596 | 2023-07-27 23:18:39 | lection | 1 | 69583 | 6 | 1.216 | 57222.9 |
595 | 2023-07-26 23:30:07 | lection | 2 | 107671 | 44 | 2.906 | 37051.3 |
594 | 2023-05-17 11:37:16 | lection | 3 | 134027 | 291 | 5.736 | 23365.9 |
593 | 2023-05-11 00:09:38 | lection | 3 | 134027 | 291 | 5.733 | 23378.2 |
592 | 2023-05-01 15:49:49 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
591 | 2023-04-17 01:05:33 | lection | 3 | 134027 | 291 | 6.376 | 21020.5 |
590 | 2023-04-16 01:15:30 | lection | 1 | 69583 | 6 | 1.046 | 66522.9 |
589 | 2023-04-05 05:08:51 | lection | 2 | 107671 | 44 | 3.110 | 34620.9 |
588 | 2023-03-02 22:56:14 | lection | 3 | 134027 | 291 | 5.686 | 23571.4 |
587 | 2023-03-02 22:51:25 | lection | 3 | 134027 | 291 | 6.563 | 20421.6 |
586 | 2023-02-28 06:54:13 | lection | 3 | 134027 | 291 | 12.813 | 10460.2 |
585 | 2023-02-22 10:47:46 | lection | 1 | 69583 | 6 | 1.033 | 67360.1 |
584 | 2023-02-16 06:35:58 | lection | 3 | 134027 | 291 | 6.876 | 19492.0 |
583 | 2023-01-26 11:58:40 | lection | 3 | 134027 | 291 | 6.360 | 21073.4 |
582 | 2023-01-07 07:00:39 | lection | 1 | 69583 | 6 | 1.220 | 57035.2 |
581 | 2023-01-02 16:21:01 | lection | 3 | 134027 | 291 | 6.766 | 19808.9 |
580 | 2023-01-02 04:27:50 | lection | 2 | 107671 | 44 | 3.216 | 33479.8 |
579 | 2022-12-21 14:54:47 | lection | 1 | 69583 | 6 | 1.190 | 58473.1 |
578 | 2022-12-21 10:31:16 | lection | 3 | 134027 | 291 | 5.720 | 23431.3 |
577 | 2022-11-27 05:35:05 | lection | 3 | 134027 | 291 | 6.300 | 21274.1 |
576 | 2022-09-19 22:30:27 | lection | 1 | 69583 | 6 | 1.156 | 60192.9 |
575 | 2022-09-10 15:32:53 | lection | 1 | 69583 | 6 | 1.076 | 64668.2 |
574 | 2022-09-08 00:43:40 | lection | 1 | 69583 | 6 | 1.046 | 66522.9 |
573 | 2022-09-06 23:48:32 | lection | 2 | 107671 | 44 | 2.783 | 38688.8 |
572 | 2022-08-31 03:36:51 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
571 | 2022-08-25 18:56:41 | lection | 3 | 134027 | 291 | 5.826 | 23005.0 |
570 | 2022-07-28 12:04:10 | lection | 3 | 134027 | 291 | 6.640 | 20184.8 |
569 | 2022-07-04 15:52:56 | lection | 3 | 134027 | 291 | 5.783 | 23176.0 |
568 | 2022-07-02 10:02:58 | lection | 3 | 134027 | 291 | 6.186 | 21666.2 |
567 | 2022-05-30 23:35:01 | lection | 1 | 69583 | 6 | 1.216 | 57222.9 |
566 | 2022-04-21 06:34:33 | lection | 1 | 69583 | 6 | 1.173 | 59320.5 |
565 | 2022-03-28 07:24:59 | lection | 2 | 107671 | 44 | 3.050 | 35302.0 |
564 | 2022-02-16 09:31:37 | lection | 1 | 69583 | 6 | 1.080 | 64428.7 |
563 | 2022-02-11 13:07:42 | lection | 3 | 134027 | 291 | 5.766 | 23244.4 |
562 | 2022-01-19 06:04:28 | lection | 1 | 69583 | 6 | 1.203 | 57841.2 |
561 | 2021-12-09 15:00:02 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
560 | 2021-11-20 17:57:07 | lection | 1 | 69583 | 6 | 1.096 | 63488.1 |
559 | 2021-11-20 06:45:19 | lection | 1 | 69583 | 6 | 1.093 | 63662.4 |
558 | 2021-11-17 00:12:23 | lection | 1 | 69583 | 6 | 1.110 | 62687.4 |
557 | 2021-11-08 10:04:53 | lection | 1 | 69583 | 6 | 1.076 | 64668.2 |
556 | 2021-10-22 03:45:14 | lection | 1 | 69583 | 6 | 1.076 | 64668.2 |
555 | 2021-10-04 17:10:24 | lection | 1 | 69583 | 6 | 1.186 | 58670.3 |
554 | 2021-09-25 12:54:49 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
553 | 2021-09-24 22:26:30 | lection | 1 | 69583 | 6 | 1.203 | 57841.2 |
552 | 2021-09-19 07:40:17 | lection | 1 | 69583 | 6 | 1.233 | 56433.9 |
551 | 2021-09-16 19:38:04 | lection | 1 | 69583 | 6 | 1.046 | 66522.9 |
550 | 2021-09-13 09:13:38 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
549 | 2021-08-27 14:05:49 | lection | 1 | 69583 | 6 | 1.060 | 65644.3 |
548 | 2021-08-15 06:37:33 | lection | 1 | 69583 | 6 | 1.266 | 54962.9 |
547 | 2021-08-13 12:33:36 | lection | 1 | 69583 | 6 | 1.046 | 66522.9 |
546 | 2021-08-11 14:08:19 | lection | 1 | 69583 | 6 | 1.186 | 58670.3 |
545 | 2021-08-09 11:31:11 | lection | 1 | 69583 | 6 | 1.076 | 64668.2 |
544 | 2021-08-05 07:45:12 | lection | 1 | 69583 | 6 | 1.063 | 65459.1 |
543 | 2021-05-28 05:46:26 | lection | 1 | 69583 | 6 | 2.423 | 28717.7 |
542 | 2021-05-02 11:02:55 | lection | 1 | 69583 | 6 | 1.110 | 62687.4 |
541 | 2021-05-01 04:59:11 | lection | 1 | 69583 | 6 | 1.233 | 56433.9 |
540 | 2021-03-31 18:11:52 | lection | 1 | 69583 | 6 | 1.236 | 56296.9 |
539 | 2021-02-24 23:41:14 | lection | 1 | 69583 | 6 | 1.250 | 55666.4 |
538 | 2021-02-24 19:37:54 | lection | 1 | 69583 | 6 | 1.156 | 60192.9 |
537 | 2021-01-28 18:10:04 | lection | 1 | 69583 | 6 | 1.076 | 64668.2 |
536 | 2021-01-26 14:02:31 | lection | 1 | 69583 | 6 | 1.203 | 57841.2 |
535 | 2021-01-15 08:59:30 | lection | 1 | 69583 | 6 | 1.266 | 54962.9 |
534 | 2020-11-04 17:10:02 | lection | 1 | 69583 | 6 | 1.203 | 57841.2 |