History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gunny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
654 | 2024-05-01 19:40:34 | gunny | 1 | 28756 | 9 | 0.550 | 52283.6 |
653 | 2024-04-30 17:45:03 | gunny | 1 | 28756 | 9 | 1.123 | 25606.4 |
652 | 2024-04-27 05:41:34 | gunny | 1 | 28756 | 9 | 0.470 | 61183.0 |
651 | 2024-04-27 05:40:37 | gunny | 1 | 28756 | 9 | 0.516 | 55728.7 |
650 | 2024-04-18 15:51:15 | gunny | 1 | 28756 | 9 | 1.560 | 18433.3 |
649 | 2024-04-03 03:15:58 | gunny | 1 | 28756 | 9 | 1.580 | 18200.0 |
648 | 2024-03-31 03:04:50 | gunny | 1 | 28756 | 9 | 0.546 | 52666.7 |
647 | 2024-03-27 04:55:20 | gunny | 1 | 28756 | 9 | 1.080 | 26625.9 |
646 | 2024-03-19 02:38:41 | gunny | 3 | 83667 | 810 | 8.796 | 9511.9 |
645 | 2024-03-15 22:36:58 | gunny | 1 | 28756 | 9 | 0.546 | 52666.7 |
644 | 2024-03-12 06:35:31 | gunny | 1 | 28756 | 9 | 0.533 | 53951.2 |
643 | 2024-03-12 06:35:00 | gunny | 3 | 83667 | 810 | 4.186 | 19987.3 |
642 | 2024-03-03 21:00:08 | gunny | 1 | 28756 | 9 | 0.500 | 57512.0 |
641 | 2024-03-02 14:49:19 | gunny | 2 | 53800 | 70 | 5.326 | 10101.4 |
640 | 2024-03-01 09:19:37 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
639 | 2024-03-01 03:44:02 | gunny | 2 | 53800 | 70 | 3.220 | 16708.1 |
638 | 2024-03-01 03:43:36 | gunny | 3 | 83667 | 810 | 4.940 | 16936.6 |
637 | 2024-02-29 07:49:07 | gunny | 3 | 83667 | 810 | 5.486 | 15251.0 |
636 | 2024-02-25 17:37:14 | gunny | 1 | 28756 | 9 | 0.483 | 59536.2 |
635 | 2024-02-18 03:52:43 | gunny | 2 | 53800 | 70 | 4.956 | 10855.5 |
634 | 2024-02-17 01:15:11 | gunny | 1 | 28756 | 9 | 0.513 | 56054.6 |
633 | 2024-02-16 22:27:27 | gunny | 2 | 53800 | 70 | 1.623 | 33148.5 |
632 | 2024-02-13 09:27:15 | gunny | 1 | 28756 | 9 | 0.596 | 48248.3 |
631 | 2024-02-03 11:02:29 | gunny | 2 | 53800 | 70 | 1.326 | 40573.2 |
630 | 2024-02-03 11:02:02 | gunny | 3 | 83667 | 810 | 3.126 | 26764.9 |
629 | 2024-02-02 19:56:35 | gunny | 1 | 28756 | 9 | 0.546 | 52666.7 |
628 | 2024-01-30 14:56:15 | gunny | 2 | 53800 | 70 | 2.860 | 18811.2 |
627 | 2024-01-30 14:55:39 | gunny | 3 | 83667 | 810 | 3.140 | 26645.5 |
626 | 2024-01-26 04:54:42 | gunny | 3 | 83667 | 810 | 3.843 | 21771.3 |
625 | 2024-01-25 21:03:37 | gunny | 1 | 28756 | 9 | 1.013 | 28387.0 |
624 | 2024-01-20 05:41:32 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
623 | 2024-01-14 07:57:48 | gunny | 1 | 28756 | 9 | 0.546 | 52666.7 |
622 | 2024-01-11 23:31:29 | gunny | 1 | 28756 | 9 | 0.500 | 57512.0 |
621 | 2024-01-10 04:18:48 | gunny | 1 | 28756 | 9 | 0.516 | 55728.7 |
620 | 2024-01-09 23:28:11 | gunny | 1 | 28756 | 9 | 0.500 | 57512.0 |
619 | 2024-01-09 07:24:11 | gunny | 1 | 28756 | 9 | 0.440 | 65354.5 |
618 | 2024-01-05 19:13:51 | gunny | 1 | 28756 | 9 | 0.453 | 63479.0 |
617 | 2024-01-04 23:35:26 | gunny | 2 | 53800 | 70 | 2.030 | 26502.5 |
616 | 2023-12-01 07:29:10 | gunny | 1 | 28756 | 9 | 0.453 | 63479.0 |
615 | 2023-11-20 02:12:23 | gunny | 3 | 83667 | 810 | 3.716 | 22515.3 |
614 | 2023-11-20 02:12:25 | gunny | 2 | 53800 | 70 | 1.576 | 34137.1 |
613 | 2023-11-17 10:03:31 | gunny | 2 | 53800 | 70 | 1.546 | 34799.5 |
612 | 2023-11-15 17:47:23 | gunny | 2 | 53800 | 70 | 1.470 | 36598.6 |
611 | 2023-11-14 05:42:11 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
610 | 2023-11-10 03:36:03 | gunny | 3 | 83667 | 810 | 3.720 | 22491.1 |
609 | 2023-11-09 21:18:37 | gunny | 3 | 83667 | 810 | 3.640 | 22985.4 |
608 | 2023-11-08 19:07:35 | gunny | 1 | 28756 | 9 | 0.483 | 59536.2 |
607 | 2023-11-06 07:48:18 | gunny | 3 | 83667 | 810 | 3.623 | 23093.3 |
606 | 2023-10-29 19:00:48 | gunny | 3 | 83667 | 810 | 3.250 | 25743.7 |
605 | 2023-10-29 19:00:40 | gunny | 2 | 53800 | 70 | 1.356 | 39675.5 |
604 | 2023-10-27 02:30:20 | gunny | 1 | 28756 | 9 | 0.420 | 68466.7 |
603 | 2023-10-20 18:26:58 | gunny | 1 | 28756 | 9 | 0.470 | 61183.0 |
602 | 2023-10-17 14:05:42 | gunny | 1 | 28756 | 9 | 0.440 | 65354.5 |
601 | 2023-10-11 13:52:53 | gunny | 1 | 28756 | 9 | 0.423 | 67981.1 |
600 | 2023-10-05 11:43:45 | gunny | 3 | 83667 | 810 | 3.156 | 26510.5 |
599 | 2023-10-05 11:43:42 | gunny | 2 | 53800 | 70 | 1.483 | 36277.8 |
598 | 2023-10-03 09:51:06 | gunny | 1 | 28756 | 9 | 0.440 | 65354.5 |
597 | 2023-09-28 12:35:51 | gunny | 1 | 28756 | 9 | 0.453 | 63479.0 |
596 | 2023-09-26 06:19:10 | gunny | 1 | 28756 | 9 | 0.453 | 63479.0 |
595 | 2023-09-25 17:45:06 | gunny | 1 | 28756 | 9 | 0.470 | 61183.0 |
594 | 2023-09-20 17:34:10 | gunny | 1 | 28756 | 9 | 0.423 | 67981.1 |
593 | 2023-09-15 07:02:19 | gunny | 1 | 28756 | 9 | 0.500 | 57512.0 |
592 | 2023-08-18 14:59:14 | gunny | 2 | 53800 | 70 | 1.656 | 32487.9 |
591 | 2023-08-12 03:41:15 | gunny | 3 | 83667 | 810 | 3.716 | 22515.3 |
590 | 2023-07-01 20:38:48 | gunny | 1 | 28756 | 9 | 0.483 | 59536.2 |
589 | 2023-06-09 05:16:38 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
588 | 2023-06-05 23:05:35 | gunny | 1 | 28756 | 9 | 0.470 | 61183.0 |
587 | 2023-05-05 09:54:26 | gunny | 2 | 53800 | 70 | 1.313 | 40974.9 |
586 | 2023-04-25 00:02:35 | gunny | 3 | 83667 | 810 | 3.653 | 22903.6 |
585 | 2023-04-11 02:22:45 | gunny | 1 | 28756 | 9 | 0.420 | 68466.7 |
584 | 2023-02-24 12:45:55 | gunny | 1 | 28756 | 9 | 0.483 | 59536.2 |
583 | 2023-02-13 20:31:49 | gunny | 2 | 53800 | 70 | 1.576 | 34137.1 |
582 | 2023-01-30 05:10:35 | gunny | 1 | 28756 | 9 | 0.420 | 68466.7 |
581 | 2023-01-27 22:55:49 | gunny | 3 | 83667 | 810 | 3.593 | 23286.1 |
580 | 2022-12-19 00:52:43 | gunny | 3 | 83667 | 810 | 3.250 | 25743.7 |
579 | 2022-11-26 17:01:53 | gunny | 1 | 28756 | 9 | 0.423 | 67981.1 |
578 | 2022-11-25 14:48:49 | gunny | 2 | 53800 | 70 | 1.376 | 39098.8 |
577 | 2022-11-10 00:25:56 | gunny | 3 | 83667 | 810 | 3.233 | 25879.1 |
576 | 2022-11-07 15:05:05 | gunny | 1 | 28756 | 9 | 0.483 | 59536.2 |
575 | 2022-11-06 10:53:50 | gunny | 3 | 83667 | 810 | 3.300 | 25353.6 |
574 | 2022-11-05 04:24:21 | gunny | 3 | 83667 | 810 | 3.173 | 26368.4 |
573 | 2022-11-03 14:15:00 | gunny | 3 | 83667 | 810 | 3.283 | 25484.9 |
572 | 2022-11-01 16:40:24 | gunny | 3 | 83667 | 810 | 3.466 | 24139.4 |
571 | 2022-09-18 09:47:32 | gunny | 3 | 83667 | 810 | 3.186 | 26260.8 |
570 | 2022-08-29 20:20:49 | gunny | 3 | 83667 | 810 | 3.720 | 22491.1 |
569 | 2022-08-09 10:04:01 | gunny | 3 | 83667 | 810 | 3.830 | 21845.2 |
568 | 2022-08-02 07:01:56 | gunny | 3 | 83667 | 810 | 3.170 | 26393.4 |
567 | 2022-07-21 21:58:40 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
566 | 2022-07-21 11:32:58 | gunny | 1 | 28756 | 9 | 0.500 | 57512.0 |
565 | 2022-06-26 00:21:39 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
564 | 2022-06-14 07:59:27 | gunny | 3 | 83667 | 810 | 3.186 | 26260.8 |
563 | 2022-05-06 09:32:12 | gunny | 3 | 83667 | 810 | 3.953 | 21165.4 |
562 | 2022-04-19 05:19:21 | gunny | 2 | 53800 | 70 | 1.360 | 39558.8 |
561 | 2022-04-03 13:58:57 | gunny | 1 | 28756 | 9 | 0.440 | 65354.5 |
560 | 2022-03-25 06:40:47 | gunny | 1 | 28756 | 9 | 0.546 | 52666.7 |
559 | 2021-12-31 04:02:10 | gunny | 1 | 28756 | 9 | 0.483 | 59536.2 |
558 | 2021-12-24 13:20:37 | gunny | 2 | 53800 | 70 | 1.533 | 35094.6 |
557 | 2021-12-19 20:45:32 | gunny | 1 | 28756 | 9 | 0.470 | 61183.0 |
556 | 2021-11-07 03:29:45 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |
555 | 2021-10-31 15:37:32 | gunny | 1 | 28756 | 9 | 0.436 | 65954.1 |