History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smoker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
611 | 2024-04-27 04:49:20 | smoker | 1 | 48755 | 8 | 0.920 | 52994.6 |
610 | 2024-04-13 23:04:20 | smoker | 2 | 82551 | 79 | 9.890 | 8346.9 |
609 | 2024-03-31 09:09:06 | smoker | 2 | 82551 | 79 | 5.000 | 16510.2 |
608 | 2024-03-31 09:09:02 | smoker | 1 | 48755 | 8 | 0.923 | 52822.3 |
607 | 2024-03-06 04:55:08 | smoker | 2 | 82551 | 79 | 6.390 | 12918.8 |
606 | 2024-03-06 03:27:49 | smoker | 3 | 112716 | 959 | 5.936 | 18988.5 |
605 | 2024-03-04 04:18:50 | smoker | 1 | 48755 | 8 | 1.953 | 24964.2 |
604 | 2024-03-04 04:14:22 | smoker | 3 | 112716 | 959 | 5.986 | 18829.9 |
603 | 2024-03-04 04:14:20 | smoker | 2 | 82551 | 79 | 2.576 | 32046.2 |
602 | 2024-02-28 05:23:37 | smoker | 3 | 112716 | 959 | 10.953 | 10290.9 |
601 | 2024-02-28 05:18:42 | smoker | 3 | 112716 | 959 | 8.050 | 14002.0 |
600 | 2024-02-28 05:06:16 | smoker | 3 | 112716 | 959 | 15.423 | 7308.3 |
599 | 2024-02-28 05:06:15 | smoker | 2 | 82551 | 79 | 4.846 | 17034.9 |
598 | 2024-02-28 05:06:11 | smoker | 1 | 48755 | 8 | 1.236 | 39445.8 |
597 | 2024-01-13 22:39:49 | smoker | 1 | 48755 | 8 | 0.766 | 63648.8 |
596 | 2024-01-03 03:25:58 | smoker | 3 | 112716 | 959 | 9.110 | 12372.8 |
595 | 2023-12-27 13:43:22 | smoker | 3 | 112716 | 959 | 5.390 | 20912.1 |
594 | 2023-12-23 22:38:02 | smoker | 2 | 82551 | 79 | 2.373 | 34787.6 |
593 | 2023-12-21 18:34:25 | smoker | 3 | 112716 | 959 | 4.623 | 24381.6 |
592 | 2023-12-13 22:12:18 | smoker | 2 | 82551 | 79 | 2.110 | 39123.7 |
591 | 2023-11-18 05:19:51 | smoker | 1 | 48755 | 8 | 0.860 | 56691.9 |
590 | 2023-11-15 13:16:15 | smoker | 1 | 48755 | 8 | 0.766 | 63648.8 |
589 | 2023-11-12 05:33:44 | smoker | 2 | 82551 | 79 | 2.266 | 36430.3 |
588 | 2023-11-12 05:33:40 | smoker | 3 | 112716 | 959 | 4.906 | 22975.1 |
587 | 2023-11-08 04:47:08 | smoker | 1 | 48755 | 8 | 0.876 | 55656.4 |
586 | 2023-11-07 21:48:56 | smoker | 1 | 48755 | 8 | 0.780 | 62506.4 |
585 | 2023-11-01 17:18:22 | smoker | 1 | 48755 | 8 | 0.733 | 66514.3 |
584 | 2023-10-29 10:37:34 | smoker | 3 | 112716 | 959 | 9.640 | 11692.5 |
583 | 2023-10-25 21:52:21 | smoker | 1 | 48755 | 8 | 0.876 | 55656.4 |
582 | 2023-10-24 02:44:25 | smoker | 3 | 112716 | 959 | 11.436 | 9856.2 |
581 | 2023-10-20 13:21:56 | smoker | 3 | 112716 | 959 | 6.313 | 17854.6 |
580 | 2023-10-18 22:52:56 | smoker | 1 | 48755 | 8 | 0.733 | 66514.3 |
579 | 2023-10-17 20:50:55 | smoker | 3 | 112716 | 959 | 5.266 | 21404.5 |
578 | 2023-10-15 19:22:01 | smoker | 1 | 48755 | 8 | 0.750 | 65006.7 |
577 | 2023-10-13 06:32:00 | smoker | 3 | 112716 | 959 | 5.626 | 20034.8 |
576 | 2023-10-09 11:30:03 | smoker | 3 | 112716 | 959 | 8.453 | 13334.4 |
575 | 2023-10-05 08:44:56 | smoker | 1 | 48755 | 8 | 0.796 | 61250.0 |
574 | 2023-10-04 06:00:38 | smoker | 3 | 112716 | 959 | 5.063 | 22262.7 |
573 | 2023-10-02 23:55:29 | smoker | 3 | 112716 | 959 | 4.656 | 24208.8 |
572 | 2023-09-29 23:31:50 | smoker | 3 | 112716 | 959 | 6.126 | 18399.6 |
571 | 2023-09-29 07:14:09 | smoker | 1 | 48755 | 8 | 0.796 | 61250.0 |
570 | 2023-09-28 01:01:25 | smoker | 3 | 112716 | 959 | 5.716 | 19719.4 |
569 | 2023-09-25 17:29:37 | smoker | 1 | 48755 | 8 | 0.906 | 53813.5 |
568 | 2023-09-21 03:07:13 | smoker | 3 | 112716 | 959 | 5.220 | 21593.1 |
567 | 2023-09-14 12:38:38 | smoker | 1 | 48755 | 8 | 0.780 | 62506.4 |
566 | 2023-09-13 23:01:03 | smoker | 2 | 82551 | 79 | 2.170 | 38041.9 |
565 | 2023-08-29 03:02:51 | smoker | 1 | 48755 | 8 | 0.750 | 65006.7 |
564 | 2023-08-24 12:11:24 | smoker | 3 | 112716 | 959 | 5.156 | 21861.1 |
563 | 2023-08-12 05:44:27 | smoker | 3 | 112716 | 959 | 4.610 | 24450.3 |
562 | 2023-07-20 00:52:22 | smoker | 3 | 112716 | 959 | 5.563 | 20261.7 |
561 | 2023-06-24 12:42:25 | smoker | 1 | 48755 | 8 | 0.830 | 58741.0 |
560 | 2023-06-21 03:14:42 | smoker | 1 | 48755 | 8 | 0.733 | 66514.3 |
559 | 2023-06-12 05:33:09 | smoker | 2 | 82551 | 79 | 2.093 | 39441.5 |
558 | 2023-05-31 17:23:39 | smoker | 1 | 48755 | 8 | 0.780 | 62506.4 |
557 | 2023-05-10 20:19:58 | smoker | 3 | 112716 | 959 | 5.420 | 20796.3 |
556 | 2023-04-21 20:14:48 | smoker | 3 | 112716 | 959 | 4.686 | 24053.8 |
555 | 2023-04-13 08:00:44 | smoker | 3 | 112716 | 959 | 5.236 | 21527.1 |
554 | 2023-04-12 07:48:54 | smoker | 3 | 112716 | 959 | 5.313 | 21215.1 |
553 | 2023-04-11 07:53:31 | smoker | 3 | 112716 | 959 | 5.436 | 20735.1 |
552 | 2023-04-10 07:51:30 | smoker | 3 | 112716 | 959 | 6.140 | 18357.7 |
551 | 2023-04-09 07:52:26 | smoker | 3 | 112716 | 959 | 5.250 | 21469.7 |
550 | 2023-04-08 07:58:33 | smoker | 3 | 112716 | 959 | 4.860 | 23192.6 |
549 | 2023-04-07 07:47:30 | smoker | 3 | 112716 | 959 | 5.470 | 20606.2 |
548 | 2023-04-04 08:23:05 | smoker | 3 | 112716 | 959 | 5.343 | 21096.0 |
547 | 2023-04-03 07:56:39 | smoker | 3 | 112716 | 959 | 5.390 | 20912.1 |
546 | 2023-04-02 13:01:11 | smoker | 3 | 112716 | 959 | 4.580 | 24610.5 |
545 | 2023-04-02 07:42:38 | smoker | 3 | 112716 | 959 | 5.106 | 22075.2 |
544 | 2023-04-02 03:10:02 | smoker | 3 | 112716 | 959 | 4.596 | 24524.8 |
543 | 2023-04-01 07:42:33 | smoker | 3 | 112716 | 959 | 5.420 | 20796.3 |
542 | 2023-03-31 07:40:10 | smoker | 3 | 112716 | 959 | 4.546 | 24794.5 |
541 | 2023-03-30 07:31:28 | smoker | 3 | 112716 | 959 | 4.563 | 24702.2 |
540 | 2023-03-29 07:36:39 | smoker | 3 | 112716 | 959 | 5.330 | 21147.5 |
539 | 2023-03-28 07:33:16 | smoker | 3 | 112716 | 959 | 5.626 | 20034.8 |
538 | 2023-03-27 08:33:59 | smoker | 3 | 112716 | 959 | 4.563 | 24702.2 |
537 | 2023-03-26 08:30:53 | smoker | 3 | 112716 | 959 | 4.800 | 23482.5 |
536 | 2023-03-25 10:26:33 | smoker | 1 | 48755 | 8 | 0.830 | 58741.0 |
535 | 2023-03-25 08:29:19 | smoker | 3 | 112716 | 959 | 5.140 | 21929.2 |
534 | 2023-03-24 08:45:16 | smoker | 3 | 112716 | 959 | 5.140 | 21929.2 |
533 | 2023-03-23 08:38:31 | smoker | 3 | 112716 | 959 | 4.516 | 24959.3 |
532 | 2023-03-22 08:28:28 | smoker | 3 | 112716 | 959 | 5.046 | 22337.7 |
531 | 2023-03-21 08:28:30 | smoker | 3 | 112716 | 959 | 6.660 | 16924.3 |
530 | 2023-03-21 00:23:37 | smoker | 3 | 112716 | 959 | 5.016 | 22471.3 |
529 | 2023-03-20 08:30:35 | smoker | 3 | 112716 | 959 | 4.686 | 24053.8 |
528 | 2023-03-19 08:34:03 | smoker | 3 | 112716 | 959 | 11.593 | 9722.8 |
527 | 2023-03-18 07:23:36 | smoker | 3 | 112716 | 959 | 5.156 | 21861.1 |
526 | 2023-03-17 07:19:09 | smoker | 3 | 112716 | 959 | 6.093 | 18499.3 |
525 | 2023-03-15 07:11:50 | smoker | 3 | 112716 | 959 | 5.610 | 20092.0 |
524 | 2023-03-14 07:28:53 | smoker | 3 | 112716 | 959 | 4.610 | 24450.3 |
523 | 2023-03-13 07:22:51 | smoker | 3 | 112716 | 959 | 5.750 | 19602.8 |
522 | 2023-03-13 01:04:45 | smoker | 2 | 82551 | 79 | 2.110 | 39123.7 |
521 | 2023-03-10 07:07:35 | smoker | 3 | 112716 | 959 | 4.610 | 24450.3 |
520 | 2023-03-09 07:34:50 | smoker | 3 | 112716 | 959 | 4.546 | 24794.5 |
519 | 2023-03-08 07:35:50 | smoker | 3 | 112716 | 959 | 5.686 | 19823.4 |
518 | 2023-03-07 07:07:37 | smoker | 3 | 112716 | 959 | 4.690 | 24033.3 |
517 | 2023-03-06 07:08:43 | smoker | 3 | 112716 | 959 | 5.580 | 20200.0 |
516 | 2023-03-05 07:27:11 | smoker | 3 | 112716 | 959 | 4.513 | 24975.8 |
515 | 2023-03-04 11:10:04 | smoker | 2 | 82551 | 79 | 2.406 | 34310.5 |
514 | 2023-03-04 07:45:43 | smoker | 1 | 48755 | 8 | 0.843 | 57835.1 |
513 | 2023-03-04 06:56:25 | smoker | 3 | 112716 | 959 | 4.966 | 22697.5 |
512 | 2023-03-03 06:57:05 | smoker | 3 | 112716 | 959 | 5.610 | 20092.0 |