History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hastate"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 301 | 2024-04-01 01:18:03 | hastate | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 300 | 2024-03-28 08:01:09 | hastate | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 299 | 2024-03-01 20:58:05 | hastate | 1 | 69583 | 1 | 1.656 | 42018.7 |
| 298 | 2024-02-18 22:53:47 | hastate | 2 | 107671 | 21 | 7.343 | 14663.1 |
| 297 | 2023-12-28 02:19:16 | hastate | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 296 | 2023-12-22 12:17:03 | hastate | 1 | 69583 | 1 | 1.343 | 51811.6 |
| 295 | 2023-12-21 05:37:28 | hastate | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 294 | 2023-12-19 21:06:32 | hastate | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 293 | 2023-12-17 02:09:49 | hastate | 3 | 134027 | 279 | 14.470 | 9262.4 |
| 292 | 2023-12-17 02:09:51 | hastate | 2 | 107671 | 21 | 3.733 | 28843.0 |
| 291 | 2023-11-29 11:24:45 | hastate | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 290 | 2023-11-24 08:30:07 | hastate | 1 | 69583 | 1 | 1.393 | 49951.9 |
| 289 | 2023-11-17 15:53:29 | hastate | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 288 | 2023-11-17 11:27:35 | hastate | 2 | 107671 | 21 | 2.843 | 37872.3 |
| 287 | 2023-11-12 05:10:46 | hastate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 286 | 2023-11-05 09:14:56 | hastate | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 285 | 2023-10-13 04:20:40 | hastate | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 284 | 2023-10-07 16:02:42 | hastate | 1 | 69583 | 1 | 1.153 | 60349.5 |
| 283 | 2023-09-29 21:50:40 | hastate | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 282 | 2023-09-17 03:40:58 | hastate | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 281 | 2023-08-30 17:29:50 | hastate | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 280 | 2023-08-18 22:16:04 | hastate | 2 | 107671 | 21 | 3.453 | 31181.9 |
| 279 | 2023-08-03 11:33:22 | hastate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 278 | 2023-05-17 04:36:46 | hastate | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 277 | 2023-05-02 13:00:31 | hastate | 2 | 107671 | 21 | 3.236 | 33272.9 |
| 276 | 2023-04-30 00:34:33 | hastate | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 275 | 2023-03-03 01:16:27 | hastate | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 274 | 2023-02-18 21:03:07 | hastate | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 273 | 2023-02-07 22:52:40 | hastate | 2 | 107671 | 21 | 2.813 | 38276.2 |
| 272 | 2023-02-03 18:01:19 | hastate | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 271 | 2022-12-17 04:24:51 | hastate | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 270 | 2022-11-18 20:17:01 | hastate | 2 | 107671 | 21 | 3.250 | 33129.5 |
| 269 | 2022-10-17 07:18:17 | hastate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 268 | 2022-09-11 21:06:57 | hastate | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 267 | 2022-08-26 02:31:13 | hastate | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 266 | 2022-07-30 10:12:28 | hastate | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 265 | 2022-07-04 17:26:08 | hastate | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 264 | 2022-06-26 00:44:02 | hastate | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 263 | 2022-06-24 23:55:57 | hastate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 262 | 2022-06-23 13:31:03 | hastate | 2 | 107671 | 21 | 3.000 | 35890.3 |
| 261 | 2022-04-28 10:29:27 | hastate | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 260 | 2022-03-17 11:04:12 | hastate | 1 | 69583 | 1 | 1.546 | 45008.4 |
| 259 | 2021-12-06 23:36:00 | hastate | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 258 | 2021-12-03 16:59:47 | hastate | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 257 | 2021-10-30 20:03:32 | hastate | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 256 | 2021-10-29 18:43:46 | hastate | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 255 | 2021-09-21 17:50:13 | hastate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 254 | 2021-09-20 21:55:10 | hastate | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 253 | 2021-09-20 04:49:34 | hastate | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 252 | 2021-09-13 20:39:20 | hastate | 1 | 69583 | 1 | 1.533 | 45390.1 |
| 251 | 2021-08-30 15:03:02 | hastate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 250 | 2021-05-29 22:20:25 | hastate | 1 | 69583 | 1 | 1.200 | 57985.8 |
| 249 | 2021-05-12 12:00:21 | hastate | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 248 | 2021-02-27 06:28:03 | hastate | 1 | 69583 | 1 | 1.310 | 53116.8 |
| 247 | 2021-02-26 11:03:05 | hastate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 246 | 2020-11-22 13:57:26 | hastate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 245 | 2020-11-13 19:12:43 | hastate | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 244 | 2020-10-27 19:56:33 | hastate | 1 | 69583 | 1 | 1.216 | 57222.9 |
| 243 | 2020-10-20 04:54:47 | hastate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 242 | 2020-10-13 17:28:58 | hastate | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 241 | 2020-08-21 10:21:08 | hastate | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 240 | 2020-08-08 10:15:56 | hastate | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 239 | 2020-07-27 07:18:42 | hastate | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 238 | 2020-06-17 11:46:56 | hastate | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 237 | 2020-05-20 02:25:19 | hastate | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 236 | 2020-05-02 05:04:24 | hastate | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 235 | 2020-04-16 10:06:59 | hastate | 1 | 69583 | 1 | 1.123 | 61961.7 |
| 234 | 2020-03-28 04:51:50 | hastate | 1 | 69583 | 1 | 2.640 | 26357.2 |
| 233 | 2020-03-28 01:43:42 | hastate | 1 | 69583 | 1 | 1.266 | 54962.9 |
| 232 | 2020-03-24 13:00:30 | hastate | 1 | 69583 | 1 | 2.530 | 27503.2 |
| 231 | 2020-03-23 08:47:57 | hastate | 1 | 69583 | 1 | 2.420 | 28753.3 |
| 230 | 2020-03-20 09:29:25 | hastate | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 229 | 2020-02-28 10:39:40 | hastate | 3 | 134027 | 279 | 14.406 | 9303.6 |
| 228 | 2020-02-28 09:34:36 | hastate | 3 | 134027 | 279 | 7.110 | 18850.5 |
| 227 | 2020-02-28 08:04:10 | hastate | 3 | 134027 | 279 | 8.533 | 15706.9 |
| 226 | 2020-02-27 22:21:56 | hastate | 3 | 134027 | 279 | 7.923 | 16916.2 |
| 225 | 2020-02-27 18:22:12 | hastate | 3 | 134027 | 279 | 13.453 | 9962.6 |
| 224 | 2020-02-27 13:38:41 | hastate | 3 | 134027 | 279 | 19.123 | 7008.7 |
| 223 | 2020-02-26 11:42:17 | hastate | 1 | 69583 | 1 | 1.560 | 44604.5 |
| 222 | 2020-02-26 10:44:19 | hastate | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 221 | 2020-02-24 11:17:02 | hastate | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 220 | 2020-02-17 04:00:14 | hastate | 1 | 69583 | 1 | 1.690 | 41173.4 |
| 219 | 2020-02-15 12:44:52 | hastate | 1 | 69583 | 1 | 2.530 | 27503.2 |
| 218 | 2020-02-07 20:30:26 | hastate | 1 | 69583 | 1 | 1.813 | 38380.0 |
| 217 | 2020-02-07 15:34:49 | hastate | 1 | 69583 | 1 | 2.296 | 30306.2 |
| 216 | 2020-02-06 14:13:08 | hastate | 1 | 69583 | 1 | 1.280 | 54361.7 |
| 215 | 2020-02-02 07:03:42 | hastate | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 214 | 2020-02-01 12:08:09 | hastate | 1 | 69583 | 1 | 1.330 | 52318.0 |
| 213 | 2020-01-30 20:06:35 | hastate | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 212 | 2020-01-24 00:14:21 | hastate | 1 | 69583 | 1 | 3.076 | 22621.3 |
| 211 | 2020-01-16 09:10:03 | hastate | 1 | 69583 | 1 | 1.970 | 35321.3 |
| 210 | 2020-01-16 02:43:59 | hastate | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 209 | 2020-01-13 11:16:49 | hastate | 3 | 134027 | 279 | 13.080 | 10246.7 |
| 208 | 2020-01-13 08:04:50 | hastate | 3 | 134027 | 279 | 7.190 | 18640.8 |
| 207 | 2020-01-13 04:43:32 | hastate | 2 | 107671 | 21 | 3.766 | 28590.3 |
| 206 | 2020-01-13 03:03:20 | hastate | 3 | 134027 | 279 | 10.220 | 13114.2 |
| 205 | 2020-01-12 23:17:59 | hastate | 1 | 69583 | 1 | 1.406 | 49490.0 |
| 204 | 2020-01-04 13:50:30 | hastate | 1 | 69583 | 1 | 1.063 | 65459.1 |
| 203 | 2019-12-31 05:24:46 | hastate | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 202 | 2019-12-29 09:33:50 | hastate | 1 | 69583 | 1 | 1.266 | 54962.9 |