History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drifts"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 468 | 2024-04-04 21:51:16 | drifts | 1 | 48755 | 6 | 2.856 | 17071.1 |
| 467 | 2024-03-28 18:07:15 | drifts | 1 | 48755 | 6 | 2.843 | 17149.1 |
| 466 | 2024-03-14 10:20:10 | drifts | 3 | 112716 | 733 | 9.330 | 12081.0 |
| 465 | 2024-03-08 04:05:14 | drifts | 3 | 112716 | 733 | 16.813 | 6704.1 |
| 464 | 2024-03-08 04:04:55 | drifts | 2 | 82551 | 64 | 8.780 | 9402.2 |
| 463 | 2024-03-07 23:59:05 | drifts | 3 | 112716 | 733 | 6.156 | 18309.9 |
| 462 | 2024-03-07 03:41:22 | drifts | 3 | 112716 | 733 | 13.453 | 8378.5 |
| 461 | 2024-03-07 03:41:23 | drifts | 2 | 82551 | 64 | 2.966 | 27832.4 |
| 460 | 2024-03-06 20:59:34 | drifts | 1 | 48755 | 6 | 1.123 | 43415.0 |
| 459 | 2024-02-03 06:03:13 | drifts | 1 | 48755 | 6 | 0.923 | 52822.3 |
| 458 | 2024-01-30 19:06:45 | drifts | 1 | 48755 | 6 | 0.923 | 52822.3 |
| 457 | 2024-01-29 15:00:18 | drifts | 2 | 82551 | 64 | 3.673 | 22475.1 |
| 456 | 2024-01-29 14:59:26 | drifts | 3 | 112716 | 733 | 6.030 | 18692.5 |
| 455 | 2024-01-28 18:14:19 | drifts | 2 | 82551 | 64 | 2.080 | 39688.0 |
| 454 | 2024-01-28 18:13:43 | drifts | 3 | 112716 | 733 | 4.763 | 23664.9 |
| 453 | 2024-01-23 19:08:46 | drifts | 3 | 112716 | 733 | 5.250 | 21469.7 |
| 452 | 2024-01-03 20:16:16 | drifts | 3 | 112716 | 733 | 9.470 | 11902.4 |
| 451 | 2024-01-02 20:43:51 | drifts | 1 | 48755 | 6 | 1.046 | 46610.9 |
| 450 | 2024-01-01 10:14:06 | drifts | 2 | 82551 | 64 | 2.356 | 35038.6 |
| 449 | 2023-12-30 12:55:43 | drifts | 3 | 112716 | 733 | 5.110 | 22057.9 |
| 448 | 2023-12-30 12:55:44 | drifts | 2 | 82551 | 64 | 2.500 | 33020.4 |
| 447 | 2023-12-27 23:00:15 | drifts | 2 | 82551 | 64 | 2.373 | 34787.6 |
| 446 | 2023-11-26 09:51:19 | drifts | 1 | 48755 | 6 | 0.763 | 63899.1 |
| 445 | 2023-11-18 22:14:02 | drifts | 3 | 112716 | 733 | 5.500 | 20493.8 |
| 444 | 2023-11-13 19:49:55 | drifts | 3 | 112716 | 733 | 5.266 | 21404.5 |
| 443 | 2023-11-13 16:37:19 | drifts | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 442 | 2023-11-13 11:40:46 | drifts | 1 | 48755 | 6 | 0.830 | 58741.0 |
| 441 | 2023-11-08 10:31:06 | drifts | 3 | 112716 | 733 | 5.670 | 19879.4 |
| 440 | 2023-11-02 15:24:22 | drifts | 3 | 112716 | 733 | 4.623 | 24381.6 |
| 439 | 2023-10-31 09:37:01 | drifts | 1 | 48755 | 6 | 0.780 | 62506.4 |
| 438 | 2023-10-30 16:27:40 | drifts | 1 | 48755 | 6 | 0.830 | 58741.0 |
| 437 | 2023-10-20 05:15:46 | drifts | 1 | 48755 | 6 | 0.763 | 63899.1 |
| 436 | 2023-10-13 22:40:15 | drifts | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 435 | 2023-10-04 23:21:55 | drifts | 1 | 48755 | 6 | 0.736 | 66243.2 |
| 434 | 2023-09-26 01:04:33 | drifts | 1 | 48755 | 6 | 0.736 | 66243.2 |
| 433 | 2023-09-12 10:14:41 | drifts | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 432 | 2023-09-11 03:38:02 | drifts | 1 | 48755 | 6 | 0.826 | 59025.4 |
| 431 | 2023-09-07 09:43:23 | drifts | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 430 | 2023-09-03 19:38:11 | drifts | 1 | 48755 | 6 | 0.830 | 58741.0 |
| 429 | 2023-08-09 23:55:57 | drifts | 3 | 112716 | 733 | 4.623 | 24381.6 |
| 428 | 2023-06-19 03:59:33 | drifts | 1 | 48755 | 6 | 0.736 | 66243.2 |
| 427 | 2023-05-21 11:58:55 | drifts | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 426 | 2023-04-21 02:27:48 | drifts | 3 | 112716 | 733 | 4.610 | 24450.3 |
| 425 | 2023-03-31 23:27:41 | drifts | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 424 | 2023-02-08 09:25:05 | drifts | 1 | 48755 | 6 | 1.423 | 34262.1 |
| 423 | 2023-02-06 04:57:52 | drifts | 3 | 112716 | 733 | 5.203 | 21663.7 |
| 422 | 2023-02-02 16:22:44 | drifts | 3 | 112716 | 733 | 5.626 | 20034.8 |
| 421 | 2023-01-30 07:28:10 | drifts | 3 | 112716 | 733 | 5.250 | 21469.7 |
| 420 | 2023-01-28 08:26:01 | drifts | 3 | 112716 | 733 | 4.610 | 24450.3 |
| 419 | 2023-01-14 13:53:27 | drifts | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 418 | 2023-01-14 03:13:31 | drifts | 3 | 112716 | 733 | 5.076 | 22205.7 |
| 417 | 2022-12-16 18:39:15 | drifts | 3 | 112716 | 733 | 5.330 | 21147.5 |
| 416 | 2022-11-10 10:09:27 | drifts | 3 | 112716 | 733 | 5.063 | 22262.7 |
| 415 | 2022-11-05 21:19:31 | drifts | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 414 | 2022-10-25 10:27:58 | drifts | 1 | 48755 | 6 | 0.843 | 57835.1 |
| 413 | 2022-09-04 08:30:00 | drifts | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 412 | 2022-08-15 08:14:00 | drifts | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 411 | 2022-08-06 23:48:29 | drifts | 1 | 48755 | 6 | 0.716 | 68093.6 |
| 410 | 2022-07-05 19:18:44 | drifts | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 409 | 2022-06-28 17:39:16 | drifts | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 408 | 2022-06-26 12:41:47 | drifts | 1 | 48755 | 6 | 0.826 | 59025.4 |
| 407 | 2022-06-25 13:57:12 | drifts | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 406 | 2022-06-11 15:43:25 | drifts | 3 | 112716 | 733 | 4.706 | 23951.6 |
| 405 | 2022-06-07 08:51:21 | drifts | 3 | 112716 | 733 | 4.626 | 24365.8 |
| 404 | 2022-05-21 20:50:35 | drifts | 3 | 112716 | 733 | 4.750 | 23729.7 |
| 403 | 2022-04-24 12:59:24 | drifts | 3 | 112716 | 733 | 4.953 | 22757.1 |
| 402 | 2022-04-23 11:41:16 | drifts | 3 | 112716 | 733 | 5.766 | 19548.4 |
| 401 | 2022-03-14 23:33:42 | drifts | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 400 | 2022-03-04 20:24:45 | drifts | 3 | 112716 | 733 | 4.626 | 24365.8 |
| 399 | 2022-03-04 00:27:15 | drifts | 3 | 112716 | 733 | 5.156 | 21861.1 |
| 398 | 2022-03-01 11:58:25 | drifts | 1 | 48755 | 6 | 0.983 | 49598.2 |
| 397 | 2022-02-04 02:22:23 | drifts | 3 | 112716 | 733 | 5.703 | 19764.3 |
| 396 | 2021-12-28 14:40:42 | drifts | 3 | 112716 | 733 | 5.360 | 21029.1 |
| 395 | 2021-12-16 08:11:59 | drifts | 1 | 48755 | 6 | 0.766 | 63648.8 |
| 394 | 2021-12-01 06:11:46 | drifts | 1 | 48755 | 6 | 0.813 | 59969.2 |
| 393 | 2021-11-30 15:20:32 | drifts | 3 | 112716 | 733 | 5.750 | 19602.8 |
| 392 | 2021-11-28 15:49:02 | drifts | 3 | 112716 | 733 | 5.406 | 20850.2 |
| 391 | 2021-11-27 18:45:57 | drifts | 1 | 48755 | 6 | 0.783 | 62266.9 |
| 390 | 2021-11-11 10:03:19 | drifts | 3 | 112716 | 733 | 6.516 | 17298.3 |
| 389 | 2021-10-19 09:34:29 | drifts | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 388 | 2021-09-09 18:59:26 | drifts | 3 | 112716 | 733 | 5.110 | 22057.9 |
| 387 | 2021-09-09 06:41:59 | drifts | 1 | 48755 | 6 | 0.906 | 53813.5 |
| 386 | 2021-08-22 15:34:02 | drifts | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 385 | 2021-08-21 12:59:42 | drifts | 1 | 48755 | 6 | 0.733 | 66514.3 |
| 384 | 2021-05-24 03:45:21 | drifts | 1 | 48755 | 6 | 0.876 | 55656.4 |
| 383 | 2021-05-20 22:07:23 | drifts | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 382 | 2021-05-05 14:14:12 | drifts | 3 | 112716 | 733 | 5.326 | 21163.3 |
| 381 | 2021-04-27 06:13:02 | drifts | 1 | 48755 | 6 | 0.720 | 67715.3 |
| 380 | 2021-04-11 04:31:04 | drifts | 1 | 48755 | 6 | 0.860 | 56691.9 |
| 379 | 2021-04-04 13:23:10 | drifts | 1 | 48755 | 6 | 0.796 | 61250.0 |
| 378 | 2021-04-03 17:31:26 | drifts | 3 | 112716 | 733 | 5.000 | 22543.2 |
| 377 | 2021-03-27 08:57:59 | drifts | 1 | 48755 | 6 | 1.453 | 33554.7 |
| 376 | 2021-02-21 23:15:19 | drifts | 3 | 112716 | 733 | 4.733 | 23814.9 |
| 375 | 2021-02-18 10:13:21 | drifts | 1 | 48755 | 6 | 0.750 | 65006.7 |
| 374 | 2021-02-15 21:29:04 | drifts | 3 | 112716 | 733 | 5.313 | 21215.1 |
| 373 | 2021-02-11 21:36:50 | drifts | 3 | 112716 | 733 | 4.843 | 23274.0 |
| 372 | 2021-02-07 05:15:55 | drifts | 3 | 112716 | 733 | 5.173 | 21789.3 |
| 371 | 2021-02-03 04:32:17 | drifts | 3 | 112716 | 733 | 5.216 | 21609.7 |
| 370 | 2021-01-29 19:02:12 | drifts | 3 | 112716 | 733 | 5.080 | 22188.2 |
| 369 | 2021-01-27 15:23:38 | drifts | 3 | 112716 | 733 | 5.500 | 20493.8 |