History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potions"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
578 | 2024-04-08 03:47:01 | potions | 1 | 69583 | 7 | 1.220 | 57035.2 |
577 | 2024-04-05 05:25:46 | potions | 1 | 69583 | 7 | 2.453 | 28366.5 |
576 | 2024-03-28 21:21:53 | potions | 1 | 69583 | 7 | 1.203 | 57841.2 |
575 | 2024-02-27 18:20:32 | potions | 1 | 69583 | 7 | 1.110 | 62687.4 |
574 | 2024-01-12 09:09:49 | potions | 3 | 134027 | 541 | 6.046 | 22167.9 |
573 | 2024-01-05 08:50:07 | potions | 2 | 107671 | 52 | 3.016 | 35699.9 |
572 | 2024-01-02 16:40:53 | potions | 3 | 134027 | 541 | 6.033 | 22215.6 |
571 | 2024-01-02 10:37:52 | potions | 1 | 69583 | 7 | 1.280 | 54361.7 |
570 | 2023-12-27 00:05:13 | potions | 1 | 69583 | 7 | 1.170 | 59472.6 |
569 | 2023-12-02 03:27:43 | potions | 1 | 69583 | 7 | 1.173 | 59320.5 |
568 | 2023-11-30 16:16:28 | potions | 3 | 134027 | 541 | 6.436 | 20824.6 |
567 | 2023-11-30 16:16:28 | potions | 2 | 107671 | 52 | 3.390 | 31761.4 |
566 | 2023-11-25 20:35:17 | potions | 3 | 134027 | 541 | 9.986 | 13421.5 |
565 | 2023-11-10 14:45:00 | potions | 1 | 69583 | 7 | 1.140 | 61037.7 |
564 | 2023-11-07 01:36:49 | potions | 1 | 69583 | 7 | 1.063 | 65459.1 |
563 | 2023-10-25 05:55:53 | potions | 1 | 69583 | 7 | 1.096 | 63488.1 |
562 | 2023-10-23 14:47:41 | potions | 3 | 134027 | 541 | 7.436 | 18024.1 |
561 | 2023-10-21 01:42:20 | potions | 3 | 134027 | 541 | 12.030 | 11141.1 |
560 | 2023-10-19 14:44:14 | potions | 3 | 134027 | 541 | 12.513 | 10711.0 |
559 | 2023-10-17 12:26:38 | potions | 1 | 69583 | 7 | 1.186 | 58670.3 |
558 | 2023-10-16 20:46:47 | potions | 1 | 69583 | 7 | 1.143 | 60877.5 |
557 | 2023-10-11 14:49:00 | potions | 2 | 107671 | 52 | 2.910 | 37000.3 |
556 | 2023-10-11 08:44:17 | potions | 1 | 69583 | 7 | 1.326 | 52475.9 |
555 | 2023-10-04 00:36:09 | potions | 3 | 134027 | 541 | 8.576 | 15628.1 |
554 | 2023-09-30 15:12:38 | potions | 3 | 134027 | 541 | 6.843 | 19586.0 |
553 | 2023-09-30 15:12:40 | potions | 2 | 107671 | 52 | 3.576 | 30109.3 |
552 | 2023-09-25 00:27:56 | potions | 1 | 69583 | 7 | 1.186 | 58670.3 |
551 | 2023-09-24 22:12:22 | potions | 1 | 69583 | 7 | 1.190 | 58473.1 |
550 | 2023-09-10 10:38:57 | potions | 1 | 69583 | 7 | 1.093 | 63662.4 |
549 | 2023-09-07 00:02:21 | potions | 1 | 69583 | 7 | 1.250 | 55666.4 |
548 | 2023-08-21 13:02:44 | potions | 3 | 134027 | 541 | 6.716 | 19956.4 |
547 | 2023-08-14 12:40:55 | potions | 1 | 69583 | 7 | 1.203 | 57841.2 |
546 | 2023-08-12 02:26:18 | potions | 3 | 134027 | 541 | 5.843 | 22938.0 |
545 | 2023-07-31 18:55:52 | potions | 3 | 134027 | 541 | 6.266 | 21389.6 |
544 | 2023-07-23 01:00:28 | potions | 2 | 107671 | 52 | 3.000 | 35890.3 |
543 | 2023-05-24 10:58:26 | potions | 1 | 69583 | 7 | 1.080 | 64428.7 |
542 | 2023-05-16 04:51:34 | potions | 1 | 69583 | 7 | 1.076 | 64668.2 |
541 | 2023-04-08 10:48:33 | potions | 3 | 134027 | 541 | 6.330 | 21173.3 |
540 | 2023-04-03 16:15:13 | potions | 2 | 107671 | 52 | 2.813 | 38276.2 |
539 | 2023-03-10 01:34:03 | potions | 1 | 69583 | 7 | 1.080 | 64428.7 |
538 | 2023-02-04 07:53:01 | potions | 1 | 69583 | 7 | 1.076 | 64668.2 |
537 | 2023-02-02 05:03:19 | potions | 1 | 69583 | 7 | 1.093 | 63662.4 |
536 | 2023-01-06 08:49:50 | potions | 3 | 134027 | 541 | 6.390 | 20974.5 |
535 | 2023-01-03 16:50:35 | potions | 2 | 107671 | 52 | 3.173 | 33933.5 |
534 | 2023-01-01 18:07:32 | potions | 1 | 69583 | 7 | 1.266 | 54962.9 |
533 | 2022-12-30 16:38:38 | potions | 2 | 107671 | 52 | 2.796 | 38508.9 |
532 | 2022-12-30 05:10:40 | potions | 3 | 134027 | 541 | 6.186 | 21666.2 |
531 | 2022-12-20 21:59:37 | potions | 3 | 134027 | 541 | 6.360 | 21073.4 |
530 | 2022-12-19 14:10:49 | potions | 3 | 134027 | 541 | 7.486 | 17903.7 |
529 | 2022-12-18 02:25:55 | potions | 3 | 134027 | 541 | 6.830 | 19623.3 |
528 | 2022-12-17 09:30:56 | potions | 1 | 69583 | 7 | 1.233 | 56433.9 |
527 | 2022-12-17 05:53:41 | potions | 3 | 134027 | 541 | 6.703 | 19995.1 |
526 | 2022-12-15 22:19:06 | potions | 3 | 134027 | 541 | 5.736 | 23365.9 |
525 | 2022-12-14 12:07:39 | potions | 3 | 134027 | 541 | 6.253 | 21434.0 |
524 | 2022-12-13 09:18:45 | potions | 3 | 134027 | 541 | 5.733 | 23378.2 |
523 | 2022-12-12 13:20:51 | potions | 3 | 134027 | 541 | 6.173 | 21711.8 |
522 | 2022-12-11 23:07:38 | potions | 3 | 134027 | 541 | 6.110 | 21935.7 |
521 | 2022-12-11 17:39:08 | potions | 3 | 134027 | 541 | 6.063 | 22105.7 |
520 | 2022-12-10 03:42:24 | potions | 3 | 134027 | 541 | 6.186 | 21666.2 |
519 | 2022-12-09 14:53:27 | potions | 3 | 134027 | 541 | 7.016 | 19103.1 |
518 | 2022-12-08 14:17:50 | potions | 3 | 134027 | 541 | 7.656 | 17506.1 |
517 | 2022-12-07 16:06:31 | potions | 3 | 134027 | 541 | 6.640 | 20184.8 |
516 | 2022-12-05 18:52:56 | potions | 3 | 134027 | 541 | 16.300 | 8222.5 |
515 | 2022-12-05 04:15:27 | potions | 3 | 134027 | 541 | 6.970 | 19229.1 |
514 | 2022-12-04 03:16:13 | potions | 3 | 134027 | 541 | 6.953 | 19276.1 |
513 | 2022-12-03 23:33:01 | potions | 3 | 134027 | 541 | 5.763 | 23256.5 |
512 | 2022-12-03 16:15:21 | potions | 1 | 69583 | 7 | 1.063 | 65459.1 |
511 | 2022-12-03 10:35:33 | potions | 3 | 134027 | 541 | 16.093 | 8328.3 |
510 | 2022-12-01 13:10:15 | potions | 3 | 134027 | 541 | 11.313 | 11847.2 |
509 | 2022-11-30 09:47:29 | potions | 3 | 134027 | 541 | 6.546 | 20474.6 |
508 | 2022-11-29 07:58:32 | potions | 3 | 134027 | 541 | 12.953 | 10347.2 |
507 | 2022-11-27 17:57:08 | potions | 3 | 134027 | 541 | 7.846 | 17082.2 |
506 | 2022-11-26 15:59:19 | potions | 3 | 134027 | 541 | 9.110 | 14712.1 |
505 | 2022-11-19 20:55:26 | potions | 1 | 69583 | 7 | 1.156 | 60192.9 |
504 | 2022-11-14 09:52:52 | potions | 3 | 134027 | 541 | 6.156 | 21771.8 |
503 | 2022-11-07 01:51:56 | potions | 1 | 69583 | 7 | 1.170 | 59472.6 |
502 | 2022-11-07 00:27:19 | potions | 1 | 69583 | 7 | 1.220 | 57035.2 |
501 | 2022-11-05 12:52:06 | potions | 3 | 134027 | 541 | 6.076 | 22058.4 |
500 | 2022-11-05 03:48:30 | potions | 1 | 69583 | 7 | 1.203 | 57841.2 |
499 | 2022-10-25 13:12:05 | potions | 3 | 134027 | 541 | 9.623 | 13927.8 |
498 | 2022-10-14 04:12:12 | potions | 1 | 69583 | 7 | 1.060 | 65644.3 |
497 | 2022-09-25 00:57:50 | potions | 1 | 69583 | 7 | 1.076 | 64668.2 |
496 | 2022-09-21 18:20:09 | potions | 3 | 134027 | 541 | 5.813 | 23056.4 |
495 | 2022-09-11 16:40:05 | potions | 3 | 134027 | 541 | 6.500 | 20619.5 |
494 | 2022-09-01 03:23:47 | potions | 2 | 107671 | 52 | 2.860 | 37647.2 |
493 | 2022-06-27 15:52:19 | potions | 1 | 69583 | 7 | 1.093 | 63662.4 |
492 | 2022-05-06 06:01:18 | potions | 1 | 69583 | 7 | 1.123 | 61961.7 |
491 | 2022-03-11 04:32:06 | potions | 1 | 69583 | 7 | 1.220 | 57035.2 |
490 | 2022-03-01 19:59:44 | potions | 1 | 69583 | 7 | 1.390 | 50059.7 |
489 | 2022-03-01 07:09:36 | potions | 1 | 69583 | 7 | 1.156 | 60192.9 |
488 | 2022-02-28 12:28:47 | potions | 1 | 69583 | 7 | 1.296 | 53690.6 |
487 | 2022-02-27 18:58:26 | potions | 1 | 69583 | 7 | 2.483 | 28023.8 |
486 | 2022-02-27 07:31:19 | potions | 1 | 69583 | 7 | 1.186 | 58670.3 |
485 | 2022-02-26 14:10:58 | potions | 1 | 69583 | 7 | 1.076 | 64668.2 |
484 | 2022-02-25 14:44:30 | potions | 1 | 69583 | 7 | 1.326 | 52475.9 |
483 | 2022-02-13 00:00:32 | potions | 1 | 69583 | 7 | 1.173 | 59320.5 |
482 | 2022-02-12 12:59:39 | potions | 1 | 69583 | 7 | 1.110 | 62687.4 |
481 | 2022-02-11 21:38:27 | potions | 1 | 69583 | 7 | 1.173 | 59320.5 |
480 | 2022-02-11 07:50:56 | potions | 1 | 69583 | 7 | 2.623 | 26528.0 |
479 | 2022-01-29 14:03:08 | potions | 1 | 69583 | 7 | 1.220 | 57035.2 |