History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"searchable"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 156 | 2024-06-04 15:54:04 | searchable | 1 | 67641 | 1 | 4.313 | 15683.1 |
| 155 | 2024-06-01 18:04:04 | searchable | 1 | 67641 | 1 | 1.623 | 41676.5 |
| 154 | 2024-05-28 20:10:07 | searchable | 4 | 161450 | 215 | 49.173 | 3283.3 |
| 153 | 2024-05-28 14:07:49 | searchable | 4 | 161450 | 215 | 62.410 | 2586.9 |
| 152 | 2024-05-28 06:14:53 | searchable | 4 | 161450 | 215 | 53.816 | 3000.0 |
| 151 | 2024-05-28 06:14:41 | searchable | 3 | 140603 | 36 | 25.373 | 5541.4 |
| 150 | 2024-05-28 04:22:27 | searchable | 4 | 161450 | 215 | 40.593 | 3977.3 |
| 149 | 2024-05-28 04:22:29 | searchable | 2 | 108824 | 6 | 16.843 | 6461.1 |
| 148 | 2024-05-28 04:22:29 | searchable | 3 | 140603 | 36 | 13.000 | 10815.6 |
| 147 | 2024-05-28 04:17:59 | searchable | 1 | 67641 | 1 | 1.643 | 41169.2 |
| 146 | 2024-05-14 10:11:02 | searchable | 1 | 67641 | 1 | 1.783 | 37936.6 |
| 145 | 2024-05-11 06:53:20 | searchable | 2 | 108824 | 6 | 4.063 | 26784.1 |
| 144 | 2024-05-06 11:22:15 | searchable | 1 | 67641 | 1 | 2.643 | 25592.5 |
| 143 | 2024-05-05 10:29:43 | searchable | 1 | 67641 | 1 | 3.283 | 20603.4 |
| 142 | 2024-04-29 16:36:37 | searchable | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 141 | 2024-04-26 04:17:05 | searchable | 1 | 67641 | 1 | 1.153 | 58665.2 |
| 140 | 2024-04-25 16:19:16 | searchable | 1 | 67641 | 1 | 2.203 | 30704.0 |
| 139 | 2024-04-19 21:58:42 | searchable | 2 | 108824 | 6 | 16.393 | 6638.4 |
| 138 | 2024-04-19 21:55:21 | searchable | 1 | 67641 | 1 | 2.483 | 27241.6 |
| 137 | 2024-04-12 00:38:36 | searchable | 4 | 161450 | 215 | 22.643 | 7130.2 |
| 136 | 2024-04-10 07:53:20 | searchable | 4 | 161450 | 215 | 27.220 | 5931.3 |
| 135 | 2024-04-09 15:23:32 | searchable | 4 | 161450 | 215 | 40.893 | 3948.1 |
| 134 | 2024-04-09 15:23:33 | searchable | 3 | 140603 | 36 | 20.860 | 6740.3 |
| 133 | 2024-04-09 15:23:35 | searchable | 2 | 108824 | 6 | 11.563 | 9411.4 |
| 132 | 2024-04-09 14:09:59 | searchable | 1 | 67641 | 1 | 1.170 | 57812.8 |
| 131 | 2024-03-24 06:42:19 | searchable | 2 | 108824 | 6 | 5.610 | 19398.2 |
| 130 | 2024-03-24 06:36:33 | searchable | 1 | 67641 | 1 | 2.670 | 25333.7 |
| 129 | 2024-03-21 11:17:04 | searchable | 1 | 67641 | 1 | 1.360 | 49736.0 |
| 128 | 2024-03-19 05:51:10 | searchable | 1 | 67641 | 1 | 3.983 | 16982.4 |
| 127 | 2024-03-10 10:19:13 | searchable | 2 | 108824 | 6 | 11.423 | 9526.7 |
| 126 | 2024-03-08 15:30:15 | searchable | 2 | 108824 | 6 | 10.330 | 10534.8 |
| 125 | 2024-03-08 15:28:31 | searchable | 1 | 67641 | 1 | 2.110 | 32057.3 |
| 124 | 2024-03-08 15:19:28 | searchable | 3 | 140603 | 36 | 16.656 | 8441.6 |
| 123 | 2024-03-08 15:11:59 | searchable | 4 | 161450 | 215 | 29.376 | 5496.0 |
| 122 | 2024-03-06 06:40:46 | searchable | 3 | 140603 | 36 | 25.190 | 5581.7 |
| 121 | 2024-03-04 21:40:49 | searchable | 3 | 140603 | 36 | 20.766 | 6770.8 |
| 120 | 2024-03-04 10:22:52 | searchable | 4 | 161450 | 215 | 35.126 | 4596.3 |
| 119 | 2024-03-03 14:56:46 | searchable | 3 | 140603 | 36 | 16.750 | 8394.2 |
| 118 | 2024-03-03 14:56:47 | searchable | 2 | 108824 | 6 | 3.733 | 29151.9 |
| 117 | 2024-03-03 14:05:20 | searchable | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 116 | 2024-03-02 22:59:44 | searchable | 4 | 161450 | 215 | 22.613 | 7139.7 |
| 115 | 2024-03-02 18:43:48 | searchable | 4 | 161450 | 215 | 22.800 | 7081.1 |
| 114 | 2024-03-02 03:37:10 | searchable | 4 | 161450 | 215 | 19.673 | 8206.7 |
| 113 | 2024-02-07 02:16:42 | searchable | 1 | 67641 | 1 | 2.516 | 26884.3 |
| 112 | 2024-01-30 13:16:03 | searchable | 1 | 67641 | 1 | 1.233 | 54858.9 |
| 111 | 2024-01-28 04:27:03 | searchable | 1 | 67641 | 1 | 1.060 | 63812.3 |
| 110 | 2024-01-19 17:04:23 | searchable | 1 | 67641 | 1 | 1.140 | 59334.2 |
| 109 | 2024-01-02 01:06:41 | searchable | 2 | 108824 | 6 | 3.233 | 33660.4 |
| 108 | 2023-11-26 18:55:23 | searchable | 4 | 161450 | 215 | 10.000 | 16145.0 |
| 107 | 2023-11-22 14:32:08 | searchable | 1 | 67641 | 1 | 1.156 | 58513.0 |
| 106 | 2023-11-15 07:29:39 | searchable | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 105 | 2023-10-07 10:02:01 | searchable | 2 | 108824 | 6 | 2.813 | 38686.1 |
| 104 | 2023-09-02 23:14:25 | searchable | 1 | 67641 | 1 | 1.190 | 56841.2 |
| 103 | 2023-08-26 05:53:09 | searchable | 4 | 161450 | 215 | 10.500 | 15376.2 |
| 102 | 2023-07-19 21:50:20 | searchable | 2 | 108824 | 6 | 2.796 | 38921.3 |
| 101 | 2023-06-07 04:25:16 | searchable | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 100 | 2023-05-11 02:44:02 | searchable | 4 | 161450 | 215 | 10.000 | 16145.0 |
| 99 | 2023-03-31 00:47:57 | searchable | 2 | 108824 | 6 | 2.810 | 38727.4 |
| 98 | 2023-03-28 20:57:21 | searchable | 1 | 67641 | 1 | 1.016 | 66575.8 |
| 97 | 2023-02-18 06:05:52 | searchable | 4 | 161450 | 215 | 9.966 | 16200.1 |
| 96 | 2023-01-11 20:12:53 | searchable | 1 | 67641 | 1 | 1.110 | 60937.8 |
| 95 | 2022-12-28 03:40:48 | searchable | 2 | 108824 | 6 | 2.750 | 39572.4 |
| 94 | 2022-11-30 00:26:37 | searchable | 4 | 161450 | 215 | 9.953 | 16221.2 |
| 93 | 2022-10-17 20:14:43 | searchable | 1 | 67641 | 1 | 1.030 | 65670.9 |
| 92 | 2022-08-28 23:28:39 | searchable | 2 | 108824 | 6 | 2.936 | 37065.4 |
| 91 | 2022-07-06 23:33:45 | searchable | 4 | 161450 | 215 | 9.953 | 16221.2 |
| 90 | 2022-06-09 02:41:08 | searchable | 1 | 67641 | 1 | 1.033 | 65480.2 |
| 89 | 2021-04-28 08:47:13 | searchable | 1 | 67641 | 1 | 2.110 | 32057.3 |
| 88 | 2021-02-16 15:36:24 | searchable | 1 | 67641 | 1 | 1.143 | 59178.5 |
| 87 | 2021-01-11 12:25:38 | searchable | 1 | 67641 | 1 | 1.046 | 64666.3 |
| 86 | 2020-10-24 08:22:08 | searchable | 1 | 67641 | 1 | 1.050 | 64420.0 |
| 85 | 2020-03-29 16:38:22 | searchable | 1 | 67641 | 1 | 1.093 | 61885.6 |
| 84 | 2020-03-24 17:00:51 | searchable | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 83 | 2020-03-22 10:48:25 | searchable | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 82 | 2020-02-18 02:46:24 | searchable | 1 | 67641 | 1 | 2.796 | 24192.1 |
| 81 | 2020-02-13 15:10:06 | searchable | 1 | 67641 | 1 | 1.203 | 56226.9 |
| 80 | 2020-02-08 13:47:35 | searchable | 1 | 67641 | 1 | 1.250 | 54112.8 |
| 79 | 2020-01-30 09:36:45 | searchable | 1 | 67641 | 1 | 2.580 | 26217.4 |
| 78 | 2020-01-26 19:13:58 | searchable | 1 | 67641 | 1 | 1.563 | 43276.4 |
| 77 | 2020-01-22 13:00:20 | searchable | 1 | 67641 | 1 | 3.893 | 17375.0 |
| 76 | 2020-01-21 00:41:30 | searchable | 1 | 67641 | 1 | 2.876 | 23519.1 |
| 75 | 2020-01-16 16:51:19 | searchable | 1 | 67641 | 1 | 2.626 | 25758.2 |
| 74 | 2020-01-02 12:09:06 | searchable | 1 | 67641 | 1 | 1.280 | 52844.5 |
| 73 | 2020-01-01 22:57:26 | searchable | 1 | 67641 | 1 | 1.593 | 42461.4 |
| 72 | 2019-12-21 12:34:19 | searchable | 1 | 67641 | 1 | 1.063 | 63632.2 |
| 71 | 2019-09-20 09:19:21 | searchable | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 70 | 2019-06-23 18:19:09 | searchable | 1 | 67641 | 1 | 1.163 | 58160.8 |
| 69 | 2019-06-14 12:36:45 | searchable | 1 | 67641 | 1 | 1.123 | 60232.4 |
| 68 | 2019-04-04 05:18:32 | searchable | 1 | 67641 | 1 | 1.173 | 57665.0 |
| 67 | 2019-02-20 20:33:36 | searchable | 1 | 67641 | 1 | 1.013 | 66773.0 |
| 66 | 2019-01-02 13:31:17 | searchable | 1 | 67641 | 1 | 1.433 | 47202.4 |
| 65 | 2018-10-29 04:31:08 | searchable | 1 | 67641 | 1 | 1.150 | 58818.3 |
| 64 | 2018-07-22 09:45:14 | searchable | 1 | 67641 | 1 | 1.333 | 50743.4 |
| 63 | 2018-07-22 00:31:41 | searchable | 1 | 67641 | 1 | 1.310 | 51634.4 |
| 62 | 2018-06-22 11:42:32 | searchable | 1 | 67641 | 1 | 1.056 | 64054.0 |
| 61 | 2018-06-19 23:14:09 | searchable | 1 | 67641 | 1 | 1.166 | 58011.1 |
| 60 | 2018-06-19 18:58:09 | searchable | 1 | 67641 | 1 | 1.080 | 62630.6 |
| 59 | 2017-12-11 00:30:37 | searchable | 1 | 67641 | 1 | 2.143 | 31563.7 |
| 58 | 2017-10-25 18:26:32 | searchable | 1 | 67641 | 1 | 2.130 | 31756.3 |
| 57 | 2017-10-24 20:40:15 | searchable | 1 | 67641 | 1 | 2.193 | 30844.0 |