History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mamma"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
618 | 2024-05-04 04:34:55 | mamma | 1 | 28756 | 10 | 1.080 | 26625.9 |
617 | 2024-05-04 01:03:21 | mamma | 2 | 53800 | 87 | 5.373 | 10013.0 |
616 | 2024-05-04 01:03:14 | mamma | 3 | 83667 | 868 | 4.686 | 17854.7 |
615 | 2024-05-04 00:07:07 | mamma | 1 | 28756 | 10 | 0.576 | 49923.6 |
614 | 2024-05-03 21:11:41 | mamma | 2 | 53800 | 87 | 1.860 | 28924.7 |
613 | 2024-05-03 21:11:36 | mamma | 1 | 28756 | 10 | 0.593 | 48492.4 |
612 | 2024-05-03 21:10:53 | mamma | 3 | 83667 | 868 | 6.970 | 12003.9 |
611 | 2024-05-03 14:59:22 | mamma | 3 | 83667 | 868 | 4.216 | 19845.1 |
610 | 2024-05-02 04:04:23 | mamma | 1 | 28756 | 10 | 0.936 | 30722.2 |
609 | 2024-04-30 10:46:09 | mamma | 1 | 28756 | 10 | 1.673 | 17188.3 |
608 | 2024-04-29 20:04:57 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
607 | 2024-04-28 06:58:42 | mamma | 1 | 28756 | 10 | 0.813 | 35370.2 |
606 | 2024-04-24 15:05:42 | mamma | 1 | 28756 | 10 | 1.266 | 22714.1 |
605 | 2024-04-24 14:34:29 | mamma | 1 | 28756 | 10 | 1.156 | 24875.4 |
604 | 2024-04-20 08:52:43 | mamma | 1 | 28756 | 10 | 0.470 | 61183.0 |
603 | 2024-04-11 01:45:23 | mamma | 1 | 28756 | 10 | 0.813 | 35370.2 |
602 | 2024-04-03 05:48:19 | mamma | 1 | 28756 | 10 | 1.046 | 27491.4 |
601 | 2024-03-31 09:21:13 | mamma | 2 | 53800 | 87 | 1.940 | 27732.0 |
600 | 2024-03-31 09:03:00 | mamma | 3 | 83667 | 868 | 6.203 | 13488.2 |
599 | 2024-03-31 09:02:59 | mamma | 2 | 53800 | 87 | 1.750 | 30742.9 |
598 | 2024-03-31 09:01:32 | mamma | 1 | 28756 | 10 | 0.530 | 54256.6 |
597 | 2024-03-30 20:06:09 | mamma | 3 | 83667 | 868 | 8.080 | 10354.8 |
596 | 2024-03-30 04:35:13 | mamma | 2 | 53800 | 87 | 3.780 | 14232.8 |
595 | 2024-03-30 04:34:30 | mamma | 3 | 83667 | 868 | 8.360 | 10008.0 |
594 | 2024-03-29 08:24:38 | mamma | 3 | 83667 | 868 | 11.580 | 7225.1 |
593 | 2024-03-29 08:24:38 | mamma | 2 | 53800 | 87 | 2.093 | 25704.7 |
592 | 2024-03-29 08:20:36 | mamma | 1 | 28756 | 10 | 0.546 | 52666.7 |
591 | 2024-03-03 21:52:55 | mamma | 1 | 28756 | 10 | 0.483 | 59536.2 |
590 | 2024-03-01 06:34:08 | mamma | 1 | 28756 | 10 | 0.533 | 53951.2 |
589 | 2024-02-28 05:15:07 | mamma | 3 | 83667 | 868 | 10.376 | 8063.5 |
588 | 2024-02-28 05:14:20 | mamma | 2 | 53800 | 87 | 3.143 | 17117.4 |
587 | 2024-02-28 03:51:26 | mamma | 2 | 53800 | 87 | 1.826 | 29463.3 |
586 | 2024-02-28 03:50:58 | mamma | 3 | 83667 | 868 | 4.326 | 19340.5 |
585 | 2024-02-28 03:05:01 | mamma | 3 | 83667 | 868 | 3.986 | 20990.2 |
584 | 2024-02-28 03:04:54 | mamma | 1 | 28756 | 10 | 0.516 | 55728.7 |
583 | 2024-01-31 13:58:33 | mamma | 2 | 53800 | 87 | 1.593 | 33772.8 |
582 | 2024-01-29 00:51:37 | mamma | 1 | 28756 | 10 | 0.516 | 55728.7 |
581 | 2024-01-28 20:39:56 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
580 | 2024-01-20 16:21:08 | mamma | 3 | 83667 | 868 | 3.296 | 25384.4 |
579 | 2024-01-12 20:10:47 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
578 | 2024-01-05 07:23:05 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
577 | 2024-01-04 07:40:56 | mamma | 2 | 53800 | 87 | 1.673 | 32157.8 |
576 | 2024-01-03 05:47:01 | mamma | 3 | 83667 | 868 | 8.126 | 10296.2 |
575 | 2023-12-23 01:33:48 | mamma | 1 | 28756 | 10 | 0.516 | 55728.7 |
574 | 2023-12-22 01:14:35 | mamma | 3 | 83667 | 868 | 3.716 | 22515.3 |
573 | 2023-12-10 04:30:57 | mamma | 2 | 53800 | 87 | 1.596 | 33709.3 |
572 | 2023-12-03 16:52:14 | mamma | 3 | 83667 | 868 | 3.970 | 21074.8 |
571 | 2023-12-01 02:48:12 | mamma | 2 | 53800 | 87 | 1.563 | 34421.0 |
570 | 2023-11-26 08:49:46 | mamma | 3 | 83667 | 868 | 3.826 | 21868.0 |
569 | 2023-11-26 08:49:48 | mamma | 2 | 53800 | 87 | 1.670 | 32215.6 |
568 | 2023-11-12 05:25:07 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
567 | 2023-11-10 19:50:37 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
566 | 2023-11-10 08:00:20 | mamma | 2 | 53800 | 87 | 1.406 | 38264.6 |
565 | 2023-11-07 02:17:10 | mamma | 1 | 28756 | 10 | 0.453 | 63479.0 |
564 | 2023-10-31 08:29:46 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
563 | 2023-10-31 02:06:18 | mamma | 3 | 83667 | 868 | 3.296 | 25384.4 |
562 | 2023-10-22 00:00:13 | mamma | 1 | 28756 | 10 | 0.450 | 63902.2 |
561 | 2023-10-20 07:50:46 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
560 | 2023-10-12 01:26:39 | mamma | 1 | 28756 | 10 | 0.483 | 59536.2 |
559 | 2023-10-05 06:40:43 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
558 | 2023-09-27 08:59:57 | mamma | 1 | 28756 | 10 | 0.440 | 65354.5 |
557 | 2023-09-23 17:46:18 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
556 | 2023-09-13 01:49:46 | mamma | 1 | 28756 | 10 | 0.470 | 61183.0 |
555 | 2023-09-09 17:59:24 | mamma | 1 | 28756 | 10 | 0.470 | 61183.0 |
554 | 2023-08-27 11:28:50 | mamma | 1 | 28756 | 10 | 0.440 | 65354.5 |
553 | 2023-08-13 12:23:18 | mamma | 2 | 53800 | 87 | 1.563 | 34421.0 |
552 | 2023-08-10 12:26:05 | mamma | 3 | 83667 | 868 | 4.063 | 20592.4 |
551 | 2023-08-09 13:17:26 | mamma | 3 | 83667 | 868 | 3.750 | 22311.2 |
550 | 2023-08-08 01:50:51 | mamma | 3 | 83667 | 868 | 3.313 | 25254.2 |
549 | 2023-05-30 05:31:12 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
548 | 2023-05-27 02:20:57 | mamma | 1 | 28756 | 10 | 0.440 | 65354.5 |
547 | 2023-05-12 21:14:09 | mamma | 1 | 28756 | 10 | 0.483 | 59536.2 |
546 | 2023-05-11 10:51:26 | mamma | 3 | 83667 | 868 | 4.046 | 20678.9 |
545 | 2023-04-25 12:11:04 | mamma | 2 | 53800 | 87 | 1.703 | 31591.3 |
544 | 2023-04-20 15:25:16 | mamma | 3 | 83667 | 868 | 3.983 | 21006.0 |
543 | 2023-04-10 09:33:24 | mamma | 3 | 83667 | 868 | 3.533 | 23681.6 |
542 | 2023-04-08 07:01:49 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
541 | 2023-03-23 19:55:14 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
540 | 2023-03-21 15:17:21 | mamma | 3 | 83667 | 868 | 3.516 | 23796.1 |
539 | 2023-02-21 22:10:27 | mamma | 3 | 83667 | 868 | 3.656 | 22884.8 |
538 | 2023-02-10 20:27:08 | mamma | 1 | 28756 | 10 | 0.440 | 65354.5 |
537 | 2023-01-28 03:50:51 | mamma | 2 | 53800 | 87 | 1.406 | 38264.6 |
536 | 2023-01-23 05:37:55 | mamma | 3 | 83667 | 868 | 3.640 | 22985.4 |
535 | 2023-01-08 00:53:03 | mamma | 1 | 28756 | 10 | 0.440 | 65354.5 |
534 | 2022-12-23 16:25:26 | mamma | 2 | 53800 | 87 | 1.563 | 34421.0 |
533 | 2022-11-10 10:10:32 | mamma | 2 | 53800 | 87 | 1.516 | 35488.1 |
532 | 2022-11-04 03:36:52 | mamma | 3 | 83667 | 868 | 3.796 | 22040.8 |
531 | 2022-10-24 07:57:01 | mamma | 1 | 28756 | 10 | 0.453 | 63479.0 |
530 | 2022-10-20 17:54:17 | mamma | 1 | 28756 | 10 | 0.453 | 63479.0 |
529 | 2022-10-05 23:18:54 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
528 | 2022-09-17 18:27:11 | mamma | 1 | 28756 | 10 | 0.453 | 63479.0 |
527 | 2022-09-03 12:25:52 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
526 | 2022-08-14 23:55:28 | mamma | 1 | 28756 | 10 | 0.436 | 65954.1 |
525 | 2022-08-14 04:30:02 | mamma | 1 | 28756 | 10 | 0.530 | 54256.6 |
524 | 2022-08-07 03:32:46 | mamma | 1 | 28756 | 10 | 0.483 | 59536.2 |
523 | 2022-07-29 08:04:16 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
522 | 2022-07-11 07:32:44 | mamma | 3 | 83667 | 868 | 3.703 | 22594.4 |
521 | 2022-07-11 07:31:30 | mamma | 2 | 53800 | 87 | 1.406 | 38264.6 |
520 | 2022-07-04 13:38:57 | mamma | 1 | 28756 | 10 | 0.500 | 57512.0 |
519 | 2022-06-12 12:13:21 | mamma | 2 | 53800 | 87 | 1.500 | 35866.7 |