History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"duty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
638 | 2024-04-04 23:18:07 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
637 | 2024-04-03 01:20:57 | duty | 1 | 13983 | 4 | 0.690 | 20265.2 |
636 | 2024-03-31 02:24:40 | duty | 1 | 13983 | 4 | 0.500 | 27966.0 |
635 | 2024-03-28 05:34:23 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
634 | 2024-03-27 22:13:30 | duty | 1 | 13983 | 4 | 0.263 | 53167.3 |
633 | 2024-03-27 22:13:22 | duty | 2 | 29872 | 194 | 0.843 | 35435.3 |
632 | 2024-03-26 22:38:44 | duty | 2 | 29872 | 194 | 1.043 | 28640.5 |
631 | 2024-03-26 21:20:23 | duty | 1 | 13983 | 4 | 0.513 | 27257.3 |
630 | 2024-03-05 21:06:48 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
629 | 2024-03-03 19:56:48 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
628 | 2024-02-29 20:20:01 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
627 | 2024-02-25 16:15:41 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
626 | 2024-02-03 00:02:25 | duty | 1 | 13983 | 4 | 0.466 | 30006.4 |
625 | 2024-02-02 17:05:43 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
624 | 2024-01-31 01:53:38 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
623 | 2024-01-31 00:54:40 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
622 | 2024-01-28 16:18:43 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
621 | 2024-01-26 02:21:37 | duty | 1 | 13983 | 4 | 0.500 | 27966.0 |
620 | 2023-12-12 05:46:49 | duty | 2 | 29872 | 194 | 0.733 | 40753.1 |
619 | 2023-11-24 06:22:57 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
618 | 2023-11-20 23:24:25 | duty | 2 | 29872 | 194 | 0.750 | 39829.3 |
617 | 2023-11-16 20:32:44 | duty | 2 | 29872 | 194 | 1.466 | 20376.5 |
616 | 2023-11-10 21:49:14 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
615 | 2023-11-08 23:36:55 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
614 | 2023-10-27 03:48:06 | duty | 1 | 13983 | 4 | 0.470 | 29751.1 |
613 | 2023-10-23 14:31:22 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
612 | 2023-10-20 00:00:47 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
611 | 2023-10-17 13:53:01 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
610 | 2023-10-15 23:38:29 | duty | 1 | 13983 | 4 | 0.530 | 26383.0 |
609 | 2023-10-11 02:38:23 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
608 | 2023-10-05 07:23:48 | duty | 2 | 29872 | 194 | 0.826 | 36164.6 |
607 | 2023-10-03 09:40:05 | duty | 1 | 13983 | 4 | 0.280 | 49939.3 |
606 | 2023-09-28 18:24:23 | duty | 2 | 29872 | 194 | 0.796 | 37527.6 |
605 | 2023-09-22 02:22:16 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
604 | 2023-09-19 21:18:52 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
603 | 2023-09-09 15:39:06 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
602 | 2023-07-10 07:40:36 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
601 | 2023-06-14 09:32:21 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
600 | 2023-04-02 19:00:18 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
599 | 2023-03-31 10:52:41 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
598 | 2023-01-13 16:01:00 | duty | 1 | 13983 | 4 | 0.423 | 33056.7 |
597 | 2022-12-28 14:15:12 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
596 | 2022-10-26 08:49:33 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
595 | 2022-09-19 10:55:47 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
594 | 2022-09-14 04:30:33 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
593 | 2022-09-09 13:01:38 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
592 | 2022-08-06 19:20:54 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
591 | 2022-07-30 00:20:36 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
590 | 2022-07-03 07:06:13 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
589 | 2022-06-25 18:14:32 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
588 | 2022-06-16 15:43:21 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
587 | 2022-06-16 07:08:12 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
586 | 2022-06-08 22:13:55 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
585 | 2022-06-08 18:24:40 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
584 | 2022-06-01 20:36:42 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
583 | 2022-05-29 01:03:13 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
582 | 2022-02-24 04:08:23 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
581 | 2022-02-17 18:38:39 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
580 | 2021-12-15 07:03:23 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
579 | 2021-11-13 01:56:45 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
578 | 2021-11-09 17:37:55 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
577 | 2021-10-20 11:16:40 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
576 | 2021-09-20 02:10:55 | duty | 2 | 29872 | 194 | 0.766 | 38997.4 |
575 | 2021-09-12 12:58:34 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
574 | 2021-08-23 18:56:15 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
573 | 2021-08-06 17:42:20 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
572 | 2021-06-13 06:48:51 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
571 | 2021-03-23 06:17:55 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
570 | 2021-02-21 07:07:27 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
569 | 2021-01-15 20:56:36 | duty | 1 | 13983 | 4 | 0.266 | 52567.7 |
568 | 2021-01-09 05:47:03 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
567 | 2021-01-05 05:03:30 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
566 | 2020-10-31 20:36:35 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
565 | 2020-10-21 08:57:45 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
564 | 2020-09-25 00:18:36 | duty | 1 | 13983 | 4 | 0.203 | 68881.8 |
563 | 2020-08-25 02:14:06 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
562 | 2020-08-24 06:55:00 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
561 | 2020-08-24 06:12:40 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
560 | 2020-08-21 09:52:53 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
559 | 2020-08-15 03:30:48 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
558 | 2020-05-26 05:10:41 | duty | 1 | 13983 | 4 | 0.220 | 63559.1 |
557 | 2020-03-30 22:43:39 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
556 | 2020-03-30 09:21:23 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
555 | 2020-03-30 06:28:40 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
554 | 2020-03-28 07:48:49 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
553 | 2020-03-25 11:36:09 | duty | 1 | 13983 | 4 | 0.266 | 52567.7 |
552 | 2020-03-24 13:52:57 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
551 | 2020-03-23 07:41:06 | duty | 1 | 13983 | 4 | 0.500 | 27966.0 |
550 | 2020-03-21 16:46:32 | duty | 1 | 13983 | 4 | 0.360 | 38841.7 |
549 | 2020-03-20 14:14:55 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
548 | 2020-03-19 20:14:33 | duty | 1 | 13983 | 4 | 0.216 | 64736.1 |
547 | 2020-03-18 20:51:14 | duty | 1 | 13983 | 4 | 0.263 | 53167.3 |
546 | 2020-03-17 19:04:05 | duty | 1 | 13983 | 4 | 0.263 | 53167.3 |
545 | 2020-03-02 01:52:36 | duty | 1 | 13983 | 4 | 0.233 | 60012.9 |
544 | 2020-02-23 23:14:26 | duty | 1 | 13983 | 4 | 0.250 | 55932.0 |
543 | 2020-02-22 20:10:14 | duty | 1 | 13983 | 4 | 0.236 | 59250.0 |
542 | 2020-02-22 09:18:18 | duty | 1 | 13983 | 4 | 0.546 | 25609.9 |
541 | 2020-02-14 16:16:19 | duty | 1 | 13983 | 4 | 0.516 | 27098.8 |
540 | 2020-02-10 14:49:51 | duty | 1 | 13983 | 4 | 0.266 | 52567.7 |
539 | 2020-02-07 21:33:09 | duty | 1 | 13983 | 4 | 0.533 | 26234.5 |