History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pattern"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 459 | 2024-05-10 23:04:40 | pattern | 1 | 69583 | 6 | 1.486 | 46825.7 |
| 458 | 2024-04-30 02:59:55 | pattern | 1 | 69583 | 6 | 1.420 | 49002.1 |
| 457 | 2024-04-29 22:50:10 | pattern | 1 | 69583 | 6 | 1.296 | 53690.6 |
| 456 | 2024-04-09 23:57:46 | pattern | 1 | 69583 | 6 | 4.406 | 15792.8 |
| 455 | 2024-04-09 23:56:23 | pattern | 1 | 69583 | 6 | 1.623 | 42873.1 |
| 454 | 2024-03-09 17:02:31 | pattern | 2 | 107671 | 72 | 2.906 | 37051.3 |
| 453 | 2024-03-05 22:54:46 | pattern | 3 | 134027 | 572 | 17.016 | 7876.5 |
| 452 | 2024-03-04 20:22:29 | pattern | 3 | 134027 | 572 | 9.436 | 14203.8 |
| 451 | 2024-02-29 06:47:28 | pattern | 2 | 107671 | 72 | 3.656 | 29450.5 |
| 450 | 2024-02-29 06:46:43 | pattern | 3 | 134027 | 572 | 7.626 | 17575.0 |
| 449 | 2024-02-29 00:00:26 | pattern | 3 | 134027 | 572 | 6.296 | 21287.6 |
| 448 | 2024-02-28 10:28:44 | pattern | 1 | 69583 | 6 | 3.170 | 21950.5 |
| 447 | 2023-12-29 03:36:48 | pattern | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 446 | 2023-12-23 00:06:11 | pattern | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 445 | 2023-12-02 08:28:42 | pattern | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 444 | 2023-11-30 09:31:00 | pattern | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 443 | 2023-11-25 18:26:18 | pattern | 2 | 107671 | 72 | 2.923 | 36835.8 |
| 442 | 2023-11-22 03:06:26 | pattern | 3 | 134027 | 572 | 5.860 | 22871.5 |
| 441 | 2023-11-20 13:58:29 | pattern | 2 | 107671 | 72 | 2.923 | 36835.8 |
| 440 | 2023-11-20 13:58:19 | pattern | 3 | 134027 | 572 | 5.860 | 22871.5 |
| 439 | 2023-11-13 20:02:02 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 438 | 2023-11-09 00:43:58 | pattern | 1 | 69583 | 6 | 1.080 | 64428.7 |
| 437 | 2023-10-30 12:51:04 | pattern | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 436 | 2023-10-19 01:38:24 | pattern | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 435 | 2023-09-24 04:15:47 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 434 | 2023-08-25 05:29:40 | pattern | 2 | 107671 | 72 | 3.326 | 32372.5 |
| 433 | 2023-08-22 06:20:21 | pattern | 3 | 134027 | 572 | 5.830 | 22989.2 |
| 432 | 2023-08-20 08:26:19 | pattern | 1 | 69583 | 6 | 1.063 | 65459.1 |
| 431 | 2023-08-16 23:17:01 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 430 | 2023-08-15 06:01:24 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 429 | 2023-05-16 02:46:15 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 428 | 2023-05-14 15:32:45 | pattern | 3 | 134027 | 572 | 5.860 | 22871.5 |
| 427 | 2023-05-08 18:31:33 | pattern | 2 | 107671 | 72 | 2.856 | 37699.9 |
| 426 | 2023-05-07 07:25:03 | pattern | 3 | 134027 | 572 | 5.813 | 23056.4 |
| 425 | 2023-04-28 22:15:07 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 424 | 2023-04-01 05:05:00 | pattern | 3 | 134027 | 572 | 6.843 | 19586.0 |
| 423 | 2023-03-09 20:00:18 | pattern | 1 | 69583 | 6 | 1.190 | 58473.1 |
| 422 | 2023-02-11 12:19:14 | pattern | 3 | 134027 | 572 | 5.843 | 22938.0 |
| 421 | 2023-02-08 10:18:51 | pattern | 2 | 107671 | 72 | 2.936 | 36672.7 |
| 420 | 2023-01-05 10:37:25 | pattern | 1 | 69583 | 6 | 1.076 | 64668.2 |
| 419 | 2023-01-01 10:46:28 | pattern | 1 | 69583 | 6 | 2.170 | 32065.9 |
| 418 | 2022-11-23 12:36:18 | pattern | 3 | 134027 | 572 | 6.423 | 20866.7 |
| 417 | 2022-11-20 06:43:06 | pattern | 2 | 107671 | 72 | 3.326 | 32372.5 |
| 416 | 2022-09-22 15:20:13 | pattern | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 415 | 2022-09-10 23:47:10 | pattern | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 414 | 2022-06-22 22:18:05 | pattern | 2 | 107671 | 72 | 2.843 | 37872.3 |
| 413 | 2022-05-15 19:45:20 | pattern | 1 | 69583 | 6 | 1.106 | 62914.1 |
| 412 | 2022-05-03 12:36:18 | pattern | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 411 | 2022-05-01 08:43:46 | pattern | 1 | 69583 | 6 | 1.203 | 57841.2 |
| 410 | 2022-04-27 14:43:43 | pattern | 3 | 134027 | 572 | 7.813 | 17154.4 |
| 409 | 2022-04-25 09:45:48 | pattern | 3 | 134027 | 572 | 7.440 | 18014.4 |
| 408 | 2022-01-28 02:45:21 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 407 | 2022-01-20 08:34:39 | pattern | 1 | 69583 | 6 | 1.470 | 47335.4 |
| 406 | 2022-01-18 04:28:15 | pattern | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 405 | 2022-01-16 20:44:29 | pattern | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 404 | 2021-12-24 06:02:24 | pattern | 3 | 134027 | 572 | 7.050 | 19010.9 |
| 403 | 2021-12-09 00:49:49 | pattern | 1 | 69583 | 6 | 1.373 | 50679.5 |
| 402 | 2021-11-11 20:53:37 | pattern | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 401 | 2021-10-11 10:16:17 | pattern | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 400 | 2021-09-27 09:36:26 | pattern | 1 | 69583 | 6 | 1.156 | 60192.9 |
| 399 | 2021-09-10 06:33:06 | pattern | 1 | 69583 | 6 | 1.110 | 62687.4 |
| 398 | 2021-07-09 21:49:35 | pattern | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 397 | 2021-05-27 05:54:28 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 396 | 2021-05-16 22:25:11 | pattern | 1 | 69583 | 6 | 1.280 | 54361.7 |
| 395 | 2021-05-01 10:52:29 | pattern | 1 | 69583 | 6 | 1.923 | 36184.6 |
| 394 | 2021-04-06 01:25:27 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 393 | 2021-04-01 21:15:51 | pattern | 1 | 69583 | 6 | 1.186 | 58670.3 |
| 392 | 2021-02-26 00:16:03 | pattern | 1 | 69583 | 6 | 1.263 | 55093.4 |
| 391 | 2021-02-22 12:51:01 | pattern | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 390 | 2021-02-08 12:57:09 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 389 | 2021-01-14 09:00:55 | pattern | 1 | 69583 | 6 | 1.093 | 63662.4 |
| 388 | 2020-12-24 15:19:22 | pattern | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 387 | 2020-11-01 07:19:13 | pattern | 1 | 69583 | 6 | 1.233 | 56433.9 |
| 386 | 2020-10-21 21:05:08 | pattern | 1 | 69583 | 6 | 1.466 | 47464.5 |
| 385 | 2020-10-01 10:51:34 | pattern | 1 | 69583 | 6 | 1.143 | 60877.5 |
| 384 | 2020-09-20 18:53:48 | pattern | 1 | 69583 | 6 | 1.096 | 63488.1 |
| 383 | 2020-08-19 13:41:00 | pattern | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 382 | 2020-08-15 13:25:13 | pattern | 1 | 69583 | 6 | 1.123 | 61961.7 |
| 381 | 2020-08-15 08:16:42 | pattern | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 380 | 2020-07-28 23:56:34 | pattern | 1 | 69583 | 6 | 1.170 | 59472.6 |
| 379 | 2020-06-07 07:12:54 | pattern | 1 | 69583 | 6 | 1.126 | 61796.6 |
| 378 | 2020-05-18 09:05:28 | pattern | 1 | 69583 | 6 | 1.173 | 59320.5 |
| 377 | 2020-03-28 06:22:08 | pattern | 1 | 69583 | 6 | 1.313 | 52995.4 |
| 376 | 2020-03-27 03:23:40 | pattern | 1 | 69583 | 6 | 2.670 | 26061.0 |
| 375 | 2020-03-25 17:36:05 | pattern | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 374 | 2020-03-22 00:54:37 | pattern | 1 | 69583 | 6 | 1.266 | 54962.9 |
| 373 | 2020-03-20 00:19:54 | pattern | 1 | 69583 | 6 | 1.250 | 55666.4 |
| 372 | 2020-03-05 19:06:00 | pattern | 1 | 69583 | 6 | 1.720 | 40455.2 |
| 371 | 2020-03-01 01:10:01 | pattern | 2 | 107671 | 72 | 3.373 | 31921.4 |
| 370 | 2020-02-29 23:56:11 | pattern | 2 | 107671 | 72 | 8.906 | 12089.7 |
| 369 | 2020-02-29 21:30:04 | pattern | 1 | 69583 | 6 | 2.470 | 28171.3 |
| 368 | 2020-02-29 13:48:25 | pattern | 1 | 69583 | 6 | 1.470 | 47335.4 |
| 367 | 2020-02-29 07:13:48 | pattern | 2 | 107671 | 72 | 3.780 | 28484.4 |
| 366 | 2020-02-28 09:21:08 | pattern | 2 | 107671 | 72 | 5.313 | 20265.6 |
| 365 | 2020-02-18 00:59:52 | pattern | 1 | 69583 | 6 | 1.673 | 41591.8 |
| 364 | 2020-02-17 01:07:53 | pattern | 1 | 69583 | 6 | 1.516 | 45899.1 |
| 363 | 2020-02-10 04:44:00 | pattern | 3 | 134027 | 572 | 7.096 | 18887.7 |
| 362 | 2020-02-09 23:59:46 | pattern | 3 | 134027 | 572 | 25.580 | 5239.5 |
| 361 | 2020-02-09 21:06:10 | pattern | 3 | 134027 | 572 | 7.123 | 18816.1 |
| 360 | 2020-02-09 14:33:59 | pattern | 3 | 134027 | 572 | 6.860 | 19537.5 |