History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spill"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
537 | 2024-04-25 05:03:48 | spill | 2 | 53800 | 143 | 6.123 | 8786.5 |
536 | 2024-04-25 05:03:25 | spill | 1 | 28756 | 13 | 1.780 | 16155.1 |
535 | 2024-04-03 00:48:12 | spill | 1 | 28756 | 13 | 0.966 | 29768.1 |
534 | 2024-03-28 18:54:57 | spill | 2 | 53800 | 143 | 3.986 | 13497.2 |
533 | 2024-03-28 18:12:10 | spill | 1 | 28756 | 13 | 0.920 | 31256.5 |
532 | 2024-03-26 09:19:35 | spill | 1 | 28756 | 13 | 1.673 | 17188.3 |
531 | 2024-03-22 07:25:41 | spill | 2 | 53800 | 143 | 3.533 | 15227.9 |
530 | 2024-03-22 07:25:37 | spill | 1 | 28756 | 13 | 0.563 | 51076.4 |
529 | 2024-03-03 21:20:59 | spill | 1 | 28756 | 13 | 0.563 | 51076.4 |
528 | 2024-03-01 16:33:00 | spill | 1 | 28756 | 13 | 0.533 | 53951.2 |
527 | 2024-03-01 10:40:00 | spill | 1 | 28756 | 13 | 0.563 | 51076.4 |
526 | 2024-02-26 08:43:34 | spill | 1 | 28756 | 13 | 0.593 | 48492.4 |
525 | 2024-02-23 20:39:58 | spill | 2 | 53800 | 143 | 1.420 | 37887.3 |
524 | 2024-02-23 19:45:41 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
523 | 2024-02-20 06:46:34 | spill | 2 | 53800 | 143 | 1.763 | 30516.2 |
522 | 2024-02-19 20:26:18 | spill | 1 | 28756 | 13 | 0.546 | 52666.7 |
521 | 2024-02-03 03:44:39 | spill | 1 | 28756 | 13 | 0.513 | 56054.6 |
520 | 2024-01-27 06:41:05 | spill | 1 | 28756 | 13 | 0.483 | 59536.2 |
519 | 2024-01-26 13:14:54 | spill | 1 | 28756 | 13 | 1.063 | 27051.7 |
518 | 2024-01-24 17:09:23 | spill | 1 | 28756 | 13 | 1.080 | 26625.9 |
517 | 2024-01-20 09:39:04 | spill | 1 | 28756 | 13 | 0.440 | 65354.5 |
516 | 2024-01-08 23:13:40 | spill | 2 | 53800 | 143 | 1.610 | 33416.1 |
515 | 2023-12-28 11:17:05 | spill | 2 | 53800 | 143 | 1.390 | 38705.0 |
514 | 2023-12-17 11:19:53 | spill | 2 | 53800 | 143 | 1.453 | 37026.8 |
513 | 2023-12-06 21:24:27 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
512 | 2023-11-18 12:57:13 | spill | 1 | 28756 | 13 | 1.106 | 26000.0 |
511 | 2023-11-14 20:21:16 | spill | 1 | 28756 | 13 | 0.450 | 63902.2 |
510 | 2023-11-02 09:00:56 | spill | 2 | 53800 | 143 | 1.656 | 32487.9 |
509 | 2023-10-31 06:52:01 | spill | 2 | 53800 | 143 | 3.153 | 17063.1 |
508 | 2023-10-29 06:42:24 | spill | 1 | 28756 | 13 | 0.483 | 59536.2 |
507 | 2023-10-21 10:11:19 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
506 | 2023-10-20 20:10:36 | spill | 1 | 28756 | 13 | 0.486 | 59168.7 |
505 | 2023-10-13 04:57:13 | spill | 1 | 28756 | 13 | 0.486 | 59168.7 |
504 | 2023-10-08 19:57:45 | spill | 1 | 28756 | 13 | 0.483 | 59536.2 |
503 | 2023-10-04 11:20:24 | spill | 2 | 53800 | 143 | 1.780 | 30224.7 |
502 | 2023-10-01 01:09:12 | spill | 2 | 53800 | 143 | 1.440 | 37361.1 |
501 | 2023-09-26 09:32:43 | spill | 1 | 28756 | 13 | 0.470 | 61183.0 |
500 | 2023-09-22 09:12:52 | spill | 1 | 28756 | 13 | 0.470 | 61183.0 |
499 | 2023-09-20 07:11:34 | spill | 1 | 28756 | 13 | 0.516 | 55728.7 |
498 | 2023-07-29 05:34:26 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
497 | 2023-07-11 05:56:45 | spill | 2 | 53800 | 143 | 1.360 | 39558.8 |
496 | 2023-07-10 09:12:31 | spill | 1 | 28756 | 13 | 0.436 | 65954.1 |
495 | 2023-04-13 08:56:43 | spill | 1 | 28756 | 13 | 0.483 | 59536.2 |
494 | 2023-04-02 12:47:18 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
493 | 2023-03-29 05:03:47 | spill | 2 | 53800 | 143 | 1.513 | 35558.5 |
492 | 2023-02-04 02:31:49 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
491 | 2023-01-30 12:24:55 | spill | 2 | 53800 | 143 | 1.376 | 39098.8 |
490 | 2023-01-17 08:31:09 | spill | 2 | 53800 | 143 | 1.623 | 33148.5 |
489 | 2023-01-17 08:14:28 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
488 | 2022-12-25 00:39:05 | spill | 2 | 53800 | 143 | 1.343 | 40059.6 |
487 | 2022-12-15 19:53:36 | spill | 2 | 53800 | 143 | 1.376 | 39098.8 |
486 | 2022-12-11 04:02:02 | spill | 1 | 28756 | 13 | 0.420 | 68466.7 |
485 | 2022-12-07 20:24:04 | spill | 1 | 28756 | 13 | 0.483 | 59536.2 |
484 | 2022-12-01 19:22:56 | spill | 1 | 28756 | 13 | 0.436 | 65954.1 |
483 | 2022-11-16 01:55:07 | spill | 2 | 53800 | 143 | 1.626 | 33087.3 |
482 | 2022-11-14 15:26:09 | spill | 2 | 53800 | 143 | 1.673 | 32157.8 |
481 | 2022-10-30 10:55:17 | spill | 2 | 53800 | 143 | 1.640 | 32804.9 |
480 | 2022-10-29 08:03:30 | spill | 2 | 53800 | 143 | 1.343 | 40059.6 |
479 | 2022-09-29 18:40:25 | spill | 2 | 53800 | 143 | 1.593 | 33772.8 |
478 | 2022-08-25 21:00:55 | spill | 2 | 53800 | 143 | 1.390 | 38705.0 |
477 | 2022-08-04 08:44:45 | spill | 1 | 28756 | 13 | 0.516 | 55728.7 |
476 | 2022-07-31 22:11:06 | spill | 1 | 28756 | 13 | 0.436 | 65954.1 |
475 | 2022-07-29 09:11:37 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
474 | 2022-07-27 10:26:34 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
473 | 2022-07-25 03:04:47 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
472 | 2022-07-19 07:24:35 | spill | 2 | 53800 | 143 | 1.410 | 38156.0 |
471 | 2022-06-09 22:44:39 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
470 | 2022-04-24 22:52:33 | spill | 1 | 28756 | 13 | 0.456 | 63061.4 |
469 | 2022-03-23 15:35:38 | spill | 1 | 28756 | 13 | 0.466 | 61708.2 |
468 | 2022-03-23 03:35:26 | spill | 2 | 53800 | 143 | 1.703 | 31591.3 |
467 | 2022-03-17 21:17:39 | spill | 1 | 28756 | 13 | 0.470 | 61183.0 |
466 | 2022-03-15 16:29:20 | spill | 1 | 28756 | 13 | 0.660 | 43569.7 |
465 | 2022-01-13 05:29:08 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
464 | 2022-01-12 09:28:12 | spill | 1 | 28756 | 13 | 0.440 | 65354.5 |
463 | 2022-01-11 21:11:23 | spill | 1 | 28756 | 13 | 0.546 | 52666.7 |
462 | 2022-01-11 03:47:02 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
461 | 2022-01-10 14:51:24 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
460 | 2022-01-10 00:20:07 | spill | 1 | 28756 | 13 | 0.533 | 53951.2 |
459 | 2022-01-09 13:08:11 | spill | 1 | 28756 | 13 | 0.546 | 52666.7 |
458 | 2022-01-06 05:48:40 | spill | 1 | 28756 | 13 | 0.546 | 52666.7 |
457 | 2022-01-05 16:25:57 | spill | 1 | 28756 | 13 | 0.466 | 61708.2 |
456 | 2022-01-05 07:42:31 | spill | 1 | 28756 | 13 | 0.530 | 54256.6 |
455 | 2022-01-04 17:00:04 | spill | 1 | 28756 | 13 | 0.563 | 51076.4 |
454 | 2021-12-25 23:27:12 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
453 | 2021-12-14 05:48:46 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
452 | 2021-12-13 20:28:41 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
451 | 2021-12-13 09:37:07 | spill | 1 | 28756 | 13 | 0.453 | 63479.0 |
450 | 2021-12-12 17:37:53 | spill | 1 | 28756 | 13 | 0.466 | 61708.2 |
449 | 2021-12-12 07:32:04 | spill | 1 | 28756 | 13 | 0.936 | 30722.2 |
448 | 2021-12-10 15:04:17 | spill | 1 | 28756 | 13 | 0.483 | 59536.2 |
447 | 2021-11-29 14:24:36 | spill | 1 | 28756 | 13 | 0.513 | 56054.6 |
446 | 2021-11-24 16:02:23 | spill | 1 | 28756 | 13 | 0.440 | 65354.5 |
445 | 2021-11-24 04:02:35 | spill | 1 | 28756 | 13 | 0.530 | 54256.6 |
444 | 2021-11-23 11:06:26 | spill | 1 | 28756 | 13 | 0.516 | 55728.7 |
443 | 2021-11-23 00:10:46 | spill | 1 | 28756 | 13 | 0.563 | 51076.4 |
442 | 2021-11-10 11:25:36 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
441 | 2021-11-08 18:22:22 | spill | 1 | 28756 | 13 | 0.516 | 55728.7 |
440 | 2021-10-30 19:00:48 | spill | 1 | 28756 | 13 | 0.500 | 57512.0 |
439 | 2021-10-29 17:40:05 | spill | 1 | 28756 | 13 | 0.456 | 63061.4 |
438 | 2021-10-29 00:05:50 | spill | 1 | 28756 | 13 | 0.516 | 55728.7 |