History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aspired"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
605 | 2024-03-15 22:26:10 | aspired | 1 | 69583 | 5 | 2.373 | 29322.8 |
604 | 2024-01-09 15:05:57 | aspired | 3 | 134027 | 385 | 9.156 | 14638.2 |
603 | 2024-01-09 15:05:58 | aspired | 2 | 107671 | 38 | 5.890 | 18280.3 |
602 | 2024-01-07 00:05:04 | aspired | 3 | 134027 | 385 | 7.233 | 18529.9 |
601 | 2024-01-02 18:52:51 | aspired | 1 | 69583 | 5 | 1.110 | 62687.4 |
600 | 2023-12-24 00:40:52 | aspired | 1 | 69583 | 5 | 1.080 | 64428.7 |
599 | 2023-11-24 12:13:48 | aspired | 3 | 134027 | 385 | 6.060 | 22116.7 |
598 | 2023-11-19 11:57:02 | aspired | 1 | 69583 | 5 | 2.326 | 29915.3 |
597 | 2023-11-14 18:13:15 | aspired | 1 | 69583 | 5 | 1.063 | 65459.1 |
596 | 2023-11-11 06:42:41 | aspired | 1 | 69583 | 5 | 1.250 | 55666.4 |
595 | 2023-11-03 07:50:32 | aspired | 1 | 69583 | 5 | 1.126 | 61796.6 |
594 | 2023-10-24 17:34:32 | aspired | 1 | 69583 | 5 | 1.156 | 60192.9 |
593 | 2023-10-24 04:36:40 | aspired | 1 | 69583 | 5 | 1.263 | 55093.4 |
592 | 2023-10-17 15:52:53 | aspired | 3 | 134027 | 385 | 18.860 | 7106.4 |
591 | 2023-10-14 07:59:06 | aspired | 3 | 134027 | 385 | 6.453 | 20769.7 |
590 | 2023-10-10 13:24:29 | aspired | 1 | 69583 | 5 | 1.250 | 55666.4 |
589 | 2023-10-08 09:23:53 | aspired | 1 | 69583 | 5 | 1.093 | 63662.4 |
588 | 2023-09-26 10:09:26 | aspired | 1 | 69583 | 5 | 1.093 | 63662.4 |
587 | 2023-09-14 12:23:28 | aspired | 1 | 69583 | 5 | 1.233 | 56433.9 |
586 | 2023-09-07 07:58:09 | aspired | 1 | 69583 | 5 | 1.170 | 59472.6 |
585 | 2023-09-03 18:19:49 | aspired | 1 | 69583 | 5 | 1.220 | 57035.2 |
584 | 2023-08-07 05:08:33 | aspired | 1 | 69583 | 5 | 1.190 | 58473.1 |
583 | 2023-07-24 22:46:49 | aspired | 3 | 134027 | 385 | 6.266 | 21389.6 |
582 | 2023-05-21 10:29:16 | aspired | 1 | 69583 | 5 | 1.250 | 55666.4 |
581 | 2023-05-01 20:13:28 | aspired | 1 | 69583 | 5 | 1.220 | 57035.2 |
580 | 2023-04-07 16:58:35 | aspired | 3 | 134027 | 385 | 6.236 | 21492.5 |
579 | 2023-02-21 11:21:24 | aspired | 1 | 69583 | 5 | 1.080 | 64428.7 |
578 | 2023-02-08 07:19:10 | aspired | 1 | 69583 | 5 | 1.140 | 61037.7 |
577 | 2023-01-05 04:32:46 | aspired | 3 | 134027 | 385 | 5.860 | 22871.5 |
576 | 2022-12-20 02:36:27 | aspired | 1 | 69583 | 5 | 1.063 | 65459.1 |
575 | 2022-10-25 08:50:00 | aspired | 1 | 69583 | 5 | 1.263 | 55093.4 |
574 | 2022-09-09 16:48:07 | aspired | 3 | 134027 | 385 | 6.233 | 21502.8 |
573 | 2022-09-07 14:34:16 | aspired | 3 | 134027 | 385 | 6.330 | 21173.3 |
572 | 2022-08-31 00:44:04 | aspired | 1 | 69583 | 5 | 1.063 | 65459.1 |
571 | 2022-07-05 17:33:24 | aspired | 1 | 69583 | 5 | 1.200 | 57985.8 |
570 | 2022-04-15 11:36:14 | aspired | 1 | 69583 | 5 | 1.576 | 44151.6 |
569 | 2022-03-28 22:02:20 | aspired | 3 | 134027 | 385 | 6.580 | 20368.8 |
568 | 2022-03-14 21:52:54 | aspired | 1 | 69583 | 5 | 1.423 | 48898.8 |
567 | 2022-01-15 12:59:03 | aspired | 1 | 69583 | 5 | 1.280 | 54361.7 |
566 | 2021-12-04 14:18:53 | aspired | 1 | 69583 | 5 | 1.140 | 61037.7 |
565 | 2021-11-13 09:44:32 | aspired | 1 | 69583 | 5 | 1.233 | 56433.9 |
564 | 2021-10-01 02:43:46 | aspired | 1 | 69583 | 5 | 1.220 | 57035.2 |
563 | 2021-09-28 23:31:00 | aspired | 1 | 69583 | 5 | 1.186 | 58670.3 |
562 | 2021-09-07 12:48:10 | aspired | 1 | 69583 | 5 | 1.220 | 57035.2 |
561 | 2021-08-28 04:52:45 | aspired | 1 | 69583 | 5 | 1.233 | 56433.9 |
560 | 2021-06-21 07:55:57 | aspired | 1 | 69583 | 5 | 1.110 | 62687.4 |
559 | 2021-05-27 10:44:29 | aspired | 1 | 69583 | 5 | 1.233 | 56433.9 |
558 | 2021-05-02 19:49:26 | aspired | 1 | 69583 | 5 | 1.266 | 54962.9 |
557 | 2021-04-01 19:43:58 | aspired | 1 | 69583 | 5 | 1.126 | 61796.6 |
556 | 2021-02-22 03:37:51 | aspired | 1 | 69583 | 5 | 1.186 | 58670.3 |
555 | 2021-02-21 15:30:22 | aspired | 1 | 69583 | 5 | 1.376 | 50569.0 |
554 | 2021-02-10 10:12:58 | aspired | 1 | 69583 | 5 | 1.186 | 58670.3 |
553 | 2020-12-17 19:24:50 | aspired | 1 | 69583 | 5 | 1.330 | 52318.0 |
552 | 2020-11-19 02:04:27 | aspired | 1 | 69583 | 5 | 1.156 | 60192.9 |
551 | 2020-11-09 03:03:01 | aspired | 1 | 69583 | 5 | 2.733 | 25460.3 |
550 | 2020-10-27 09:41:29 | aspired | 1 | 69583 | 5 | 1.250 | 55666.4 |
549 | 2020-10-18 20:35:59 | aspired | 1 | 69583 | 5 | 1.220 | 57035.2 |
548 | 2020-10-16 10:28:17 | aspired | 1 | 69583 | 5 | 1.063 | 65459.1 |
547 | 2020-08-12 20:14:37 | aspired | 1 | 69583 | 5 | 1.186 | 58670.3 |
546 | 2020-07-19 22:39:24 | aspired | 1 | 69583 | 5 | 1.126 | 61796.6 |
545 | 2020-05-11 18:04:08 | aspired | 1 | 69583 | 5 | 1.110 | 62687.4 |
544 | 2020-03-28 09:51:34 | aspired | 1 | 69583 | 5 | 1.263 | 55093.4 |
543 | 2020-03-27 01:01:53 | aspired | 1 | 69583 | 5 | 2.453 | 28366.5 |
542 | 2020-03-25 20:55:19 | aspired | 1 | 69583 | 5 | 1.203 | 57841.2 |
541 | 2020-03-22 10:18:39 | aspired | 1 | 69583 | 5 | 1.233 | 56433.9 |
540 | 2020-03-20 16:41:37 | aspired | 1 | 69583 | 5 | 1.143 | 60877.5 |
539 | 2020-02-26 01:02:31 | aspired | 1 | 69583 | 5 | 1.203 | 57841.2 |
538 | 2020-02-23 20:53:08 | aspired | 1 | 69583 | 5 | 2.623 | 26528.0 |
537 | 2020-02-12 11:52:12 | aspired | 1 | 69583 | 5 | 2.720 | 25582.0 |
536 | 2020-02-09 03:20:54 | aspired | 1 | 69583 | 5 | 1.153 | 60349.5 |
535 | 2020-02-08 16:27:25 | aspired | 1 | 69583 | 5 | 1.250 | 55666.4 |
534 | 2020-02-02 20:44:15 | aspired | 1 | 69583 | 5 | 1.296 | 53690.6 |
533 | 2020-01-31 17:46:35 | aspired | 1 | 69583 | 5 | 1.440 | 48321.5 |
532 | 2020-01-28 18:22:44 | aspired | 1 | 69583 | 5 | 1.203 | 57841.2 |
531 | 2020-01-24 07:43:39 | aspired | 1 | 69583 | 5 | 2.796 | 24886.6 |
530 | 2020-01-17 20:05:47 | aspired | 1 | 69583 | 5 | 1.216 | 57222.9 |
529 | 2020-01-16 08:39:21 | aspired | 1 | 69583 | 5 | 1.263 | 55093.4 |
528 | 2020-01-11 14:33:26 | aspired | 1 | 69583 | 5 | 1.393 | 49951.9 |
527 | 2020-01-04 06:54:49 | aspired | 1 | 69583 | 5 | 2.470 | 28171.3 |
526 | 2019-12-27 15:46:15 | aspired | 1 | 69583 | 5 | 1.266 | 54962.9 |
525 | 2019-12-27 14:42:42 | aspired | 1 | 69583 | 5 | 1.093 | 63662.4 |
524 | 2019-12-27 13:35:58 | aspired | 1 | 69583 | 5 | 1.296 | 53690.6 |
523 | 2019-12-25 03:29:57 | aspired | 1 | 69583 | 5 | 1.216 | 57222.9 |
522 | 2019-11-08 17:05:44 | aspired | 1 | 69583 | 5 | 1.156 | 60192.9 |
521 | 2019-08-10 14:12:21 | aspired | 1 | 69583 | 5 | 1.210 | 57506.6 |
520 | 2019-07-17 09:15:09 | aspired | 1 | 69583 | 5 | 1.076 | 64668.2 |
519 | 2019-05-10 18:39:25 | aspired | 1 | 69583 | 5 | 1.296 | 53690.6 |
518 | 2019-03-04 22:14:39 | aspired | 1 | 69583 | 5 | 1.040 | 66906.7 |
517 | 2019-02-26 16:35:13 | aspired | 1 | 69583 | 5 | 1.210 | 57506.6 |
516 | 2019-02-07 17:43:27 | aspired | 1 | 69583 | 5 | 1.730 | 40221.4 |
515 | 2019-01-12 02:21:52 | aspired | 1 | 69583 | 5 | 1.110 | 62687.4 |
514 | 2019-01-05 08:45:28 | aspired | 1 | 69583 | 5 | 1.080 | 64428.7 |
513 | 2018-12-16 09:00:04 | aspired | 1 | 69583 | 5 | 1.050 | 66269.5 |
512 | 2018-12-12 16:47:57 | aspired | 1 | 69583 | 5 | 1.143 | 60877.5 |
511 | 2018-12-07 00:21:10 | aspired | 1 | 69583 | 5 | 1.040 | 66906.7 |
510 | 2018-12-03 03:32:50 | aspired | 1 | 69583 | 5 | 1.126 | 61796.6 |
509 | 2018-11-23 17:51:29 | aspired | 1 | 69583 | 5 | 1.150 | 60507.0 |
508 | 2018-11-19 21:36:20 | aspired | 1 | 69583 | 5 | 1.046 | 66522.9 |
507 | 2018-11-03 15:48:35 | aspired | 1 | 69583 | 5 | 1.043 | 66714.3 |
506 | 2018-10-20 07:04:36 | aspired | 1 | 69583 | 5 | 1.026 | 67819.7 |