History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sayer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
649 | 2024-04-24 23:42:45 | sayer | 1 | 28756 | 20 | 0.530 | 54256.6 |
648 | 2024-04-02 21:58:47 | sayer | 1 | 28756 | 20 | 0.563 | 51076.4 |
647 | 2024-03-31 03:57:09 | sayer | 1 | 28756 | 20 | 0.546 | 52666.7 |
646 | 2024-03-30 19:46:18 | sayer | 2 | 53800 | 279 | 4.753 | 11319.2 |
645 | 2024-03-30 04:41:20 | sayer | 2 | 53800 | 279 | 4.703 | 11439.5 |
644 | 2024-03-29 02:16:00 | sayer | 2 | 53800 | 279 | 3.796 | 14172.8 |
643 | 2024-03-29 01:26:25 | sayer | 2 | 53800 | 279 | 5.313 | 10126.1 |
642 | 2024-03-29 01:10:14 | sayer | 1 | 28756 | 20 | 0.983 | 29253.3 |
641 | 2024-03-12 10:03:54 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
640 | 2024-03-05 14:59:43 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
639 | 2024-03-03 23:17:22 | sayer | 2 | 53800 | 279 | 5.860 | 9180.9 |
638 | 2024-03-03 22:22:03 | sayer | 1 | 28756 | 20 | 0.563 | 51076.4 |
637 | 2024-02-28 00:09:20 | sayer | 2 | 53800 | 279 | 1.750 | 30742.9 |
636 | 2024-02-27 22:15:13 | sayer | 2 | 53800 | 279 | 1.563 | 34421.0 |
635 | 2024-02-27 21:01:14 | sayer | 1 | 28756 | 20 | 0.546 | 52666.7 |
634 | 2024-02-11 11:29:14 | sayer | 1 | 28756 | 20 | 2.343 | 12273.2 |
633 | 2024-01-28 18:57:49 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
632 | 2024-01-16 00:29:23 | sayer | 1 | 28756 | 20 | 0.610 | 47141.0 |
631 | 2024-01-15 10:31:50 | sayer | 1 | 28756 | 20 | 0.530 | 54256.6 |
630 | 2024-01-01 05:16:18 | sayer | 2 | 53800 | 279 | 1.436 | 37465.2 |
629 | 2023-12-12 11:42:18 | sayer | 1 | 28756 | 20 | 0.483 | 59536.2 |
628 | 2023-11-20 16:03:24 | sayer | 2 | 53800 | 279 | 2.516 | 21383.1 |
627 | 2023-11-18 07:57:48 | sayer | 1 | 28756 | 20 | 0.466 | 61708.2 |
626 | 2023-11-09 04:19:07 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
625 | 2023-11-03 13:22:12 | sayer | 1 | 28756 | 20 | 0.513 | 56054.6 |
624 | 2023-10-23 22:33:59 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
623 | 2023-10-18 09:55:39 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
622 | 2023-10-17 18:47:58 | sayer | 1 | 28756 | 20 | 0.450 | 63902.2 |
621 | 2023-10-05 21:30:59 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
620 | 2023-10-04 21:16:23 | sayer | 2 | 53800 | 279 | 1.423 | 37807.4 |
619 | 2023-09-29 04:18:05 | sayer | 1 | 28756 | 20 | 0.466 | 61708.2 |
618 | 2023-09-29 00:47:26 | sayer | 1 | 28756 | 20 | 1.016 | 28303.1 |
617 | 2023-09-23 03:33:23 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
616 | 2023-09-18 20:02:00 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
615 | 2023-07-25 18:57:53 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
614 | 2023-07-16 00:34:02 | sayer | 2 | 53800 | 279 | 1.610 | 33416.1 |
613 | 2023-06-01 15:17:44 | sayer | 1 | 28756 | 20 | 0.436 | 65954.1 |
612 | 2023-04-24 05:43:28 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
611 | 2023-04-01 23:11:01 | sayer | 2 | 53800 | 279 | 1.406 | 38264.6 |
610 | 2023-02-16 16:39:41 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
609 | 2023-02-14 14:21:36 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
608 | 2022-12-30 23:43:22 | sayer | 2 | 53800 | 279 | 1.403 | 38346.4 |
607 | 2022-12-12 16:54:49 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
606 | 2022-10-30 13:20:32 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
605 | 2022-09-04 08:35:32 | sayer | 2 | 53800 | 279 | 1.733 | 31044.4 |
604 | 2022-08-19 02:11:25 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
603 | 2022-08-16 15:31:31 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
602 | 2022-07-29 09:40:32 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
601 | 2022-07-08 02:29:51 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
600 | 2022-04-01 01:18:40 | sayer | 1 | 28756 | 20 | 0.483 | 59536.2 |
599 | 2022-03-29 21:12:22 | sayer | 2 | 53800 | 279 | 2.156 | 24953.6 |
598 | 2022-03-22 00:16:07 | sayer | 1 | 28756 | 20 | 0.593 | 48492.4 |
597 | 2022-03-21 03:09:42 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
596 | 2022-03-20 09:32:19 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
595 | 2022-03-15 19:59:19 | sayer | 1 | 28756 | 20 | 0.623 | 46157.3 |
594 | 2022-03-15 02:23:22 | sayer | 1 | 28756 | 20 | 0.530 | 54256.6 |
593 | 2022-03-13 17:51:52 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
592 | 2022-03-12 21:43:52 | sayer | 1 | 28756 | 20 | 0.450 | 63902.2 |
591 | 2022-03-11 14:10:22 | sayer | 1 | 28756 | 20 | 0.500 | 57512.0 |
590 | 2022-03-10 23:45:16 | sayer | 1 | 28756 | 20 | 0.830 | 34645.8 |
589 | 2022-03-09 22:17:14 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
588 | 2022-03-09 11:48:33 | sayer | 1 | 28756 | 20 | 0.563 | 51076.4 |
587 | 2022-03-08 18:16:41 | sayer | 1 | 28756 | 20 | 0.576 | 49923.6 |
586 | 2022-03-07 22:05:45 | sayer | 1 | 28756 | 20 | 0.500 | 57512.0 |
585 | 2022-03-06 20:50:12 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
584 | 2022-03-05 20:39:44 | sayer | 1 | 28756 | 20 | 0.466 | 61708.2 |
583 | 2022-03-04 20:29:32 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
582 | 2022-03-03 14:09:08 | sayer | 1 | 28756 | 20 | 0.546 | 52666.7 |
581 | 2022-02-10 17:18:21 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
580 | 2022-01-02 16:22:09 | sayer | 1 | 28756 | 20 | 0.483 | 59536.2 |
579 | 2021-12-17 10:13:17 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
578 | 2021-12-16 21:32:02 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
577 | 2021-12-16 07:51:52 | sayer | 1 | 28756 | 20 | 1.063 | 27051.7 |
576 | 2021-12-15 18:53:57 | sayer | 1 | 28756 | 20 | 0.560 | 51350.0 |
575 | 2021-12-15 03:50:18 | sayer | 1 | 28756 | 20 | 0.530 | 54256.6 |
574 | 2021-12-14 18:05:53 | sayer | 1 | 28756 | 20 | 0.513 | 56054.6 |
573 | 2021-11-24 14:22:38 | sayer | 1 | 28756 | 20 | 0.500 | 57512.0 |
572 | 2021-11-23 11:39:37 | sayer | 1 | 28756 | 20 | 1.033 | 27837.4 |
571 | 2021-11-22 14:44:46 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
570 | 2021-11-22 10:00:48 | sayer | 1 | 28756 | 20 | 0.533 | 53951.2 |
569 | 2021-11-19 22:45:51 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
568 | 2021-11-15 13:03:47 | sayer | 1 | 28756 | 20 | 0.483 | 59536.2 |
567 | 2021-11-14 12:02:51 | sayer | 1 | 28756 | 20 | 0.530 | 54256.6 |
566 | 2021-11-13 13:59:45 | sayer | 1 | 28756 | 20 | 0.593 | 48492.4 |
565 | 2021-11-12 16:10:25 | sayer | 1 | 28756 | 20 | 0.533 | 53951.2 |
564 | 2021-11-12 07:21:40 | sayer | 1 | 28756 | 20 | 0.530 | 54256.6 |
563 | 2021-11-11 08:55:16 | sayer | 1 | 28756 | 20 | 0.533 | 53951.2 |
562 | 2021-11-09 20:01:34 | sayer | 1 | 28756 | 20 | 0.453 | 63479.0 |
561 | 2021-11-08 09:57:46 | sayer | 1 | 28756 | 20 | 0.500 | 57512.0 |
560 | 2021-11-07 12:50:01 | sayer | 1 | 28756 | 20 | 0.513 | 56054.6 |
559 | 2021-11-07 05:19:24 | sayer | 1 | 28756 | 20 | 1.013 | 28387.0 |
558 | 2021-11-06 22:26:25 | sayer | 1 | 28756 | 20 | 0.500 | 57512.0 |
557 | 2021-11-06 12:21:46 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
556 | 2021-11-06 01:07:04 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
555 | 2021-11-05 19:10:35 | sayer | 1 | 28756 | 20 | 0.516 | 55728.7 |
554 | 2021-11-05 09:01:11 | sayer | 1 | 28756 | 20 | 0.466 | 61708.2 |
553 | 2021-11-05 04:41:59 | sayer | 1 | 28756 | 20 | 1.123 | 25606.4 |
552 | 2021-11-05 01:08:18 | sayer | 1 | 28756 | 20 | 0.513 | 56054.6 |
551 | 2021-11-04 12:49:15 | sayer | 1 | 28756 | 20 | 0.470 | 61183.0 |
550 | 2021-11-03 18:00:57 | sayer | 1 | 28756 | 20 | 1.140 | 25224.6 |