History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spence"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 504 | 2024-04-24 09:42:18 | spence | 1 | 48755 | 5 | 1.970 | 24748.7 |
| 503 | 2024-04-12 09:32:16 | spence | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 502 | 2024-04-03 07:59:19 | spence | 1 | 48755 | 5 | 3.236 | 15066.4 |
| 501 | 2024-03-31 10:31:36 | spence | 1 | 48755 | 5 | 2.110 | 23106.6 |
| 500 | 2024-03-29 00:04:31 | spence | 1 | 48755 | 5 | 1.310 | 37217.6 |
| 499 | 2024-02-28 10:32:48 | spence | 1 | 48755 | 5 | 1.843 | 26454.2 |
| 498 | 2024-02-28 06:26:52 | spence | 2 | 82551 | 50 | 2.810 | 29377.6 |
| 497 | 2024-02-28 04:52:36 | spence | 3 | 112716 | 532 | 7.220 | 15611.6 |
| 496 | 2024-02-27 22:28:03 | spence | 2 | 82551 | 50 | 2.813 | 29346.2 |
| 495 | 2024-02-27 22:27:44 | spence | 3 | 112716 | 532 | 8.283 | 13608.1 |
| 494 | 2024-02-27 21:36:41 | spence | 3 | 112716 | 532 | 6.813 | 16544.3 |
| 493 | 2024-02-27 21:36:39 | spence | 2 | 82551 | 50 | 2.750 | 30018.5 |
| 492 | 2024-02-27 21:36:38 | spence | 1 | 48755 | 5 | 1.843 | 26454.2 |
| 491 | 2024-01-19 06:54:46 | spence | 3 | 112716 | 532 | 5.530 | 20382.6 |
| 490 | 2024-01-12 02:47:17 | spence | 3 | 112716 | 532 | 4.860 | 23192.6 |
| 489 | 2024-01-11 01:25:05 | spence | 2 | 82551 | 50 | 2.356 | 35038.6 |
| 488 | 2024-01-10 09:20:54 | spence | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 487 | 2024-01-10 02:51:31 | spence | 3 | 112716 | 532 | 5.766 | 19548.4 |
| 486 | 2024-01-06 03:30:02 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 485 | 2023-12-26 10:09:58 | spence | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 484 | 2023-11-28 06:22:40 | spence | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 483 | 2023-11-28 03:19:05 | spence | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 482 | 2023-11-17 02:50:27 | spence | 1 | 48755 | 5 | 0.763 | 63899.1 |
| 481 | 2023-11-16 14:13:57 | spence | 3 | 112716 | 532 | 5.063 | 22262.7 |
| 480 | 2023-11-16 14:13:55 | spence | 2 | 82551 | 50 | 2.483 | 33246.5 |
| 479 | 2023-11-14 15:17:59 | spence | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 478 | 2023-11-02 08:45:43 | spence | 3 | 112716 | 532 | 6.546 | 17219.1 |
| 477 | 2023-11-02 08:45:42 | spence | 2 | 82551 | 50 | 7.046 | 11716.0 |
| 476 | 2023-11-02 07:42:10 | spence | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 475 | 2023-10-30 23:59:43 | spence | 1 | 48755 | 5 | 0.953 | 51159.5 |
| 474 | 2023-10-21 13:17:00 | spence | 1 | 48755 | 5 | 0.906 | 53813.5 |
| 473 | 2023-10-19 09:06:58 | spence | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 472 | 2023-10-12 00:45:46 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 471 | 2023-10-08 18:55:13 | spence | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 470 | 2023-09-26 20:23:57 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 469 | 2023-09-14 09:02:19 | spence | 1 | 48755 | 5 | 0.840 | 58041.7 |
| 468 | 2023-09-07 13:47:21 | spence | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 467 | 2023-08-23 05:42:05 | spence | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 466 | 2023-07-12 06:56:42 | spence | 2 | 82551 | 50 | 2.123 | 38884.1 |
| 465 | 2023-07-12 05:49:09 | spence | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 464 | 2023-05-27 18:09:24 | spence | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 463 | 2023-05-25 12:44:54 | spence | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 462 | 2023-05-14 20:09:28 | spence | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 461 | 2023-03-23 04:22:34 | spence | 1 | 48755 | 5 | 0.736 | 66243.2 |
| 460 | 2023-03-22 16:32:21 | spence | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 459 | 2023-01-17 21:32:15 | spence | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 458 | 2023-01-08 23:37:39 | spence | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 457 | 2022-10-11 13:46:34 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 456 | 2022-09-15 19:46:47 | spence | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 455 | 2022-07-29 08:11:04 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 454 | 2022-07-19 13:21:10 | spence | 2 | 82551 | 50 | 2.203 | 37472.1 |
| 453 | 2022-07-19 13:20:49 | spence | 3 | 112716 | 532 | 4.623 | 24381.6 |
| 452 | 2022-05-30 18:43:21 | spence | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 451 | 2022-05-29 12:13:14 | spence | 1 | 48755 | 5 | 0.810 | 60191.4 |
| 450 | 2022-05-13 11:55:06 | spence | 1 | 48755 | 5 | 1.096 | 44484.5 |
| 449 | 2022-03-17 06:11:17 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 448 | 2022-03-15 02:09:44 | spence | 1 | 48755 | 5 | 1.033 | 47197.5 |
| 447 | 2022-01-28 19:40:34 | spence | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 446 | 2022-01-28 00:19:58 | spence | 1 | 48755 | 5 | 1.016 | 47987.2 |
| 445 | 2022-01-27 07:15:41 | spence | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 444 | 2022-01-26 20:29:56 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 443 | 2022-01-26 12:20:08 | spence | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 442 | 2022-01-26 02:10:40 | spence | 1 | 48755 | 5 | 0.970 | 50262.9 |
| 441 | 2022-01-25 13:14:26 | spence | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 440 | 2022-01-25 02:44:55 | spence | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 439 | 2022-01-24 18:59:51 | spence | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 438 | 2022-01-24 07:08:15 | spence | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 437 | 2022-01-23 17:21:14 | spence | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 436 | 2022-01-22 05:40:48 | spence | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 435 | 2022-01-03 17:28:23 | spence | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 434 | 2021-12-27 11:34:48 | spence | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 433 | 2021-12-23 15:42:49 | spence | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 432 | 2021-12-23 08:08:11 | spence | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 431 | 2021-12-22 20:17:29 | spence | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 430 | 2021-12-22 09:23:46 | spence | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 429 | 2021-12-22 01:32:57 | spence | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 428 | 2021-12-21 14:51:25 | spence | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 427 | 2021-12-21 06:50:37 | spence | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 426 | 2021-12-20 21:29:51 | spence | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 425 | 2021-12-20 10:51:41 | spence | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 424 | 2021-12-19 22:06:45 | spence | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 423 | 2021-11-22 11:36:05 | spence | 1 | 48755 | 5 | 0.940 | 51867.0 |
| 422 | 2021-11-21 20:30:20 | spence | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 421 | 2021-11-15 20:34:07 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 420 | 2021-11-15 09:29:45 | spence | 1 | 48755 | 5 | 0.876 | 55656.4 |
| 419 | 2021-11-14 23:07:28 | spence | 1 | 48755 | 5 | 1.716 | 28412.0 |
| 418 | 2021-11-14 14:33:05 | spence | 1 | 48755 | 5 | 0.783 | 62266.9 |
| 417 | 2021-11-13 22:39:01 | spence | 1 | 48755 | 5 | 1.563 | 31193.2 |
| 416 | 2021-11-13 11:35:55 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 415 | 2021-11-12 20:54:10 | spence | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 414 | 2021-11-12 10:58:51 | spence | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 413 | 2021-11-11 18:25:15 | spence | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 412 | 2021-11-11 07:38:28 | spence | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 411 | 2021-11-01 05:51:52 | spence | 1 | 48755 | 5 | 0.986 | 49447.3 |
| 410 | 2021-10-30 05:55:09 | spence | 1 | 48755 | 5 | 0.920 | 52994.6 |
| 409 | 2021-10-14 18:34:21 | spence | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 408 | 2021-10-13 22:39:42 | spence | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 407 | 2021-10-13 16:18:01 | spence | 3 | 112716 | 532 | 5.920 | 19039.9 |
| 406 | 2021-10-12 14:20:51 | spence | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 405 | 2021-10-11 17:16:50 | spence | 1 | 48755 | 5 | 0.876 | 55656.4 |