History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"megapod"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 483 | 2024-04-27 09:42:20 | megapod | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 482 | 2024-04-10 21:06:23 | megapod | 4 | 151207 | 795 | 17.983 | 8408.3 |
| 481 | 2024-04-10 02:24:25 | megapod | 3 | 134027 | 67 | 7.686 | 17437.8 |
| 480 | 2024-04-09 20:00:32 | megapod | 4 | 151207 | 795 | 18.330 | 8249.2 |
| 479 | 2024-04-08 22:15:53 | megapod | 4 | 151207 | 795 | 41.266 | 3664.2 |
| 478 | 2024-04-08 12:37:00 | megapod | 4 | 151207 | 795 | 14.423 | 10483.7 |
| 477 | 2024-04-08 09:36:04 | megapod | 4 | 151207 | 795 | 14.143 | 10691.3 |
| 476 | 2024-04-08 09:33:30 | megapod | 3 | 134027 | 67 | 18.893 | 7094.0 |
| 475 | 2024-04-08 08:10:04 | megapod | 3 | 134027 | 67 | 17.876 | 7497.6 |
| 474 | 2024-04-08 08:10:04 | megapod | 4 | 151207 | 795 | 14.076 | 10742.2 |
| 473 | 2024-04-08 08:10:04 | megapod | 1 | 69583 | 3 | 4.220 | 16488.9 |
| 472 | 2024-04-08 08:10:03 | megapod | 2 | 107671 | 8 | 3.906 | 27565.5 |
| 471 | 2024-03-31 08:34:58 | megapod | 1 | 69583 | 3 | 4.376 | 15901.1 |
| 470 | 2024-03-12 01:02:13 | megapod | 4 | 151207 | 795 | 19.656 | 7692.7 |
| 469 | 2024-03-10 14:46:16 | megapod | 4 | 151207 | 795 | 32.206 | 4695.0 |
| 468 | 2024-03-10 03:12:15 | megapod | 4 | 151207 | 795 | 28.593 | 5288.3 |
| 467 | 2024-03-05 17:45:28 | megapod | 3 | 134027 | 67 | 22.456 | 5968.4 |
| 466 | 2024-03-04 14:26:41 | megapod | 1 | 69583 | 3 | 2.733 | 25460.3 |
| 465 | 2024-03-04 14:21:09 | megapod | 1 | 69583 | 3 | 2.060 | 33778.2 |
| 464 | 2024-03-04 14:13:59 | megapod | 2 | 107671 | 8 | 6.483 | 16608.2 |
| 463 | 2024-03-04 02:41:04 | megapod | 2 | 107671 | 8 | 3.516 | 30623.2 |
| 462 | 2024-03-04 02:39:48 | megapod | 3 | 134027 | 67 | 7.813 | 17154.4 |
| 461 | 2024-03-01 16:21:29 | megapod | 3 | 134027 | 67 | 17.843 | 7511.5 |
| 460 | 2024-03-01 15:17:50 | megapod | 4 | 151207 | 795 | 33.750 | 4480.2 |
| 459 | 2024-02-28 03:55:57 | megapod | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 458 | 2024-02-26 08:21:53 | megapod | 4 | 151207 | 795 | 17.110 | 8837.3 |
| 457 | 2024-02-26 08:21:53 | megapod | 3 | 134027 | 67 | 6.890 | 19452.4 |
| 456 | 2024-02-26 08:21:45 | megapod | 2 | 107671 | 8 | 3.360 | 32044.9 |
| 455 | 2024-02-24 02:51:54 | megapod | 2 | 107671 | 8 | 3.296 | 32667.2 |
| 454 | 2024-02-07 22:51:35 | megapod | 4 | 151207 | 795 | 27.906 | 5418.4 |
| 453 | 2024-02-05 23:24:14 | megapod | 4 | 151207 | 795 | 12.970 | 11658.2 |
| 452 | 2024-01-26 05:52:03 | megapod | 4 | 151207 | 795 | 12.656 | 11947.5 |
| 451 | 2024-01-24 11:39:58 | megapod | 1 | 69583 | 3 | 2.360 | 29484.3 |
| 450 | 2024-01-16 07:22:14 | megapod | 4 | 151207 | 795 | 11.296 | 13385.9 |
| 449 | 2024-01-16 07:22:15 | megapod | 3 | 134027 | 67 | 6.876 | 19492.0 |
| 448 | 2024-01-16 07:22:13 | megapod | 2 | 107671 | 8 | 3.186 | 33795.0 |
| 447 | 2024-01-10 17:16:45 | megapod | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 446 | 2023-12-26 21:37:20 | megapod | 3 | 134027 | 67 | 6.690 | 20033.9 |
| 445 | 2023-11-27 23:01:31 | megapod | 4 | 151207 | 795 | 10.486 | 14419.9 |
| 444 | 2023-11-25 05:30:38 | megapod | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 443 | 2023-11-19 07:50:58 | megapod | 2 | 107671 | 8 | 2.813 | 38276.2 |
| 442 | 2023-11-17 18:48:57 | megapod | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 441 | 2023-11-09 01:51:34 | megapod | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 440 | 2023-11-05 18:13:32 | megapod | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 439 | 2023-11-03 09:26:44 | megapod | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 438 | 2023-10-26 17:17:31 | megapod | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 437 | 2023-10-15 02:12:43 | megapod | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 436 | 2023-10-09 20:08:37 | megapod | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 435 | 2023-09-30 21:59:00 | megapod | 3 | 134027 | 67 | 12.296 | 10900.0 |
| 434 | 2023-09-29 18:54:31 | megapod | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 433 | 2023-09-27 18:07:34 | megapod | 3 | 134027 | 67 | 5.796 | 23124.1 |
| 432 | 2023-09-14 19:37:56 | megapod | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 431 | 2023-08-28 05:05:14 | megapod | 4 | 151207 | 795 | 10.486 | 14419.9 |
| 430 | 2023-08-26 08:13:40 | megapod | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 429 | 2023-08-20 09:34:48 | megapod | 2 | 107671 | 8 | 3.000 | 35890.3 |
| 428 | 2023-07-29 23:02:23 | megapod | 4 | 151207 | 795 | 11.126 | 13590.4 |
| 427 | 2023-07-08 04:25:22 | megapod | 3 | 134027 | 67 | 5.670 | 23637.9 |
| 426 | 2023-07-02 21:14:18 | megapod | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 425 | 2023-06-15 13:10:01 | megapod | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 424 | 2023-05-27 22:26:17 | megapod | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 423 | 2023-05-27 07:50:15 | megapod | 4 | 151207 | 795 | 10.516 | 14378.8 |
| 422 | 2023-05-13 00:54:46 | megapod | 4 | 151207 | 795 | 9.736 | 15530.7 |
| 421 | 2023-05-04 08:55:57 | megapod | 2 | 107671 | 8 | 2.763 | 38968.9 |
| 420 | 2023-04-27 07:07:59 | megapod | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 419 | 2023-04-17 16:55:58 | megapod | 4 | 151207 | 795 | 10.673 | 14167.2 |
| 418 | 2023-04-04 07:26:48 | megapod | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 417 | 2023-03-31 03:52:15 | megapod | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 416 | 2023-03-24 20:43:43 | megapod | 3 | 134027 | 67 | 5.610 | 23890.7 |
| 415 | 2023-03-24 12:54:53 | megapod | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 414 | 2023-03-16 18:01:13 | megapod | 4 | 151207 | 795 | 9.766 | 15483.0 |
| 413 | 2023-03-03 04:21:44 | megapod | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 412 | 2023-02-17 15:07:05 | megapod | 4 | 151207 | 795 | 10.950 | 13808.9 |
| 411 | 2023-02-09 07:25:46 | megapod | 2 | 107671 | 8 | 2.813 | 38276.2 |
| 410 | 2023-01-10 05:31:44 | megapod | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 409 | 2022-12-23 20:33:32 | megapod | 3 | 134027 | 67 | 5.610 | 23890.7 |
| 408 | 2022-11-27 22:17:57 | megapod | 4 | 151207 | 795 | 10.440 | 14483.4 |
| 407 | 2022-11-20 22:21:20 | megapod | 2 | 107671 | 8 | 2.890 | 37256.4 |
| 406 | 2022-10-20 12:00:23 | megapod | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 405 | 2022-10-12 06:43:38 | megapod | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 404 | 2022-08-21 08:14:15 | megapod | 3 | 134027 | 67 | 6.986 | 19185.1 |
| 403 | 2022-07-04 10:57:09 | megapod | 4 | 151207 | 795 | 9.690 | 15604.4 |
| 402 | 2022-06-24 18:20:14 | megapod | 2 | 107671 | 8 | 2.860 | 37647.2 |
| 401 | 2022-06-08 01:17:38 | megapod | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 400 | 2022-05-29 15:32:07 | megapod | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 399 | 2022-02-15 04:04:34 | megapod | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 398 | 2022-02-12 22:50:19 | megapod | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 397 | 2022-01-31 06:22:41 | megapod | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 396 | 2021-12-29 00:15:01 | megapod | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 395 | 2021-12-19 03:53:04 | megapod | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 394 | 2021-12-17 02:11:45 | megapod | 1 | 69583 | 3 | 1.143 | 60877.5 |
| 393 | 2021-11-19 14:07:46 | megapod | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 392 | 2021-10-04 17:38:27 | megapod | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 391 | 2021-07-02 12:45:45 | megapod | 4 | 151207 | 795 | 12.923 | 11700.6 |
| 390 | 2021-06-29 02:03:11 | megapod | 4 | 151207 | 795 | 11.033 | 13705.0 |
| 389 | 2021-06-06 05:50:42 | megapod | 4 | 151207 | 795 | 10.050 | 15045.5 |
| 388 | 2021-05-12 06:06:06 | megapod | 4 | 151207 | 795 | 9.783 | 15456.1 |
| 387 | 2021-05-08 06:04:28 | megapod | 3 | 134027 | 67 | 7.890 | 16986.9 |
| 386 | 2021-05-05 23:37:13 | megapod | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 385 | 2021-05-02 18:18:26 | megapod | 4 | 151207 | 795 | 11.893 | 12713.9 |
| 384 | 2021-05-02 15:48:09 | megapod | 1 | 69583 | 3 | 1.313 | 52995.4 |