History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"opal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
587 | 2024-04-27 17:17:09 | opal | 1 | 13983 | 8 | 0.283 | 49409.9 |
586 | 2024-04-27 02:33:15 | opal | 1 | 13983 | 8 | 0.546 | 25609.9 |
585 | 2024-04-05 00:28:17 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
584 | 2024-03-31 10:16:33 | opal | 2 | 29872 | 155 | 1.606 | 18600.2 |
583 | 2024-03-31 08:18:52 | opal | 1 | 13983 | 8 | 0.516 | 27098.8 |
582 | 2024-03-29 02:35:10 | opal | 1 | 13983 | 8 | 0.296 | 47239.9 |
581 | 2024-03-12 02:16:57 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
580 | 2024-03-05 19:43:02 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
579 | 2024-03-01 03:58:56 | opal | 1 | 13983 | 8 | 0.500 | 27966.0 |
578 | 2024-02-27 22:00:24 | opal | 2 | 29872 | 155 | 2.236 | 13359.6 |
577 | 2024-02-27 21:05:52 | opal | 1 | 13983 | 8 | 0.500 | 27966.0 |
576 | 2024-02-06 14:34:45 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
575 | 2024-02-03 01:00:22 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
574 | 2024-02-02 19:16:29 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
573 | 2024-01-29 03:48:27 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
572 | 2024-01-28 19:59:49 | opal | 1 | 13983 | 8 | 0.280 | 49939.3 |
571 | 2024-01-08 11:49:31 | opal | 2 | 29872 | 155 | 0.733 | 40753.1 |
570 | 2024-01-06 05:10:56 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
569 | 2023-12-22 08:24:06 | opal | 1 | 13983 | 8 | 0.296 | 47239.9 |
568 | 2023-12-21 19:31:52 | opal | 2 | 29872 | 155 | 0.843 | 35435.3 |
567 | 2023-12-07 16:28:41 | opal | 1 | 13983 | 8 | 0.500 | 27966.0 |
566 | 2023-12-07 16:28:40 | opal | 1 | 13983 | 8 | 0.500 | 27966.0 |
565 | 2023-11-21 18:08:16 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
564 | 2023-11-16 02:35:31 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
563 | 2023-11-12 01:25:34 | opal | 1 | 13983 | 8 | 0.203 | 68881.8 |
562 | 2023-11-04 13:52:10 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
561 | 2023-11-03 17:15:24 | opal | 2 | 29872 | 155 | 0.890 | 33564.0 |
560 | 2023-11-03 05:31:19 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
559 | 2023-11-02 02:53:24 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
558 | 2023-10-27 17:53:13 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
557 | 2023-10-19 21:38:45 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
556 | 2023-10-17 17:15:31 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
555 | 2023-10-11 11:23:41 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
554 | 2023-10-11 02:25:15 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
553 | 2023-10-05 17:34:04 | opal | 1 | 13983 | 8 | 0.200 | 69915.0 |
552 | 2023-09-28 11:41:23 | opal | 2 | 29872 | 155 | 0.843 | 35435.3 |
551 | 2023-09-24 05:21:53 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
550 | 2023-09-12 05:35:35 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
549 | 2023-09-08 14:24:47 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
548 | 2023-08-22 07:48:09 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
547 | 2023-08-01 06:27:03 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
546 | 2023-08-01 05:46:30 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
545 | 2023-07-08 20:33:10 | opal | 1 | 13983 | 8 | 0.206 | 67878.6 |
544 | 2023-06-20 23:06:42 | opal | 1 | 13983 | 8 | 0.203 | 68881.8 |
543 | 2023-06-17 18:41:14 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
542 | 2023-05-20 18:30:34 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
541 | 2023-03-26 21:09:37 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
540 | 2023-03-16 03:31:46 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
539 | 2023-03-08 20:11:34 | opal | 1 | 13983 | 8 | 0.203 | 68881.8 |
538 | 2023-01-05 22:42:37 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
537 | 2022-11-16 23:25:29 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
536 | 2022-09-26 12:49:32 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
535 | 2022-09-19 15:25:14 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
534 | 2022-08-14 17:06:23 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
533 | 2022-07-29 01:19:38 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
532 | 2022-07-20 10:50:56 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
531 | 2022-07-16 17:35:16 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
530 | 2022-07-10 09:50:57 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
529 | 2022-07-02 19:20:18 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
528 | 2022-05-13 00:49:15 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
527 | 2022-03-19 11:10:53 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
526 | 2022-03-16 00:21:46 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
525 | 2022-02-13 15:30:00 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
524 | 2022-01-31 22:52:45 | opal | 1 | 13983 | 8 | 0.266 | 52567.7 |
523 | 2021-12-02 08:42:58 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
522 | 2021-11-22 21:42:33 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
521 | 2021-11-20 19:57:48 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
520 | 2021-10-06 13:55:13 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
519 | 2021-09-04 10:23:40 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
518 | 2021-09-02 03:51:58 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
517 | 2021-08-29 06:36:17 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
516 | 2021-08-17 20:09:16 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
515 | 2021-07-01 07:09:06 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
514 | 2021-05-28 13:15:29 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
513 | 2021-02-25 12:25:10 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
512 | 2020-11-25 13:16:45 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
511 | 2020-10-31 06:00:09 | opal | 1 | 13983 | 8 | 0.483 | 28950.3 |
510 | 2020-10-27 23:10:00 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
509 | 2020-10-27 02:14:07 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
508 | 2020-10-21 18:57:09 | opal | 2 | 29872 | 155 | 0.750 | 39829.3 |
507 | 2020-10-19 17:42:09 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
506 | 2020-10-02 00:45:44 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
505 | 2020-09-18 02:55:12 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
504 | 2020-08-26 11:13:01 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
503 | 2020-08-26 10:13:54 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
502 | 2020-08-24 01:27:58 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
501 | 2020-08-21 17:41:06 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
500 | 2020-08-10 14:19:35 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
499 | 2020-08-04 04:06:33 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
498 | 2020-07-27 06:35:06 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
497 | 2020-07-24 21:23:43 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
496 | 2020-05-22 00:24:09 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |
495 | 2020-05-18 20:59:15 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
494 | 2020-05-05 21:23:53 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
493 | 2020-03-29 18:02:35 | opal | 1 | 13983 | 8 | 0.263 | 53167.3 |
492 | 2020-03-25 23:45:17 | opal | 1 | 13983 | 8 | 0.216 | 64736.1 |
491 | 2020-03-24 03:40:06 | opal | 1 | 13983 | 8 | 0.233 | 60012.9 |
490 | 2020-03-22 15:53:35 | opal | 1 | 13983 | 8 | 0.236 | 59250.0 |
489 | 2020-03-21 09:35:31 | opal | 1 | 13983 | 8 | 0.250 | 55932.0 |
488 | 2020-03-18 13:55:07 | opal | 1 | 13983 | 8 | 0.220 | 63559.1 |