History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"flights"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 669 | 2024-03-29 22:34:32 | flights | 1 | 69583 | 10 | 2.703 | 25742.9 |
| 668 | 2024-01-15 05:15:47 | flights | 1 | 69583 | 10 | 1.126 | 61796.6 |
| 667 | 2024-01-11 10:14:48 | flights | 1 | 69583 | 10 | 1.110 | 62687.4 |
| 666 | 2024-01-01 17:18:30 | flights | 3 | 134027 | 247 | 6.296 | 21287.6 |
| 665 | 2023-12-15 06:39:26 | flights | 2 | 107671 | 44 | 3.170 | 33965.6 |
| 664 | 2023-12-12 07:54:28 | flights | 3 | 134027 | 247 | 5.736 | 23365.9 |
| 663 | 2023-12-07 18:22:06 | flights | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 662 | 2023-11-21 06:33:29 | flights | 1 | 69583 | 10 | 1.126 | 61796.6 |
| 661 | 2023-11-11 07:10:44 | flights | 3 | 134027 | 247 | 7.313 | 18327.2 |
| 660 | 2023-11-08 16:57:34 | flights | 1 | 69583 | 10 | 1.173 | 59320.5 |
| 659 | 2023-11-06 03:27:23 | flights | 3 | 134027 | 247 | 6.346 | 21119.9 |
| 658 | 2023-11-05 23:27:32 | flights | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 657 | 2023-11-05 22:13:58 | flights | 1 | 69583 | 10 | 1.203 | 57841.2 |
| 656 | 2023-10-17 20:38:42 | flights | 1 | 69583 | 10 | 1.030 | 67556.3 |
| 655 | 2023-10-17 15:44:59 | flights | 3 | 134027 | 247 | 16.110 | 8319.5 |
| 654 | 2023-10-13 21:50:34 | flights | 2 | 107671 | 44 | 2.796 | 38508.9 |
| 653 | 2023-10-13 03:19:48 | flights | 1 | 69583 | 10 | 1.233 | 56433.9 |
| 652 | 2023-10-09 09:55:09 | flights | 1 | 69583 | 10 | 1.153 | 60349.5 |
| 651 | 2023-09-28 18:35:41 | flights | 3 | 134027 | 247 | 5.953 | 22514.2 |
| 650 | 2023-09-26 01:19:03 | flights | 1 | 69583 | 10 | 1.140 | 61037.7 |
| 649 | 2023-09-24 09:01:14 | flights | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 648 | 2023-09-18 15:16:47 | flights | 1 | 69583 | 10 | 1.233 | 56433.9 |
| 647 | 2023-09-11 20:48:06 | flights | 2 | 107671 | 44 | 3.186 | 33795.0 |
| 646 | 2023-09-09 23:10:03 | flights | 2 | 107671 | 44 | 2.703 | 39833.9 |
| 645 | 2023-09-08 12:02:22 | flights | 2 | 107671 | 44 | 2.733 | 39396.6 |
| 644 | 2023-09-05 10:40:09 | flights | 2 | 107671 | 44 | 3.140 | 34290.1 |
| 643 | 2023-09-03 23:44:06 | flights | 2 | 107671 | 44 | 3.093 | 34811.2 |
| 642 | 2023-09-02 20:56:25 | flights | 2 | 107671 | 44 | 6.096 | 17662.6 |
| 641 | 2023-09-01 20:15:48 | flights | 2 | 107671 | 44 | 3.310 | 32529.0 |
| 640 | 2023-08-26 17:27:15 | flights | 1 | 69583 | 10 | 1.110 | 62687.4 |
| 639 | 2023-08-17 20:28:56 | flights | 2 | 107671 | 44 | 2.670 | 40326.2 |
| 638 | 2023-08-16 22:58:17 | flights | 2 | 107671 | 44 | 3.173 | 33933.5 |
| 637 | 2023-08-13 03:28:11 | flights | 3 | 134027 | 247 | 5.610 | 23890.7 |
| 636 | 2023-06-18 01:02:44 | flights | 3 | 134027 | 247 | 6.516 | 20568.9 |
| 635 | 2023-06-04 18:52:00 | flights | 1 | 69583 | 10 | 1.016 | 68487.2 |
| 634 | 2023-05-30 03:10:52 | flights | 1 | 69583 | 10 | 1.016 | 68487.2 |
| 633 | 2023-05-21 05:15:54 | flights | 3 | 134027 | 247 | 6.373 | 21030.4 |
| 632 | 2023-03-23 08:44:14 | flights | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 631 | 2023-02-26 14:35:14 | flights | 1 | 69583 | 10 | 1.030 | 67556.3 |
| 630 | 2023-01-08 00:33:22 | flights | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 629 | 2022-12-28 15:28:13 | flights | 1 | 69583 | 10 | 1.123 | 61961.7 |
| 628 | 2022-11-15 23:54:41 | flights | 1 | 69583 | 10 | 1.156 | 60192.9 |
| 627 | 2022-11-09 19:04:13 | flights | 1 | 69583 | 10 | 1.186 | 58670.3 |
| 626 | 2022-09-28 19:08:49 | flights | 1 | 69583 | 10 | 1.016 | 68487.2 |
| 625 | 2022-08-15 02:00:00 | flights | 1 | 69583 | 10 | 1.156 | 60192.9 |
| 624 | 2022-07-20 12:39:40 | flights | 1 | 69583 | 10 | 1.046 | 66522.9 |
| 623 | 2022-07-16 19:25:24 | flights | 1 | 69583 | 10 | 1.076 | 64668.2 |
| 622 | 2022-07-10 10:53:14 | flights | 1 | 69583 | 10 | 1.216 | 57222.9 |
| 621 | 2022-07-02 20:03:52 | flights | 1 | 69583 | 10 | 1.033 | 67360.1 |
| 620 | 2022-06-17 09:00:00 | flights | 3 | 134027 | 247 | 6.513 | 20578.4 |
| 619 | 2022-06-15 22:01:06 | flights | 1 | 69583 | 10 | 1.170 | 59472.6 |
| 618 | 2022-05-11 07:57:29 | flights | 1 | 69583 | 10 | 1.203 | 57841.2 |
| 617 | 2022-04-27 04:11:26 | flights | 3 | 134027 | 247 | 6.656 | 20136.3 |
| 616 | 2022-03-31 21:20:23 | flights | 2 | 107671 | 44 | 2.906 | 37051.3 |
| 615 | 2022-03-22 23:23:52 | flights | 1 | 69583 | 10 | 1.093 | 63662.4 |
| 614 | 2022-03-11 14:28:39 | flights | 3 | 134027 | 247 | 7.466 | 17951.6 |
| 613 | 2022-03-10 17:21:12 | flights | 3 | 134027 | 247 | 7.076 | 18941.1 |
| 612 | 2022-03-09 17:22:03 | flights | 3 | 134027 | 247 | 5.966 | 22465.1 |
| 611 | 2022-03-08 15:27:48 | flights | 3 | 134027 | 247 | 6.440 | 20811.6 |
| 610 | 2022-03-07 16:43:18 | flights | 3 | 134027 | 247 | 7.393 | 18128.9 |
| 609 | 2022-03-06 16:42:43 | flights | 3 | 134027 | 247 | 6.456 | 20760.1 |
| 608 | 2022-03-05 14:40:48 | flights | 3 | 134027 | 247 | 5.720 | 23431.3 |
| 607 | 2022-03-04 16:17:46 | flights | 3 | 134027 | 247 | 6.140 | 21828.5 |
| 606 | 2022-03-03 13:24:16 | flights | 3 | 134027 | 247 | 6.970 | 19229.1 |
| 605 | 2022-03-02 17:32:12 | flights | 3 | 134027 | 247 | 6.580 | 20368.8 |
| 604 | 2022-02-24 03:15:58 | flights | 2 | 107671 | 44 | 3.673 | 29314.2 |
| 603 | 2022-02-23 13:37:58 | flights | 2 | 107671 | 44 | 4.810 | 22384.8 |
| 602 | 2022-02-22 11:41:41 | flights | 2 | 107671 | 44 | 3.720 | 28943.8 |
| 601 | 2022-02-21 04:16:46 | flights | 2 | 107671 | 44 | 6.720 | 16022.5 |
| 600 | 2022-02-20 06:40:57 | flights | 2 | 107671 | 44 | 3.110 | 34620.9 |
| 599 | 2022-02-19 05:46:07 | flights | 2 | 107671 | 44 | 3.440 | 31299.7 |
| 598 | 2022-02-18 05:53:29 | flights | 2 | 107671 | 44 | 3.576 | 30109.3 |
| 597 | 2022-02-17 06:48:23 | flights | 2 | 107671 | 44 | 3.360 | 32044.9 |
| 596 | 2022-02-16 10:27:17 | flights | 2 | 107671 | 44 | 3.656 | 29450.5 |
| 595 | 2022-02-15 06:20:16 | flights | 2 | 107671 | 44 | 4.610 | 23356.0 |
| 594 | 2022-02-14 09:56:41 | flights | 2 | 107671 | 44 | 3.500 | 30763.1 |
| 593 | 2022-02-13 05:36:29 | flights | 1 | 69583 | 10 | 1.033 | 67360.1 |
| 592 | 2022-02-03 16:15:49 | flights | 1 | 69583 | 10 | 1.046 | 66522.9 |
| 591 | 2022-01-28 23:42:06 | flights | 2 | 107671 | 44 | 2.750 | 39153.1 |
| 590 | 2022-01-27 18:48:49 | flights | 2 | 107671 | 44 | 2.673 | 40281.0 |
| 589 | 2022-01-26 22:18:13 | flights | 2 | 107671 | 44 | 3.186 | 33795.0 |
| 588 | 2022-01-25 23:23:30 | flights | 2 | 107671 | 44 | 3.220 | 33438.2 |
| 587 | 2022-01-22 06:51:08 | flights | 3 | 134027 | 247 | 6.030 | 22226.7 |
| 586 | 2022-01-21 12:03:29 | flights | 3 | 134027 | 247 | 6.296 | 21287.6 |
| 585 | 2022-01-20 10:21:32 | flights | 3 | 134027 | 247 | 6.456 | 20760.1 |
| 584 | 2022-01-19 16:53:38 | flights | 3 | 134027 | 247 | 7.936 | 16888.5 |
| 583 | 2022-01-18 17:14:29 | flights | 3 | 134027 | 247 | 6.046 | 22167.9 |
| 582 | 2022-01-13 19:45:47 | flights | 3 | 134027 | 247 | 6.563 | 20421.6 |
| 581 | 2022-01-12 19:56:35 | flights | 3 | 134027 | 247 | 5.670 | 23637.9 |
| 580 | 2022-01-11 23:30:34 | flights | 3 | 134027 | 247 | 6.220 | 21547.7 |
| 579 | 2021-12-28 06:41:56 | flights | 3 | 134027 | 247 | 5.673 | 23625.4 |
| 578 | 2021-12-17 05:24:37 | flights | 2 | 107671 | 44 | 3.153 | 34148.7 |
| 577 | 2021-12-16 08:42:03 | flights | 2 | 107671 | 44 | 3.250 | 33129.5 |
| 576 | 2021-12-15 08:00:46 | flights | 2 | 107671 | 44 | 3.190 | 33752.7 |
| 575 | 2021-12-05 17:35:37 | flights | 1 | 69583 | 10 | 1.190 | 58473.1 |
| 574 | 2021-12-05 08:50:40 | flights | 2 | 107671 | 44 | 3.860 | 27894.0 |
| 573 | 2021-12-04 13:14:06 | flights | 2 | 107671 | 44 | 2.920 | 36873.6 |
| 572 | 2021-12-03 07:24:23 | flights | 2 | 107671 | 44 | 3.440 | 31299.7 |
| 571 | 2021-12-01 19:17:27 | flights | 1 | 69583 | 10 | 2.373 | 29322.8 |
| 570 | 2021-11-22 00:15:50 | flights | 2 | 107671 | 44 | 3.250 | 33129.5 |