History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"facts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
651 | 2025-04-15 05:32:54 | facts | 1 | 28756 | 10 | 2.033 | 14144.6 |
650 | 2025-04-11 08:27:38 | facts | 2 | 53800 | 200 | 7.156 | 7518.2 |
649 | 2025-04-09 10:10:02 | facts | 2 | 53800 | 200 | 8.656 | 6215.3 |
648 | 2025-04-08 02:30:22 | facts | 1 | 28756 | 10 | 3.233 | 8894.5 |
647 | 2025-04-03 12:26:40 | facts | 1 | 28756 | 10 | 1.016 | 28303.1 |
646 | 2025-04-02 09:00:31 | facts | 1 | 28756 | 10 | 4.030 | 7135.5 |
645 | 2025-03-27 02:44:35 | facts | 1 | 28756 | 10 | 2.546 | 11294.6 |
644 | 2025-03-21 02:47:25 | facts | 2 | 53800 | 200 | 6.563 | 8197.5 |
643 | 2025-03-19 11:27:14 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
642 | 2025-03-15 23:11:08 | facts | 1 | 28756 | 10 | 2.173 | 13233.3 |
641 | 2025-03-07 15:34:19 | facts | 1 | 28756 | 10 | 1.250 | 23004.8 |
640 | 2025-02-27 17:03:57 | facts | 2 | 53800 | 200 | 3.906 | 13773.7 |
639 | 2025-02-27 14:09:59 | facts | 1 | 28756 | 10 | 1.486 | 19351.3 |
638 | 2025-02-27 07:32:35 | facts | 2 | 53800 | 200 | 7.986 | 6736.8 |
637 | 2025-02-27 07:22:42 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
636 | 2025-02-26 14:40:47 | facts | 1 | 28756 | 10 | 1.436 | 20025.1 |
635 | 2025-02-23 18:41:56 | facts | 1 | 28756 | 10 | 2.250 | 12780.4 |
634 | 2025-02-05 10:53:00 | facts | 1 | 28756 | 10 | 1.343 | 21411.8 |
633 | 2025-01-30 10:56:22 | facts | 1 | 28756 | 10 | 2.203 | 13053.1 |
632 | 2025-01-28 09:47:26 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
631 | 2025-01-27 09:38:01 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
630 | 2025-01-06 04:22:26 | facts | 1 | 28756 | 10 | 2.623 | 10963.0 |
629 | 2024-12-30 10:22:46 | facts | 2 | 53800 | 200 | 7.796 | 6901.0 |
628 | 2024-12-29 07:28:21 | facts | 2 | 53800 | 200 | 7.756 | 6936.6 |
627 | 2024-12-29 04:27:29 | facts | 2 | 53800 | 200 | 7.733 | 6957.2 |
626 | 2024-12-29 04:16:35 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
625 | 2024-12-28 08:20:01 | facts | 1 | 28756 | 10 | 0.530 | 54256.6 |
624 | 2024-12-27 14:40:03 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
623 | 2024-12-25 15:44:59 | facts | 1 | 28756 | 10 | 2.360 | 12184.7 |
622 | 2024-12-07 01:04:56 | facts | 1 | 28756 | 10 | 1.220 | 23570.5 |
621 | 2024-11-30 06:20:26 | facts | 2 | 53800 | 200 | 7.610 | 7069.6 |
620 | 2024-11-29 06:30:45 | facts | 2 | 53800 | 200 | 3.953 | 13609.9 |
619 | 2024-11-29 03:54:05 | facts | 2 | 53800 | 200 | 3.923 | 13714.0 |
618 | 2024-11-29 03:50:17 | facts | 1 | 28756 | 10 | 2.703 | 10638.5 |
617 | 2024-11-25 15:03:03 | facts | 1 | 28756 | 10 | 2.373 | 12118.0 |
616 | 2024-11-06 21:01:38 | facts | 1 | 28756 | 10 | 2.530 | 11366.0 |
615 | 2024-10-29 22:10:05 | facts | 2 | 53800 | 200 | 6.640 | 8102.4 |
614 | 2024-10-29 13:26:33 | facts | 2 | 53800 | 200 | 10.753 | 5003.3 |
613 | 2024-10-29 13:26:23 | facts | 1 | 28756 | 10 | 1.343 | 21411.8 |
612 | 2024-10-29 05:19:51 | facts | 2 | 53800 | 200 | 12.016 | 4477.4 |
611 | 2024-10-29 05:10:10 | facts | 1 | 28756 | 10 | 0.936 | 30722.2 |
610 | 2024-10-26 11:25:27 | facts | 1 | 28756 | 10 | 1.516 | 18968.3 |
609 | 2024-10-23 08:28:42 | facts | 1 | 28756 | 10 | 1.186 | 24246.2 |
608 | 2024-09-29 08:37:58 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
607 | 2024-09-29 03:29:54 | facts | 2 | 53800 | 200 | 12.453 | 4320.2 |
606 | 2024-09-29 02:21:10 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
605 | 2024-09-25 17:51:04 | facts | 1 | 28756 | 10 | 3.576 | 8041.4 |
604 | 2024-09-07 10:02:07 | facts | 1 | 28756 | 10 | 3.110 | 9246.3 |
603 | 2024-08-29 21:30:14 | facts | 1 | 28756 | 10 | 2.423 | 11867.9 |
602 | 2024-08-29 19:11:13 | facts | 1 | 28756 | 10 | 2.830 | 10161.1 |
601 | 2024-08-29 18:19:50 | facts | 2 | 53800 | 200 | 15.983 | 3366.1 |
600 | 2024-08-29 15:15:32 | facts | 2 | 53800 | 200 | 6.330 | 8499.2 |
599 | 2024-08-29 11:36:34 | facts | 2 | 53800 | 200 | 6.313 | 8522.1 |
598 | 2024-08-29 11:28:21 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
597 | 2024-08-26 15:17:15 | facts | 1 | 28756 | 10 | 3.576 | 8041.4 |
596 | 2024-08-20 15:30:33 | facts | 2 | 53800 | 200 | 13.046 | 4123.9 |
595 | 2024-08-09 16:06:18 | facts | 2 | 53800 | 200 | 6.500 | 8276.9 |
594 | 2024-08-09 15:51:00 | facts | 1 | 28756 | 10 | 0.983 | 29253.3 |
593 | 2024-08-08 01:29:02 | facts | 1 | 28756 | 10 | 2.140 | 13437.4 |
592 | 2024-07-30 09:52:15 | facts | 1 | 28756 | 10 | 0.486 | 59168.7 |
591 | 2024-07-30 09:01:37 | facts | 2 | 53800 | 200 | 8.516 | 6317.5 |
590 | 2024-07-30 07:52:19 | facts | 1 | 28756 | 10 | 0.466 | 61708.2 |
589 | 2024-07-28 17:44:31 | facts | 1 | 28756 | 10 | 1.343 | 21411.8 |
588 | 2024-07-28 12:57:34 | facts | 1 | 28756 | 10 | 1.156 | 24875.4 |
587 | 2024-07-27 06:15:45 | facts | 1 | 28756 | 10 | 1.406 | 20452.3 |
586 | 2024-07-24 07:56:18 | facts | 1 | 28756 | 10 | 1.970 | 14597.0 |
585 | 2024-07-10 07:42:50 | facts | 1 | 28756 | 10 | 1.860 | 15460.2 |
584 | 2024-07-07 17:11:28 | facts | 1 | 28756 | 10 | 1.936 | 14853.3 |
583 | 2024-07-07 17:08:40 | facts | 1 | 28756 | 10 | 0.610 | 47141.0 |
582 | 2024-07-02 01:39:38 | facts | 1 | 28756 | 10 | 2.326 | 12362.9 |
581 | 2024-07-02 00:20:36 | facts | 2 | 53800 | 200 | 5.610 | 9590.0 |
580 | 2024-07-02 00:20:24 | facts | 2 | 53800 | 200 | 5.686 | 9461.8 |
579 | 2024-06-30 08:13:47 | facts | 2 | 53800 | 200 | 2.453 | 21932.3 |
578 | 2024-06-30 04:24:09 | facts | 1 | 28756 | 10 | 0.860 | 33437.2 |
577 | 2024-06-30 02:58:02 | facts | 2 | 53800 | 200 | 8.686 | 6193.9 |
576 | 2024-06-29 22:33:50 | facts | 2 | 53800 | 200 | 8.140 | 6609.3 |
575 | 2024-06-29 21:41:18 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
574 | 2024-06-28 11:31:58 | facts | 1 | 28756 | 10 | 1.626 | 17685.1 |
573 | 2024-06-28 02:26:50 | facts | 1 | 28756 | 10 | 0.953 | 30174.2 |
572 | 2024-06-26 09:19:03 | facts | 1 | 28756 | 10 | 0.750 | 38341.3 |
571 | 2024-06-10 18:51:05 | facts | 1 | 28756 | 10 | 0.986 | 29164.3 |
570 | 2024-06-08 02:24:58 | facts | 1 | 28756 | 10 | 0.843 | 34111.5 |
569 | 2024-06-04 05:59:59 | facts | 2 | 53800 | 200 | 3.033 | 17738.2 |
568 | 2024-06-03 12:54:33 | facts | 2 | 53800 | 200 | 5.656 | 9512.0 |
567 | 2024-06-03 12:45:20 | facts | 1 | 28756 | 10 | 0.953 | 30174.2 |
566 | 2024-06-01 08:15:48 | facts | 1 | 28756 | 10 | 2.826 | 10175.5 |
565 | 2024-05-30 21:40:16 | facts | 1 | 28756 | 10 | 0.513 | 56054.6 |
564 | 2024-05-30 08:50:34 | facts | 1 | 28756 | 10 | 1.936 | 14853.3 |
563 | 2024-05-28 01:59:44 | facts | 1 | 28756 | 10 | 2.203 | 13053.1 |
562 | 2024-05-10 08:22:43 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
561 | 2024-05-09 05:45:54 | facts | 1 | 28756 | 10 | 0.530 | 54256.6 |
560 | 2024-05-04 12:28:04 | facts | 1 | 28756 | 10 | 0.530 | 54256.6 |
559 | 2024-05-03 07:22:52 | facts | 1 | 28756 | 10 | 0.906 | 31739.5 |
558 | 2024-05-02 08:43:54 | facts | 1 | 28756 | 10 | 0.533 | 53951.2 |
557 | 2024-05-01 22:37:46 | facts | 2 | 53800 | 200 | 1.766 | 30464.3 |
556 | 2024-05-01 22:37:42 | facts | 1 | 28756 | 10 | 1.046 | 27491.4 |
555 | 2024-05-01 22:37:32 | facts | 2 | 53800 | 200 | 6.076 | 8854.5 |
554 | 2024-05-01 22:37:36 | facts | 1 | 28756 | 10 | 0.610 | 47141.0 |
553 | 2024-04-30 20:29:03 | facts | 1 | 28756 | 10 | 1.063 | 27051.7 |
552 | 2024-04-03 06:37:40 | facts | 1 | 28756 | 10 | 1.156 | 24875.4 |