History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"comment"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
605 | 2024-04-29 17:36:13 | comment | 3 | 134027 | 277 | 6.686 | 20045.9 |
604 | 2024-04-28 16:37:51 | comment | 2 | 107671 | 28 | 3.080 | 34958.1 |
603 | 2024-04-26 06:10:38 | comment | 2 | 107671 | 28 | 5.220 | 20626.6 |
602 | 2024-04-26 06:02:49 | comment | 3 | 134027 | 277 | 7.563 | 17721.4 |
601 | 2024-04-24 19:21:46 | comment | 3 | 134027 | 277 | 22.220 | 6031.8 |
600 | 2024-04-24 15:29:51 | comment | 3 | 134027 | 277 | 11.626 | 11528.2 |
599 | 2024-04-23 03:47:41 | comment | 3 | 134027 | 277 | 17.530 | 7645.6 |
598 | 2024-04-23 03:47:45 | comment | 2 | 107671 | 28 | 4.500 | 23926.9 |
597 | 2024-04-23 02:18:26 | comment | 1 | 69583 | 3 | 1.360 | 51164.0 |
596 | 2024-04-04 06:16:21 | comment | 1 | 69583 | 3 | 4.233 | 16438.2 |
595 | 2024-03-24 07:31:30 | comment | 2 | 107671 | 28 | 12.686 | 8487.4 |
594 | 2024-03-24 07:30:36 | comment | 3 | 134027 | 277 | 8.406 | 15944.2 |
593 | 2024-03-22 23:28:12 | comment | 3 | 134027 | 277 | 6.123 | 21889.1 |
592 | 2024-03-20 02:46:30 | comment | 2 | 107671 | 28 | 3.656 | 29450.5 |
591 | 2024-03-20 02:44:46 | comment | 3 | 134027 | 277 | 6.843 | 19586.0 |
590 | 2024-03-18 20:45:11 | comment | 3 | 134027 | 277 | 11.470 | 11685.0 |
589 | 2024-03-18 07:40:29 | comment | 2 | 107671 | 28 | 3.533 | 30475.8 |
588 | 2024-03-18 07:39:25 | comment | 3 | 134027 | 277 | 7.550 | 17751.9 |
587 | 2024-03-17 09:53:11 | comment | 1 | 69583 | 3 | 1.296 | 53690.6 |
586 | 2024-03-17 09:52:50 | comment | 3 | 134027 | 277 | 6.716 | 19956.4 |
585 | 2024-03-17 09:52:53 | comment | 2 | 107671 | 28 | 3.766 | 28590.3 |
584 | 2024-03-17 09:52:36 | comment | 1 | 69583 | 3 | 1.283 | 54234.6 |
583 | 2024-03-05 21:26:26 | comment | 1 | 69583 | 3 | 1.250 | 55666.4 |
582 | 2024-03-02 13:16:27 | comment | 1 | 69583 | 3 | 1.326 | 52475.9 |
581 | 2024-02-13 14:40:20 | comment | 1 | 69583 | 3 | 4.106 | 16946.7 |
580 | 2024-02-07 16:10:38 | comment | 2 | 107671 | 28 | 3.283 | 32796.5 |
579 | 2024-02-07 16:09:50 | comment | 3 | 134027 | 277 | 6.140 | 21828.5 |
578 | 2024-02-07 00:06:07 | comment | 2 | 107671 | 28 | 4.470 | 24087.5 |
577 | 2024-02-07 00:02:26 | comment | 3 | 134027 | 277 | 7.953 | 16852.4 |
576 | 2024-02-06 22:11:21 | comment | 3 | 134027 | 277 | 7.563 | 17721.4 |
575 | 2024-02-06 22:10:41 | comment | 2 | 107671 | 28 | 3.450 | 31209.0 |
574 | 2024-01-10 10:18:46 | comment | 1 | 69583 | 3 | 1.110 | 62687.4 |
573 | 2023-12-21 04:56:39 | comment | 1 | 69583 | 3 | 1.220 | 57035.2 |
572 | 2023-12-14 23:36:05 | comment | 2 | 107671 | 28 | 3.250 | 33129.5 |
571 | 2023-12-11 06:43:21 | comment | 3 | 134027 | 277 | 6.716 | 19956.4 |
570 | 2023-12-11 06:43:18 | comment | 2 | 107671 | 28 | 3.203 | 33615.7 |
569 | 2023-12-03 14:26:44 | comment | 3 | 134027 | 277 | 7.233 | 18529.9 |
568 | 2023-12-03 14:26:43 | comment | 2 | 107671 | 28 | 6.936 | 15523.5 |
567 | 2023-11-30 17:23:11 | comment | 3 | 134027 | 277 | 5.890 | 22755.0 |
566 | 2023-11-26 21:14:14 | comment | 3 | 134027 | 277 | 6.423 | 20866.7 |
565 | 2023-11-26 21:14:11 | comment | 2 | 107671 | 28 | 2.813 | 38276.2 |
564 | 2023-11-13 03:59:08 | comment | 1 | 69583 | 3 | 1.233 | 56433.9 |
563 | 2023-11-11 01:29:06 | comment | 1 | 69583 | 3 | 1.096 | 63488.1 |
562 | 2023-11-10 02:09:40 | comment | 1 | 69583 | 3 | 1.310 | 53116.8 |
561 | 2023-10-27 23:43:45 | comment | 1 | 69583 | 3 | 1.263 | 55093.4 |
560 | 2023-10-20 04:13:03 | comment | 1 | 69583 | 3 | 1.296 | 53690.6 |
559 | 2023-10-18 00:16:39 | comment | 1 | 69583 | 3 | 1.110 | 62687.4 |
558 | 2023-10-14 04:10:57 | comment | 1 | 69583 | 3 | 1.263 | 55093.4 |
557 | 2023-10-08 22:45:43 | comment | 1 | 69583 | 3 | 1.110 | 62687.4 |
556 | 2023-10-04 05:44:09 | comment | 1 | 69583 | 3 | 1.220 | 57035.2 |
555 | 2023-09-23 12:31:16 | comment | 1 | 69583 | 3 | 1.203 | 57841.2 |
554 | 2023-09-12 05:44:36 | comment | 1 | 69583 | 3 | 1.216 | 57222.9 |
553 | 2023-09-12 03:20:10 | comment | 2 | 107671 | 28 | 3.330 | 32333.6 |
552 | 2023-08-30 02:56:55 | comment | 3 | 134027 | 277 | 5.763 | 23256.5 |
551 | 2023-08-05 01:26:25 | comment | 1 | 69583 | 3 | 1.140 | 61037.7 |
550 | 2023-08-03 01:31:09 | comment | 1 | 69583 | 3 | 1.203 | 57841.2 |
549 | 2023-06-01 17:20:28 | comment | 2 | 107671 | 28 | 2.826 | 38100.1 |
548 | 2023-05-16 16:36:11 | comment | 3 | 134027 | 277 | 5.640 | 23763.7 |
547 | 2023-05-01 05:06:17 | comment | 1 | 69583 | 3 | 1.093 | 63662.4 |
546 | 2023-04-25 14:12:13 | comment | 1 | 69583 | 3 | 1.076 | 64668.2 |
545 | 2023-03-09 15:37:16 | comment | 2 | 107671 | 28 | 2.796 | 38508.9 |
544 | 2023-02-24 03:37:28 | comment | 1 | 69583 | 3 | 1.126 | 61796.6 |
543 | 2023-02-22 12:40:46 | comment | 3 | 134027 | 277 | 5.703 | 23501.1 |
542 | 2023-01-09 12:00:33 | comment | 1 | 69583 | 3 | 1.190 | 58473.1 |
541 | 2022-12-22 23:43:56 | comment | 1 | 69583 | 3 | 1.063 | 65459.1 |
540 | 2022-12-13 20:38:27 | comment | 2 | 107671 | 28 | 3.123 | 34476.8 |
539 | 2022-12-02 22:08:26 | comment | 3 | 134027 | 277 | 6.420 | 20876.5 |
538 | 2022-11-24 17:20:59 | comment | 1 | 69583 | 3 | 1.110 | 62687.4 |
537 | 2022-09-25 16:52:42 | comment | 1 | 69583 | 3 | 1.110 | 62687.4 |
536 | 2022-09-10 12:46:17 | comment | 1 | 69583 | 3 | 1.156 | 60192.9 |
535 | 2022-09-09 08:02:41 | comment | 1 | 69583 | 3 | 1.080 | 64428.7 |
534 | 2022-09-01 15:31:09 | comment | 1 | 69583 | 3 | 1.126 | 61796.6 |
533 | 2022-08-02 04:53:52 | comment | 2 | 107671 | 28 | 2.873 | 37476.9 |
532 | 2022-07-30 21:23:47 | comment | 2 | 107671 | 28 | 2.796 | 38508.9 |
531 | 2022-07-11 09:54:42 | comment | 3 | 134027 | 277 | 5.640 | 23763.7 |
530 | 2022-06-08 16:40:09 | comment | 1 | 69583 | 3 | 1.093 | 63662.4 |
529 | 2022-04-24 21:53:22 | comment | 1 | 69583 | 3 | 1.203 | 57841.2 |
528 | 2022-04-22 15:02:28 | comment | 1 | 69583 | 3 | 1.326 | 52475.9 |
527 | 2022-03-10 06:34:08 | comment | 2 | 107671 | 28 | 2.856 | 37699.9 |
526 | 2022-02-21 19:37:49 | comment | 1 | 69583 | 3 | 1.656 | 42018.7 |
525 | 2022-01-16 05:33:39 | comment | 1 | 69583 | 3 | 1.173 | 59320.5 |
524 | 2021-12-16 10:58:54 | comment | 2 | 107671 | 28 | 3.486 | 30886.7 |
523 | 2021-11-17 02:04:21 | comment | 1 | 69583 | 3 | 1.093 | 63662.4 |
522 | 2021-11-14 03:14:05 | comment | 1 | 69583 | 3 | 1.126 | 61796.6 |
521 | 2021-10-03 22:32:21 | comment | 1 | 69583 | 3 | 1.263 | 55093.4 |
520 | 2021-08-30 08:25:47 | comment | 1 | 69583 | 3 | 2.156 | 32274.1 |
519 | 2021-08-28 03:31:13 | comment | 1 | 69583 | 3 | 1.096 | 63488.1 |
518 | 2021-08-14 04:47:32 | comment | 1 | 69583 | 3 | 1.093 | 63662.4 |
517 | 2021-05-31 06:58:19 | comment | 1 | 69583 | 3 | 1.123 | 61961.7 |
516 | 2021-05-29 17:08:13 | comment | 2 | 107671 | 28 | 3.500 | 30763.1 |
515 | 2021-05-13 12:27:27 | comment | 1 | 69583 | 3 | 1.156 | 60192.9 |
514 | 2021-05-06 01:50:20 | comment | 1 | 69583 | 3 | 1.093 | 63662.4 |
513 | 2021-05-04 05:40:16 | comment | 2 | 107671 | 28 | 2.936 | 36672.7 |
512 | 2021-05-01 03:12:47 | comment | 1 | 69583 | 3 | 1.640 | 42428.7 |
511 | 2021-04-04 05:00:17 | comment | 1 | 69583 | 3 | 1.220 | 57035.2 |
510 | 2021-04-02 09:26:27 | comment | 2 | 107671 | 28 | 2.923 | 36835.8 |
509 | 2021-02-10 21:55:18 | comment | 3 | 134027 | 277 | 6.110 | 21935.7 |
508 | 2021-02-10 02:32:25 | comment | 1 | 69583 | 3 | 1.110 | 62687.4 |
507 | 2021-02-09 20:54:01 | comment | 1 | 69583 | 3 | 1.250 | 55666.4 |
506 | 2021-01-19 14:36:32 | comment | 1 | 69583 | 3 | 1.280 | 54361.7 |