History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guided"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
641 | 2024-04-30 15:16:37 | guided | 1 | 48755 | 8 | 0.813 | 59969.2 |
640 | 2024-04-01 02:32:10 | guided | 3 | 112716 | 985 | 21.330 | 5284.4 |
639 | 2024-03-31 18:04:04 | guided | 3 | 112716 | 985 | 41.566 | 2711.7 |
638 | 2024-03-31 18:01:16 | guided | 3 | 112716 | 985 | 56.253 | 2003.7 |
637 | 2024-03-31 16:05:28 | guided | 3 | 112716 | 985 | 8.580 | 13137.1 |
636 | 2024-03-29 05:48:33 | guided | 1 | 48755 | 8 | 2.813 | 17332.0 |
635 | 2024-03-10 15:49:40 | guided | 3 | 112716 | 985 | 9.310 | 12107.0 |
634 | 2024-03-10 08:49:15 | guided | 3 | 112716 | 985 | 13.690 | 8233.5 |
633 | 2024-03-09 13:07:56 | guided | 3 | 112716 | 985 | 5.843 | 19290.8 |
632 | 2024-03-07 06:28:08 | guided | 3 | 112716 | 985 | 13.220 | 8526.2 |
631 | 2024-03-07 06:28:08 | guided | 2 | 82551 | 79 | 7.813 | 10565.9 |
630 | 2024-03-07 02:24:29 | guided | 1 | 48755 | 8 | 0.783 | 62266.9 |
629 | 2024-02-29 15:35:46 | guided | 2 | 82551 | 79 | 2.513 | 32849.6 |
628 | 2024-02-29 15:33:33 | guided | 3 | 112716 | 985 | 5.733 | 19660.9 |
627 | 2024-02-28 05:09:27 | guided | 3 | 112716 | 985 | 26.066 | 4324.3 |
626 | 2024-02-28 05:09:29 | guided | 2 | 82551 | 79 | 13.873 | 5950.5 |
625 | 2024-02-28 05:09:06 | guided | 1 | 48755 | 8 | 1.750 | 27860.0 |
624 | 2024-02-25 22:25:05 | guided | 1 | 48755 | 8 | 2.453 | 19875.7 |
623 | 2024-02-24 15:09:59 | guided | 1 | 48755 | 8 | 0.736 | 66243.2 |
622 | 2024-02-01 02:27:24 | guided | 2 | 82551 | 79 | 2.466 | 33475.7 |
621 | 2024-02-01 02:26:52 | guided | 3 | 112716 | 985 | 5.580 | 20200.0 |
620 | 2024-01-30 14:46:28 | guided | 2 | 82551 | 79 | 2.296 | 35954.3 |
619 | 2024-01-30 14:42:44 | guided | 3 | 112716 | 985 | 5.656 | 19928.6 |
618 | 2024-01-29 20:54:22 | guided | 3 | 112716 | 985 | 5.703 | 19764.3 |
617 | 2024-01-17 04:51:15 | guided | 1 | 48755 | 8 | 0.766 | 63648.8 |
616 | 2024-01-10 07:29:51 | guided | 3 | 112716 | 985 | 4.906 | 22975.1 |
615 | 2024-01-10 07:29:52 | guided | 2 | 82551 | 79 | 2.313 | 35690.0 |
614 | 2024-01-07 17:27:55 | guided | 3 | 112716 | 985 | 5.126 | 21989.1 |
613 | 2024-01-07 17:27:51 | guided | 2 | 82551 | 79 | 2.406 | 34310.5 |
612 | 2023-12-08 03:48:01 | guided | 3 | 112716 | 985 | 4.940 | 22817.0 |
611 | 2023-12-07 22:19:29 | guided | 1 | 48755 | 8 | 1.780 | 27390.4 |
610 | 2023-12-07 22:19:28 | guided | 1 | 48755 | 8 | 0.860 | 56691.9 |
609 | 2023-12-07 12:34:24 | guided | 1 | 48755 | 8 | 0.796 | 61250.0 |
608 | 2023-12-04 14:57:01 | guided | 3 | 112716 | 985 | 5.110 | 22057.9 |
607 | 2023-11-15 10:56:10 | guided | 1 | 48755 | 8 | 0.780 | 62506.4 |
606 | 2023-11-15 09:09:11 | guided | 1 | 48755 | 8 | 0.736 | 66243.2 |
605 | 2023-10-22 19:47:49 | guided | 1 | 48755 | 8 | 0.810 | 60191.4 |
604 | 2023-10-19 11:26:57 | guided | 1 | 48755 | 8 | 0.830 | 58741.0 |
603 | 2023-10-11 08:11:46 | guided | 3 | 112716 | 985 | 5.393 | 20900.4 |
602 | 2023-10-11 08:11:49 | guided | 2 | 82551 | 79 | 2.533 | 32590.2 |
601 | 2023-10-09 22:56:12 | guided | 1 | 48755 | 8 | 0.750 | 65006.7 |
600 | 2023-10-09 20:39:58 | guided | 1 | 48755 | 8 | 0.720 | 67715.3 |
599 | 2023-09-26 05:46:27 | guided | 1 | 48755 | 8 | 0.826 | 59025.4 |
598 | 2023-09-23 15:55:39 | guided | 1 | 48755 | 8 | 0.766 | 63648.8 |
597 | 2023-09-22 10:17:51 | guided | 1 | 48755 | 8 | 0.733 | 66514.3 |
596 | 2023-09-20 21:43:12 | guided | 1 | 48755 | 8 | 0.766 | 63648.8 |
595 | 2023-09-11 17:33:18 | guided | 3 | 112716 | 985 | 6.126 | 18399.6 |
594 | 2023-09-02 11:16:58 | guided | 3 | 112716 | 985 | 5.406 | 20850.2 |
593 | 2023-07-16 15:11:13 | guided | 1 | 48755 | 8 | 0.736 | 66243.2 |
592 | 2023-06-06 12:57:17 | guided | 1 | 48755 | 8 | 0.796 | 61250.0 |
591 | 2023-06-03 06:21:57 | guided | 1 | 48755 | 8 | 0.716 | 68093.6 |
590 | 2023-05-18 13:49:21 | guided | 3 | 112716 | 985 | 4.580 | 24610.5 |
589 | 2023-04-19 02:58:09 | guided | 1 | 48755 | 8 | 0.750 | 65006.7 |
588 | 2023-04-12 18:50:17 | guided | 3 | 112716 | 985 | 4.483 | 25143.0 |
587 | 2023-03-19 00:34:19 | guided | 3 | 112716 | 985 | 5.046 | 22337.7 |
586 | 2023-02-24 02:07:19 | guided | 3 | 112716 | 985 | 4.516 | 24959.3 |
585 | 2023-02-11 12:27:03 | guided | 1 | 48755 | 8 | 0.733 | 66514.3 |
584 | 2023-02-06 09:53:12 | guided | 1 | 48755 | 8 | 0.716 | 68093.6 |
583 | 2023-01-14 02:15:02 | guided | 3 | 112716 | 985 | 4.466 | 25238.7 |
582 | 2022-12-05 06:46:38 | guided | 3 | 112716 | 985 | 9.470 | 11902.4 |
581 | 2022-12-04 20:40:04 | guided | 1 | 48755 | 8 | 0.733 | 66514.3 |
580 | 2022-11-13 18:59:58 | guided | 3 | 112716 | 985 | 5.140 | 21929.2 |
579 | 2022-11-05 04:05:25 | guided | 3 | 112716 | 985 | 5.203 | 21663.7 |
578 | 2022-11-05 03:05:19 | guided | 3 | 112716 | 985 | 4.483 | 25143.0 |
577 | 2022-10-28 10:06:29 | guided | 3 | 112716 | 985 | 5.186 | 21734.7 |
576 | 2022-10-25 00:36:55 | guided | 1 | 48755 | 8 | 0.720 | 67715.3 |
575 | 2022-10-22 23:48:05 | guided | 3 | 112716 | 985 | 5.233 | 21539.5 |
574 | 2022-09-27 17:53:55 | guided | 3 | 112716 | 985 | 4.516 | 24959.3 |
573 | 2022-09-11 19:24:56 | guided | 1 | 48755 | 8 | 0.716 | 68093.6 |
572 | 2022-08-31 19:30:54 | guided | 3 | 112716 | 985 | 4.563 | 24702.2 |
571 | 2022-08-16 02:35:44 | guided | 1 | 48755 | 8 | 0.736 | 66243.2 |
570 | 2022-08-01 21:46:48 | guided | 1 | 48755 | 8 | 0.843 | 57835.1 |
569 | 2022-07-30 09:20:34 | guided | 1 | 48755 | 8 | 0.716 | 68093.6 |
568 | 2022-07-18 15:49:29 | guided | 1 | 48755 | 8 | 0.703 | 69352.8 |
567 | 2022-07-11 02:31:28 | guided | 3 | 112716 | 985 | 4.563 | 24702.2 |
566 | 2022-07-10 23:05:03 | guided | 3 | 112716 | 985 | 5.203 | 21663.7 |
565 | 2022-07-05 07:58:10 | guided | 1 | 48755 | 8 | 0.750 | 65006.7 |
564 | 2022-06-25 09:13:57 | guided | 1 | 48755 | 8 | 0.813 | 59969.2 |
563 | 2022-06-24 22:57:45 | guided | 1 | 48755 | 8 | 0.736 | 66243.2 |
562 | 2022-06-23 03:10:31 | guided | 3 | 112716 | 985 | 4.623 | 24381.6 |
561 | 2022-05-14 11:19:57 | guided | 3 | 112716 | 985 | 4.893 | 23036.2 |
560 | 2022-05-09 16:34:00 | guided | 3 | 112716 | 985 | 4.843 | 23274.0 |
559 | 2022-05-06 15:46:01 | guided | 3 | 112716 | 985 | 5.436 | 20735.1 |
558 | 2022-04-08 18:27:01 | guided | 3 | 112716 | 985 | 4.640 | 24292.2 |
557 | 2022-03-25 01:41:31 | guided | 1 | 48755 | 8 | 1.000 | 48755.0 |
556 | 2022-03-21 10:33:27 | guided | 1 | 48755 | 8 | 0.920 | 52994.6 |
555 | 2022-03-18 00:07:48 | guided | 1 | 48755 | 8 | 0.843 | 57835.1 |
554 | 2021-12-31 00:18:27 | guided | 1 | 48755 | 8 | 1.033 | 47197.5 |
553 | 2021-12-16 19:34:24 | guided | 1 | 48755 | 8 | 0.810 | 60191.4 |
552 | 2021-12-04 06:01:00 | guided | 1 | 48755 | 8 | 0.876 | 55656.4 |
551 | 2021-11-30 19:55:54 | guided | 1 | 48755 | 8 | 0.826 | 59025.4 |
550 | 2021-11-06 16:34:45 | guided | 1 | 48755 | 8 | 0.906 | 53813.5 |
549 | 2021-09-26 08:08:11 | guided | 1 | 48755 | 8 | 0.720 | 67715.3 |
548 | 2021-09-11 08:36:37 | guided | 3 | 112716 | 985 | 4.513 | 24975.8 |
547 | 2021-09-09 04:30:10 | guided | 1 | 48755 | 8 | 0.716 | 68093.6 |
546 | 2021-08-24 13:20:39 | guided | 1 | 48755 | 8 | 0.873 | 55847.7 |
545 | 2021-08-09 03:35:18 | guided | 3 | 112716 | 985 | 4.686 | 24053.8 |
544 | 2021-06-24 11:02:16 | guided | 3 | 112716 | 985 | 5.546 | 20323.8 |
543 | 2021-06-13 13:50:59 | guided | 1 | 48755 | 8 | 0.750 | 65006.7 |
542 | 2021-06-09 12:11:51 | guided | 3 | 112716 | 985 | 4.516 | 24959.3 |