History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sporty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
515 | 2024-05-04 02:55:23 | sporty | 1 | 48755 | 5 | 0.890 | 54780.9 |
514 | 2024-04-29 10:24:37 | sporty | 2 | 82551 | 67 | 2.483 | 33246.5 |
513 | 2024-04-29 10:24:02 | sporty | 3 | 112716 | 621 | 6.060 | 18600.0 |
512 | 2024-04-29 01:22:11 | sporty | 2 | 82551 | 67 | 3.546 | 23280.0 |
511 | 2024-04-29 01:21:43 | sporty | 2 | 82551 | 67 | 2.720 | 30349.6 |
510 | 2024-04-29 01:21:39 | sporty | 3 | 112716 | 621 | 5.623 | 20045.5 |
509 | 2024-04-29 01:21:35 | sporty | 1 | 48755 | 5 | 0.860 | 56691.9 |
508 | 2024-04-29 01:21:13 | sporty | 3 | 112716 | 621 | 5.800 | 19433.8 |
507 | 2024-04-28 17:39:53 | sporty | 3 | 112716 | 621 | 6.810 | 16551.5 |
506 | 2024-04-27 08:25:11 | sporty | 1 | 48755 | 5 | 1.030 | 47335.0 |
505 | 2024-04-03 07:59:35 | sporty | 1 | 48755 | 5 | 1.013 | 48129.3 |
504 | 2024-03-31 17:56:04 | sporty | 1 | 48755 | 5 | 0.936 | 52088.7 |
503 | 2024-03-28 22:27:24 | sporty | 2 | 82551 | 67 | 6.080 | 13577.5 |
502 | 2024-03-28 22:27:13 | sporty | 1 | 48755 | 5 | 2.153 | 22645.1 |
501 | 2024-03-05 03:39:19 | sporty | 3 | 112716 | 621 | 12.953 | 8701.9 |
500 | 2024-03-04 21:00:55 | sporty | 2 | 82551 | 67 | 2.390 | 34540.2 |
499 | 2024-03-04 21:00:51 | sporty | 2 | 82551 | 67 | 2.923 | 28241.9 |
498 | 2024-03-04 21:00:49 | sporty | 1 | 48755 | 5 | 0.890 | 54780.9 |
497 | 2024-03-04 21:00:25 | sporty | 3 | 112716 | 621 | 5.233 | 21539.5 |
496 | 2024-03-04 07:01:15 | sporty | 3 | 112716 | 621 | 14.720 | 7657.3 |
495 | 2024-03-04 03:31:30 | sporty | 3 | 112716 | 621 | 4.966 | 22697.5 |
494 | 2024-03-04 03:31:28 | sporty | 2 | 82551 | 67 | 2.466 | 33475.7 |
493 | 2024-03-04 03:31:26 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
492 | 2024-02-04 09:15:43 | sporty | 1 | 48755 | 5 | 1.330 | 36657.9 |
491 | 2024-01-16 02:39:20 | sporty | 3 | 112716 | 621 | 5.406 | 20850.2 |
490 | 2024-01-16 02:39:19 | sporty | 2 | 82551 | 67 | 2.610 | 31628.7 |
489 | 2024-01-15 00:30:51 | sporty | 1 | 48755 | 5 | 0.860 | 56691.9 |
488 | 2024-01-13 09:02:26 | sporty | 1 | 48755 | 5 | 0.873 | 55847.7 |
487 | 2023-12-19 23:34:26 | sporty | 3 | 112716 | 621 | 4.623 | 24381.6 |
486 | 2023-11-25 12:08:20 | sporty | 1 | 48755 | 5 | 0.813 | 59969.2 |
485 | 2023-11-18 18:02:02 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
484 | 2023-11-16 07:03:57 | sporty | 1 | 48755 | 5 | 0.860 | 56691.9 |
483 | 2023-11-09 22:49:39 | sporty | 1 | 48755 | 5 | 0.936 | 52088.7 |
482 | 2023-11-03 02:55:38 | sporty | 1 | 48755 | 5 | 0.830 | 58741.0 |
481 | 2023-10-25 21:53:43 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
480 | 2023-10-15 02:34:13 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
479 | 2023-10-03 23:11:44 | sporty | 1 | 48755 | 5 | 0.813 | 59969.2 |
478 | 2023-09-28 11:45:02 | sporty | 3 | 112716 | 621 | 5.563 | 20261.7 |
477 | 2023-09-26 19:25:44 | sporty | 1 | 48755 | 5 | 0.780 | 62506.4 |
476 | 2023-09-22 17:25:10 | sporty | 3 | 112716 | 621 | 5.813 | 19390.3 |
475 | 2023-09-20 16:09:07 | sporty | 3 | 112716 | 621 | 5.220 | 21593.1 |
474 | 2023-09-18 12:26:08 | sporty | 3 | 112716 | 621 | 4.846 | 23259.6 |
473 | 2023-09-12 11:07:36 | sporty | 1 | 48755 | 5 | 0.766 | 63648.8 |
472 | 2023-09-03 08:16:37 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
471 | 2023-08-30 09:04:41 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
470 | 2023-06-27 20:22:51 | sporty | 3 | 112716 | 621 | 4.876 | 23116.5 |
469 | 2023-06-04 22:47:31 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
468 | 2023-05-03 05:14:55 | sporty | 1 | 48755 | 5 | 0.890 | 54780.9 |
467 | 2023-03-29 07:57:00 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
466 | 2023-03-21 08:27:28 | sporty | 3 | 112716 | 621 | 5.640 | 19985.1 |
465 | 2023-01-12 01:14:58 | sporty | 1 | 48755 | 5 | 0.826 | 59025.4 |
464 | 2023-01-02 06:03:27 | sporty | 1 | 48755 | 5 | 0.796 | 61250.0 |
463 | 2022-12-21 06:02:58 | sporty | 3 | 112716 | 621 | 5.263 | 21416.7 |
462 | 2022-11-30 04:59:10 | sporty | 3 | 112716 | 621 | 5.123 | 22002.0 |
461 | 2022-11-26 14:19:12 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
460 | 2022-10-26 11:01:54 | sporty | 1 | 48755 | 5 | 0.780 | 62506.4 |
459 | 2022-10-21 07:09:12 | sporty | 3 | 112716 | 621 | 4.876 | 23116.5 |
458 | 2022-10-19 08:44:54 | sporty | 3 | 112716 | 621 | 4.796 | 23502.1 |
457 | 2022-08-28 23:40:45 | sporty | 1 | 48755 | 5 | 0.766 | 63648.8 |
456 | 2022-08-16 10:18:48 | sporty | 3 | 112716 | 621 | 4.656 | 24208.8 |
455 | 2022-07-18 04:08:22 | sporty | 2 | 82551 | 67 | 2.153 | 38342.3 |
454 | 2022-06-17 21:09:46 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
453 | 2022-06-15 15:52:50 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
452 | 2022-04-24 21:02:23 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
451 | 2022-03-16 20:13:19 | sporty | 3 | 112716 | 621 | 5.440 | 20719.9 |
450 | 2022-02-21 00:37:29 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
449 | 2022-01-02 00:45:50 | sporty | 1 | 48755 | 5 | 0.856 | 56956.8 |
448 | 2021-12-31 05:45:06 | sporty | 3 | 112716 | 621 | 4.813 | 23419.1 |
447 | 2021-12-31 05:01:32 | sporty | 3 | 112716 | 621 | 6.220 | 18121.5 |
446 | 2021-12-30 06:34:18 | sporty | 3 | 112716 | 621 | 6.233 | 18083.7 |
445 | 2021-12-29 05:22:05 | sporty | 3 | 112716 | 621 | 6.423 | 17548.8 |
444 | 2021-12-28 07:10:49 | sporty | 3 | 112716 | 621 | 5.950 | 18943.9 |
443 | 2021-12-27 05:31:16 | sporty | 3 | 112716 | 621 | 5.763 | 19558.6 |
442 | 2021-12-26 06:21:26 | sporty | 3 | 112716 | 621 | 8.186 | 13769.4 |
441 | 2021-12-25 06:12:45 | sporty | 3 | 112716 | 621 | 10.093 | 11167.7 |
440 | 2021-12-24 02:26:00 | sporty | 3 | 112716 | 621 | 5.873 | 19192.2 |
439 | 2021-12-19 19:42:35 | sporty | 3 | 112716 | 621 | 4.673 | 24120.7 |
438 | 2021-12-18 14:21:14 | sporty | 1 | 48755 | 5 | 0.780 | 62506.4 |
437 | 2021-12-16 11:30:15 | sporty | 1 | 48755 | 5 | 0.890 | 54780.9 |
436 | 2021-10-19 13:54:02 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
435 | 2021-09-29 10:32:08 | sporty | 3 | 112716 | 621 | 5.436 | 20735.1 |
434 | 2021-09-28 21:42:29 | sporty | 3 | 112716 | 621 | 4.800 | 23482.5 |
433 | 2021-09-28 00:04:51 | sporty | 3 | 112716 | 621 | 7.110 | 15853.2 |
432 | 2021-09-13 02:49:16 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
431 | 2021-09-11 15:38:21 | sporty | 1 | 48755 | 5 | 0.830 | 58741.0 |
430 | 2021-09-09 10:42:12 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
429 | 2021-08-20 15:17:06 | sporty | 1 | 48755 | 5 | 0.780 | 62506.4 |
428 | 2021-08-17 08:49:48 | sporty | 3 | 112716 | 621 | 4.610 | 24450.3 |
427 | 2021-07-28 15:05:04 | sporty | 3 | 112716 | 621 | 4.733 | 23814.9 |
426 | 2021-06-18 12:05:36 | sporty | 1 | 48755 | 5 | 0.873 | 55847.7 |
425 | 2021-06-10 10:52:52 | sporty | 3 | 112716 | 621 | 4.953 | 22757.1 |
424 | 2021-06-08 23:21:56 | sporty | 1 | 48755 | 5 | 0.843 | 57835.1 |
423 | 2021-06-03 20:49:26 | sporty | 3 | 112716 | 621 | 4.643 | 24276.5 |
422 | 2021-06-02 17:16:51 | sporty | 3 | 112716 | 621 | 5.720 | 19705.6 |
421 | 2021-06-01 18:29:18 | sporty | 3 | 112716 | 621 | 4.716 | 23900.8 |
420 | 2021-05-10 21:38:56 | sporty | 3 | 112716 | 621 | 5.876 | 19182.4 |
419 | 2021-05-08 21:44:44 | sporty | 3 | 112716 | 621 | 5.266 | 21404.5 |
418 | 2021-05-01 02:05:10 | sporty | 1 | 48755 | 5 | 0.876 | 55656.4 |
417 | 2021-04-30 01:56:24 | sporty | 1 | 48755 | 5 | 0.766 | 63648.8 |
416 | 2021-04-24 23:11:58 | sporty | 3 | 112716 | 621 | 5.716 | 19719.4 |