History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pearly"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 472 | 2024-04-27 11:23:07 | pearly | 1 | 48755 | 8 | 0.983 | 49598.2 |
| 471 | 2024-04-14 08:52:28 | pearly | 1 | 48755 | 8 | 3.156 | 15448.4 |
| 470 | 2024-04-01 22:29:04 | pearly | 2 | 82551 | 65 | 2.220 | 37185.1 |
| 469 | 2024-03-28 13:54:39 | pearly | 1 | 48755 | 8 | 0.923 | 52822.3 |
| 468 | 2024-03-01 13:28:41 | pearly | 3 | 112716 | 706 | 11.000 | 10246.9 |
| 467 | 2024-02-28 13:10:17 | pearly | 3 | 112716 | 706 | 9.376 | 12021.8 |
| 466 | 2024-02-27 14:51:13 | pearly | 3 | 112716 | 706 | 5.940 | 18975.8 |
| 465 | 2024-02-27 14:51:07 | pearly | 2 | 82551 | 65 | 2.296 | 35954.3 |
| 464 | 2024-02-27 14:51:05 | pearly | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 463 | 2024-02-04 10:53:18 | pearly | 1 | 48755 | 8 | 0.966 | 50471.0 |
| 462 | 2024-01-31 16:14:28 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 461 | 2023-12-26 17:09:33 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 460 | 2023-12-05 01:28:28 | pearly | 2 | 82551 | 65 | 2.266 | 36430.3 |
| 459 | 2023-12-03 16:25:46 | pearly | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 458 | 2023-12-03 16:25:44 | pearly | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 457 | 2023-11-28 12:20:18 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 456 | 2023-11-25 09:15:53 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 455 | 2023-11-18 08:28:54 | pearly | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 454 | 2023-10-24 08:57:55 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 453 | 2023-10-23 09:14:50 | pearly | 2 | 82551 | 65 | 2.343 | 35233.0 |
| 452 | 2023-10-20 18:36:39 | pearly | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 451 | 2023-10-15 05:56:19 | pearly | 1 | 48755 | 8 | 0.876 | 55656.4 |
| 450 | 2023-10-11 06:46:47 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 449 | 2023-10-04 07:32:01 | pearly | 1 | 48755 | 8 | 0.873 | 55847.7 |
| 448 | 2023-10-02 22:13:48 | pearly | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 447 | 2023-09-24 09:43:54 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 446 | 2023-09-13 11:52:36 | pearly | 1 | 48755 | 8 | 0.860 | 56691.9 |
| 445 | 2023-09-02 11:34:22 | pearly | 2 | 82551 | 65 | 2.423 | 34069.7 |
| 444 | 2023-08-11 21:12:22 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 443 | 2023-06-19 04:44:59 | pearly | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 442 | 2023-05-20 21:11:38 | pearly | 2 | 82551 | 65 | 2.220 | 37185.1 |
| 441 | 2023-05-10 11:36:40 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 440 | 2023-03-04 20:10:27 | pearly | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 439 | 2023-03-03 15:57:57 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 438 | 2023-02-27 10:36:10 | pearly | 2 | 82551 | 65 | 2.140 | 38575.2 |
| 437 | 2022-12-26 23:08:14 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 436 | 2022-12-06 08:07:47 | pearly | 2 | 82551 | 65 | 2.436 | 33887.9 |
| 435 | 2022-11-11 06:04:08 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 434 | 2022-11-07 19:24:31 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 433 | 2022-09-13 17:48:56 | pearly | 1 | 48755 | 8 | 0.763 | 63899.1 |
| 432 | 2022-09-01 06:15:52 | pearly | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 431 | 2022-07-18 09:30:33 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 430 | 2022-07-02 16:56:17 | pearly | 1 | 48755 | 8 | 0.826 | 59025.4 |
| 429 | 2022-06-30 12:01:30 | pearly | 1 | 48755 | 8 | 0.920 | 52994.6 |
| 428 | 2022-04-15 11:42:55 | pearly | 2 | 82551 | 65 | 3.170 | 26041.3 |
| 427 | 2022-03-31 06:54:11 | pearly | 1 | 48755 | 8 | 0.783 | 62266.9 |
| 426 | 2022-03-03 05:51:09 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 425 | 2021-12-20 22:09:30 | pearly | 2 | 82551 | 65 | 2.283 | 36159.0 |
| 424 | 2021-12-18 01:21:33 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 423 | 2021-12-16 19:07:31 | pearly | 1 | 48755 | 8 | 0.876 | 55656.4 |
| 422 | 2021-10-25 02:51:22 | pearly | 1 | 48755 | 8 | 1.703 | 28628.9 |
| 421 | 2021-10-23 02:31:37 | pearly | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 420 | 2021-09-13 03:54:39 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 419 | 2021-09-09 13:24:08 | pearly | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 418 | 2021-08-22 05:43:19 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 417 | 2021-06-08 14:02:42 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 416 | 2021-04-15 17:40:26 | pearly | 1 | 48755 | 8 | 0.796 | 61250.0 |
| 415 | 2021-03-06 08:17:46 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 414 | 2021-01-28 19:36:20 | pearly | 1 | 48755 | 8 | 1.000 | 48755.0 |
| 413 | 2020-12-04 03:25:53 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 412 | 2020-12-01 22:57:18 | pearly | 1 | 48755 | 8 | 0.780 | 62506.4 |
| 411 | 2020-11-04 16:48:33 | pearly | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 410 | 2020-10-24 10:14:38 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 409 | 2020-10-18 07:06:34 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 408 | 2020-08-27 20:51:35 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 407 | 2020-08-16 15:45:37 | pearly | 1 | 48755 | 8 | 0.750 | 65006.7 |
| 406 | 2020-08-10 08:52:30 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 405 | 2020-07-21 23:24:15 | pearly | 1 | 48755 | 8 | 0.813 | 59969.2 |
| 404 | 2020-07-21 18:03:54 | pearly | 1 | 48755 | 8 | 0.843 | 57835.1 |
| 403 | 2020-05-26 07:55:02 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 402 | 2020-04-19 06:27:04 | pearly | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 401 | 2020-03-29 12:59:15 | pearly | 2 | 82551 | 65 | 2.733 | 30205.3 |
| 400 | 2020-03-29 01:20:51 | pearly | 2 | 82551 | 65 | 3.796 | 21746.8 |
| 399 | 2020-03-26 04:46:29 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 398 | 2020-03-26 00:06:35 | pearly | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 397 | 2020-03-24 08:07:08 | pearly | 1 | 48755 | 8 | 1.000 | 48755.0 |
| 396 | 2020-03-23 04:35:59 | pearly | 1 | 48755 | 8 | 0.860 | 56691.9 |
| 395 | 2020-03-22 08:49:11 | pearly | 1 | 48755 | 8 | 0.860 | 56691.9 |
| 394 | 2020-03-18 14:58:37 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 393 | 2020-03-02 05:21:57 | pearly | 1 | 48755 | 8 | 0.830 | 58741.0 |
| 392 | 2020-02-24 10:51:36 | pearly | 1 | 48755 | 8 | 0.903 | 53992.2 |
| 391 | 2020-02-23 02:32:38 | pearly | 1 | 48755 | 8 | 0.876 | 55656.4 |
| 390 | 2020-02-21 14:57:31 | pearly | 1 | 48755 | 8 | 1.016 | 47987.2 |
| 389 | 2020-02-20 07:00:43 | pearly | 1 | 48755 | 8 | 1.843 | 26454.2 |
| 388 | 2020-02-16 18:50:21 | pearly | 1 | 48755 | 8 | 0.903 | 53992.2 |
| 387 | 2020-02-11 06:00:38 | pearly | 1 | 48755 | 8 | 2.986 | 16327.9 |
| 386 | 2020-02-09 03:02:59 | pearly | 1 | 48755 | 8 | 0.766 | 63648.8 |
| 385 | 2020-02-01 06:12:02 | pearly | 1 | 48755 | 8 | 1.810 | 26936.5 |
| 384 | 2020-02-01 04:19:35 | pearly | 1 | 48755 | 8 | 0.970 | 50262.9 |
| 383 | 2020-01-30 01:54:05 | pearly | 1 | 48755 | 8 | 1.423 | 34262.1 |
| 382 | 2020-01-28 09:49:55 | pearly | 1 | 48755 | 8 | 0.783 | 62266.9 |
| 381 | 2020-01-25 08:27:32 | pearly | 1 | 48755 | 8 | 2.940 | 16583.3 |
| 380 | 2020-01-24 08:54:12 | pearly | 1 | 48755 | 8 | 2.220 | 21961.7 |
| 379 | 2020-01-21 22:45:29 | pearly | 1 | 48755 | 8 | 0.953 | 51159.5 |
| 378 | 2020-01-13 08:04:51 | pearly | 1 | 48755 | 8 | 0.906 | 53813.5 |
| 377 | 2020-01-13 06:13:52 | pearly | 1 | 48755 | 8 | 0.890 | 54780.9 |
| 376 | 2020-01-08 10:11:06 | pearly | 1 | 48755 | 8 | 1.890 | 25796.3 |
| 375 | 2020-01-04 19:21:15 | pearly | 2 | 82551 | 65 | 2.860 | 28864.0 |
| 374 | 2020-01-02 11:20:43 | pearly | 1 | 48755 | 8 | 0.920 | 52994.6 |
| 373 | 2019-12-26 19:04:46 | pearly | 1 | 48755 | 8 | 0.826 | 59025.4 |