History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chemists"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 633 | 2024-05-14 15:30:52 | chemists | 3 | 146162 | 154 | 10.076 | 14506.0 |
| 632 | 2024-05-14 02:36:38 | chemists | 3 | 146162 | 154 | 10.406 | 14045.9 |
| 631 | 2024-04-30 04:58:25 | chemists | 3 | 146162 | 154 | 8.563 | 17069.0 |
| 630 | 2024-04-29 19:14:25 | chemists | 2 | 121059 | 22 | 3.830 | 31608.1 |
| 629 | 2024-04-29 19:08:41 | chemists | 3 | 146162 | 154 | 8.050 | 18156.8 |
| 628 | 2024-04-28 08:35:20 | chemists | 3 | 146162 | 154 | 9.360 | 15615.6 |
| 627 | 2024-04-25 14:02:48 | chemists | 2 | 121059 | 22 | 3.953 | 30624.6 |
| 626 | 2024-04-25 14:02:47 | chemists | 1 | 82945 | 5 | 1.513 | 54821.5 |
| 625 | 2024-04-25 05:04:32 | chemists | 3 | 146162 | 154 | 19.890 | 7348.5 |
| 624 | 2024-04-24 21:14:36 | chemists | 3 | 146162 | 154 | 8.186 | 17855.1 |
| 623 | 2024-04-23 12:52:27 | chemists | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 622 | 2024-04-22 06:00:53 | chemists | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 621 | 2024-04-22 06:00:30 | chemists | 3 | 146162 | 154 | 7.046 | 20744.0 |
| 620 | 2024-04-22 06:00:32 | chemists | 2 | 121059 | 22 | 3.546 | 34139.6 |
| 619 | 2024-04-22 06:00:28 | chemists | 1 | 82945 | 5 | 1.470 | 56425.2 |
| 618 | 2024-04-13 15:39:19 | chemists | 1 | 82945 | 5 | 1.843 | 45005.4 |
| 617 | 2024-04-11 03:47:11 | chemists | 1 | 82945 | 5 | 2.033 | 40799.3 |
| 616 | 2024-04-09 19:25:14 | chemists | 1 | 82945 | 5 | 1.780 | 46598.3 |
| 615 | 2024-04-03 21:31:29 | chemists | 1 | 82945 | 5 | 1.673 | 49578.6 |
| 614 | 2024-03-30 08:00:49 | chemists | 1 | 82945 | 5 | 1.640 | 50576.2 |
| 613 | 2024-03-27 07:34:01 | chemists | 2 | 121059 | 22 | 3.843 | 31501.2 |
| 612 | 2024-03-27 07:30:42 | chemists | 3 | 146162 | 154 | 7.796 | 18748.3 |
| 611 | 2024-03-22 10:45:46 | chemists | 2 | 121059 | 22 | 3.860 | 31362.4 |
| 610 | 2024-03-22 10:45:24 | chemists | 3 | 146162 | 154 | 8.173 | 17883.5 |
| 609 | 2024-03-21 22:16:21 | chemists | 3 | 146162 | 154 | 16.796 | 8702.2 |
| 608 | 2024-03-18 22:25:35 | chemists | 3 | 146162 | 154 | 24.593 | 5943.2 |
| 607 | 2024-03-18 04:34:56 | chemists | 3 | 146162 | 154 | 8.393 | 17414.8 |
| 606 | 2024-03-18 04:34:46 | chemists | 2 | 121059 | 22 | 3.546 | 34139.6 |
| 605 | 2024-03-18 04:34:46 | chemists | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 604 | 2024-03-17 04:39:17 | chemists | 3 | 146162 | 154 | 8.033 | 18195.2 |
| 603 | 2024-03-17 04:39:22 | chemists | 1 | 82945 | 5 | 1.576 | 52630.1 |
| 602 | 2024-03-17 04:39:15 | chemists | 2 | 121059 | 22 | 3.766 | 32145.2 |
| 601 | 2024-03-17 04:39:10 | chemists | 1 | 82945 | 5 | 1.466 | 56579.1 |
| 600 | 2024-02-14 22:17:45 | chemists | 3 | 146162 | 154 | 7.326 | 19951.1 |
| 599 | 2024-02-14 22:17:46 | chemists | 2 | 121059 | 22 | 3.763 | 32170.9 |
| 598 | 2024-02-14 22:17:40 | chemists | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 597 | 2024-02-05 22:08:02 | chemists | 2 | 121059 | 22 | 5.830 | 20764.8 |
| 596 | 2024-02-05 22:06:37 | chemists | 3 | 146162 | 154 | 6.156 | 23743.0 |
| 595 | 2024-02-04 04:36:02 | chemists | 2 | 121059 | 22 | 3.873 | 31257.2 |
| 594 | 2024-02-04 04:35:50 | chemists | 3 | 146162 | 154 | 7.110 | 20557.2 |
| 593 | 2024-02-04 04:24:35 | chemists | 3 | 146162 | 154 | 6.750 | 21653.6 |
| 592 | 2024-02-04 04:24:31 | chemists | 2 | 121059 | 22 | 3.313 | 36540.6 |
| 591 | 2024-02-04 04:24:27 | chemists | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 590 | 2024-01-09 20:06:26 | chemists | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 589 | 2024-01-05 19:34:44 | chemists | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 588 | 2023-12-25 14:34:14 | chemists | 1 | 82945 | 5 | 1.263 | 65673.0 |
| 587 | 2023-12-19 20:11:27 | chemists | 1 | 82945 | 5 | 1.920 | 43200.5 |
| 586 | 2023-11-12 18:34:27 | chemists | 1 | 82945 | 5 | 1.516 | 54713.1 |
| 585 | 2023-10-28 23:14:40 | chemists | 1 | 82945 | 5 | 2.580 | 32149.2 |
| 584 | 2023-10-13 23:37:08 | chemists | 1 | 82945 | 5 | 1.280 | 64800.8 |
| 583 | 2023-08-27 06:17:09 | chemists | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 582 | 2023-08-10 02:47:52 | chemists | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 581 | 2023-05-13 15:03:15 | chemists | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 580 | 2023-05-10 16:37:26 | chemists | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 579 | 2023-03-05 09:31:30 | chemists | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 578 | 2023-01-31 07:04:22 | chemists | 1 | 82945 | 5 | 2.390 | 34705.0 |
| 577 | 2023-01-27 18:23:45 | chemists | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 576 | 2022-12-27 18:23:12 | chemists | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 575 | 2022-10-06 05:08:30 | chemists | 1 | 82945 | 5 | 1.393 | 59544.1 |
| 574 | 2022-09-13 22:59:26 | chemists | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 573 | 2022-07-14 09:13:24 | chemists | 1 | 82945 | 5 | 1.330 | 62364.7 |
| 572 | 2022-06-26 16:02:54 | chemists | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 571 | 2022-06-23 04:12:14 | chemists | 1 | 82945 | 5 | 1.373 | 60411.5 |
| 570 | 2022-03-14 11:22:05 | chemists | 1 | 82945 | 5 | 1.906 | 43517.8 |
| 569 | 2022-03-07 05:22:37 | chemists | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 568 | 2022-01-06 04:45:44 | chemists | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 567 | 2022-01-05 16:41:08 | chemists | 1 | 82945 | 5 | 1.343 | 61761.0 |
| 566 | 2022-01-05 00:59:05 | chemists | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 565 | 2021-12-22 15:40:09 | chemists | 1 | 82945 | 5 | 1.483 | 55930.5 |
| 564 | 2021-11-28 15:10:40 | chemists | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 563 | 2021-11-28 02:31:37 | chemists | 1 | 82945 | 5 | 1.403 | 59119.7 |
| 562 | 2021-11-27 10:49:32 | chemists | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 561 | 2021-11-23 13:55:54 | chemists | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 560 | 2021-11-15 21:00:40 | chemists | 1 | 82945 | 5 | 1.436 | 57761.1 |
| 559 | 2021-11-15 12:39:58 | chemists | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 558 | 2021-11-14 21:07:44 | chemists | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 557 | 2021-11-14 12:05:34 | chemists | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 556 | 2021-11-13 20:48:44 | chemists | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 555 | 2021-11-13 10:45:32 | chemists | 1 | 82945 | 5 | 3.716 | 22321.0 |
| 554 | 2021-11-12 20:43:40 | chemists | 1 | 82945 | 5 | 1.296 | 64000.8 |
| 553 | 2021-11-12 10:39:32 | chemists | 1 | 82945 | 5 | 1.390 | 59672.7 |
| 552 | 2021-11-11 17:55:36 | chemists | 1 | 82945 | 5 | 1.486 | 55817.6 |
| 551 | 2021-11-11 07:04:57 | chemists | 1 | 82945 | 5 | 1.376 | 60279.8 |
| 550 | 2021-10-27 11:55:13 | chemists | 1 | 82945 | 5 | 1.250 | 66356.0 |
| 549 | 2021-10-26 19:10:58 | chemists | 1 | 82945 | 5 | 1.500 | 55296.7 |
| 548 | 2021-10-26 09:37:00 | chemists | 1 | 82945 | 5 | 1.420 | 58412.0 |
| 547 | 2021-10-25 13:49:41 | chemists | 1 | 82945 | 5 | 1.283 | 64649.3 |
| 546 | 2021-10-25 03:38:53 | chemists | 1 | 82945 | 5 | 1.423 | 58288.8 |
| 545 | 2021-10-24 19:44:28 | chemists | 1 | 82945 | 5 | 1.530 | 54212.4 |
| 544 | 2021-10-24 09:42:00 | chemists | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 543 | 2021-10-24 02:34:45 | chemists | 1 | 82945 | 5 | 2.876 | 28840.4 |
| 542 | 2021-10-23 16:14:48 | chemists | 1 | 82945 | 5 | 1.360 | 60989.0 |
| 541 | 2021-10-23 09:07:22 | chemists | 1 | 82945 | 5 | 1.453 | 57085.3 |
| 540 | 2021-10-22 16:18:10 | chemists | 1 | 82945 | 5 | 2.720 | 30494.5 |
| 539 | 2021-09-30 15:50:34 | chemists | 1 | 82945 | 5 | 1.406 | 58993.6 |
| 538 | 2021-09-28 08:24:37 | chemists | 2 | 121059 | 22 | 3.406 | 35542.9 |
| 537 | 2021-09-24 10:32:57 | chemists | 1 | 82945 | 5 | 2.843 | 29175.2 |
| 536 | 2021-09-23 17:17:48 | chemists | 1 | 82945 | 5 | 1.266 | 65517.4 |
| 535 | 2021-09-23 14:12:29 | chemists | 2 | 121059 | 22 | 3.406 | 35542.9 |
| 534 | 2021-09-23 13:36:27 | chemists | 1 | 82945 | 5 | 1.530 | 54212.4 |