History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sprat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
527 | 2024-05-07 05:19:30 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
526 | 2024-05-04 12:30:36 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
525 | 2024-05-04 02:27:18 | sprat | 1 | 28756 | 8 | 1.063 | 27051.7 |
524 | 2024-04-30 17:26:47 | sprat | 1 | 28756 | 8 | 0.970 | 29645.4 |
523 | 2024-04-30 03:24:44 | sprat | 2 | 53800 | 124 | 5.673 | 9483.5 |
522 | 2024-04-30 02:02:01 | sprat | 1 | 28756 | 8 | 1.720 | 16718.6 |
521 | 2024-04-27 08:17:32 | sprat | 1 | 28756 | 8 | 0.530 | 54256.6 |
520 | 2024-04-03 02:24:49 | sprat | 1 | 28756 | 8 | 0.576 | 49923.6 |
519 | 2024-03-31 18:05:04 | sprat | 2 | 53800 | 124 | 9.783 | 5499.3 |
518 | 2024-03-31 13:50:33 | sprat | 2 | 53800 | 124 | 3.813 | 14109.6 |
517 | 2024-03-31 13:49:27 | sprat | 1 | 28756 | 8 | 0.580 | 49579.3 |
516 | 2024-03-28 18:45:21 | sprat | 2 | 53800 | 124 | 3.703 | 14528.8 |
515 | 2024-03-28 18:21:11 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
514 | 2024-03-01 11:50:27 | sprat | 1 | 28756 | 8 | 0.486 | 59168.7 |
513 | 2024-02-28 16:52:26 | sprat | 1 | 28756 | 8 | 0.626 | 45936.1 |
512 | 2024-02-25 22:58:55 | sprat | 2 | 53800 | 124 | 5.313 | 10126.1 |
511 | 2024-02-25 18:07:23 | sprat | 1 | 28756 | 8 | 0.906 | 31739.5 |
510 | 2024-01-28 23:10:23 | sprat | 1 | 28756 | 8 | 0.470 | 61183.0 |
509 | 2024-01-25 23:10:53 | sprat | 2 | 53800 | 124 | 1.530 | 35163.4 |
508 | 2024-01-25 23:10:29 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
507 | 2024-01-13 12:00:30 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
506 | 2024-01-02 04:26:57 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
505 | 2023-12-23 02:55:02 | sprat | 2 | 53800 | 124 | 1.716 | 31352.0 |
504 | 2023-11-25 03:04:57 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
503 | 2023-11-12 20:20:35 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
502 | 2023-11-06 15:39:18 | sprat | 1 | 28756 | 8 | 0.623 | 46157.3 |
501 | 2023-10-27 11:36:36 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
500 | 2023-10-27 11:22:16 | sprat | 2 | 53800 | 124 | 1.783 | 30173.9 |
499 | 2023-10-24 22:31:53 | sprat | 2 | 53800 | 124 | 2.906 | 18513.4 |
498 | 2023-10-19 18:44:39 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
497 | 2023-10-17 17:11:00 | sprat | 1 | 28756 | 8 | 0.483 | 59536.2 |
496 | 2023-10-17 12:32:48 | sprat | 2 | 53800 | 124 | 3.906 | 13773.7 |
495 | 2023-10-10 23:56:22 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
494 | 2023-10-04 10:12:12 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
493 | 2023-09-22 16:39:37 | sprat | 1 | 28756 | 8 | 0.483 | 59536.2 |
492 | 2023-09-12 11:14:59 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
491 | 2023-08-31 01:13:16 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
490 | 2023-08-28 15:55:29 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
489 | 2023-05-30 18:13:12 | sprat | 1 | 28756 | 8 | 0.483 | 59536.2 |
488 | 2023-05-10 08:51:40 | sprat | 1 | 28756 | 8 | 0.486 | 59168.7 |
487 | 2023-05-06 20:56:25 | sprat | 1 | 28756 | 8 | 0.440 | 65354.5 |
486 | 2023-03-22 22:52:30 | sprat | 1 | 28756 | 8 | 0.486 | 59168.7 |
485 | 2023-01-17 08:31:07 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
484 | 2023-01-09 14:57:34 | sprat | 1 | 28756 | 8 | 0.440 | 65354.5 |
483 | 2023-01-08 05:42:56 | sprat | 1 | 28756 | 8 | 0.423 | 67981.1 |
482 | 2022-10-06 06:09:29 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
481 | 2022-09-11 10:29:18 | sprat | 1 | 28756 | 8 | 0.466 | 61708.2 |
480 | 2022-07-29 05:32:44 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
479 | 2022-05-22 21:14:56 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
478 | 2022-05-09 12:02:19 | sprat | 1 | 28756 | 8 | 0.640 | 44931.3 |
477 | 2022-02-03 23:12:53 | sprat | 1 | 28756 | 8 | 0.466 | 61708.2 |
476 | 2022-02-02 23:23:32 | sprat | 1 | 28756 | 8 | 0.483 | 59536.2 |
475 | 2022-02-02 01:52:04 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
474 | 2022-02-01 21:57:38 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
473 | 2022-01-31 23:22:28 | sprat | 1 | 28756 | 8 | 0.530 | 54256.6 |
472 | 2022-01-30 23:29:25 | sprat | 1 | 28756 | 8 | 0.470 | 61183.0 |
471 | 2022-01-23 23:21:25 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
470 | 2022-01-18 04:16:28 | sprat | 1 | 28756 | 8 | 0.466 | 61708.2 |
469 | 2022-01-14 21:24:22 | sprat | 1 | 28756 | 8 | 0.623 | 46157.3 |
468 | 2021-12-23 21:45:05 | sprat | 1 | 28756 | 8 | 0.563 | 51076.4 |
467 | 2021-12-22 20:46:06 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
466 | 2021-12-21 21:40:52 | sprat | 1 | 28756 | 8 | 0.546 | 52666.7 |
465 | 2021-12-20 19:42:13 | sprat | 1 | 28756 | 8 | 0.560 | 51350.0 |
464 | 2021-11-23 23:25:53 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
463 | 2021-10-09 17:49:57 | sprat | 1 | 28756 | 8 | 0.440 | 65354.5 |
462 | 2021-10-08 15:14:29 | sprat | 1 | 28756 | 8 | 0.440 | 65354.5 |
461 | 2021-09-22 20:14:58 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
460 | 2021-07-10 09:05:31 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
459 | 2021-06-21 01:01:09 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
458 | 2021-06-11 00:01:03 | sprat | 1 | 28756 | 8 | 0.486 | 59168.7 |
457 | 2021-05-23 08:01:32 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
456 | 2021-05-22 14:44:30 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
455 | 2021-05-21 17:46:46 | sprat | 1 | 28756 | 8 | 0.533 | 53951.2 |
454 | 2021-05-18 15:08:03 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
453 | 2021-04-06 13:28:03 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
452 | 2021-04-02 09:42:33 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
451 | 2021-03-20 06:43:11 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
450 | 2021-02-23 00:46:38 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
449 | 2021-01-29 22:07:37 | sprat | 1 | 28756 | 8 | 0.466 | 61708.2 |
448 | 2021-01-01 16:43:06 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
447 | 2020-12-21 09:27:14 | sprat | 1 | 28756 | 8 | 0.470 | 61183.0 |
446 | 2020-12-05 07:04:39 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
445 | 2020-11-11 15:39:25 | sprat | 1 | 28756 | 8 | 0.440 | 65354.5 |
444 | 2020-10-30 21:03:15 | sprat | 1 | 28756 | 8 | 0.906 | 31739.5 |
443 | 2020-10-28 13:13:02 | sprat | 1 | 28756 | 8 | 0.500 | 57512.0 |
442 | 2020-09-17 11:31:33 | sprat | 1 | 28756 | 8 | 0.450 | 63902.2 |
441 | 2020-09-12 07:15:47 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
440 | 2020-08-15 04:08:50 | sprat | 1 | 28756 | 8 | 0.533 | 53951.2 |
439 | 2020-07-23 14:07:20 | sprat | 1 | 28756 | 8 | 0.486 | 59168.7 |
438 | 2020-07-11 18:46:09 | sprat | 1 | 28756 | 8 | 0.470 | 61183.0 |
437 | 2020-06-07 15:18:50 | sprat | 1 | 28756 | 8 | 0.436 | 65954.1 |
436 | 2020-03-30 01:53:51 | sprat | 1 | 28756 | 8 | 0.533 | 53951.2 |
435 | 2020-03-26 21:29:23 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
434 | 2020-03-26 06:34:23 | sprat | 1 | 28756 | 8 | 0.530 | 54256.6 |
433 | 2020-03-24 15:11:13 | sprat | 1 | 28756 | 8 | 1.123 | 25606.4 |
432 | 2020-03-23 11:24:21 | sprat | 1 | 28756 | 8 | 0.550 | 52283.6 |
431 | 2020-03-22 06:43:11 | sprat | 1 | 28756 | 8 | 0.450 | 63902.2 |
430 | 2020-03-22 01:50:18 | sprat | 1 | 28756 | 8 | 0.516 | 55728.7 |
429 | 2020-03-19 16:12:28 | sprat | 1 | 28756 | 8 | 0.453 | 63479.0 |
428 | 2020-03-18 22:57:51 | sprat | 1 | 28756 | 8 | 0.890 | 32310.1 |