History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smiles"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 490 | 2024-05-04 19:30:42 | smiles | 1 | 48755 | 12 | 1.890 | 25796.3 |
| 489 | 2024-05-04 16:52:55 | smiles | 1 | 48755 | 12 | 1.190 | 40970.6 |
| 488 | 2024-04-29 08:49:47 | smiles | 1 | 48755 | 12 | 1.060 | 45995.3 |
| 487 | 2024-04-29 08:48:53 | smiles | 1 | 48755 | 12 | 1.860 | 26212.4 |
| 486 | 2024-04-27 18:54:50 | smiles | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 485 | 2024-03-31 18:00:04 | smiles | 1 | 48755 | 12 | 1.906 | 25579.7 |
| 484 | 2024-03-31 17:30:08 | smiles | 1 | 48755 | 12 | 2.810 | 17350.5 |
| 483 | 2024-03-30 23:48:40 | smiles | 2 | 82551 | 157 | 2.576 | 32046.2 |
| 482 | 2024-03-29 05:11:26 | smiles | 2 | 82551 | 157 | 7.453 | 11076.2 |
| 481 | 2024-03-29 05:11:21 | smiles | 1 | 48755 | 12 | 1.953 | 24964.2 |
| 480 | 2024-03-29 05:11:13 | smiles | 2 | 82551 | 157 | 3.920 | 21058.9 |
| 479 | 2024-03-29 05:11:10 | smiles | 1 | 48755 | 12 | 2.673 | 18239.8 |
| 478 | 2024-02-28 10:29:20 | smiles | 1 | 48755 | 12 | 1.533 | 31803.7 |
| 477 | 2024-01-28 23:32:39 | smiles | 1 | 48755 | 12 | 0.876 | 55656.4 |
| 476 | 2024-01-21 07:30:52 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 475 | 2024-01-06 23:36:50 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 474 | 2024-01-01 03:50:46 | smiles | 2 | 82551 | 157 | 2.170 | 38041.9 |
| 473 | 2023-12-26 06:34:19 | smiles | 2 | 82551 | 157 | 2.170 | 38041.9 |
| 472 | 2023-12-19 09:33:55 | smiles | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 471 | 2023-12-16 11:50:44 | smiles | 2 | 82551 | 157 | 2.436 | 33887.9 |
| 470 | 2023-12-15 02:27:57 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 469 | 2023-12-07 01:19:59 | smiles | 1 | 48755 | 12 | 1.013 | 48129.3 |
| 468 | 2023-12-07 01:19:58 | smiles | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 467 | 2023-12-04 15:23:49 | smiles | 1 | 48755 | 12 | 0.826 | 59025.4 |
| 466 | 2023-12-04 15:23:48 | smiles | 1 | 48755 | 12 | 0.893 | 54596.9 |
| 465 | 2023-11-22 05:57:51 | smiles | 1 | 48755 | 12 | 1.766 | 27607.6 |
| 464 | 2023-11-18 17:46:41 | smiles | 2 | 82551 | 157 | 2.343 | 35233.0 |
| 463 | 2023-11-14 04:02:56 | smiles | 1 | 48755 | 12 | 0.873 | 55847.7 |
| 462 | 2023-11-12 03:53:52 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 461 | 2023-10-30 03:59:26 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 460 | 2023-10-29 23:29:00 | smiles | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 459 | 2023-10-21 13:38:52 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 458 | 2023-10-18 21:27:22 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 457 | 2023-10-13 23:19:30 | smiles | 1 | 48755 | 12 | 0.780 | 62506.4 |
| 456 | 2023-10-04 13:27:10 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 455 | 2023-09-26 01:38:43 | smiles | 1 | 48755 | 12 | 0.780 | 62506.4 |
| 454 | 2023-09-23 23:06:52 | smiles | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 453 | 2023-09-22 10:10:43 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 452 | 2023-08-23 12:21:32 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 451 | 2023-06-03 14:29:46 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 450 | 2023-05-22 22:28:43 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 449 | 2023-03-15 04:58:59 | smiles | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 448 | 2023-02-11 20:48:12 | smiles | 1 | 48755 | 12 | 0.736 | 66243.2 |
| 447 | 2023-01-03 23:27:40 | smiles | 1 | 48755 | 12 | 0.733 | 66514.3 |
| 446 | 2022-10-29 00:04:03 | smiles | 1 | 48755 | 12 | 0.830 | 58741.0 |
| 445 | 2022-09-23 11:50:34 | smiles | 1 | 48755 | 12 | 0.830 | 58741.0 |
| 444 | 2022-09-10 21:29:26 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 443 | 2022-09-01 21:56:46 | smiles | 1 | 48755 | 12 | 1.923 | 25353.6 |
| 442 | 2022-08-31 14:12:17 | smiles | 1 | 48755 | 12 | 1.156 | 42175.6 |
| 441 | 2022-08-15 05:54:31 | smiles | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 440 | 2022-08-10 17:18:32 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 439 | 2022-08-03 01:04:06 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 438 | 2022-07-29 13:11:42 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 437 | 2022-07-29 07:05:30 | smiles | 1 | 48755 | 12 | 0.733 | 66514.3 |
| 436 | 2022-07-25 07:19:08 | smiles | 1 | 48755 | 12 | 0.736 | 66243.2 |
| 435 | 2022-07-15 23:38:56 | smiles | 1 | 48755 | 12 | 0.780 | 62506.4 |
| 434 | 2022-07-10 12:08:28 | smiles | 1 | 48755 | 12 | 0.826 | 59025.4 |
| 433 | 2022-07-05 17:23:20 | smiles | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 432 | 2022-07-03 15:40:42 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 431 | 2022-07-02 21:09:52 | smiles | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 430 | 2022-07-01 21:24:52 | smiles | 1 | 48755 | 12 | 0.826 | 59025.4 |
| 429 | 2022-06-17 05:12:05 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 428 | 2022-06-15 22:44:02 | smiles | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 427 | 2022-06-04 04:42:55 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 426 | 2022-05-09 06:35:28 | smiles | 1 | 48755 | 12 | 0.810 | 60191.4 |
| 425 | 2022-05-07 01:36:03 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 424 | 2022-05-04 21:10:27 | smiles | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 423 | 2022-03-08 03:35:35 | smiles | 1 | 48755 | 12 | 0.953 | 51159.5 |
| 422 | 2022-01-26 00:36:04 | smiles | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 421 | 2021-11-29 19:08:26 | smiles | 1 | 48755 | 12 | 1.093 | 44606.6 |
| 420 | 2021-11-24 11:31:26 | smiles | 1 | 48755 | 12 | 0.923 | 52822.3 |
| 419 | 2021-10-11 07:41:37 | smiles | 1 | 48755 | 12 | 0.860 | 56691.9 |
| 418 | 2021-09-09 12:12:25 | smiles | 1 | 48755 | 12 | 0.890 | 54780.9 |
| 417 | 2021-08-22 19:39:09 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 416 | 2021-08-18 03:26:26 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 415 | 2021-08-14 20:01:20 | smiles | 1 | 48755 | 12 | 0.813 | 59969.2 |
| 414 | 2021-06-07 09:54:09 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |
| 413 | 2021-05-14 04:20:49 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 412 | 2021-05-13 10:51:47 | smiles | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 411 | 2021-04-12 07:26:51 | smiles | 1 | 48755 | 12 | 0.876 | 55656.4 |
| 410 | 2021-03-16 05:51:47 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 409 | 2021-02-22 03:48:00 | smiles | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 408 | 2021-02-19 05:44:46 | smiles | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 407 | 2021-02-13 21:07:54 | smiles | 1 | 48755 | 12 | 0.750 | 65006.7 |
| 406 | 2021-02-10 19:29:46 | smiles | 1 | 48755 | 12 | 1.796 | 27146.4 |
| 405 | 2020-11-09 05:25:44 | smiles | 1 | 48755 | 12 | 0.783 | 62266.9 |
| 404 | 2020-10-13 13:38:16 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 403 | 2020-09-11 14:18:12 | smiles | 1 | 48755 | 12 | 0.783 | 62266.9 |
| 402 | 2020-08-08 06:08:12 | smiles | 1 | 48755 | 12 | 0.763 | 63899.1 |
| 401 | 2020-07-31 13:59:28 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 400 | 2020-07-27 11:01:16 | smiles | 1 | 48755 | 12 | 0.876 | 55656.4 |
| 399 | 2020-07-21 14:59:23 | smiles | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 398 | 2020-07-21 03:33:50 | smiles | 1 | 48755 | 12 | 0.953 | 51159.5 |
| 397 | 2020-05-07 22:48:00 | smiles | 1 | 48755 | 12 | 0.780 | 62506.4 |
| 396 | 2020-04-29 03:09:45 | smiles | 1 | 48755 | 12 | 0.766 | 63648.8 |
| 395 | 2020-03-28 00:44:41 | smiles | 1 | 48755 | 12 | 0.920 | 52994.6 |
| 394 | 2020-03-24 05:23:22 | smiles | 1 | 48755 | 12 | 0.906 | 53813.5 |
| 393 | 2020-03-23 17:34:54 | smiles | 1 | 48755 | 12 | 0.906 | 53813.5 |
| 392 | 2020-03-23 03:00:14 | smiles | 1 | 48755 | 12 | 0.796 | 61250.0 |
| 391 | 2020-03-18 16:03:53 | smiles | 1 | 48755 | 12 | 0.843 | 57835.1 |