History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
598 | 2024-04-27 08:01:46 | collate | 1 | 69583 | 4 | 1.123 | 61961.7 |
597 | 2024-04-27 07:05:13 | collate | 1 | 69583 | 4 | 3.436 | 20251.2 |
596 | 2024-02-28 10:28:08 | collate | 1 | 69583 | 4 | 1.563 | 44518.9 |
595 | 2024-01-30 13:16:51 | collate | 1 | 69583 | 4 | 1.186 | 58670.3 |
594 | 2024-01-21 21:19:43 | collate | 2 | 107671 | 56 | 2.826 | 38100.1 |
593 | 2024-01-21 20:44:50 | collate | 2 | 107671 | 56 | 3.030 | 35535.0 |
592 | 2024-01-20 10:06:48 | collate | 1 | 69583 | 4 | 1.110 | 62687.4 |
591 | 2024-01-16 17:45:44 | collate | 1 | 69583 | 4 | 1.203 | 57841.2 |
590 | 2023-12-27 22:18:41 | collate | 3 | 134027 | 449 | 6.970 | 19229.1 |
589 | 2023-12-27 18:24:57 | collate | 3 | 134027 | 449 | 8.093 | 16560.9 |
588 | 2023-12-26 08:13:35 | collate | 3 | 134027 | 449 | 7.890 | 16986.9 |
587 | 2023-12-16 00:16:49 | collate | 1 | 69583 | 4 | 1.093 | 63662.4 |
586 | 2023-11-27 19:45:57 | collate | 1 | 69583 | 4 | 1.186 | 58670.3 |
585 | 2023-11-25 23:16:09 | collate | 1 | 69583 | 4 | 1.200 | 57985.8 |
584 | 2023-11-18 10:55:42 | collate | 1 | 69583 | 4 | 1.266 | 54962.9 |
583 | 2023-11-12 17:14:30 | collate | 3 | 134027 | 449 | 6.673 | 20085.0 |
582 | 2023-11-06 12:47:28 | collate | 1 | 69583 | 4 | 1.080 | 64428.7 |
581 | 2023-11-02 08:00:12 | collate | 2 | 107671 | 56 | 3.233 | 33303.7 |
580 | 2023-11-01 03:10:26 | collate | 1 | 69583 | 4 | 2.406 | 28920.6 |
579 | 2023-10-24 12:52:07 | collate | 3 | 134027 | 449 | 9.236 | 14511.4 |
578 | 2023-10-15 22:37:27 | collate | 3 | 134027 | 449 | 6.826 | 19634.8 |
577 | 2023-10-13 13:57:49 | collate | 1 | 69583 | 4 | 1.266 | 54962.9 |
576 | 2023-10-06 14:16:52 | collate | 3 | 134027 | 449 | 21.830 | 6139.6 |
575 | 2023-10-02 22:12:59 | collate | 1 | 69583 | 4 | 1.313 | 52995.4 |
574 | 2023-10-02 11:49:17 | collate | 3 | 134027 | 449 | 5.923 | 22628.2 |
573 | 2023-09-23 01:10:04 | collate | 1 | 69583 | 4 | 1.093 | 63662.4 |
572 | 2023-09-18 21:59:20 | collate | 1 | 69583 | 4 | 2.156 | 32274.1 |
571 | 2023-09-11 01:50:18 | collate | 1 | 69583 | 4 | 1.140 | 61037.7 |
570 | 2023-08-09 04:32:22 | collate | 2 | 107671 | 56 | 2.940 | 36622.8 |
569 | 2023-07-13 16:32:02 | collate | 3 | 134027 | 449 | 5.763 | 23256.5 |
568 | 2023-06-29 15:36:51 | collate | 1 | 69583 | 4 | 1.110 | 62687.4 |
567 | 2023-06-25 13:44:09 | collate | 1 | 69583 | 4 | 1.203 | 57841.2 |
566 | 2023-04-24 13:16:53 | collate | 2 | 107671 | 56 | 3.173 | 33933.5 |
565 | 2023-04-18 21:36:30 | collate | 2 | 107671 | 56 | 3.093 | 34811.2 |
564 | 2023-04-07 02:02:22 | collate | 1 | 69583 | 4 | 1.076 | 64668.2 |
563 | 2023-03-31 08:22:11 | collate | 3 | 134027 | 449 | 6.220 | 21547.7 |
562 | 2023-03-26 22:30:45 | collate | 1 | 69583 | 4 | 1.063 | 65459.1 |
561 | 2023-01-30 14:06:59 | collate | 1 | 69583 | 4 | 1.076 | 64668.2 |
560 | 2023-01-20 02:59:08 | collate | 2 | 107671 | 56 | 3.406 | 31612.2 |
559 | 2022-12-29 14:39:58 | collate | 3 | 134027 | 449 | 5.703 | 23501.1 |
558 | 2022-12-18 06:36:56 | collate | 1 | 69583 | 4 | 1.093 | 63662.4 |
557 | 2022-11-28 14:59:00 | collate | 1 | 69583 | 4 | 1.096 | 63488.1 |
556 | 2022-10-30 08:50:43 | collate | 2 | 107671 | 56 | 3.170 | 33965.6 |
555 | 2022-09-01 02:21:33 | collate | 3 | 134027 | 449 | 12.313 | 10885.0 |
554 | 2022-08-31 22:39:57 | collate | 1 | 69583 | 4 | 1.203 | 57841.2 |
553 | 2022-07-25 02:00:23 | collate | 1 | 69583 | 4 | 1.093 | 63662.4 |
552 | 2022-06-11 06:19:50 | collate | 2 | 107671 | 56 | 2.940 | 36622.8 |
551 | 2022-05-26 08:01:39 | collate | 1 | 69583 | 4 | 1.093 | 63662.4 |
550 | 2022-05-18 09:57:33 | collate | 2 | 107671 | 56 | 2.906 | 37051.3 |
549 | 2022-05-02 11:55:32 | collate | 1 | 69583 | 4 | 1.560 | 44604.5 |
548 | 2022-04-08 06:08:47 | collate | 1 | 69583 | 4 | 1.093 | 63662.4 |
547 | 2022-03-28 18:38:47 | collate | 3 | 134027 | 449 | 7.673 | 17467.4 |
546 | 2022-03-11 11:19:12 | collate | 1 | 69583 | 4 | 1.263 | 55093.4 |
545 | 2022-02-18 07:42:52 | collate | 1 | 69583 | 4 | 1.110 | 62687.4 |
544 | 2021-12-21 16:23:06 | collate | 1 | 69583 | 4 | 1.360 | 51164.0 |
543 | 2021-12-15 14:57:48 | collate | 3 | 134027 | 449 | 5.876 | 22809.2 |
542 | 2021-11-13 15:38:44 | collate | 1 | 69583 | 4 | 1.236 | 56296.9 |
541 | 2021-11-12 02:35:27 | collate | 1 | 69583 | 4 | 2.470 | 28171.3 |
540 | 2021-11-09 10:47:34 | collate | 2 | 107671 | 56 | 3.593 | 29966.9 |
539 | 2021-08-14 01:39:36 | collate | 1 | 69583 | 4 | 1.096 | 63488.1 |
538 | 2021-05-30 20:45:30 | collate | 2 | 107671 | 56 | 3.436 | 31336.1 |
537 | 2021-05-25 20:07:46 | collate | 1 | 69583 | 4 | 1.296 | 53690.6 |
536 | 2021-05-13 08:49:39 | collate | 1 | 69583 | 4 | 1.220 | 57035.2 |
535 | 2021-05-12 12:59:01 | collate | 2 | 107671 | 56 | 3.593 | 29966.9 |
534 | 2021-05-09 19:12:24 | collate | 1 | 69583 | 4 | 1.250 | 55666.4 |
533 | 2021-05-05 14:53:03 | collate | 2 | 107671 | 56 | 3.220 | 33438.2 |
532 | 2021-04-30 10:35:40 | collate | 1 | 69583 | 4 | 1.313 | 52995.4 |
531 | 2021-04-29 16:04:22 | collate | 1 | 69583 | 4 | 1.313 | 52995.4 |
530 | 2021-04-03 18:57:11 | collate | 2 | 107671 | 56 | 2.906 | 37051.3 |
529 | 2021-03-29 04:26:38 | collate | 1 | 69583 | 4 | 1.220 | 57035.2 |
528 | 2021-02-19 13:12:46 | collate | 2 | 107671 | 56 | 2.906 | 37051.3 |
527 | 2021-02-15 21:33:25 | collate | 2 | 107671 | 56 | 3.000 | 35890.3 |
526 | 2021-02-11 20:56:07 | collate | 2 | 107671 | 56 | 2.873 | 37476.9 |
525 | 2021-02-07 05:18:36 | collate | 2 | 107671 | 56 | 2.920 | 36873.6 |
524 | 2021-02-04 06:24:58 | collate | 1 | 69583 | 4 | 1.076 | 64668.2 |
523 | 2021-02-03 04:27:55 | collate | 2 | 107671 | 56 | 3.266 | 32967.2 |
522 | 2021-01-29 18:47:38 | collate | 2 | 107671 | 56 | 3.080 | 34958.1 |
521 | 2021-01-27 15:27:24 | collate | 2 | 107671 | 56 | 2.906 | 37051.3 |
520 | 2021-01-26 00:16:40 | collate | 2 | 107671 | 56 | 2.860 | 37647.2 |
519 | 2021-01-21 17:41:17 | collate | 2 | 107671 | 56 | 2.953 | 36461.6 |
518 | 2021-01-20 07:23:42 | collate | 2 | 107671 | 56 | 2.970 | 36252.9 |
517 | 2021-01-17 11:34:25 | collate | 2 | 107671 | 56 | 3.080 | 34958.1 |
516 | 2021-01-13 14:54:27 | collate | 2 | 107671 | 56 | 2.890 | 37256.4 |
515 | 2021-01-12 22:35:49 | collate | 1 | 69583 | 4 | 1.313 | 52995.4 |
514 | 2021-01-09 15:15:19 | collate | 2 | 107671 | 56 | 3.343 | 32207.9 |
513 | 2021-01-05 15:28:27 | collate | 2 | 107671 | 56 | 3.033 | 35499.8 |
512 | 2021-01-01 12:06:03 | collate | 2 | 107671 | 56 | 3.280 | 32826.5 |
511 | 2021-01-01 10:15:01 | collate | 2 | 107671 | 56 | 2.890 | 37256.4 |
510 | 2020-12-30 06:14:46 | collate | 2 | 107671 | 56 | 2.983 | 36094.9 |
509 | 2020-12-28 11:50:31 | collate | 2 | 107671 | 56 | 2.923 | 36835.8 |
508 | 2020-12-24 14:15:42 | collate | 2 | 107671 | 56 | 2.940 | 36622.8 |
507 | 2020-12-20 11:44:35 | collate | 2 | 107671 | 56 | 2.940 | 36622.8 |
506 | 2020-12-16 11:21:59 | collate | 2 | 107671 | 56 | 2.893 | 37217.8 |
505 | 2020-11-24 08:39:19 | collate | 2 | 107671 | 56 | 2.893 | 37217.8 |
504 | 2020-11-11 22:41:53 | collate | 2 | 107671 | 56 | 3.436 | 31336.1 |
503 | 2020-11-02 19:53:26 | collate | 1 | 69583 | 4 | 1.160 | 59985.3 |
502 | 2020-10-17 04:20:30 | collate | 2 | 107671 | 56 | 2.936 | 36672.7 |
501 | 2020-10-16 01:05:46 | collate | 1 | 69583 | 4 | 1.080 | 64428.7 |
500 | 2020-10-04 13:30:47 | collate | 2 | 107671 | 56 | 2.890 | 37256.4 |
499 | 2020-09-30 08:40:42 | collate | 1 | 69583 | 4 | 1.110 | 62687.4 |