History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"crime"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
668 | 2024-04-03 04:13:51 | crime | 1 | 28756 | 10 | 1.720 | 16718.6 |
667 | 2024-03-31 08:55:16 | crime | 2 | 53800 | 152 | 1.626 | 33087.3 |
666 | 2024-03-31 08:55:09 | crime | 1 | 28756 | 10 | 0.546 | 52666.7 |
665 | 2024-03-31 08:53:59 | crime | 2 | 53800 | 152 | 1.716 | 31352.0 |
664 | 2024-03-31 08:53:55 | crime | 1 | 28756 | 10 | 0.483 | 59536.2 |
663 | 2024-03-29 21:38:44 | crime | 1 | 28756 | 10 | 1.670 | 17219.2 |
662 | 2024-03-28 03:58:53 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
661 | 2024-03-27 07:33:47 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
660 | 2024-03-04 03:57:47 | crime | 2 | 53800 | 152 | 1.860 | 28924.7 |
659 | 2024-03-04 00:42:01 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
658 | 2024-03-01 04:33:40 | crime | 1 | 28756 | 10 | 0.546 | 52666.7 |
657 | 2024-02-28 10:32:36 | crime | 1 | 28756 | 10 | 2.893 | 9939.9 |
656 | 2024-02-25 17:47:24 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
655 | 2024-02-22 18:54:59 | crime | 2 | 53800 | 152 | 1.766 | 30464.3 |
654 | 2024-02-02 21:03:47 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
653 | 2024-01-28 19:00:03 | crime | 1 | 28756 | 10 | 0.483 | 59536.2 |
652 | 2024-01-26 11:13:17 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
651 | 2023-12-28 21:36:45 | crime | 2 | 53800 | 152 | 1.606 | 33499.4 |
650 | 2023-12-27 18:17:41 | crime | 1 | 28756 | 10 | 0.530 | 54256.6 |
649 | 2023-12-20 19:43:17 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
648 | 2023-12-19 19:22:36 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
647 | 2023-11-25 20:36:21 | crime | 1 | 28756 | 10 | 0.513 | 56054.6 |
646 | 2023-11-18 21:25:11 | crime | 2 | 53800 | 152 | 1.703 | 31591.3 |
645 | 2023-11-14 20:38:35 | crime | 2 | 53800 | 152 | 1.423 | 37807.4 |
644 | 2023-11-13 03:24:49 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
643 | 2023-11-08 15:56:46 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
642 | 2023-11-04 07:45:44 | crime | 2 | 53800 | 152 | 1.376 | 39098.8 |
641 | 2023-10-28 00:05:37 | crime | 1 | 28756 | 10 | 0.530 | 54256.6 |
640 | 2023-10-26 04:29:34 | crime | 2 | 53800 | 152 | 1.406 | 38264.6 |
639 | 2023-10-19 19:24:10 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
638 | 2023-10-18 11:23:31 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
637 | 2023-10-11 14:59:19 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
636 | 2023-10-07 03:01:45 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
635 | 2023-10-05 01:32:47 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
634 | 2023-09-22 23:33:47 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
633 | 2023-09-20 14:38:05 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
632 | 2023-09-06 07:32:05 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
631 | 2023-08-20 19:57:45 | crime | 2 | 53800 | 152 | 1.593 | 33772.8 |
630 | 2023-08-02 14:35:31 | crime | 1 | 28756 | 10 | 0.483 | 59536.2 |
629 | 2023-06-02 15:25:55 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
628 | 2023-05-05 04:15:00 | crime | 2 | 53800 | 152 | 3.063 | 17564.5 |
627 | 2023-04-29 16:13:30 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
626 | 2023-02-27 23:01:56 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
625 | 2023-02-16 21:49:35 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
624 | 2023-02-09 19:52:36 | crime | 2 | 53800 | 152 | 1.546 | 34799.5 |
623 | 2022-12-15 22:08:22 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
622 | 2022-11-21 21:04:03 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
621 | 2022-11-20 22:22:30 | crime | 2 | 53800 | 152 | 1.376 | 39098.8 |
620 | 2022-09-02 01:34:22 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
619 | 2022-08-25 06:21:59 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
618 | 2022-08-21 10:38:03 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
617 | 2022-08-15 18:58:49 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
616 | 2022-07-29 01:29:17 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
615 | 2022-06-25 04:39:48 | crime | 2 | 53800 | 152 | 1.390 | 38705.0 |
614 | 2022-06-11 14:02:59 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
613 | 2022-06-07 07:18:30 | crime | 1 | 28756 | 10 | 0.563 | 51076.4 |
612 | 2022-05-15 19:36:23 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
611 | 2022-04-02 07:23:30 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
610 | 2022-02-11 01:43:44 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
609 | 2022-02-06 13:34:46 | crime | 2 | 53800 | 152 | 1.716 | 31352.0 |
608 | 2022-01-03 22:18:20 | crime | 1 | 28756 | 10 | 0.546 | 52666.7 |
607 | 2022-01-01 18:57:48 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
606 | 2021-11-10 02:22:58 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
605 | 2021-11-09 17:06:15 | crime | 2 | 53800 | 152 | 1.653 | 32546.9 |
604 | 2021-11-02 05:24:03 | crime | 1 | 28756 | 10 | 0.513 | 56054.6 |
603 | 2021-09-23 20:10:48 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
602 | 2021-08-19 23:58:03 | crime | 1 | 28756 | 10 | 0.516 | 55728.7 |
601 | 2021-08-17 19:39:33 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
600 | 2021-08-07 02:48:28 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
599 | 2021-08-05 00:53:07 | crime | 1 | 28756 | 10 | 0.440 | 65354.5 |
598 | 2021-07-28 00:50:22 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
597 | 2021-07-20 01:02:02 | crime | 1 | 28756 | 10 | 0.530 | 54256.6 |
596 | 2021-07-12 00:57:25 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
595 | 2021-06-04 11:39:55 | crime | 1 | 28756 | 10 | 0.516 | 55728.7 |
594 | 2021-05-06 06:51:33 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
593 | 2021-05-02 14:05:25 | crime | 1 | 28756 | 10 | 1.013 | 28387.0 |
592 | 2021-04-08 20:47:56 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
591 | 2021-02-16 11:37:52 | crime | 1 | 28756 | 10 | 0.486 | 59168.7 |
590 | 2021-01-30 22:04:03 | crime | 1 | 28756 | 10 | 0.483 | 59536.2 |
589 | 2021-01-26 19:15:41 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
588 | 2020-12-25 03:39:41 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
587 | 2020-10-28 12:11:41 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
586 | 2020-10-24 10:20:52 | crime | 1 | 28756 | 10 | 0.483 | 59536.2 |
585 | 2020-10-09 23:57:12 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
584 | 2020-10-07 21:00:56 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
583 | 2020-09-30 15:48:57 | crime | 1 | 28756 | 10 | 0.486 | 59168.7 |
582 | 2020-09-30 00:09:07 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
581 | 2020-09-28 00:10:18 | crime | 1 | 28756 | 10 | 0.436 | 65954.1 |
580 | 2020-09-21 20:51:54 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
579 | 2020-09-17 21:03:26 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
578 | 2020-08-23 08:30:00 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
577 | 2020-08-19 07:18:44 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
576 | 2020-08-02 20:51:45 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |
575 | 2020-07-30 15:36:04 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
574 | 2020-07-17 21:44:10 | crime | 1 | 28756 | 10 | 0.470 | 61183.0 |
573 | 2020-05-20 18:06:03 | crime | 1 | 28756 | 10 | 0.546 | 52666.7 |
572 | 2020-05-01 11:07:37 | crime | 1 | 28756 | 10 | 0.453 | 63479.0 |
571 | 2020-03-25 06:16:00 | crime | 1 | 28756 | 10 | 0.483 | 59536.2 |
570 | 2020-03-23 22:01:39 | crime | 1 | 28756 | 10 | 0.533 | 53951.2 |
569 | 2020-03-22 09:41:29 | crime | 1 | 28756 | 10 | 0.500 | 57512.0 |