History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"troughs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
607 | 2024-04-28 04:08:43 | troughs | 1 | 69583 | 4 | 1.263 | 55093.4 |
606 | 2024-04-28 04:04:31 | troughs | 1 | 69583 | 4 | 1.453 | 47889.2 |
605 | 2024-04-27 11:37:55 | troughs | 1 | 69583 | 4 | 1.533 | 45390.1 |
604 | 2024-04-27 00:27:58 | troughs | 1 | 69583 | 4 | 5.736 | 12130.9 |
603 | 2024-04-19 00:12:15 | troughs | 1 | 69583 | 4 | 4.283 | 16246.3 |
602 | 2024-03-28 10:35:21 | troughs | 1 | 69583 | 4 | 1.220 | 57035.2 |
601 | 2024-02-27 08:26:44 | troughs | 1 | 69583 | 4 | 2.733 | 25460.3 |
600 | 2024-02-25 22:27:35 | troughs | 1 | 69583 | 4 | 3.063 | 22717.3 |
599 | 2024-02-07 15:56:28 | troughs | 1 | 69583 | 4 | 1.170 | 59472.6 |
598 | 2023-12-13 23:15:46 | troughs | 3 | 134027 | 247 | 14.953 | 8963.2 |
597 | 2023-12-13 23:15:46 | troughs | 2 | 107671 | 38 | 3.656 | 29450.5 |
596 | 2023-11-30 23:54:04 | troughs | 3 | 134027 | 247 | 8.893 | 15071.1 |
595 | 2023-11-30 23:54:06 | troughs | 2 | 107671 | 38 | 6.343 | 16974.8 |
594 | 2023-11-28 18:17:21 | troughs | 1 | 69583 | 4 | 1.140 | 61037.7 |
593 | 2023-11-11 04:27:43 | troughs | 1 | 69583 | 4 | 1.423 | 48898.8 |
592 | 2023-11-10 15:24:10 | troughs | 1 | 69583 | 4 | 1.343 | 51811.6 |
591 | 2023-10-27 01:51:53 | troughs | 1 | 69583 | 4 | 1.106 | 62914.1 |
590 | 2023-10-20 17:09:06 | troughs | 1 | 69583 | 4 | 1.156 | 60192.9 |
589 | 2023-10-20 16:22:59 | troughs | 1 | 69583 | 4 | 1.190 | 58473.1 |
588 | 2023-10-18 04:10:08 | troughs | 1 | 69583 | 4 | 1.093 | 63662.4 |
587 | 2023-10-11 14:14:39 | troughs | 1 | 69583 | 4 | 1.063 | 65459.1 |
586 | 2023-10-04 08:54:07 | troughs | 1 | 69583 | 4 | 1.140 | 61037.7 |
585 | 2023-09-23 21:06:43 | troughs | 1 | 69583 | 4 | 1.123 | 61961.7 |
584 | 2023-09-21 15:34:23 | troughs | 1 | 69583 | 4 | 1.326 | 52475.9 |
583 | 2023-09-14 02:20:40 | troughs | 2 | 107671 | 38 | 3.203 | 33615.7 |
582 | 2023-09-13 10:00:43 | troughs | 1 | 69583 | 4 | 1.046 | 66522.9 |
581 | 2023-09-10 14:00:56 | troughs | 3 | 134027 | 247 | 8.173 | 16398.8 |
580 | 2023-09-08 17:52:36 | troughs | 3 | 134027 | 247 | 5.796 | 23124.1 |
579 | 2023-07-24 12:31:44 | troughs | 3 | 134027 | 247 | 5.690 | 23554.8 |
578 | 2023-07-17 23:28:28 | troughs | 3 | 134027 | 247 | 6.796 | 19721.5 |
577 | 2023-07-15 13:08:17 | troughs | 3 | 134027 | 247 | 5.893 | 22743.4 |
576 | 2023-07-14 21:12:58 | troughs | 3 | 134027 | 247 | 6.266 | 21389.6 |
575 | 2023-07-13 20:38:49 | troughs | 3 | 134027 | 247 | 6.576 | 20381.2 |
574 | 2023-06-25 16:57:23 | troughs | 1 | 69583 | 4 | 1.170 | 59472.6 |
573 | 2023-06-23 05:23:47 | troughs | 3 | 134027 | 247 | 6.673 | 20085.0 |
572 | 2023-06-09 17:21:13 | troughs | 1 | 69583 | 4 | 1.140 | 61037.7 |
571 | 2023-04-06 14:01:05 | troughs | 1 | 69583 | 4 | 2.360 | 29484.3 |
570 | 2023-01-31 18:56:49 | troughs | 1 | 69583 | 4 | 1.060 | 65644.3 |
569 | 2023-01-21 08:25:45 | troughs | 1 | 69583 | 4 | 1.153 | 60349.5 |
568 | 2023-01-15 01:19:00 | troughs | 3 | 134027 | 247 | 6.016 | 22278.4 |
567 | 2022-12-01 02:28:45 | troughs | 3 | 134027 | 247 | 5.953 | 22514.2 |
566 | 2022-11-18 13:50:40 | troughs | 1 | 69583 | 4 | 1.110 | 62687.4 |
565 | 2022-11-12 05:04:20 | troughs | 3 | 134027 | 247 | 6.453 | 20769.7 |
564 | 2022-10-29 16:27:51 | troughs | 3 | 134027 | 247 | 6.233 | 21502.8 |
563 | 2022-09-29 12:15:02 | troughs | 1 | 69583 | 4 | 1.063 | 65459.1 |
562 | 2022-09-12 22:49:30 | troughs | 3 | 134027 | 247 | 5.720 | 23431.3 |
561 | 2022-09-01 23:35:24 | troughs | 3 | 134027 | 247 | 6.626 | 20227.4 |
560 | 2022-07-09 03:04:44 | troughs | 1 | 69583 | 4 | 1.046 | 66522.9 |
559 | 2022-06-17 04:19:45 | troughs | 3 | 134027 | 247 | 5.970 | 22450.1 |
558 | 2022-05-03 05:31:35 | troughs | 3 | 134027 | 247 | 5.813 | 23056.4 |
557 | 2022-04-29 22:10:49 | troughs | 3 | 134027 | 247 | 7.220 | 18563.3 |
556 | 2022-03-25 06:40:24 | troughs | 3 | 134027 | 247 | 5.703 | 23501.1 |
555 | 2022-03-24 16:09:00 | troughs | 3 | 134027 | 247 | 6.220 | 21547.7 |
554 | 2022-03-23 15:47:16 | troughs | 3 | 134027 | 247 | 7.733 | 17331.8 |
553 | 2022-03-23 03:10:04 | troughs | 3 | 134027 | 247 | 7.016 | 19103.1 |
552 | 2022-03-22 17:51:30 | troughs | 3 | 134027 | 247 | 7.126 | 18808.2 |
551 | 2022-03-19 10:15:12 | troughs | 3 | 134027 | 247 | 6.156 | 21771.8 |
550 | 2022-03-18 14:33:08 | troughs | 3 | 134027 | 247 | 5.750 | 23309.0 |
549 | 2022-03-17 03:49:22 | troughs | 3 | 134027 | 247 | 6.766 | 19808.9 |
548 | 2022-03-16 12:50:55 | troughs | 3 | 134027 | 247 | 7.923 | 16916.2 |
547 | 2022-03-15 14:48:16 | troughs | 3 | 134027 | 247 | 6.890 | 19452.4 |
546 | 2022-03-12 04:15:49 | troughs | 3 | 134027 | 247 | 6.546 | 20474.6 |
545 | 2022-03-09 13:13:27 | troughs | 1 | 69583 | 4 | 1.266 | 54962.9 |
544 | 2022-02-04 14:00:13 | troughs | 1 | 69583 | 4 | 1.080 | 64428.7 |
543 | 2022-01-28 22:36:54 | troughs | 3 | 134027 | 247 | 6.390 | 20974.5 |
542 | 2022-01-28 04:23:50 | troughs | 3 | 134027 | 247 | 5.766 | 23244.4 |
541 | 2022-01-27 09:31:55 | troughs | 3 | 134027 | 247 | 6.436 | 20824.6 |
540 | 2022-01-26 16:24:36 | troughs | 3 | 134027 | 247 | 6.233 | 21502.8 |
539 | 2022-01-26 06:55:48 | troughs | 3 | 134027 | 247 | 6.673 | 20085.0 |
538 | 2022-01-25 16:29:03 | troughs | 3 | 134027 | 247 | 7.016 | 19103.1 |
537 | 2022-01-25 04:49:27 | troughs | 3 | 134027 | 247 | 7.486 | 17903.7 |
536 | 2022-01-24 12:16:34 | troughs | 3 | 134027 | 247 | 6.860 | 19537.5 |
535 | 2022-01-09 06:20:51 | troughs | 3 | 134027 | 247 | 7.220 | 18563.3 |
534 | 2022-01-08 16:05:46 | troughs | 3 | 134027 | 247 | 7.203 | 18607.1 |
533 | 2022-01-07 22:56:16 | troughs | 3 | 134027 | 247 | 6.766 | 19808.9 |
532 | 2022-01-07 12:21:06 | troughs | 3 | 134027 | 247 | 8.763 | 15294.6 |
531 | 2022-01-06 20:19:20 | troughs | 3 | 134027 | 247 | 5.983 | 22401.3 |
530 | 2022-01-06 09:30:59 | troughs | 3 | 134027 | 247 | 7.173 | 18684.9 |
529 | 2022-01-05 13:53:23 | troughs | 3 | 134027 | 247 | 6.220 | 21547.7 |
528 | 2022-01-04 22:29:56 | troughs | 3 | 134027 | 247 | 7.486 | 17903.7 |
527 | 2022-01-02 15:29:10 | troughs | 3 | 134027 | 247 | 7.080 | 18930.4 |
526 | 2022-01-01 20:47:16 | troughs | 3 | 134027 | 247 | 6.910 | 19396.1 |
525 | 2022-01-01 09:52:43 | troughs | 3 | 134027 | 247 | 7.173 | 18684.9 |
524 | 2021-12-31 22:33:30 | troughs | 3 | 134027 | 247 | 6.250 | 21444.3 |
523 | 2021-12-30 23:12:49 | troughs | 3 | 134027 | 247 | 9.953 | 13466.0 |
522 | 2021-12-30 19:18:35 | troughs | 3 | 134027 | 247 | 7.686 | 17437.8 |
521 | 2021-12-29 21:20:49 | troughs | 3 | 134027 | 247 | 6.530 | 20524.8 |
520 | 2021-12-28 22:17:39 | troughs | 3 | 134027 | 247 | 7.063 | 18975.9 |
519 | 2021-12-27 20:27:29 | troughs | 3 | 134027 | 247 | 7.263 | 18453.4 |
518 | 2021-12-26 20:08:04 | troughs | 3 | 134027 | 247 | 7.140 | 18771.3 |
517 | 2021-12-25 15:04:41 | troughs | 3 | 134027 | 247 | 7.453 | 17983.0 |
516 | 2021-12-24 15:33:58 | troughs | 3 | 134027 | 247 | 7.470 | 17942.0 |
515 | 2021-12-24 04:13:02 | troughs | 1 | 69583 | 4 | 1.110 | 62687.4 |
514 | 2021-12-17 14:30:11 | troughs | 3 | 134027 | 247 | 6.046 | 22167.9 |
513 | 2021-12-17 03:11:36 | troughs | 3 | 134027 | 247 | 6.576 | 20381.2 |
512 | 2021-12-16 20:21:09 | troughs | 3 | 134027 | 247 | 7.516 | 17832.2 |
511 | 2021-12-15 22:21:15 | troughs | 3 | 134027 | 247 | 6.423 | 20866.7 |
510 | 2021-12-15 05:31:19 | troughs | 3 | 134027 | 247 | 6.893 | 19443.9 |
509 | 2021-12-14 19:04:51 | troughs | 3 | 134027 | 247 | 7.033 | 19056.9 |
508 | 2021-12-11 18:49:52 | troughs | 3 | 134027 | 247 | 6.486 | 20664.0 |