History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"byroads"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 408 | 2025-07-19 04:27:26 | byroads | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 407 | 2025-07-13 19:06:13 | byroads | 1 | 69583 | 3 | 5.516 | 12614.8 |
| 406 | 2025-07-10 04:20:15 | byroads | 1 | 69583 | 3 | 3.516 | 19790.4 |
| 405 | 2025-06-25 12:50:24 | byroads | 1 | 69583 | 3 | 1.703 | 40859.1 |
| 404 | 2025-06-23 08:58:10 | byroads | 2 | 107671 | 11 | 4.716 | 22831.0 |
| 403 | 2025-06-21 18:54:42 | byroads | 2 | 107671 | 11 | 10.266 | 10488.1 |
| 402 | 2025-06-20 19:31:59 | byroads | 1 | 69583 | 3 | 6.033 | 11533.7 |
| 401 | 2025-06-15 09:11:05 | byroads | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 400 | 2025-06-15 00:09:50 | byroads | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 399 | 2025-06-12 09:26:41 | byroads | 2 | 107671 | 11 | 20.923 | 5146.1 |
| 398 | 2025-06-12 01:31:14 | byroads | 1 | 69583 | 3 | 7.780 | 8943.8 |
| 397 | 2025-06-08 09:41:36 | byroads | 2 | 107671 | 11 | 15.733 | 6843.6 |
| 396 | 2025-06-06 22:42:36 | byroads | 1 | 69583 | 3 | 5.453 | 12760.5 |
| 395 | 2025-06-06 04:03:58 | byroads | 3 | 134027 | 182 | 56.280 | 2381.4 |
| 394 | 2025-06-05 00:16:37 | byroads | 3 | 134027 | 182 | 36.783 | 3643.7 |
| 393 | 2025-06-04 17:58:29 | byroads | 2 | 107671 | 11 | 16.283 | 6612.5 |
| 392 | 2025-06-03 23:10:31 | byroads | 1 | 69583 | 3 | 3.653 | 19048.2 |
| 391 | 2025-06-03 22:51:32 | byroads | 3 | 134027 | 182 | 32.826 | 4083.0 |
| 390 | 2025-06-03 13:42:20 | byroads | 1 | 69583 | 3 | 2.296 | 30306.2 |
| 389 | 2025-05-24 22:23:48 | byroads | 2 | 107671 | 11 | 19.500 | 5521.6 |
| 388 | 2025-05-23 17:13:41 | byroads | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 387 | 2025-05-18 16:04:00 | byroads | 1 | 69583 | 3 | 8.143 | 8545.1 |
| 386 | 2025-05-16 13:22:41 | byroads | 1 | 69583 | 3 | 5.063 | 13743.4 |
| 385 | 2025-05-07 09:05:54 | byroads | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 384 | 2025-05-02 14:01:06 | byroads | 1 | 69583 | 3 | 3.530 | 19711.9 |
| 383 | 2025-04-30 01:48:17 | byroads | 3 | 134027 | 182 | 28.516 | 4700.1 |
| 382 | 2025-04-27 22:09:12 | byroads | 3 | 134027 | 182 | 35.500 | 3775.4 |
| 381 | 2025-04-26 16:25:32 | byroads | 3 | 134027 | 182 | 28.143 | 4762.4 |
| 380 | 2025-04-25 23:55:34 | byroads | 1 | 69583 | 3 | 6.140 | 11332.7 |
| 379 | 2025-04-25 09:11:10 | byroads | 3 | 134027 | 182 | 6.720 | 19944.5 |
| 378 | 2025-04-23 16:18:41 | byroads | 1 | 69583 | 3 | 5.156 | 13495.5 |
| 377 | 2025-04-22 03:14:57 | byroads | 1 | 69583 | 3 | 4.766 | 14599.9 |
| 376 | 2025-04-14 12:58:02 | byroads | 1 | 69583 | 3 | 8.093 | 8597.9 |
| 375 | 2025-04-12 16:01:46 | byroads | 1 | 69583 | 3 | 5.266 | 13213.6 |
| 374 | 2025-04-05 17:35:16 | byroads | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 373 | 2025-04-04 09:36:56 | byroads | 1 | 69583 | 3 | 3.326 | 20920.9 |
| 372 | 2025-03-23 16:46:44 | byroads | 1 | 69583 | 3 | 5.673 | 12265.6 |
| 371 | 2025-03-20 18:14:43 | byroads | 1 | 69583 | 3 | 3.453 | 20151.5 |
| 370 | 2025-03-14 03:43:45 | byroads | 3 | 134027 | 182 | 39.423 | 3399.7 |
| 369 | 2025-03-12 20:52:47 | byroads | 1 | 69583 | 3 | 5.000 | 13916.6 |
| 368 | 2025-03-12 19:00:40 | byroads | 3 | 134027 | 182 | 29.080 | 4608.9 |
| 367 | 2025-03-12 19:00:37 | byroads | 2 | 107671 | 11 | 16.096 | 6689.3 |
| 366 | 2025-03-12 08:23:33 | byroads | 3 | 134027 | 182 | 29.390 | 4560.3 |
| 365 | 2025-03-12 08:23:34 | byroads | 2 | 107671 | 11 | 13.706 | 7855.8 |
| 364 | 2025-03-12 08:22:59 | byroads | 1 | 69583 | 3 | 2.563 | 27149.0 |
| 363 | 2025-03-06 02:29:18 | byroads | 1 | 69583 | 3 | 8.190 | 8496.1 |
| 362 | 2025-03-05 21:29:17 | byroads | 1 | 69583 | 3 | 2.203 | 31585.6 |
| 361 | 2025-02-27 08:22:05 | byroads | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 360 | 2025-02-23 20:49:05 | byroads | 3 | 134027 | 182 | 40.176 | 3336.0 |
| 359 | 2025-02-21 11:09:22 | byroads | 3 | 134027 | 182 | 38.600 | 3472.2 |
| 358 | 2025-02-21 02:24:07 | byroads | 3 | 134027 | 182 | 34.706 | 3861.8 |
| 357 | 2025-02-21 02:24:08 | byroads | 2 | 107671 | 11 | 16.626 | 6476.1 |
| 356 | 2025-02-21 02:22:34 | byroads | 1 | 69583 | 3 | 3.373 | 20629.4 |
| 355 | 2025-02-07 03:23:02 | byroads | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 354 | 2025-01-27 16:03:55 | byroads | 1 | 69583 | 3 | 5.423 | 12831.1 |
| 353 | 2025-01-20 19:34:37 | byroads | 3 | 134027 | 182 | 30.656 | 4372.0 |
| 352 | 2025-01-19 21:35:44 | byroads | 3 | 134027 | 182 | 41.690 | 3214.8 |
| 351 | 2025-01-19 05:30:34 | byroads | 3 | 134027 | 182 | 18.300 | 7323.9 |
| 350 | 2025-01-09 23:44:57 | byroads | 1 | 69583 | 3 | 5.593 | 12441.1 |
| 349 | 2025-01-06 01:40:36 | byroads | 1 | 69583 | 3 | 7.673 | 9068.6 |
| 348 | 2024-12-25 10:15:03 | byroads | 3 | 134027 | 182 | 29.783 | 4500.1 |
| 347 | 2024-12-25 07:57:48 | byroads | 3 | 134027 | 182 | 32.860 | 4078.7 |
| 346 | 2024-12-25 07:57:49 | byroads | 2 | 107671 | 11 | 17.236 | 6246.9 |
| 345 | 2024-12-25 07:57:33 | byroads | 1 | 69583 | 3 | 3.640 | 19116.2 |
| 344 | 2024-12-13 15:27:29 | byroads | 3 | 134027 | 182 | 32.580 | 4113.8 |
| 343 | 2024-12-13 07:14:42 | byroads | 3 | 134027 | 182 | 40.953 | 3272.7 |
| 342 | 2024-12-10 19:31:41 | byroads | 1 | 69583 | 3 | 4.563 | 15249.4 |
| 341 | 2024-12-10 01:01:24 | byroads | 1 | 69583 | 3 | 4.830 | 14406.4 |
| 340 | 2024-12-02 12:22:00 | byroads | 1 | 69583 | 3 | 5.253 | 13246.3 |
| 339 | 2024-11-26 18:55:10 | byroads | 2 | 107671 | 11 | 3.170 | 33965.6 |
| 338 | 2024-11-26 18:54:57 | byroads | 3 | 134027 | 182 | 7.766 | 17258.2 |
| 337 | 2024-11-23 12:31:06 | byroads | 3 | 134027 | 182 | 33.503 | 4000.4 |
| 336 | 2024-11-23 12:31:06 | byroads | 2 | 107671 | 11 | 22.596 | 4765.0 |
| 335 | 2024-11-23 12:30:43 | byroads | 1 | 69583 | 3 | 3.046 | 22844.1 |
| 334 | 2024-10-30 01:56:54 | byroads | 1 | 69583 | 3 | 5.470 | 12720.8 |
| 333 | 2024-10-22 09:17:37 | byroads | 1 | 69583 | 3 | 5.343 | 13023.2 |
| 332 | 2024-10-07 06:13:20 | byroads | 1 | 69583 | 3 | 10.110 | 6882.6 |
| 331 | 2024-09-22 07:27:40 | byroads | 1 | 69583 | 3 | 10.360 | 6716.5 |
| 330 | 2024-09-11 13:10:03 | byroads | 1 | 69583 | 3 | 8.220 | 8465.1 |
| 329 | 2024-09-06 10:40:30 | byroads | 1 | 69583 | 3 | 13.186 | 5277.0 |
| 328 | 2024-08-15 05:07:42 | byroads | 1 | 69583 | 3 | 8.436 | 8248.3 |
| 327 | 2024-08-10 08:34:52 | byroads | 1 | 69583 | 3 | 2.373 | 29322.8 |
| 326 | 2024-07-30 12:07:02 | byroads | 3 | 134027 | 182 | 12.453 | 10762.6 |
| 325 | 2024-07-30 03:59:56 | byroads | 1 | 69583 | 3 | 3.796 | 18330.6 |
| 324 | 2024-07-29 20:58:57 | byroads | 3 | 134027 | 182 | 26.143 | 5126.7 |
| 323 | 2024-07-29 17:01:04 | byroads | 3 | 134027 | 182 | 27.783 | 4824.1 |
| 322 | 2024-07-29 14:04:10 | byroads | 3 | 134027 | 182 | 13.516 | 9916.2 |
| 321 | 2024-07-29 14:04:11 | byroads | 2 | 107671 | 11 | 3.313 | 32499.5 |
| 320 | 2024-07-26 09:01:39 | byroads | 1 | 69583 | 3 | 1.986 | 35036.8 |
| 319 | 2024-07-16 17:51:43 | byroads | 1 | 69583 | 3 | 4.106 | 16946.7 |
| 318 | 2024-07-16 17:40:41 | byroads | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 317 | 2024-07-11 04:14:30 | byroads | 2 | 107671 | 11 | 5.733 | 18780.9 |
| 316 | 2024-07-11 04:13:55 | byroads | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 315 | 2024-07-11 02:52:32 | byroads | 1 | 69583 | 3 | 4.280 | 16257.7 |
| 314 | 2024-07-06 21:35:06 | byroads | 1 | 69583 | 3 | 2.530 | 27503.2 |
| 313 | 2024-07-06 11:20:28 | byroads | 1 | 69583 | 3 | 4.780 | 14557.1 |
| 312 | 2024-06-29 23:46:44 | byroads | 1 | 69583 | 3 | 5.530 | 12582.8 |
| 311 | 2024-06-29 05:03:45 | byroads | 3 | 134027 | 182 | 19.453 | 6889.8 |
| 310 | 2024-06-28 06:28:05 | byroads | 3 | 134027 | 182 | 17.580 | 7623.8 |
| 309 | 2024-06-28 05:53:13 | byroads | 3 | 134027 | 182 | 35.983 | 3724.7 |