History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jokes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
645 | 2024-04-27 13:10:40 | jokes | 1 | 28756 | 19 | 0.686 | 41918.4 |
644 | 2024-04-20 16:58:13 | jokes | 1 | 28756 | 19 | 1.703 | 16885.5 |
643 | 2024-04-03 02:16:52 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
642 | 2024-04-01 17:55:28 | jokes | 1 | 28756 | 19 | 0.546 | 52666.7 |
641 | 2024-03-31 03:16:52 | jokes | 1 | 28756 | 19 | 1.280 | 22465.6 |
640 | 2024-03-29 02:48:41 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
639 | 2024-03-29 02:48:34 | jokes | 2 | 53800 | 242 | 3.266 | 16472.7 |
638 | 2024-03-29 00:01:54 | jokes | 2 | 53800 | 242 | 3.563 | 15099.6 |
637 | 2024-03-28 23:04:18 | jokes | 1 | 28756 | 19 | 0.516 | 55728.7 |
636 | 2024-03-28 06:10:13 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
635 | 2024-03-04 00:12:58 | jokes | 1 | 28756 | 19 | 1.610 | 17860.9 |
634 | 2024-03-02 14:29:07 | jokes | 2 | 53800 | 242 | 6.220 | 8649.5 |
633 | 2024-03-02 14:28:54 | jokes | 1 | 28756 | 19 | 0.950 | 30269.5 |
632 | 2024-02-28 18:23:56 | jokes | 2 | 53800 | 242 | 2.593 | 20748.2 |
631 | 2024-02-27 19:34:33 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
630 | 2024-02-27 18:52:44 | jokes | 2 | 53800 | 242 | 1.516 | 35488.1 |
629 | 2024-02-27 18:43:31 | jokes | 2 | 53800 | 242 | 1.500 | 35866.7 |
628 | 2024-02-22 15:40:03 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
627 | 2024-02-21 21:28:28 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
626 | 2024-02-20 13:20:06 | jokes | 1 | 28756 | 19 | 1.576 | 18246.2 |
625 | 2024-02-19 15:39:21 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
624 | 2024-02-18 21:13:54 | jokes | 1 | 28756 | 19 | 1.420 | 20250.7 |
623 | 2024-01-30 20:11:05 | jokes | 1 | 28756 | 19 | 0.486 | 59168.7 |
622 | 2024-01-12 02:13:01 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
621 | 2023-12-27 03:42:17 | jokes | 2 | 53800 | 242 | 1.470 | 36598.6 |
620 | 2023-12-08 08:48:26 | jokes | 1 | 28756 | 19 | 0.516 | 55728.7 |
619 | 2023-12-08 08:48:25 | jokes | 1 | 28756 | 19 | 0.796 | 36125.6 |
618 | 2023-12-01 23:43:03 | jokes | 2 | 53800 | 242 | 1.356 | 39675.5 |
617 | 2023-11-26 21:49:34 | jokes | 2 | 53800 | 242 | 1.610 | 33416.1 |
616 | 2023-11-25 11:18:26 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
615 | 2023-11-21 10:55:00 | jokes | 2 | 53800 | 242 | 1.420 | 37887.3 |
614 | 2023-11-12 22:48:21 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
613 | 2023-11-10 01:50:20 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
612 | 2023-11-04 09:36:15 | jokes | 1 | 28756 | 19 | 0.470 | 61183.0 |
611 | 2023-11-01 07:59:54 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
610 | 2023-10-22 05:37:27 | jokes | 1 | 28756 | 19 | 0.470 | 61183.0 |
609 | 2023-10-18 00:22:37 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
608 | 2023-10-12 02:33:49 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
607 | 2023-10-07 16:35:33 | jokes | 1 | 28756 | 19 | 0.486 | 59168.7 |
606 | 2023-09-28 09:10:55 | jokes | 1 | 28756 | 19 | 0.440 | 65354.5 |
605 | 2023-09-22 10:06:30 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
604 | 2023-09-14 03:38:48 | jokes | 1 | 28756 | 19 | 0.440 | 65354.5 |
603 | 2023-09-11 04:46:24 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
602 | 2023-08-21 18:04:56 | jokes | 2 | 53800 | 242 | 1.343 | 40059.6 |
601 | 2023-06-16 21:24:02 | jokes | 1 | 28756 | 19 | 0.486 | 59168.7 |
600 | 2023-06-05 07:29:14 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
599 | 2023-05-03 07:35:51 | jokes | 2 | 53800 | 242 | 1.483 | 36277.8 |
598 | 2023-04-01 02:03:17 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
597 | 2023-02-27 05:31:38 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
596 | 2023-02-23 19:50:20 | jokes | 1 | 28756 | 19 | 0.470 | 61183.0 |
595 | 2023-02-08 06:02:52 | jokes | 2 | 53800 | 242 | 1.330 | 40451.1 |
594 | 2023-01-16 10:33:24 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
593 | 2022-11-20 04:15:35 | jokes | 2 | 53800 | 242 | 1.330 | 40451.1 |
592 | 2022-11-13 19:08:37 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
591 | 2022-11-06 23:02:46 | jokes | 1 | 28756 | 19 | 0.466 | 61708.2 |
590 | 2022-09-12 05:08:08 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
589 | 2022-09-10 15:37:17 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
588 | 2022-08-07 23:18:59 | jokes | 2 | 53800 | 242 | 1.623 | 33148.5 |
587 | 2022-08-06 21:53:27 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
586 | 2022-07-21 04:24:00 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
585 | 2022-07-17 23:11:15 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
584 | 2022-07-17 10:44:04 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
583 | 2022-07-03 19:45:29 | jokes | 1 | 28756 | 19 | 0.453 | 63479.0 |
582 | 2022-07-03 08:37:42 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
581 | 2022-06-25 20:10:33 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
580 | 2022-06-16 08:36:27 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
579 | 2022-06-08 22:29:09 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
578 | 2022-06-08 19:03:35 | jokes | 1 | 28756 | 19 | 0.453 | 63479.0 |
577 | 2022-06-01 21:05:45 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
576 | 2022-05-18 18:22:35 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
575 | 2022-05-18 02:03:44 | jokes | 1 | 28756 | 19 | 0.483 | 59536.2 |
574 | 2022-05-17 11:43:07 | jokes | 1 | 28756 | 19 | 0.593 | 48492.4 |
573 | 2022-05-16 17:26:47 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
572 | 2022-05-15 22:54:40 | jokes | 1 | 28756 | 19 | 0.576 | 49923.6 |
571 | 2022-05-14 15:43:58 | jokes | 2 | 53800 | 242 | 1.500 | 35866.7 |
570 | 2022-05-14 05:22:11 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
569 | 2022-05-13 16:04:24 | jokes | 1 | 28756 | 19 | 0.656 | 43835.4 |
568 | 2022-05-13 04:20:16 | jokes | 1 | 28756 | 19 | 0.453 | 63479.0 |
567 | 2022-05-12 18:22:42 | jokes | 1 | 28756 | 19 | 0.563 | 51076.4 |
566 | 2022-05-11 19:00:16 | jokes | 1 | 28756 | 19 | 0.576 | 49923.6 |
565 | 2022-05-11 07:20:20 | jokes | 1 | 28756 | 19 | 0.453 | 63479.0 |
564 | 2022-05-10 20:42:50 | jokes | 1 | 28756 | 19 | 1.060 | 27128.3 |
563 | 2022-05-10 01:19:51 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
562 | 2022-05-08 14:10:59 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
561 | 2022-05-08 01:23:23 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
560 | 2022-05-07 15:23:09 | jokes | 1 | 28756 | 19 | 0.440 | 65354.5 |
559 | 2022-05-02 00:27:30 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
558 | 2022-05-01 10:18:39 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
557 | 2022-04-30 19:39:56 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
556 | 2022-04-30 10:57:26 | jokes | 1 | 28756 | 19 | 0.420 | 68466.7 |
555 | 2022-04-29 13:29:13 | jokes | 1 | 28756 | 19 | 0.546 | 52666.7 |
554 | 2022-04-29 01:47:46 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
553 | 2022-04-28 15:44:47 | jokes | 1 | 28756 | 19 | 0.530 | 54256.6 |
552 | 2022-04-12 19:57:04 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
551 | 2022-04-11 18:01:13 | jokes | 1 | 28756 | 19 | 0.673 | 42728.1 |
550 | 2022-04-10 18:09:54 | jokes | 1 | 28756 | 19 | 0.436 | 65954.1 |
549 | 2022-04-09 23:18:25 | jokes | 1 | 28756 | 19 | 0.500 | 57512.0 |
548 | 2022-04-02 21:13:00 | jokes | 1 | 28756 | 19 | 0.423 | 67981.1 |
547 | 2022-03-31 08:56:48 | jokes | 1 | 28756 | 19 | 0.673 | 42728.1 |
546 | 2022-03-30 13:22:44 | jokes | 1 | 28756 | 19 | 0.576 | 49923.6 |