History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"cisco"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
670 | 2024-04-27 18:29:49 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
669 | 2024-04-21 06:08:47 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
668 | 2024-04-18 19:14:33 | cisco | 2 | 53800 | 29 | 5.140 | 10466.9 |
667 | 2024-04-18 19:13:16 | cisco | 2 | 53800 | 29 | 1.876 | 28678.0 |
666 | 2024-04-18 14:19:07 | cisco | 1 | 28756 | 4 | 1.186 | 24246.2 |
665 | 2024-04-02 22:46:53 | cisco | 3 | 83667 | 502 | 14.080 | 5942.3 |
664 | 2024-04-02 22:46:53 | cisco | 2 | 53800 | 29 | 5.170 | 10406.2 |
663 | 2024-04-02 21:02:06 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
662 | 2024-03-31 15:22:32 | cisco | 1 | 28756 | 4 | 0.563 | 51076.4 |
661 | 2024-03-29 08:55:54 | cisco | 2 | 53800 | 29 | 1.343 | 40059.6 |
660 | 2024-03-29 08:55:53 | cisco | 1 | 28756 | 4 | 0.466 | 61708.2 |
659 | 2024-03-29 08:55:37 | cisco | 3 | 83667 | 502 | 3.953 | 21165.4 |
658 | 2024-03-29 08:28:20 | cisco | 3 | 83667 | 502 | 7.563 | 11062.7 |
657 | 2024-03-29 08:28:07 | cisco | 2 | 53800 | 29 | 5.563 | 9671.0 |
656 | 2024-03-29 08:18:22 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
655 | 2024-03-02 18:02:14 | cisco | 3 | 83667 | 502 | 9.953 | 8406.2 |
654 | 2024-03-02 18:02:12 | cisco | 2 | 53800 | 29 | 6.783 | 7931.6 |
653 | 2024-03-02 17:53:13 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
652 | 2024-03-01 12:53:24 | cisco | 1 | 28756 | 4 | 0.440 | 65354.5 |
651 | 2024-02-28 02:28:32 | cisco | 1 | 28756 | 4 | 0.546 | 52666.7 |
650 | 2024-01-29 07:37:31 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
649 | 2024-01-28 23:04:01 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
648 | 2024-01-02 10:06:18 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
647 | 2023-12-31 22:30:04 | cisco | 3 | 83667 | 502 | 3.830 | 21845.2 |
646 | 2023-12-31 22:30:02 | cisco | 2 | 53800 | 29 | 1.703 | 31591.3 |
645 | 2023-12-31 18:02:42 | cisco | 3 | 83667 | 502 | 4.060 | 20607.6 |
644 | 2023-12-31 18:02:43 | cisco | 2 | 53800 | 29 | 1.686 | 31909.8 |
643 | 2023-12-14 20:52:14 | cisco | 2 | 53800 | 29 | 1.643 | 32745.0 |
642 | 2023-12-08 07:33:48 | cisco | 1 | 28756 | 4 | 0.470 | 61183.0 |
641 | 2023-11-14 20:38:31 | cisco | 3 | 83667 | 502 | 3.640 | 22985.4 |
640 | 2023-11-14 20:38:33 | cisco | 2 | 53800 | 29 | 1.596 | 33709.3 |
639 | 2023-11-13 23:44:04 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
638 | 2023-11-13 13:39:56 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
637 | 2023-11-04 04:24:24 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
636 | 2023-10-24 02:52:28 | cisco | 1 | 28756 | 4 | 0.580 | 49579.3 |
635 | 2023-10-21 10:11:14 | cisco | 1 | 28756 | 4 | 0.486 | 59168.7 |
634 | 2023-10-18 11:55:19 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
633 | 2023-10-13 14:49:20 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
632 | 2023-10-05 02:57:21 | cisco | 1 | 28756 | 4 | 0.486 | 59168.7 |
631 | 2023-09-28 06:48:09 | cisco | 1 | 28756 | 4 | 0.513 | 56054.6 |
630 | 2023-09-13 04:48:20 | cisco | 2 | 53800 | 29 | 1.546 | 34799.5 |
629 | 2023-09-12 02:02:10 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
628 | 2023-08-20 09:37:50 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
627 | 2023-08-12 12:28:12 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
626 | 2023-05-31 21:06:07 | cisco | 2 | 53800 | 29 | 1.356 | 39675.5 |
625 | 2023-05-22 16:22:39 | cisco | 1 | 28756 | 4 | 0.420 | 68466.7 |
624 | 2023-05-01 06:49:04 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
623 | 2023-03-17 23:58:09 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
622 | 2023-03-09 14:25:13 | cisco | 2 | 53800 | 29 | 1.360 | 39558.8 |
621 | 2023-01-22 19:08:50 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
620 | 2023-01-05 22:38:08 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
619 | 2022-12-13 10:19:39 | cisco | 2 | 53800 | 29 | 1.576 | 34137.1 |
618 | 2022-11-25 06:36:54 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
617 | 2022-09-28 12:47:58 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
616 | 2022-06-30 20:54:10 | cisco | 2 | 53800 | 29 | 1.356 | 39675.5 |
615 | 2022-06-29 09:50:57 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
614 | 2022-06-28 17:20:54 | cisco | 2 | 53800 | 29 | 1.450 | 37103.4 |
613 | 2022-06-06 19:28:56 | cisco | 1 | 28756 | 4 | 0.440 | 65354.5 |
612 | 2022-05-30 07:12:21 | cisco | 1 | 28756 | 4 | 0.420 | 68466.7 |
611 | 2022-05-18 14:08:41 | cisco | 1 | 28756 | 4 | 0.466 | 61708.2 |
610 | 2022-05-10 02:59:17 | cisco | 1 | 28756 | 4 | 0.530 | 54256.6 |
609 | 2022-04-30 23:58:59 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
608 | 2022-04-11 18:33:24 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
607 | 2022-03-09 08:12:11 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
606 | 2022-02-10 00:50:20 | cisco | 2 | 53800 | 29 | 1.673 | 32157.8 |
605 | 2022-01-24 18:07:17 | cisco | 1 | 28756 | 4 | 0.470 | 61183.0 |
604 | 2022-01-22 14:43:51 | cisco | 1 | 28756 | 4 | 0.513 | 56054.6 |
603 | 2021-12-06 22:04:32 | cisco | 1 | 28756 | 4 | 0.516 | 55728.7 |
602 | 2021-11-27 11:48:01 | cisco | 2 | 53800 | 29 | 3.076 | 17490.2 |
601 | 2021-11-22 05:23:47 | cisco | 1 | 28756 | 4 | 0.890 | 32310.1 |
600 | 2021-11-18 20:17:27 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
599 | 2021-11-16 01:40:06 | cisco | 1 | 28756 | 4 | 0.450 | 63902.2 |
598 | 2021-10-27 14:49:59 | cisco | 1 | 28756 | 4 | 0.716 | 40162.0 |
597 | 2021-09-27 11:09:07 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
596 | 2021-09-10 08:45:03 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
595 | 2021-08-16 01:17:44 | cisco | 1 | 28756 | 4 | 0.470 | 61183.0 |
594 | 2021-07-24 07:49:03 | cisco | 1 | 28756 | 4 | 0.470 | 61183.0 |
593 | 2021-06-26 07:35:07 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
592 | 2021-05-14 08:43:15 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
591 | 2021-05-11 23:58:58 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
590 | 2021-04-13 09:22:51 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
589 | 2021-04-07 15:01:30 | cisco | 1 | 28756 | 4 | 0.530 | 54256.6 |
588 | 2021-02-23 15:26:24 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
587 | 2021-02-07 14:17:37 | cisco | 1 | 28756 | 4 | 0.440 | 65354.5 |
586 | 2021-01-14 11:19:03 | cisco | 3 | 83667 | 502 | 3.516 | 23796.1 |
585 | 2020-12-29 06:36:37 | cisco | 1 | 28756 | 4 | 0.560 | 51350.0 |
584 | 2020-11-27 12:00:59 | cisco | 1 | 28756 | 4 | 0.436 | 65954.1 |
583 | 2020-11-11 02:41:36 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
582 | 2020-11-09 23:27:04 | cisco | 3 | 83667 | 502 | 3.360 | 24900.9 |
581 | 2020-11-05 19:57:56 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
580 | 2020-11-02 05:28:34 | cisco | 3 | 83667 | 502 | 4.436 | 18860.9 |
579 | 2020-10-26 18:49:33 | cisco | 3 | 83667 | 502 | 3.360 | 24900.9 |
578 | 2020-09-22 01:18:50 | cisco | 1 | 28756 | 4 | 0.440 | 65354.5 |
577 | 2020-09-16 14:21:22 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
576 | 2020-08-09 14:16:06 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
575 | 2020-08-06 07:15:45 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |
574 | 2020-08-04 23:59:04 | cisco | 1 | 28756 | 4 | 0.546 | 52666.7 |
573 | 2020-08-04 11:25:09 | cisco | 1 | 28756 | 4 | 0.500 | 57512.0 |
572 | 2020-08-01 18:39:58 | cisco | 1 | 28756 | 4 | 0.483 | 59536.2 |
571 | 2020-08-01 18:10:06 | cisco | 1 | 28756 | 4 | 0.453 | 63479.0 |