History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nearest"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 592 | 2024-04-28 01:45:02 | nearest | 2 | 107671 | 32 | 3.626 | 29694.2 |
| 591 | 2024-04-03 08:47:35 | nearest | 3 | 134027 | 420 | 11.593 | 11561.0 |
| 590 | 2024-04-01 16:07:00 | nearest | 1 | 69583 | 4 | 1.343 | 51811.6 |
| 589 | 2024-04-01 09:53:09 | nearest | 3 | 134027 | 420 | 25.393 | 5278.1 |
| 588 | 2024-03-29 07:18:55 | nearest | 3 | 134027 | 420 | 17.173 | 7804.5 |
| 587 | 2024-03-29 07:18:53 | nearest | 2 | 107671 | 32 | 12.440 | 8655.2 |
| 586 | 2024-03-29 07:18:17 | nearest | 1 | 69583 | 4 | 3.046 | 22844.1 |
| 585 | 2024-03-28 14:35:42 | nearest | 1 | 69583 | 4 | 1.216 | 57222.9 |
| 584 | 2024-03-28 02:15:29 | nearest | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 583 | 2024-03-18 09:39:08 | nearest | 1 | 69583 | 4 | 2.423 | 28717.7 |
| 582 | 2024-02-25 10:55:54 | nearest | 1 | 69583 | 4 | 1.403 | 49595.9 |
| 581 | 2023-12-24 07:26:07 | nearest | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 580 | 2023-12-09 23:41:33 | nearest | 1 | 69583 | 4 | 1.126 | 61796.6 |
| 579 | 2023-12-04 19:02:00 | nearest | 3 | 134027 | 420 | 6.733 | 19906.0 |
| 578 | 2023-12-04 19:01:40 | nearest | 2 | 107671 | 32 | 3.673 | 29314.2 |
| 577 | 2023-11-24 06:55:22 | nearest | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 576 | 2023-11-10 23:20:13 | nearest | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 575 | 2023-11-04 13:31:12 | nearest | 1 | 69583 | 4 | 2.500 | 27833.2 |
| 574 | 2023-11-03 08:01:54 | nearest | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 573 | 2023-10-28 16:46:53 | nearest | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 572 | 2023-10-24 04:49:17 | nearest | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 571 | 2023-10-14 00:34:52 | nearest | 1 | 69583 | 4 | 1.733 | 40151.8 |
| 570 | 2023-10-11 19:56:27 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 569 | 2023-09-29 19:55:08 | nearest | 1 | 69583 | 4 | 1.030 | 67556.3 |
| 568 | 2023-09-17 00:57:18 | nearest | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 567 | 2023-08-15 08:22:46 | nearest | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 566 | 2023-08-09 20:21:57 | nearest | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 565 | 2023-08-08 21:13:10 | nearest | 1 | 69583 | 4 | 1.080 | 64428.7 |
| 564 | 2023-08-08 01:31:26 | nearest | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 563 | 2023-08-04 23:21:42 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 562 | 2023-08-04 11:07:19 | nearest | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 561 | 2023-08-02 05:25:59 | nearest | 2 | 107671 | 32 | 3.060 | 35186.6 |
| 560 | 2023-07-04 20:43:43 | nearest | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 559 | 2023-06-20 00:04:04 | nearest | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 558 | 2023-05-09 15:14:51 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 557 | 2023-05-08 06:48:42 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 556 | 2023-05-01 12:25:06 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 555 | 2023-03-19 19:52:09 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 554 | 2023-03-14 20:37:26 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 553 | 2023-03-11 00:47:06 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 552 | 2023-03-05 03:03:37 | nearest | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 551 | 2023-01-24 11:53:34 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 550 | 2023-01-17 03:52:45 | nearest | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 549 | 2022-12-28 17:48:59 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 548 | 2022-12-10 06:30:49 | nearest | 1 | 69583 | 4 | 1.486 | 46825.7 |
| 547 | 2022-12-03 05:20:59 | nearest | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 546 | 2022-11-23 09:58:20 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 545 | 2022-11-19 21:51:03 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 544 | 2022-11-14 05:08:08 | nearest | 2 | 107671 | 32 | 3.360 | 32044.9 |
| 543 | 2022-11-13 14:52:05 | nearest | 2 | 107671 | 32 | 3.690 | 29179.1 |
| 542 | 2022-10-24 02:15:05 | nearest | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 541 | 2022-10-17 07:28:15 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 540 | 2022-09-17 16:08:35 | nearest | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 539 | 2022-09-10 13:10:42 | nearest | 1 | 69583 | 4 | 1.143 | 60877.5 |
| 538 | 2022-09-03 12:05:33 | nearest | 1 | 69583 | 4 | 2.313 | 30083.4 |
| 537 | 2022-07-30 14:40:40 | nearest | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 536 | 2022-07-22 16:55:36 | nearest | 1 | 69583 | 4 | 1.046 | 66522.9 |
| 535 | 2022-07-15 21:42:08 | nearest | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 534 | 2022-05-28 20:06:25 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 533 | 2022-05-09 23:54:06 | nearest | 1 | 69583 | 4 | 2.453 | 28366.5 |
| 532 | 2022-04-26 19:37:36 | nearest | 1 | 69583 | 4 | 1.123 | 61961.7 |
| 531 | 2022-04-24 14:25:01 | nearest | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 530 | 2022-04-22 07:58:26 | nearest | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 529 | 2022-04-10 07:31:44 | nearest | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 528 | 2022-04-01 15:08:57 | nearest | 1 | 69583 | 4 | 1.250 | 55666.4 |
| 527 | 2022-03-22 08:55:37 | nearest | 1 | 69583 | 4 | 1.626 | 42794.0 |
| 526 | 2022-01-13 20:41:23 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 525 | 2022-01-03 19:46:02 | nearest | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 524 | 2021-12-18 00:43:49 | nearest | 1 | 69583 | 4 | 1.110 | 62687.4 |
| 523 | 2021-11-23 06:00:59 | nearest | 1 | 69583 | 4 | 1.170 | 59472.6 |
| 522 | 2021-11-11 18:09:49 | nearest | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 521 | 2021-10-09 22:51:13 | nearest | 1 | 69583 | 4 | 1.173 | 59320.5 |
| 520 | 2021-10-09 22:28:56 | nearest | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 519 | 2021-10-03 20:55:42 | nearest | 1 | 69583 | 4 | 1.093 | 63662.4 |
| 518 | 2021-09-22 08:11:38 | nearest | 1 | 69583 | 4 | 1.280 | 54361.7 |
| 517 | 2021-09-21 03:34:10 | nearest | 1 | 69583 | 4 | 1.266 | 54962.9 |
| 516 | 2021-09-20 12:35:06 | nearest | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 515 | 2021-09-19 08:33:24 | nearest | 1 | 69583 | 4 | 1.156 | 60192.9 |
| 514 | 2021-09-07 13:27:59 | nearest | 1 | 69583 | 4 | 1.190 | 58473.1 |
| 513 | 2021-08-19 18:45:16 | nearest | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 512 | 2021-08-13 23:27:41 | nearest | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 511 | 2021-08-08 01:57:27 | nearest | 2 | 107671 | 32 | 2.906 | 37051.3 |
| 510 | 2021-08-02 01:46:36 | nearest | 2 | 107671 | 32 | 3.876 | 27778.9 |
| 509 | 2021-07-29 10:00:56 | nearest | 3 | 134027 | 420 | 6.080 | 22043.9 |
| 508 | 2021-07-27 01:11:22 | nearest | 2 | 107671 | 32 | 2.986 | 36058.6 |
| 507 | 2021-07-09 00:25:03 | nearest | 2 | 107671 | 32 | 3.373 | 31921.4 |
| 506 | 2021-07-08 02:30:40 | nearest | 2 | 107671 | 32 | 2.873 | 37476.9 |
| 505 | 2021-07-06 18:38:49 | nearest | 2 | 107671 | 32 | 2.953 | 36461.6 |
| 504 | 2021-07-05 20:31:31 | nearest | 2 | 107671 | 32 | 3.000 | 35890.3 |
| 503 | 2021-07-05 20:23:06 | nearest | 1 | 69583 | 4 | 1.283 | 54234.6 |
| 502 | 2021-07-04 13:21:34 | nearest | 2 | 107671 | 32 | 5.530 | 19470.3 |
| 501 | 2021-07-03 19:04:50 | nearest | 2 | 107671 | 32 | 3.000 | 35890.3 |
| 500 | 2021-07-02 22:29:31 | nearest | 2 | 107671 | 32 | 3.486 | 30886.7 |
| 499 | 2021-07-02 11:14:14 | nearest | 2 | 107671 | 32 | 3.203 | 33615.7 |
| 498 | 2021-07-01 22:52:43 | nearest | 2 | 107671 | 32 | 3.216 | 33479.8 |
| 497 | 2021-06-30 16:33:39 | nearest | 2 | 107671 | 32 | 3.550 | 30329.9 |
| 496 | 2021-06-19 16:52:31 | nearest | 2 | 107671 | 32 | 3.203 | 33615.7 |
| 495 | 2021-06-18 21:13:11 | nearest | 2 | 107671 | 32 | 3.516 | 30623.2 |
| 494 | 2021-06-17 21:02:43 | nearest | 2 | 107671 | 32 | 3.440 | 31299.7 |
| 493 | 2021-06-06 16:03:28 | nearest | 1 | 69583 | 4 | 1.263 | 55093.4 |