History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"motion"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
657 | 2024-04-27 18:40:14 | motion | 1 | 48755 | 8 | 0.893 | 54596.9 |
656 | 2024-04-27 02:23:22 | motion | 2 | 82551 | 53 | 4.956 | 16656.8 |
655 | 2024-04-26 23:05:33 | motion | 3 | 112716 | 523 | 19.580 | 5756.7 |
654 | 2024-04-02 22:48:21 | motion | 2 | 82551 | 53 | 7.580 | 10890.6 |
653 | 2024-04-01 09:34:03 | motion | 2 | 82551 | 53 | 8.063 | 10238.2 |
652 | 2024-04-01 02:51:42 | motion | 2 | 82551 | 53 | 5.966 | 13836.9 |
651 | 2024-04-01 02:51:38 | motion | 1 | 48755 | 8 | 1.970 | 24748.7 |
650 | 2024-04-01 02:51:14 | motion | 3 | 112716 | 523 | 6.593 | 17096.3 |
649 | 2024-03-31 18:01:29 | motion | 3 | 112716 | 523 | 60.566 | 1861.0 |
648 | 2024-03-31 16:18:22 | motion | 3 | 112716 | 523 | 6.860 | 16430.9 |
647 | 2024-03-31 16:18:10 | motion | 1 | 48755 | 8 | 2.903 | 16794.7 |
646 | 2024-03-28 05:21:17 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
645 | 2024-03-19 19:09:20 | motion | 1 | 48755 | 8 | 0.906 | 53813.5 |
644 | 2024-03-01 19:17:05 | motion | 2 | 82551 | 53 | 6.030 | 13690.0 |
643 | 2024-02-29 04:08:44 | motion | 2 | 82551 | 53 | 2.640 | 31269.3 |
642 | 2024-02-29 04:08:24 | motion | 3 | 112716 | 523 | 5.516 | 20434.4 |
641 | 2024-02-28 13:53:52 | motion | 2 | 82551 | 53 | 3.343 | 24693.7 |
640 | 2024-02-28 05:10:05 | motion | 3 | 112716 | 523 | 20.550 | 5485.0 |
639 | 2024-02-27 09:12:42 | motion | 2 | 82551 | 53 | 2.780 | 29694.6 |
638 | 2024-02-27 09:04:58 | motion | 3 | 112716 | 523 | 12.300 | 9163.9 |
637 | 2024-02-26 12:43:04 | motion | 3 | 112716 | 523 | 6.203 | 18171.2 |
636 | 2024-02-26 12:43:06 | motion | 2 | 82551 | 53 | 2.843 | 29036.6 |
635 | 2024-02-26 12:42:59 | motion | 1 | 48755 | 8 | 1.813 | 26891.9 |
634 | 2024-01-27 04:15:33 | motion | 1 | 48755 | 8 | 0.876 | 55656.4 |
633 | 2024-01-03 18:50:19 | motion | 3 | 112716 | 523 | 4.796 | 23502.1 |
632 | 2024-01-02 17:33:47 | motion | 3 | 112716 | 523 | 4.826 | 23356.0 |
631 | 2024-01-02 17:33:44 | motion | 2 | 82551 | 53 | 2.203 | 37472.1 |
630 | 2023-12-22 00:11:28 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
629 | 2023-12-19 03:50:57 | motion | 1 | 48755 | 8 | 0.906 | 53813.5 |
628 | 2023-12-16 22:58:22 | motion | 1 | 48755 | 8 | 0.843 | 57835.1 |
627 | 2023-12-14 04:55:57 | motion | 1 | 48755 | 8 | 0.953 | 51159.5 |
626 | 2023-12-14 04:02:17 | motion | 3 | 112716 | 523 | 5.390 | 20912.1 |
625 | 2023-12-14 04:02:19 | motion | 2 | 82551 | 53 | 2.453 | 33653.1 |
624 | 2023-12-11 13:29:12 | motion | 1 | 48755 | 8 | 0.843 | 57835.1 |
623 | 2023-12-11 08:25:44 | motion | 2 | 82551 | 53 | 2.406 | 34310.5 |
622 | 2023-12-11 08:25:36 | motion | 3 | 112716 | 523 | 5.483 | 20557.4 |
621 | 2023-11-15 06:32:16 | motion | 1 | 48755 | 8 | 0.813 | 59969.2 |
620 | 2023-11-13 22:55:46 | motion | 1 | 48755 | 8 | 1.796 | 27146.4 |
619 | 2023-11-11 21:19:16 | motion | 1 | 48755 | 8 | 0.766 | 63648.8 |
618 | 2023-10-30 11:25:27 | motion | 3 | 112716 | 523 | 4.860 | 23192.6 |
617 | 2023-10-28 13:25:30 | motion | 1 | 48755 | 8 | 0.860 | 56691.9 |
616 | 2023-10-23 14:47:44 | motion | 3 | 112716 | 523 | 6.093 | 18499.3 |
615 | 2023-10-23 00:47:15 | motion | 1 | 48755 | 8 | 0.766 | 63648.8 |
614 | 2023-10-20 02:22:02 | motion | 3 | 112716 | 523 | 6.873 | 16399.8 |
613 | 2023-10-19 00:10:10 | motion | 1 | 48755 | 8 | 0.953 | 51159.5 |
612 | 2023-10-11 19:46:06 | motion | 3 | 112716 | 523 | 4.860 | 23192.6 |
611 | 2023-10-11 14:27:22 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
610 | 2023-10-04 00:35:38 | motion | 3 | 112716 | 523 | 6.186 | 18221.1 |
609 | 2023-10-02 12:37:00 | motion | 1 | 48755 | 8 | 0.830 | 58741.0 |
608 | 2023-10-01 10:37:04 | motion | 3 | 112716 | 523 | 6.266 | 17988.5 |
607 | 2023-09-26 21:43:02 | motion | 3 | 112716 | 523 | 8.656 | 13021.7 |
606 | 2023-09-25 01:51:15 | motion | 1 | 48755 | 8 | 0.923 | 52822.3 |
605 | 2023-09-13 14:55:56 | motion | 1 | 48755 | 8 | 0.830 | 58741.0 |
604 | 2023-09-11 15:03:53 | motion | 3 | 112716 | 523 | 5.156 | 21861.1 |
603 | 2023-08-22 02:34:33 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
602 | 2023-07-30 12:13:33 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
601 | 2023-07-22 22:06:20 | motion | 3 | 112716 | 523 | 6.250 | 18034.6 |
600 | 2023-05-08 09:39:17 | motion | 1 | 48755 | 8 | 0.736 | 66243.2 |
599 | 2023-04-29 04:52:02 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
598 | 2023-04-25 21:08:45 | motion | 1 | 48755 | 8 | 0.766 | 63648.8 |
597 | 2023-04-08 13:53:37 | motion | 1 | 48755 | 8 | 0.716 | 68093.6 |
596 | 2023-04-03 20:37:56 | motion | 3 | 112716 | 523 | 4.716 | 23900.8 |
595 | 2023-03-21 15:54:27 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
594 | 2023-02-15 17:41:11 | motion | 1 | 48755 | 8 | 0.796 | 61250.0 |
593 | 2023-01-29 15:54:29 | motion | 1 | 48755 | 8 | 0.796 | 61250.0 |
592 | 2023-01-27 10:11:03 | motion | 3 | 112716 | 523 | 4.610 | 24450.3 |
591 | 2023-01-02 13:37:26 | motion | 3 | 112716 | 523 | 4.966 | 22697.5 |
590 | 2022-12-25 10:55:21 | motion | 3 | 112716 | 523 | 5.030 | 22408.7 |
589 | 2022-12-22 22:21:59 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
588 | 2022-12-13 13:23:35 | motion | 1 | 48755 | 8 | 0.830 | 58741.0 |
587 | 2022-12-12 20:59:13 | motion | 3 | 112716 | 523 | 4.673 | 24120.7 |
586 | 2022-11-27 22:20:06 | motion | 1 | 48755 | 8 | 0.826 | 59025.4 |
585 | 2022-11-22 21:16:59 | motion | 3 | 112716 | 523 | 5.436 | 20735.1 |
584 | 2022-11-10 10:53:02 | motion | 3 | 112716 | 523 | 5.190 | 21717.9 |
583 | 2022-11-09 22:57:14 | motion | 3 | 112716 | 523 | 5.546 | 20323.8 |
582 | 2022-11-09 01:01:20 | motion | 3 | 112716 | 523 | 11.483 | 9815.9 |
581 | 2022-11-08 18:12:12 | motion | 3 | 112716 | 523 | 5.906 | 19085.0 |
580 | 2022-10-27 00:37:03 | motion | 3 | 112716 | 523 | 4.610 | 24450.3 |
579 | 2022-10-26 10:27:30 | motion | 3 | 112716 | 523 | 5.423 | 20784.8 |
578 | 2022-10-23 06:28:59 | motion | 3 | 112716 | 523 | 5.923 | 19030.2 |
577 | 2022-10-15 10:57:55 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
576 | 2022-09-24 19:51:38 | motion | 3 | 112716 | 523 | 4.640 | 24292.2 |
575 | 2022-09-18 13:04:35 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
574 | 2022-09-06 13:26:30 | motion | 3 | 112716 | 523 | 4.690 | 24033.3 |
573 | 2022-08-22 23:37:58 | motion | 1 | 48755 | 8 | 0.766 | 63648.8 |
572 | 2022-08-17 16:46:19 | motion | 1 | 48755 | 8 | 0.766 | 63648.8 |
571 | 2022-08-15 07:07:14 | motion | 1 | 48755 | 8 | 0.780 | 62506.4 |
570 | 2022-08-06 19:42:23 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
569 | 2022-07-30 00:41:48 | motion | 1 | 48755 | 8 | 0.750 | 65006.7 |
568 | 2022-07-10 04:04:50 | motion | 1 | 48755 | 8 | 0.766 | 63648.8 |
567 | 2022-07-03 07:19:15 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
566 | 2022-07-02 15:47:59 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
565 | 2022-06-28 22:44:03 | motion | 1 | 48755 | 8 | 0.843 | 57835.1 |
564 | 2022-06-25 14:23:41 | motion | 3 | 112716 | 523 | 4.796 | 23502.1 |
563 | 2022-06-16 07:20:49 | motion | 1 | 48755 | 8 | 0.733 | 66514.3 |
562 | 2022-06-15 16:20:04 | motion | 1 | 48755 | 8 | 0.826 | 59025.4 |
561 | 2022-05-04 13:21:24 | motion | 3 | 112716 | 523 | 10.050 | 11215.5 |
560 | 2022-05-02 07:50:10 | motion | 3 | 112716 | 523 | 4.640 | 24292.2 |
559 | 2022-04-15 19:50:24 | motion | 3 | 112716 | 523 | 4.720 | 23880.5 |
558 | 2022-04-14 18:44:01 | motion | 3 | 112716 | 523 | 5.876 | 19182.4 |