History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"calif"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
675 | 2024-04-16 20:15:13 | calif | 1 | 28756 | 6 | 1.123 | 25606.4 |
674 | 2024-04-06 21:01:49 | calif | 1 | 28756 | 6 | 1.206 | 23844.1 |
673 | 2024-04-03 06:58:47 | calif | 1 | 28756 | 6 | 0.813 | 35370.2 |
672 | 2024-03-31 07:01:58 | calif | 1 | 28756 | 6 | 1.530 | 18794.8 |
671 | 2024-03-28 18:31:45 | calif | 1 | 28756 | 6 | 1.796 | 16011.1 |
670 | 2024-03-12 19:42:12 | calif | 2 | 53800 | 66 | 5.000 | 10760.0 |
669 | 2024-03-12 06:28:48 | calif | 2 | 53800 | 66 | 1.923 | 27977.1 |
668 | 2024-03-05 17:52:27 | calif | 3 | 83667 | 1237 | 9.766 | 8567.2 |
667 | 2024-03-05 13:21:19 | calif | 2 | 53800 | 66 | 3.733 | 14412.0 |
666 | 2024-03-05 13:21:00 | calif | 3 | 83667 | 1237 | 4.156 | 20131.6 |
665 | 2024-03-05 06:37:42 | calif | 3 | 83667 | 1237 | 10.466 | 7994.2 |
664 | 2024-03-04 20:48:28 | calif | 2 | 53800 | 66 | 1.813 | 29674.6 |
663 | 2024-03-04 20:48:28 | calif | 1 | 28756 | 6 | 0.580 | 49579.3 |
662 | 2024-03-04 20:48:05 | calif | 3 | 83667 | 1237 | 7.750 | 10795.7 |
661 | 2024-03-04 16:29:59 | calif | 3 | 83667 | 1237 | 13.203 | 6337.0 |
660 | 2024-03-04 03:33:04 | calif | 3 | 83667 | 1237 | 3.530 | 23701.7 |
659 | 2024-03-04 03:33:04 | calif | 2 | 53800 | 66 | 1.593 | 33772.8 |
658 | 2024-03-04 03:32:59 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
657 | 2024-02-25 18:11:29 | calif | 1 | 28756 | 6 | 1.593 | 18051.5 |
656 | 2024-02-03 02:39:11 | calif | 1 | 28756 | 6 | 0.513 | 56054.6 |
655 | 2024-01-29 06:26:11 | calif | 1 | 28756 | 6 | 0.483 | 59536.2 |
654 | 2024-01-26 11:14:37 | calif | 3 | 83667 | 1237 | 3.626 | 23074.2 |
653 | 2024-01-26 11:14:05 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
652 | 2024-01-24 09:00:02 | calif | 1 | 28756 | 6 | 0.483 | 59536.2 |
651 | 2024-01-14 05:41:48 | calif | 3 | 83667 | 1237 | 3.873 | 21602.6 |
650 | 2024-01-02 06:07:09 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
649 | 2023-12-30 04:59:46 | calif | 2 | 53800 | 66 | 1.610 | 33416.1 |
648 | 2023-12-30 04:59:43 | calif | 3 | 83667 | 1237 | 3.560 | 23502.0 |
647 | 2023-12-25 06:47:25 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
646 | 2023-12-21 18:03:28 | calif | 3 | 83667 | 1237 | 4.186 | 19987.3 |
645 | 2023-12-21 18:03:27 | calif | 2 | 53800 | 66 | 1.703 | 31591.3 |
644 | 2023-11-29 14:27:14 | calif | 3 | 83667 | 1237 | 4.173 | 20049.6 |
643 | 2023-11-29 14:27:16 | calif | 2 | 53800 | 66 | 1.750 | 30742.9 |
642 | 2023-11-25 09:40:15 | calif | 2 | 53800 | 66 | 1.576 | 34137.1 |
641 | 2023-11-13 22:52:56 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
640 | 2023-11-12 10:00:04 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
639 | 2023-11-07 07:43:58 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
638 | 2023-11-04 05:46:06 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
637 | 2023-11-03 08:48:16 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
636 | 2023-10-29 21:43:25 | calif | 2 | 53800 | 66 | 1.466 | 36698.5 |
635 | 2023-10-26 15:32:39 | calif | 3 | 83667 | 1237 | 6.876 | 12168.0 |
634 | 2023-10-25 22:38:32 | calif | 1 | 28756 | 6 | 0.516 | 55728.7 |
633 | 2023-10-25 06:52:57 | calif | 1 | 28756 | 6 | 0.486 | 59168.7 |
632 | 2023-10-24 11:11:12 | calif | 3 | 83667 | 1237 | 3.763 | 22234.1 |
631 | 2023-10-22 05:02:06 | calif | 1 | 28756 | 6 | 0.516 | 55728.7 |
630 | 2023-10-20 09:52:20 | calif | 1 | 28756 | 6 | 0.470 | 61183.0 |
629 | 2023-10-14 16:07:51 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
628 | 2023-10-13 01:07:52 | calif | 1 | 28756 | 6 | 0.483 | 59536.2 |
627 | 2023-10-04 19:10:13 | calif | 3 | 83667 | 1237 | 3.393 | 24658.7 |
626 | 2023-10-03 16:48:30 | calif | 1 | 28756 | 6 | 0.470 | 61183.0 |
625 | 2023-09-30 09:32:43 | calif | 3 | 83667 | 1237 | 3.923 | 21327.3 |
624 | 2023-09-30 09:32:35 | calif | 2 | 53800 | 66 | 2.063 | 26078.5 |
623 | 2023-09-24 21:57:19 | calif | 1 | 28756 | 6 | 0.533 | 53951.2 |
622 | 2023-09-15 11:17:28 | calif | 1 | 28756 | 6 | 0.470 | 61183.0 |
621 | 2023-08-24 02:13:28 | calif | 2 | 53800 | 66 | 1.593 | 33772.8 |
620 | 2023-08-18 18:14:33 | calif | 1 | 28756 | 6 | 0.486 | 59168.7 |
619 | 2023-08-02 08:47:10 | calif | 3 | 83667 | 1237 | 3.546 | 23594.8 |
618 | 2023-07-17 04:44:03 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
617 | 2023-07-07 06:59:34 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
616 | 2023-05-19 01:31:55 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
615 | 2023-05-10 13:34:49 | calif | 2 | 53800 | 66 | 1.423 | 37807.4 |
614 | 2023-04-12 13:34:14 | calif | 3 | 83667 | 1237 | 3.310 | 25277.0 |
613 | 2023-03-31 15:03:04 | calif | 3 | 83667 | 1237 | 3.393 | 24658.7 |
612 | 2023-03-27 15:37:14 | calif | 1 | 28756 | 6 | 0.516 | 55728.7 |
611 | 2023-03-27 01:58:22 | calif | 1 | 28756 | 6 | 0.436 | 65954.1 |
610 | 2023-03-14 18:08:39 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
609 | 2023-02-19 15:57:46 | calif | 2 | 53800 | 66 | 1.423 | 37807.4 |
608 | 2023-01-17 12:01:57 | calif | 3 | 83667 | 1237 | 3.890 | 21508.2 |
607 | 2023-01-03 09:44:34 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
606 | 2022-12-15 04:28:38 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
605 | 2022-11-30 21:12:03 | calif | 2 | 53800 | 66 | 1.393 | 38621.7 |
604 | 2022-10-29 11:15:25 | calif | 3 | 83667 | 1237 | 3.360 | 24900.9 |
603 | 2022-09-25 20:34:54 | calif | 1 | 28756 | 6 | 0.580 | 49579.3 |
602 | 2022-09-04 06:32:51 | calif | 1 | 28756 | 6 | 0.513 | 56054.6 |
601 | 2022-09-01 23:10:03 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
600 | 2022-08-31 16:00:00 | calif | 1 | 28756 | 6 | 0.470 | 61183.0 |
599 | 2022-08-14 16:02:32 | calif | 1 | 28756 | 6 | 0.486 | 59168.7 |
598 | 2022-07-07 14:58:56 | calif | 2 | 53800 | 66 | 1.403 | 38346.4 |
597 | 2022-05-31 05:21:14 | calif | 3 | 83667 | 1237 | 3.373 | 24804.9 |
596 | 2022-05-23 01:46:53 | calif | 1 | 28756 | 6 | 0.486 | 59168.7 |
595 | 2022-05-19 16:02:58 | calif | 1 | 28756 | 6 | 0.450 | 63902.2 |
594 | 2022-05-13 10:04:40 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
593 | 2022-02-20 23:00:56 | calif | 2 | 53800 | 66 | 1.533 | 35094.6 |
592 | 2022-02-14 23:45:17 | calif | 1 | 28756 | 6 | 0.483 | 59536.2 |
591 | 2022-02-11 10:41:48 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
590 | 2022-02-06 16:45:17 | calif | 1 | 28756 | 6 | 0.530 | 54256.6 |
589 | 2022-02-05 12:38:23 | calif | 1 | 28756 | 6 | 0.516 | 55728.7 |
588 | 2022-02-04 13:42:50 | calif | 1 | 28756 | 6 | 1.030 | 27918.4 |
587 | 2022-02-03 09:54:57 | calif | 1 | 28756 | 6 | 0.550 | 52283.6 |
586 | 2022-02-02 07:07:53 | calif | 1 | 28756 | 6 | 0.436 | 65954.1 |
585 | 2022-02-01 10:22:50 | calif | 1 | 28756 | 6 | 0.533 | 53951.2 |
584 | 2022-02-01 08:39:56 | calif | 1 | 28756 | 6 | 1.013 | 28387.0 |
583 | 2022-01-31 08:48:08 | calif | 1 | 28756 | 6 | 0.546 | 52666.7 |
582 | 2022-01-30 14:55:06 | calif | 1 | 28756 | 6 | 0.533 | 53951.2 |
581 | 2022-01-29 15:06:21 | calif | 1 | 28756 | 6 | 0.533 | 53951.2 |
580 | 2022-01-16 23:03:54 | calif | 1 | 28756 | 6 | 0.453 | 63479.0 |
579 | 2021-12-01 18:29:30 | calif | 2 | 53800 | 66 | 1.530 | 35163.4 |
578 | 2021-11-25 11:20:30 | calif | 1 | 28756 | 6 | 0.466 | 61708.2 |
577 | 2021-11-10 10:17:10 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |
576 | 2021-11-08 16:46:14 | calif | 1 | 28756 | 6 | 0.500 | 57512.0 |