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 |
| 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 |
| 411 | 2023-11-28 11:58:31 | pirates | 2 | 107671 | 78 | 3.000 | 35890.3 |
| 410 | 2023-11-13 16:50:53 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 409 | 2023-11-02 21:43:13 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 408 | 2023-10-29 23:36:20 | pirates | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 407 | 2023-10-29 18:31:14 | pirates | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 406 | 2023-10-25 13:15:29 | pirates | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 405 | 2023-10-13 06:44:28 | pirates | 2 | 107671 | 78 | 3.143 | 34257.4 |
| 404 | 2023-10-12 22:20:23 | pirates | 1 | 69583 | 5 | 1.300 | 53525.4 |
| 403 | 2023-09-27 06:16:38 | pirates | 1 | 69583 | 5 | 1.390 | 50059.7 |
| 402 | 2023-09-22 17:54:48 | pirates | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 401 | 2023-08-27 13:55:57 | pirates | 2 | 107671 | 78 | 2.876 | 37437.8 |
| 400 | 2023-08-20 18:48:32 | pirates | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 399 | 2023-06-05 15:00:50 | pirates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 398 | 2023-05-20 03:06:58 | pirates | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 397 | 2023-05-15 21:01:27 | pirates | 2 | 107671 | 78 | 2.796 | 38508.9 |
| 396 | 2023-03-15 17:41:34 | pirates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 395 | 2023-02-24 04:13:31 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 394 | 2023-02-23 18:15:51 | pirates | 2 | 107671 | 78 | 3.126 | 34443.7 |
| 393 | 2023-02-20 20:24:27 | pirates | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 392 | 2023-01-02 15:59:32 | pirates | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 391 | 2022-12-04 20:41:01 | pirates | 2 | 107671 | 78 | 2.843 | 37872.3 |
| 390 | 2022-11-07 07:04:14 | pirates | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 389 | 2022-09-24 15:53:11 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 388 | 2022-07-21 12:56:53 | pirates | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 387 | 2022-07-17 19:40:53 | pirates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 386 | 2022-05-07 16:54:59 | pirates | 1 | 69583 | 5 | 1.236 | 56296.9 |
| 385 | 2022-04-18 22:06:32 | pirates | 2 | 107671 | 78 | 3.376 | 31893.1 |
| 384 | 2022-03-27 06:47:04 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 383 | 2022-03-23 22:12:14 | pirates | 1 | 69583 | 5 | 1.436 | 48456.1 |
| 382 | 2022-01-22 09:19:34 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 381 | 2021-12-16 07:13:10 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 380 | 2021-11-22 01:43:14 | pirates | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 379 | 2021-10-01 12:31:15 | pirates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 378 | 2021-09-29 06:31:04 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 377 | 2021-09-12 07:32:41 | pirates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 376 | 2021-08-30 00:30:45 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 375 | 2021-08-27 20:30:00 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 374 | 2021-07-28 02:21:59 | pirates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 373 | 2021-06-12 01:18:01 | pirates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 372 | 2021-05-18 15:19:12 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 371 | 2021-04-18 15:54:59 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 370 | 2021-03-21 11:40:34 | pirates | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 369 | 2021-03-09 00:16:10 | pirates | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 368 | 2021-01-27 07:56:23 | pirates | 2 | 107671 | 78 | 6.033 | 17847.0 |
| 367 | 2020-11-26 20:26:22 | pirates | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 366 | 2020-11-11 11:27:59 | pirates | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 365 | 2020-11-06 23:24:10 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 364 | 2020-11-02 17:54:17 | pirates | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 363 | 2020-10-23 11:01:21 | pirates | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 362 | 2020-10-15 20:36:46 | pirates | 1 | 69583 | 5 | 2.266 | 30707.4 |
| 361 | 2020-08-21 01:10:23 | pirates | 1 | 69583 | 5 | 1.190 | 58473.1 |
| 360 | 2020-08-15 06:15:19 | pirates | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 359 | 2020-08-09 04:26:27 | pirates | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 358 | 2020-05-19 18:14:09 | pirates | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 357 | 2020-05-17 15:51:44 | pirates | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 356 | 2020-03-27 23:39:56 | pirates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 355 | 2020-03-24 22:57:39 | pirates | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 354 | 2020-03-24 14:37:19 | pirates | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 353 | 2020-03-23 15:48:46 | pirates | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 352 | 2020-03-22 13:51:22 | pirates | 1 | 69583 | 5 | 1.643 | 42351.2 |
| 351 | 2020-03-20 01:58:30 | pirates | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 350 | 2020-02-26 20:38:33 | pirates | 1 | 69583 | 5 | 2.703 | 25742.9 |
| 349 | 2020-02-26 19:45:40 | pirates | 1 | 69583 | 5 | 1.310 | 53116.8 |
| 348 | 2020-02-26 03:13:13 | pirates | 1 | 69583 | 5 | 2.766 | 25156.5 |
| 347 | 2020-02-25 15:54:11 | pirates | 1 | 69583 | 5 | 2.533 | 27470.6 |
| 346 | 2020-02-18 20:59:12 | pirates | 1 | 69583 | 5 | 1.313 | 52995.4 |
| 345 | 2020-02-16 19:36:09 | pirates | 1 | 69583 | 5 | 1.440 | 48321.5 |
| 344 | 2020-02-16 15:33:00 | pirates | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 343 | 2020-02-12 10:32:09 | pirates | 1 | 69583 | 5 | 4.123 | 16876.8 |
| 342 | 2020-02-11 23:56:56 | pirates | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 341 | 2020-02-09 18:08:06 | pirates | 1 | 69583 | 5 | 1.326 | 52475.9 |
| 340 | 2020-01-30 20:53:45 | pirates | 1 | 69583 | 5 | 3.500 | 19880.9 |
| 339 | 2020-01-30 20:37:01 | pirates | 1 | 69583 | 5 | 1.703 | 40859.1 |
| 338 | 2020-01-30 06:35:36 | pirates | 1 | 69583 | 5 | 2.610 | 26660.2 |
| 337 | 2020-01-29 17:11:48 | pirates | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 336 | 2020-01-24 00:43:51 | pirates | 1 | 69583 | 5 | 2.326 | 29915.3 |
| 335 | 2020-01-22 07:33:07 | pirates | 1 | 69583 | 5 | 1.343 | 51811.6 |
| 334 | 2020-01-13 04:52:02 | pirates | 1 | 69583 | 5 | 1.860 | 37410.2 |
| 333 | 2020-01-12 05:35:51 | pirates | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 332 | 2020-01-10 12:53:06 | pirates | 1 | 69583 | 5 | 2.076 | 33517.8 |
| 331 | 2020-01-04 13:12:10 | pirates | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 330 | 2020-01-01 08:31:04 | pirates | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 329 | 2019-12-26 10:58:01 | pirates | 1 | 69583 | 5 | 1.346 | 51696.1 |