History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"users"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
642 | 2024-05-01 01:43:04 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
641 | 2024-04-30 04:15:17 | users | 1 | 28756 | 7 | 1.203 | 23903.6 |
640 | 2024-04-29 06:34:12 | users | 1 | 28756 | 7 | 0.546 | 52666.7 |
639 | 2024-04-28 00:16:32 | users | 1 | 28756 | 7 | 1.126 | 25538.2 |
638 | 2024-04-26 06:25:47 | users | 1 | 28756 | 7 | 0.546 | 52666.7 |
637 | 2024-04-03 10:50:12 | users | 2 | 53800 | 155 | 5.533 | 9723.5 |
636 | 2024-04-03 10:49:43 | users | 1 | 28756 | 7 | 1.670 | 17219.2 |
635 | 2024-03-31 07:56:18 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
634 | 2024-03-04 09:33:46 | users | 2 | 53800 | 155 | 2.830 | 19010.6 |
633 | 2024-03-04 09:33:42 | users | 1 | 28756 | 7 | 1.093 | 26309.2 |
632 | 2024-03-04 09:33:26 | users | 2 | 53800 | 155 | 1.826 | 29463.3 |
631 | 2024-03-04 06:41:42 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
630 | 2024-02-25 22:57:20 | users | 2 | 53800 | 155 | 3.766 | 14285.7 |
629 | 2024-02-25 22:57:10 | users | 1 | 28756 | 7 | 1.170 | 24577.8 |
628 | 2024-02-12 05:59:34 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
627 | 2024-02-03 04:57:08 | users | 2 | 53800 | 155 | 3.593 | 14973.6 |
626 | 2024-02-03 04:49:07 | users | 1 | 28756 | 7 | 0.533 | 53951.2 |
625 | 2024-01-29 07:46:51 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
624 | 2024-01-26 20:34:57 | users | 1 | 28756 | 7 | 0.470 | 61183.0 |
623 | 2024-01-07 16:35:53 | users | 1 | 28756 | 7 | 0.486 | 59168.7 |
622 | 2024-01-07 09:36:35 | users | 2 | 53800 | 155 | 1.356 | 39675.5 |
621 | 2023-12-20 18:04:28 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
620 | 2023-12-07 21:50:43 | users | 1 | 28756 | 7 | 0.500 | 57512.0 |
619 | 2023-12-07 21:50:42 | users | 1 | 28756 | 7 | 0.533 | 53951.2 |
618 | 2023-12-03 07:25:28 | users | 2 | 53800 | 155 | 1.530 | 35163.4 |
617 | 2023-11-21 05:34:08 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
616 | 2023-11-15 09:00:38 | users | 1 | 28756 | 7 | 0.423 | 67981.1 |
615 | 2023-11-09 08:41:54 | users | 1 | 28756 | 7 | 0.500 | 57512.0 |
614 | 2023-10-31 23:53:08 | users | 1 | 28756 | 7 | 0.486 | 59168.7 |
613 | 2023-10-27 01:23:32 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
612 | 2023-10-22 09:47:46 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
611 | 2023-10-18 02:13:54 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
610 | 2023-10-17 04:26:11 | users | 1 | 28756 | 7 | 0.953 | 30174.2 |
609 | 2023-10-08 07:48:49 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
608 | 2023-10-06 14:25:04 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
607 | 2023-09-24 08:03:01 | users | 1 | 28756 | 7 | 0.470 | 61183.0 |
606 | 2023-09-22 10:23:02 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
605 | 2023-08-24 16:38:23 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
604 | 2023-06-09 20:43:47 | users | 1 | 28756 | 7 | 0.440 | 65354.5 |
603 | 2023-05-27 16:00:18 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
602 | 2023-03-22 07:27:48 | users | 1 | 28756 | 7 | 0.470 | 61183.0 |
601 | 2023-02-07 23:41:01 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
600 | 2023-01-07 10:20:18 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
599 | 2022-10-13 00:02:13 | users | 1 | 28756 | 7 | 0.440 | 65354.5 |
598 | 2022-10-06 20:42:57 | users | 1 | 28756 | 7 | 0.470 | 61183.0 |
597 | 2022-10-03 06:37:04 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
596 | 2022-09-20 01:06:12 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
595 | 2022-09-18 17:24:52 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
594 | 2022-08-14 11:59:37 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
593 | 2022-08-14 06:40:13 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
592 | 2022-08-07 05:52:09 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
591 | 2022-07-17 22:43:58 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
590 | 2022-06-05 10:35:46 | users | 1 | 28756 | 7 | 0.420 | 68466.7 |
589 | 2022-06-02 03:59:07 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
588 | 2022-06-02 03:58:00 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
587 | 2022-02-09 23:02:29 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
586 | 2022-01-28 18:48:50 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
585 | 2021-12-03 15:40:36 | users | 1 | 28756 | 7 | 0.486 | 59168.7 |
584 | 2021-11-22 01:22:54 | users | 1 | 28756 | 7 | 0.440 | 65354.5 |
583 | 2021-11-11 07:56:23 | users | 1 | 28756 | 7 | 0.513 | 56054.6 |
582 | 2021-10-19 06:24:33 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
581 | 2021-10-05 15:08:24 | users | 1 | 28756 | 7 | 0.516 | 55728.7 |
580 | 2021-09-24 04:42:50 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
579 | 2021-07-06 17:47:12 | users | 1 | 28756 | 7 | 0.516 | 55728.7 |
578 | 2021-07-03 04:34:19 | users | 1 | 28756 | 7 | 0.500 | 57512.0 |
577 | 2021-06-01 02:35:46 | users | 1 | 28756 | 7 | 0.750 | 38341.3 |
576 | 2021-05-06 21:00:52 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
575 | 2021-04-05 03:06:09 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
574 | 2021-03-29 09:40:17 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
573 | 2021-03-25 01:17:13 | users | 1 | 28756 | 7 | 0.470 | 61183.0 |
572 | 2021-02-22 21:32:49 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
571 | 2021-02-13 07:26:35 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
570 | 2021-01-20 09:02:24 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
569 | 2020-12-21 16:36:17 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
568 | 2020-11-05 07:28:36 | users | 1 | 28756 | 7 | 0.440 | 65354.5 |
567 | 2020-10-22 06:24:10 | users | 1 | 28756 | 7 | 0.966 | 29768.1 |
566 | 2020-10-17 22:38:53 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
565 | 2020-10-05 17:39:22 | users | 1 | 28756 | 7 | 0.513 | 56054.6 |
564 | 2020-09-21 12:55:59 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
563 | 2020-09-07 01:03:20 | users | 1 | 28756 | 7 | 0.953 | 30174.2 |
562 | 2020-09-02 05:32:20 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
561 | 2020-08-05 03:55:10 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
560 | 2020-08-04 13:48:51 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
559 | 2020-08-02 04:22:05 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
558 | 2020-08-01 08:55:49 | users | 1 | 28756 | 7 | 0.500 | 57512.0 |
557 | 2020-06-10 19:57:52 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
556 | 2020-03-31 05:18:49 | users | 1 | 28756 | 7 | 0.453 | 63479.0 |
555 | 2020-03-27 05:15:54 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
554 | 2020-03-26 22:58:20 | users | 1 | 28756 | 7 | 0.640 | 44931.3 |
553 | 2020-03-26 14:33:17 | users | 1 | 28756 | 7 | 0.466 | 61708.2 |
552 | 2020-03-23 06:45:23 | users | 1 | 28756 | 7 | 0.530 | 54256.6 |
551 | 2020-03-21 03:13:25 | users | 1 | 28756 | 7 | 0.423 | 67981.1 |
550 | 2020-03-18 15:11:59 | users | 1 | 28756 | 7 | 0.436 | 65954.1 |
549 | 2020-03-09 05:57:29 | users | 1 | 28756 | 7 | 0.546 | 52666.7 |
548 | 2020-02-26 19:09:54 | users | 1 | 28756 | 7 | 0.483 | 59536.2 |
547 | 2020-02-25 14:44:27 | users | 1 | 28756 | 7 | 0.516 | 55728.7 |
546 | 2020-02-25 12:13:47 | users | 1 | 28756 | 7 | 0.500 | 57512.0 |
545 | 2020-02-24 20:23:58 | users | 1 | 28756 | 7 | 1.030 | 27918.4 |
544 | 2020-02-19 23:14:17 | users | 1 | 28756 | 7 | 1.013 | 28387.0 |
543 | 2020-02-15 06:47:13 | users | 2 | 53800 | 155 | 2.550 | 21098.0 |