History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smacker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
659 | 2024-04-19 05:14:44 | smacker | 1 | 69583 | 7 | 4.033 | 17253.4 |
658 | 2024-03-28 10:37:57 | smacker | 1 | 69583 | 7 | 1.263 | 55093.4 |
657 | 2024-03-26 03:18:11 | smacker | 1 | 69583 | 7 | 1.186 | 58670.3 |
656 | 2024-03-18 20:51:56 | smacker | 2 | 107671 | 71 | 7.470 | 14413.8 |
655 | 2024-03-18 20:51:16 | smacker | 3 | 134027 | 565 | 7.673 | 17467.4 |
654 | 2024-03-18 11:41:03 | smacker | 3 | 134027 | 565 | 13.956 | 9603.5 |
653 | 2024-03-15 15:59:40 | smacker | 2 | 107671 | 71 | 6.783 | 15873.7 |
652 | 2024-03-15 15:56:22 | smacker | 3 | 134027 | 565 | 7.330 | 18284.7 |
651 | 2024-03-13 04:35:31 | smacker | 3 | 134027 | 565 | 15.686 | 8544.4 |
650 | 2024-03-13 04:35:31 | smacker | 2 | 107671 | 71 | 7.733 | 13923.6 |
649 | 2024-03-13 04:35:10 | smacker | 1 | 69583 | 7 | 3.203 | 21724.3 |
648 | 2024-03-13 04:34:40 | smacker | 3 | 134027 | 565 | 15.233 | 8798.5 |
647 | 2024-03-13 04:34:35 | smacker | 2 | 107671 | 71 | 7.750 | 13893.0 |
646 | 2024-03-13 04:34:21 | smacker | 1 | 69583 | 7 | 1.376 | 50569.0 |
645 | 2024-02-09 18:27:06 | smacker | 3 | 134027 | 565 | 12.300 | 10896.5 |
644 | 2024-02-05 21:05:42 | smacker | 3 | 134027 | 565 | 6.593 | 20328.7 |
643 | 2024-01-25 23:05:39 | smacker | 3 | 134027 | 565 | 7.063 | 18975.9 |
642 | 2024-01-15 00:39:02 | smacker | 3 | 134027 | 565 | 6.703 | 19995.1 |
641 | 2024-01-15 00:38:59 | smacker | 2 | 107671 | 71 | 3.500 | 30763.1 |
640 | 2024-01-12 22:30:09 | smacker | 1 | 69583 | 7 | 1.186 | 58670.3 |
639 | 2024-01-05 06:09:11 | smacker | 1 | 69583 | 7 | 1.173 | 59320.5 |
638 | 2024-01-01 16:06:01 | smacker | 1 | 69583 | 7 | 1.156 | 60192.9 |
637 | 2023-12-18 04:01:05 | smacker | 1 | 69583 | 7 | 1.093 | 63662.4 |
636 | 2023-12-15 20:35:28 | smacker | 1 | 69583 | 7 | 1.500 | 46388.7 |
635 | 2023-11-17 05:54:04 | smacker | 1 | 69583 | 7 | 1.580 | 44039.9 |
634 | 2023-10-23 19:06:18 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
633 | 2023-10-14 07:46:07 | smacker | 1 | 69583 | 7 | 1.220 | 57035.2 |
632 | 2023-10-08 03:28:43 | smacker | 3 | 134027 | 565 | 9.903 | 13534.0 |
631 | 2023-10-06 17:55:41 | smacker | 1 | 69583 | 7 | 1.250 | 55666.4 |
630 | 2023-10-06 17:51:23 | smacker | 2 | 107671 | 71 | 3.610 | 29825.8 |
629 | 2023-10-05 00:08:54 | smacker | 1 | 69583 | 7 | 1.076 | 64668.2 |
628 | 2023-10-04 21:23:50 | smacker | 3 | 134027 | 565 | 8.060 | 16628.7 |
627 | 2023-10-01 18:37:21 | smacker | 3 | 134027 | 565 | 7.876 | 17017.1 |
626 | 2023-10-01 18:37:22 | smacker | 2 | 107671 | 71 | 3.796 | 28364.3 |
625 | 2023-09-29 08:17:53 | smacker | 1 | 69583 | 7 | 1.250 | 55666.4 |
624 | 2023-09-23 19:42:51 | smacker | 1 | 69583 | 7 | 1.123 | 61961.7 |
623 | 2023-08-27 02:50:22 | smacker | 1 | 69583 | 7 | 1.110 | 62687.4 |
622 | 2023-08-02 01:33:22 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
621 | 2023-04-26 05:26:41 | smacker | 1 | 69583 | 7 | 1.250 | 55666.4 |
620 | 2023-04-21 11:11:18 | smacker | 1 | 69583 | 7 | 1.123 | 61961.7 |
619 | 2023-03-04 05:15:39 | smacker | 1 | 69583 | 7 | 1.090 | 63837.6 |
618 | 2023-02-13 23:59:31 | smacker | 1 | 69583 | 7 | 1.076 | 64668.2 |
617 | 2022-12-14 19:47:41 | smacker | 1 | 69583 | 7 | 2.143 | 32469.9 |
616 | 2022-12-10 20:27:47 | smacker | 1 | 69583 | 7 | 1.046 | 66522.9 |
615 | 2022-10-02 16:44:03 | smacker | 1 | 69583 | 7 | 1.233 | 56433.9 |
614 | 2022-08-29 00:50:56 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
613 | 2022-08-18 17:52:53 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
612 | 2022-08-13 03:34:57 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
611 | 2022-08-08 03:45:28 | smacker | 1 | 69583 | 7 | 1.186 | 58670.3 |
610 | 2022-07-26 12:33:14 | smacker | 1 | 69583 | 7 | 1.096 | 63488.1 |
609 | 2022-05-18 13:40:25 | smacker | 1 | 69583 | 7 | 1.063 | 65459.1 |
608 | 2022-04-06 21:43:10 | smacker | 1 | 69583 | 7 | 1.140 | 61037.7 |
607 | 2022-04-04 08:09:08 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
606 | 2022-04-02 04:45:03 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
605 | 2022-01-08 00:58:20 | smacker | 1 | 69583 | 7 | 1.126 | 61796.6 |
604 | 2021-12-30 23:05:34 | smacker | 1 | 69583 | 7 | 1.173 | 59320.5 |
603 | 2021-12-13 07:53:21 | smacker | 1 | 69583 | 7 | 1.250 | 55666.4 |
602 | 2021-11-10 08:16:16 | smacker | 1 | 69583 | 7 | 1.216 | 57222.9 |
601 | 2021-11-08 06:14:36 | smacker | 1 | 69583 | 7 | 1.326 | 52475.9 |
600 | 2021-09-27 22:50:36 | smacker | 1 | 69583 | 7 | 1.216 | 57222.9 |
599 | 2021-09-25 20:12:26 | smacker | 1 | 69583 | 7 | 1.263 | 55093.4 |
598 | 2021-09-08 16:09:09 | smacker | 1 | 69583 | 7 | 1.250 | 55666.4 |
597 | 2021-08-27 03:51:11 | smacker | 1 | 69583 | 7 | 1.190 | 58473.1 |
596 | 2021-08-23 20:50:20 | smacker | 1 | 69583 | 7 | 1.106 | 62914.1 |
595 | 2021-07-30 17:13:47 | smacker | 3 | 134027 | 565 | 5.986 | 22390.1 |
594 | 2021-07-27 21:17:30 | smacker | 1 | 69583 | 7 | 1.046 | 66522.9 |
593 | 2021-06-26 16:00:07 | smacker | 3 | 134027 | 565 | 6.016 | 22278.4 |
592 | 2021-05-31 23:54:50 | smacker | 3 | 134027 | 565 | 5.810 | 23068.3 |
591 | 2021-05-19 18:22:42 | smacker | 1 | 69583 | 7 | 1.123 | 61961.7 |
590 | 2021-05-18 20:09:02 | smacker | 1 | 69583 | 7 | 1.233 | 56433.9 |
589 | 2021-04-20 11:00:10 | smacker | 2 | 107671 | 71 | 3.000 | 35890.3 |
588 | 2021-04-18 22:12:21 | smacker | 1 | 69583 | 7 | 1.313 | 52995.4 |
587 | 2021-03-01 19:13:36 | smacker | 3 | 134027 | 565 | 5.716 | 23447.7 |
586 | 2021-02-16 21:43:07 | smacker | 1 | 69583 | 7 | 1.093 | 63662.4 |
585 | 2021-02-01 14:25:39 | smacker | 2 | 107671 | 71 | 2.890 | 37256.4 |
584 | 2021-01-31 06:30:26 | smacker | 1 | 69583 | 7 | 1.093 | 63662.4 |
583 | 2021-01-18 04:42:05 | smacker | 1 | 69583 | 7 | 1.093 | 63662.4 |
582 | 2021-01-03 13:15:40 | smacker | 1 | 69583 | 7 | 1.080 | 64428.7 |
581 | 2020-11-19 04:11:02 | smacker | 1 | 69583 | 7 | 1.173 | 59320.5 |
580 | 2020-11-12 15:27:31 | smacker | 1 | 69583 | 7 | 1.110 | 62687.4 |
579 | 2020-10-23 22:20:58 | smacker | 1 | 69583 | 7 | 1.063 | 65459.1 |
578 | 2020-10-16 09:54:13 | smacker | 3 | 134027 | 565 | 5.936 | 22578.7 |
577 | 2020-08-13 08:42:55 | smacker | 1 | 69583 | 7 | 1.203 | 57841.2 |
576 | 2020-08-10 08:05:03 | smacker | 1 | 69583 | 7 | 1.093 | 63662.4 |
575 | 2020-07-27 07:12:23 | smacker | 1 | 69583 | 7 | 1.140 | 61037.7 |
574 | 2020-07-23 23:50:53 | smacker | 1 | 69583 | 7 | 1.126 | 61796.6 |
573 | 2020-05-05 04:25:20 | smacker | 1 | 69583 | 7 | 1.233 | 56433.9 |
572 | 2020-04-21 21:50:55 | smacker | 1 | 69583 | 7 | 1.330 | 52318.0 |
571 | 2020-03-28 20:30:18 | smacker | 1 | 69583 | 7 | 1.263 | 55093.4 |
570 | 2020-03-25 09:22:17 | smacker | 1 | 69583 | 7 | 1.220 | 57035.2 |
569 | 2020-03-25 00:19:41 | smacker | 1 | 69583 | 7 | 1.296 | 53690.6 |
568 | 2020-03-20 10:10:22 | smacker | 1 | 69583 | 7 | 1.266 | 54962.9 |
567 | 2020-03-01 04:28:16 | smacker | 2 | 107671 | 71 | 4.126 | 26095.7 |
566 | 2020-02-27 16:41:15 | smacker | 1 | 69583 | 7 | 1.326 | 52475.9 |
565 | 2020-02-22 09:06:30 | smacker | 1 | 69583 | 7 | 1.296 | 53690.6 |
564 | 2020-02-16 02:36:55 | smacker | 3 | 134027 | 565 | 6.423 | 20866.7 |
563 | 2020-02-14 18:54:04 | smacker | 1 | 69583 | 7 | 4.876 | 14270.5 |
562 | 2020-02-14 11:21:16 | smacker | 3 | 134027 | 565 | 7.813 | 17154.4 |
561 | 2020-02-14 00:02:23 | smacker | 3 | 134027 | 565 | 14.283 | 9383.7 |
560 | 2020-02-13 17:04:24 | smacker | 3 | 134027 | 565 | 8.000 | 16753.4 |