History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"periods"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
564 | 2025-04-20 05:03:29 | periods | 1 | 69583 | 3 | 6.190 | 11241.2 |
563 | 2025-04-18 08:56:24 | periods | 1 | 69583 | 3 | 8.296 | 8387.5 |
562 | 2025-03-31 18:47:58 | periods | 1 | 69583 | 3 | 5.253 | 13246.3 |
561 | 2025-03-27 13:58:24 | periods | 1 | 69583 | 3 | 2.936 | 23699.9 |
560 | 2025-03-21 05:09:17 | periods | 2 | 107671 | 26 | 23.923 | 4500.7 |
559 | 2025-03-19 07:06:36 | periods | 1 | 69583 | 3 | 1.283 | 54234.6 |
558 | 2025-03-18 00:03:41 | periods | 1 | 69583 | 3 | 6.266 | 11104.9 |
557 | 2025-03-16 12:38:30 | periods | 3 | 134027 | 392 | 33.376 | 4015.7 |
556 | 2025-03-16 11:42:38 | periods | 3 | 134027 | 392 | 31.753 | 4220.9 |
555 | 2025-03-13 03:16:16 | periods | 1 | 69583 | 3 | 2.906 | 23944.6 |
554 | 2025-03-07 22:44:35 | periods | 1 | 69583 | 3 | 5.516 | 12614.8 |
553 | 2025-02-27 22:40:40 | periods | 1 | 69583 | 3 | 6.050 | 11501.3 |
552 | 2025-02-27 08:20:32 | periods | 1 | 69583 | 3 | 3.530 | 19711.9 |
551 | 2025-02-26 05:35:55 | periods | 3 | 134027 | 392 | 28.030 | 4781.6 |
550 | 2025-02-25 21:53:55 | periods | 3 | 134027 | 392 | 25.630 | 5229.3 |
549 | 2025-02-25 09:31:09 | periods | 3 | 134027 | 392 | 43.650 | 3070.5 |
548 | 2025-02-25 09:09:09 | periods | 3 | 134027 | 392 | 39.033 | 3433.7 |
547 | 2025-02-25 07:27:50 | periods | 3 | 134027 | 392 | 24.350 | 5504.2 |
546 | 2025-02-25 07:27:48 | periods | 2 | 107671 | 26 | 8.303 | 12967.7 |
545 | 2025-02-25 05:39:19 | periods | 3 | 134027 | 392 | 25.986 | 5157.7 |
544 | 2025-02-25 05:39:18 | periods | 2 | 107671 | 26 | 16.580 | 6494.0 |
543 | 2025-02-25 05:39:17 | periods | 1 | 69583 | 3 | 6.546 | 10629.9 |
542 | 2025-02-05 13:34:05 | periods | 1 | 69583 | 3 | 4.280 | 16257.7 |
541 | 2025-02-04 11:25:44 | periods | 1 | 69583 | 3 | 4.000 | 17395.8 |
540 | 2025-01-22 18:43:12 | periods | 3 | 134027 | 392 | 35.186 | 3809.1 |
539 | 2025-01-19 13:47:15 | periods | 2 | 107671 | 26 | 15.983 | 6736.6 |
538 | 2025-01-19 09:50:04 | periods | 3 | 134027 | 392 | 31.110 | 4308.2 |
537 | 2025-01-18 07:19:28 | periods | 3 | 134027 | 392 | 41.893 | 3199.3 |
536 | 2025-01-18 07:19:24 | periods | 2 | 107671 | 26 | 18.720 | 5751.7 |
535 | 2025-01-16 19:32:26 | periods | 1 | 69583 | 3 | 5.483 | 12690.7 |
534 | 2025-01-15 22:58:29 | periods | 1 | 69583 | 3 | 2.700 | 25771.5 |
533 | 2025-01-12 06:31:46 | periods | 1 | 69583 | 3 | 3.076 | 22621.3 |
532 | 2024-12-28 16:31:17 | periods | 1 | 69583 | 3 | 7.703 | 9033.2 |
531 | 2024-12-10 02:02:44 | periods | 1 | 69583 | 3 | 3.843 | 18106.4 |
530 | 2024-11-29 11:54:39 | periods | 1 | 69583 | 3 | 4.140 | 16807.5 |
529 | 2024-11-27 14:37:50 | periods | 1 | 69583 | 3 | 5.560 | 12514.9 |
528 | 2024-11-09 19:00:52 | periods | 1 | 69583 | 3 | 5.376 | 12943.3 |
527 | 2024-11-09 11:27:44 | periods | 1 | 69583 | 3 | 4.376 | 15901.1 |
526 | 2024-11-05 09:22:34 | periods | 1 | 69583 | 3 | 4.423 | 15732.1 |
525 | 2024-10-20 23:13:47 | periods | 1 | 69583 | 3 | 6.390 | 10889.4 |
524 | 2024-09-28 07:18:05 | periods | 1 | 69583 | 3 | 8.530 | 8157.4 |
523 | 2024-09-12 18:54:13 | periods | 1 | 69583 | 3 | 7.516 | 9258.0 |
522 | 2024-09-10 14:31:39 | periods | 1 | 69583 | 3 | 5.860 | 11874.2 |
521 | 2024-09-07 10:04:38 | periods | 1 | 69583 | 3 | 12.530 | 5553.3 |
520 | 2024-08-29 21:21:09 | periods | 1 | 69583 | 3 | 8.830 | 7880.3 |
519 | 2024-08-29 09:20:16 | periods | 1 | 69583 | 3 | 6.500 | 10705.1 |
518 | 2024-08-28 11:41:16 | periods | 3 | 134027 | 392 | 52.406 | 2557.5 |
517 | 2024-08-28 09:22:01 | periods | 3 | 134027 | 392 | 68.566 | 1954.7 |
516 | 2024-08-26 12:28:22 | periods | 3 | 134027 | 392 | 67.960 | 1972.1 |
515 | 2024-08-26 12:28:11 | periods | 2 | 107671 | 26 | 22.020 | 4889.7 |
514 | 2024-08-26 11:49:44 | periods | 1 | 69583 | 3 | 10.983 | 6335.5 |
513 | 2024-08-15 18:42:23 | periods | 1 | 69583 | 3 | 12.440 | 5593.5 |
512 | 2024-08-12 08:28:15 | periods | 1 | 69583 | 3 | 4.656 | 14944.8 |
511 | 2024-08-09 10:04:15 | periods | 1 | 69583 | 3 | 4.190 | 16606.9 |
510 | 2024-07-29 23:00:29 | periods | 1 | 69583 | 3 | 1.313 | 52995.4 |
509 | 2024-07-29 12:29:15 | periods | 1 | 69583 | 3 | 2.226 | 31259.2 |
508 | 2024-07-26 17:29:25 | periods | 1 | 69583 | 3 | 6.280 | 11080.1 |
507 | 2024-07-25 12:23:00 | periods | 1 | 69583 | 3 | 5.530 | 12582.8 |
506 | 2024-07-22 04:13:26 | periods | 1 | 69583 | 3 | 4.393 | 15839.5 |
505 | 2024-07-05 12:23:22 | periods | 1 | 69583 | 3 | 3.250 | 21410.2 |
504 | 2024-07-05 12:17:32 | periods | 1 | 69583 | 3 | 6.063 | 11476.7 |
503 | 2024-07-01 21:50:08 | periods | 1 | 69583 | 3 | 7.906 | 8801.3 |
502 | 2024-07-01 12:30:24 | periods | 1 | 69583 | 3 | 4.766 | 14599.9 |
501 | 2024-06-26 19:50:14 | periods | 1 | 69583 | 3 | 2.216 | 31400.3 |
500 | 2024-06-22 05:45:23 | periods | 1 | 69583 | 3 | 4.610 | 15093.9 |
499 | 2024-06-17 20:25:31 | periods | 3 | 134027 | 392 | 25.546 | 5246.5 |
498 | 2024-06-17 07:59:15 | periods | 3 | 134027 | 392 | 40.440 | 3314.2 |
497 | 2024-06-17 07:57:38 | periods | 3 | 134027 | 392 | 16.733 | 8009.7 |
496 | 2024-05-29 11:47:04 | periods | 1 | 69583 | 3 | 5.563 | 12508.2 |
495 | 2024-05-29 09:18:25 | periods | 1 | 69583 | 3 | 2.190 | 31773.1 |
494 | 2024-05-17 15:20:37 | periods | 1 | 69583 | 3 | 1.156 | 60192.9 |
493 | 2024-05-11 14:42:06 | periods | 3 | 134027 | 392 | 26.300 | 5096.1 |
492 | 2024-05-10 21:52:48 | periods | 3 | 134027 | 392 | 21.986 | 6096.0 |
491 | 2024-05-09 20:50:39 | periods | 3 | 134027 | 392 | 16.783 | 7985.9 |
490 | 2024-05-09 18:37:45 | periods | 2 | 107671 | 26 | 5.203 | 20694.0 |
489 | 2024-05-09 16:53:55 | periods | 3 | 134027 | 392 | 23.766 | 5639.4 |
488 | 2024-05-09 07:38:58 | periods | 1 | 69583 | 3 | 3.563 | 19529.3 |
487 | 2024-05-09 07:35:24 | periods | 3 | 134027 | 392 | 13.156 | 10187.5 |
486 | 2024-05-09 07:35:21 | periods | 2 | 107671 | 26 | 4.060 | 26520.0 |
485 | 2024-05-09 07:34:43 | periods | 1 | 69583 | 3 | 2.826 | 24622.4 |
484 | 2024-04-27 21:04:54 | periods | 1 | 69583 | 3 | 4.796 | 14508.5 |
483 | 2024-04-13 04:42:49 | periods | 1 | 69583 | 3 | 1.313 | 52995.4 |
482 | 2024-03-29 22:40:52 | periods | 1 | 69583 | 3 | 2.843 | 24475.2 |
481 | 2024-03-20 17:13:17 | periods | 1 | 69583 | 3 | 1.110 | 62687.4 |
480 | 2024-02-27 18:21:12 | periods | 1 | 69583 | 3 | 1.123 | 61961.7 |
479 | 2024-02-04 00:12:39 | periods | 3 | 134027 | 392 | 9.000 | 14891.9 |
478 | 2024-01-29 08:22:44 | periods | 3 | 134027 | 392 | 19.343 | 6929.0 |
477 | 2024-01-27 16:00:31 | periods | 2 | 107671 | 26 | 2.910 | 37000.3 |
476 | 2024-01-27 16:00:11 | periods | 3 | 134027 | 392 | 6.126 | 21878.4 |
475 | 2024-01-26 15:13:09 | periods | 2 | 107671 | 26 | 3.610 | 29825.8 |
474 | 2024-01-26 15:12:01 | periods | 3 | 134027 | 392 | 7.530 | 17799.1 |
473 | 2024-01-22 09:15:19 | periods | 3 | 134027 | 392 | 7.953 | 16852.4 |
472 | 2023-12-31 02:38:09 | periods | 1 | 69583 | 3 | 1.186 | 58670.3 |
471 | 2023-12-12 22:17:16 | periods | 1 | 69583 | 3 | 1.390 | 50059.7 |
470 | 2023-12-09 19:32:51 | periods | 1 | 69583 | 3 | 1.200 | 57985.8 |
469 | 2023-11-22 16:36:56 | periods | 3 | 134027 | 392 | 6.000 | 22337.8 |
468 | 2023-11-18 21:35:24 | periods | 1 | 69583 | 3 | 1.110 | 62687.4 |
467 | 2023-11-11 20:42:04 | periods | 1 | 69583 | 3 | 1.233 | 56433.9 |
466 | 2023-11-11 17:47:59 | periods | 1 | 69583 | 3 | 1.186 | 58670.3 |
465 | 2023-11-07 05:01:40 | periods | 1 | 69583 | 3 | 1.093 | 63662.4 |