History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spree"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
536 | 2024-04-24 16:07:12 | spree | 1 | 28756 | 7 | 1.123 | 25606.4 |
535 | 2024-04-03 04:52:30 | spree | 1 | 28756 | 7 | 1.063 | 27051.7 |
534 | 2024-03-31 14:35:50 | spree | 2 | 53800 | 136 | 3.563 | 15099.6 |
533 | 2024-03-31 14:35:45 | spree | 1 | 28756 | 7 | 1.110 | 25906.3 |
532 | 2024-03-31 14:35:41 | spree | 2 | 53800 | 136 | 1.810 | 29723.8 |
531 | 2024-03-31 07:35:16 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
530 | 2024-03-31 06:52:52 | spree | 2 | 53800 | 136 | 1.563 | 34421.0 |
529 | 2024-03-05 08:50:37 | spree | 1 | 28756 | 7 | 0.593 | 48492.4 |
528 | 2024-03-04 04:14:20 | spree | 2 | 53800 | 136 | 1.703 | 31591.3 |
527 | 2024-03-04 00:36:03 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
526 | 2024-03-01 06:28:18 | spree | 1 | 28756 | 7 | 1.093 | 26309.2 |
525 | 2024-02-28 04:51:45 | spree | 2 | 53800 | 136 | 2.080 | 25865.4 |
524 | 2024-02-28 02:42:40 | spree | 2 | 53800 | 136 | 3.670 | 14659.4 |
523 | 2024-02-25 22:12:32 | spree | 2 | 53800 | 136 | 4.216 | 12760.9 |
522 | 2024-02-25 22:12:23 | spree | 1 | 28756 | 7 | 0.593 | 48492.4 |
521 | 2024-02-02 23:04:39 | spree | 1 | 28756 | 7 | 0.516 | 55728.7 |
520 | 2024-01-31 12:51:03 | spree | 1 | 28756 | 7 | 0.530 | 54256.6 |
519 | 2024-01-29 07:13:32 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
518 | 2024-01-26 19:20:49 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
517 | 2024-01-22 07:20:34 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
516 | 2024-01-22 01:29:54 | spree | 2 | 53800 | 136 | 1.343 | 40059.6 |
515 | 2023-12-09 10:42:47 | spree | 2 | 53800 | 136 | 1.546 | 34799.5 |
514 | 2023-12-04 19:14:06 | spree | 2 | 53800 | 136 | 1.390 | 38705.0 |
513 | 2023-11-26 13:39:21 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
512 | 2023-11-23 15:55:29 | spree | 2 | 53800 | 136 | 3.673 | 14647.4 |
511 | 2023-11-21 12:19:46 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
510 | 2023-11-18 20:04:32 | spree | 2 | 53800 | 136 | 1.733 | 31044.4 |
509 | 2023-11-09 03:38:20 | spree | 1 | 28756 | 7 | 0.516 | 55728.7 |
508 | 2023-10-28 10:43:03 | spree | 1 | 28756 | 7 | 0.513 | 56054.6 |
507 | 2023-10-21 13:45:47 | spree | 1 | 28756 | 7 | 0.440 | 65354.5 |
506 | 2023-10-19 07:22:08 | spree | 1 | 28756 | 7 | 0.450 | 63902.2 |
505 | 2023-10-16 16:37:23 | spree | 1 | 28756 | 7 | 0.470 | 61183.0 |
504 | 2023-10-05 06:21:24 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
503 | 2023-09-28 13:19:31 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
502 | 2023-09-21 14:05:22 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
501 | 2023-09-20 14:56:55 | spree | 1 | 28756 | 7 | 0.893 | 32201.6 |
500 | 2023-09-10 20:07:36 | spree | 1 | 28756 | 7 | 1.706 | 16855.8 |
499 | 2023-09-02 21:26:01 | spree | 2 | 53800 | 136 | 1.533 | 35094.6 |
498 | 2023-06-18 08:37:00 | spree | 1 | 28756 | 7 | 0.513 | 56054.6 |
497 | 2023-05-25 15:11:13 | spree | 1 | 28756 | 7 | 0.440 | 65354.5 |
496 | 2023-05-19 01:38:44 | spree | 2 | 53800 | 136 | 1.343 | 40059.6 |
495 | 2023-04-03 23:07:30 | spree | 1 | 28756 | 7 | 0.466 | 61708.2 |
494 | 2023-02-24 15:59:52 | spree | 2 | 53800 | 136 | 1.343 | 40059.6 |
493 | 2023-02-05 13:14:59 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
492 | 2023-01-16 00:53:24 | spree | 1 | 28756 | 7 | 0.440 | 65354.5 |
491 | 2022-12-05 13:44:07 | spree | 2 | 53800 | 136 | 1.343 | 40059.6 |
490 | 2022-11-06 09:09:11 | spree | 1 | 28756 | 7 | 0.470 | 61183.0 |
489 | 2022-10-08 01:58:15 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
488 | 2022-09-12 22:50:07 | spree | 1 | 28756 | 7 | 0.673 | 42728.1 |
487 | 2022-09-04 19:51:10 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
486 | 2022-08-28 23:40:17 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
485 | 2022-08-18 16:34:11 | spree | 1 | 28756 | 7 | 0.906 | 31739.5 |
484 | 2022-08-16 02:02:02 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
483 | 2022-07-26 10:54:53 | spree | 1 | 28756 | 7 | 0.466 | 61708.2 |
482 | 2022-07-18 08:36:10 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
481 | 2022-07-10 11:15:30 | spree | 1 | 28756 | 7 | 0.483 | 59536.2 |
480 | 2022-07-03 22:34:33 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
479 | 2022-06-25 23:44:39 | spree | 1 | 28756 | 7 | 0.450 | 63902.2 |
478 | 2022-06-25 16:23:27 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
477 | 2022-06-10 07:51:36 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
476 | 2022-06-09 03:32:14 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
475 | 2022-06-08 20:18:40 | spree | 1 | 28756 | 7 | 0.440 | 65354.5 |
474 | 2022-06-07 09:40:25 | spree | 1 | 28756 | 7 | 0.486 | 59168.7 |
473 | 2022-05-02 17:07:48 | spree | 1 | 28756 | 7 | 0.860 | 33437.2 |
472 | 2022-04-11 10:59:45 | spree | 2 | 53800 | 136 | 1.830 | 29398.9 |
471 | 2022-03-01 01:55:51 | spree | 1 | 28756 | 7 | 0.640 | 44931.3 |
470 | 2022-02-09 11:17:08 | spree | 1 | 28756 | 7 | 0.470 | 61183.0 |
469 | 2021-12-19 04:52:13 | spree | 2 | 53800 | 136 | 1.406 | 38264.6 |
468 | 2021-12-17 23:30:23 | spree | 1 | 28756 | 7 | 0.546 | 52666.7 |
467 | 2021-10-26 02:31:51 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
466 | 2021-10-25 01:03:41 | spree | 1 | 28756 | 7 | 0.516 | 55728.7 |
465 | 2021-10-23 01:56:13 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
464 | 2021-09-19 13:20:48 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
463 | 2021-08-30 21:03:59 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
462 | 2021-08-28 16:37:17 | spree | 1 | 28756 | 7 | 0.486 | 59168.7 |
461 | 2021-07-19 04:24:51 | spree | 1 | 28756 | 7 | 0.440 | 65354.5 |
460 | 2021-05-23 10:07:12 | spree | 1 | 28756 | 7 | 0.923 | 31154.9 |
459 | 2021-04-24 16:14:15 | spree | 1 | 28756 | 7 | 0.513 | 56054.6 |
458 | 2021-04-21 17:28:56 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
457 | 2021-04-16 13:49:21 | spree | 1 | 28756 | 7 | 0.516 | 55728.7 |
456 | 2021-04-12 16:34:35 | spree | 1 | 28756 | 7 | 0.530 | 54256.6 |
455 | 2021-03-26 13:47:31 | spree | 1 | 28756 | 7 | 1.000 | 28756.0 |
454 | 2021-02-26 11:14:34 | spree | 1 | 28756 | 7 | 0.470 | 61183.0 |
453 | 2021-01-02 22:54:10 | spree | 1 | 28756 | 7 | 0.466 | 61708.2 |
452 | 2020-11-20 06:11:59 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
451 | 2020-10-25 05:40:17 | spree | 1 | 28756 | 7 | 0.466 | 61708.2 |
450 | 2020-10-01 01:39:36 | spree | 1 | 28756 | 7 | 0.440 | 65354.5 |
449 | 2020-09-15 02:03:46 | spree | 1 | 28756 | 7 | 0.436 | 65954.1 |
448 | 2020-07-25 03:52:54 | spree | 1 | 28756 | 7 | 0.580 | 49579.3 |
447 | 2020-07-21 19:28:36 | spree | 1 | 28756 | 7 | 0.483 | 59536.2 |
446 | 2020-06-21 03:27:45 | spree | 1 | 28756 | 7 | 0.670 | 42919.4 |
445 | 2020-06-17 23:29:06 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
444 | 2020-06-11 14:11:52 | spree | 1 | 28756 | 7 | 0.546 | 52666.7 |
443 | 2020-04-19 01:36:13 | spree | 1 | 28756 | 7 | 0.453 | 63479.0 |
442 | 2020-03-30 01:54:57 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
441 | 2020-03-25 07:09:23 | spree | 1 | 28756 | 7 | 0.486 | 59168.7 |
440 | 2020-03-23 17:05:33 | spree | 1 | 28756 | 7 | 0.530 | 54256.6 |
439 | 2020-03-23 14:19:35 | spree | 1 | 28756 | 7 | 0.530 | 54256.6 |
438 | 2020-03-22 06:43:24 | spree | 1 | 28756 | 7 | 0.500 | 57512.0 |
437 | 2020-03-21 05:50:37 | spree | 1 | 28756 | 7 | 0.486 | 59168.7 |