History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smoking"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 613 | 2025-01-03 22:00:16 | smoking | 2 | 107671 | 79 | 12.063 | 8925.7 |
| 612 | 2025-01-03 19:57:35 | smoking | 2 | 107671 | 79 | 17.643 | 6102.8 |
| 611 | 2025-01-03 19:27:27 | smoking | 3 | 134027 | 775 | 8.500 | 15767.9 |
| 610 | 2024-12-25 17:18:59 | smoking | 3 | 134027 | 775 | 38.266 | 3502.5 |
| 609 | 2024-12-24 12:20:41 | smoking | 3 | 134027 | 775 | 36.313 | 3690.9 |
| 608 | 2024-12-24 05:46:33 | smoking | 3 | 134027 | 775 | 36.236 | 3698.7 |
| 607 | 2024-12-16 14:10:16 | smoking | 1 | 69583 | 4 | 5.890 | 11813.8 |
| 606 | 2024-12-13 13:48:23 | smoking | 1 | 69583 | 4 | 7.936 | 8768.0 |
| 605 | 2024-12-10 12:08:42 | smoking | 1 | 69583 | 4 | 3.080 | 22591.9 |
| 604 | 2024-12-04 00:06:44 | smoking | 3 | 134027 | 775 | 34.740 | 3858.0 |
| 603 | 2024-11-20 19:59:13 | smoking | 2 | 107671 | 79 | 6.516 | 16524.1 |
| 602 | 2024-11-18 14:09:08 | smoking | 2 | 107671 | 79 | 5.720 | 18823.6 |
| 601 | 2024-11-18 13:38:57 | smoking | 2 | 107671 | 79 | 3.390 | 31761.4 |
| 600 | 2024-11-13 02:13:17 | smoking | 1 | 69583 | 4 | 3.486 | 19960.7 |
| 599 | 2024-11-12 09:02:19 | smoking | 3 | 134027 | 775 | 22.593 | 5932.2 |
| 598 | 2024-11-12 08:41:00 | smoking | 3 | 134027 | 775 | 39.033 | 3433.7 |
| 597 | 2024-11-11 23:07:14 | smoking | 1 | 69583 | 4 | 3.936 | 17678.6 |
| 596 | 2024-11-11 21:00:04 | smoking | 3 | 134027 | 775 | 33.970 | 3945.5 |
| 595 | 2024-11-11 21:00:10 | smoking | 2 | 107671 | 79 | 23.203 | 4640.4 |
| 594 | 2024-11-11 10:30:55 | smoking | 1 | 69583 | 4 | 2.966 | 23460.2 |
| 593 | 2024-11-08 06:32:05 | smoking | 1 | 69583 | 4 | 3.923 | 17737.2 |
| 592 | 2024-10-23 14:27:51 | smoking | 1 | 69583 | 4 | 3.063 | 22717.3 |
| 591 | 2024-10-16 09:48:08 | smoking | 1 | 69583 | 4 | 5.766 | 12067.8 |
| 590 | 2024-10-12 17:39:39 | smoking | 1 | 69583 | 4 | 2.873 | 24219.6 |
| 589 | 2024-09-15 22:12:27 | smoking | 2 | 107671 | 79 | 26.046 | 4133.9 |
| 588 | 2024-09-15 18:23:14 | smoking | 2 | 107671 | 79 | 20.753 | 5188.2 |
| 587 | 2024-09-15 18:22:57 | smoking | 1 | 69583 | 4 | 4.250 | 16372.5 |
| 586 | 2024-09-10 23:08:35 | smoking | 1 | 69583 | 4 | 12.016 | 5790.9 |
| 585 | 2024-09-06 06:09:51 | smoking | 1 | 69583 | 4 | 12.026 | 5786.0 |
| 584 | 2024-09-05 13:38:07 | smoking | 1 | 69583 | 4 | 9.626 | 7228.7 |
| 583 | 2024-08-15 22:44:32 | smoking | 2 | 107671 | 79 | 27.530 | 3911.0 |
| 582 | 2024-08-15 22:44:49 | smoking | 1 | 69583 | 4 | 4.373 | 15912.0 |
| 581 | 2024-08-12 22:20:53 | smoking | 1 | 69583 | 4 | 8.266 | 8418.0 |
| 580 | 2024-08-11 14:26:33 | smoking | 3 | 134027 | 775 | 37.453 | 3578.5 |
| 579 | 2024-08-11 13:37:01 | smoking | 1 | 69583 | 4 | 5.580 | 12470.1 |
| 578 | 2024-08-10 01:24:47 | smoking | 3 | 134027 | 775 | 12.796 | 10474.1 |
| 577 | 2024-08-09 17:25:09 | smoking | 3 | 134027 | 775 | 31.563 | 4246.3 |
| 576 | 2024-08-09 16:10:05 | smoking | 3 | 134027 | 775 | 25.940 | 5166.8 |
| 575 | 2024-08-09 16:10:05 | smoking | 2 | 107671 | 79 | 9.923 | 10850.7 |
| 574 | 2024-08-09 15:52:17 | smoking | 1 | 69583 | 4 | 2.033 | 34226.8 |
| 573 | 2024-08-04 06:09:47 | smoking | 2 | 107671 | 79 | 9.860 | 10920.0 |
| 572 | 2024-08-02 09:25:17 | smoking | 1 | 69583 | 4 | 2.063 | 33729.0 |
| 571 | 2024-08-01 06:28:38 | smoking | 1 | 69583 | 4 | 4.420 | 15742.8 |
| 570 | 2024-07-29 03:46:03 | smoking | 1 | 69583 | 4 | 1.953 | 35628.8 |
| 569 | 2024-07-11 11:02:01 | smoking | 1 | 69583 | 4 | 5.203 | 13373.6 |
| 568 | 2024-07-06 17:41:26 | smoking | 1 | 69583 | 4 | 2.000 | 34791.5 |
| 567 | 2024-07-01 23:59:36 | smoking | 1 | 69583 | 4 | 5.440 | 12791.0 |
| 566 | 2024-07-01 22:25:48 | smoking | 1 | 69583 | 4 | 4.873 | 14279.3 |
| 565 | 2024-07-01 08:09:14 | smoking | 1 | 69583 | 4 | 4.626 | 15041.7 |
| 564 | 2024-06-16 06:34:04 | smoking | 1 | 69583 | 4 | 2.813 | 24736.2 |
| 563 | 2024-06-10 12:38:34 | smoking | 1 | 69583 | 4 | 4.640 | 14996.3 |
| 562 | 2024-06-07 01:06:03 | smoking | 1 | 69583 | 4 | 1.310 | 53116.8 |
| 561 | 2024-05-30 05:28:12 | smoking | 3 | 134027 | 775 | 28.063 | 4775.9 |
| 560 | 2024-05-29 16:57:59 | smoking | 3 | 134027 | 775 | 12.610 | 10628.6 |
| 559 | 2024-05-28 00:09:19 | smoking | 3 | 134027 | 775 | 27.843 | 4813.7 |
| 558 | 2024-05-25 13:55:15 | smoking | 3 | 134027 | 775 | 18.906 | 7089.1 |
| 557 | 2024-05-25 12:30:14 | smoking | 3 | 134027 | 775 | 13.626 | 9836.1 |
| 556 | 2024-05-21 09:36:51 | smoking | 3 | 134027 | 775 | 13.016 | 10297.1 |
| 555 | 2024-05-20 08:48:52 | smoking | 3 | 134027 | 775 | 8.716 | 15377.1 |
| 554 | 2024-05-20 08:48:50 | smoking | 3 | 134027 | 775 | 9.220 | 14536.6 |
| 553 | 2024-05-10 01:51:24 | smoking | 2 | 107671 | 79 | 3.780 | 28484.4 |
| 552 | 2024-04-26 22:28:55 | smoking | 1 | 69583 | 4 | 2.716 | 25619.7 |
| 551 | 2024-04-25 11:06:29 | smoking | 1 | 69583 | 4 | 4.050 | 17181.0 |
| 550 | 2024-04-22 14:11:31 | smoking | 1 | 69583 | 4 | 2.703 | 25742.9 |
| 549 | 2024-03-25 23:40:41 | smoking | 3 | 134027 | 775 | 12.686 | 10565.0 |
| 548 | 2024-03-25 18:40:32 | smoking | 2 | 107671 | 79 | 2.830 | 38046.3 |
| 547 | 2024-03-25 18:26:04 | smoking | 3 | 134027 | 775 | 6.563 | 20421.6 |
| 546 | 2024-03-25 13:46:15 | smoking | 2 | 107671 | 79 | 3.190 | 33752.7 |
| 545 | 2024-03-25 13:45:41 | smoking | 3 | 134027 | 775 | 5.796 | 23124.1 |
| 544 | 2024-03-23 08:36:05 | smoking | 2 | 107671 | 79 | 5.843 | 18427.3 |
| 543 | 2024-03-23 08:09:05 | smoking | 1 | 69583 | 4 | 1.406 | 49490.0 |
| 542 | 2024-03-23 03:50:14 | smoking | 3 | 134027 | 775 | 7.970 | 16816.4 |
| 541 | 2024-03-22 06:50:04 | smoking | 3 | 134027 | 775 | 7.266 | 18445.8 |
| 540 | 2024-03-22 06:50:05 | smoking | 2 | 107671 | 79 | 3.576 | 30109.3 |
| 539 | 2024-03-22 06:49:55 | smoking | 1 | 69583 | 4 | 1.483 | 46920.4 |
| 538 | 2024-03-17 15:28:11 | smoking | 1 | 69583 | 4 | 1.236 | 56296.9 |
| 537 | 2024-02-21 20:51:09 | smoking | 1 | 69583 | 4 | 1.220 | 57035.2 |
| 536 | 2024-02-20 06:26:33 | smoking | 1 | 69583 | 4 | 3.706 | 18775.8 |
| 535 | 2024-02-12 09:47:52 | smoking | 2 | 107671 | 79 | 3.716 | 28975.0 |
| 534 | 2024-02-11 20:10:29 | smoking | 2 | 107671 | 79 | 3.920 | 27467.1 |
| 533 | 2024-02-09 20:44:37 | smoking | 2 | 107671 | 79 | 3.126 | 34443.7 |
| 532 | 2024-02-09 20:29:28 | smoking | 3 | 134027 | 775 | 7.346 | 18244.9 |
| 531 | 2024-01-27 11:55:05 | smoking | 3 | 134027 | 775 | 6.750 | 19855.9 |
| 530 | 2024-01-27 09:52:39 | smoking | 3 | 134027 | 775 | 7.343 | 18252.3 |
| 529 | 2024-01-22 11:18:00 | smoking | 1 | 69583 | 4 | 3.843 | 18106.4 |
| 528 | 2024-01-21 04:46:58 | smoking | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 527 | 2024-01-14 13:54:41 | smoking | 3 | 134027 | 775 | 5.796 | 23124.1 |
| 526 | 2024-01-04 00:51:29 | smoking | 2 | 107671 | 79 | 2.936 | 36672.7 |
| 525 | 2023-12-23 08:12:11 | smoking | 1 | 69583 | 4 | 1.203 | 57841.2 |
| 524 | 2023-12-19 03:08:45 | smoking | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 523 | 2023-12-11 00:13:38 | smoking | 1 | 69583 | 4 | 1.233 | 56433.9 |
| 522 | 2023-11-19 05:41:56 | smoking | 1 | 69583 | 4 | 1.186 | 58670.3 |
| 521 | 2023-10-30 07:58:02 | smoking | 3 | 134027 | 775 | 10.156 | 13196.8 |
| 520 | 2023-10-28 12:50:20 | smoking | 3 | 134027 | 775 | 12.846 | 10433.4 |
| 519 | 2023-10-24 11:37:49 | smoking | 3 | 134027 | 775 | 8.063 | 16622.5 |
| 518 | 2023-10-19 17:53:01 | smoking | 1 | 69583 | 4 | 1.063 | 65459.1 |
| 517 | 2023-10-11 01:15:33 | smoking | 2 | 107671 | 79 | 3.200 | 33647.2 |
| 516 | 2023-10-07 20:25:11 | smoking | 1 | 69583 | 4 | 1.076 | 64668.2 |
| 515 | 2023-09-21 08:10:54 | smoking | 1 | 69583 | 4 | 1.060 | 65644.3 |
| 514 | 2023-08-03 21:05:00 | smoking | 1 | 69583 | 4 | 1.080 | 64428.7 |