History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"threats"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 435 | 2024-04-08 10:51:56 | threats | 1 | 69583 | 6 | 1.220 | 57035.2 |
| 434 | 2024-03-28 08:05:37 | threats | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 433 | 2024-02-26 04:01:50 | threats | 2 | 107671 | 32 | 5.546 | 19414.2 |
| 432 | 2024-02-26 04:00:02 | threats | 3 | 134027 | 353 | 8.063 | 16622.5 |
| 431 | 2024-02-22 04:18:54 | threats | 3 | 134027 | 353 | 6.033 | 22215.6 |
| 430 | 2024-02-07 19:43:15 | threats | 2 | 107671 | 32 | 11.220 | 9596.3 |
| 429 | 2024-02-04 08:47:18 | threats | 3 | 134027 | 353 | 22.313 | 6006.7 |
| 428 | 2024-02-04 06:09:43 | threats | 3 | 134027 | 353 | 6.436 | 20824.6 |
| 427 | 2024-02-04 06:09:35 | threats | 2 | 107671 | 32 | 3.470 | 31029.1 |
| 426 | 2024-01-30 06:55:17 | threats | 2 | 107671 | 32 | 2.936 | 36672.7 |
| 425 | 2024-01-29 12:59:06 | threats | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 424 | 2024-01-25 19:17:49 | threats | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 423 | 2024-01-22 11:44:06 | threats | 3 | 134027 | 353 | 13.300 | 10077.2 |
| 422 | 2024-01-21 14:41:08 | threats | 3 | 134027 | 353 | 7.376 | 18170.7 |
| 421 | 2023-12-27 14:46:12 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 420 | 2023-12-13 06:12:43 | threats | 2 | 107671 | 32 | 2.953 | 36461.6 |
| 419 | 2023-12-09 23:05:34 | threats | 1 | 69583 | 6 | 1.096 | 63488.1 |
| 418 | 2023-11-28 23:05:20 | threats | 3 | 134027 | 353 | 6.373 | 21030.4 |
| 417 | 2023-11-24 00:30:35 | threats | 3 | 134027 | 353 | 13.906 | 9638.1 |
| 416 | 2023-11-20 02:24:16 | threats | 2 | 107671 | 32 | 2.813 | 38276.2 |
| 415 | 2023-11-19 20:42:12 | threats | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 414 | 2023-11-17 11:04:53 | threats | 3 | 134027 | 353 | 5.780 | 23188.1 |
| 413 | 2023-11-09 09:40:31 | threats | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 412 | 2023-11-08 18:49:32 | threats | 2 | 107671 | 32 | 2.843 | 37872.3 |
| 411 | 2023-11-06 00:39:26 | threats | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 410 | 2023-10-27 02:45:44 | threats | 3 | 134027 | 353 | 18.030 | 7433.6 |
| 409 | 2023-10-25 08:48:58 | threats | 3 | 134027 | 353 | 13.750 | 9747.4 |
| 408 | 2023-10-21 16:40:02 | threats | 3 | 134027 | 353 | 6.890 | 19452.4 |
| 407 | 2023-10-17 01:57:14 | threats | 1 | 69583 | 6 | 1.360 | 51164.0 |
| 406 | 2023-10-12 01:48:31 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 405 | 2023-09-24 01:24:58 | threats | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 404 | 2023-09-20 18:59:17 | threats | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 403 | 2023-09-11 10:02:47 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 402 | 2023-08-18 15:59:47 | threats | 3 | 134027 | 353 | 5.610 | 23890.7 |
| 401 | 2023-08-14 09:17:57 | threats | 2 | 107671 | 32 | 5.470 | 19683.9 |
| 400 | 2023-08-12 03:20:06 | threats | 1 | 69583 | 6 | 1.033 | 67360.1 |
| 399 | 2023-05-11 15:29:31 | threats | 1 | 69583 | 6 | 1.033 | 67360.1 |
| 398 | 2023-05-10 15:41:53 | threats | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 397 | 2023-05-05 09:11:58 | threats | 3 | 134027 | 353 | 6.406 | 20922.1 |
| 396 | 2023-04-21 00:48:00 | threats | 2 | 107671 | 32 | 2.763 | 38968.9 |
| 395 | 2023-03-05 08:40:51 | threats | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 394 | 2023-02-11 22:47:52 | threats | 3 | 134027 | 353 | 5.670 | 23637.9 |
| 393 | 2023-01-28 10:39:47 | threats | 2 | 107671 | 32 | 2.826 | 38100.1 |
| 392 | 2023-01-18 10:27:56 | threats | 1 | 69583 | 6 | 1.030 | 67556.3 |
| 391 | 2022-12-27 17:49:50 | threats | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 390 | 2022-12-23 04:24:29 | threats | 3 | 134027 | 353 | 5.656 | 23696.4 |
| 389 | 2022-11-22 22:44:19 | threats | 3 | 134027 | 353 | 8.420 | 15917.7 |
| 388 | 2022-11-10 12:41:00 | threats | 2 | 107671 | 32 | 2.750 | 39153.1 |
| 387 | 2022-09-13 22:51:11 | threats | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 386 | 2022-09-12 17:30:07 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 385 | 2022-07-15 05:34:54 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 384 | 2022-06-02 07:26:42 | threats | 2 | 107671 | 32 | 2.766 | 38926.6 |
| 383 | 2022-04-29 19:21:44 | threats | 1 | 69583 | 6 | 1.033 | 67360.1 |
| 382 | 2022-04-29 14:39:55 | threats | 3 | 134027 | 353 | 6.126 | 21878.4 |
| 381 | 2022-04-27 03:21:16 | threats | 3 | 134027 | 353 | 5.703 | 23501.1 |
| 380 | 2022-03-15 02:01:57 | threats | 1 | 69583 | 6 | 1.486 | 46825.7 |
| 379 | 2022-01-06 07:36:56 | threats | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 378 | 2022-01-03 01:55:52 | threats | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 377 | 2022-01-01 07:16:09 | threats | 3 | 134027 | 353 | 6.453 | 20769.7 |
| 376 | 2021-12-30 03:54:03 | threats | 3 | 134027 | 353 | 9.500 | 14108.1 |
| 375 | 2021-12-27 10:18:44 | threats | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 374 | 2021-12-25 07:59:27 | threats | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 373 | 2021-11-11 13:54:45 | threats | 3 | 134027 | 353 | 6.936 | 19323.4 |
| 372 | 2021-10-26 01:33:17 | threats | 1 | 69583 | 6 | 1.060 | 65644.3 |
| 371 | 2021-10-24 02:03:34 | threats | 1 | 69583 | 6 | 1.140 | 61037.7 |
| 370 | 2021-10-12 07:24:44 | threats | 3 | 134027 | 353 | 5.783 | 23176.0 |
| 369 | 2021-09-12 01:34:53 | threats | 1 | 69583 | 6 | 1.216 | 57222.9 |
| 368 | 2021-09-10 23:02:21 | threats | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 367 | 2021-09-07 16:52:05 | threats | 1 | 69583 | 6 | 1.030 | 67556.3 |
| 366 | 2021-08-23 06:39:26 | threats | 1 | 69583 | 6 | 2.313 | 30083.4 |
| 365 | 2021-08-21 02:00:19 | threats | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 364 | 2021-08-17 07:31:25 | threats | 3 | 134027 | 353 | 5.546 | 24166.4 |
| 363 | 2021-08-15 02:47:32 | threats | 3 | 134027 | 353 | 6.330 | 21173.3 |
| 362 | 2021-08-12 11:04:02 | threats | 3 | 134027 | 353 | 5.703 | 23501.1 |
| 361 | 2021-06-08 22:02:08 | threats | 2 | 107671 | 32 | 3.483 | 30913.3 |
| 360 | 2021-06-07 01:32:33 | threats | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 359 | 2021-05-31 09:16:19 | threats | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 358 | 2021-05-26 20:29:52 | threats | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 357 | 2021-05-13 02:05:23 | threats | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 356 | 2021-04-14 05:01:15 | threats | 2 | 107671 | 32 | 3.280 | 32826.5 |
| 355 | 2021-04-11 21:59:16 | threats | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 354 | 2021-03-30 13:02:21 | threats | 3 | 134027 | 353 | 6.470 | 20715.1 |
| 353 | 2021-02-25 00:30:58 | threats | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 352 | 2021-02-20 19:26:02 | threats | 2 | 107671 | 32 | 3.453 | 31181.9 |
| 351 | 2021-02-19 12:39:49 | threats | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 350 | 2021-02-10 11:45:45 | threats | 3 | 134027 | 353 | 6.110 | 21935.7 |
| 349 | 2021-02-08 07:25:15 | threats | 3 | 134027 | 353 | 5.906 | 22693.4 |
| 348 | 2021-01-31 10:52:18 | threats | 3 | 134027 | 353 | 5.876 | 22809.2 |
| 347 | 2021-01-26 01:14:17 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 346 | 2021-01-14 03:13:35 | threats | 3 | 134027 | 353 | 5.733 | 23378.2 |
| 345 | 2020-12-30 01:44:34 | threats | 2 | 107671 | 32 | 2.783 | 38688.8 |
| 344 | 2020-11-19 23:47:52 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 343 | 2020-11-10 04:11:15 | threats | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 342 | 2020-11-06 20:38:25 | threats | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 341 | 2020-11-06 10:43:55 | threats | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 340 | 2020-10-23 20:26:24 | threats | 3 | 134027 | 353 | 5.780 | 23188.1 |
| 339 | 2020-10-14 06:16:16 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 338 | 2020-10-12 08:12:46 | threats | 1 | 69583 | 6 | 1.046 | 66522.9 |
| 337 | 2020-10-07 09:58:20 | threats | 2 | 107671 | 32 | 3.110 | 34620.9 |
| 336 | 2020-09-30 05:44:46 | threats | 3 | 134027 | 353 | 5.703 | 23501.1 |