History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"joyance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
577 | 2024-02-07 02:56:08 | joyance | 1 | 69583 | 2 | 1.126 | 61796.6 |
576 | 2024-02-05 02:33:28 | joyance | 4 | 151207 | 817 | 17.173 | 8804.9 |
575 | 2024-02-03 10:22:22 | joyance | 2 | 107671 | 6 | 3.160 | 34073.1 |
574 | 2024-02-03 10:19:54 | joyance | 3 | 134027 | 69 | 6.953 | 19276.1 |
573 | 2024-01-26 12:33:11 | joyance | 2 | 107671 | 6 | 3.186 | 33795.0 |
572 | 2024-01-26 12:32:59 | joyance | 3 | 134027 | 69 | 8.530 | 15712.4 |
571 | 2024-01-26 12:21:19 | joyance | 4 | 151207 | 817 | 18.390 | 8222.2 |
570 | 2024-01-23 03:44:52 | joyance | 4 | 151207 | 817 | 34.660 | 4362.6 |
569 | 2024-01-22 19:32:50 | joyance | 4 | 151207 | 817 | 13.513 | 11189.7 |
568 | 2024-01-20 17:58:28 | joyance | 4 | 151207 | 817 | 12.063 | 12534.8 |
567 | 2024-01-20 17:58:23 | joyance | 3 | 134027 | 69 | 6.516 | 20568.9 |
566 | 2024-01-14 18:00:39 | joyance | 4 | 151207 | 817 | 19.500 | 7754.2 |
565 | 2024-01-14 18:00:40 | joyance | 2 | 107671 | 6 | 5.530 | 19470.3 |
564 | 2023-12-12 04:16:19 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
563 | 2023-12-03 04:23:50 | joyance | 1 | 69583 | 2 | 1.063 | 65459.1 |
562 | 2023-11-28 13:47:02 | joyance | 1 | 69583 | 2 | 1.030 | 67556.3 |
561 | 2023-11-17 16:56:36 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
560 | 2023-11-11 16:19:09 | joyance | 1 | 69583 | 2 | 1.186 | 58670.3 |
559 | 2023-10-19 09:08:42 | joyance | 1 | 69583 | 2 | 1.110 | 62687.4 |
558 | 2023-10-12 07:07:14 | joyance | 1 | 69583 | 2 | 1.093 | 63662.4 |
557 | 2023-09-29 10:55:38 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
556 | 2023-09-15 12:33:21 | joyance | 1 | 69583 | 2 | 1.126 | 61796.6 |
555 | 2023-09-13 16:39:31 | joyance | 1 | 69583 | 2 | 1.173 | 59320.5 |
554 | 2023-07-07 12:21:15 | joyance | 1 | 69583 | 2 | 1.296 | 53690.6 |
553 | 2023-07-06 05:22:36 | joyance | 1 | 69583 | 2 | 1.173 | 59320.5 |
552 | 2023-07-01 22:45:29 | joyance | 1 | 69583 | 2 | 1.123 | 61961.7 |
551 | 2023-06-28 17:34:04 | joyance | 1 | 69583 | 2 | 1.016 | 68487.2 |
550 | 2023-04-07 16:32:35 | joyance | 1 | 69583 | 2 | 1.173 | 59320.5 |
549 | 2023-02-23 08:51:25 | joyance | 1 | 69583 | 2 | 1.123 | 61961.7 |
548 | 2023-01-22 04:32:34 | joyance | 1 | 69583 | 2 | 1.033 | 67360.1 |
547 | 2022-11-19 01:59:26 | joyance | 1 | 69583 | 2 | 1.033 | 67360.1 |
546 | 2022-10-19 14:25:30 | joyance | 1 | 69583 | 2 | 1.236 | 56296.9 |
545 | 2022-09-01 07:11:09 | joyance | 1 | 69583 | 2 | 1.016 | 68487.2 |
544 | 2022-07-14 11:29:19 | joyance | 2 | 107671 | 6 | 2.640 | 40784.5 |
543 | 2022-07-11 06:29:27 | joyance | 1 | 69583 | 2 | 1.016 | 68487.2 |
542 | 2022-07-09 07:02:46 | joyance | 1 | 69583 | 2 | 1.093 | 63662.4 |
541 | 2022-06-03 15:36:39 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
540 | 2022-03-09 16:30:34 | joyance | 1 | 69583 | 2 | 1.280 | 54361.7 |
539 | 2022-01-23 10:59:59 | joyance | 1 | 69583 | 2 | 1.173 | 59320.5 |
538 | 2021-12-22 05:43:27 | joyance | 1 | 69583 | 2 | 1.156 | 60192.9 |
537 | 2021-12-20 02:42:03 | joyance | 1 | 69583 | 2 | 1.280 | 54361.7 |
536 | 2021-09-30 18:13:04 | joyance | 1 | 69583 | 2 | 1.200 | 57985.8 |
535 | 2021-07-01 08:51:11 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
534 | 2021-06-26 22:20:29 | joyance | 1 | 69583 | 2 | 2.000 | 34791.5 |
533 | 2021-05-02 01:24:28 | joyance | 1 | 69583 | 2 | 1.216 | 57222.9 |
532 | 2021-04-08 09:21:41 | joyance | 1 | 69583 | 2 | 1.033 | 67360.1 |
531 | 2021-03-31 10:21:10 | joyance | 1 | 69583 | 2 | 1.173 | 59320.5 |
530 | 2021-03-12 15:01:13 | joyance | 1 | 69583 | 2 | 1.033 | 67360.1 |
529 | 2021-01-23 07:16:41 | joyance | 1 | 69583 | 2 | 1.050 | 66269.5 |
528 | 2020-12-26 22:38:50 | joyance | 1 | 69583 | 2 | 1.156 | 60192.9 |
527 | 2020-12-24 14:23:23 | joyance | 1 | 69583 | 2 | 1.063 | 65459.1 |
526 | 2020-11-09 20:12:45 | joyance | 1 | 69583 | 2 | 1.060 | 65644.3 |
525 | 2020-10-23 10:14:37 | joyance | 1 | 69583 | 2 | 1.123 | 61961.7 |
524 | 2020-10-10 20:44:17 | joyance | 1 | 69583 | 2 | 1.016 | 68487.2 |
523 | 2020-09-30 17:33:30 | joyance | 1 | 69583 | 2 | 1.000 | 69583.0 |
522 | 2020-09-23 06:19:02 | joyance | 1 | 69583 | 2 | 1.063 | 65459.1 |
521 | 2020-09-19 23:41:39 | joyance | 1 | 69583 | 2 | 1.033 | 67360.1 |
520 | 2020-09-17 10:54:52 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
519 | 2020-08-25 02:43:37 | joyance | 1 | 69583 | 2 | 1.060 | 65644.3 |
518 | 2020-07-28 03:50:43 | joyance | 1 | 69583 | 2 | 1.296 | 53690.6 |
517 | 2020-07-23 20:50:01 | joyance | 1 | 69583 | 2 | 1.080 | 64428.7 |
516 | 2020-06-12 05:39:16 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
515 | 2020-06-09 05:44:33 | joyance | 1 | 69583 | 2 | 1.063 | 65459.1 |
514 | 2020-05-21 02:11:43 | joyance | 1 | 69583 | 2 | 1.046 | 66522.9 |
513 | 2020-03-29 02:15:48 | joyance | 1 | 69583 | 2 | 1.346 | 51696.1 |
512 | 2020-03-23 14:38:36 | joyance | 1 | 69583 | 2 | 1.983 | 35089.8 |
511 | 2020-02-29 20:07:31 | joyance | 1 | 69583 | 2 | 1.283 | 54234.6 |
510 | 2020-02-27 13:23:47 | joyance | 4 | 151207 | 817 | 14.046 | 10765.1 |
509 | 2020-02-27 12:23:02 | joyance | 4 | 151207 | 817 | 12.610 | 11991.0 |
508 | 2020-02-27 09:08:05 | joyance | 4 | 151207 | 817 | 32.346 | 4674.7 |
507 | 2020-02-27 01:40:42 | joyance | 1 | 69583 | 2 | 1.326 | 52475.9 |
506 | 2020-02-24 15:04:29 | joyance | 4 | 151207 | 817 | 9.640 | 15685.4 |
505 | 2020-02-24 08:40:04 | joyance | 1 | 69583 | 2 | 2.016 | 34515.4 |
504 | 2020-02-22 08:11:42 | joyance | 4 | 151207 | 817 | 14.860 | 10175.4 |
503 | 2020-02-22 06:36:14 | joyance | 4 | 151207 | 817 | 15.343 | 9855.1 |
502 | 2020-02-21 14:15:44 | joyance | 4 | 151207 | 817 | 18.533 | 8158.8 |
501 | 2020-02-16 02:54:27 | joyance | 1 | 69583 | 2 | 1.220 | 57035.2 |
500 | 2020-02-09 01:49:09 | joyance | 1 | 69583 | 2 | 1.126 | 61796.6 |
499 | 2020-02-05 05:39:45 | joyance | 1 | 69583 | 2 | 1.310 | 53116.8 |
498 | 2020-02-03 16:08:55 | joyance | 1 | 69583 | 2 | 3.186 | 21840.2 |
497 | 2020-01-29 06:39:38 | joyance | 1 | 69583 | 2 | 1.233 | 56433.9 |
496 | 2020-01-27 20:42:17 | joyance | 1 | 69583 | 2 | 1.280 | 54361.7 |
495 | 2020-01-25 01:01:09 | joyance | 1 | 69583 | 2 | 2.326 | 29915.3 |
494 | 2020-01-18 14:44:52 | joyance | 1 | 69583 | 2 | 1.423 | 48898.8 |
493 | 2020-01-18 11:26:02 | joyance | 1 | 69583 | 2 | 1.766 | 39401.5 |
492 | 2020-01-17 19:27:08 | joyance | 4 | 151207 | 817 | 12.703 | 11903.3 |
491 | 2020-01-17 16:43:31 | joyance | 4 | 151207 | 817 | 11.373 | 13295.3 |
490 | 2020-01-17 13:55:47 | joyance | 4 | 151207 | 817 | 11.533 | 13110.8 |
489 | 2020-01-17 11:59:21 | joyance | 4 | 151207 | 817 | 19.580 | 7722.5 |
488 | 2020-01-13 01:23:42 | joyance | 1 | 69583 | 2 | 1.280 | 54361.7 |
487 | 2020-01-06 23:47:59 | joyance | 1 | 69583 | 2 | 1.330 | 52318.0 |
486 | 2020-01-01 22:58:22 | joyance | 1 | 69583 | 2 | 2.580 | 26970.2 |
485 | 2019-12-31 14:16:21 | joyance | 1 | 69583 | 2 | 1.516 | 45899.1 |
484 | 2019-12-02 22:14:26 | joyance | 1 | 69583 | 2 | 1.076 | 64668.2 |
483 | 2019-11-16 08:30:25 | joyance | 1 | 69583 | 2 | 2.203 | 31585.6 |
482 | 2019-08-14 21:45:40 | joyance | 1 | 69583 | 2 | 0.953 | 73014.7 |
481 | 2019-08-04 04:55:37 | joyance | 1 | 69583 | 2 | 1.000 | 69583.0 |
480 | 2019-07-24 06:23:47 | joyance | 1 | 69583 | 2 | 1.096 | 63488.1 |
479 | 2019-07-18 17:52:48 | joyance | 1 | 69583 | 2 | 1.363 | 51051.4 |
478 | 2019-06-22 23:04:43 | joyance | 1 | 69583 | 2 | 1.056 | 65893.0 |