History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefect"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 485 | 2025-11-21 01:57:14 | prefect | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 484 | 2025-10-29 13:04:11 | prefect | 1 | 69583 | 6 | 3.670 | 18959.9 |
| 483 | 2025-10-29 05:15:47 | prefect | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 482 | 2025-10-26 05:20:16 | prefect | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 481 | 2025-10-25 21:49:55 | prefect | 2 | 107671 | 37 | 5.906 | 18230.8 |
| 480 | 2025-09-30 11:18:55 | prefect | 2 | 107671 | 37 | 3.326 | 32372.5 |
| 479 | 2025-09-28 22:09:57 | prefect | 3 | 134027 | 229 | 6.736 | 19897.1 |
| 478 | 2025-09-21 06:30:45 | prefect | 2 | 107671 | 37 | 4.486 | 24001.6 |
| 477 | 2025-09-18 22:44:18 | prefect | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 476 | 2025-09-18 19:37:33 | prefect | 3 | 134027 | 229 | 7.000 | 19146.7 |
| 475 | 2025-09-17 12:36:51 | prefect | 3 | 134027 | 229 | 6.656 | 20136.3 |
| 474 | 2025-08-29 09:58:43 | prefect | 3 | 134027 | 229 | 7.000 | 19146.7 |
| 473 | 2025-08-27 03:01:11 | prefect | 3 | 134027 | 229 | 6.393 | 20964.6 |
| 472 | 2025-08-26 22:31:09 | prefect | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 471 | 2025-08-24 20:59:40 | prefect | 1 | 69583 | 6 | 6.376 | 10913.3 |
| 470 | 2025-08-24 14:26:51 | prefect | 1 | 69583 | 6 | 5.703 | 12201.1 |
| 469 | 2025-08-24 08:57:27 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 468 | 2025-08-23 23:18:27 | prefect | 2 | 107671 | 37 | 9.220 | 11678.0 |
| 467 | 2025-08-22 21:10:06 | prefect | 3 | 134027 | 229 | 36.376 | 3684.5 |
| 466 | 2025-08-22 16:21:14 | prefect | 2 | 107671 | 37 | 2.910 | 37000.3 |
| 465 | 2025-08-22 15:25:16 | prefect | 2 | 107671 | 37 | 3.500 | 30763.1 |
| 464 | 2025-08-21 20:24:53 | prefect | 2 | 107671 | 37 | 3.466 | 31064.9 |
| 463 | 2025-08-20 07:19:18 | prefect | 2 | 107671 | 37 | 6.406 | 16807.8 |
| 462 | 2025-08-18 18:58:00 | prefect | 3 | 134027 | 229 | 18.733 | 7154.6 |
| 461 | 2025-08-17 16:19:43 | prefect | 3 | 134027 | 229 | 15.953 | 8401.4 |
| 460 | 2025-08-15 14:24:06 | prefect | 3 | 134027 | 229 | 15.516 | 8638.0 |
| 459 | 2025-08-14 13:47:45 | prefect | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 458 | 2025-08-13 15:13:08 | prefect | 3 | 134027 | 229 | 17.706 | 7569.6 |
| 457 | 2025-08-12 22:16:49 | prefect | 1 | 69583 | 6 | 4.440 | 15671.8 |
| 456 | 2025-08-11 08:27:17 | prefect | 1 | 69583 | 6 | 5.780 | 12038.6 |
| 455 | 2025-08-11 05:41:39 | prefect | 1 | 69583 | 6 | 8.753 | 7949.6 |
| 454 | 2025-08-01 16:54:45 | prefect | 1 | 69583 | 6 | 5.560 | 12514.9 |
| 453 | 2025-08-01 12:55:53 | prefect | 2 | 107671 | 37 | 13.013 | 8274.1 |
| 452 | 2025-07-31 05:29:31 | prefect | 1 | 69583 | 6 | 1.263 | 55093.4 |
| 451 | 2025-07-27 00:24:50 | prefect | 1 | 69583 | 6 | 4.783 | 14548.0 |
| 450 | 2025-07-26 18:48:52 | prefect | 1 | 69583 | 6 | 4.330 | 16070.0 |
| 449 | 2025-07-25 00:12:33 | prefect | 1 | 69583 | 6 | 5.030 | 13833.6 |
| 448 | 2025-07-23 17:36:32 | prefect | 1 | 69583 | 6 | 4.016 | 17326.4 |
| 447 | 2025-07-22 21:46:10 | prefect | 1 | 69583 | 6 | 3.780 | 18408.2 |
| 446 | 2025-07-22 02:55:59 | prefect | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 445 | 2025-07-16 08:25:22 | prefect | 1 | 69583 | 6 | 6.140 | 11332.7 |
| 444 | 2025-07-16 03:57:22 | prefect | 1 | 69583 | 6 | 2.766 | 25156.5 |
| 443 | 2025-07-13 13:57:18 | prefect | 3 | 134027 | 229 | 6.826 | 19634.8 |
| 442 | 2025-07-11 09:36:02 | prefect | 3 | 134027 | 229 | 41.003 | 3268.7 |
| 441 | 2025-07-10 21:44:07 | prefect | 1 | 69583 | 6 | 6.253 | 11127.9 |
| 440 | 2025-07-10 10:38:19 | prefect | 1 | 69583 | 6 | 1.766 | 39401.5 |
| 439 | 2025-07-08 20:00:11 | prefect | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 438 | 2025-06-28 05:10:55 | prefect | 1 | 69583 | 6 | 6.016 | 11566.3 |
| 437 | 2025-06-22 14:30:41 | prefect | 1 | 69583 | 6 | 2.643 | 26327.3 |
| 436 | 2025-06-21 22:47:38 | prefect | 1 | 69583 | 6 | 5.906 | 11781.7 |
| 435 | 2025-06-15 23:14:19 | prefect | 1 | 69583 | 6 | 5.390 | 12909.6 |
| 434 | 2025-06-14 13:55:52 | prefect | 1 | 69583 | 6 | 7.530 | 9240.8 |
| 433 | 2025-06-10 14:10:34 | prefect | 1 | 69583 | 6 | 9.656 | 7206.2 |
| 432 | 2025-06-10 10:00:06 | prefect | 1 | 69583 | 6 | 3.593 | 19366.3 |
| 431 | 2025-06-10 04:23:14 | prefect | 1 | 69583 | 6 | 4.656 | 14944.8 |
| 430 | 2025-05-30 02:48:32 | prefect | 1 | 69583 | 6 | 2.940 | 23667.7 |
| 429 | 2025-05-26 05:46:34 | prefect | 1 | 69583 | 6 | 4.660 | 14932.0 |
| 428 | 2025-05-23 08:43:35 | prefect | 1 | 69583 | 6 | 1.703 | 40859.1 |
| 427 | 2025-05-15 23:32:48 | prefect | 1 | 69583 | 6 | 3.293 | 21130.6 |
| 426 | 2025-05-13 09:03:09 | prefect | 1 | 69583 | 6 | 1.736 | 40082.4 |
| 425 | 2025-05-13 04:39:57 | prefect | 1 | 69583 | 6 | 5.593 | 12441.1 |
| 424 | 2025-05-10 13:52:09 | prefect | 1 | 69583 | 6 | 6.940 | 10026.4 |
| 423 | 2025-05-10 04:22:06 | prefect | 1 | 69583 | 6 | 6.126 | 11358.6 |
| 422 | 2025-05-07 15:18:12 | prefect | 1 | 69583 | 6 | 1.280 | 54361.7 |
| 421 | 2025-05-02 13:30:21 | prefect | 1 | 69583 | 6 | 3.296 | 21111.3 |
| 420 | 2025-04-26 08:06:50 | prefect | 3 | 134027 | 229 | 18.086 | 7410.5 |
| 419 | 2025-04-23 16:57:05 | prefect | 3 | 134027 | 229 | 45.720 | 2931.5 |
| 418 | 2025-04-22 23:01:42 | prefect | 3 | 134027 | 229 | 28.423 | 4715.4 |
| 417 | 2025-04-22 16:56:56 | prefect | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 416 | 2025-04-20 20:58:41 | prefect | 3 | 134027 | 229 | 32.563 | 4115.9 |
| 415 | 2025-04-19 21:10:49 | prefect | 1 | 69583 | 6 | 5.640 | 12337.4 |
| 414 | 2025-04-19 02:19:24 | prefect | 1 | 69583 | 6 | 1.856 | 37490.8 |
| 413 | 2025-04-09 03:56:20 | prefect | 1 | 69583 | 6 | 2.686 | 25905.8 |
| 412 | 2025-04-03 05:42:13 | prefect | 1 | 69583 | 6 | 1.283 | 54234.6 |
| 411 | 2025-03-19 22:07:02 | prefect | 1 | 69583 | 6 | 4.233 | 16438.2 |
| 410 | 2025-03-19 08:29:06 | prefect | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 409 | 2025-03-18 12:52:36 | prefect | 1 | 69583 | 6 | 4.343 | 16021.9 |
| 408 | 2025-03-14 09:04:42 | prefect | 1 | 69583 | 6 | 5.670 | 12272.1 |
| 407 | 2025-03-06 20:01:31 | prefect | 1 | 69583 | 6 | 8.486 | 8199.7 |
| 406 | 2025-03-02 15:39:30 | prefect | 1 | 69583 | 6 | 5.873 | 11847.9 |
| 405 | 2025-02-12 11:57:30 | prefect | 1 | 69583 | 6 | 5.843 | 11908.8 |
| 404 | 2025-02-08 08:44:15 | prefect | 1 | 69583 | 6 | 6.110 | 11388.4 |
| 403 | 2025-01-24 09:00:25 | prefect | 1 | 69583 | 6 | 5.986 | 11624.3 |
| 402 | 2025-01-06 01:30:04 | prefect | 1 | 69583 | 6 | 4.563 | 15249.4 |
| 401 | 2024-12-30 03:55:45 | prefect | 1 | 69583 | 6 | 6.593 | 10554.1 |
| 400 | 2024-12-13 15:05:54 | prefect | 1 | 69583 | 6 | 3.546 | 19623.0 |
| 399 | 2024-12-07 14:13:13 | prefect | 3 | 134027 | 229 | 16.610 | 8069.1 |
| 398 | 2024-12-07 12:52:19 | prefect | 3 | 134027 | 229 | 7.233 | 18529.9 |
| 397 | 2024-12-07 03:47:48 | prefect | 2 | 107671 | 37 | 3.233 | 33303.7 |
| 396 | 2024-12-06 22:48:12 | prefect | 3 | 134027 | 229 | 41.910 | 3198.0 |
| 395 | 2024-12-06 22:48:14 | prefect | 2 | 107671 | 37 | 32.673 | 3295.4 |
| 394 | 2024-12-06 22:47:53 | prefect | 1 | 69583 | 6 | 4.440 | 15671.8 |
| 393 | 2024-11-29 02:47:39 | prefect | 1 | 69583 | 6 | 5.796 | 12005.3 |
| 392 | 2024-11-12 00:49:54 | prefect | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 391 | 2024-11-10 07:10:34 | prefect | 1 | 69583 | 6 | 6.266 | 11104.9 |
| 390 | 2024-11-04 19:54:06 | prefect | 2 | 107671 | 37 | 6.703 | 16063.1 |
| 389 | 2024-10-30 05:31:41 | prefect | 2 | 107671 | 37 | 16.173 | 6657.5 |
| 388 | 2024-10-29 14:17:15 | prefect | 2 | 107671 | 37 | 16.610 | 6482.3 |
| 387 | 2024-10-29 14:11:12 | prefect | 1 | 69583 | 6 | 2.890 | 24077.2 |
| 386 | 2024-10-23 05:10:04 | prefect | 3 | 134027 | 229 | 33.940 | 3948.9 |