History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
653 | 2024-04-27 10:02:21 | canal | 1 | 28756 | 7 | 0.546 | 52666.7 |
652 | 2024-04-23 20:46:51 | canal | 1 | 28756 | 7 | 2.093 | 13739.1 |
651 | 2024-04-19 15:14:49 | canal | 2 | 53800 | 130 | 2.390 | 22510.5 |
650 | 2024-04-18 00:02:32 | canal | 1 | 28756 | 7 | 0.546 | 52666.7 |
649 | 2024-04-15 21:42:46 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
648 | 2024-04-11 19:22:05 | canal | 1 | 28756 | 7 | 1.156 | 24875.4 |
647 | 2024-04-11 19:21:05 | canal | 1 | 28756 | 7 | 0.830 | 34645.8 |
646 | 2024-04-09 21:27:04 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
645 | 2024-04-03 06:35:24 | canal | 1 | 28756 | 7 | 1.110 | 25906.3 |
644 | 2024-03-31 12:47:27 | canal | 2 | 53800 | 130 | 2.780 | 19352.5 |
643 | 2024-03-31 12:43:31 | canal | 1 | 28756 | 7 | 1.030 | 27918.4 |
642 | 2024-03-29 15:43:57 | canal | 2 | 53800 | 130 | 3.826 | 14061.7 |
641 | 2024-03-29 09:02:40 | canal | 2 | 53800 | 130 | 2.906 | 18513.4 |
640 | 2024-03-29 08:57:02 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
639 | 2024-03-05 20:54:35 | canal | 1 | 28756 | 7 | 1.203 | 23903.6 |
638 | 2024-03-03 20:49:23 | canal | 1 | 28756 | 7 | 1.093 | 26309.2 |
637 | 2024-03-01 06:00:04 | canal | 1 | 28756 | 7 | 1.110 | 25906.3 |
636 | 2024-02-28 07:25:06 | canal | 1 | 28756 | 7 | 0.546 | 52666.7 |
635 | 2024-02-23 19:20:45 | canal | 2 | 53800 | 130 | 1.436 | 37465.2 |
634 | 2024-02-02 20:05:15 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
633 | 2024-01-29 04:52:53 | canal | 1 | 28756 | 7 | 0.436 | 65954.1 |
632 | 2024-01-28 19:26:55 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
631 | 2024-01-17 23:37:37 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
630 | 2024-01-08 19:51:52 | canal | 2 | 53800 | 130 | 1.626 | 33087.3 |
629 | 2024-01-03 07:16:56 | canal | 2 | 53800 | 130 | 1.623 | 33148.5 |
628 | 2023-12-29 01:37:44 | canal | 1 | 28756 | 7 | 0.546 | 52666.7 |
627 | 2023-12-20 02:44:11 | canal | 2 | 53800 | 130 | 1.390 | 38705.0 |
626 | 2023-12-19 08:50:30 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
625 | 2023-12-02 21:50:21 | canal | 2 | 53800 | 130 | 2.330 | 23090.1 |
624 | 2023-11-27 06:31:44 | canal | 2 | 53800 | 130 | 1.763 | 30516.2 |
623 | 2023-11-25 18:23:35 | canal | 1 | 28756 | 7 | 0.513 | 56054.6 |
622 | 2023-11-25 18:09:41 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
621 | 2023-11-19 00:19:45 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
620 | 2023-11-13 22:56:59 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
619 | 2023-11-13 19:51:38 | canal | 2 | 53800 | 130 | 1.593 | 33772.8 |
618 | 2023-11-11 21:51:13 | canal | 1 | 28756 | 7 | 0.483 | 59536.2 |
617 | 2023-11-10 18:48:55 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
616 | 2023-10-31 04:53:11 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
615 | 2023-10-21 23:24:50 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
614 | 2023-10-18 18:49:25 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
613 | 2023-10-16 17:02:56 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
612 | 2023-10-14 23:19:38 | canal | 1 | 28756 | 7 | 0.440 | 65354.5 |
611 | 2023-10-07 07:19:46 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
610 | 2023-10-05 19:34:16 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
609 | 2023-10-04 00:50:57 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
608 | 2023-09-30 14:15:47 | canal | 2 | 53800 | 130 | 1.610 | 33416.1 |
607 | 2023-09-24 22:10:22 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
606 | 2023-09-14 09:29:07 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
605 | 2023-08-13 00:26:09 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
604 | 2023-08-12 22:24:09 | canal | 2 | 53800 | 130 | 1.500 | 35866.7 |
603 | 2023-06-30 23:09:47 | canal | 1 | 28756 | 7 | 0.533 | 53951.2 |
602 | 2023-05-14 02:23:34 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
601 | 2023-05-10 18:06:42 | canal | 2 | 53800 | 130 | 1.470 | 36598.6 |
600 | 2023-03-28 05:33:34 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
599 | 2023-03-26 23:28:59 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
598 | 2023-02-09 09:28:53 | canal | 2 | 53800 | 130 | 1.530 | 35163.4 |
597 | 2022-12-29 14:46:46 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
596 | 2022-12-23 01:57:38 | canal | 1 | 28756 | 7 | 0.436 | 65954.1 |
595 | 2022-11-06 20:28:33 | canal | 2 | 53800 | 130 | 1.623 | 33148.5 |
594 | 2022-09-19 14:39:31 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
593 | 2022-09-19 13:40:59 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
592 | 2022-09-01 23:14:55 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
591 | 2022-08-15 17:14:20 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
590 | 2022-08-07 14:04:50 | canal | 2 | 53800 | 130 | 1.453 | 37026.8 |
589 | 2022-07-29 00:43:32 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
588 | 2022-07-17 23:51:28 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
587 | 2022-07-13 04:45:26 | canal | 2 | 53800 | 130 | 1.420 | 37887.3 |
586 | 2022-06-09 19:54:29 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
585 | 2022-06-06 05:17:40 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
584 | 2022-05-05 22:13:21 | canal | 2 | 53800 | 130 | 1.623 | 33148.5 |
583 | 2022-05-01 17:45:07 | canal | 1 | 28756 | 7 | 0.436 | 65954.1 |
582 | 2022-04-10 04:14:56 | canal | 2 | 53800 | 130 | 1.593 | 33772.8 |
581 | 2022-03-18 05:31:25 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
580 | 2022-03-15 21:28:19 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
579 | 2022-03-01 17:30:38 | canal | 1 | 28756 | 7 | 0.736 | 39070.7 |
578 | 2022-02-03 12:06:54 | canal | 2 | 53800 | 130 | 1.656 | 32487.9 |
577 | 2022-01-27 05:43:26 | canal | 1 | 28756 | 7 | 0.436 | 65954.1 |
576 | 2021-11-28 21:07:30 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
575 | 2021-11-28 03:17:35 | canal | 1 | 28756 | 7 | 0.546 | 52666.7 |
574 | 2021-11-01 16:49:39 | canal | 2 | 53800 | 130 | 1.673 | 32157.8 |
573 | 2021-10-11 04:08:30 | canal | 2 | 53800 | 130 | 1.593 | 33772.8 |
572 | 2021-10-08 08:28:33 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
571 | 2021-09-06 09:42:52 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
570 | 2021-08-25 07:03:49 | canal | 1 | 28756 | 7 | 0.456 | 63061.4 |
569 | 2021-08-19 16:39:00 | canal | 1 | 28756 | 7 | 0.593 | 48492.4 |
568 | 2021-07-28 18:44:25 | canal | 2 | 53800 | 130 | 1.406 | 38264.6 |
567 | 2021-06-08 04:12:17 | canal | 2 | 53800 | 130 | 1.406 | 38264.6 |
566 | 2021-06-04 23:16:17 | canal | 2 | 53800 | 130 | 1.720 | 31279.1 |
565 | 2021-05-29 16:15:17 | canal | 1 | 28756 | 7 | 1.016 | 28303.1 |
564 | 2021-05-24 10:26:25 | canal | 1 | 28756 | 7 | 0.500 | 57512.0 |
563 | 2021-05-21 23:46:34 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
562 | 2021-05-04 04:39:52 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
561 | 2021-04-20 16:23:29 | canal | 1 | 28756 | 7 | 0.516 | 55728.7 |
560 | 2021-02-18 21:06:19 | canal | 1 | 28756 | 7 | 0.470 | 61183.0 |
559 | 2021-02-11 12:17:47 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
558 | 2021-02-11 11:45:38 | canal | 1 | 28756 | 7 | 0.483 | 59536.2 |
557 | 2021-02-11 11:28:47 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
556 | 2021-02-11 11:09:21 | canal | 1 | 28756 | 7 | 0.530 | 54256.6 |
555 | 2021-02-06 14:57:48 | canal | 1 | 28756 | 7 | 0.453 | 63479.0 |
554 | 2021-01-26 06:33:35 | canal | 1 | 28756 | 7 | 0.486 | 59168.7 |