History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sectary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
681 | 2024-05-04 02:38:30 | sectary | 1 | 69583 | 2 | 1.266 | 54962.9 |
680 | 2024-04-28 09:23:40 | sectary | 1 | 69583 | 2 | 1.483 | 46920.4 |
679 | 2024-04-26 09:21:52 | sectary | 2 | 107671 | 17 | 3.686 | 29210.8 |
678 | 2024-04-26 09:21:40 | sectary | 3 | 134027 | 209 | 6.733 | 19906.0 |
677 | 2024-04-25 18:34:10 | sectary | 3 | 134027 | 209 | 15.766 | 8501.0 |
676 | 2024-04-25 17:24:49 | sectary | 2 | 107671 | 17 | 9.750 | 11043.2 |
675 | 2024-04-25 17:13:32 | sectary | 3 | 134027 | 209 | 8.080 | 16587.5 |
674 | 2024-04-24 18:19:44 | sectary | 2 | 107671 | 17 | 6.126 | 17576.1 |
673 | 2024-04-24 18:11:35 | sectary | 3 | 134027 | 209 | 7.986 | 16782.7 |
672 | 2024-04-23 03:47:59 | sectary | 3 | 134027 | 209 | 25.410 | 5274.6 |
671 | 2024-04-23 03:47:55 | sectary | 2 | 107671 | 17 | 9.216 | 11683.1 |
670 | 2024-04-23 02:15:26 | sectary | 1 | 69583 | 2 | 1.330 | 52318.0 |
669 | 2024-04-11 09:05:39 | sectary | 1 | 69583 | 2 | 1.300 | 53525.4 |
668 | 2024-03-15 22:34:22 | sectary | 1 | 69583 | 2 | 1.406 | 49490.0 |
667 | 2024-02-18 06:58:52 | sectary | 1 | 69583 | 2 | 3.860 | 18026.7 |
666 | 2024-02-18 05:07:03 | sectary | 2 | 107671 | 17 | 3.500 | 30763.1 |
665 | 2024-02-13 16:09:01 | sectary | 2 | 107671 | 17 | 9.093 | 11841.1 |
664 | 2024-02-13 13:01:22 | sectary | 1 | 69583 | 2 | 1.110 | 62687.4 |
663 | 2024-02-04 17:15:18 | sectary | 3 | 134027 | 209 | 7.690 | 17428.7 |
662 | 2024-02-04 12:25:27 | sectary | 3 | 134027 | 209 | 21.690 | 6179.2 |
661 | 2024-01-30 22:43:39 | sectary | 3 | 134027 | 209 | 13.986 | 9582.9 |
660 | 2024-01-26 07:13:27 | sectary | 3 | 134027 | 209 | 9.610 | 13946.6 |
659 | 2024-01-26 02:16:02 | sectary | 3 | 134027 | 209 | 8.953 | 14970.1 |
658 | 2024-01-09 15:28:05 | sectary | 1 | 69583 | 2 | 1.140 | 61037.7 |
657 | 2023-12-28 08:15:28 | sectary | 1 | 69583 | 2 | 1.236 | 56296.9 |
656 | 2023-12-23 23:06:54 | sectary | 1 | 69583 | 2 | 1.173 | 59320.5 |
655 | 2023-12-12 00:16:05 | sectary | 2 | 107671 | 17 | 6.626 | 16249.8 |
654 | 2023-12-11 02:43:51 | sectary | 3 | 134027 | 209 | 8.686 | 15430.2 |
653 | 2023-11-25 02:20:35 | sectary | 1 | 69583 | 2 | 1.173 | 59320.5 |
652 | 2023-11-21 22:29:41 | sectary | 3 | 134027 | 209 | 7.376 | 18170.7 |
651 | 2023-11-11 09:43:02 | sectary | 1 | 69583 | 2 | 1.093 | 63662.4 |
650 | 2023-11-07 09:30:48 | sectary | 1 | 69583 | 2 | 1.263 | 55093.4 |
649 | 2023-11-05 02:43:07 | sectary | 3 | 134027 | 209 | 6.296 | 21287.6 |
648 | 2023-10-18 13:06:07 | sectary | 1 | 69583 | 2 | 1.153 | 60349.5 |
647 | 2023-10-17 13:05:51 | sectary | 1 | 69583 | 2 | 1.343 | 51811.6 |
646 | 2023-10-16 14:19:41 | sectary | 1 | 69583 | 2 | 1.110 | 62687.4 |
645 | 2023-10-15 01:49:26 | sectary | 1 | 69583 | 2 | 1.266 | 54962.9 |
644 | 2023-09-26 07:20:11 | sectary | 1 | 69583 | 2 | 1.156 | 60192.9 |
643 | 2023-09-25 02:10:25 | sectary | 1 | 69583 | 2 | 1.343 | 51811.6 |
642 | 2023-08-14 11:31:30 | sectary | 1 | 69583 | 2 | 1.123 | 61961.7 |
641 | 2023-08-10 16:12:12 | sectary | 3 | 134027 | 209 | 6.343 | 21129.9 |
640 | 2023-06-08 01:12:32 | sectary | 1 | 69583 | 2 | 1.096 | 63488.1 |
639 | 2023-05-12 17:51:56 | sectary | 1 | 69583 | 2 | 1.093 | 63662.4 |
638 | 2023-04-22 03:07:32 | sectary | 3 | 134027 | 209 | 6.110 | 21935.7 |
637 | 2023-03-08 23:19:36 | sectary | 1 | 69583 | 2 | 1.233 | 56433.9 |
636 | 2023-02-05 22:19:51 | sectary | 1 | 69583 | 2 | 1.263 | 55093.4 |
635 | 2023-01-25 19:04:26 | sectary | 3 | 134027 | 209 | 5.843 | 22938.0 |
634 | 2022-12-29 01:42:16 | sectary | 1 | 69583 | 2 | 1.250 | 55666.4 |
633 | 2022-11-07 05:36:36 | sectary | 3 | 134027 | 209 | 5.860 | 22871.5 |
632 | 2022-09-17 04:57:26 | sectary | 1 | 69583 | 2 | 1.093 | 63662.4 |
631 | 2022-07-19 09:03:57 | sectary | 1 | 69583 | 2 | 1.093 | 63662.4 |
630 | 2022-07-17 01:30:50 | sectary | 1 | 69583 | 2 | 1.093 | 63662.4 |
629 | 2022-06-25 13:30:07 | sectary | 1 | 69583 | 2 | 1.186 | 58670.3 |
628 | 2022-06-08 00:02:55 | sectary | 3 | 134027 | 209 | 5.890 | 22755.0 |
627 | 2022-03-12 10:59:14 | sectary | 1 | 69583 | 2 | 1.126 | 61796.6 |
626 | 2022-02-09 19:39:27 | sectary | 1 | 69583 | 2 | 1.373 | 50679.5 |
625 | 2022-01-27 02:59:16 | sectary | 3 | 134027 | 209 | 7.203 | 18607.1 |
624 | 2021-12-20 15:55:03 | sectary | 1 | 69583 | 2 | 1.280 | 54361.7 |
623 | 2021-12-04 00:47:43 | sectary | 1 | 69583 | 2 | 1.143 | 60877.5 |
622 | 2021-11-15 05:35:11 | sectary | 1 | 69583 | 2 | 1.266 | 54962.9 |
621 | 2021-11-13 04:28:12 | sectary | 1 | 69583 | 2 | 1.250 | 55666.4 |
620 | 2021-10-27 17:29:45 | sectary | 1 | 69583 | 2 | 1.250 | 55666.4 |
619 | 2021-10-07 02:14:16 | sectary | 1 | 69583 | 2 | 1.216 | 57222.9 |
618 | 2021-07-26 02:43:09 | sectary | 2 | 107671 | 17 | 2.860 | 37647.2 |
617 | 2021-06-28 22:16:51 | sectary | 1 | 69583 | 2 | 1.250 | 55666.4 |
616 | 2021-06-01 18:46:25 | sectary | 1 | 69583 | 2 | 1.263 | 55093.4 |
615 | 2021-05-31 04:20:47 | sectary | 1 | 69583 | 2 | 1.250 | 55666.4 |
614 | 2021-05-16 19:13:21 | sectary | 2 | 107671 | 17 | 3.406 | 31612.2 |
613 | 2021-05-05 09:55:35 | sectary | 1 | 69583 | 2 | 1.280 | 54361.7 |
612 | 2021-04-10 19:44:33 | sectary | 1 | 69583 | 2 | 1.233 | 56433.9 |
611 | 2021-04-04 03:02:42 | sectary | 1 | 69583 | 2 | 1.216 | 57222.9 |
610 | 2021-02-23 00:24:55 | sectary | 3 | 134027 | 209 | 6.190 | 21652.2 |
609 | 2021-02-21 08:02:44 | sectary | 3 | 134027 | 209 | 6.750 | 19855.9 |
608 | 2021-02-18 15:23:12 | sectary | 1 | 69583 | 2 | 1.143 | 60877.5 |
607 | 2021-02-17 23:39:55 | sectary | 1 | 69583 | 2 | 1.390 | 50059.7 |
606 | 2021-02-16 14:12:26 | sectary | 1 | 69583 | 2 | 1.266 | 54962.9 |
605 | 2021-02-15 14:50:35 | sectary | 1 | 69583 | 2 | 1.250 | 55666.4 |
604 | 2021-02-14 15:26:56 | sectary | 1 | 69583 | 2 | 1.233 | 56433.9 |
603 | 2021-02-13 22:09:05 | sectary | 1 | 69583 | 2 | 1.220 | 57035.2 |
602 | 2021-02-12 10:41:14 | sectary | 1 | 69583 | 2 | 1.266 | 54962.9 |
601 | 2021-01-29 08:50:13 | sectary | 2 | 107671 | 17 | 2.983 | 36094.9 |
600 | 2021-01-28 08:29:17 | sectary | 3 | 134027 | 209 | 6.203 | 21606.8 |
599 | 2021-01-27 02:19:26 | sectary | 3 | 134027 | 209 | 6.936 | 19323.4 |
598 | 2021-01-26 10:08:45 | sectary | 3 | 134027 | 209 | 6.673 | 20085.0 |
597 | 2021-01-01 07:41:58 | sectary | 1 | 69583 | 2 | 1.233 | 56433.9 |
596 | 2020-12-30 14:56:36 | sectary | 3 | 134027 | 209 | 7.686 | 17437.8 |
595 | 2020-12-26 05:23:20 | sectary | 1 | 69583 | 2 | 1.110 | 62687.4 |
594 | 2020-12-22 01:44:34 | sectary | 1 | 69583 | 2 | 1.160 | 59985.3 |
593 | 2020-12-18 11:40:59 | sectary | 1 | 69583 | 2 | 1.236 | 56296.9 |
592 | 2020-12-16 16:05:58 | sectary | 1 | 69583 | 2 | 1.096 | 63488.1 |
591 | 2020-12-11 18:20:38 | sectary | 1 | 69583 | 2 | 1.140 | 61037.7 |
590 | 2020-12-09 23:26:16 | sectary | 1 | 69583 | 2 | 1.203 | 57841.2 |
589 | 2020-11-09 21:12:43 | sectary | 2 | 107671 | 17 | 3.283 | 32796.5 |
588 | 2020-11-08 18:39:05 | sectary | 3 | 134027 | 209 | 6.486 | 20664.0 |
587 | 2020-10-30 00:17:49 | sectary | 1 | 69583 | 2 | 1.436 | 48456.1 |
586 | 2020-10-15 06:57:14 | sectary | 1 | 69583 | 2 | 1.126 | 61796.6 |
585 | 2020-10-04 19:44:57 | sectary | 1 | 69583 | 2 | 2.186 | 31831.2 |
584 | 2020-08-29 08:50:54 | sectary | 1 | 69583 | 2 | 1.106 | 62914.1 |
583 | 2020-08-23 16:22:36 | sectary | 1 | 69583 | 2 | 1.233 | 56433.9 |
582 | 2020-08-22 23:48:26 | sectary | 1 | 69583 | 2 | 1.110 | 62687.4 |