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 |
| 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 |
| 415 | 2021-04-05 16:36:08 | sporty | 3 | 112716 | 621 | 4.593 | 24540.8 |
| 414 | 2021-03-29 11:57:07 | sporty | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 413 | 2021-03-09 23:25:13 | sporty | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 412 | 2021-03-07 23:50:41 | sporty | 3 | 112716 | 621 | 4.610 | 24450.3 |
| 411 | 2021-02-13 19:03:03 | sporty | 3 | 112716 | 621 | 5.390 | 20912.1 |
| 410 | 2021-01-31 15:41:00 | sporty | 3 | 112716 | 621 | 4.970 | 22679.3 |
| 409 | 2021-01-29 12:13:29 | sporty | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 408 | 2021-01-13 06:13:22 | sporty | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 407 | 2020-12-21 15:56:38 | sporty | 3 | 112716 | 621 | 4.750 | 23729.7 |
| 406 | 2020-12-04 08:20:43 | sporty | 3 | 112716 | 621 | 4.690 | 24033.3 |