History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lenses"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 519 | 2024-04-27 19:45:49 | lenses | 1 | 48755 | 11 | 1.046 | 46610.9 |
| 518 | 2024-04-25 23:10:16 | lenses | 1 | 48755 | 11 | 1.016 | 47987.2 |
| 517 | 2024-04-25 12:18:54 | lenses | 1 | 48755 | 11 | 1.890 | 25796.3 |
| 516 | 2024-04-09 21:53:16 | lenses | 1 | 48755 | 11 | 1.343 | 36303.1 |
| 515 | 2024-04-03 11:55:25 | lenses | 1 | 48755 | 11 | 1.893 | 25755.4 |
| 514 | 2024-03-04 07:34:42 | lenses | 1 | 48755 | 11 | 2.216 | 22001.4 |
| 513 | 2024-02-03 06:15:13 | lenses | 1 | 48755 | 11 | 1.923 | 25353.6 |
| 512 | 2024-01-10 16:03:36 | lenses | 2 | 82551 | 151 | 2.220 | 37185.1 |
| 511 | 2024-01-10 02:21:49 | lenses | 1 | 48755 | 11 | 0.826 | 59025.4 |
| 510 | 2023-12-28 04:44:37 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 509 | 2023-12-26 01:13:20 | lenses | 2 | 82551 | 151 | 2.156 | 38289.0 |
| 508 | 2023-12-05 08:43:49 | lenses | 2 | 82551 | 151 | 2.440 | 33832.4 |
| 507 | 2023-11-26 14:55:43 | lenses | 1 | 48755 | 11 | 0.780 | 62506.4 |
| 506 | 2023-11-19 08:56:32 | lenses | 1 | 48755 | 11 | 0.736 | 66243.2 |
| 505 | 2023-11-17 21:08:43 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 504 | 2023-11-16 12:35:38 | lenses | 2 | 82551 | 151 | 2.153 | 38342.3 |
| 503 | 2023-11-12 11:45:53 | lenses | 1 | 48755 | 11 | 0.780 | 62506.4 |
| 502 | 2023-11-10 09:39:25 | lenses | 1 | 48755 | 11 | 0.733 | 66514.3 |
| 501 | 2023-10-26 22:22:26 | lenses | 1 | 48755 | 11 | 0.736 | 66243.2 |
| 500 | 2023-10-20 14:53:14 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 499 | 2023-10-17 22:11:30 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 498 | 2023-10-17 12:04:34 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 497 | 2023-10-12 08:32:53 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 496 | 2023-10-04 03:50:09 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 495 | 2023-09-27 09:49:48 | lenses | 2 | 82551 | 151 | 2.470 | 33421.5 |
| 494 | 2023-09-26 01:52:45 | lenses | 1 | 48755 | 11 | 0.890 | 54780.9 |
| 493 | 2023-09-20 19:18:11 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 492 | 2023-08-14 05:02:31 | lenses | 1 | 48755 | 11 | 0.810 | 60191.4 |
| 491 | 2023-08-06 09:12:16 | lenses | 1 | 48755 | 11 | 0.780 | 62506.4 |
| 490 | 2023-07-08 16:33:26 | lenses | 2 | 82551 | 151 | 2.156 | 38289.0 |
| 489 | 2023-05-16 06:50:00 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 488 | 2023-04-25 03:35:41 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 487 | 2023-03-28 23:32:04 | lenses | 2 | 82551 | 151 | 2.093 | 39441.5 |
| 486 | 2023-03-11 22:19:09 | lenses | 1 | 48755 | 11 | 0.733 | 66514.3 |
| 485 | 2023-01-09 01:32:01 | lenses | 1 | 48755 | 11 | 0.720 | 67715.3 |
| 484 | 2023-01-01 12:43:44 | lenses | 1 | 48755 | 11 | 0.736 | 66243.2 |
| 483 | 2022-12-26 07:37:37 | lenses | 2 | 82551 | 151 | 2.110 | 39123.7 |
| 482 | 2022-09-25 06:24:22 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 481 | 2022-09-19 19:02:49 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 480 | 2022-09-19 15:03:59 | lenses | 1 | 48755 | 11 | 0.813 | 59969.2 |
| 479 | 2022-09-18 11:18:49 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 478 | 2022-09-10 10:01:41 | lenses | 1 | 48755 | 11 | 0.826 | 59025.4 |
| 477 | 2022-09-09 11:08:31 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 476 | 2022-09-03 19:33:49 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 475 | 2022-09-01 11:40:08 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 474 | 2022-08-26 11:59:19 | lenses | 2 | 82551 | 151 | 2.156 | 38289.0 |
| 473 | 2022-08-23 16:49:38 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 472 | 2022-08-15 10:26:32 | lenses | 1 | 48755 | 11 | 0.733 | 66514.3 |
| 471 | 2022-08-14 23:20:49 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 470 | 2022-08-14 03:18:08 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 469 | 2022-08-06 11:44:53 | lenses | 1 | 48755 | 11 | 0.796 | 61250.0 |
| 468 | 2022-08-01 12:22:26 | lenses | 1 | 48755 | 11 | 1.156 | 42175.6 |
| 467 | 2022-07-10 02:58:43 | lenses | 1 | 48755 | 11 | 0.780 | 62506.4 |
| 466 | 2022-06-19 06:53:50 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 465 | 2022-05-02 11:58:22 | lenses | 1 | 48755 | 11 | 0.840 | 58041.7 |
| 464 | 2022-03-13 20:39:42 | lenses | 1 | 48755 | 11 | 0.763 | 63899.1 |
| 463 | 2022-01-23 16:30:30 | lenses | 1 | 48755 | 11 | 0.796 | 61250.0 |
| 462 | 2022-01-21 12:22:04 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 461 | 2021-12-10 02:05:41 | lenses | 1 | 48755 | 11 | 1.763 | 27654.6 |
| 460 | 2021-12-06 19:36:00 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 459 | 2021-11-17 02:22:48 | lenses | 1 | 48755 | 11 | 0.780 | 62506.4 |
| 458 | 2021-10-02 19:27:17 | lenses | 1 | 48755 | 11 | 0.873 | 55847.7 |
| 457 | 2021-09-30 16:03:41 | lenses | 1 | 48755 | 11 | 0.906 | 53813.5 |
| 456 | 2021-09-02 18:00:53 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 455 | 2021-08-24 19:51:44 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 454 | 2021-08-22 15:29:56 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 453 | 2021-05-29 18:26:16 | lenses | 1 | 48755 | 11 | 0.906 | 53813.5 |
| 452 | 2021-05-27 01:46:52 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 451 | 2021-05-01 06:42:27 | lenses | 1 | 48755 | 11 | 0.890 | 54780.9 |
| 450 | 2021-02-27 00:36:55 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 449 | 2021-01-14 05:49:08 | lenses | 1 | 48755 | 11 | 0.826 | 59025.4 |
| 448 | 2020-11-22 07:55:09 | lenses | 1 | 48755 | 11 | 0.826 | 59025.4 |
| 447 | 2020-10-30 21:36:54 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 446 | 2020-10-21 21:01:44 | lenses | 1 | 48755 | 11 | 0.810 | 60191.4 |
| 445 | 2020-10-16 22:03:06 | lenses | 1 | 48755 | 11 | 0.783 | 62266.9 |
| 444 | 2020-10-01 10:02:14 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 443 | 2020-09-05 11:30:37 | lenses | 1 | 48755 | 11 | 0.736 | 66243.2 |
| 442 | 2020-08-19 22:50:20 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 441 | 2020-08-18 02:17:49 | lenses | 1 | 48755 | 11 | 0.780 | 62506.4 |
| 440 | 2020-08-01 18:20:35 | lenses | 1 | 48755 | 11 | 0.873 | 55847.7 |
| 439 | 2020-05-16 20:32:24 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 438 | 2020-05-15 01:28:12 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 437 | 2020-03-26 11:56:59 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 436 | 2020-03-26 05:23:00 | lenses | 1 | 48755 | 11 | 0.843 | 57835.1 |
| 435 | 2020-03-24 18:05:24 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 434 | 2020-03-23 13:49:27 | lenses | 1 | 48755 | 11 | 2.876 | 16952.4 |
| 433 | 2020-03-22 02:51:05 | lenses | 1 | 48755 | 11 | 1.016 | 47987.2 |
| 432 | 2020-03-18 09:35:45 | lenses | 1 | 48755 | 11 | 0.750 | 65006.7 |
| 431 | 2020-02-25 09:23:32 | lenses | 1 | 48755 | 11 | 0.953 | 51159.5 |
| 430 | 2020-02-25 08:13:33 | lenses | 1 | 48755 | 11 | 0.890 | 54780.9 |
| 429 | 2020-02-23 23:41:49 | lenses | 1 | 48755 | 11 | 0.860 | 56691.9 |
| 428 | 2020-02-23 16:40:49 | lenses | 2 | 82551 | 151 | 7.830 | 10542.9 |
| 427 | 2020-02-23 04:41:12 | lenses | 2 | 82551 | 151 | 2.766 | 29844.9 |
| 426 | 2020-02-23 02:16:31 | lenses | 2 | 82551 | 151 | 2.920 | 28270.9 |
| 425 | 2020-02-23 00:27:32 | lenses | 2 | 82551 | 151 | 2.766 | 29844.9 |
| 424 | 2020-02-22 06:40:53 | lenses | 1 | 48755 | 11 | 0.936 | 52088.7 |
| 423 | 2020-02-18 03:33:20 | lenses | 1 | 48755 | 11 | 0.873 | 55847.7 |
| 422 | 2020-02-14 01:27:12 | lenses | 1 | 48755 | 11 | 0.766 | 63648.8 |
| 421 | 2020-02-10 05:50:44 | lenses | 1 | 48755 | 11 | 0.903 | 53992.2 |
| 420 | 2020-01-30 05:19:00 | lenses | 1 | 48755 | 11 | 0.873 | 55847.7 |