History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prods"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
555 | 2024-04-19 19:55:40 | prods | 1 | 28756 | 14 | 0.563 | 51076.4 |
554 | 2024-04-02 22:16:53 | prods | 2 | 53800 | 198 | 3.873 | 13891.0 |
553 | 2024-04-02 21:45:14 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
552 | 2024-03-31 01:16:56 | prods | 1 | 28756 | 14 | 2.263 | 12707.0 |
551 | 2024-03-16 16:39:33 | prods | 1 | 28756 | 14 | 1.720 | 16718.6 |
550 | 2024-03-11 04:08:28 | prods | 1 | 28756 | 14 | 0.530 | 54256.6 |
549 | 2024-02-25 18:32:18 | prods | 1 | 28756 | 14 | 1.030 | 27918.4 |
548 | 2024-02-20 16:58:25 | prods | 1 | 28756 | 14 | 0.533 | 53951.2 |
547 | 2024-02-11 23:35:50 | prods | 1 | 28756 | 14 | 1.703 | 16885.5 |
546 | 2024-01-28 23:39:39 | prods | 1 | 28756 | 14 | 0.516 | 55728.7 |
545 | 2024-01-26 00:45:21 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
544 | 2024-01-20 00:56:11 | prods | 2 | 53800 | 198 | 1.423 | 37807.4 |
543 | 2024-01-03 16:46:49 | prods | 2 | 53800 | 198 | 1.580 | 34050.6 |
542 | 2023-12-04 19:56:31 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
541 | 2023-11-25 09:42:44 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
540 | 2023-11-25 06:38:47 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
539 | 2023-11-21 12:11:14 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
538 | 2023-11-13 23:17:14 | prods | 1 | 28756 | 14 | 0.796 | 36125.6 |
537 | 2023-11-04 10:44:32 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
536 | 2023-10-29 16:42:52 | prods | 2 | 53800 | 198 | 1.470 | 36598.6 |
535 | 2023-10-28 18:12:27 | prods | 2 | 53800 | 198 | 2.470 | 21781.4 |
534 | 2023-10-27 08:12:31 | prods | 1 | 28756 | 14 | 0.470 | 61183.0 |
533 | 2023-10-25 16:40:30 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
532 | 2023-10-25 13:29:51 | prods | 2 | 53800 | 198 | 2.080 | 25865.4 |
531 | 2023-10-21 00:45:44 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
530 | 2023-10-18 07:30:12 | prods | 2 | 53800 | 198 | 1.393 | 38621.7 |
529 | 2023-10-16 19:17:35 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
528 | 2023-10-13 10:50:29 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
527 | 2023-10-06 08:02:59 | prods | 1 | 28756 | 14 | 0.513 | 56054.6 |
526 | 2023-09-29 04:47:07 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
525 | 2023-09-18 21:39:46 | prods | 1 | 28756 | 14 | 0.530 | 54256.6 |
524 | 2023-09-12 05:16:43 | prods | 1 | 28756 | 14 | 0.796 | 36125.6 |
523 | 2023-08-16 16:14:23 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
522 | 2023-08-07 00:29:11 | prods | 2 | 53800 | 198 | 1.406 | 38264.6 |
521 | 2023-07-12 13:32:11 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
520 | 2023-07-05 04:53:15 | prods | 1 | 28756 | 14 | 1.000 | 28756.0 |
519 | 2023-05-18 05:05:55 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
518 | 2023-05-08 16:49:11 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
517 | 2023-04-16 20:45:36 | prods | 2 | 53800 | 198 | 1.343 | 40059.6 |
516 | 2023-04-12 09:20:37 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
515 | 2023-03-21 17:25:09 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
514 | 2023-03-20 22:56:25 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
513 | 2023-02-03 05:46:12 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
512 | 2023-01-22 07:56:14 | prods | 2 | 53800 | 198 | 1.390 | 38705.0 |
511 | 2022-12-03 14:29:48 | prods | 1 | 28756 | 14 | 0.486 | 59168.7 |
510 | 2022-12-02 10:57:20 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
509 | 2022-11-02 05:50:07 | prods | 2 | 53800 | 198 | 1.343 | 40059.6 |
508 | 2022-08-03 08:28:59 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
507 | 2022-07-28 08:23:42 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
506 | 2022-05-27 11:08:33 | prods | 2 | 53800 | 198 | 1.373 | 39184.3 |
505 | 2022-05-16 04:12:06 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
504 | 2022-05-11 14:49:28 | prods | 2 | 53800 | 198 | 1.826 | 29463.3 |
503 | 2022-04-08 20:16:19 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
502 | 2022-03-25 03:10:33 | prods | 1 | 28756 | 14 | 0.576 | 49923.6 |
501 | 2022-03-23 01:19:34 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
500 | 2021-12-26 18:21:45 | prods | 1 | 28756 | 14 | 0.533 | 53951.2 |
499 | 2021-12-24 16:28:05 | prods | 1 | 28756 | 14 | 0.516 | 55728.7 |
498 | 2021-12-21 12:54:47 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
497 | 2021-11-02 14:39:25 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
496 | 2021-10-31 13:23:49 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
495 | 2021-09-22 02:48:09 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
494 | 2021-09-17 13:19:12 | prods | 1 | 28756 | 14 | 0.486 | 59168.7 |
493 | 2021-08-22 13:45:07 | prods | 1 | 28756 | 14 | 0.440 | 65354.5 |
492 | 2021-08-20 09:57:51 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
491 | 2021-07-27 11:31:11 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
490 | 2021-06-17 16:14:41 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
489 | 2021-05-18 08:46:57 | prods | 1 | 28756 | 14 | 0.986 | 29164.3 |
488 | 2021-04-18 08:35:46 | prods | 1 | 28756 | 14 | 0.546 | 52666.7 |
487 | 2021-03-21 04:26:09 | prods | 1 | 28756 | 14 | 0.516 | 55728.7 |
486 | 2021-03-18 09:08:14 | prods | 1 | 28756 | 14 | 0.516 | 55728.7 |
485 | 2021-02-02 15:42:15 | prods | 1 | 28756 | 14 | 0.466 | 61708.2 |
484 | 2021-01-30 20:28:25 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
483 | 2021-01-02 19:20:33 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
482 | 2020-12-15 10:04:45 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
481 | 2020-10-31 19:30:07 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
480 | 2020-10-17 19:49:35 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
479 | 2020-09-27 19:58:28 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
478 | 2020-09-16 18:36:10 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
477 | 2020-09-15 03:37:05 | prods | 1 | 28756 | 14 | 0.483 | 59536.2 |
476 | 2020-09-02 20:39:26 | prods | 1 | 28756 | 14 | 0.533 | 53951.2 |
475 | 2020-08-24 00:12:02 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
474 | 2020-07-17 16:37:54 | prods | 1 | 28756 | 14 | 0.470 | 61183.0 |
473 | 2020-06-10 21:03:02 | prods | 1 | 28756 | 14 | 0.486 | 59168.7 |
472 | 2020-06-03 00:39:19 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
471 | 2020-05-30 22:20:04 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
470 | 2020-05-28 07:37:46 | prods | 1 | 28756 | 14 | 0.436 | 65954.1 |
469 | 2020-03-25 15:20:58 | prods | 1 | 28756 | 14 | 0.513 | 56054.6 |
468 | 2020-03-25 12:56:39 | prods | 1 | 28756 | 14 | 0.533 | 53951.2 |
467 | 2020-03-22 07:04:01 | prods | 1 | 28756 | 14 | 1.093 | 26309.2 |
466 | 2020-03-22 06:43:16 | prods | 1 | 28756 | 14 | 0.890 | 32310.1 |
465 | 2020-03-21 07:01:12 | prods | 1 | 28756 | 14 | 1.063 | 27051.7 |
464 | 2020-03-18 07:01:09 | prods | 1 | 28756 | 14 | 0.440 | 65354.5 |
463 | 2020-03-14 23:30:14 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
462 | 2020-02-24 21:37:56 | prods | 1 | 28756 | 14 | 0.453 | 63479.0 |
461 | 2020-02-24 12:39:14 | prods | 1 | 28756 | 14 | 0.500 | 57512.0 |
460 | 2020-02-14 14:30:29 | prods | 1 | 28756 | 14 | 0.703 | 40904.7 |
459 | 2020-02-14 00:55:59 | prods | 1 | 28756 | 14 | 0.513 | 56054.6 |
458 | 2020-02-10 05:06:14 | prods | 1 | 28756 | 14 | 0.516 | 55728.7 |
457 | 2020-02-09 16:54:19 | prods | 1 | 28756 | 14 | 0.546 | 52666.7 |
456 | 2020-01-31 11:38:06 | prods | 1 | 28756 | 14 | 1.123 | 25606.4 |