History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offender"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
654 | 2025-05-24 07:32:29 | offender | 3 | 146162 | 73 | 26.863 | 5441.0 |
653 | 2025-05-24 01:03:34 | offender | 2 | 121059 | 13 | 13.956 | 8674.3 |
652 | 2025-05-22 18:29:27 | offender | 1 | 82945 | 3 | 1.470 | 56425.2 |
651 | 2025-05-19 20:39:02 | offender | 1 | 82945 | 3 | 6.750 | 12288.1 |
650 | 2025-05-18 05:29:48 | offender | 1 | 82945 | 3 | 9.736 | 8519.4 |
649 | 2025-05-05 17:43:45 | offender | 1 | 82945 | 3 | 1.283 | 64649.3 |
648 | 2025-04-23 07:02:57 | offender | 1 | 82945 | 3 | 6.093 | 13613.2 |
647 | 2025-04-22 23:56:26 | offender | 2 | 121059 | 13 | 18.936 | 6393.1 |
646 | 2025-04-21 12:27:48 | offender | 2 | 121059 | 13 | 20.563 | 5887.2 |
645 | 2025-04-21 05:44:10 | offender | 3 | 146162 | 73 | 43.880 | 3330.9 |
644 | 2025-04-20 17:52:14 | offender | 1 | 82945 | 3 | 9.750 | 8507.2 |
643 | 2025-04-20 09:23:18 | offender | 1 | 82945 | 3 | 1.453 | 57085.3 |
642 | 2025-04-18 03:31:56 | offender | 1 | 82945 | 3 | 8.440 | 9827.6 |
641 | 2025-04-12 09:01:10 | offender | 3 | 146162 | 73 | 35.190 | 4153.5 |
640 | 2025-04-08 11:41:40 | offender | 1 | 82945 | 3 | 5.110 | 16231.9 |
639 | 2025-04-06 05:28:30 | offender | 1 | 82945 | 3 | 6.233 | 13307.4 |
638 | 2025-03-21 06:13:21 | offender | 3 | 146162 | 73 | 36.860 | 3965.3 |
637 | 2025-03-20 18:40:05 | offender | 1 | 82945 | 3 | 7.140 | 11616.9 |
636 | 2025-03-17 07:38:48 | offender | 3 | 146162 | 73 | 35.656 | 4099.2 |
635 | 2025-03-16 06:13:20 | offender | 3 | 146162 | 73 | 18.686 | 7822.0 |
634 | 2025-03-14 23:53:59 | offender | 3 | 146162 | 73 | 25.580 | 5713.9 |
633 | 2025-03-14 16:38:02 | offender | 3 | 146162 | 73 | 39.003 | 3747.5 |
632 | 2025-03-14 16:37:18 | offender | 1 | 82945 | 3 | 6.906 | 12010.6 |
631 | 2025-03-13 23:52:14 | offender | 3 | 146162 | 73 | 35.673 | 4097.3 |
630 | 2025-03-06 04:00:51 | offender | 1 | 82945 | 3 | 6.126 | 13539.8 |
629 | 2025-03-03 09:04:24 | offender | 1 | 82945 | 3 | 3.173 | 26140.9 |
628 | 2025-02-06 18:51:45 | offender | 1 | 82945 | 3 | 9.483 | 8746.7 |
627 | 2025-02-05 01:21:37 | offender | 3 | 146162 | 73 | 27.736 | 5269.8 |
626 | 2025-02-04 20:28:55 | offender | 3 | 146162 | 73 | 36.173 | 4040.6 |
625 | 2025-02-04 16:43:04 | offender | 3 | 146162 | 73 | 6.203 | 23563.1 |
624 | 2025-01-27 16:11:01 | offender | 1 | 82945 | 3 | 6.216 | 13343.8 |
623 | 2024-12-26 17:17:24 | offender | 3 | 146162 | 73 | 31.473 | 4644.0 |
622 | 2024-12-24 22:34:27 | offender | 3 | 146162 | 73 | 12.983 | 11258.0 |
621 | 2024-12-23 09:15:04 | offender | 1 | 82945 | 3 | 6.343 | 13076.6 |
620 | 2024-12-21 08:49:50 | offender | 3 | 146162 | 73 | 10.173 | 14367.6 |
619 | 2024-12-18 20:11:21 | offender | 3 | 146162 | 73 | 23.750 | 6154.2 |
618 | 2024-12-18 20:10:58 | offender | 3 | 146162 | 73 | 30.316 | 4821.3 |
617 | 2024-12-18 20:10:59 | offender | 2 | 121059 | 13 | 20.406 | 5932.5 |
616 | 2024-12-18 20:10:49 | offender | 1 | 82945 | 3 | 1.500 | 55296.7 |
615 | 2024-12-17 12:25:52 | offender | 1 | 82945 | 3 | 5.466 | 15174.7 |
614 | 2024-12-06 18:57:47 | offender | 1 | 82945 | 3 | 2.983 | 27805.9 |
613 | 2024-11-18 09:20:41 | offender | 1 | 82945 | 3 | 3.826 | 21679.3 |
612 | 2024-11-15 21:27:21 | offender | 1 | 82945 | 3 | 6.813 | 12174.5 |
611 | 2024-11-15 21:26:59 | offender | 2 | 121059 | 13 | 16.876 | 7173.4 |
610 | 2024-11-11 10:48:04 | offender | 3 | 146162 | 73 | 33.813 | 4322.7 |
609 | 2024-11-11 10:48:03 | offender | 2 | 121059 | 13 | 17.440 | 6941.5 |
608 | 2024-11-07 15:53:39 | offender | 3 | 146162 | 73 | 41.566 | 3516.4 |
607 | 2024-11-07 15:53:33 | offender | 3 | 146162 | 73 | 34.686 | 4213.9 |
606 | 2024-11-07 08:44:44 | offender | 2 | 121059 | 13 | 16.376 | 7392.5 |
605 | 2024-11-07 08:43:16 | offender | 1 | 82945 | 3 | 6.483 | 12794.2 |
604 | 2024-11-06 13:50:39 | offender | 3 | 146162 | 73 | 32.160 | 4544.8 |
603 | 2024-11-06 13:42:47 | offender | 3 | 146162 | 73 | 35.676 | 4096.9 |
602 | 2024-11-06 12:32:09 | offender | 4 | 161609 | 566 | 68.130 | 2372.1 |
601 | 2024-11-06 12:32:12 | offender | 3 | 146162 | 73 | 26.986 | 5416.2 |
600 | 2024-11-06 12:32:15 | offender | 2 | 121059 | 13 | 17.736 | 6825.6 |
599 | 2024-11-06 12:32:06 | offender | 1 | 82945 | 3 | 6.313 | 13138.8 |
598 | 2024-10-14 06:45:48 | offender | 2 | 121059 | 13 | 3.513 | 34460.3 |
597 | 2024-10-14 06:45:40 | offender | 1 | 82945 | 3 | 1.530 | 54212.4 |
596 | 2024-10-11 14:43:10 | offender | 3 | 146162 | 73 | 7.360 | 19859.0 |
595 | 2024-10-11 14:43:08 | offender | 3 | 146162 | 73 | 6.983 | 20931.1 |
594 | 2024-10-11 14:43:09 | offender | 2 | 121059 | 13 | 3.563 | 33976.7 |
593 | 2024-10-11 14:43:06 | offender | 1 | 82945 | 3 | 1.296 | 64000.8 |
592 | 2024-10-06 16:54:09 | offender | 1 | 82945 | 3 | 9.046 | 9169.2 |
591 | 2024-10-01 21:57:19 | offender | 1 | 82945 | 3 | 6.720 | 12343.0 |
590 | 2024-09-24 19:40:20 | offender | 3 | 146162 | 73 | 80.113 | 1824.4 |
589 | 2024-09-22 01:27:51 | offender | 3 | 146162 | 73 | 27.643 | 5287.5 |
588 | 2024-09-20 00:24:01 | offender | 3 | 146162 | 73 | 52.250 | 2797.4 |
587 | 2024-09-09 20:32:18 | offender | 3 | 146162 | 73 | 56.143 | 2603.4 |
586 | 2024-09-06 01:28:27 | offender | 3 | 146162 | 73 | 23.613 | 6189.9 |
585 | 2024-08-27 22:20:09 | offender | 2 | 121059 | 13 | 10.250 | 11810.6 |
584 | 2024-08-27 04:12:29 | offender | 2 | 121059 | 13 | 19.500 | 6208.2 |
583 | 2024-08-27 04:12:21 | offender | 1 | 82945 | 3 | 3.580 | 23169.0 |
582 | 2024-08-25 11:22:25 | offender | 3 | 146162 | 73 | 33.686 | 4339.0 |
581 | 2024-08-23 10:41:02 | offender | 1 | 82945 | 3 | 11.783 | 7039.4 |
580 | 2024-08-21 21:31:56 | offender | 3 | 146162 | 73 | 85.206 | 1715.4 |
579 | 2024-08-20 06:50:22 | offender | 3 | 146162 | 73 | 50.436 | 2898.0 |
578 | 2024-08-20 06:50:07 | offender | 3 | 146162 | 73 | 44.186 | 3307.9 |
577 | 2024-08-19 08:41:24 | offender | 3 | 146162 | 73 | 50.503 | 2894.1 |
576 | 2024-08-19 08:23:15 | offender | 4 | 161609 | 566 | 62.400 | 2589.9 |
575 | 2024-08-18 13:55:15 | offender | 4 | 161609 | 566 | 37.546 | 4304.3 |
574 | 2024-08-18 13:55:14 | offender | 3 | 146162 | 73 | 7.890 | 18525.0 |
573 | 2024-08-18 13:55:16 | offender | 2 | 121059 | 13 | 3.750 | 32282.4 |
572 | 2024-08-18 13:55:11 | offender | 1 | 82945 | 3 | 1.420 | 58412.0 |
571 | 2024-08-17 13:01:20 | offender | 1 | 82945 | 3 | 12.563 | 6602.3 |
570 | 2024-08-02 22:17:38 | offender | 1 | 82945 | 3 | 6.796 | 12205.0 |
569 | 2024-07-17 15:46:18 | offender | 2 | 121059 | 13 | 7.780 | 15560.3 |
568 | 2024-07-17 14:12:22 | offender | 1 | 82945 | 3 | 5.343 | 15524.1 |
567 | 2024-07-16 05:54:59 | offender | 4 | 161609 | 566 | 56.000 | 2885.9 |
566 | 2024-07-16 01:26:49 | offender | 4 | 161609 | 566 | 31.276 | 5167.2 |
565 | 2024-07-15 19:33:35 | offender | 4 | 161609 | 566 | 65.863 | 2453.7 |
564 | 2024-07-15 03:14:26 | offender | 4 | 161609 | 566 | 55.393 | 2917.5 |
563 | 2024-07-15 03:12:05 | offender | 3 | 146162 | 73 | 27.376 | 5339.1 |
562 | 2024-07-15 00:52:11 | offender | 4 | 161609 | 566 | 43.753 | 3693.7 |
561 | 2024-07-15 00:52:14 | offender | 2 | 121059 | 13 | 12.876 | 9401.9 |
560 | 2024-07-15 00:52:06 | offender | 3 | 146162 | 73 | 16.156 | 9046.9 |
559 | 2024-07-15 00:51:54 | offender | 1 | 82945 | 3 | 6.313 | 13138.8 |
558 | 2024-07-13 15:01:01 | offender | 1 | 82945 | 3 | 3.110 | 26670.4 |
557 | 2024-07-11 07:39:30 | offender | 1 | 82945 | 3 | 7.720 | 10744.2 |
556 | 2024-07-04 21:12:11 | offender | 1 | 82945 | 3 | 7.736 | 10721.9 |
555 | 2024-07-04 21:09:23 | offender | 1 | 82945 | 3 | 5.233 | 15850.4 |