History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cause"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
650 | 2024-04-27 22:30:16 | cause | 1 | 28756 | 11 | 0.530 | 54256.6 |
649 | 2024-04-27 08:03:44 | cause | 1 | 28756 | 11 | 0.513 | 56054.6 |
648 | 2024-04-23 21:25:28 | cause | 1 | 28756 | 11 | 1.500 | 19170.7 |
647 | 2024-04-20 21:39:08 | cause | 2 | 53800 | 172 | 2.673 | 20127.2 |
646 | 2024-04-20 21:39:01 | cause | 1 | 28756 | 11 | 1.436 | 20025.1 |
645 | 2024-04-20 21:38:50 | cause | 2 | 53800 | 172 | 2.576 | 20885.1 |
644 | 2024-04-03 06:28:36 | cause | 1 | 28756 | 11 | 1.233 | 23322.0 |
643 | 2024-03-30 21:18:17 | cause | 1 | 28756 | 11 | 0.796 | 36125.6 |
642 | 2024-03-28 06:17:22 | cause | 1 | 28756 | 11 | 0.530 | 54256.6 |
641 | 2024-03-27 02:27:40 | cause | 1 | 28756 | 11 | 2.330 | 12341.6 |
640 | 2024-03-22 11:31:59 | cause | 2 | 53800 | 172 | 1.766 | 30464.3 |
639 | 2024-03-20 18:51:19 | cause | 2 | 53800 | 172 | 1.953 | 27547.4 |
638 | 2024-03-20 18:50:57 | cause | 1 | 28756 | 11 | 0.656 | 43835.4 |
637 | 2024-03-20 18:50:25 | cause | 2 | 53800 | 172 | 3.313 | 16239.1 |
636 | 2024-03-01 20:59:45 | cause | 1 | 28756 | 11 | 1.110 | 25906.3 |
635 | 2024-02-19 01:49:03 | cause | 2 | 53800 | 172 | 5.593 | 9619.2 |
634 | 2024-02-18 12:02:34 | cause | 2 | 53800 | 172 | 1.966 | 27365.2 |
633 | 2024-01-26 12:34:32 | cause | 1 | 28756 | 11 | 0.546 | 52666.7 |
632 | 2024-01-23 02:44:11 | cause | 1 | 28756 | 11 | 0.486 | 59168.7 |
631 | 2024-01-12 03:34:50 | cause | 2 | 53800 | 172 | 1.686 | 31909.8 |
630 | 2023-12-25 14:23:36 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
629 | 2023-12-20 21:20:00 | cause | 2 | 53800 | 172 | 1.670 | 32215.6 |
628 | 2023-11-23 06:25:16 | cause | 2 | 53800 | 172 | 1.720 | 31279.1 |
627 | 2023-11-22 17:26:25 | cause | 2 | 53800 | 172 | 3.530 | 15240.8 |
626 | 2023-11-22 06:02:18 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
625 | 2023-11-21 17:13:51 | cause | 1 | 28756 | 11 | 0.466 | 61708.2 |
624 | 2023-11-17 06:16:58 | cause | 2 | 53800 | 172 | 1.690 | 31834.3 |
623 | 2023-11-15 14:56:33 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
622 | 2023-11-15 07:59:43 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
621 | 2023-11-15 07:41:55 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
620 | 2023-11-09 07:52:13 | cause | 1 | 28756 | 11 | 1.030 | 27918.4 |
619 | 2023-11-08 07:59:18 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
618 | 2023-11-01 08:02:00 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
617 | 2023-10-27 06:53:05 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
616 | 2023-10-19 17:33:53 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
615 | 2023-10-19 16:57:21 | cause | 2 | 53800 | 172 | 1.720 | 31279.1 |
614 | 2023-10-19 13:38:10 | cause | 2 | 53800 | 172 | 1.706 | 31535.8 |
613 | 2023-10-16 20:40:21 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
612 | 2023-10-12 02:10:31 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
611 | 2023-10-04 06:21:49 | cause | 1 | 28756 | 11 | 0.466 | 61708.2 |
610 | 2023-09-25 14:19:45 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
609 | 2023-09-23 14:51:56 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
608 | 2023-09-20 15:41:02 | cause | 2 | 53800 | 172 | 1.420 | 37887.3 |
607 | 2023-09-11 22:16:26 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
606 | 2023-09-09 17:54:19 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
605 | 2023-08-01 10:51:06 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
604 | 2023-06-26 18:04:47 | cause | 2 | 53800 | 172 | 1.406 | 38264.6 |
603 | 2023-06-18 19:58:10 | cause | 1 | 28756 | 11 | 0.656 | 43835.4 |
602 | 2023-04-20 08:49:22 | cause | 1 | 28756 | 11 | 0.470 | 61183.0 |
601 | 2023-04-04 23:17:30 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
600 | 2023-03-31 14:12:46 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
599 | 2023-03-23 20:02:19 | cause | 2 | 53800 | 172 | 1.563 | 34421.0 |
598 | 2023-03-19 08:34:45 | cause | 2 | 53800 | 172 | 1.703 | 31591.3 |
597 | 2023-03-03 01:46:49 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
596 | 2023-01-20 08:45:51 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
595 | 2023-01-11 16:21:51 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
594 | 2022-12-20 00:56:03 | cause | 2 | 53800 | 172 | 1.376 | 39098.8 |
593 | 2022-11-18 07:13:16 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
592 | 2022-10-01 09:48:59 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
591 | 2022-09-13 10:03:35 | cause | 2 | 53800 | 172 | 1.546 | 34799.5 |
590 | 2022-08-15 18:23:32 | cause | 2 | 53800 | 172 | 1.436 | 37465.2 |
589 | 2022-07-09 10:09:35 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
588 | 2022-06-14 09:54:25 | cause | 1 | 28756 | 11 | 0.513 | 56054.6 |
587 | 2022-03-18 09:17:08 | cause | 2 | 53800 | 172 | 1.500 | 35866.7 |
586 | 2022-03-09 20:03:43 | cause | 1 | 28756 | 11 | 0.750 | 38341.3 |
585 | 2022-03-02 15:17:48 | cause | 1 | 28756 | 11 | 0.703 | 40904.7 |
584 | 2021-12-22 08:52:15 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
583 | 2021-12-03 08:48:46 | cause | 2 | 53800 | 172 | 1.436 | 37465.2 |
582 | 2021-11-25 18:16:27 | cause | 1 | 28756 | 11 | 0.466 | 61708.2 |
581 | 2021-10-31 10:06:05 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
580 | 2021-10-27 06:55:39 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
579 | 2021-09-19 18:02:13 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
578 | 2021-08-22 21:10:22 | cause | 1 | 28756 | 11 | 0.470 | 61183.0 |
577 | 2021-08-20 03:55:32 | cause | 1 | 28756 | 11 | 0.533 | 53951.2 |
576 | 2021-08-18 00:02:27 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
575 | 2021-05-12 02:20:47 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
574 | 2021-05-02 02:11:19 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
573 | 2021-02-20 03:04:34 | cause | 1 | 28756 | 11 | 0.450 | 63902.2 |
572 | 2021-02-07 17:49:57 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
571 | 2021-02-02 18:40:52 | cause | 1 | 28756 | 11 | 0.450 | 63902.2 |
570 | 2021-01-29 22:15:55 | cause | 2 | 53800 | 172 | 1.423 | 37807.4 |
569 | 2021-01-29 13:35:57 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
568 | 2020-11-18 10:50:54 | cause | 2 | 53800 | 172 | 1.660 | 32409.6 |
567 | 2020-11-05 22:00:06 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |
566 | 2020-10-26 19:08:57 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
565 | 2020-10-19 11:15:40 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
564 | 2020-10-15 04:01:25 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
563 | 2020-10-10 03:13:18 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
562 | 2020-10-06 13:07:49 | cause | 1 | 28756 | 11 | 0.470 | 61183.0 |
561 | 2020-10-03 13:05:47 | cause | 1 | 28756 | 11 | 0.440 | 65354.5 |
560 | 2020-10-02 10:18:48 | cause | 1 | 28756 | 11 | 0.483 | 59536.2 |
559 | 2020-09-21 11:56:45 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
558 | 2020-09-02 19:58:14 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
557 | 2020-08-31 04:01:01 | cause | 1 | 28756 | 11 | 0.450 | 63902.2 |
556 | 2020-08-15 09:28:52 | cause | 1 | 28756 | 11 | 0.530 | 54256.6 |
555 | 2020-07-28 13:32:50 | cause | 1 | 28756 | 11 | 0.516 | 55728.7 |
554 | 2020-07-22 23:50:59 | cause | 1 | 28756 | 11 | 0.470 | 61183.0 |
553 | 2020-06-13 11:55:13 | cause | 1 | 28756 | 11 | 0.470 | 61183.0 |
552 | 2020-06-12 12:53:28 | cause | 1 | 28756 | 11 | 0.453 | 63479.0 |
551 | 2020-05-28 03:15:21 | cause | 1 | 28756 | 11 | 0.500 | 57512.0 |