History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"red"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2708 | 2025-09-01 01:29:51 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2707 | 2025-08-30 13:44:44 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2706 | 2025-08-28 17:53:17 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2705 | 2025-08-28 13:39:13 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2704 | 2025-08-27 20:30:39 | red | 2 | 14084 | 571 | 0.403 | 34947.9 |
2703 | 2025-08-24 20:30:39 | red | 1 | 5146 | 38 | 0.390 | 13194.9 |
2702 | 2025-08-18 17:20:47 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2701 | 2025-08-17 13:19:56 | red | 2 | 14084 | 571 | 1.063 | 13249.3 |
2700 | 2025-08-15 17:54:26 | red | 2 | 14084 | 571 | 0.923 | 15258.9 |
2699 | 2025-08-13 20:42:07 | red | 1 | 5146 | 38 | 0.170 | 30270.6 |
2698 | 2025-08-11 04:52:23 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2697 | 2025-08-09 19:42:43 | red | 1 | 5146 | 38 | 0.186 | 27666.7 |
2696 | 2025-08-08 15:19:48 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2695 | 2025-08-05 09:40:20 | red | 2 | 14084 | 571 | 0.873 | 16132.9 |
2694 | 2025-08-03 04:49:54 | red | 2 | 14084 | 571 | 1.966 | 7163.8 |
2693 | 2025-07-31 04:45:01 | red | 1 | 5146 | 38 | 0.170 | 30270.6 |
2692 | 2025-07-30 21:41:44 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2691 | 2025-07-30 20:45:25 | red | 2 | 14084 | 571 | 0.423 | 33295.5 |
2690 | 2025-07-28 10:07:21 | red | 2 | 14084 | 571 | 1.923 | 7324.0 |
2689 | 2025-07-28 10:07:22 | red | 2 | 14084 | 571 | 1.063 | 13249.3 |
2688 | 2025-07-27 11:46:21 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2687 | 2025-07-27 07:39:24 | red | 2 | 14084 | 571 | 1.046 | 13464.6 |
2686 | 2025-07-26 18:39:29 | red | 1 | 5146 | 38 | 0.606 | 8491.7 |
2685 | 2025-07-26 11:15:10 | red | 2 | 14084 | 571 | 1.393 | 10110.6 |
2684 | 2025-07-26 05:31:24 | red | 1 | 5146 | 38 | 0.593 | 8677.9 |
2683 | 2025-07-25 04:14:06 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2682 | 2025-07-24 05:35:55 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2681 | 2025-07-24 02:57:42 | red | 1 | 5146 | 38 | 0.640 | 8040.6 |
2680 | 2025-07-23 22:59:00 | red | 1 | 5146 | 38 | 0.186 | 27666.7 |
2679 | 2025-07-22 13:29:55 | red | 1 | 5146 | 38 | 0.373 | 13796.2 |
2678 | 2025-07-19 13:40:01 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2677 | 2025-07-17 22:51:13 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2676 | 2025-07-17 04:45:48 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2675 | 2025-07-16 18:32:18 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2674 | 2025-07-16 05:57:23 | red | 1 | 5146 | 38 | 0.126 | 40841.3 |
2673 | 2025-07-12 21:41:37 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2672 | 2025-07-11 15:24:31 | red | 2 | 14084 | 571 | 2.813 | 5006.8 |
2671 | 2025-07-09 17:45:06 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2670 | 2025-07-09 08:43:37 | red | 1 | 5146 | 38 | 0.080 | 64325.0 |
2669 | 2025-07-09 06:56:10 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2668 | 2025-07-09 03:36:26 | red | 2 | 14084 | 571 | 1.080 | 13040.7 |
2667 | 2025-07-08 08:53:05 | red | 1 | 5146 | 38 | 0.533 | 9654.8 |
2666 | 2025-07-07 18:22:26 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2665 | 2025-07-07 13:22:39 | red | 2 | 14084 | 571 | 2.000 | 7042.0 |
2664 | 2025-07-06 05:31:06 | red | 1 | 5146 | 38 | 0.190 | 27084.2 |
2663 | 2025-07-05 08:48:18 | red | 2 | 14084 | 571 | 1.716 | 8207.5 |
2662 | 2025-07-02 21:25:49 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2661 | 2025-07-02 20:32:05 | red | 2 | 14084 | 571 | 2.923 | 4818.3 |
2660 | 2025-07-01 17:29:37 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2659 | 2025-06-29 23:04:33 | red | 2 | 14084 | 571 | 1.796 | 7841.9 |
2658 | 2025-06-29 13:00:21 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2657 | 2025-06-29 03:35:17 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2656 | 2025-06-29 01:03:55 | red | 1 | 5146 | 38 | 0.106 | 48547.2 |
2655 | 2025-06-28 23:19:24 | red | 2 | 14084 | 571 | 0.420 | 33533.3 |
2654 | 2025-06-27 21:38:03 | red | 1 | 5146 | 38 | 0.516 | 9972.9 |
2653 | 2025-06-24 06:05:39 | red | 2 | 14084 | 571 | 1.716 | 8207.5 |
2652 | 2025-06-23 19:51:51 | red | 2 | 14084 | 571 | 0.436 | 32302.8 |
2651 | 2025-06-20 09:08:57 | red | 2 | 14084 | 571 | 1.470 | 9581.0 |
2650 | 2025-06-19 21:14:56 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2649 | 2025-06-19 10:08:08 | red | 2 | 14084 | 571 | 1.736 | 8112.9 |
2648 | 2025-06-17 17:47:39 | red | 2 | 14084 | 571 | 0.343 | 41061.2 |
2647 | 2025-06-16 10:23:56 | red | 1 | 5146 | 38 | 0.293 | 17563.1 |
2646 | 2025-06-16 01:40:28 | red | 1 | 5146 | 38 | 0.500 | 10292.0 |
2645 | 2025-06-15 14:06:12 | red | 1 | 5146 | 38 | 0.560 | 9189.3 |
2644 | 2025-06-12 10:56:18 | red | 2 | 14084 | 571 | 1.393 | 10110.6 |
2643 | 2025-06-11 21:18:32 | red | 1 | 5146 | 38 | 0.610 | 8436.1 |
2642 | 2025-06-11 07:00:31 | red | 2 | 14084 | 571 | 2.233 | 6307.2 |
2641 | 2025-06-10 22:07:39 | red | 1 | 5146 | 38 | 0.453 | 11359.8 |
2640 | 2025-06-10 21:57:47 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2639 | 2025-06-10 13:06:10 | red | 2 | 14084 | 571 | 2.713 | 5191.3 |
2638 | 2025-06-08 03:41:23 | red | 2 | 14084 | 571 | 1.610 | 8747.8 |
2637 | 2025-06-07 07:24:44 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2636 | 2025-06-06 17:23:06 | red | 1 | 5146 | 38 | 0.453 | 11359.8 |
2635 | 2025-06-05 17:28:13 | red | 2 | 14084 | 571 | 0.360 | 39122.2 |
2634 | 2025-06-03 22:06:17 | red | 2 | 14084 | 571 | 2.076 | 6784.2 |
2633 | 2025-06-01 03:41:13 | red | 1 | 5146 | 38 | 1.123 | 4582.4 |
2632 | 2025-05-29 04:59:44 | red | 2 | 14084 | 571 | 1.846 | 7629.5 |
2631 | 2025-05-29 02:54:59 | red | 1 | 5146 | 38 | 0.126 | 40841.3 |
2630 | 2025-05-28 21:05:41 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2629 | 2025-05-28 18:34:06 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2628 | 2025-05-28 14:53:39 | red | 1 | 5146 | 38 | 0.610 | 8436.1 |
2627 | 2025-05-28 07:06:46 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2626 | 2025-05-27 22:42:00 | red | 1 | 5146 | 38 | 0.076 | 67710.5 |
2625 | 2025-05-27 17:57:22 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2624 | 2025-05-26 23:29:14 | red | 1 | 5146 | 38 | 0.703 | 7320.1 |
2623 | 2025-05-26 16:57:45 | red | 2 | 14084 | 571 | 1.720 | 8188.4 |
2622 | 2025-05-25 07:10:38 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2621 | 2025-05-23 08:20:13 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2620 | 2025-05-18 07:22:53 | red | 2 | 14084 | 571 | 2.093 | 6729.1 |
2619 | 2025-05-17 21:02:12 | red | 1 | 5146 | 38 | 0.280 | 18378.6 |
2618 | 2025-05-17 14:52:16 | red | 2 | 14084 | 571 | 0.390 | 36112.8 |
2617 | 2025-05-16 15:56:45 | red | 2 | 14084 | 571 | 2.280 | 6177.2 |
2616 | 2025-05-16 10:45:08 | red | 2 | 14084 | 571 | 1.656 | 8504.8 |
2615 | 2025-05-15 08:26:15 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2614 | 2025-05-15 03:08:23 | red | 1 | 5146 | 38 | 0.203 | 25349.8 |
2613 | 2025-05-12 20:15:00 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2612 | 2025-05-10 22:38:13 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2611 | 2025-05-09 05:00:14 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2610 | 2025-05-05 01:39:48 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |
2609 | 2025-05-02 20:47:05 | red | 1 | 5146 | 38 | 0.126 | 40841.3 |