History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gwine"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
552 | 2024-04-27 07:57:17 | gwine | 1 | 28756 | 5 | 0.406 | 70827.6 |
551 | 2024-04-14 16:11:53 | gwine | 1 | 28756 | 5 | 0.610 | 47141.0 |
550 | 2024-04-10 09:06:36 | gwine | 2 | 53800 | 106 | 1.656 | 32487.9 |
549 | 2024-04-02 23:49:26 | gwine | 1 | 28756 | 5 | 1.486 | 19351.3 |
548 | 2024-03-31 02:52:26 | gwine | 1 | 28756 | 5 | 0.500 | 57512.0 |
547 | 2024-03-29 04:08:49 | gwine | 1 | 28756 | 5 | 1.280 | 22465.6 |
546 | 2024-03-29 02:32:42 | gwine | 1 | 28756 | 5 | 0.516 | 55728.7 |
545 | 2024-03-03 21:22:52 | gwine | 1 | 28756 | 5 | 0.516 | 55728.7 |
544 | 2024-02-27 22:43:03 | gwine | 2 | 53800 | 106 | 1.690 | 31834.3 |
543 | 2024-02-27 20:48:11 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
542 | 2024-01-28 20:41:57 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
541 | 2024-01-17 03:18:08 | gwine | 2 | 53800 | 106 | 1.390 | 38705.0 |
540 | 2023-12-19 12:33:12 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
539 | 2023-12-11 05:24:11 | gwine | 2 | 53800 | 106 | 1.610 | 33416.1 |
538 | 2023-11-29 12:36:30 | gwine | 2 | 53800 | 106 | 1.330 | 40451.1 |
537 | 2023-11-15 11:32:13 | gwine | 2 | 53800 | 106 | 1.313 | 40974.9 |
536 | 2023-11-11 23:30:48 | gwine | 2 | 53800 | 106 | 1.516 | 35488.1 |
535 | 2023-11-10 01:31:40 | gwine | 1 | 28756 | 5 | 0.466 | 61708.2 |
534 | 2023-11-08 16:16:16 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
533 | 2023-11-02 06:31:38 | gwine | 1 | 28756 | 5 | 0.453 | 63479.0 |
532 | 2023-10-21 09:15:19 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
531 | 2023-10-20 16:23:42 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
530 | 2023-10-18 07:17:42 | gwine | 1 | 28756 | 5 | 0.533 | 53951.2 |
529 | 2023-10-13 05:48:01 | gwine | 1 | 28756 | 5 | 0.550 | 52283.6 |
528 | 2023-10-06 20:38:41 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
527 | 2023-10-04 13:42:23 | gwine | 1 | 28756 | 5 | 0.486 | 59168.7 |
526 | 2023-09-26 11:43:19 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
525 | 2023-09-22 05:29:25 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
524 | 2023-09-11 01:41:20 | gwine | 2 | 53800 | 106 | 1.563 | 34421.0 |
523 | 2023-09-08 11:15:46 | gwine | 2 | 53800 | 106 | 1.343 | 40059.6 |
522 | 2023-08-02 18:29:51 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
521 | 2023-06-26 06:58:44 | gwine | 1 | 28756 | 5 | 0.470 | 61183.0 |
520 | 2023-05-26 01:26:58 | gwine | 2 | 53800 | 106 | 1.296 | 41512.3 |
519 | 2023-04-28 14:06:11 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
518 | 2023-03-07 01:45:24 | gwine | 2 | 53800 | 106 | 1.330 | 40451.1 |
517 | 2023-03-03 23:42:58 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
516 | 2023-02-22 01:06:37 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
515 | 2023-02-05 04:54:24 | gwine | 1 | 28756 | 5 | 0.486 | 59168.7 |
514 | 2023-02-03 18:45:18 | gwine | 2 | 53800 | 106 | 1.470 | 36598.6 |
513 | 2023-01-11 17:17:47 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
512 | 2023-01-06 16:56:46 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
511 | 2022-12-28 12:51:03 | gwine | 1 | 28756 | 5 | 0.403 | 71354.8 |
510 | 2022-12-24 12:32:48 | gwine | 2 | 53800 | 106 | 1.280 | 42031.3 |
509 | 2022-12-24 06:24:16 | gwine | 1 | 28756 | 5 | 0.470 | 61183.0 |
508 | 2022-12-19 20:50:45 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
507 | 2022-12-18 18:02:48 | gwine | 2 | 53800 | 106 | 2.580 | 20852.7 |
506 | 2022-12-18 11:12:37 | gwine | 1 | 28756 | 5 | 0.453 | 63479.0 |
505 | 2022-12-12 01:12:13 | gwine | 2 | 53800 | 106 | 1.546 | 34799.5 |
504 | 2022-12-04 16:17:34 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
503 | 2022-12-02 00:42:17 | gwine | 2 | 53800 | 106 | 1.343 | 40059.6 |
502 | 2022-11-27 03:41:13 | gwine | 1 | 28756 | 5 | 0.470 | 61183.0 |
501 | 2022-11-15 12:18:39 | gwine | 1 | 28756 | 5 | 0.546 | 52666.7 |
500 | 2022-11-11 14:34:01 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
499 | 2022-11-10 22:00:52 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
498 | 2022-11-09 14:48:20 | gwine | 1 | 28756 | 5 | 0.516 | 55728.7 |
497 | 2022-11-07 13:57:38 | gwine | 2 | 53800 | 106 | 1.780 | 30224.7 |
496 | 2022-11-01 04:24:43 | gwine | 2 | 53800 | 106 | 2.660 | 20225.6 |
495 | 2022-10-30 10:35:29 | gwine | 2 | 53800 | 106 | 1.500 | 35866.7 |
494 | 2022-10-24 02:48:01 | gwine | 2 | 53800 | 106 | 1.343 | 40059.6 |
493 | 2022-09-23 19:54:46 | gwine | 2 | 53800 | 106 | 1.313 | 40974.9 |
492 | 2022-09-12 17:38:21 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
491 | 2022-09-04 15:54:30 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
490 | 2022-08-31 05:00:06 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
489 | 2022-07-22 11:07:36 | gwine | 1 | 28756 | 5 | 0.500 | 57512.0 |
488 | 2022-07-02 08:13:23 | gwine | 2 | 53800 | 106 | 1.296 | 41512.3 |
487 | 2022-04-13 11:48:02 | gwine | 1 | 28756 | 5 | 0.436 | 65954.1 |
486 | 2022-04-11 05:44:47 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
485 | 2022-04-07 12:28:03 | gwine | 1 | 28756 | 5 | 0.546 | 52666.7 |
484 | 2022-02-13 14:36:11 | gwine | 2 | 53800 | 106 | 1.376 | 39098.8 |
483 | 2022-01-05 00:12:58 | gwine | 1 | 28756 | 5 | 0.500 | 57512.0 |
482 | 2021-12-23 12:44:13 | gwine | 1 | 28756 | 5 | 0.500 | 57512.0 |
481 | 2021-11-16 09:36:42 | gwine | 2 | 53800 | 106 | 1.360 | 39558.8 |
480 | 2021-11-08 19:58:31 | gwine | 1 | 28756 | 5 | 0.436 | 65954.1 |
479 | 2021-11-05 08:07:16 | gwine | 1 | 28756 | 5 | 0.500 | 57512.0 |
478 | 2021-09-27 00:30:06 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
477 | 2021-09-14 23:33:05 | gwine | 2 | 53800 | 106 | 1.596 | 33709.3 |
476 | 2021-09-13 02:33:08 | gwine | 1 | 28756 | 5 | 0.436 | 65954.1 |
475 | 2021-08-29 18:35:58 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
474 | 2021-08-14 12:55:02 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
473 | 2021-06-12 23:15:01 | gwine | 1 | 28756 | 5 | 0.453 | 63479.0 |
472 | 2021-05-29 12:51:25 | gwine | 1 | 28756 | 5 | 0.500 | 57512.0 |
471 | 2021-05-13 13:00:54 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
470 | 2021-03-13 13:17:21 | gwine | 1 | 28756 | 5 | 0.466 | 61708.2 |
469 | 2021-03-06 18:12:40 | gwine | 1 | 28756 | 5 | 0.453 | 63479.0 |
468 | 2021-02-23 08:19:33 | gwine | 1 | 28756 | 5 | 0.453 | 63479.0 |
467 | 2020-12-16 02:41:49 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
466 | 2020-12-10 12:03:20 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
465 | 2020-11-04 20:08:28 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
464 | 2020-10-30 06:54:27 | gwine | 1 | 28756 | 5 | 0.436 | 65954.1 |
463 | 2020-10-29 01:34:25 | gwine | 1 | 28756 | 5 | 0.470 | 61183.0 |
462 | 2020-10-26 01:01:26 | gwine | 2 | 53800 | 106 | 1.500 | 35866.7 |
461 | 2020-10-24 16:18:04 | gwine | 1 | 28756 | 5 | 0.440 | 65354.5 |
460 | 2020-10-14 12:14:20 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
459 | 2020-09-27 12:11:46 | gwine | 1 | 28756 | 5 | 0.423 | 67981.1 |
458 | 2020-09-10 13:05:23 | gwine | 1 | 28756 | 5 | 0.420 | 68466.7 |
457 | 2020-08-31 09:26:55 | gwine | 1 | 28756 | 5 | 0.546 | 52666.7 |
456 | 2020-08-19 18:47:33 | gwine | 1 | 28756 | 5 | 0.483 | 59536.2 |
455 | 2020-08-18 01:49:38 | gwine | 1 | 28756 | 5 | 0.440 | 65354.5 |
454 | 2020-07-30 09:57:58 | gwine | 1 | 28756 | 5 | 0.533 | 53951.2 |
453 | 2020-05-26 14:45:55 | gwine | 1 | 28756 | 5 | 0.470 | 61183.0 |