History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"surfer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 481 | 2024-04-26 11:48:13 | surfer | 1 | 48755 | 7 | 0.920 | 52994.6 |
| 480 | 2024-04-03 19:46:14 | surfer | 3 | 112716 | 1085 | 19.330 | 5831.1 |
| 479 | 2024-04-03 14:46:33 | surfer | 3 | 112716 | 1085 | 10.376 | 10863.1 |
| 478 | 2024-04-03 10:40:34 | surfer | 3 | 112716 | 1085 | 7.563 | 14903.6 |
| 477 | 2024-04-03 10:40:36 | surfer | 2 | 82551 | 89 | 3.046 | 27101.4 |
| 476 | 2024-04-03 10:40:14 | surfer | 1 | 48755 | 7 | 1.013 | 48129.3 |
| 475 | 2024-03-30 02:30:55 | surfer | 1 | 48755 | 7 | 0.936 | 52088.7 |
| 474 | 2024-03-04 07:08:19 | surfer | 1 | 48755 | 7 | 2.966 | 16438.0 |
| 473 | 2024-02-28 22:08:11 | surfer | 2 | 82551 | 89 | 2.640 | 31269.3 |
| 472 | 2024-02-28 13:42:59 | surfer | 2 | 82551 | 89 | 2.953 | 27955.0 |
| 471 | 2024-02-28 13:42:21 | surfer | 3 | 112716 | 1085 | 5.406 | 20850.2 |
| 470 | 2024-02-26 05:26:55 | surfer | 3 | 112716 | 1085 | 10.236 | 11011.7 |
| 469 | 2024-02-24 07:41:01 | surfer | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 468 | 2024-02-22 05:34:13 | surfer | 3 | 112716 | 1085 | 7.580 | 14870.2 |
| 467 | 2024-02-22 02:46:53 | surfer | 2 | 82551 | 89 | 5.436 | 15186.0 |
| 466 | 2024-02-22 00:11:50 | surfer | 3 | 112716 | 1085 | 5.690 | 19809.5 |
| 465 | 2024-02-21 17:28:15 | surfer | 2 | 82551 | 89 | 5.376 | 15355.5 |
| 464 | 2024-02-19 14:28:29 | surfer | 2 | 82551 | 89 | 8.953 | 9220.5 |
| 463 | 2024-02-16 19:32:04 | surfer | 2 | 82551 | 89 | 2.390 | 34540.2 |
| 462 | 2024-01-21 04:13:34 | surfer | 3 | 112716 | 1085 | 4.656 | 24208.8 |
| 461 | 2024-01-19 15:24:34 | surfer | 3 | 112716 | 1085 | 5.673 | 19868.9 |
| 460 | 2024-01-17 16:17:52 | surfer | 2 | 82551 | 89 | 2.170 | 38041.9 |
| 459 | 2024-01-14 09:06:21 | surfer | 2 | 82551 | 89 | 2.530 | 32628.9 |
| 458 | 2024-01-09 13:10:53 | surfer | 2 | 82551 | 89 | 2.233 | 36968.7 |
| 457 | 2023-12-07 16:43:37 | surfer | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 456 | 2023-12-07 16:43:36 | surfer | 1 | 48755 | 7 | 1.046 | 46610.9 |
| 455 | 2023-12-06 18:03:37 | surfer | 1 | 48755 | 7 | 1.266 | 38511.1 |
| 454 | 2023-12-05 01:24:14 | surfer | 3 | 112716 | 1085 | 6.420 | 17557.0 |
| 453 | 2023-12-04 08:11:39 | surfer | 3 | 112716 | 1085 | 4.966 | 22697.5 |
| 452 | 2023-12-04 08:11:33 | surfer | 3 | 112716 | 1085 | 4.860 | 23192.6 |
| 451 | 2023-12-03 19:47:59 | surfer | 1 | 48755 | 7 | 0.766 | 63648.8 |
| 450 | 2023-12-03 19:47:58 | surfer | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 449 | 2023-11-18 00:18:25 | surfer | 1 | 48755 | 7 | 0.876 | 55656.4 |
| 448 | 2023-11-17 12:01:17 | surfer | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 447 | 2023-11-16 07:32:09 | surfer | 2 | 82551 | 89 | 2.470 | 33421.5 |
| 446 | 2023-11-15 13:18:36 | surfer | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 445 | 2023-10-31 05:22:53 | surfer | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 444 | 2023-10-27 04:10:09 | surfer | 1 | 48755 | 7 | 0.783 | 62266.9 |
| 443 | 2023-10-23 06:01:12 | surfer | 1 | 48755 | 7 | 0.800 | 60943.8 |
| 442 | 2023-10-15 13:44:47 | surfer | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 441 | 2023-10-04 09:33:13 | surfer | 3 | 112716 | 1085 | 6.796 | 16585.6 |
| 440 | 2023-10-01 14:39:42 | surfer | 3 | 112716 | 1085 | 5.580 | 20200.0 |
| 439 | 2023-09-28 23:16:18 | surfer | 1 | 48755 | 7 | 1.140 | 42767.5 |
| 438 | 2023-09-28 05:55:14 | surfer | 3 | 112716 | 1085 | 5.596 | 20142.2 |
| 437 | 2023-09-28 05:55:12 | surfer | 2 | 82551 | 89 | 2.533 | 32590.2 |
| 436 | 2023-09-22 10:46:24 | surfer | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 435 | 2023-09-21 03:54:11 | surfer | 1 | 48755 | 7 | 0.860 | 56691.9 |
| 434 | 2023-08-16 17:11:12 | surfer | 2 | 82551 | 89 | 2.450 | 33694.3 |
| 433 | 2023-07-11 20:47:54 | surfer | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 432 | 2023-06-25 15:30:32 | surfer | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 431 | 2023-05-01 09:54:51 | surfer | 2 | 82551 | 89 | 2.170 | 38041.9 |
| 430 | 2023-04-19 23:34:46 | surfer | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 429 | 2023-03-03 01:30:24 | surfer | 3 | 112716 | 1085 | 4.856 | 23211.7 |
| 428 | 2023-02-21 02:52:20 | surfer | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 427 | 2023-02-17 16:08:20 | surfer | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 426 | 2023-02-10 18:45:51 | surfer | 2 | 82551 | 89 | 2.296 | 35954.3 |
| 425 | 2023-02-07 13:31:34 | surfer | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 424 | 2023-02-07 00:03:43 | surfer | 2 | 82551 | 89 | 2.140 | 38575.2 |
| 423 | 2023-01-15 04:36:59 | surfer | 2 | 82551 | 89 | 2.576 | 32046.2 |
| 422 | 2022-12-26 23:53:51 | surfer | 3 | 112716 | 1085 | 4.626 | 24365.8 |
| 421 | 2022-12-19 03:55:27 | surfer | 3 | 112716 | 1085 | 4.810 | 23433.7 |
| 420 | 2022-12-05 22:51:28 | surfer | 1 | 48755 | 7 | 0.826 | 59025.4 |
| 419 | 2022-12-01 04:47:36 | surfer | 2 | 82551 | 89 | 2.123 | 38884.1 |
| 418 | 2022-11-23 02:20:17 | surfer | 3 | 112716 | 1085 | 4.936 | 22835.5 |
| 417 | 2022-11-19 01:42:27 | surfer | 2 | 82551 | 89 | 2.170 | 38041.9 |
| 416 | 2022-11-18 10:49:55 | surfer | 3 | 112716 | 1085 | 5.890 | 19136.8 |
| 415 | 2022-11-12 09:36:59 | surfer | 3 | 112716 | 1085 | 5.390 | 20912.1 |
| 414 | 2022-11-10 10:51:45 | surfer | 3 | 112716 | 1085 | 6.000 | 18786.0 |
| 413 | 2022-11-09 23:28:47 | surfer | 2 | 82551 | 89 | 2.563 | 32208.7 |
| 412 | 2022-11-06 05:15:04 | surfer | 2 | 82551 | 89 | 2.140 | 38575.2 |
| 411 | 2022-10-15 03:28:54 | surfer | 2 | 82551 | 89 | 2.126 | 38829.3 |
| 410 | 2022-10-13 09:51:03 | surfer | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 409 | 2022-10-10 11:56:13 | surfer | 3 | 112716 | 1085 | 4.736 | 23799.8 |
| 408 | 2022-09-18 04:58:29 | surfer | 2 | 82551 | 89 | 2.516 | 32810.4 |
| 407 | 2022-09-13 02:43:41 | surfer | 2 | 82551 | 89 | 2.420 | 34112.0 |
| 406 | 2022-09-05 18:23:38 | surfer | 3 | 112716 | 1085 | 4.670 | 24136.2 |
| 405 | 2022-09-01 23:29:25 | surfer | 2 | 82551 | 89 | 2.656 | 31080.9 |
| 404 | 2022-08-02 03:52:47 | surfer | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 403 | 2022-08-01 08:04:31 | surfer | 2 | 82551 | 89 | 2.156 | 38289.0 |
| 402 | 2022-07-29 09:10:47 | surfer | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 401 | 2022-07-19 13:33:37 | surfer | 2 | 82551 | 89 | 2.330 | 35429.6 |
| 400 | 2022-06-22 17:44:41 | surfer | 2 | 82551 | 89 | 2.170 | 38041.9 |
| 399 | 2022-06-15 13:26:21 | surfer | 1 | 48755 | 7 | 0.750 | 65006.7 |
| 398 | 2022-03-29 14:43:17 | surfer | 1 | 48755 | 7 | 1.140 | 42767.5 |
| 397 | 2022-03-27 10:49:55 | surfer | 1 | 48755 | 7 | 0.763 | 63899.1 |
| 396 | 2022-02-14 14:09:00 | surfer | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 395 | 2022-02-10 23:54:08 | surfer | 1 | 48755 | 7 | 0.793 | 61481.7 |
| 394 | 2022-01-02 09:00:36 | surfer | 1 | 48755 | 7 | 0.813 | 59969.2 |
| 393 | 2021-11-04 21:16:34 | surfer | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 392 | 2021-10-24 09:13:10 | surfer | 1 | 48755 | 7 | 0.780 | 62506.4 |
| 391 | 2021-09-20 04:23:29 | surfer | 1 | 48755 | 7 | 1.750 | 27860.0 |
| 390 | 2021-08-18 09:42:20 | surfer | 1 | 48755 | 7 | 0.830 | 58741.0 |
| 389 | 2021-08-16 05:01:22 | surfer | 1 | 48755 | 7 | 0.843 | 57835.1 |
| 388 | 2021-07-17 04:42:38 | surfer | 1 | 48755 | 7 | 0.906 | 53813.5 |
| 387 | 2021-05-29 00:28:42 | surfer | 3 | 112716 | 1085 | 5.703 | 19764.3 |
| 386 | 2021-05-24 18:21:12 | surfer | 1 | 48755 | 7 | 0.796 | 61250.0 |
| 385 | 2021-05-16 05:00:19 | surfer | 1 | 48755 | 7 | 0.873 | 55847.7 |
| 384 | 2021-05-03 08:18:54 | surfer | 3 | 112716 | 1085 | 6.093 | 18499.3 |
| 383 | 2021-04-28 02:41:12 | surfer | 1 | 48755 | 7 | 1.016 | 47987.2 |
| 382 | 2021-04-14 10:19:05 | surfer | 1 | 48755 | 7 | 0.860 | 56691.9 |