History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefectural"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 230 | 2024-05-05 14:17:48 | prefectural | 4 | 148819 | 35 | 10.123 | 14701.1 |
| 229 | 2024-04-21 16:52:01 | prefectural | 3 | 121633 | 7 | 10.466 | 11621.7 |
| 228 | 2024-04-19 20:06:25 | prefectural | 4 | 148819 | 35 | 23.326 | 6380.0 |
| 227 | 2024-04-19 06:48:14 | prefectural | 4 | 148819 | 35 | 38.426 | 3872.9 |
| 226 | 2024-04-19 06:48:15 | prefectural | 3 | 121633 | 7 | 26.110 | 4658.5 |
| 225 | 2024-04-16 22:30:57 | prefectural | 5 | 164607 | 227 | 45.046 | 3654.2 |
| 224 | 2024-04-16 02:32:03 | prefectural | 5 | 164607 | 227 | 55.816 | 2949.1 |
| 223 | 2024-04-16 00:12:26 | prefectural | 5 | 164607 | 227 | 36.440 | 4517.2 |
| 222 | 2024-04-14 20:17:19 | prefectural | 5 | 164607 | 227 | 65.550 | 2511.2 |
| 221 | 2024-04-14 20:17:18 | prefectural | 4 | 148819 | 35 | 18.220 | 8167.9 |
| 220 | 2024-04-14 17:14:51 | prefectural | 5 | 164607 | 227 | 31.753 | 5184.0 |
| 219 | 2024-04-14 17:15:00 | prefectural | 3 | 121633 | 7 | 18.033 | 6745.0 |
| 218 | 2024-04-14 17:15:04 | prefectural | 2 | 86808 | 3 | 8.826 | 9835.5 |
| 217 | 2024-04-14 17:14:55 | prefectural | 4 | 148819 | 35 | 12.143 | 12255.5 |
| 216 | 2024-04-14 17:14:06 | prefectural | 5 | 164607 | 227 | 52.003 | 3165.3 |
| 215 | 2024-04-14 17:14:35 | prefectural | 1 | 49908 | 1 | 1.580 | 31587.3 |
| 214 | 2024-04-14 17:14:07 | prefectural | 4 | 148819 | 35 | 12.156 | 12242.4 |
| 213 | 2024-04-14 17:14:16 | prefectural | 2 | 86808 | 3 | 3.250 | 26710.2 |
| 212 | 2024-04-14 17:14:09 | prefectural | 3 | 121633 | 7 | 7.060 | 17228.5 |
| 211 | 2024-04-14 17:13:53 | prefectural | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 210 | 2024-04-14 17:13:50 | prefectural | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 209 | 2024-03-21 03:40:44 | prefectural | 1 | 49908 | 1 | 3.030 | 16471.3 |
| 208 | 2024-03-02 07:01:52 | prefectural | 1 | 49908 | 1 | 0.983 | 50771.1 |
| 207 | 2024-02-21 06:39:30 | prefectural | 3 | 121633 | 7 | 11.813 | 10296.5 |
| 206 | 2024-02-21 06:39:31 | prefectural | 2 | 86808 | 3 | 8.703 | 9974.5 |
| 205 | 2024-02-21 06:39:29 | prefectural | 1 | 49908 | 1 | 2.326 | 21456.6 |
| 204 | 2024-02-21 05:49:13 | prefectural | 1 | 49908 | 1 | 0.936 | 53320.5 |
| 203 | 2024-02-20 18:00:42 | prefectural | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 202 | 2024-02-19 19:44:24 | prefectural | 4 | 148819 | 35 | 15.313 | 9718.5 |
| 201 | 2024-02-12 16:42:39 | prefectural | 4 | 148819 | 35 | 11.876 | 12531.1 |
| 200 | 2024-01-29 04:58:06 | prefectural | 5 | 164607 | 227 | 18.300 | 8994.9 |
| 199 | 2024-01-08 20:29:43 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 198 | 2023-12-29 05:26:00 | prefectural | 5 | 164607 | 227 | 14.953 | 11008.3 |
| 197 | 2023-12-29 05:25:51 | prefectural | 4 | 148819 | 35 | 8.686 | 17133.2 |
| 196 | 2023-12-29 05:25:46 | prefectural | 3 | 121633 | 7 | 4.826 | 25203.7 |
| 195 | 2023-12-29 05:25:44 | prefectural | 2 | 86808 | 3 | 2.186 | 39710.9 |
| 194 | 2023-12-29 04:24:54 | prefectural | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 193 | 2023-12-11 13:44:01 | prefectural | 1 | 49908 | 1 | 0.906 | 55086.1 |
| 192 | 2023-12-07 07:00:22 | prefectural | 5 | 164607 | 227 | 15.733 | 10462.5 |
| 191 | 2023-12-07 06:44:54 | prefectural | 5 | 164607 | 227 | 14.923 | 11030.4 |
| 190 | 2023-12-07 06:20:22 | prefectural | 5 | 164607 | 227 | 15.610 | 10545.0 |
| 189 | 2023-12-04 00:16:27 | prefectural | 5 | 164607 | 227 | 17.956 | 9167.2 |
| 188 | 2023-11-23 18:01:36 | prefectural | 5 | 164607 | 227 | 13.393 | 12290.5 |
| 187 | 2023-11-07 15:19:50 | prefectural | 5 | 164607 | 227 | 13.093 | 12572.1 |
| 186 | 2023-11-05 20:42:54 | prefectural | 1 | 49908 | 1 | 0.920 | 54247.8 |
| 185 | 2023-10-22 07:51:10 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 184 | 2023-10-16 17:24:46 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 183 | 2023-09-26 23:15:17 | prefectural | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 182 | 2023-09-15 04:40:16 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 181 | 2023-08-12 09:16:26 | prefectural | 5 | 164607 | 227 | 13.800 | 11928.0 |
| 180 | 2023-07-24 16:20:41 | prefectural | 1 | 49908 | 1 | 0.763 | 65410.2 |
| 179 | 2023-05-14 17:47:34 | prefectural | 5 | 164607 | 227 | 12.953 | 12708.0 |
| 178 | 2023-05-12 01:46:16 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 177 | 2023-04-28 02:12:01 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 176 | 2023-04-23 16:15:21 | prefectural | 5 | 164607 | 227 | 13.763 | 11960.1 |
| 175 | 2023-03-27 00:25:03 | prefectural | 5 | 164607 | 227 | 14.236 | 11562.7 |
| 174 | 2023-02-19 16:53:42 | prefectural | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 173 | 2023-01-30 08:17:26 | prefectural | 5 | 164607 | 227 | 17.876 | 9208.3 |
| 172 | 2022-12-20 03:44:55 | prefectural | 1 | 49908 | 1 | 1.326 | 37638.0 |
| 171 | 2022-12-18 05:13:06 | prefectural | 1 | 49908 | 1 | 0.750 | 66544.0 |
| 170 | 2022-12-16 19:26:15 | prefectural | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 169 | 2022-12-13 15:24:51 | prefectural | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 168 | 2022-11-11 17:17:26 | prefectural | 5 | 164607 | 227 | 13.936 | 11811.6 |
| 167 | 2022-09-02 00:24:40 | prefectural | 1 | 49908 | 1 | 0.876 | 56972.6 |
| 166 | 2022-08-30 18:11:11 | prefectural | 1 | 49908 | 1 | 0.826 | 60421.3 |
| 165 | 2022-07-31 03:00:41 | prefectural | 2 | 86808 | 3 | 2.173 | 39948.5 |
| 164 | 2022-07-13 05:36:44 | prefectural | 4 | 148819 | 35 | 8.313 | 17902.0 |
| 163 | 2022-06-25 10:00:46 | prefectural | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 162 | 2022-06-13 22:24:15 | prefectural | 5 | 164607 | 227 | 12.966 | 12695.3 |
| 161 | 2022-05-19 22:19:21 | prefectural | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 160 | 2022-04-13 01:52:29 | prefectural | 1 | 49908 | 1 | 0.966 | 51664.6 |
| 159 | 2022-01-21 17:48:25 | prefectural | 1 | 49908 | 1 | 1.000 | 49908.0 |
| 158 | 2022-01-13 05:38:19 | prefectural | 1 | 49908 | 1 | 0.920 | 54247.8 |
| 157 | 2021-11-05 22:02:40 | prefectural | 1 | 49908 | 1 | 0.936 | 53320.5 |
| 156 | 2021-09-01 12:54:12 | prefectural | 1 | 49908 | 1 | 0.856 | 58303.7 |
| 155 | 2021-05-08 03:04:22 | prefectural | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 154 | 2021-05-05 00:48:24 | prefectural | 1 | 49908 | 1 | 0.940 | 53093.6 |
| 153 | 2021-04-06 12:53:38 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 152 | 2021-01-29 06:05:48 | prefectural | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 151 | 2021-01-27 03:51:19 | prefectural | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 150 | 2021-01-21 18:41:03 | prefectural | 1 | 49908 | 1 | 0.953 | 52369.4 |
| 149 | 2020-12-22 17:16:39 | prefectural | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 148 | 2020-11-12 15:33:57 | prefectural | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 147 | 2020-10-26 17:11:55 | prefectural | 1 | 49908 | 1 | 1.406 | 35496.4 |
| 146 | 2020-10-26 11:34:47 | prefectural | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 145 | 2020-07-19 11:15:02 | prefectural | 1 | 49908 | 1 | 0.830 | 60130.1 |
| 144 | 2020-04-11 14:33:41 | prefectural | 1 | 49908 | 1 | 0.810 | 61614.8 |
| 143 | 2020-03-24 13:19:10 | prefectural | 1 | 49908 | 1 | 1.170 | 42656.4 |
| 142 | 2020-03-04 22:45:42 | prefectural | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 141 | 2020-03-04 15:28:28 | prefectural | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 140 | 2020-02-12 19:50:26 | prefectural | 1 | 49908 | 1 | 2.030 | 24585.2 |
| 139 | 2020-02-09 08:51:04 | prefectural | 1 | 49908 | 1 | 0.923 | 54071.5 |
| 138 | 2020-02-08 13:54:25 | prefectural | 1 | 49908 | 1 | 1.096 | 45536.5 |
| 137 | 2020-02-04 16:24:08 | prefectural | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 136 | 2020-01-20 21:41:15 | prefectural | 2 | 86808 | 3 | 3.046 | 28499.0 |
| 135 | 2020-01-20 17:17:54 | prefectural | 1 | 49908 | 1 | 2.983 | 16730.8 |
| 134 | 2020-01-14 00:32:39 | prefectural | 4 | 148819 | 35 | 15.813 | 9411.2 |
| 133 | 2020-01-14 00:32:41 | prefectural | 2 | 86808 | 3 | 5.640 | 15391.5 |
| 132 | 2020-01-13 18:00:05 | prefectural | 1 | 49908 | 1 | 0.953 | 52369.4 |
| 131 | 2020-01-07 22:44:47 | prefectural | 1 | 49908 | 1 | 3.016 | 16547.7 |