History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gainers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
636 | 2024-05-01 16:52:00 | gainers | 1 | 69583 | 5 | 2.250 | 30925.8 |
635 | 2024-04-28 01:51:24 | gainers | 2 | 107671 | 116 | 7.170 | 15016.9 |
634 | 2024-04-23 20:00:56 | gainers | 1 | 69583 | 5 | 1.953 | 35628.8 |
633 | 2024-04-23 06:21:23 | gainers | 1 | 69583 | 5 | 3.140 | 22160.2 |
632 | 2024-04-23 03:10:58 | gainers | 1 | 69583 | 5 | 2.546 | 27330.3 |
631 | 2024-04-22 12:17:36 | gainers | 1 | 69583 | 5 | 4.000 | 17395.8 |
630 | 2024-04-22 02:44:06 | gainers | 1 | 69583 | 5 | 4.313 | 16133.3 |
629 | 2024-04-21 23:09:38 | gainers | 1 | 69583 | 5 | 1.376 | 50569.0 |
628 | 2024-04-21 02:56:49 | gainers | 1 | 69583 | 5 | 1.970 | 35321.3 |
627 | 2024-04-19 22:45:49 | gainers | 1 | 69583 | 5 | 1.923 | 36184.6 |
626 | 2024-04-18 22:34:00 | gainers | 1 | 69583 | 5 | 1.220 | 57035.2 |
625 | 2024-04-16 02:08:10 | gainers | 1 | 69583 | 5 | 4.406 | 15792.8 |
624 | 2024-04-15 01:21:41 | gainers | 1 | 69583 | 5 | 3.390 | 20526.0 |
623 | 2024-04-14 01:31:14 | gainers | 1 | 69583 | 5 | 4.703 | 14795.4 |
622 | 2024-04-12 14:32:13 | gainers | 1 | 69583 | 5 | 3.203 | 21724.3 |
621 | 2024-04-11 14:38:12 | gainers | 1 | 69583 | 5 | 1.220 | 57035.2 |
620 | 2024-04-10 14:15:15 | gainers | 1 | 69583 | 5 | 1.186 | 58670.3 |
619 | 2024-04-09 13:49:48 | gainers | 1 | 69583 | 5 | 1.203 | 57841.2 |
618 | 2024-04-08 14:15:58 | gainers | 1 | 69583 | 5 | 1.220 | 57035.2 |
617 | 2024-04-05 12:15:04 | gainers | 1 | 69583 | 5 | 1.606 | 43326.9 |
616 | 2024-04-04 23:19:02 | gainers | 1 | 69583 | 5 | 1.346 | 51696.1 |
615 | 2024-04-03 13:40:24 | gainers | 1 | 69583 | 5 | 2.860 | 24329.7 |
614 | 2024-04-02 23:09:37 | gainers | 1 | 69583 | 5 | 4.190 | 16606.9 |
613 | 2024-04-02 19:50:17 | gainers | 1 | 69583 | 5 | 2.733 | 25460.3 |
612 | 2024-04-01 20:34:07 | gainers | 1 | 69583 | 5 | 1.406 | 49490.0 |
611 | 2024-04-01 04:54:35 | gainers | 1 | 69583 | 5 | 3.546 | 19623.0 |
610 | 2024-03-31 20:37:19 | gainers | 1 | 69583 | 5 | 2.500 | 27833.2 |
609 | 2024-03-28 11:12:05 | gainers | 1 | 69583 | 5 | 1.203 | 57841.2 |
608 | 2024-03-26 12:16:34 | gainers | 1 | 69583 | 5 | 1.280 | 54361.7 |
607 | 2024-03-25 22:57:26 | gainers | 1 | 69583 | 5 | 3.750 | 18555.5 |
606 | 2024-03-25 08:09:12 | gainers | 1 | 69583 | 5 | 1.203 | 57841.2 |
605 | 2024-03-24 01:53:32 | gainers | 1 | 69583 | 5 | 1.283 | 54234.6 |
604 | 2024-03-23 02:27:59 | gainers | 1 | 69583 | 5 | 3.406 | 20429.5 |
603 | 2024-03-22 06:33:01 | gainers | 1 | 69583 | 5 | 1.173 | 59320.5 |
602 | 2024-03-21 16:31:45 | gainers | 1 | 69583 | 5 | 2.813 | 24736.2 |
601 | 2024-03-21 06:19:34 | gainers | 1 | 69583 | 5 | 2.283 | 30478.8 |
600 | 2024-03-20 15:47:21 | gainers | 1 | 69583 | 5 | 1.313 | 52995.4 |
599 | 2024-03-20 06:27:00 | gainers | 1 | 69583 | 5 | 1.423 | 48898.8 |
598 | 2024-03-17 15:20:22 | gainers | 1 | 69583 | 5 | 1.110 | 62687.4 |
597 | 2024-03-16 15:26:13 | gainers | 1 | 69583 | 5 | 2.780 | 25029.9 |
596 | 2024-03-15 17:32:33 | gainers | 1 | 69583 | 5 | 1.206 | 57697.3 |
595 | 2024-03-15 15:25:05 | gainers | 1 | 69583 | 5 | 1.190 | 58473.1 |
594 | 2024-03-14 13:15:48 | gainers | 1 | 69583 | 5 | 1.360 | 51164.0 |
593 | 2024-03-14 13:12:25 | gainers | 1 | 69583 | 5 | 1.280 | 54361.7 |
592 | 2024-03-13 17:49:46 | gainers | 1 | 69583 | 5 | 1.390 | 50059.7 |
591 | 2024-03-13 14:10:33 | gainers | 1 | 69583 | 5 | 4.266 | 16311.1 |
590 | 2024-03-12 13:17:01 | gainers | 1 | 69583 | 5 | 1.140 | 61037.7 |
589 | 2024-03-12 10:16:08 | gainers | 1 | 69583 | 5 | 1.376 | 50569.0 |
588 | 2024-03-11 20:15:35 | gainers | 1 | 69583 | 5 | 4.126 | 16864.5 |
587 | 2024-03-11 06:35:41 | gainers | 1 | 69583 | 5 | 1.376 | 50569.0 |
586 | 2024-03-10 22:38:19 | gainers | 1 | 69583 | 5 | 2.546 | 27330.3 |
585 | 2024-03-10 20:11:59 | gainers | 1 | 69583 | 5 | 1.750 | 39761.7 |
584 | 2024-03-10 07:33:40 | gainers | 1 | 69583 | 5 | 2.826 | 24622.4 |
583 | 2024-03-08 23:24:43 | gainers | 1 | 69583 | 5 | 2.236 | 31119.4 |
582 | 2024-03-07 11:51:20 | gainers | 1 | 69583 | 5 | 1.360 | 51164.0 |
581 | 2024-03-07 00:20:24 | gainers | 1 | 69583 | 5 | 1.220 | 57035.2 |
580 | 2024-03-06 23:17:09 | gainers | 1 | 69583 | 5 | 3.280 | 21214.3 |
579 | 2024-03-06 00:39:32 | gainers | 1 | 69583 | 5 | 2.203 | 31585.6 |
578 | 2024-03-05 14:50:41 | gainers | 1 | 69583 | 5 | 1.250 | 55666.4 |
577 | 2024-03-05 05:30:48 | gainers | 1 | 69583 | 5 | 1.110 | 62687.4 |
576 | 2024-03-04 08:25:15 | gainers | 2 | 107671 | 116 | 3.860 | 27894.0 |
575 | 2024-03-04 05:31:49 | gainers | 1 | 69583 | 5 | 1.080 | 64428.7 |
574 | 2024-03-03 23:39:24 | gainers | 2 | 107671 | 116 | 12.673 | 8496.1 |
573 | 2024-03-03 21:18:24 | gainers | 2 | 107671 | 116 | 5.533 | 19459.8 |
572 | 2024-03-03 17:11:50 | gainers | 1 | 69583 | 5 | 1.376 | 50569.0 |
571 | 2024-03-02 17:09:19 | gainers | 1 | 69583 | 5 | 1.216 | 57222.9 |
570 | 2024-03-02 07:29:24 | gainers | 1 | 69583 | 5 | 1.390 | 50059.7 |
569 | 2024-03-01 17:18:45 | gainers | 1 | 69583 | 5 | 1.390 | 50059.7 |
568 | 2024-03-01 12:21:48 | gainers | 1 | 69583 | 5 | 1.220 | 57035.2 |
567 | 2024-02-29 21:24:17 | gainers | 1 | 69583 | 5 | 1.296 | 53690.6 |
566 | 2024-02-29 12:33:46 | gainers | 1 | 69583 | 5 | 1.263 | 55093.4 |
565 | 2024-02-28 12:06:59 | gainers | 1 | 69583 | 5 | 1.233 | 56433.9 |
564 | 2024-02-27 22:21:18 | gainers | 1 | 69583 | 5 | 3.576 | 19458.3 |
563 | 2024-02-27 11:49:49 | gainers | 1 | 69583 | 5 | 1.126 | 61796.6 |
562 | 2024-02-26 22:24:13 | gainers | 1 | 69583 | 5 | 1.173 | 59320.5 |
561 | 2024-02-26 12:55:18 | gainers | 1 | 69583 | 5 | 1.216 | 57222.9 |
560 | 2024-02-25 22:45:48 | gainers | 1 | 69583 | 5 | 1.250 | 55666.4 |
559 | 2024-02-25 22:29:28 | gainers | 1 | 69583 | 5 | 4.186 | 16622.8 |
558 | 2024-02-25 11:59:56 | gainers | 1 | 69583 | 5 | 1.190 | 58473.1 |
557 | 2024-02-24 22:28:38 | gainers | 1 | 69583 | 5 | 1.190 | 58473.1 |
556 | 2024-02-23 19:29:49 | gainers | 1 | 69583 | 5 | 1.090 | 63837.6 |
555 | 2024-02-23 09:21:31 | gainers | 1 | 69583 | 5 | 1.283 | 54234.6 |
554 | 2024-02-22 19:25:51 | gainers | 1 | 69583 | 5 | 1.313 | 52995.4 |
553 | 2024-02-21 19:12:09 | gainers | 1 | 69583 | 5 | 2.766 | 25156.5 |
552 | 2024-02-21 18:16:01 | gainers | 1 | 69583 | 5 | 1.280 | 54361.7 |
551 | 2024-02-20 19:22:41 | gainers | 1 | 69583 | 5 | 1.186 | 58670.3 |
550 | 2024-02-20 17:03:03 | gainers | 1 | 69583 | 5 | 1.076 | 64668.2 |
549 | 2024-02-19 19:44:34 | gainers | 1 | 69583 | 5 | 1.360 | 51164.0 |
548 | 2024-02-19 19:29:05 | gainers | 1 | 69583 | 5 | 1.343 | 51811.6 |
547 | 2024-02-19 14:22:06 | gainers | 1 | 69583 | 5 | 1.296 | 53690.6 |
546 | 2024-02-19 05:29:28 | gainers | 1 | 69583 | 5 | 1.063 | 65459.1 |
545 | 2024-02-18 17:26:10 | gainers | 1 | 69583 | 5 | 1.280 | 54361.7 |
544 | 2024-02-18 15:47:12 | gainers | 1 | 69583 | 5 | 1.060 | 65644.3 |
543 | 2024-02-18 05:39:07 | gainers | 1 | 69583 | 5 | 4.703 | 14795.4 |
542 | 2024-02-17 16:45:18 | gainers | 1 | 69583 | 5 | 1.170 | 59472.6 |
541 | 2024-02-17 04:53:47 | gainers | 1 | 69583 | 5 | 2.843 | 24475.2 |
540 | 2024-02-16 04:57:18 | gainers | 1 | 69583 | 5 | 2.766 | 25156.5 |
539 | 2024-02-15 15:37:39 | gainers | 1 | 69583 | 5 | 1.076 | 64668.2 |
538 | 2024-02-15 05:18:24 | gainers | 1 | 69583 | 5 | 1.186 | 58670.3 |
537 | 2024-02-11 12:22:28 | gainers | 1 | 69583 | 5 | 1.220 | 57035.2 |