History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"collars"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
549 | 2024-03-07 06:19:53 | collars | 1 | 69583 | 6 | 1.360 | 51164.0 |
548 | 2024-02-28 10:22:24 | collars | 1 | 69583 | 6 | 3.653 | 19048.2 |
547 | 2024-01-09 02:42:15 | collars | 1 | 69583 | 6 | 1.126 | 61796.6 |
546 | 2023-12-25 07:24:34 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
545 | 2023-12-11 08:23:30 | collars | 1 | 69583 | 6 | 1.390 | 50059.7 |
544 | 2023-11-27 19:45:29 | collars | 1 | 69583 | 6 | 1.250 | 55666.4 |
543 | 2023-11-21 11:14:12 | collars | 2 | 107671 | 62 | 3.360 | 32044.9 |
542 | 2023-11-21 11:14:07 | collars | 3 | 134027 | 527 | 6.406 | 20922.1 |
541 | 2023-11-09 12:14:35 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
540 | 2023-11-01 18:47:51 | collars | 1 | 69583 | 6 | 1.280 | 54361.7 |
539 | 2023-10-27 11:08:12 | collars | 1 | 69583 | 6 | 1.216 | 57222.9 |
538 | 2023-10-11 22:30:09 | collars | 1 | 69583 | 6 | 1.203 | 57841.2 |
537 | 2023-09-28 02:31:50 | collars | 1 | 69583 | 6 | 1.253 | 55533.1 |
536 | 2023-09-24 23:36:51 | collars | 1 | 69583 | 6 | 1.110 | 62687.4 |
535 | 2023-09-23 01:45:37 | collars | 1 | 69583 | 6 | 1.080 | 64428.7 |
534 | 2023-09-22 05:34:30 | collars | 1 | 69583 | 6 | 1.076 | 64668.2 |
533 | 2023-07-16 19:39:10 | collars | 1 | 69583 | 6 | 1.453 | 47889.2 |
532 | 2023-06-15 19:26:08 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
531 | 2023-03-13 10:31:48 | collars | 1 | 69583 | 6 | 1.110 | 62687.4 |
530 | 2022-12-08 10:55:12 | collars | 1 | 69583 | 6 | 1.296 | 53690.6 |
529 | 2022-09-19 17:54:44 | collars | 1 | 69583 | 6 | 1.186 | 58670.3 |
528 | 2022-09-11 17:08:10 | collars | 1 | 69583 | 6 | 1.063 | 65459.1 |
527 | 2022-08-31 18:33:30 | collars | 1 | 69583 | 6 | 1.250 | 55666.4 |
526 | 2022-07-30 08:14:15 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
525 | 2022-07-18 17:57:37 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
524 | 2022-06-25 09:45:24 | collars | 1 | 69583 | 6 | 1.096 | 63488.1 |
523 | 2022-06-24 21:55:13 | collars | 1 | 69583 | 6 | 1.216 | 57222.9 |
522 | 2022-06-08 19:43:01 | collars | 1 | 69583 | 6 | 1.076 | 64668.2 |
521 | 2022-05-26 03:56:47 | collars | 1 | 69583 | 6 | 1.080 | 64428.7 |
520 | 2022-05-25 19:41:05 | collars | 1 | 69583 | 6 | 1.200 | 57985.8 |
519 | 2022-04-30 01:25:24 | collars | 1 | 69583 | 6 | 1.110 | 62687.4 |
518 | 2022-04-27 20:09:57 | collars | 1 | 69583 | 6 | 1.686 | 41271.1 |
517 | 2022-02-18 03:48:45 | collars | 1 | 69583 | 6 | 1.233 | 56433.9 |
516 | 2022-01-14 18:57:12 | collars | 1 | 69583 | 6 | 1.220 | 57035.2 |
515 | 2021-11-27 06:47:16 | collars | 1 | 69583 | 6 | 1.156 | 60192.9 |
514 | 2021-11-25 03:38:24 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
513 | 2021-11-13 11:18:59 | collars | 1 | 69583 | 6 | 2.690 | 25867.3 |
512 | 2021-09-21 21:47:23 | collars | 1 | 69583 | 6 | 1.283 | 54234.6 |
511 | 2021-08-20 04:24:52 | collars | 1 | 69583 | 6 | 1.186 | 58670.3 |
510 | 2021-08-18 00:11:45 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
509 | 2021-08-13 21:38:22 | collars | 1 | 69583 | 6 | 2.266 | 30707.4 |
508 | 2021-08-03 07:46:57 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
507 | 2021-07-28 18:07:44 | collars | 1 | 69583 | 6 | 2.173 | 32021.6 |
506 | 2021-07-16 15:03:37 | collars | 2 | 107671 | 62 | 2.876 | 37437.8 |
505 | 2021-05-20 07:07:56 | collars | 1 | 69583 | 6 | 1.343 | 51811.6 |
504 | 2021-05-13 04:14:34 | collars | 1 | 69583 | 6 | 1.106 | 62914.1 |
503 | 2021-05-05 21:18:04 | collars | 2 | 107671 | 62 | 3.346 | 32179.0 |
502 | 2021-04-15 09:25:59 | collars | 1 | 69583 | 6 | 1.406 | 49490.0 |
501 | 2021-04-04 00:30:02 | collars | 2 | 107671 | 62 | 3.063 | 35152.1 |
500 | 2021-04-01 23:33:15 | collars | 3 | 134027 | 527 | 6.330 | 21173.3 |
499 | 2021-02-24 23:43:18 | collars | 2 | 107671 | 62 | 3.016 | 35699.9 |
498 | 2021-02-24 19:23:04 | collars | 2 | 107671 | 62 | 3.220 | 33438.2 |
497 | 2021-02-23 07:02:51 | collars | 2 | 107671 | 62 | 4.033 | 26697.5 |
496 | 2021-02-21 18:06:53 | collars | 2 | 107671 | 62 | 3.810 | 28260.1 |
495 | 2021-02-09 11:24:58 | collars | 1 | 69583 | 6 | 1.220 | 57035.2 |
494 | 2021-02-01 15:31:35 | collars | 1 | 69583 | 6 | 1.126 | 61796.6 |
493 | 2021-01-23 11:14:59 | collars | 2 | 107671 | 62 | 2.860 | 37647.2 |
492 | 2021-01-22 04:38:56 | collars | 2 | 107671 | 62 | 3.376 | 31893.1 |
491 | 2021-01-20 23:45:10 | collars | 2 | 107671 | 62 | 3.013 | 35735.5 |
490 | 2021-01-19 03:19:27 | collars | 2 | 107671 | 62 | 2.970 | 36252.9 |
489 | 2021-01-17 00:57:24 | collars | 3 | 134027 | 527 | 5.876 | 22809.2 |
488 | 2021-01-05 05:19:01 | collars | 1 | 69583 | 6 | 1.123 | 61961.7 |
487 | 2020-11-27 00:27:10 | collars | 2 | 107671 | 62 | 3.250 | 33129.5 |
486 | 2020-11-22 09:03:58 | collars | 3 | 134027 | 527 | 6.220 | 21547.7 |
485 | 2020-11-18 17:59:13 | collars | 1 | 69583 | 6 | 1.093 | 63662.4 |
484 | 2020-11-17 13:14:29 | collars | 3 | 134027 | 527 | 6.393 | 20964.6 |
483 | 2020-11-07 17:54:25 | collars | 1 | 69583 | 6 | 1.250 | 55666.4 |
482 | 2020-11-02 12:55:24 | collars | 2 | 107671 | 62 | 3.923 | 27446.1 |
481 | 2020-10-31 13:00:44 | collars | 2 | 107671 | 62 | 3.046 | 35348.3 |
480 | 2020-10-23 04:44:45 | collars | 1 | 69583 | 6 | 1.080 | 64428.7 |
479 | 2020-10-17 00:24:53 | collars | 1 | 69583 | 6 | 1.123 | 61961.7 |
478 | 2020-10-12 03:51:39 | collars | 3 | 134027 | 527 | 5.876 | 22809.2 |
477 | 2020-09-30 12:27:48 | collars | 1 | 69583 | 6 | 2.156 | 32274.1 |
476 | 2020-09-25 20:23:50 | collars | 1 | 69583 | 6 | 1.110 | 62687.4 |
475 | 2020-09-09 13:46:33 | collars | 2 | 107671 | 62 | 2.940 | 36622.8 |
474 | 2020-09-07 01:30:27 | collars | 1 | 69583 | 6 | 1.123 | 61961.7 |
473 | 2020-08-23 14:04:00 | collars | 1 | 69583 | 6 | 1.110 | 62687.4 |
472 | 2020-08-21 17:43:55 | collars | 1 | 69583 | 6 | 1.203 | 57841.2 |
471 | 2020-08-02 22:39:39 | collars | 1 | 69583 | 6 | 1.140 | 61037.7 |
470 | 2020-07-23 06:04:34 | collars | 1 | 69583 | 6 | 1.140 | 61037.7 |
469 | 2020-06-20 00:41:01 | collars | 1 | 69583 | 6 | 1.156 | 60192.9 |
468 | 2020-06-16 17:10:59 | collars | 1 | 69583 | 6 | 1.140 | 61037.7 |
467 | 2020-06-14 08:08:24 | collars | 1 | 69583 | 6 | 2.576 | 27012.0 |
466 | 2020-06-13 08:09:30 | collars | 1 | 69583 | 6 | 1.110 | 62687.4 |
465 | 2020-05-04 15:33:09 | collars | 1 | 69583 | 6 | 1.123 | 61961.7 |
464 | 2020-03-27 18:32:59 | collars | 1 | 69583 | 6 | 1.546 | 45008.4 |
463 | 2020-03-25 13:22:54 | collars | 1 | 69583 | 6 | 2.486 | 27989.9 |
462 | 2020-03-24 14:19:44 | collars | 1 | 69583 | 6 | 2.843 | 24475.2 |
461 | 2020-03-23 17:57:27 | collars | 1 | 69583 | 6 | 1.313 | 52995.4 |
460 | 2020-03-22 15:37:22 | collars | 1 | 69583 | 6 | 1.216 | 57222.9 |
459 | 2020-03-21 14:24:23 | collars | 1 | 69583 | 6 | 1.310 | 53116.8 |
458 | 2020-03-20 00:56:34 | collars | 1 | 69583 | 6 | 1.203 | 57841.2 |
457 | 2020-02-28 16:39:16 | collars | 1 | 69583 | 6 | 2.690 | 25867.3 |
456 | 2020-02-27 02:26:58 | collars | 1 | 69583 | 6 | 1.343 | 51811.6 |
455 | 2020-02-26 23:55:48 | collars | 1 | 69583 | 6 | 1.310 | 53116.8 |
454 | 2020-02-24 20:35:53 | collars | 1 | 69583 | 6 | 1.313 | 52995.4 |
453 | 2020-02-20 13:45:00 | collars | 1 | 69583 | 6 | 1.373 | 50679.5 |
452 | 2020-02-11 03:20:24 | collars | 1 | 69583 | 6 | 1.266 | 54962.9 |
451 | 2020-02-09 02:22:24 | collars | 1 | 69583 | 6 | 1.096 | 63488.1 |
450 | 2020-02-02 20:29:27 | collars | 1 | 69583 | 6 | 1.810 | 38443.6 |