History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roper"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
645 | 2024-04-24 20:51:17 | roper | 2 | 53800 | 276 | 3.843 | 13999.5 |
644 | 2024-04-23 18:50:25 | roper | 2 | 53800 | 276 | 8.546 | 6295.3 |
643 | 2024-04-23 18:48:28 | roper | 2 | 53800 | 276 | 3.766 | 14285.7 |
642 | 2024-04-20 02:08:51 | roper | 1 | 28756 | 22 | 2.263 | 12707.0 |
641 | 2024-04-03 03:53:23 | roper | 1 | 28756 | 22 | 2.546 | 11294.6 |
640 | 2024-04-01 21:09:42 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
639 | 2024-03-31 03:27:50 | roper | 1 | 28756 | 22 | 1.736 | 16564.5 |
638 | 2024-03-28 23:27:03 | roper | 2 | 53800 | 276 | 4.220 | 12748.8 |
637 | 2024-03-28 23:26:53 | roper | 1 | 28756 | 22 | 1.156 | 24875.4 |
636 | 2024-03-28 23:26:41 | roper | 2 | 53800 | 276 | 3.970 | 13551.6 |
635 | 2024-03-28 23:26:18 | roper | 1 | 28756 | 22 | 0.530 | 54256.6 |
634 | 2024-03-03 21:49:38 | roper | 1 | 28756 | 22 | 0.563 | 51076.4 |
633 | 2024-03-01 01:14:40 | roper | 1 | 28756 | 22 | 0.516 | 55728.7 |
632 | 2024-02-27 19:37:01 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
631 | 2024-02-06 22:49:15 | roper | 1 | 28756 | 22 | 1.343 | 21411.8 |
630 | 2024-02-03 03:31:32 | roper | 1 | 28756 | 22 | 0.486 | 59168.7 |
629 | 2024-01-09 09:09:36 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
628 | 2023-12-22 12:46:54 | roper | 1 | 28756 | 22 | 0.450 | 63902.2 |
627 | 2023-12-17 17:24:49 | roper | 2 | 53800 | 276 | 1.640 | 32804.9 |
626 | 2023-11-28 02:57:52 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
625 | 2023-11-27 17:59:59 | roper | 2 | 53800 | 276 | 1.920 | 28020.8 |
624 | 2023-11-26 12:07:14 | roper | 2 | 53800 | 276 | 1.890 | 28465.6 |
623 | 2023-11-21 02:34:08 | roper | 1 | 28756 | 22 | 0.450 | 63902.2 |
622 | 2023-11-11 22:02:11 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
621 | 2023-11-09 20:26:06 | roper | 2 | 53800 | 276 | 1.533 | 35094.6 |
620 | 2023-11-03 23:17:58 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
619 | 2023-11-02 08:43:46 | roper | 2 | 53800 | 276 | 1.873 | 28724.0 |
618 | 2023-11-02 07:35:38 | roper | 1 | 28756 | 22 | 0.530 | 54256.6 |
617 | 2023-10-21 08:59:47 | roper | 1 | 28756 | 22 | 0.486 | 59168.7 |
616 | 2023-10-18 08:01:33 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
615 | 2023-10-13 17:52:34 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
614 | 2023-10-11 19:09:07 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
613 | 2023-10-08 22:15:53 | roper | 1 | 28756 | 22 | 0.466 | 61708.2 |
612 | 2023-10-07 09:52:32 | roper | 1 | 28756 | 22 | 0.546 | 52666.7 |
611 | 2023-09-25 06:27:59 | roper | 1 | 28756 | 22 | 0.466 | 61708.2 |
610 | 2023-09-23 07:32:48 | roper | 2 | 53800 | 276 | 3.140 | 17133.8 |
609 | 2023-09-17 23:15:34 | roper | 2 | 53800 | 276 | 1.420 | 37887.3 |
608 | 2023-09-14 03:46:13 | roper | 1 | 28756 | 22 | 0.513 | 56054.6 |
607 | 2023-08-04 16:04:32 | roper | 1 | 28756 | 22 | 0.486 | 59168.7 |
606 | 2023-06-20 22:17:18 | roper | 2 | 53800 | 276 | 1.406 | 38264.6 |
605 | 2023-06-18 01:26:59 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
604 | 2023-06-14 19:43:58 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
603 | 2023-05-02 02:48:28 | roper | 1 | 28756 | 22 | 0.466 | 61708.2 |
602 | 2023-03-19 01:47:53 | roper | 2 | 53800 | 276 | 1.376 | 39098.8 |
601 | 2023-03-02 10:45:27 | roper | 1 | 28756 | 22 | 0.906 | 31739.5 |
600 | 2023-02-26 20:32:42 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
599 | 2023-02-22 16:36:23 | roper | 1 | 28756 | 22 | 0.440 | 65354.5 |
598 | 2022-12-21 01:54:31 | roper | 2 | 53800 | 276 | 1.423 | 37807.4 |
597 | 2022-12-20 04:02:02 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
596 | 2022-11-10 00:24:03 | roper | 1 | 28756 | 22 | 0.436 | 65954.1 |
595 | 2022-09-20 03:16:43 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
594 | 2022-09-02 06:01:46 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
593 | 2022-08-14 22:09:56 | roper | 1 | 28756 | 22 | 0.466 | 61708.2 |
592 | 2022-08-13 09:20:41 | roper | 2 | 53800 | 276 | 1.423 | 37807.4 |
591 | 2022-07-29 06:21:02 | roper | 1 | 28756 | 22 | 0.440 | 65354.5 |
590 | 2022-07-20 19:12:22 | roper | 1 | 28756 | 22 | 0.456 | 63061.4 |
589 | 2022-07-17 01:58:06 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
588 | 2022-04-15 11:53:16 | roper | 1 | 28756 | 22 | 0.550 | 52283.6 |
587 | 2022-03-19 18:42:14 | roper | 1 | 28756 | 22 | 0.533 | 53951.2 |
586 | 2022-03-14 02:22:38 | roper | 2 | 53800 | 276 | 1.453 | 37026.8 |
585 | 2022-03-11 20:57:03 | roper | 2 | 53800 | 276 | 1.470 | 36598.6 |
584 | 2022-01-15 11:50:33 | roper | 1 | 28756 | 22 | 0.563 | 51076.4 |
583 | 2021-12-05 23:23:09 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
582 | 2021-11-29 04:27:55 | roper | 2 | 53800 | 276 | 1.436 | 37465.2 |
581 | 2021-11-13 11:39:34 | roper | 1 | 28756 | 22 | 0.533 | 53951.2 |
580 | 2021-10-01 03:02:24 | roper | 1 | 28756 | 22 | 0.483 | 59536.2 |
579 | 2021-09-28 23:13:39 | roper | 1 | 28756 | 22 | 0.530 | 54256.6 |
578 | 2021-09-07 13:09:08 | roper | 1 | 28756 | 22 | 0.516 | 55728.7 |
577 | 2021-09-05 03:51:39 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
576 | 2021-09-01 20:21:08 | roper | 1 | 28756 | 22 | 0.530 | 54256.6 |
575 | 2021-07-10 19:07:56 | roper | 1 | 28756 | 22 | 0.450 | 63902.2 |
574 | 2021-06-01 03:33:34 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
573 | 2021-03-28 09:59:01 | roper | 1 | 28756 | 22 | 1.060 | 27128.3 |
572 | 2021-03-01 22:52:19 | roper | 1 | 28756 | 22 | 0.436 | 65954.1 |
571 | 2021-03-01 22:43:10 | roper | 1 | 28756 | 22 | 0.516 | 55728.7 |
570 | 2021-02-17 22:16:06 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
569 | 2020-12-13 06:22:04 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
568 | 2020-11-30 10:04:52 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
567 | 2020-11-02 07:42:05 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
566 | 2020-09-23 23:20:29 | roper | 1 | 28756 | 22 | 0.436 | 65954.1 |
565 | 2020-09-20 03:59:20 | roper | 1 | 28756 | 22 | 0.436 | 65954.1 |
564 | 2020-09-08 10:12:06 | roper | 1 | 28756 | 22 | 0.456 | 63061.4 |
563 | 2020-08-29 23:09:57 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
562 | 2020-08-29 02:39:58 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
561 | 2020-08-26 01:36:31 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
560 | 2020-07-20 23:22:17 | roper | 1 | 28756 | 22 | 0.486 | 59168.7 |
559 | 2020-07-18 00:39:42 | roper | 1 | 28756 | 22 | 0.533 | 53951.2 |
558 | 2020-05-25 07:57:23 | roper | 1 | 28756 | 22 | 0.436 | 65954.1 |
557 | 2020-05-23 17:49:42 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
556 | 2020-05-22 07:09:09 | roper | 1 | 28756 | 22 | 0.483 | 59536.2 |
555 | 2020-03-29 02:59:00 | roper | 1 | 28756 | 22 | 0.500 | 57512.0 |
554 | 2020-03-28 18:11:46 | roper | 1 | 28756 | 22 | 0.563 | 51076.4 |
553 | 2020-03-25 10:08:40 | roper | 1 | 28756 | 22 | 0.470 | 61183.0 |
552 | 2020-03-23 22:53:54 | roper | 1 | 28756 | 22 | 0.470 | 61183.0 |
551 | 2020-03-22 06:47:17 | roper | 1 | 28756 | 22 | 0.513 | 56054.6 |
550 | 2020-03-21 20:23:14 | roper | 1 | 28756 | 22 | 1.123 | 25606.4 |
549 | 2020-03-21 05:07:32 | roper | 1 | 28756 | 22 | 0.436 | 65954.1 |
548 | 2020-03-18 06:36:32 | roper | 1 | 28756 | 22 | 0.453 | 63479.0 |
547 | 2020-02-29 08:45:41 | roper | 1 | 28756 | 22 | 0.563 | 51076.4 |
546 | 2020-02-27 06:14:11 | roper | 1 | 28756 | 22 | 0.593 | 48492.4 |