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 |
| 397 | 2025-12-27 15:41:49 | prefectural | 1 | 49908 | 1 | 0.953 | 52369.4 |
| 396 | 2025-12-05 04:34:56 | prefectural | 4 | 148819 | 35 | 10.660 | 13960.5 |
| 395 | 2025-12-01 01:51:18 | prefectural | 4 | 148819 | 35 | 8.970 | 16590.7 |
| 394 | 2025-10-20 15:50:26 | prefectural | 1 | 49908 | 1 | 5.750 | 8679.7 |
| 393 | 2025-10-20 15:50:17 | prefectural | 1 | 49908 | 1 | 6.343 | 7868.2 |
| 392 | 2025-10-20 15:50:11 | prefectural | 1 | 49908 | 1 | 3.656 | 13651.0 |
| 391 | 2025-10-20 15:50:08 | prefectural | 1 | 49908 | 1 | 5.893 | 8469.0 |
| 390 | 2025-09-12 23:11:58 | prefectural | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 389 | 2025-08-28 16:28:15 | prefectural | 2 | 86808 | 3 | 2.953 | 29396.5 |
| 388 | 2025-08-23 10:00:03 | prefectural | 4 | 148819 | 35 | 51.266 | 2902.9 |
| 387 | 2025-08-18 19:33:50 | prefectural | 4 | 148819 | 35 | 50.300 | 2958.6 |
| 386 | 2025-08-15 16:11:35 | prefectural | 4 | 148819 | 35 | 31.253 | 4761.8 |
| 385 | 2025-08-15 14:22:07 | prefectural | 1 | 49908 | 1 | 1.986 | 25129.9 |
| 384 | 2025-08-10 20:28:45 | prefectural | 1 | 49908 | 1 | 1.986 | 25129.9 |
| 383 | 2025-08-10 12:13:28 | prefectural | 1 | 49908 | 1 | 2.190 | 22789.0 |
| 382 | 2025-08-09 02:43:44 | prefectural | 1 | 49908 | 1 | 6.096 | 8187.0 |
| 381 | 2025-07-30 10:43:04 | prefectural | 1 | 49908 | 1 | 2.313 | 21577.2 |
| 380 | 2025-07-27 12:41:27 | prefectural | 4 | 148819 | 35 | 34.313 | 4337.1 |
| 379 | 2025-07-27 02:03:47 | prefectural | 1 | 49908 | 1 | 2.750 | 18148.4 |
| 378 | 2025-07-22 19:08:52 | prefectural | 1 | 49908 | 1 | 2.673 | 18671.2 |
| 377 | 2025-07-19 06:21:30 | prefectural | 1 | 49908 | 1 | 0.953 | 52369.4 |
| 376 | 2025-07-19 05:02:11 | prefectural | 1 | 49908 | 1 | 0.873 | 57168.4 |
| 375 | 2025-07-16 01:55:05 | prefectural | 1 | 49908 | 1 | 3.156 | 15813.7 |
| 374 | 2025-07-12 05:07:26 | prefectural | 1 | 49908 | 1 | 1.733 | 28798.6 |
| 373 | 2025-07-10 17:37:57 | prefectural | 1 | 49908 | 1 | 3.936 | 12679.9 |
| 372 | 2025-06-30 01:18:20 | prefectural | 1 | 49908 | 1 | 6.170 | 8088.8 |
| 371 | 2025-06-26 10:59:19 | prefectural | 1 | 49908 | 1 | 6.703 | 7445.6 |
| 370 | 2025-06-22 05:51:55 | prefectural | 1 | 49908 | 1 | 7.970 | 6262.0 |
| 369 | 2025-06-07 22:02:53 | prefectural | 1 | 49908 | 1 | 8.343 | 5982.0 |
| 368 | 2025-05-18 10:18:58 | prefectural | 4 | 148819 | 35 | 61.816 | 2407.5 |
| 367 | 2025-05-17 20:07:31 | prefectural | 4 | 148819 | 35 | 51.376 | 2896.7 |
| 366 | 2025-05-10 05:01:39 | prefectural | 4 | 148819 | 35 | 45.160 | 3295.4 |
| 365 | 2025-05-07 13:22:41 | prefectural | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 364 | 2025-05-05 03:56:24 | prefectural | 4 | 148819 | 35 | 10.690 | 13921.3 |
| 363 | 2025-05-03 18:16:00 | prefectural | 1 | 49908 | 1 | 0.906 | 55086.1 |
| 362 | 2025-05-01 10:26:22 | prefectural | 4 | 148819 | 35 | 9.110 | 16335.8 |
| 361 | 2025-04-16 09:59:50 | prefectural | 1 | 49908 | 1 | 5.890 | 8473.3 |
| 360 | 2025-04-11 15:18:44 | prefectural | 4 | 148819 | 35 | 44.813 | 3320.9 |
| 359 | 2025-04-09 17:00:43 | prefectural | 4 | 148819 | 35 | 67.316 | 2210.8 |
| 358 | 2025-04-02 06:59:39 | prefectural | 4 | 148819 | 35 | 38.516 | 3863.8 |
| 357 | 2025-04-02 06:44:43 | prefectural | 4 | 148819 | 35 | 32.830 | 4533.0 |
| 356 | 2025-04-02 03:21:03 | prefectural | 4 | 148819 | 35 | 58.016 | 2565.1 |
| 355 | 2025-03-30 03:31:34 | prefectural | 5 | 164607 | 227 | 13.140 | 12527.2 |
| 354 | 2025-03-29 14:06:58 | prefectural | 1 | 49908 | 1 | 3.640 | 13711.0 |
| 353 | 2025-03-29 10:19:55 | prefectural | 3 | 121633 | 7 | 22.440 | 5420.4 |
| 352 | 2025-03-29 00:44:01 | prefectural | 1 | 49908 | 1 | 4.500 | 11090.7 |
| 351 | 2025-03-28 02:02:59 | prefectural | 4 | 148819 | 35 | 7.936 | 18752.4 |
| 350 | 2025-03-27 06:59:17 | prefectural | 4 | 148819 | 35 | 56.723 | 2623.6 |
| 349 | 2025-03-16 01:59:52 | prefectural | 1 | 49908 | 1 | 3.500 | 14259.4 |
| 348 | 2025-03-13 03:54:55 | prefectural | 1 | 49908 | 1 | 3.923 | 12721.9 |
| 347 | 2025-03-12 07:59:49 | prefectural | 4 | 148819 | 35 | 48.516 | 3067.4 |
| 346 | 2025-03-07 23:42:29 | prefectural | 1 | 49908 | 1 | 3.470 | 14382.7 |
| 345 | 2025-03-02 09:12:59 | prefectural | 4 | 148819 | 35 | 60.180 | 2472.9 |
| 344 | 2025-02-10 07:41:47 | prefectural | 3 | 121633 | 7 | 25.266 | 4814.1 |
| 343 | 2025-02-10 07:41:44 | prefectural | 2 | 86808 | 3 | 11.953 | 7262.4 |
| 342 | 2025-02-10 07:38:47 | prefectural | 4 | 148819 | 35 | 51.846 | 2870.4 |
| 341 | 2025-02-10 07:28:13 | prefectural | 1 | 49908 | 1 | 0.903 | 55269.1 |
| 340 | 2025-02-10 03:13:29 | prefectural | 3 | 121633 | 7 | 19.076 | 6376.2 |
| 339 | 2025-02-10 03:13:27 | prefectural | 2 | 86808 | 3 | 6.000 | 14468.0 |
| 338 | 2025-02-10 02:05:51 | prefectural | 1 | 49908 | 1 | 0.856 | 58303.7 |
| 337 | 2025-02-09 19:51:44 | prefectural | 4 | 148819 | 35 | 49.690 | 2994.9 |
| 336 | 2025-02-08 09:07:35 | prefectural | 4 | 148819 | 35 | 52.736 | 2822.0 |
| 335 | 2025-02-03 23:01:53 | prefectural | 4 | 148819 | 35 | 52.660 | 2826.0 |
| 334 | 2025-01-31 12:44:25 | prefectural | 1 | 49908 | 1 | 6.013 | 8300.0 |
| 333 | 2025-01-30 08:06:54 | prefectural | 1 | 49908 | 1 | 2.233 | 22350.2 |
| 332 | 2025-01-30 08:03:46 | prefectural | 4 | 148819 | 35 | 38.833 | 3832.3 |
| 331 | 2025-01-09 04:17:12 | prefectural | 2 | 86808 | 3 | 16.580 | 5235.7 |
| 330 | 2025-01-09 04:14:26 | prefectural | 3 | 121633 | 7 | 27.000 | 4504.9 |
| 329 | 2025-01-09 04:14:10 | prefectural | 1 | 49908 | 1 | 3.593 | 13890.3 |
| 328 | 2025-01-05 03:58:44 | prefectural | 3 | 121633 | 7 | 32.346 | 3760.4 |
| 327 | 2025-01-05 03:58:47 | prefectural | 2 | 86808 | 3 | 5.826 | 14900.1 |
| 326 | 2025-01-05 03:56:28 | prefectural | 1 | 49908 | 1 | 5.423 | 9203.0 |
| 325 | 2025-01-02 13:45:58 | prefectural | 3 | 121633 | 7 | 26.190 | 4644.3 |
| 324 | 2025-01-02 13:45:49 | prefectural | 2 | 86808 | 3 | 12.656 | 6859.0 |
| 323 | 2025-01-01 13:44:41 | prefectural | 4 | 148819 | 35 | 49.706 | 2994.0 |
| 322 | 2025-01-01 10:59:42 | prefectural | 4 | 148819 | 35 | 55.126 | 2699.6 |
| 321 | 2025-01-01 09:40:53 | prefectural | 5 | 164607 | 227 | 125.926 | 1307.2 |
| 320 | 2025-01-01 09:41:10 | prefectural | 4 | 148819 | 35 | 51.783 | 2873.9 |
| 319 | 2025-01-01 09:41:17 | prefectural | 3 | 121633 | 7 | 27.673 | 4395.4 |
| 318 | 2025-01-01 09:41:31 | prefectural | 2 | 86808 | 3 | 12.063 | 7196.2 |
| 317 | 2025-01-01 09:37:32 | prefectural | 1 | 49908 | 1 | 3.500 | 14259.4 |
| 316 | 2024-12-29 12:21:29 | prefectural | 4 | 148819 | 35 | 10.123 | 14701.1 |
| 315 | 2024-11-19 17:35:43 | prefectural | 4 | 148819 | 35 | 37.970 | 3919.4 |
| 314 | 2024-11-18 10:20:08 | prefectural | 4 | 148819 | 35 | 51.490 | 2890.3 |
| 313 | 2024-11-16 08:27:21 | prefectural | 4 | 148819 | 35 | 26.266 | 5665.8 |
| 312 | 2024-11-16 08:27:22 | prefectural | 3 | 121633 | 7 | 20.716 | 5871.5 |
| 311 | 2024-11-16 08:27:23 | prefectural | 2 | 86808 | 3 | 6.376 | 13614.8 |
| 310 | 2024-11-16 08:10:39 | prefectural | 4 | 148819 | 35 | 53.486 | 2782.4 |
| 309 | 2024-11-16 07:20:12 | prefectural | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 308 | 2024-11-15 23:36:42 | prefectural | 4 | 148819 | 35 | 47.743 | 3117.1 |
| 307 | 2024-11-15 23:36:44 | prefectural | 2 | 86808 | 3 | 12.156 | 7141.2 |
| 306 | 2024-11-15 23:23:51 | prefectural | 1 | 49908 | 1 | 1.903 | 26226.0 |
| 305 | 2024-11-13 12:39:55 | prefectural | 2 | 86808 | 3 | 18.530 | 4684.7 |
| 304 | 2024-11-13 12:39:05 | prefectural | 4 | 148819 | 35 | 47.236 | 3150.5 |
| 303 | 2024-11-13 12:36:54 | prefectural | 1 | 49908 | 1 | 1.733 | 28798.6 |
| 302 | 2024-11-05 23:01:49 | prefectural | 3 | 121633 | 7 | 15.050 | 8081.9 |
| 301 | 2024-11-01 11:37:31 | prefectural | 2 | 86808 | 3 | 13.250 | 6551.5 |
| 300 | 2024-11-01 11:37:22 | prefectural | 3 | 121633 | 7 | 19.500 | 6237.6 |
| 299 | 2024-11-01 11:36:05 | prefectural | 1 | 49908 | 1 | 3.160 | 15793.7 |
| 298 | 2024-10-22 08:39:15 | prefectural | 4 | 148819 | 35 | 48.533 | 3066.3 |