History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"colour"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 2683 | 2024-04-25 15:38:43 | colour | 2 | 82551 | 45 | 2.593 | 31836.1 |
| 2682 | 2024-04-24 11:19:24 | colour | 1 | 48755 | 5 | 2.000 | 24377.5 |
| 2681 | 2024-04-21 06:42:18 | colour | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 2680 | 2024-04-17 08:38:20 | colour | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 2679 | 2024-04-13 14:08:01 | colour | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 2678 | 2024-04-11 05:44:45 | colour | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 2677 | 2024-03-30 03:19:32 | colour | 3 | 112716 | 474 | 18.016 | 6256.4 |
| 2676 | 2024-03-29 08:46:45 | colour | 1 | 48755 | 5 | 2.873 | 16970.1 |
| 2675 | 2024-03-27 04:10:28 | colour | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 2674 | 2024-03-25 06:51:49 | colour | 3 | 112716 | 474 | 6.250 | 18034.6 |
| 2673 | 2024-03-21 17:23:44 | colour | 3 | 112716 | 474 | 6.860 | 16430.9 |
| 2672 | 2024-03-21 17:23:46 | colour | 2 | 82551 | 45 | 3.000 | 27517.0 |
| 2671 | 2024-03-17 19:55:38 | colour | 2 | 82551 | 45 | 6.720 | 12284.4 |
| 2670 | 2024-03-17 19:38:24 | colour | 3 | 112716 | 474 | 6.173 | 18259.5 |
| 2669 | 2024-03-17 19:38:23 | colour | 2 | 82551 | 45 | 2.923 | 28241.9 |
| 2668 | 2024-03-17 19:38:19 | colour | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 2667 | 2024-03-17 19:37:55 | colour | 3 | 112716 | 474 | 5.576 | 20214.5 |
| 2666 | 2024-03-17 06:58:13 | colour | 3 | 112716 | 474 | 4.873 | 23130.7 |
| 2665 | 2024-03-08 11:04:28 | colour | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 2664 | 2024-03-07 06:24:12 | colour | 1 | 48755 | 5 | 2.940 | 16583.3 |
| 2663 | 2024-03-05 08:50:23 | colour | 1 | 48755 | 5 | 1.453 | 33554.7 |
| 2662 | 2024-02-28 22:21:45 | colour | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 2661 | 2024-02-25 18:57:07 | colour | 1 | 48755 | 5 | 0.983 | 49598.2 |
| 2660 | 2024-02-25 15:48:59 | colour | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 2659 | 2024-02-21 07:20:26 | colour | 1 | 48755 | 5 | 1.186 | 41108.8 |
| 2658 | 2024-02-09 17:22:50 | colour | 3 | 112716 | 474 | 11.233 | 10034.4 |
| 2657 | 2024-02-05 03:00:03 | colour | 3 | 112716 | 474 | 12.453 | 9051.3 |
| 2656 | 2024-01-29 23:24:11 | colour | 2 | 82551 | 45 | 3.923 | 21042.8 |
| 2655 | 2024-01-29 23:20:38 | colour | 3 | 112716 | 474 | 6.263 | 17997.1 |
| 2654 | 2024-01-29 02:08:05 | colour | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 2653 | 2024-01-28 11:58:59 | colour | 2 | 82551 | 45 | 2.156 | 38289.0 |
| 2652 | 2024-01-28 11:58:39 | colour | 3 | 112716 | 474 | 5.436 | 20735.1 |
| 2651 | 2024-01-26 13:12:37 | colour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 2650 | 2024-01-25 18:14:27 | colour | 3 | 112716 | 474 | 6.000 | 18786.0 |
| 2649 | 2024-01-25 18:14:23 | colour | 2 | 82551 | 45 | 2.593 | 31836.1 |
| 2648 | 2024-01-24 12:55:26 | colour | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 2647 | 2024-01-24 00:04:55 | colour | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 2646 | 2024-01-19 01:42:36 | colour | 2 | 82551 | 45 | 2.690 | 30688.1 |
| 2645 | 2024-01-07 17:23:38 | colour | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 2644 | 2023-12-29 04:26:07 | colour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 2643 | 2023-12-15 09:48:33 | colour | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 2642 | 2023-12-09 13:45:35 | colour | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 2641 | 2023-12-08 07:12:35 | colour | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 2640 | 2023-12-08 07:12:34 | colour | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 2639 | 2023-12-02 16:36:00 | colour | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 2638 | 2023-11-24 07:08:45 | colour | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 2637 | 2023-11-23 18:22:24 | colour | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 2636 | 2023-11-23 10:12:17 | colour | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 2635 | 2023-11-15 04:40:17 | colour | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 2634 | 2023-11-11 20:57:07 | colour | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 2633 | 2023-11-11 16:32:36 | colour | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 2632 | 2023-11-08 11:36:36 | colour | 2 | 82551 | 45 | 2.546 | 32423.8 |
| 2631 | 2023-11-08 11:35:52 | colour | 3 | 112716 | 474 | 5.673 | 19868.9 |
| 2630 | 2023-11-08 08:14:41 | colour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 2629 | 2023-11-08 02:06:31 | colour | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 2628 | 2023-11-08 01:08:21 | colour | 3 | 112716 | 474 | 5.626 | 20034.8 |
| 2627 | 2023-11-08 01:08:18 | colour | 2 | 82551 | 45 | 2.500 | 33020.4 |
| 2626 | 2023-11-07 21:51:21 | colour | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 2625 | 2023-11-07 19:00:18 | colour | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 2624 | 2023-11-07 10:43:54 | colour | 3 | 112716 | 474 | 12.000 | 9393.0 |
| 2623 | 2023-11-07 10:43:55 | colour | 2 | 82551 | 45 | 3.390 | 24351.3 |
| 2622 | 2023-11-07 07:17:03 | colour | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 2621 | 2023-11-07 04:41:38 | colour | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 2620 | 2023-11-06 20:17:10 | colour | 3 | 112716 | 474 | 6.343 | 17770.1 |
| 2619 | 2023-11-06 20:06:37 | colour | 2 | 82551 | 45 | 2.170 | 38041.9 |
| 2618 | 2023-11-06 13:01:08 | colour | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 2617 | 2023-11-06 09:49:43 | colour | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 2616 | 2023-11-05 17:23:24 | colour | 1 | 48755 | 5 | 0.800 | 60943.8 |
| 2615 | 2023-11-05 16:22:09 | colour | 3 | 112716 | 474 | 5.420 | 20796.3 |
| 2614 | 2023-11-05 16:22:04 | colour | 2 | 82551 | 45 | 2.436 | 33887.9 |
| 2613 | 2023-11-05 12:14:16 | colour | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 2612 | 2023-11-02 01:52:05 | colour | 3 | 112716 | 474 | 4.890 | 23050.3 |
| 2611 | 2023-11-02 01:09:27 | colour | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 2610 | 2023-10-31 12:39:54 | colour | 2 | 82551 | 45 | 2.626 | 31436.0 |
| 2609 | 2023-10-30 01:13:30 | colour | 3 | 112716 | 474 | 5.546 | 20323.8 |
| 2608 | 2023-10-30 01:12:01 | colour | 2 | 82551 | 45 | 2.186 | 37763.5 |
| 2607 | 2023-10-29 22:47:54 | colour | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 2606 | 2023-10-25 20:51:53 | colour | 3 | 112716 | 474 | 5.783 | 19490.9 |
| 2605 | 2023-10-25 20:51:52 | colour | 2 | 82551 | 45 | 2.436 | 33887.9 |
| 2604 | 2023-10-25 19:13:11 | colour | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 2603 | 2023-10-24 10:36:25 | colour | 3 | 112716 | 474 | 4.936 | 22835.5 |
| 2602 | 2023-10-23 15:19:01 | colour | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 2601 | 2023-10-19 15:08:15 | colour | 3 | 112716 | 474 | 4.766 | 23650.0 |
| 2600 | 2023-10-19 15:08:05 | colour | 2 | 82551 | 45 | 5.453 | 15138.6 |
| 2599 | 2023-10-19 14:09:21 | colour | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 2598 | 2023-10-19 13:21:28 | colour | 2 | 82551 | 45 | 2.220 | 37185.1 |
| 2597 | 2023-10-16 19:06:11 | colour | 3 | 112716 | 474 | 6.923 | 16281.4 |
| 2596 | 2023-10-16 19:06:13 | colour | 2 | 82551 | 45 | 2.906 | 28407.1 |
| 2595 | 2023-10-16 18:08:36 | colour | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 2594 | 2023-10-15 20:02:43 | colour | 2 | 82551 | 45 | 2.156 | 38289.0 |
| 2593 | 2023-10-09 21:38:42 | colour | 2 | 82551 | 45 | 2.596 | 31799.3 |
| 2592 | 2023-10-09 21:38:14 | colour | 3 | 112716 | 474 | 6.170 | 18268.4 |
| 2591 | 2023-10-09 20:11:48 | colour | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 2590 | 2023-10-03 09:06:19 | colour | 3 | 112716 | 474 | 5.280 | 21347.7 |
| 2589 | 2023-10-03 09:06:21 | colour | 2 | 82551 | 45 | 2.483 | 33246.5 |
| 2588 | 2023-10-03 08:06:38 | colour | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 2587 | 2023-09-25 15:01:22 | colour | 3 | 112716 | 474 | 4.733 | 23814.9 |
| 2586 | 2023-09-25 15:00:47 | colour | 2 | 82551 | 45 | 2.420 | 34112.0 |
| 2585 | 2023-09-25 09:55:47 | colour | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 2584 | 2023-09-18 19:22:03 | colour | 3 | 112716 | 474 | 5.640 | 19985.1 |