History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"john"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 536 | 2024-04-04 23:11:35 | john | 1 | 13983 | 4 | 0.516 | 27098.8 |
| 535 | 2024-04-02 20:57:11 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 534 | 2024-03-31 00:55:39 | john | 1 | 13983 | 4 | 0.326 | 42892.6 |
| 533 | 2024-03-27 07:23:55 | john | 1 | 13983 | 4 | 0.326 | 42892.6 |
| 532 | 2024-03-05 21:28:16 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 531 | 2024-03-03 20:23:25 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 530 | 2024-02-29 23:04:29 | john | 1 | 13983 | 4 | 0.530 | 26383.0 |
| 529 | 2024-02-26 01:56:04 | john | 2 | 29872 | 101 | 2.906 | 10279.4 |
| 528 | 2024-02-26 01:32:16 | john | 1 | 13983 | 4 | 0.406 | 34440.9 |
| 527 | 2024-02-03 04:27:54 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 526 | 2024-02-02 18:07:43 | john | 1 | 13983 | 4 | 0.406 | 34440.9 |
| 525 | 2024-01-29 08:38:47 | john | 1 | 13983 | 4 | 0.500 | 27966.0 |
| 524 | 2024-01-27 00:07:21 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 523 | 2024-01-01 06:19:20 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 522 | 2023-12-28 23:55:15 | john | 2 | 29872 | 101 | 0.716 | 41720.7 |
| 521 | 2023-11-28 00:10:07 | john | 2 | 29872 | 101 | 0.783 | 38150.7 |
| 520 | 2023-11-20 04:59:43 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 519 | 2023-11-18 19:36:02 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 518 | 2023-11-13 12:50:24 | john | 2 | 29872 | 101 | 0.703 | 42492.2 |
| 517 | 2023-11-09 22:54:23 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 516 | 2023-10-26 18:44:55 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 515 | 2023-10-24 00:45:44 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 514 | 2023-10-20 10:30:06 | john | 1 | 13983 | 4 | 0.453 | 30867.5 |
| 513 | 2023-10-17 07:05:48 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 512 | 2023-10-15 03:52:03 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 511 | 2023-10-04 00:39:43 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 510 | 2023-09-24 22:43:57 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 509 | 2023-09-15 12:15:06 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 508 | 2023-08-20 05:45:14 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 507 | 2023-07-23 03:12:08 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 506 | 2023-05-28 13:00:07 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 505 | 2023-05-22 07:47:41 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 504 | 2023-04-04 00:11:43 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 503 | 2023-03-17 11:21:02 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 502 | 2023-01-06 17:05:31 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 501 | 2022-12-12 10:34:04 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 500 | 2022-10-01 16:19:09 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 499 | 2022-09-18 12:23:25 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 498 | 2022-09-10 15:22:06 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 497 | 2022-08-31 03:06:45 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 496 | 2022-08-20 14:35:38 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 495 | 2022-08-12 04:59:37 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 494 | 2022-08-06 05:47:17 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 493 | 2022-07-10 03:42:39 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 492 | 2022-07-02 15:30:47 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 491 | 2022-05-16 17:50:50 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 490 | 2022-04-14 17:56:07 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 489 | 2022-01-31 09:56:21 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 488 | 2021-12-23 18:12:51 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 487 | 2021-11-30 17:18:10 | john | 1 | 13983 | 4 | 0.373 | 37487.9 |
| 486 | 2021-11-13 10:20:34 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 485 | 2021-10-12 06:25:15 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 484 | 2021-10-01 06:59:33 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 483 | 2021-09-20 21:42:19 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 482 | 2021-09-12 13:47:31 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 481 | 2021-09-10 10:36:29 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 480 | 2021-09-10 02:40:36 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 479 | 2021-08-25 23:33:27 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 478 | 2021-08-23 19:23:24 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 477 | 2021-06-09 05:08:31 | john | 1 | 13983 | 4 | 0.483 | 28950.3 |
| 476 | 2021-05-09 08:28:07 | john | 1 | 13983 | 4 | 0.313 | 44674.1 |
| 475 | 2021-03-10 05:30:57 | john | 1 | 13983 | 4 | 0.346 | 40413.3 |
| 474 | 2021-02-25 04:16:39 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 473 | 2021-02-19 17:26:28 | john | 2 | 29872 | 101 | 0.826 | 36164.6 |
| 472 | 2020-12-06 19:49:58 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 471 | 2020-10-28 12:16:31 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 470 | 2020-09-07 09:00:34 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 469 | 2020-08-28 09:51:34 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 468 | 2020-08-26 13:15:45 | john | 1 | 13983 | 4 | 0.220 | 63559.1 |
| 467 | 2020-08-24 19:20:21 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 466 | 2020-08-21 12:21:06 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 465 | 2020-08-09 16:28:26 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 464 | 2020-05-20 18:19:26 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 463 | 2020-04-11 06:51:00 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 462 | 2020-03-25 07:17:13 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 461 | 2020-03-23 21:34:52 | john | 1 | 13983 | 4 | 0.500 | 27966.0 |
| 460 | 2020-03-22 10:39:07 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 459 | 2020-03-21 03:37:07 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 458 | 2020-03-20 16:20:41 | john | 1 | 13983 | 4 | 0.470 | 29751.1 |
| 457 | 2020-03-18 02:38:16 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 456 | 2020-02-26 21:59:52 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 455 | 2020-02-26 19:37:08 | john | 1 | 13983 | 4 | 0.516 | 27098.8 |
| 454 | 2020-02-23 10:01:09 | john | 1 | 13983 | 4 | 0.546 | 25609.9 |
| 453 | 2020-02-17 17:56:03 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
| 452 | 2020-02-15 07:46:25 | john | 1 | 13983 | 4 | 0.266 | 52567.7 |
| 451 | 2020-02-12 11:14:41 | john | 1 | 13983 | 4 | 0.483 | 28950.3 |
| 450 | 2020-01-31 05:11:53 | john | 1 | 13983 | 4 | 0.236 | 59250.0 |
| 449 | 2020-01-31 01:33:22 | john | 1 | 13983 | 4 | 0.533 | 26234.5 |
| 448 | 2020-01-30 01:27:33 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 447 | 2020-01-29 18:57:43 | john | 1 | 13983 | 4 | 0.330 | 42372.7 |
| 446 | 2020-01-24 03:48:54 | john | 1 | 13983 | 4 | 0.796 | 17566.6 |
| 445 | 2020-01-21 16:24:26 | john | 1 | 13983 | 4 | 0.263 | 53167.3 |
| 444 | 2020-01-11 01:58:06 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |
| 443 | 2020-01-10 18:03:53 | john | 1 | 13983 | 4 | 0.283 | 49409.9 |
| 442 | 2020-01-08 05:12:08 | john | 1 | 13983 | 4 | 0.513 | 27257.3 |
| 441 | 2020-01-03 00:37:30 | john | 1 | 13983 | 4 | 0.250 | 55932.0 |
| 440 | 2019-12-24 05:58:43 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 439 | 2019-12-24 04:21:57 | john | 1 | 13983 | 4 | 0.233 | 60012.9 |
| 438 | 2019-12-24 00:37:50 | john | 1 | 13983 | 4 | 0.216 | 64736.1 |
| 437 | 2019-12-23 14:20:52 | john | 1 | 13983 | 4 | 0.203 | 68881.8 |