History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sampled"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
608 | 2024-05-22 00:34:50 | sampled | 1 | 69583 | 4 | 4.796 | 14508.5 |
607 | 2024-05-19 12:58:28 | sampled | 1 | 69583 | 4 | 3.046 | 22844.1 |
606 | 2024-05-09 21:34:11 | sampled | 3 | 134027 | 574 | 9.156 | 14638.2 |
605 | 2024-05-09 00:51:08 | sampled | 2 | 107671 | 48 | 12.126 | 8879.4 |
604 | 2024-05-06 20:02:36 | sampled | 2 | 107671 | 48 | 4.140 | 26007.5 |
603 | 2024-05-06 20:02:06 | sampled | 3 | 134027 | 574 | 18.923 | 7082.8 |
602 | 2024-05-06 15:26:57 | sampled | 2 | 107671 | 48 | 7.063 | 15244.4 |
601 | 2024-05-06 07:51:35 | sampled | 3 | 134027 | 574 | 9.736 | 13766.1 |
600 | 2024-05-06 03:58:58 | sampled | 2 | 107671 | 48 | 11.953 | 9007.9 |
599 | 2024-05-05 21:27:31 | sampled | 3 | 134027 | 574 | 13.516 | 9916.2 |
598 | 2024-05-05 08:50:51 | sampled | 2 | 107671 | 48 | 4.516 | 23842.1 |
597 | 2024-05-05 08:50:32 | sampled | 1 | 69583 | 4 | 2.936 | 23699.9 |
596 | 2024-05-05 08:33:24 | sampled | 2 | 107671 | 48 | 3.200 | 33647.2 |
595 | 2024-05-05 08:31:27 | sampled | 3 | 134027 | 574 | 7.110 | 18850.5 |
594 | 2024-05-05 07:54:13 | sampled | 3 | 134027 | 574 | 8.406 | 15944.2 |
593 | 2024-05-05 04:55:23 | sampled | 3 | 134027 | 574 | 8.970 | 14941.7 |
592 | 2024-04-27 22:11:17 | sampled | 1 | 69583 | 4 | 1.266 | 54962.9 |
591 | 2024-04-21 07:49:22 | sampled | 1 | 69583 | 4 | 2.263 | 30748.1 |
590 | 2024-04-14 00:59:35 | sampled | 1 | 69583 | 4 | 3.733 | 18640.0 |
589 | 2024-04-14 00:56:22 | sampled | 1 | 69583 | 4 | 3.750 | 18555.5 |
588 | 2024-03-30 16:29:30 | sampled | 1 | 69583 | 4 | 3.593 | 19366.3 |
587 | 2024-03-28 07:35:37 | sampled | 1 | 69583 | 4 | 1.360 | 51164.0 |
586 | 2024-03-17 20:01:52 | sampled | 1 | 69583 | 4 | 1.423 | 48898.8 |
585 | 2024-03-07 23:27:29 | sampled | 3 | 134027 | 574 | 15.360 | 8725.7 |
584 | 2024-03-07 22:25:21 | sampled | 3 | 134027 | 574 | 13.940 | 9614.6 |
583 | 2024-03-07 00:06:25 | sampled | 1 | 69583 | 4 | 3.733 | 18640.0 |
582 | 2024-02-23 23:39:41 | sampled | 2 | 107671 | 48 | 7.186 | 14983.4 |
581 | 2024-02-23 23:38:42 | sampled | 3 | 134027 | 574 | 8.003 | 16747.1 |
580 | 2024-02-17 06:06:52 | sampled | 2 | 107671 | 48 | 4.110 | 26197.3 |
579 | 2024-02-14 20:23:15 | sampled | 3 | 134027 | 574 | 24.906 | 5381.3 |
578 | 2024-02-14 20:23:14 | sampled | 2 | 107671 | 48 | 5.390 | 19976.1 |
577 | 2024-02-14 18:45:06 | sampled | 1 | 69583 | 4 | 1.373 | 50679.5 |
576 | 2024-02-05 08:04:59 | sampled | 3 | 134027 | 574 | 15.910 | 8424.1 |
575 | 2024-02-05 07:54:22 | sampled | 3 | 134027 | 574 | 17.266 | 7762.5 |
574 | 2024-01-30 22:25:35 | sampled | 1 | 69583 | 4 | 1.216 | 57222.9 |
573 | 2024-01-22 10:58:08 | sampled | 1 | 69583 | 4 | 4.236 | 16426.6 |
572 | 2024-01-10 06:55:33 | sampled | 3 | 134027 | 574 | 6.673 | 20085.0 |
571 | 2024-01-10 06:55:32 | sampled | 2 | 107671 | 48 | 3.220 | 33438.2 |
570 | 2024-01-09 02:18:52 | sampled | 2 | 107671 | 48 | 3.000 | 35890.3 |
569 | 2024-01-04 18:41:11 | sampled | 1 | 69583 | 4 | 1.140 | 61037.7 |
568 | 2023-12-28 16:59:36 | sampled | 3 | 134027 | 574 | 8.110 | 16526.1 |
567 | 2023-12-27 01:27:22 | sampled | 3 | 134027 | 574 | 5.903 | 22704.9 |
566 | 2023-12-05 12:34:16 | sampled | 1 | 69583 | 4 | 1.236 | 56296.9 |
565 | 2023-11-26 06:54:26 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
564 | 2023-11-16 22:46:18 | sampled | 1 | 69583 | 4 | 1.826 | 38106.8 |
563 | 2023-10-31 21:13:55 | sampled | 1 | 69583 | 4 | 1.310 | 53116.8 |
562 | 2023-10-30 09:16:25 | sampled | 1 | 69583 | 4 | 1.106 | 62914.1 |
561 | 2023-10-01 05:36:42 | sampled | 3 | 134027 | 574 | 14.373 | 9324.9 |
560 | 2023-09-29 12:51:04 | sampled | 1 | 69583 | 4 | 1.156 | 60192.9 |
559 | 2023-09-29 09:16:53 | sampled | 3 | 134027 | 574 | 6.360 | 21073.4 |
558 | 2023-09-29 09:16:55 | sampled | 2 | 107671 | 48 | 3.390 | 31761.4 |
557 | 2023-09-29 05:46:38 | sampled | 3 | 134027 | 574 | 6.673 | 20085.0 |
556 | 2023-09-25 19:05:37 | sampled | 1 | 69583 | 4 | 1.140 | 61037.7 |
555 | 2023-09-15 02:49:33 | sampled | 1 | 69583 | 4 | 1.186 | 58670.3 |
554 | 2023-09-11 11:39:23 | sampled | 1 | 69583 | 4 | 1.423 | 48898.8 |
553 | 2023-08-19 03:47:35 | sampled | 3 | 134027 | 574 | 5.906 | 22693.4 |
552 | 2023-08-11 05:05:09 | sampled | 3 | 134027 | 574 | 6.436 | 20824.6 |
551 | 2023-07-10 17:53:02 | sampled | 3 | 134027 | 574 | 6.860 | 19537.5 |
550 | 2023-06-23 23:01:14 | sampled | 1 | 69583 | 4 | 1.110 | 62687.4 |
549 | 2023-05-22 10:24:01 | sampled | 1 | 69583 | 4 | 1.233 | 56433.9 |
548 | 2023-04-07 20:08:53 | sampled | 1 | 69583 | 4 | 1.076 | 64668.2 |
547 | 2023-03-28 03:12:16 | sampled | 3 | 134027 | 574 | 7.156 | 18729.3 |
546 | 2023-01-29 19:50:02 | sampled | 1 | 69583 | 4 | 1.093 | 63662.4 |
545 | 2023-01-18 23:19:30 | sampled | 3 | 134027 | 574 | 6.656 | 20136.3 |
544 | 2023-01-13 14:51:11 | sampled | 3 | 134027 | 574 | 6.003 | 22326.7 |
543 | 2022-12-25 22:23:26 | sampled | 3 | 134027 | 574 | 5.753 | 23296.9 |
542 | 2022-11-29 12:15:25 | sampled | 3 | 134027 | 574 | 11.643 | 11511.4 |
541 | 2022-11-03 19:20:50 | sampled | 3 | 134027 | 574 | 6.253 | 21434.0 |
540 | 2022-10-04 16:56:00 | sampled | 1 | 69583 | 4 | 1.343 | 51811.6 |
539 | 2022-08-29 01:29:26 | sampled | 1 | 69583 | 4 | 1.110 | 62687.4 |
538 | 2022-08-25 02:28:36 | sampled | 3 | 134027 | 574 | 6.296 | 21287.6 |
537 | 2022-08-18 18:38:31 | sampled | 1 | 69583 | 4 | 1.110 | 62687.4 |
536 | 2022-06-17 10:19:58 | sampled | 1 | 69583 | 4 | 1.093 | 63662.4 |
535 | 2022-06-10 15:53:06 | sampled | 1 | 69583 | 4 | 1.250 | 55666.4 |
534 | 2022-06-04 10:36:24 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
533 | 2022-05-28 04:46:02 | sampled | 3 | 134027 | 574 | 6.126 | 21878.4 |
532 | 2022-05-28 01:12:56 | sampled | 1 | 69583 | 4 | 1.233 | 56433.9 |
531 | 2022-05-22 21:38:23 | sampled | 3 | 134027 | 574 | 6.093 | 21996.9 |
530 | 2022-05-22 19:09:37 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
529 | 2022-04-27 03:06:05 | sampled | 3 | 134027 | 574 | 6.033 | 22215.6 |
528 | 2022-02-04 04:30:37 | sampled | 1 | 69583 | 4 | 1.140 | 61037.7 |
527 | 2022-01-30 03:02:03 | sampled | 1 | 69583 | 4 | 1.170 | 59472.6 |
526 | 2021-12-16 22:10:16 | sampled | 1 | 69583 | 4 | 1.236 | 56296.9 |
525 | 2021-12-14 20:37:16 | sampled | 1 | 69583 | 4 | 1.296 | 53690.6 |
524 | 2021-10-10 02:06:00 | sampled | 1 | 69583 | 4 | 1.123 | 61961.7 |
523 | 2021-07-23 05:33:12 | sampled | 3 | 134027 | 574 | 6.656 | 20136.3 |
522 | 2021-07-17 05:33:26 | sampled | 3 | 134027 | 574 | 6.000 | 22337.8 |
521 | 2021-07-08 05:22:40 | sampled | 1 | 69583 | 4 | 1.250 | 55666.4 |
520 | 2021-07-05 22:11:49 | sampled | 1 | 69583 | 4 | 1.186 | 58670.3 |
519 | 2021-06-07 00:23:45 | sampled | 3 | 134027 | 574 | 5.940 | 22563.5 |
518 | 2021-06-06 19:18:10 | sampled | 3 | 134027 | 574 | 6.983 | 19193.3 |
517 | 2021-06-06 14:23:10 | sampled | 3 | 134027 | 574 | 7.030 | 19065.0 |
516 | 2021-06-06 08:57:11 | sampled | 3 | 134027 | 574 | 7.373 | 18178.1 |
515 | 2021-06-05 20:03:57 | sampled | 3 | 134027 | 574 | 7.080 | 18930.4 |
514 | 2021-06-05 18:10:47 | sampled | 3 | 134027 | 574 | 14.236 | 9414.7 |
513 | 2021-06-05 10:03:56 | sampled | 3 | 134027 | 574 | 7.360 | 18210.2 |
512 | 2021-06-05 08:17:57 | sampled | 3 | 134027 | 574 | 7.203 | 18607.1 |
511 | 2021-06-04 19:26:19 | sampled | 3 | 134027 | 574 | 7.110 | 18850.5 |
510 | 2021-06-04 12:01:41 | sampled | 3 | 134027 | 574 | 6.720 | 19944.5 |
509 | 2021-06-04 04:49:49 | sampled | 3 | 134027 | 574 | 6.250 | 21444.3 |