History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mafia"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
668 | 2024-05-03 23:07:43 | mafia | 1 | 28756 | 7 | 0.623 | 46157.3 |
667 | 2024-04-30 17:43:11 | mafia | 1 | 28756 | 7 | 1.673 | 17188.3 |
666 | 2024-04-29 20:13:37 | mafia | 1 | 28756 | 7 | 0.500 | 57512.0 |
665 | 2024-04-27 23:35:43 | mafia | 1 | 28756 | 7 | 0.530 | 54256.6 |
664 | 2024-04-27 04:53:48 | mafia | 2 | 53800 | 62 | 1.783 | 30173.9 |
663 | 2024-04-23 00:40:35 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
662 | 2024-04-22 20:18:24 | mafia | 1 | 28756 | 7 | 0.500 | 57512.0 |
661 | 2024-04-22 12:08:56 | mafia | 1 | 28756 | 7 | 2.233 | 12877.7 |
660 | 2024-04-14 11:40:42 | mafia | 3 | 83667 | 983 | 19.423 | 4307.6 |
659 | 2024-04-09 02:06:13 | mafia | 2 | 53800 | 62 | 2.030 | 26502.5 |
658 | 2024-04-03 06:04:50 | mafia | 1 | 28756 | 7 | 0.486 | 59168.7 |
657 | 2024-03-31 06:50:28 | mafia | 2 | 53800 | 62 | 5.766 | 9330.6 |
656 | 2024-03-31 06:50:26 | mafia | 3 | 83667 | 983 | 5.906 | 14166.4 |
655 | 2024-03-31 06:42:43 | mafia | 1 | 28756 | 7 | 1.703 | 16885.5 |
654 | 2024-03-30 01:37:53 | mafia | 3 | 83667 | 983 | 13.593 | 6155.2 |
653 | 2024-03-29 09:45:50 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
652 | 2024-03-29 09:45:49 | mafia | 2 | 53800 | 62 | 1.500 | 35866.7 |
651 | 2024-03-29 09:45:13 | mafia | 3 | 83667 | 983 | 4.376 | 19119.5 |
650 | 2024-03-29 08:26:03 | mafia | 3 | 83667 | 983 | 10.110 | 8275.7 |
649 | 2024-03-29 08:26:03 | mafia | 2 | 53800 | 62 | 1.860 | 28924.7 |
648 | 2024-03-29 08:19:31 | mafia | 1 | 28756 | 7 | 0.516 | 55728.7 |
647 | 2024-03-03 21:01:33 | mafia | 1 | 28756 | 7 | 0.486 | 59168.7 |
646 | 2024-03-01 05:20:09 | mafia | 1 | 28756 | 7 | 0.420 | 68466.7 |
645 | 2024-02-28 02:30:58 | mafia | 1 | 28756 | 7 | 0.530 | 54256.6 |
644 | 2024-02-26 20:46:51 | mafia | 3 | 83667 | 983 | 6.906 | 12115.1 |
643 | 2024-02-22 11:46:21 | mafia | 3 | 83667 | 983 | 14.220 | 5883.8 |
642 | 2024-02-20 20:24:20 | mafia | 3 | 83667 | 983 | 5.483 | 15259.3 |
641 | 2024-01-29 00:12:17 | mafia | 1 | 28756 | 7 | 0.470 | 61183.0 |
640 | 2024-01-28 17:21:35 | mafia | 1 | 28756 | 7 | 0.516 | 55728.7 |
639 | 2024-01-19 11:33:20 | mafia | 1 | 28756 | 7 | 0.500 | 57512.0 |
638 | 2024-01-18 21:37:08 | mafia | 3 | 83667 | 983 | 4.420 | 18929.2 |
637 | 2023-12-21 00:22:50 | mafia | 3 | 83667 | 983 | 3.343 | 25027.5 |
636 | 2023-12-21 00:22:48 | mafia | 2 | 53800 | 62 | 1.486 | 36204.6 |
635 | 2023-12-10 23:24:21 | mafia | 2 | 53800 | 62 | 1.376 | 39098.8 |
634 | 2023-11-26 03:43:51 | mafia | 3 | 83667 | 983 | 3.750 | 22311.2 |
633 | 2023-11-21 12:39:37 | mafia | 3 | 83667 | 983 | 3.406 | 24564.6 |
632 | 2023-11-19 13:44:56 | mafia | 3 | 83667 | 983 | 8.796 | 9511.9 |
631 | 2023-11-19 13:44:45 | mafia | 2 | 53800 | 62 | 1.830 | 29398.9 |
630 | 2023-11-16 08:19:09 | mafia | 1 | 28756 | 7 | 0.440 | 65354.5 |
629 | 2023-11-14 14:24:33 | mafia | 2 | 53800 | 62 | 1.360 | 39558.8 |
628 | 2023-11-14 14:24:15 | mafia | 3 | 83667 | 983 | 3.280 | 25508.2 |
627 | 2023-11-14 06:33:53 | mafia | 1 | 28756 | 7 | 0.483 | 59536.2 |
626 | 2023-11-12 05:24:35 | mafia | 1 | 28756 | 7 | 0.533 | 53951.2 |
625 | 2023-11-08 12:46:26 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
624 | 2023-11-03 07:09:51 | mafia | 1 | 28756 | 7 | 0.470 | 61183.0 |
623 | 2023-10-21 14:38:35 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
622 | 2023-10-18 19:53:08 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
621 | 2023-10-13 01:12:27 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
620 | 2023-10-05 06:40:34 | mafia | 1 | 28756 | 7 | 0.466 | 61708.2 |
619 | 2023-09-26 13:48:45 | mafia | 1 | 28756 | 7 | 0.483 | 59536.2 |
618 | 2023-09-22 17:40:13 | mafia | 1 | 28756 | 7 | 0.440 | 65354.5 |
617 | 2023-09-07 21:14:51 | mafia | 2 | 53800 | 62 | 1.390 | 38705.0 |
616 | 2023-09-02 11:17:09 | mafia | 1 | 28756 | 7 | 0.500 | 57512.0 |
615 | 2023-08-22 04:09:59 | mafia | 3 | 83667 | 983 | 7.080 | 11817.4 |
614 | 2023-07-23 22:52:28 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
613 | 2023-06-26 06:50:32 | mafia | 3 | 83667 | 983 | 3.250 | 25743.7 |
612 | 2023-06-07 03:36:18 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
611 | 2023-06-01 02:56:15 | mafia | 3 | 83667 | 983 | 3.266 | 25617.6 |
610 | 2023-05-20 00:14:00 | mafia | 2 | 53800 | 62 | 1.673 | 32157.8 |
609 | 2023-05-07 07:42:29 | mafia | 2 | 53800 | 62 | 1.610 | 33416.1 |
608 | 2023-05-06 02:39:35 | mafia | 3 | 83667 | 983 | 3.250 | 25743.7 |
607 | 2023-04-29 11:56:59 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
606 | 2023-04-21 23:29:23 | mafia | 3 | 83667 | 983 | 3.610 | 23176.5 |
605 | 2023-04-12 11:00:23 | mafia | 3 | 83667 | 983 | 3.826 | 21868.0 |
604 | 2023-04-12 05:02:13 | mafia | 1 | 28756 | 7 | 0.440 | 65354.5 |
603 | 2023-04-09 02:55:36 | mafia | 3 | 83667 | 983 | 3.326 | 25155.4 |
602 | 2023-03-28 19:57:25 | mafia | 1 | 28756 | 7 | 0.420 | 68466.7 |
601 | 2023-03-26 22:58:20 | mafia | 3 | 83667 | 983 | 3.546 | 23594.8 |
600 | 2023-03-25 19:03:21 | mafia | 2 | 53800 | 62 | 1.606 | 33499.4 |
599 | 2023-03-23 07:20:23 | mafia | 3 | 83667 | 983 | 3.280 | 25508.2 |
598 | 2023-03-20 00:51:03 | mafia | 3 | 83667 | 983 | 3.750 | 22311.2 |
597 | 2023-03-19 21:48:29 | mafia | 1 | 28756 | 7 | 0.530 | 54256.6 |
596 | 2023-03-15 12:45:49 | mafia | 3 | 83667 | 983 | 3.753 | 22293.4 |
595 | 2023-02-26 23:16:02 | mafia | 2 | 53800 | 62 | 1.560 | 34487.2 |
594 | 2023-02-14 03:11:40 | mafia | 3 | 83667 | 983 | 3.390 | 24680.5 |
593 | 2023-01-11 13:02:51 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
592 | 2023-01-07 02:33:46 | mafia | 1 | 28756 | 7 | 0.420 | 68466.7 |
591 | 2022-12-08 21:04:07 | mafia | 2 | 53800 | 62 | 1.360 | 39558.8 |
590 | 2022-11-25 12:33:45 | mafia | 3 | 83667 | 983 | 3.280 | 25508.2 |
589 | 2022-10-21 21:00:05 | mafia | 1 | 28756 | 7 | 0.450 | 63902.2 |
588 | 2022-09-23 08:43:43 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
587 | 2022-09-20 01:36:58 | mafia | 1 | 28756 | 7 | 0.440 | 65354.5 |
586 | 2022-08-31 22:33:51 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
585 | 2022-08-15 21:51:08 | mafia | 1 | 28756 | 7 | 0.440 | 65354.5 |
584 | 2022-08-14 21:30:24 | mafia | 1 | 28756 | 7 | 0.436 | 65954.1 |
583 | 2022-07-30 08:12:08 | mafia | 1 | 28756 | 7 | 0.440 | 65354.5 |
582 | 2022-07-29 05:42:02 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
581 | 2022-07-17 07:39:31 | mafia | 2 | 53800 | 62 | 1.390 | 38705.0 |
580 | 2022-07-11 04:13:28 | mafia | 3 | 83667 | 983 | 3.250 | 25743.7 |
579 | 2022-06-12 08:28:30 | mafia | 1 | 28756 | 7 | 0.500 | 57512.0 |
578 | 2022-06-06 08:45:32 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
577 | 2022-06-04 18:46:53 | mafia | 3 | 83667 | 983 | 3.360 | 24900.9 |
576 | 2022-05-01 00:09:06 | mafia | 3 | 83667 | 983 | 3.376 | 24782.9 |
575 | 2022-04-28 20:56:01 | mafia | 3 | 83667 | 983 | 4.373 | 19132.6 |
574 | 2022-02-27 18:21:09 | mafia | 2 | 53800 | 62 | 1.563 | 34421.0 |
573 | 2022-02-22 02:49:14 | mafia | 1 | 28756 | 7 | 0.500 | 57512.0 |
572 | 2022-02-16 05:29:00 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
571 | 2021-12-31 19:22:28 | mafia | 3 | 83667 | 983 | 4.186 | 19987.3 |
570 | 2021-12-28 03:07:28 | mafia | 1 | 28756 | 7 | 0.453 | 63479.0 |
569 | 2021-11-21 11:04:56 | mafia | 3 | 83667 | 983 | 3.343 | 25027.5 |