History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"oldest"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 587 | 2024-04-06 06:23:02 | oldest | 1 | 48755 | 6 | 2.313 | 21078.7 |
| 586 | 2024-03-29 06:49:47 | oldest | 1 | 48755 | 6 | 1.170 | 41670.9 |
| 585 | 2024-03-28 02:37:17 | oldest | 1 | 48755 | 6 | 0.736 | 66243.2 |
| 584 | 2024-03-09 03:37:13 | oldest | 3 | 112716 | 558 | 5.016 | 22471.3 |
| 583 | 2024-03-08 03:43:48 | oldest | 2 | 82551 | 44 | 2.470 | 33421.5 |
| 582 | 2024-03-08 03:41:29 | oldest | 3 | 112716 | 558 | 5.516 | 20434.4 |
| 581 | 2024-03-04 07:01:06 | oldest | 3 | 112716 | 558 | 10.330 | 10911.5 |
| 580 | 2024-03-03 10:56:03 | oldest | 3 | 112716 | 558 | 18.393 | 6128.2 |
| 579 | 2024-03-03 10:56:09 | oldest | 2 | 82551 | 44 | 9.096 | 9075.5 |
| 578 | 2024-03-03 10:56:00 | oldest | 1 | 48755 | 6 | 2.843 | 17149.1 |
| 577 | 2024-02-06 15:18:43 | oldest | 2 | 82551 | 44 | 5.093 | 16208.7 |
| 576 | 2024-02-06 15:18:23 | oldest | 3 | 112716 | 558 | 6.610 | 17052.3 |
| 575 | 2024-02-06 15:04:14 | oldest | 2 | 82551 | 44 | 2.513 | 32849.6 |
| 574 | 2024-02-06 15:03:51 | oldest | 3 | 112716 | 558 | 5.263 | 21416.7 |
| 573 | 2024-02-03 23:56:03 | oldest | 3 | 112716 | 558 | 5.330 | 21147.5 |
| 572 | 2024-02-03 23:55:59 | oldest | 2 | 82551 | 44 | 2.110 | 39123.7 |
| 571 | 2024-01-22 19:31:12 | oldest | 3 | 112716 | 558 | 6.423 | 17548.8 |
| 570 | 2024-01-22 18:02:47 | oldest | 3 | 112716 | 558 | 4.936 | 22835.5 |
| 569 | 2024-01-15 20:12:38 | oldest | 3 | 112716 | 558 | 4.813 | 23419.1 |
| 568 | 2024-01-14 06:12:32 | oldest | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 567 | 2024-01-09 13:13:07 | oldest | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 566 | 2023-12-18 21:43:29 | oldest | 2 | 82551 | 44 | 2.516 | 32810.4 |
| 565 | 2023-12-18 02:52:50 | oldest | 2 | 82551 | 44 | 2.436 | 33887.9 |
| 564 | 2023-12-03 19:46:24 | oldest | 1 | 48755 | 6 | 0.906 | 53813.5 |
| 563 | 2023-12-03 19:46:22 | oldest | 1 | 48755 | 6 | 1.843 | 26454.2 |
| 562 | 2023-11-25 23:21:03 | oldest | 3 | 112716 | 558 | 5.706 | 19753.9 |
| 561 | 2023-11-22 15:58:46 | oldest | 1 | 48755 | 6 | 1.016 | 47987.2 |
| 560 | 2023-11-18 11:33:11 | oldest | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 559 | 2023-11-11 20:20:36 | oldest | 2 | 82551 | 44 | 2.440 | 33832.4 |
| 558 | 2023-11-08 18:33:13 | oldest | 1 | 48755 | 6 | 0.716 | 68093.6 |
| 557 | 2023-11-04 09:11:40 | oldest | 1 | 48755 | 6 | 0.736 | 66243.2 |
| 556 | 2023-10-26 16:44:54 | oldest | 3 | 112716 | 558 | 9.406 | 11983.4 |
| 555 | 2023-10-25 12:26:23 | oldest | 3 | 112716 | 558 | 5.406 | 20850.2 |
| 554 | 2023-10-24 14:46:27 | oldest | 1 | 48755 | 6 | 0.876 | 55656.4 |
| 553 | 2023-10-23 01:29:23 | oldest | 3 | 112716 | 558 | 4.810 | 23433.7 |
| 552 | 2023-10-19 16:57:17 | oldest | 1 | 48755 | 6 | 0.783 | 62266.9 |
| 551 | 2023-09-29 12:22:34 | oldest | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 550 | 2023-09-23 02:23:45 | oldest | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 549 | 2023-08-31 01:10:29 | oldest | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 548 | 2023-08-29 11:31:42 | oldest | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 547 | 2023-08-02 02:42:41 | oldest | 3 | 112716 | 558 | 5.156 | 21861.1 |
| 546 | 2023-07-15 22:01:05 | oldest | 3 | 112716 | 558 | 5.466 | 20621.3 |
| 545 | 2023-07-09 20:32:47 | oldest | 3 | 112716 | 558 | 7.483 | 15062.9 |
| 544 | 2023-07-08 13:29:02 | oldest | 3 | 112716 | 558 | 6.063 | 18590.8 |
| 543 | 2023-07-07 17:42:02 | oldest | 3 | 112716 | 558 | 5.360 | 21029.1 |
| 542 | 2023-07-06 19:34:37 | oldest | 3 | 112716 | 558 | 5.530 | 20382.6 |
| 541 | 2023-06-23 01:31:10 | oldest | 3 | 112716 | 558 | 8.903 | 12660.5 |
| 540 | 2023-05-29 04:19:05 | oldest | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 539 | 2023-05-10 08:48:21 | oldest | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 538 | 2023-05-06 20:59:42 | oldest | 1 | 48755 | 6 | 0.720 | 67715.3 |
| 537 | 2023-04-08 03:36:30 | oldest | 3 | 112716 | 558 | 5.343 | 21096.0 |
| 536 | 2023-03-30 18:02:38 | oldest | 3 | 112716 | 558 | 8.966 | 12571.5 |
| 535 | 2023-03-23 04:13:53 | oldest | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 534 | 2023-02-04 15:25:01 | oldest | 3 | 112716 | 558 | 4.983 | 22620.1 |
| 533 | 2023-01-12 13:00:54 | oldest | 3 | 112716 | 558 | 5.403 | 20861.7 |
| 532 | 2023-01-09 14:39:09 | oldest | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 531 | 2023-01-09 09:13:41 | oldest | 1 | 48755 | 6 | 0.720 | 67715.3 |
| 530 | 2023-01-05 14:08:36 | oldest | 3 | 112716 | 558 | 4.610 | 24450.3 |
| 529 | 2022-12-13 09:18:03 | oldest | 3 | 112716 | 558 | 4.563 | 24702.2 |
| 528 | 2022-12-06 10:16:29 | oldest | 3 | 112716 | 558 | 6.936 | 16250.9 |
| 527 | 2022-12-05 18:52:13 | oldest | 3 | 112716 | 558 | 6.126 | 18399.6 |
| 526 | 2022-11-05 16:19:45 | oldest | 3 | 112716 | 558 | 5.110 | 22057.9 |
| 525 | 2022-11-03 17:51:09 | oldest | 3 | 112716 | 558 | 5.360 | 21029.1 |
| 524 | 2022-10-04 08:00:47 | oldest | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 523 | 2022-09-11 09:50:59 | oldest | 3 | 112716 | 558 | 4.936 | 22835.5 |
| 522 | 2022-09-07 19:55:59 | oldest | 1 | 48755 | 6 | 0.763 | 63899.1 |
| 521 | 2022-05-23 02:51:55 | oldest | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 520 | 2022-05-23 00:15:41 | oldest | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 519 | 2022-05-02 02:07:05 | oldest | 1 | 48755 | 6 | 0.720 | 67715.3 |
| 518 | 2022-04-02 00:56:38 | oldest | 3 | 112716 | 558 | 4.936 | 22835.5 |
| 517 | 2022-04-01 18:32:27 | oldest | 3 | 112716 | 558 | 4.563 | 24702.2 |
| 516 | 2022-01-31 06:12:25 | oldest | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 515 | 2022-01-25 18:46:53 | oldest | 3 | 112716 | 558 | 5.563 | 20261.7 |
| 514 | 2022-01-11 14:57:55 | oldest | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 513 | 2021-12-28 08:55:09 | oldest | 3 | 112716 | 558 | 5.843 | 19290.8 |
| 512 | 2021-12-17 11:10:46 | oldest | 3 | 112716 | 558 | 4.843 | 23274.0 |
| 511 | 2021-12-07 00:31:06 | oldest | 3 | 112716 | 558 | 8.813 | 12789.7 |
| 510 | 2021-12-02 12:45:19 | oldest | 3 | 112716 | 558 | 5.560 | 20272.7 |
| 509 | 2021-12-01 00:23:20 | oldest | 3 | 112716 | 558 | 5.076 | 22205.7 |
| 508 | 2021-11-24 00:20:14 | oldest | 3 | 112716 | 558 | 4.873 | 23130.7 |
| 507 | 2021-11-22 04:15:09 | oldest | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 506 | 2021-11-09 19:57:35 | oldest | 3 | 112716 | 558 | 5.690 | 19809.5 |
| 505 | 2021-11-06 00:13:08 | oldest | 3 | 112716 | 558 | 4.813 | 23419.1 |
| 504 | 2021-10-26 06:55:59 | oldest | 3 | 112716 | 558 | 5.126 | 21989.1 |
| 503 | 2021-10-10 04:47:36 | oldest | 3 | 112716 | 558 | 5.393 | 20900.4 |
| 502 | 2021-10-09 12:45:55 | oldest | 3 | 112716 | 558 | 5.550 | 20309.2 |
| 501 | 2021-10-08 08:56:15 | oldest | 3 | 112716 | 558 | 5.283 | 21335.6 |
| 500 | 2021-10-08 03:24:57 | oldest | 3 | 112716 | 558 | 5.110 | 22057.9 |
| 499 | 2021-10-07 21:47:51 | oldest | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 498 | 2021-10-07 08:14:24 | oldest | 3 | 112716 | 558 | 5.686 | 19823.4 |
| 497 | 2021-10-06 09:03:33 | oldest | 3 | 112716 | 558 | 5.550 | 20309.2 |
| 496 | 2021-10-05 06:51:25 | oldest | 3 | 112716 | 558 | 5.236 | 21527.1 |
| 495 | 2021-10-04 11:37:17 | oldest | 3 | 112716 | 558 | 8.033 | 14031.6 |
| 494 | 2021-10-03 08:37:45 | oldest | 3 | 112716 | 558 | 5.360 | 21029.1 |
| 493 | 2021-10-02 08:15:40 | oldest | 3 | 112716 | 558 | 5.170 | 21801.9 |
| 492 | 2021-10-02 05:32:07 | oldest | 1 | 48755 | 6 | 0.890 | 54780.9 |
| 491 | 2021-09-29 00:26:12 | oldest | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 490 | 2021-09-03 14:40:15 | oldest | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 489 | 2021-08-29 11:53:53 | oldest | 3 | 112716 | 558 | 4.876 | 23116.5 |
| 488 | 2021-08-17 01:26:50 | oldest | 1 | 48755 | 6 | 0.830 | 58741.0 |