History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pirates"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 511 | 2025-04-29 04:34:30 | pirates | 1 | 69583 | 5 | 2.750 | 25302.9 |
| 510 | 2025-04-28 10:29:49 | pirates | 3 | 134027 | 847 | 51.283 | 2613.5 |
| 509 | 2025-04-28 09:22:47 | pirates | 3 | 134027 | 847 | 30.860 | 4343.1 |
| 508 | 2025-04-25 22:56:19 | pirates | 3 | 134027 | 847 | 38.673 | 3465.6 |
| 507 | 2025-04-23 04:00:01 | pirates | 1 | 69583 | 5 | 3.690 | 18857.2 |
| 506 | 2025-04-22 20:19:04 | pirates | 2 | 107671 | 78 | 14.140 | 7614.6 |
| 505 | 2025-04-20 11:20:31 | pirates | 1 | 69583 | 5 | 5.596 | 12434.4 |
| 504 | 2025-04-20 07:51:32 | pirates | 1 | 69583 | 5 | 3.293 | 21130.6 |
| 503 | 2025-04-19 08:22:49 | pirates | 3 | 134027 | 847 | 6.280 | 21341.9 |
| 502 | 2025-04-16 22:52:03 | pirates | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 501 | 2025-04-13 21:37:32 | pirates | 1 | 69583 | 5 | 6.080 | 11444.6 |
| 500 | 2025-04-12 13:33:33 | pirates | 1 | 69583 | 5 | 5.893 | 11807.7 |
| 499 | 2025-03-27 09:06:20 | pirates | 3 | 134027 | 847 | 40.533 | 3306.6 |
| 498 | 2025-03-25 12:25:10 | pirates | 3 | 134027 | 847 | 36.800 | 3642.0 |
| 497 | 2025-03-24 06:36:38 | pirates | 3 | 134027 | 847 | 33.440 | 4008.0 |
| 496 | 2025-03-23 13:35:55 | pirates | 3 | 134027 | 847 | 44.626 | 3003.3 |
| 495 | 2025-03-21 14:03:42 | pirates | 2 | 107671 | 78 | 16.236 | 6631.6 |
| 494 | 2025-03-21 13:06:10 | pirates | 3 | 134027 | 847 | 41.410 | 3236.6 |
| 493 | 2025-03-20 09:01:41 | pirates | 1 | 69583 | 5 | 3.953 | 17602.6 |
| 492 | 2025-03-19 12:49:07 | pirates | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 491 | 2025-03-13 06:33:16 | pirates | 1 | 69583 | 5 | 6.080 | 11444.6 |
| 490 | 2025-03-12 16:45:57 | pirates | 1 | 69583 | 5 | 5.173 | 13451.2 |
| 489 | 2025-03-05 22:43:06 | pirates | 1 | 69583 | 5 | 6.220 | 11187.0 |
| 488 | 2025-02-12 22:34:21 | pirates | 1 | 69583 | 5 | 6.030 | 11539.5 |
| 487 | 2024-12-29 16:31:33 | pirates | 2 | 107671 | 78 | 3.330 | 32333.6 |
| 486 | 2024-12-28 20:02:18 | pirates | 2 | 107671 | 78 | 16.733 | 6434.7 |
| 485 | 2024-12-28 18:35:43 | pirates | 2 | 107671 | 78 | 16.643 | 6469.4 |
| 484 | 2024-12-28 11:29:12 | pirates | 2 | 107671 | 78 | 10.516 | 10238.8 |
| 483 | 2024-12-28 02:41:16 | pirates | 1 | 69583 | 5 | 3.360 | 20709.2 |
| 482 | 2024-12-25 20:40:18 | pirates | 3 | 134027 | 847 | 34.860 | 3844.7 |
| 481 | 2024-12-11 20:15:12 | pirates | 3 | 134027 | 847 | 33.000 | 4061.4 |
| 480 | 2024-12-11 14:09:49 | pirates | 3 | 134027 | 847 | 23.530 | 5696.0 |
| 479 | 2024-12-11 03:47:14 | pirates | 3 | 134027 | 847 | 44.936 | 2982.6 |
| 478 | 2024-12-09 18:57:15 | pirates | 1 | 69583 | 5 | 4.656 | 14944.8 |
| 477 | 2024-12-07 01:18:25 | pirates | 1 | 69583 | 5 | 7.703 | 9033.2 |
| 476 | 2024-11-29 11:26:23 | pirates | 3 | 134027 | 847 | 36.863 | 3635.8 |
| 475 | 2024-11-27 23:16:12 | pirates | 1 | 69583 | 5 | 5.843 | 11908.8 |
| 474 | 2024-11-12 16:29:33 | pirates | 2 | 107671 | 78 | 8.296 | 12978.7 |
| 473 | 2024-11-11 17:27:32 | pirates | 3 | 134027 | 847 | 35.126 | 3815.6 |
| 472 | 2024-11-11 12:27:37 | pirates | 3 | 134027 | 847 | 54.116 | 2476.7 |
| 471 | 2024-11-11 11:08:34 | pirates | 2 | 107671 | 78 | 15.390 | 6996.2 |
| 470 | 2024-11-11 09:43:59 | pirates | 3 | 134027 | 847 | 26.923 | 4978.2 |
| 469 | 2024-11-10 23:07:13 | pirates | 3 | 134027 | 847 | 38.610 | 3471.3 |
| 468 | 2024-11-10 23:07:19 | pirates | 2 | 107671 | 78 | 13.280 | 8107.8 |
| 467 | 2024-11-10 00:38:47 | pirates | 1 | 69583 | 5 | 5.953 | 11688.7 |
| 466 | 2024-11-08 17:13:25 | pirates | 1 | 69583 | 5 | 5.860 | 11874.2 |
| 465 | 2024-10-24 11:52:20 | pirates | 1 | 69583 | 5 | 5.330 | 13055.0 |
| 464 | 2024-10-03 21:10:03 | pirates | 1 | 69583 | 5 | 8.596 | 8094.8 |
| 463 | 2024-10-01 06:40:08 | pirates | 1 | 69583 | 5 | 4.813 | 14457.3 |
| 462 | 2024-09-10 18:29:31 | pirates | 1 | 69583 | 5 | 11.706 | 5944.2 |
| 461 | 2024-09-09 14:55:12 | pirates | 1 | 69583 | 5 | 11.966 | 5815.1 |
| 460 | 2024-09-09 05:18:16 | pirates | 1 | 69583 | 5 | 4.606 | 15107.0 |
| 459 | 2024-09-06 04:05:45 | pirates | 1 | 69583 | 5 | 7.300 | 9531.9 |
| 458 | 2024-08-29 11:25:43 | pirates | 1 | 69583 | 5 | 4.093 | 17000.5 |
| 457 | 2024-08-21 07:42:28 | pirates | 1 | 69583 | 5 | 9.233 | 7536.3 |
| 456 | 2024-08-20 11:09:05 | pirates | 1 | 69583 | 5 | 13.313 | 5226.7 |
| 455 | 2024-08-14 12:39:34 | pirates | 1 | 69583 | 5 | 12.296 | 5659.0 |
| 454 | 2024-08-10 01:51:50 | pirates | 1 | 69583 | 5 | 6.533 | 10651.0 |
| 453 | 2024-08-07 20:05:12 | pirates | 1 | 69583 | 5 | 2.203 | 31585.6 |
| 452 | 2024-08-07 08:17:37 | pirates | 1 | 69583 | 5 | 2.126 | 32729.5 |
| 451 | 2024-08-02 19:17:14 | pirates | 1 | 69583 | 5 | 4.340 | 16032.9 |
| 450 | 2024-07-30 14:57:22 | pirates | 2 | 107671 | 78 | 11.283 | 9542.8 |
| 449 | 2024-07-30 04:34:08 | pirates | 1 | 69583 | 5 | 6.310 | 11027.4 |
| 448 | 2024-07-29 13:23:20 | pirates | 2 | 107671 | 78 | 4.563 | 23596.5 |
| 447 | 2024-07-29 12:53:05 | pirates | 2 | 107671 | 78 | 11.486 | 9374.1 |
| 446 | 2024-07-22 12:28:05 | pirates | 3 | 134027 | 847 | 28.533 | 4697.3 |
| 445 | 2024-07-20 18:29:51 | pirates | 3 | 134027 | 847 | 29.673 | 4516.8 |
| 444 | 2024-07-20 15:14:02 | pirates | 3 | 134027 | 847 | 18.203 | 7362.9 |
| 443 | 2024-07-20 04:06:49 | pirates | 3 | 134027 | 847 | 41.910 | 3198.0 |
| 442 | 2024-07-19 19:48:52 | pirates | 3 | 134027 | 847 | 18.360 | 7299.9 |
| 441 | 2024-07-19 11:02:58 | pirates | 3 | 134027 | 847 | 14.033 | 9550.8 |
| 440 | 2024-07-10 15:54:48 | pirates | 1 | 69583 | 5 | 2.123 | 32775.8 |
| 439 | 2024-07-08 01:00:18 | pirates | 1 | 69583 | 5 | 7.250 | 9597.7 |
| 438 | 2024-07-05 12:48:32 | pirates | 1 | 69583 | 5 | 5.656 | 12302.5 |
| 437 | 2024-07-01 20:09:35 | pirates | 1 | 69583 | 5 | 5.376 | 12943.3 |
| 436 | 2024-06-29 15:47:41 | pirates | 1 | 69583 | 5 | 2.313 | 30083.4 |
| 435 | 2024-06-28 20:02:01 | pirates | 1 | 69583 | 5 | 3.560 | 19545.8 |
| 434 | 2024-06-15 19:54:20 | pirates | 1 | 69583 | 5 | 4.206 | 16543.7 |
| 433 | 2024-06-08 05:18:14 | pirates | 1 | 69583 | 5 | 1.356 | 51314.9 |
| 432 | 2024-05-30 00:30:02 | pirates | 1 | 69583 | 5 | 2.966 | 23460.2 |
| 431 | 2024-05-27 13:00:08 | pirates | 1 | 69583 | 5 | 4.170 | 16686.6 |
| 430 | 2024-05-25 03:45:11 | pirates | 1 | 69583 | 5 | 1.986 | 35036.8 |
| 429 | 2024-05-05 19:15:49 | pirates | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 428 | 2024-04-27 18:53:32 | pirates | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 427 | 2024-04-27 12:08:55 | pirates | 1 | 69583 | 5 | 5.233 | 13297.0 |
| 426 | 2024-04-25 23:57:00 | pirates | 1 | 69583 | 5 | 2.750 | 25302.9 |
| 425 | 2024-04-23 18:31:57 | pirates | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 424 | 2024-03-07 18:48:03 | pirates | 2 | 107671 | 78 | 5.826 | 18481.1 |
| 423 | 2024-03-04 13:52:26 | pirates | 1 | 69583 | 5 | 2.860 | 24329.7 |
| 422 | 2024-02-27 04:46:23 | pirates | 1 | 69583 | 5 | 1.390 | 50059.7 |
| 421 | 2024-01-29 01:42:04 | pirates | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 420 | 2024-01-12 11:12:16 | pirates | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 419 | 2024-01-04 15:59:40 | pirates | 1 | 69583 | 5 | 1.200 | 57985.8 |
| 418 | 2023-12-27 22:30:45 | pirates | 3 | 134027 | 847 | 6.936 | 19323.4 |
| 417 | 2023-12-27 22:30:37 | pirates | 2 | 107671 | 78 | 3.470 | 31029.1 |
| 416 | 2023-12-22 16:37:58 | pirates | 3 | 134027 | 847 | 5.940 | 22563.5 |
| 415 | 2023-12-22 16:35:45 | pirates | 2 | 107671 | 78 | 3.016 | 35699.9 |
| 414 | 2023-12-17 02:20:43 | pirates | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 413 | 2023-12-15 23:59:15 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 412 | 2023-11-28 15:39:27 | pirates | 1 | 69583 | 5 | 1.203 | 57841.2 |