History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"zonetime"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 507 | 2024-04-23 03:20:25 | zonetime | 1 | 82945 | 3 | 1.813 | 45750.1 |
| 506 | 2024-04-23 03:20:08 | zonetime | 2 | 121059 | 8 | 3.673 | 32959.2 |
| 505 | 2024-04-20 04:09:26 | zonetime | 4 | 161609 | 438 | 43.816 | 3688.4 |
| 504 | 2024-04-19 16:12:23 | zonetime | 4 | 161609 | 438 | 28.066 | 5758.2 |
| 503 | 2024-04-19 16:12:23 | zonetime | 3 | 146162 | 43 | 28.236 | 5176.4 |
| 502 | 2024-04-19 16:12:25 | zonetime | 2 | 121059 | 8 | 13.766 | 8794.1 |
| 501 | 2024-04-19 14:44:28 | zonetime | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 500 | 2024-04-05 22:27:49 | zonetime | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 499 | 2024-04-01 09:30:40 | zonetime | 2 | 121059 | 8 | 5.953 | 20335.8 |
| 498 | 2024-04-01 09:30:39 | zonetime | 1 | 82945 | 3 | 2.346 | 35355.9 |
| 497 | 2024-03-31 21:10:31 | zonetime | 4 | 161609 | 438 | 44.483 | 3633.1 |
| 496 | 2024-03-31 21:10:32 | zonetime | 3 | 146162 | 43 | 17.360 | 8419.5 |
| 495 | 2024-03-31 00:30:35 | zonetime | 1 | 82945 | 3 | 3.233 | 25655.7 |
| 494 | 2024-03-29 09:06:02 | zonetime | 3 | 146162 | 43 | 22.800 | 6410.6 |
| 493 | 2024-03-29 04:49:38 | zonetime | 4 | 161609 | 438 | 25.516 | 6333.6 |
| 492 | 2024-03-29 04:45:35 | zonetime | 4 | 161609 | 438 | 35.863 | 4506.3 |
| 491 | 2024-03-29 04:45:37 | zonetime | 3 | 146162 | 43 | 24.406 | 5988.8 |
| 490 | 2024-03-29 04:45:38 | zonetime | 2 | 121059 | 8 | 8.656 | 13985.6 |
| 489 | 2024-03-29 04:45:31 | zonetime | 1 | 82945 | 3 | 2.643 | 31382.9 |
| 488 | 2024-03-11 18:41:08 | zonetime | 3 | 146162 | 43 | 17.890 | 8170.0 |
| 487 | 2024-03-11 18:41:09 | zonetime | 2 | 121059 | 8 | 4.203 | 28803.0 |
| 486 | 2024-03-11 01:40:00 | zonetime | 2 | 121059 | 8 | 8.656 | 13985.6 |
| 485 | 2024-03-10 23:03:56 | zonetime | 3 | 146162 | 43 | 7.440 | 19645.4 |
| 484 | 2024-03-10 12:31:59 | zonetime | 4 | 161609 | 438 | 39.910 | 4049.3 |
| 483 | 2024-03-10 12:32:07 | zonetime | 3 | 146162 | 43 | 17.783 | 8219.2 |
| 482 | 2024-03-10 12:31:59 | zonetime | 2 | 121059 | 8 | 9.296 | 13022.7 |
| 481 | 2024-03-10 12:28:44 | zonetime | 1 | 82945 | 3 | 3.343 | 24811.5 |
| 480 | 2024-03-02 06:21:41 | zonetime | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 479 | 2024-03-01 19:09:24 | zonetime | 3 | 146162 | 43 | 16.690 | 8757.5 |
| 478 | 2024-03-01 19:09:24 | zonetime | 2 | 121059 | 8 | 8.140 | 14872.1 |
| 477 | 2024-03-01 19:09:21 | zonetime | 1 | 82945 | 3 | 4.220 | 19655.2 |
| 476 | 2024-02-29 22:09:41 | zonetime | 4 | 161609 | 438 | 27.423 | 5893.2 |
| 475 | 2024-02-29 16:20:28 | zonetime | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 474 | 2024-02-29 00:05:33 | zonetime | 4 | 161609 | 438 | 13.873 | 11649.2 |
| 473 | 2024-02-26 11:01:39 | zonetime | 2 | 121059 | 8 | 7.406 | 16346.1 |
| 472 | 2024-02-26 11:01:30 | zonetime | 1 | 82945 | 3 | 2.846 | 29144.4 |
| 471 | 2024-02-25 22:15:02 | zonetime | 4 | 161609 | 438 | 35.113 | 4602.5 |
| 470 | 2024-02-23 06:24:44 | zonetime | 4 | 161609 | 438 | 16.453 | 9822.5 |
| 469 | 2024-02-23 02:18:34 | zonetime | 3 | 146162 | 43 | 7.250 | 20160.3 |
| 468 | 2024-02-23 02:18:33 | zonetime | 2 | 121059 | 8 | 3.796 | 31891.2 |
| 467 | 2024-01-31 18:16:48 | zonetime | 1 | 82945 | 3 | 2.033 | 40799.3 |
| 466 | 2024-01-24 23:50:55 | zonetime | 2 | 121059 | 8 | 3.313 | 36540.6 |
| 465 | 2024-01-19 03:48:59 | zonetime | 1 | 82945 | 3 | 1.310 | 63316.8 |
| 464 | 2024-01-15 16:29:29 | zonetime | 3 | 146162 | 43 | 7.016 | 20832.7 |
| 463 | 2023-12-31 01:40:15 | zonetime | 3 | 146162 | 43 | 6.220 | 23498.7 |
| 462 | 2023-12-30 03:48:58 | zonetime | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 461 | 2023-12-25 09:39:42 | zonetime | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 460 | 2023-12-09 12:50:12 | zonetime | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 459 | 2023-11-23 02:47:01 | zonetime | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 458 | 2023-11-12 16:52:19 | zonetime | 3 | 146162 | 43 | 6.580 | 22213.1 |
| 457 | 2023-11-05 00:48:19 | zonetime | 2 | 121059 | 8 | 3.156 | 38358.4 |
| 456 | 2023-10-25 13:35:44 | zonetime | 3 | 146162 | 43 | 7.313 | 19986.6 |
| 455 | 2023-10-11 18:55:15 | zonetime | 1 | 82945 | 3 | 2.733 | 30349.4 |
| 454 | 2023-09-25 09:06:48 | zonetime | 1 | 82945 | 3 | 1.216 | 68211.3 |
| 453 | 2023-08-10 01:05:26 | zonetime | 2 | 121059 | 8 | 3.326 | 36397.8 |
| 452 | 2023-08-04 10:36:34 | zonetime | 3 | 146162 | 43 | 6.050 | 24159.0 |
| 451 | 2023-05-12 11:11:59 | zonetime | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 450 | 2023-04-22 18:43:19 | zonetime | 2 | 121059 | 8 | 3.500 | 34588.3 |
| 449 | 2023-04-11 03:46:30 | zonetime | 3 | 146162 | 43 | 6.050 | 24159.0 |
| 448 | 2023-01-29 18:47:00 | zonetime | 2 | 121059 | 8 | 6.096 | 19858.8 |
| 447 | 2023-01-16 13:13:24 | zonetime | 3 | 146162 | 43 | 6.626 | 22058.9 |
| 446 | 2022-12-31 14:10:43 | zonetime | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 445 | 2022-11-11 18:14:32 | zonetime | 2 | 121059 | 8 | 3.123 | 38763.7 |
| 444 | 2022-10-28 14:25:03 | zonetime | 3 | 146162 | 43 | 6.030 | 24239.1 |
| 443 | 2022-10-04 17:19:39 | zonetime | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 442 | 2022-08-07 05:55:40 | zonetime | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 441 | 2022-08-03 22:25:53 | zonetime | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 440 | 2022-05-30 05:06:26 | zonetime | 3 | 146162 | 43 | 6.080 | 24039.8 |
| 439 | 2022-05-24 04:47:37 | zonetime | 1 | 82945 | 3 | 1.250 | 66356.0 |
| 438 | 2022-05-07 21:46:08 | zonetime | 2 | 121059 | 8 | 3.060 | 39561.8 |
| 437 | 2022-03-11 21:15:08 | zonetime | 3 | 146162 | 43 | 6.890 | 21213.6 |
| 436 | 2022-03-03 21:15:17 | zonetime | 3 | 146162 | 43 | 6.420 | 22766.7 |
| 435 | 2022-02-24 15:51:51 | zonetime | 3 | 146162 | 43 | 7.720 | 18932.9 |
| 434 | 2022-02-23 22:03:05 | zonetime | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 433 | 2022-02-22 21:00:13 | zonetime | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 432 | 2022-02-21 17:22:10 | zonetime | 3 | 146162 | 43 | 6.170 | 23689.1 |
| 431 | 2022-02-20 21:37:24 | zonetime | 3 | 146162 | 43 | 9.516 | 15359.6 |
| 430 | 2022-02-19 18:04:58 | zonetime | 3 | 146162 | 43 | 7.050 | 20732.2 |
| 429 | 2022-02-18 16:52:42 | zonetime | 3 | 146162 | 43 | 8.123 | 17993.6 |
| 428 | 2022-02-17 20:48:11 | zonetime | 3 | 146162 | 43 | 6.860 | 21306.4 |
| 427 | 2022-02-15 22:32:11 | zonetime | 3 | 146162 | 43 | 6.110 | 23921.8 |
| 426 | 2022-02-10 12:57:53 | zonetime | 3 | 146162 | 43 | 7.313 | 19986.6 |
| 425 | 2022-02-09 21:53:47 | zonetime | 3 | 146162 | 43 | 7.436 | 19656.0 |
| 424 | 2022-02-08 21:53:03 | zonetime | 3 | 146162 | 43 | 7.483 | 19532.5 |
| 423 | 2022-02-07 23:53:35 | zonetime | 3 | 146162 | 43 | 7.093 | 20606.5 |
| 422 | 2022-01-21 20:09:43 | zonetime | 3 | 146162 | 43 | 8.610 | 16975.8 |
| 421 | 2022-01-20 18:29:14 | zonetime | 3 | 146162 | 43 | 6.846 | 21350.0 |
| 420 | 2022-01-17 22:09:49 | zonetime | 3 | 146162 | 43 | 6.466 | 22604.7 |
| 419 | 2021-12-31 21:55:17 | zonetime | 3 | 146162 | 43 | 13.516 | 10814.0 |
| 418 | 2021-12-30 22:34:07 | zonetime | 3 | 146162 | 43 | 7.873 | 18565.0 |
| 417 | 2021-12-29 20:42:39 | zonetime | 3 | 146162 | 43 | 6.580 | 22213.1 |
| 416 | 2021-12-28 21:38:17 | zonetime | 3 | 146162 | 43 | 8.173 | 17883.5 |
| 415 | 2021-12-27 19:48:17 | zonetime | 3 | 146162 | 43 | 7.000 | 20880.3 |
| 414 | 2021-12-26 19:29:57 | zonetime | 3 | 146162 | 43 | 6.190 | 23612.6 |
| 413 | 2021-12-25 14:26:51 | zonetime | 3 | 146162 | 43 | 6.420 | 22766.7 |
| 412 | 2021-12-24 14:56:16 | zonetime | 3 | 146162 | 43 | 7.376 | 19815.9 |
| 411 | 2021-12-11 16:09:11 | zonetime | 3 | 146162 | 43 | 6.280 | 23274.2 |
| 410 | 2021-12-11 08:10:36 | zonetime | 3 | 146162 | 43 | 6.686 | 21860.9 |
| 409 | 2021-12-11 00:02:34 | zonetime | 3 | 146162 | 43 | 6.953 | 21021.4 |
| 408 | 2021-12-10 17:05:09 | zonetime | 3 | 146162 | 43 | 7.206 | 20283.4 |