History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"absenters"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 448 | 2024-04-25 20:54:00 | absenters | 1 | 81242 | 4 | 2.610 | 31127.2 |
| 447 | 2024-04-25 11:21:57 | absenters | 2 | 121436 | 13 | 10.623 | 11431.4 |
| 446 | 2024-04-25 10:42:02 | absenters | 1 | 81242 | 4 | 3.140 | 25873.2 |
| 445 | 2024-04-16 13:51:34 | absenters | 2 | 121436 | 13 | 3.190 | 38067.7 |
| 444 | 2024-04-10 10:38:25 | absenters | 2 | 121436 | 13 | 14.266 | 8512.3 |
| 443 | 2024-04-10 10:38:27 | absenters | 3 | 148641 | 103 | 9.966 | 14914.8 |
| 442 | 2024-04-10 08:59:42 | absenters | 1 | 81242 | 4 | 3.190 | 25467.7 |
| 441 | 2024-03-30 00:23:14 | absenters | 1 | 81242 | 4 | 2.986 | 27207.6 |
| 440 | 2024-03-28 09:07:40 | absenters | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 439 | 2024-03-26 15:49:01 | absenters | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 438 | 2024-03-19 20:10:09 | absenters | 3 | 148641 | 103 | 22.003 | 6755.5 |
| 437 | 2024-03-02 14:43:49 | absenters | 3 | 148641 | 103 | 17.686 | 8404.4 |
| 436 | 2024-03-02 14:43:47 | absenters | 2 | 121436 | 13 | 8.203 | 14803.9 |
| 435 | 2024-03-02 14:03:14 | absenters | 1 | 81242 | 4 | 3.140 | 25873.2 |
| 434 | 2024-02-28 23:16:42 | absenters | 1 | 81242 | 4 | 1.466 | 55417.5 |
| 433 | 2024-02-26 14:42:07 | absenters | 1 | 81242 | 4 | 1.420 | 57212.7 |
| 432 | 2024-02-25 06:48:46 | absenters | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 431 | 2024-02-06 16:08:13 | absenters | 3 | 148641 | 103 | 17.923 | 8293.3 |
| 430 | 2024-01-29 21:08:06 | absenters | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 429 | 2024-01-29 06:46:35 | absenters | 1 | 81242 | 4 | 2.876 | 28248.3 |
| 428 | 2024-01-25 23:44:19 | absenters | 1 | 81242 | 4 | 1.483 | 54782.2 |
| 427 | 2024-01-25 23:44:00 | absenters | 1 | 81242 | 4 | 2.893 | 28082.3 |
| 426 | 2024-01-24 20:03:20 | absenters | 1 | 81242 | 4 | 1.250 | 64993.6 |
| 425 | 2024-01-16 15:30:00 | absenters | 3 | 148641 | 103 | 6.186 | 24028.6 |
| 424 | 2023-12-15 16:40:28 | absenters | 2 | 121436 | 13 | 4.140 | 29332.4 |
| 423 | 2023-12-12 10:59:00 | absenters | 3 | 148641 | 103 | 6.046 | 24585.0 |
| 422 | 2023-11-24 10:42:47 | absenters | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 421 | 2023-11-02 00:18:49 | absenters | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 420 | 2023-10-27 20:26:24 | absenters | 3 | 148641 | 103 | 6.843 | 21721.6 |
| 419 | 2023-10-06 16:28:52 | absenters | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 418 | 2023-09-16 00:13:23 | absenters | 2 | 121436 | 13 | 3.000 | 40478.7 |
| 417 | 2023-09-09 17:32:43 | absenters | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 416 | 2023-08-17 04:03:12 | absenters | 1 | 81242 | 4 | 1.516 | 53589.7 |
| 415 | 2023-08-06 22:41:00 | absenters | 3 | 148641 | 103 | 7.110 | 20905.9 |
| 414 | 2023-06-19 17:05:16 | absenters | 1 | 81242 | 4 | 1.330 | 61084.2 |
| 413 | 2023-06-19 16:55:10 | absenters | 2 | 121436 | 13 | 2.953 | 41122.9 |
| 412 | 2023-06-12 01:15:21 | absenters | 1 | 81242 | 4 | 1.283 | 63321.9 |
| 411 | 2023-04-24 06:45:17 | absenters | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 410 | 2023-04-20 00:43:26 | absenters | 3 | 148641 | 103 | 7.046 | 21095.8 |
| 409 | 2023-03-28 23:49:19 | absenters | 1 | 81242 | 4 | 1.200 | 67701.7 |
| 408 | 2023-03-22 18:34:35 | absenters | 1 | 81242 | 4 | 1.280 | 63470.3 |
| 407 | 2023-03-15 18:44:20 | absenters | 2 | 121436 | 13 | 3.000 | 40478.7 |
| 406 | 2023-02-28 17:05:49 | absenters | 1 | 81242 | 4 | 1.220 | 66591.8 |
| 405 | 2023-01-20 17:27:19 | absenters | 3 | 148641 | 103 | 5.970 | 24898.0 |
| 404 | 2023-01-11 23:20:07 | absenters | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 403 | 2022-12-18 20:16:31 | absenters | 2 | 121436 | 13 | 3.263 | 37216.1 |
| 402 | 2022-11-08 08:40:20 | absenters | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 401 | 2022-11-04 20:30:43 | absenters | 1 | 81242 | 4 | 1.233 | 65889.7 |
| 400 | 2022-10-30 07:58:55 | absenters | 3 | 148641 | 103 | 6.326 | 23496.8 |
| 399 | 2022-10-18 05:24:37 | absenters | 1 | 81242 | 4 | 1.203 | 67532.8 |
| 398 | 2022-08-12 06:29:38 | absenters | 2 | 121436 | 13 | 3.016 | 40263.9 |
| 397 | 2022-07-18 23:52:03 | absenters | 1 | 81242 | 4 | 1.203 | 67532.8 |
| 396 | 2022-06-09 01:54:51 | absenters | 1 | 81242 | 4 | 1.233 | 65889.7 |
| 395 | 2022-05-31 13:13:51 | absenters | 3 | 148641 | 103 | 6.250 | 23782.6 |
| 394 | 2022-03-28 08:54:51 | absenters | 1 | 81242 | 4 | 1.593 | 50999.4 |
| 393 | 2022-03-21 15:39:53 | absenters | 2 | 121436 | 13 | 3.423 | 35476.5 |
| 392 | 2022-02-18 19:27:57 | absenters | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 391 | 2022-02-16 16:08:37 | absenters | 1 | 81242 | 4 | 1.216 | 66810.9 |
| 390 | 2021-12-14 02:27:08 | absenters | 1 | 81242 | 4 | 1.283 | 63321.9 |
| 389 | 2021-12-08 02:15:55 | absenters | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 388 | 2021-11-04 21:26:05 | absenters | 1 | 81242 | 4 | 1.233 | 65889.7 |
| 387 | 2021-09-03 13:10:50 | absenters | 1 | 81242 | 4 | 1.376 | 59042.2 |
| 386 | 2021-06-02 16:06:25 | absenters | 1 | 81242 | 4 | 1.513 | 53696.0 |
| 385 | 2021-05-29 08:36:12 | absenters | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 384 | 2021-05-03 19:20:00 | absenters | 1 | 81242 | 4 | 1.436 | 56575.2 |
| 383 | 2021-04-01 23:20:12 | absenters | 1 | 81242 | 4 | 1.393 | 58321.6 |
| 382 | 2021-02-28 01:35:44 | absenters | 1 | 81242 | 4 | 1.373 | 59171.2 |
| 381 | 2021-02-10 12:36:02 | absenters | 1 | 81242 | 4 | 1.216 | 66810.9 |
| 380 | 2020-11-23 11:42:23 | absenters | 1 | 81242 | 4 | 1.296 | 62686.7 |
| 379 | 2020-11-20 21:11:55 | absenters | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 378 | 2020-11-02 10:20:36 | absenters | 3 | 148641 | 103 | 6.563 | 22648.3 |
| 377 | 2020-11-02 10:20:32 | absenters | 2 | 121436 | 13 | 3.626 | 33490.3 |
| 376 | 2020-11-02 10:20:30 | absenters | 1 | 81242 | 4 | 1.343 | 60492.9 |
| 375 | 2020-10-05 11:41:19 | absenters | 1 | 81242 | 4 | 1.360 | 59736.8 |
| 374 | 2020-10-02 03:11:34 | absenters | 1 | 81242 | 4 | 1.216 | 66810.9 |
| 373 | 2020-08-15 17:21:40 | absenters | 1 | 81242 | 4 | 1.220 | 66591.8 |
| 372 | 2020-05-14 10:41:18 | absenters | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 371 | 2020-03-22 11:09:10 | absenters | 1 | 81242 | 4 | 1.486 | 54671.6 |
| 370 | 2020-03-06 02:30:29 | absenters | 3 | 148641 | 103 | 8.313 | 17880.5 |
| 369 | 2020-03-06 02:11:53 | absenters | 3 | 148641 | 103 | 6.690 | 22218.4 |
| 368 | 2020-03-05 11:17:07 | absenters | 3 | 148641 | 103 | 7.000 | 21234.4 |
| 367 | 2020-03-01 02:58:43 | absenters | 1 | 81242 | 4 | 2.936 | 27671.0 |
| 366 | 2020-02-21 04:51:48 | absenters | 1 | 81242 | 4 | 4.643 | 17497.7 |
| 365 | 2020-02-17 05:39:57 | absenters | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 364 | 2020-02-11 15:15:46 | absenters | 3 | 148641 | 103 | 19.140 | 7766.0 |
| 363 | 2020-02-09 21:49:32 | absenters | 1 | 81242 | 4 | 1.440 | 56418.1 |
| 362 | 2020-02-08 22:29:31 | absenters | 1 | 81242 | 4 | 1.406 | 57782.4 |
| 361 | 2020-02-07 02:09:24 | absenters | 1 | 81242 | 4 | 1.440 | 56418.1 |
| 360 | 2020-02-04 11:18:32 | absenters | 1 | 81242 | 4 | 1.500 | 54161.3 |
| 359 | 2020-02-03 21:03:43 | absenters | 1 | 81242 | 4 | 4.656 | 17448.9 |
| 358 | 2020-01-28 18:28:44 | absenters | 1 | 81242 | 4 | 1.453 | 55913.3 |
| 357 | 2020-01-21 07:21:06 | absenters | 3 | 148641 | 103 | 6.330 | 23482.0 |
| 356 | 2020-01-18 13:34:50 | absenters | 2 | 121436 | 13 | 7.690 | 15791.4 |
| 355 | 2020-01-18 06:19:17 | absenters | 1 | 81242 | 4 | 3.546 | 22910.9 |
| 354 | 2020-01-16 23:06:15 | absenters | 3 | 148641 | 103 | 8.063 | 18434.9 |
| 353 | 2020-01-16 13:49:56 | absenters | 2 | 121436 | 13 | 3.623 | 33518.1 |
| 352 | 2020-01-16 13:49:44 | absenters | 3 | 148641 | 103 | 6.326 | 23496.8 |
| 351 | 2020-01-16 11:24:11 | absenters | 1 | 81242 | 4 | 2.953 | 27511.7 |
| 350 | 2020-01-11 13:25:46 | absenters | 1 | 81242 | 4 | 1.390 | 58447.5 |
| 349 | 2020-01-08 15:03:35 | absenters | 1 | 81242 | 4 | 1.280 | 63470.3 |