History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jones"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
660 | 2024-04-27 06:44:36 | jones | 1 | 28756 | 14 | 1.860 | 15460.2 |
659 | 2024-04-24 17:04:12 | jones | 1 | 28756 | 14 | 0.530 | 54256.6 |
658 | 2024-04-24 17:03:39 | jones | 1 | 28756 | 14 | 1.080 | 26625.9 |
657 | 2024-04-23 13:23:25 | jones | 1 | 28756 | 14 | 1.123 | 25606.4 |
656 | 2024-04-23 00:01:36 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
655 | 2024-04-14 09:37:58 | jones | 2 | 53800 | 333 | 7.110 | 7566.8 |
654 | 2024-04-03 02:29:35 | jones | 1 | 28756 | 14 | 1.466 | 19615.3 |
653 | 2024-03-31 01:15:03 | jones | 1 | 28756 | 14 | 1.640 | 17534.1 |
652 | 2024-03-28 23:47:18 | jones | 2 | 53800 | 333 | 3.610 | 14903.0 |
651 | 2024-03-28 23:19:18 | jones | 1 | 28756 | 14 | 0.486 | 59168.7 |
650 | 2024-03-04 04:04:40 | jones | 2 | 53800 | 333 | 5.593 | 9619.2 |
649 | 2024-03-03 23:03:49 | jones | 2 | 53800 | 333 | 5.546 | 9700.7 |
648 | 2024-03-03 22:34:05 | jones | 1 | 28756 | 14 | 1.063 | 27051.7 |
647 | 2024-03-01 10:44:02 | jones | 1 | 28756 | 14 | 1.830 | 15713.7 |
646 | 2024-02-27 22:55:31 | jones | 2 | 53800 | 333 | 3.610 | 14903.0 |
645 | 2024-02-27 20:43:46 | jones | 1 | 28756 | 14 | 0.983 | 29253.3 |
644 | 2024-02-18 13:49:53 | jones | 1 | 28756 | 14 | 0.500 | 57512.0 |
643 | 2024-01-28 18:15:25 | jones | 1 | 28756 | 14 | 0.420 | 68466.7 |
642 | 2024-01-10 00:52:58 | jones | 1 | 28756 | 14 | 0.500 | 57512.0 |
641 | 2023-12-28 22:24:33 | jones | 2 | 53800 | 333 | 3.470 | 15504.3 |
640 | 2023-12-07 07:55:38 | jones | 2 | 53800 | 333 | 1.346 | 39970.3 |
639 | 2023-12-06 23:39:44 | jones | 1 | 28756 | 14 | 0.486 | 59168.7 |
638 | 2023-12-06 23:39:43 | jones | 1 | 28756 | 14 | 0.486 | 59168.7 |
637 | 2023-11-18 01:13:29 | jones | 1 | 28756 | 14 | 0.513 | 56054.6 |
636 | 2023-11-16 13:46:31 | jones | 1 | 28756 | 14 | 0.483 | 59536.2 |
635 | 2023-11-10 15:40:49 | jones | 1 | 28756 | 14 | 0.530 | 54256.6 |
634 | 2023-11-03 04:41:34 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
633 | 2023-10-30 21:41:17 | jones | 1 | 28756 | 14 | 0.420 | 68466.7 |
632 | 2023-10-30 08:53:31 | jones | 2 | 53800 | 333 | 1.626 | 33087.3 |
631 | 2023-10-19 23:27:21 | jones | 2 | 53800 | 333 | 1.626 | 33087.3 |
630 | 2023-10-19 22:01:45 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
629 | 2023-10-16 21:18:10 | jones | 1 | 28756 | 14 | 0.483 | 59536.2 |
628 | 2023-10-12 02:42:12 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
627 | 2023-10-07 16:35:44 | jones | 1 | 28756 | 14 | 0.440 | 65354.5 |
626 | 2023-09-26 22:44:56 | jones | 1 | 28756 | 14 | 0.513 | 56054.6 |
625 | 2023-08-24 23:02:28 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
624 | 2023-08-03 03:55:14 | jones | 1 | 28756 | 14 | 0.516 | 55728.7 |
623 | 2023-05-26 07:48:27 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
622 | 2023-04-25 16:56:18 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
621 | 2023-03-23 00:02:15 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
620 | 2023-01-09 14:38:46 | jones | 1 | 28756 | 14 | 0.440 | 65354.5 |
619 | 2023-01-09 03:38:18 | jones | 1 | 28756 | 14 | 0.420 | 68466.7 |
618 | 2022-10-07 07:18:57 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
617 | 2022-09-25 19:22:40 | jones | 1 | 28756 | 14 | 0.440 | 65354.5 |
616 | 2022-09-17 20:30:57 | jones | 1 | 28756 | 14 | 0.483 | 59536.2 |
615 | 2022-09-12 12:12:47 | jones | 1 | 28756 | 14 | 0.466 | 61708.2 |
614 | 2022-09-10 15:59:10 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
613 | 2022-08-14 04:55:42 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
612 | 2022-08-08 01:48:21 | jones | 2 | 53800 | 333 | 1.390 | 38705.0 |
611 | 2022-08-07 04:23:19 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
610 | 2022-07-30 04:55:30 | jones | 1 | 28756 | 14 | 0.546 | 52666.7 |
609 | 2022-07-17 23:17:27 | jones | 1 | 28756 | 14 | 0.423 | 67981.1 |
608 | 2022-07-15 11:05:02 | jones | 2 | 53800 | 333 | 1.360 | 39558.8 |
607 | 2022-07-03 11:48:43 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
606 | 2022-06-24 20:32:54 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
605 | 2022-06-16 11:48:12 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
604 | 2022-06-16 02:37:30 | jones | 1 | 28756 | 14 | 0.440 | 65354.5 |
603 | 2022-06-13 22:55:12 | jones | 1 | 28756 | 14 | 0.423 | 67981.1 |
602 | 2022-05-26 03:42:16 | jones | 1 | 28756 | 14 | 0.423 | 67981.1 |
601 | 2022-05-24 12:50:06 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
600 | 2022-04-23 18:57:06 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
599 | 2022-03-04 04:00:12 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
598 | 2022-02-28 18:05:15 | jones | 1 | 28756 | 14 | 0.656 | 43835.4 |
597 | 2022-01-13 00:40:57 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
596 | 2021-11-23 22:50:09 | jones | 1 | 28756 | 14 | 0.500 | 57512.0 |
595 | 2021-11-15 05:25:34 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
594 | 2021-10-02 22:35:05 | jones | 1 | 28756 | 14 | 0.440 | 65354.5 |
593 | 2021-09-30 19:42:50 | jones | 1 | 28756 | 14 | 0.423 | 67981.1 |
592 | 2021-09-11 13:34:22 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
591 | 2021-08-24 08:24:48 | jones | 1 | 28756 | 14 | 0.423 | 67981.1 |
590 | 2021-08-20 21:50:22 | jones | 1 | 28756 | 14 | 0.516 | 55728.7 |
589 | 2021-05-21 15:50:27 | jones | 1 | 28756 | 14 | 0.986 | 29164.3 |
588 | 2021-05-20 07:26:08 | jones | 1 | 28756 | 14 | 0.440 | 65354.5 |
587 | 2021-05-19 16:50:45 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
586 | 2021-03-16 01:34:54 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
585 | 2021-02-17 15:38:24 | jones | 1 | 28756 | 14 | 0.420 | 68466.7 |
584 | 2021-02-04 07:31:35 | jones | 1 | 28756 | 14 | 0.500 | 57512.0 |
583 | 2021-02-02 23:28:42 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
582 | 2021-02-02 08:47:10 | jones | 1 | 28756 | 14 | 0.686 | 41918.4 |
581 | 2020-12-09 08:27:52 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
580 | 2020-11-18 23:17:18 | jones | 1 | 28756 | 14 | 0.470 | 61183.0 |
579 | 2020-11-13 09:52:23 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
578 | 2020-11-07 14:23:52 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
577 | 2020-11-01 17:22:48 | jones | 1 | 28756 | 14 | 0.516 | 55728.7 |
576 | 2020-10-29 13:12:47 | jones | 1 | 28756 | 14 | 0.500 | 57512.0 |
575 | 2020-09-27 21:13:08 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
574 | 2020-09-05 03:07:39 | jones | 1 | 28756 | 14 | 0.423 | 67981.1 |
573 | 2020-08-09 11:13:17 | jones | 1 | 28756 | 14 | 0.483 | 59536.2 |
572 | 2020-07-27 12:29:58 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
571 | 2020-07-26 00:38:32 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
570 | 2020-07-25 07:20:58 | jones | 1 | 28756 | 14 | 0.466 | 61708.2 |
569 | 2020-07-24 09:32:21 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
568 | 2020-07-20 09:41:05 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
567 | 2020-07-19 09:50:24 | jones | 1 | 28756 | 14 | 0.466 | 61708.2 |
566 | 2020-06-07 12:58:11 | jones | 1 | 28756 | 14 | 0.530 | 54256.6 |
565 | 2020-06-06 13:38:57 | jones | 1 | 28756 | 14 | 0.453 | 63479.0 |
564 | 2020-06-05 13:02:11 | jones | 1 | 28756 | 14 | 0.533 | 53951.2 |
563 | 2020-06-04 13:01:57 | jones | 1 | 28756 | 14 | 0.436 | 65954.1 |
562 | 2020-06-03 13:00:18 | jones | 1 | 28756 | 14 | 0.486 | 59168.7 |
561 | 2020-05-15 04:36:53 | jones | 1 | 28756 | 14 | 0.486 | 59168.7 |