History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tourist"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 659 | 2025-11-28 03:22:16 | tourist | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 658 | 2025-11-21 08:52:48 | tourist | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 657 | 2025-11-03 06:55:29 | tourist | 1 | 69583 | 5 | 2.470 | 28171.3 |
| 656 | 2025-10-04 15:19:28 | tourist | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 655 | 2025-10-02 09:17:55 | tourist | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 654 | 2025-09-19 04:56:59 | tourist | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 653 | 2025-09-07 22:03:56 | tourist | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 652 | 2025-08-27 01:12:49 | tourist | 2 | 107671 | 27 | 3.330 | 32333.6 |
| 651 | 2025-08-26 20:09:28 | tourist | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 650 | 2025-08-25 12:58:18 | tourist | 2 | 107671 | 27 | 9.936 | 10836.5 |
| 649 | 2025-08-25 09:13:31 | tourist | 2 | 107671 | 27 | 15.533 | 6931.8 |
| 648 | 2025-08-24 22:12:17 | tourist | 1 | 69583 | 5 | 6.703 | 10380.9 |
| 647 | 2025-08-22 23:08:04 | tourist | 3 | 134027 | 286 | 34.936 | 3836.4 |
| 646 | 2025-08-19 22:52:18 | tourist | 3 | 134027 | 286 | 8.063 | 16622.5 |
| 645 | 2025-08-13 19:07:51 | tourist | 1 | 69583 | 5 | 2.970 | 23428.6 |
| 644 | 2025-08-11 19:04:22 | tourist | 1 | 69583 | 5 | 2.186 | 31831.2 |
| 643 | 2025-08-06 23:19:29 | tourist | 3 | 134027 | 286 | 25.280 | 5301.7 |
| 642 | 2025-08-05 22:55:27 | tourist | 3 | 134027 | 286 | 27.173 | 4932.4 |
| 640 | 2025-08-05 22:55:21 | tourist | 3 | 134027 | 286 | 31.690 | 4229.3 |
| 639 | 2025-08-05 18:03:14 | tourist | 3 | 134027 | 286 | 24.313 | 5512.6 |
| 638 | 2025-08-05 02:51:21 | tourist | 3 | 134027 | 286 | 21.190 | 6325.0 |
| 637 | 2025-08-04 05:19:44 | tourist | 1 | 69583 | 5 | 4.860 | 14317.5 |
| 636 | 2025-08-04 02:16:38 | tourist | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 635 | 2025-08-03 00:43:25 | tourist | 3 | 134027 | 286 | 44.190 | 3033.0 |
| 634 | 2025-07-31 00:27:34 | tourist | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 633 | 2025-07-30 18:08:55 | tourist | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 632 | 2025-07-26 21:25:06 | tourist | 1 | 69583 | 5 | 5.330 | 13055.0 |
| 631 | 2025-07-23 08:13:19 | tourist | 1 | 69583 | 5 | 3.890 | 17887.7 |
| 630 | 2025-07-19 04:41:10 | tourist | 1 | 69583 | 5 | 1.216 | 57222.9 |
| 629 | 2025-07-11 18:57:45 | tourist | 1 | 69583 | 5 | 3.890 | 17887.7 |
| 628 | 2025-07-10 15:09:34 | tourist | 1 | 69583 | 5 | 2.576 | 27012.0 |
| 627 | 2025-07-05 15:56:10 | tourist | 3 | 134027 | 286 | 32.750 | 4092.4 |
| 626 | 2025-07-05 02:16:05 | tourist | 3 | 134027 | 286 | 33.363 | 4017.2 |
| 625 | 2025-07-03 23:44:16 | tourist | 3 | 134027 | 286 | 18.203 | 7362.9 |
| 624 | 2025-07-03 22:48:41 | tourist | 3 | 134027 | 286 | 21.533 | 6224.3 |
| 623 | 2025-07-02 05:41:12 | tourist | 1 | 69583 | 5 | 5.283 | 13171.1 |
| 622 | 2025-07-01 12:21:10 | tourist | 3 | 134027 | 286 | 6.813 | 19672.2 |
| 621 | 2025-06-29 23:30:40 | tourist | 1 | 69583 | 5 | 5.966 | 11663.3 |
| 620 | 2025-06-25 21:06:38 | tourist | 1 | 69583 | 5 | 5.393 | 12902.5 |
| 619 | 2025-06-24 23:04:11 | tourist | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 618 | 2025-06-17 23:21:50 | tourist | 1 | 69583 | 5 | 3.080 | 22591.9 |
| 617 | 2025-06-06 02:54:27 | tourist | 1 | 69583 | 5 | 5.546 | 12546.5 |
| 616 | 2025-06-03 23:17:27 | tourist | 1 | 69583 | 5 | 5.203 | 13373.6 |
| 615 | 2025-05-27 16:03:10 | tourist | 1 | 69583 | 5 | 3.766 | 18476.6 |
| 614 | 2025-05-21 20:43:37 | tourist | 1 | 69583 | 5 | 7.420 | 9377.8 |
| 613 | 2025-05-18 00:46:03 | tourist | 1 | 69583 | 5 | 4.220 | 16488.9 |
| 612 | 2025-05-12 11:55:32 | tourist | 1 | 69583 | 5 | 8.470 | 8215.2 |
| 611 | 2025-05-01 23:15:27 | tourist | 1 | 69583 | 5 | 5.516 | 12614.8 |
| 610 | 2025-04-30 12:09:28 | tourist | 1 | 69583 | 5 | 8.983 | 7746.1 |
| 609 | 2025-04-30 05:12:45 | tourist | 1 | 69583 | 5 | 7.213 | 9646.9 |
| 608 | 2025-04-20 20:56:03 | tourist | 1 | 69583 | 5 | 6.186 | 11248.5 |
| 607 | 2025-04-17 22:56:54 | tourist | 1 | 69583 | 5 | 3.140 | 22160.2 |
| 606 | 2025-04-09 09:27:08 | tourist | 2 | 107671 | 27 | 15.313 | 7031.3 |
| 605 | 2025-04-08 09:56:56 | tourist | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 604 | 2025-04-08 09:33:09 | tourist | 1 | 69583 | 5 | 3.406 | 20429.5 |
| 603 | 2025-04-02 14:04:29 | tourist | 1 | 69583 | 5 | 7.576 | 9184.7 |
| 602 | 2025-03-28 23:00:54 | tourist | 1 | 69583 | 5 | 5.843 | 11908.8 |
| 601 | 2025-03-26 06:25:38 | tourist | 1 | 69583 | 5 | 5.876 | 11841.9 |
| 600 | 2025-03-24 23:31:39 | tourist | 1 | 69583 | 5 | 4.643 | 14986.6 |
| 599 | 2025-03-20 23:56:19 | tourist | 2 | 107671 | 27 | 14.736 | 7306.7 |
| 598 | 2025-03-20 23:06:06 | tourist | 3 | 134027 | 286 | 30.956 | 4329.6 |
| 597 | 2025-03-18 21:41:30 | tourist | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 596 | 2025-03-18 16:22:39 | tourist | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 595 | 2025-03-17 05:18:16 | tourist | 1 | 69583 | 5 | 4.983 | 13964.1 |
| 594 | 2025-03-09 16:23:27 | tourist | 2 | 107671 | 27 | 23.456 | 4590.3 |
| 593 | 2025-03-09 06:00:25 | tourist | 2 | 107671 | 27 | 19.110 | 5634.3 |
| 592 | 2025-03-09 00:57:24 | tourist | 1 | 69583 | 5 | 5.670 | 12272.1 |
| 591 | 2025-02-25 09:30:56 | tourist | 3 | 134027 | 286 | 34.660 | 3866.9 |
| 590 | 2025-02-25 07:57:51 | tourist | 3 | 134027 | 286 | 27.173 | 4932.4 |
| 589 | 2025-02-25 04:12:49 | tourist | 3 | 134027 | 286 | 15.423 | 8690.1 |
| 588 | 2025-02-24 15:42:42 | tourist | 1 | 69583 | 5 | 2.123 | 32775.8 |
| 587 | 2025-02-23 16:19:10 | tourist | 1 | 69583 | 5 | 3.486 | 19960.7 |
| 586 | 2025-02-21 16:45:03 | tourist | 1 | 69583 | 5 | 8.890 | 7827.1 |
| 585 | 2025-02-20 10:56:47 | tourist | 3 | 134027 | 286 | 31.313 | 4280.2 |
| 584 | 2025-02-18 07:23:35 | tourist | 2 | 107671 | 27 | 4.533 | 23752.7 |
| 583 | 2025-02-18 07:23:23 | tourist | 1 | 69583 | 5 | 3.703 | 18791.0 |
| 582 | 2025-01-29 14:12:35 | tourist | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 581 | 2025-01-26 03:41:26 | tourist | 3 | 134027 | 286 | 17.933 | 7473.8 |
| 580 | 2025-01-26 03:10:48 | tourist | 3 | 134027 | 286 | 30.686 | 4367.7 |
| 579 | 2025-01-25 11:44:04 | tourist | 3 | 134027 | 286 | 49.706 | 2696.4 |
| 578 | 2025-01-16 22:35:20 | tourist | 1 | 69583 | 5 | 2.783 | 25002.9 |
| 577 | 2025-01-01 16:04:46 | tourist | 2 | 107671 | 27 | 23.303 | 4620.5 |
| 576 | 2024-12-30 20:28:06 | tourist | 2 | 107671 | 27 | 10.546 | 10209.7 |
| 575 | 2024-12-30 18:06:36 | tourist | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 574 | 2024-12-12 19:14:24 | tourist | 1 | 69583 | 5 | 5.960 | 11675.0 |
| 573 | 2024-11-29 11:40:59 | tourist | 1 | 69583 | 5 | 2.690 | 25867.3 |
| 572 | 2024-11-26 07:45:07 | tourist | 3 | 134027 | 286 | 20.720 | 6468.5 |
| 571 | 2024-11-26 05:16:32 | tourist | 3 | 134027 | 286 | 22.610 | 5927.8 |
| 570 | 2024-11-25 11:32:15 | tourist | 3 | 134027 | 286 | 19.893 | 6737.4 |
| 569 | 2024-11-25 11:32:15 | tourist | 2 | 107671 | 27 | 12.733 | 8456.1 |
| 568 | 2024-11-25 11:32:06 | tourist | 1 | 69583 | 5 | 5.483 | 12690.7 |
| 567 | 2024-11-09 11:27:23 | tourist | 1 | 69583 | 5 | 3.110 | 22374.0 |
| 566 | 2024-10-29 21:25:11 | tourist | 1 | 69583 | 5 | 5.406 | 12871.4 |
| 565 | 2024-10-27 06:43:25 | tourist | 3 | 134027 | 286 | 28.516 | 4700.1 |
| 564 | 2024-10-26 19:17:35 | tourist | 3 | 134027 | 286 | 34.470 | 3888.2 |
| 563 | 2024-10-26 19:09:49 | tourist | 2 | 107671 | 27 | 6.860 | 15695.5 |
| 562 | 2024-10-26 08:55:44 | tourist | 3 | 134027 | 286 | 45.330 | 2956.7 |
| 561 | 2024-10-26 07:34:17 | tourist | 3 | 134027 | 286 | 44.643 | 3002.2 |
| 560 | 2024-10-26 07:34:22 | tourist | 2 | 107671 | 27 | 14.326 | 7515.8 |