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 |
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 |
2608 | 2025-04-28 04:37:40 | red | 2 | 14084 | 571 | 2.453 | 5741.5 |
2607 | 2025-04-27 21:17:23 | red | 1 | 5146 | 38 | 0.123 | 41837.4 |
2606 | 2025-04-27 06:36:15 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |
2605 | 2025-04-22 02:12:54 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |
2604 | 2025-04-16 20:30:42 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2603 | 2025-04-16 14:02:41 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2602 | 2025-04-16 11:58:57 | red | 1 | 5146 | 38 | 0.110 | 46781.8 |
2601 | 2025-04-15 17:06:46 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2600 | 2025-04-15 13:29:07 | red | 1 | 5146 | 38 | 0.640 | 8040.6 |
2599 | 2025-04-14 05:40:31 | red | 2 | 14084 | 571 | 2.060 | 6836.9 |
2598 | 2025-04-14 03:25:08 | red | 1 | 5146 | 38 | 0.096 | 53604.2 |
2597 | 2025-04-10 22:11:51 | red | 1 | 5146 | 38 | 0.610 | 8436.1 |
2596 | 2025-04-09 06:58:35 | red | 2 | 14084 | 571 | 2.156 | 6532.5 |
2595 | 2025-04-08 03:14:00 | red | 2 | 14084 | 571 | 1.750 | 8048.0 |
2594 | 2025-04-07 11:14:19 | red | 2 | 14084 | 571 | 0.436 | 32302.8 |
2593 | 2025-04-06 17:11:01 | red | 1 | 5146 | 38 | 0.220 | 23390.9 |
2592 | 2025-04-03 02:39:13 | red | 2 | 14084 | 571 | 0.436 | 32302.8 |
2591 | 2025-03-29 00:43:28 | red | 2 | 14084 | 571 | 0.873 | 16132.9 |
2590 | 2025-03-27 06:39:08 | red | 2 | 14084 | 571 | 2.173 | 6481.4 |
2589 | 2025-03-26 14:00:52 | red | 2 | 14084 | 571 | 1.110 | 12688.3 |
2588 | 2025-03-25 05:18:51 | red | 2 | 14084 | 571 | 2.843 | 4953.9 |
2587 | 2025-03-24 09:57:13 | red | 1 | 5146 | 38 | 0.703 | 7320.1 |
2586 | 2025-03-24 00:29:30 | red | 2 | 14084 | 571 | 0.406 | 34689.7 |
2585 | 2025-03-23 17:09:26 | red | 1 | 5146 | 38 | 0.403 | 12769.2 |
2584 | 2025-03-23 03:54:29 | red | 2 | 14084 | 571 | 0.873 | 16132.9 |
2583 | 2025-03-21 08:44:50 | red | 2 | 14084 | 571 | 0.906 | 15545.3 |
2582 | 2025-03-18 08:19:19 | red | 2 | 14084 | 571 | 1.750 | 8048.0 |
2581 | 2025-03-17 03:12:40 | red | 1 | 5146 | 38 | 0.466 | 11042.9 |
2580 | 2025-03-15 01:33:52 | red | 2 | 14084 | 571 | 0.860 | 16376.7 |
2579 | 2025-03-14 20:06:58 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2578 | 2025-03-13 08:16:49 | red | 1 | 5146 | 38 | 0.673 | 7646.4 |
2577 | 2025-03-11 21:24:54 | red | 2 | 14084 | 571 | 1.080 | 13040.7 |
2576 | 2025-03-10 08:07:43 | red | 2 | 14084 | 571 | 2.143 | 6572.1 |
2575 | 2025-03-10 04:35:22 | red | 2 | 14084 | 571 | 0.983 | 14327.6 |
2574 | 2025-03-10 03:33:01 | red | 1 | 5146 | 38 | 0.093 | 55333.3 |
2573 | 2025-03-06 22:28:06 | red | 2 | 14084 | 571 | 1.766 | 7975.1 |
2572 | 2025-03-06 20:52:06 | red | 2 | 14084 | 571 | 1.096 | 12850.4 |
2571 | 2025-03-06 19:56:31 | red | 2 | 14084 | 571 | 1.093 | 12885.6 |
2570 | 2025-03-06 07:47:47 | red | 1 | 5146 | 38 | 0.296 | 17385.1 |
2569 | 2025-03-05 06:18:13 | red | 1 | 5146 | 38 | 0.720 | 7147.2 |