History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affirmant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
609 | 2025-08-26 19:07:06 | affirmant | 1 | 81242 | 2 | 1.360 | 59736.8 |
608 | 2025-07-26 19:52:08 | affirmant | 1 | 81242 | 2 | 6.610 | 12290.8 |
607 | 2025-07-24 00:33:15 | affirmant | 1 | 81242 | 2 | 9.703 | 8372.9 |
606 | 2025-07-16 00:49:13 | affirmant | 1 | 81242 | 2 | 1.736 | 46798.4 |
605 | 2025-07-04 20:42:38 | affirmant | 3 | 148641 | 24 | 37.610 | 3952.2 |
604 | 2025-06-27 07:15:48 | affirmant | 3 | 148641 | 24 | 48.816 | 3044.9 |
603 | 2025-06-27 06:07:12 | affirmant | 2 | 121436 | 6 | 22.016 | 5515.8 |
602 | 2025-06-27 00:05:23 | affirmant | 3 | 148641 | 24 | 34.500 | 4308.4 |
601 | 2025-06-25 19:30:19 | affirmant | 1 | 81242 | 2 | 1.263 | 64324.6 |
600 | 2025-06-22 07:24:28 | affirmant | 1 | 81242 | 2 | 10.456 | 7769.9 |
599 | 2025-06-14 20:40:32 | affirmant | 4 | 165329 | 95 | 64.440 | 2565.6 |
598 | 2025-06-14 18:29:48 | affirmant | 2 | 121436 | 6 | 15.893 | 7640.8 |
597 | 2025-06-13 14:02:09 | affirmant | 1 | 81242 | 2 | 9.483 | 8567.1 |
596 | 2025-06-08 12:01:32 | affirmant | 1 | 81242 | 2 | 6.766 | 12007.4 |
595 | 2025-06-02 19:47:52 | affirmant | 1 | 81242 | 2 | 1.330 | 61084.2 |
594 | 2025-06-01 21:20:36 | affirmant | 5 | 174418 | 795 | 105.440 | 1654.2 |
593 | 2025-06-01 09:27:36 | affirmant | 5 | 174418 | 795 | 89.770 | 1942.9 |
592 | 2025-05-31 01:42:28 | affirmant | 5 | 174418 | 795 | 106.036 | 1644.9 |
591 | 2025-05-30 21:22:44 | affirmant | 5 | 174418 | 795 | 63.206 | 2759.5 |
590 | 2025-05-30 02:15:45 | affirmant | 5 | 174418 | 795 | 53.410 | 3265.6 |
589 | 2025-05-30 00:33:28 | affirmant | 1 | 81242 | 2 | 1.406 | 57782.4 |
588 | 2025-05-27 21:31:00 | affirmant | 5 | 174418 | 795 | 22.373 | 7795.9 |
587 | 2025-05-27 20:34:48 | affirmant | 4 | 165329 | 95 | 16.046 | 10303.4 |
586 | 2025-05-27 05:40:41 | affirmant | 2 | 121436 | 6 | 15.123 | 8029.9 |
585 | 2025-05-27 02:01:05 | affirmant | 3 | 148641 | 24 | 25.280 | 5879.8 |
584 | 2025-05-25 19:45:46 | affirmant | 1 | 81242 | 2 | 3.406 | 23852.6 |
583 | 2025-05-04 03:15:43 | affirmant | 1 | 81242 | 2 | 6.846 | 11867.1 |
582 | 2025-05-03 05:06:10 | affirmant | 1 | 81242 | 2 | 6.970 | 11656.0 |
581 | 2025-04-22 19:32:26 | affirmant | 1 | 81242 | 2 | 4.250 | 19115.8 |
580 | 2025-04-04 00:29:20 | affirmant | 4 | 165329 | 95 | 77.803 | 2125.0 |
579 | 2025-04-01 09:07:10 | affirmant | 4 | 165329 | 95 | 10.500 | 15745.6 |
578 | 2025-04-01 04:31:43 | affirmant | 3 | 148641 | 24 | 7.156 | 20771.5 |
577 | 2025-03-31 17:37:10 | affirmant | 3 | 148641 | 24 | 39.706 | 3743.5 |
576 | 2025-03-27 08:20:09 | affirmant | 2 | 121436 | 6 | 17.420 | 6971.1 |
575 | 2025-03-27 04:20:34 | affirmant | 3 | 148641 | 24 | 21.016 | 7072.8 |
574 | 2025-03-26 19:11:56 | affirmant | 2 | 121436 | 6 | 16.126 | 7530.4 |
573 | 2025-03-19 20:27:27 | affirmant | 1 | 81242 | 2 | 5.080 | 15992.5 |
572 | 2025-03-02 11:01:12 | affirmant | 1 | 81242 | 2 | 9.076 | 8951.3 |
571 | 2025-02-28 21:26:49 | affirmant | 1 | 81242 | 2 | 3.890 | 20884.8 |
570 | 2025-02-27 08:25:07 | affirmant | 2 | 121436 | 6 | 55.570 | 2185.3 |
569 | 2025-02-27 07:18:52 | affirmant | 1 | 81242 | 2 | 1.406 | 57782.4 |
568 | 2025-01-31 14:57:32 | affirmant | 3 | 148641 | 24 | 35.920 | 4138.1 |
567 | 2025-01-31 14:57:33 | affirmant | 2 | 121436 | 6 | 16.300 | 7450.1 |
566 | 2025-01-31 14:56:49 | affirmant | 1 | 81242 | 2 | 6.813 | 11924.6 |
565 | 2025-01-30 09:57:45 | affirmant | 3 | 148641 | 24 | 33.330 | 4459.7 |
564 | 2025-01-27 05:14:46 | affirmant | 3 | 148641 | 24 | 38.063 | 3905.1 |
563 | 2025-01-23 23:13:37 | affirmant | 3 | 148641 | 24 | 18.656 | 7967.5 |
562 | 2025-01-19 21:34:06 | affirmant | 1 | 81242 | 2 | 3.610 | 22504.7 |
561 | 2025-01-17 15:45:13 | affirmant | 3 | 148641 | 24 | 34.813 | 4269.7 |
560 | 2025-01-17 15:45:05 | affirmant | 3 | 148641 | 24 | 40.796 | 3643.5 |
559 | 2025-01-17 15:45:02 | affirmant | 3 | 148641 | 24 | 27.783 | 5350.1 |
558 | 2025-01-17 15:45:06 | affirmant | 2 | 121436 | 6 | 17.233 | 7046.7 |
557 | 2025-01-17 15:44:32 | affirmant | 1 | 81242 | 2 | 7.250 | 11205.8 |
556 | 2025-01-16 22:17:02 | affirmant | 3 | 148641 | 24 | 37.016 | 4015.6 |
555 | 2024-12-30 21:46:18 | affirmant | 1 | 81242 | 2 | 1.326 | 61268.5 |
554 | 2024-12-20 05:57:06 | affirmant | 2 | 121436 | 6 | 23.750 | 5113.1 |
553 | 2024-12-20 05:56:33 | affirmant | 3 | 148641 | 24 | 33.126 | 4487.1 |
552 | 2024-12-20 05:18:10 | affirmant | 1 | 81242 | 2 | 2.843 | 28576.2 |
551 | 2024-12-17 14:55:38 | affirmant | 3 | 148641 | 24 | 44.410 | 3347.0 |
550 | 2024-12-17 14:55:38 | affirmant | 3 | 148641 | 24 | 32.550 | 4566.5 |
549 | 2024-12-17 14:55:40 | affirmant | 2 | 121436 | 6 | 16.906 | 7183.0 |
548 | 2024-12-17 14:54:10 | affirmant | 1 | 81242 | 2 | 2.673 | 30393.6 |
547 | 2024-12-17 08:07:25 | affirmant | 3 | 148641 | 24 | 52.766 | 2817.0 |
546 | 2024-12-16 19:40:51 | affirmant | 4 | 165329 | 95 | 76.846 | 2151.4 |
545 | 2024-12-16 19:40:46 | affirmant | 4 | 165329 | 95 | 52.783 | 3132.2 |
544 | 2024-12-16 19:41:12 | affirmant | 2 | 121436 | 6 | 16.923 | 7175.8 |
543 | 2024-12-16 19:40:51 | affirmant | 3 | 148641 | 24 | 35.910 | 4139.3 |
542 | 2024-12-16 19:39:28 | affirmant | 1 | 81242 | 2 | 1.826 | 44491.8 |
541 | 2024-11-27 15:27:13 | affirmant | 1 | 81242 | 2 | 1.436 | 56575.2 |
540 | 2024-11-17 01:13:13 | affirmant | 3 | 148641 | 24 | 11.860 | 12533.0 |
539 | 2024-11-17 01:13:13 | affirmant | 3 | 148641 | 24 | 7.673 | 19372.0 |
538 | 2024-11-17 01:08:40 | affirmant | 1 | 81242 | 2 | 3.750 | 21664.5 |
537 | 2024-11-12 15:37:09 | affirmant | 2 | 121436 | 6 | 25.623 | 4739.3 |
536 | 2024-11-05 00:22:20 | affirmant | 3 | 148641 | 24 | 44.456 | 3343.6 |
535 | 2024-11-04 23:08:08 | affirmant | 3 | 148641 | 24 | 35.846 | 4146.7 |
534 | 2024-11-04 23:08:01 | affirmant | 2 | 121436 | 6 | 16.250 | 7473.0 |
533 | 2024-10-31 21:28:38 | affirmant | 1 | 81242 | 2 | 7.360 | 11038.3 |
532 | 2024-10-17 04:13:20 | affirmant | 3 | 148641 | 24 | 39.236 | 3788.4 |
531 | 2024-10-17 04:13:18 | affirmant | 3 | 148641 | 24 | 36.410 | 4082.4 |
530 | 2024-10-17 04:10:12 | affirmant | 1 | 81242 | 2 | 6.673 | 12174.7 |
529 | 2024-10-16 22:00:50 | affirmant | 3 | 148641 | 24 | 33.250 | 4470.4 |
528 | 2024-10-16 21:59:59 | affirmant | 1 | 81242 | 2 | 3.200 | 25388.1 |
527 | 2024-10-12 09:58:16 | affirmant | 3 | 148641 | 24 | 43.223 | 3438.9 |
526 | 2024-10-11 18:39:40 | affirmant | 2 | 121436 | 6 | 12.343 | 9838.5 |
525 | 2024-10-10 07:00:57 | affirmant | 2 | 121436 | 6 | 13.936 | 8713.8 |
524 | 2024-10-08 13:03:20 | affirmant | 3 | 148641 | 24 | 74.316 | 2000.1 |
523 | 2024-10-05 07:37:29 | affirmant | 3 | 148641 | 24 | 49.986 | 2973.7 |
522 | 2024-09-30 18:01:27 | affirmant | 3 | 148641 | 24 | 55.800 | 2663.8 |
521 | 2024-09-22 20:38:12 | affirmant | 3 | 148641 | 24 | 54.630 | 2720.9 |
520 | 2024-09-22 00:13:30 | affirmant | 3 | 148641 | 24 | 56.223 | 2643.8 |
519 | 2024-09-22 00:13:30 | affirmant | 3 | 148641 | 24 | 40.016 | 3714.5 |
518 | 2024-09-12 05:35:56 | affirmant | 1 | 81242 | 2 | 10.623 | 7647.7 |
517 | 2024-09-10 14:07:38 | affirmant | 1 | 81242 | 2 | 13.720 | 5921.4 |
516 | 2024-09-09 10:51:05 | affirmant | 1 | 81242 | 2 | 10.110 | 8035.8 |
515 | 2024-08-31 11:27:53 | affirmant | 1 | 81242 | 2 | 10.656 | 7624.1 |
514 | 2024-08-31 05:10:25 | affirmant | 2 | 121436 | 6 | 17.736 | 6846.9 |
513 | 2024-08-15 03:06:10 | affirmant | 1 | 81242 | 2 | 10.033 | 8097.5 |
512 | 2024-08-15 03:04:09 | affirmant | 4 | 165329 | 95 | 65.673 | 2517.5 |
511 | 2024-08-15 03:04:09 | affirmant | 3 | 148641 | 24 | 44.956 | 3306.4 |
510 | 2024-08-15 03:04:09 | affirmant | 2 | 121436 | 6 | 37.080 | 3275.0 |