History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guarder"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 456 | 2024-04-27 15:50:09 | guarder | 1 | 69583 | 3 | 1.470 | 47335.4 |
| 455 | 2024-04-24 19:03:59 | guarder | 3 | 134027 | 416 | 16.580 | 8083.7 |
| 454 | 2024-04-22 17:48:30 | guarder | 3 | 134027 | 416 | 17.423 | 7692.5 |
| 453 | 2024-04-20 21:18:33 | guarder | 3 | 134027 | 416 | 24.936 | 5374.8 |
| 452 | 2024-04-20 12:46:02 | guarder | 3 | 134027 | 416 | 9.266 | 14464.4 |
| 451 | 2024-04-20 12:45:58 | guarder | 2 | 107671 | 27 | 6.716 | 16032.0 |
| 450 | 2024-04-20 12:45:25 | guarder | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 449 | 2024-04-16 04:48:25 | guarder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 448 | 2024-04-16 02:42:52 | guarder | 1 | 69583 | 3 | 1.466 | 47464.5 |
| 447 | 2024-04-02 01:30:15 | guarder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 446 | 2024-03-18 22:40:54 | guarder | 1 | 69583 | 3 | 2.013 | 34566.8 |
| 445 | 2024-02-28 08:16:16 | guarder | 3 | 134027 | 416 | 8.420 | 15917.7 |
| 444 | 2024-02-22 11:11:26 | guarder | 3 | 134027 | 416 | 21.186 | 6326.2 |
| 443 | 2024-02-18 09:09:09 | guarder | 3 | 134027 | 416 | 16.893 | 7933.9 |
| 442 | 2024-02-18 09:04:56 | guarder | 3 | 134027 | 416 | 11.736 | 11420.2 |
| 441 | 2024-02-18 07:44:02 | guarder | 3 | 134027 | 416 | 16.110 | 8319.5 |
| 440 | 2024-02-17 22:19:58 | guarder | 3 | 134027 | 416 | 11.313 | 11847.2 |
| 439 | 2024-02-17 22:20:00 | guarder | 2 | 107671 | 27 | 3.640 | 29579.9 |
| 438 | 2024-02-17 17:21:27 | guarder | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 437 | 2024-02-04 04:59:04 | guarder | 2 | 107671 | 27 | 3.156 | 34116.3 |
| 436 | 2024-01-15 01:38:24 | guarder | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 435 | 2024-01-11 03:56:27 | guarder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 434 | 2023-12-28 16:31:13 | guarder | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 433 | 2023-12-21 17:52:15 | guarder | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 432 | 2023-12-10 21:24:44 | guarder | 2 | 107671 | 27 | 3.170 | 33965.6 |
| 431 | 2023-12-08 17:11:24 | guarder | 2 | 107671 | 27 | 2.860 | 37647.2 |
| 430 | 2023-11-28 09:34:50 | guarder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 429 | 2023-11-10 05:04:14 | guarder | 2 | 107671 | 27 | 3.046 | 35348.3 |
| 428 | 2023-11-04 03:29:07 | guarder | 1 | 69583 | 3 | 2.890 | 24077.2 |
| 427 | 2023-11-01 14:54:43 | guarder | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 426 | 2023-10-14 08:55:52 | guarder | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 425 | 2023-10-09 06:07:29 | guarder | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 424 | 2023-10-07 11:11:10 | guarder | 3 | 134027 | 416 | 6.640 | 20184.8 |
| 423 | 2023-10-01 06:28:20 | guarder | 3 | 134027 | 416 | 11.093 | 12082.1 |
| 422 | 2023-09-28 08:04:43 | guarder | 3 | 134027 | 416 | 6.110 | 21935.7 |
| 421 | 2023-09-28 08:04:44 | guarder | 2 | 107671 | 27 | 3.140 | 34290.1 |
| 420 | 2023-09-22 11:00:12 | guarder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 419 | 2023-09-01 10:57:55 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 418 | 2023-08-29 03:28:34 | guarder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 417 | 2023-08-13 19:01:43 | guarder | 2 | 107671 | 27 | 4.003 | 26897.6 |
| 416 | 2023-08-13 06:43:44 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 415 | 2023-08-04 19:59:51 | guarder | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 414 | 2023-05-04 18:26:16 | guarder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 413 | 2023-05-01 22:23:11 | guarder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 412 | 2023-04-29 06:53:21 | guarder | 2 | 107671 | 27 | 2.830 | 38046.3 |
| 411 | 2023-02-22 18:53:42 | guarder | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 410 | 2023-02-01 11:14:18 | guarder | 2 | 107671 | 27 | 3.203 | 33615.7 |
| 409 | 2023-01-27 05:27:15 | guarder | 2 | 107671 | 27 | 6.563 | 16405.8 |
| 408 | 2023-01-15 00:04:00 | guarder | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 407 | 2022-12-20 06:54:58 | guarder | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 406 | 2022-12-13 03:16:18 | guarder | 2 | 107671 | 27 | 3.063 | 35152.1 |
| 405 | 2022-11-13 18:05:17 | guarder | 2 | 107671 | 27 | 2.720 | 39584.9 |
| 404 | 2022-09-16 14:58:20 | guarder | 1 | 69583 | 3 | 1.030 | 67556.3 |
| 403 | 2022-09-02 08:22:20 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 402 | 2022-06-17 00:06:20 | guarder | 2 | 107671 | 27 | 2.780 | 38730.6 |
| 401 | 2022-05-16 06:22:47 | guarder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 400 | 2022-05-10 22:10:26 | guarder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 399 | 2022-05-03 01:18:29 | guarder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 398 | 2022-04-30 20:17:04 | guarder | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 397 | 2022-01-26 14:50:08 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 396 | 2021-10-10 00:38:07 | guarder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 395 | 2021-07-08 03:30:54 | guarder | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 394 | 2021-06-07 07:22:17 | guarder | 1 | 69583 | 3 | 1.050 | 66269.5 |
| 393 | 2021-05-13 09:46:41 | guarder | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 392 | 2021-04-21 13:07:38 | guarder | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 391 | 2021-04-12 06:37:42 | guarder | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 390 | 2021-04-08 08:14:07 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 389 | 2021-04-04 04:22:49 | guarder | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 388 | 2021-03-16 04:35:48 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 387 | 2021-02-02 10:57:49 | guarder | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 386 | 2021-01-06 17:20:53 | guarder | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 385 | 2020-12-30 04:00:10 | guarder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 384 | 2020-12-28 05:35:50 | guarder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 383 | 2020-10-21 15:01:11 | guarder | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 382 | 2020-10-20 21:45:20 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 381 | 2020-09-26 21:15:12 | guarder | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 380 | 2020-08-30 06:05:48 | guarder | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 379 | 2020-07-18 20:04:37 | guarder | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 378 | 2020-06-21 05:00:40 | guarder | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 377 | 2020-06-18 01:02:04 | guarder | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 376 | 2020-03-28 10:14:24 | guarder | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 375 | 2020-03-28 09:50:03 | guarder | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 374 | 2020-03-21 07:44:36 | guarder | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 373 | 2020-03-04 12:54:06 | guarder | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 372 | 2020-03-01 15:47:27 | guarder | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 371 | 2020-02-24 22:37:15 | guarder | 1 | 69583 | 3 | 2.890 | 24077.2 |
| 370 | 2020-02-21 00:47:30 | guarder | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 369 | 2020-02-18 13:35:33 | guarder | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 368 | 2020-02-12 07:16:41 | guarder | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 367 | 2020-02-08 18:01:17 | guarder | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 366 | 2020-02-04 13:49:07 | guarder | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 365 | 2020-02-03 09:25:30 | guarder | 1 | 69583 | 3 | 2.656 | 26198.4 |
| 364 | 2020-01-26 20:00:15 | guarder | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 363 | 2020-01-24 04:58:04 | guarder | 1 | 69583 | 3 | 3.266 | 21305.3 |
| 362 | 2020-01-20 21:59:28 | guarder | 1 | 69583 | 3 | 2.296 | 30306.2 |
| 361 | 2020-01-20 21:43:30 | guarder | 1 | 69583 | 3 | 4.076 | 17071.4 |
| 360 | 2020-01-15 01:09:36 | guarder | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 359 | 2020-01-08 14:31:39 | guarder | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 358 | 2020-01-01 17:37:13 | guarder | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 357 | 2019-12-30 00:24:05 | guarder | 1 | 69583 | 3 | 1.233 | 56433.9 |