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 |
| 374 | 2025-04-20 11:28:58 | hastate | 1 | 69583 | 1 | 1.283 | 54234.6 |
| 373 | 2025-04-20 01:33:29 | hastate | 2 | 107671 | 21 | 16.593 | 6488.9 |
| 372 | 2025-04-18 11:20:28 | hastate | 3 | 134027 | 279 | 20.280 | 6608.8 |
| 371 | 2025-04-16 18:26:41 | hastate | 3 | 134027 | 279 | 6.216 | 21561.6 |
| 370 | 2025-04-08 21:23:47 | hastate | 1 | 69583 | 1 | 3.190 | 21812.9 |
| 369 | 2025-04-04 13:33:06 | hastate | 3 | 134027 | 279 | 22.063 | 6074.7 |
| 368 | 2025-04-04 07:42:26 | hastate | 3 | 134027 | 279 | 37.406 | 3583.0 |
| 367 | 2025-04-04 04:02:37 | hastate | 3 | 134027 | 279 | 31.733 | 4223.6 |
| 366 | 2025-04-02 21:03:30 | hastate | 3 | 134027 | 279 | 26.186 | 5118.3 |
| 365 | 2025-04-01 15:23:59 | hastate | 3 | 134027 | 279 | 6.736 | 19897.1 |
| 364 | 2025-03-29 08:59:14 | hastate | 1 | 69583 | 1 | 3.266 | 21305.3 |
| 363 | 2025-03-26 03:16:29 | hastate | 1 | 69583 | 1 | 8.046 | 8648.1 |
| 362 | 2025-03-20 14:30:03 | hastate | 1 | 69583 | 1 | 3.076 | 22621.3 |
| 361 | 2025-03-20 03:02:40 | hastate | 1 | 69583 | 1 | 7.876 | 8834.8 |
| 360 | 2025-03-08 12:47:39 | hastate | 1 | 69583 | 1 | 3.376 | 20611.1 |
| 359 | 2025-03-05 15:44:10 | hastate | 1 | 69583 | 1 | 6.156 | 11303.3 |
| 358 | 2025-02-26 10:46:43 | hastate | 1 | 69583 | 1 | 4.376 | 15901.1 |
| 357 | 2025-02-09 07:14:57 | hastate | 1 | 69583 | 1 | 1.200 | 57985.8 |
| 356 | 2025-02-08 14:48:34 | hastate | 2 | 107671 | 21 | 21.656 | 4971.9 |
| 355 | 2025-01-30 01:35:53 | hastate | 3 | 134027 | 279 | 45.376 | 2953.7 |
| 354 | 2025-01-29 12:31:50 | hastate | 1 | 69583 | 1 | 3.966 | 17544.9 |
| 353 | 2025-01-29 11:37:14 | hastate | 2 | 107671 | 21 | 10.660 | 10100.5 |
| 352 | 2025-01-29 11:25:04 | hastate | 3 | 134027 | 279 | 7.110 | 18850.5 |
| 351 | 2025-01-28 19:47:47 | hastate | 3 | 134027 | 279 | 33.593 | 3989.7 |
| 350 | 2025-01-28 19:29:35 | hastate | 3 | 134027 | 279 | 27.580 | 4859.6 |
| 349 | 2025-01-28 16:52:13 | hastate | 3 | 134027 | 279 | 6.000 | 22337.8 |
| 348 | 2025-01-25 23:05:35 | hastate | 1 | 69583 | 1 | 3.970 | 17527.2 |
| 347 | 2025-01-24 21:03:42 | hastate | 1 | 69583 | 1 | 2.923 | 23805.3 |
| 346 | 2024-12-26 17:07:55 | hastate | 1 | 69583 | 1 | 5.140 | 13537.5 |
| 345 | 2024-12-22 11:39:02 | hastate | 2 | 107671 | 21 | 21.233 | 5070.9 |
| 344 | 2024-12-19 23:25:22 | hastate | 2 | 107671 | 21 | 3.406 | 31612.2 |
| 343 | 2024-12-19 13:01:39 | hastate | 1 | 69583 | 1 | 6.266 | 11104.9 |
| 342 | 2024-12-17 23:02:16 | hastate | 3 | 134027 | 279 | 35.470 | 3778.6 |
| 341 | 2024-12-16 20:22:17 | hastate | 3 | 134027 | 279 | 35.140 | 3814.1 |
| 340 | 2024-12-16 03:05:49 | hastate | 1 | 69583 | 1 | 5.186 | 13417.5 |
| 339 | 2024-12-14 13:29:14 | hastate | 3 | 134027 | 279 | 26.516 | 5054.6 |
| 338 | 2024-12-14 13:29:20 | hastate | 2 | 107671 | 21 | 16.753 | 6427.0 |
| 337 | 2024-12-14 13:28:01 | hastate | 1 | 69583 | 1 | 4.483 | 15521.5 |
| 336 | 2024-11-26 08:22:08 | hastate | 1 | 69583 | 1 | 4.500 | 15462.9 |
| 335 | 2024-11-12 20:47:02 | hastate | 1 | 69583 | 1 | 3.296 | 21111.3 |
| 334 | 2024-11-11 19:35:54 | hastate | 1 | 69583 | 1 | 7.293 | 9541.1 |
| 333 | 2024-10-27 02:49:58 | hastate | 1 | 69583 | 1 | 3.360 | 20709.2 |
| 332 | 2024-10-26 01:24:10 | hastate | 1 | 69583 | 1 | 8.850 | 7862.5 |
| 331 | 2024-10-11 13:23:22 | hastate | 1 | 69583 | 1 | 3.110 | 22374.0 |
| 330 | 2024-09-25 16:18:23 | hastate | 1 | 69583 | 1 | 5.156 | 13495.5 |
| 329 | 2024-09-24 07:29:35 | hastate | 1 | 69583 | 1 | 9.326 | 7461.2 |
| 328 | 2024-09-09 14:53:12 | hastate | 1 | 69583 | 1 | 5.326 | 13064.8 |
| 327 | 2024-09-09 10:23:18 | hastate | 1 | 69583 | 1 | 5.390 | 12909.6 |
| 326 | 2024-08-22 16:32:42 | hastate | 1 | 69583 | 1 | 7.673 | 9068.6 |
| 325 | 2024-08-14 09:57:39 | hastate | 1 | 69583 | 1 | 9.440 | 7371.1 |
| 324 | 2024-08-04 17:43:50 | hastate | 1 | 69583 | 1 | 2.580 | 26970.2 |
| 323 | 2024-08-03 08:03:13 | hastate | 1 | 69583 | 1 | 6.266 | 11104.9 |
| 322 | 2024-08-03 05:00:43 | hastate | 1 | 69583 | 1 | 5.780 | 12038.6 |
| 321 | 2024-07-28 22:07:18 | hastate | 1 | 69583 | 1 | 4.046 | 17198.0 |
| 320 | 2024-07-15 18:01:55 | hastate | 1 | 69583 | 1 | 5.936 | 11722.2 |
| 319 | 2024-07-07 19:29:44 | hastate | 3 | 134027 | 279 | 27.033 | 4957.9 |
| 318 | 2024-07-06 13:10:10 | hastate | 3 | 134027 | 279 | 24.970 | 5367.5 |
| 317 | 2024-07-06 13:08:50 | hastate | 3 | 134027 | 279 | 33.766 | 3969.3 |
| 316 | 2024-07-06 13:05:31 | hastate | 1 | 69583 | 1 | 5.936 | 11722.2 |
| 315 | 2024-07-03 01:16:41 | hastate | 3 | 134027 | 279 | 18.063 | 7420.0 |
| 314 | 2024-07-02 18:03:33 | hastate | 3 | 134027 | 279 | 28.296 | 4736.6 |
| 313 | 2024-07-02 17:07:37 | hastate | 3 | 134027 | 279 | 28.736 | 4664.1 |
| 312 | 2024-07-02 04:15:39 | hastate | 3 | 134027 | 279 | 15.483 | 8656.4 |
| 311 | 2024-07-02 04:15:41 | hastate | 2 | 107671 | 21 | 12.936 | 8323.4 |
| 310 | 2024-07-02 04:12:34 | hastate | 1 | 69583 | 1 | 2.936 | 23699.9 |
| 309 | 2024-07-01 15:38:30 | hastate | 1 | 69583 | 1 | 4.453 | 15626.1 |
| 308 | 2024-07-01 15:26:47 | hastate | 1 | 69583 | 1 | 4.453 | 15626.1 |
| 307 | 2024-06-24 03:24:13 | hastate | 1 | 69583 | 1 | 2.296 | 30306.2 |
| 306 | 2024-06-23 09:04:54 | hastate | 1 | 69583 | 1 | 5.326 | 13064.8 |
| 305 | 2024-06-20 00:53:03 | hastate | 1 | 69583 | 1 | 4.690 | 14836.5 |
| 304 | 2024-06-11 23:01:35 | hastate | 1 | 69583 | 1 | 4.453 | 15626.1 |
| 303 | 2024-06-06 02:24:16 | hastate | 1 | 69583 | 1 | 6.766 | 10284.2 |
| 302 | 2024-05-21 20:25:29 | hastate | 1 | 69583 | 1 | 4.310 | 16144.5 |
| 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 |