History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detainee"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 464 | 2026-02-13 22:49:50 | detainee | 1 | 82945 | 4 | 7.186 | 11542.6 |
| 463 | 2026-02-13 22:49:27 | detainee | 1 | 82945 | 4 | 3.563 | 23279.5 |
| 462 | 2026-02-13 22:48:59 | detainee | 1 | 82945 | 4 | 3.530 | 23497.2 |
| 461 | 2026-02-12 09:52:15 | detainee | 1 | 82945 | 4 | 1.610 | 51518.6 |
| 460 | 2026-02-12 08:52:52 | detainee | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 459 | 2026-02-07 09:27:26 | detainee | 1 | 82945 | 4 | 3.546 | 23391.1 |
| 458 | 2026-02-07 05:23:04 | detainee | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 457 | 2026-02-04 16:29:56 | detainee | 1 | 82945 | 4 | 2.500 | 33178.0 |
| 456 | 2026-02-02 04:06:18 | detainee | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 455 | 2026-02-01 12:27:43 | detainee | 1 | 82945 | 4 | 2.313 | 35860.4 |
| 454 | 2026-01-28 18:56:51 | detainee | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 453 | 2026-01-28 18:55:13 | detainee | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 452 | 2026-01-28 18:55:08 | detainee | 1 | 82945 | 4 | 1.486 | 55817.6 |
| 451 | 2026-01-27 02:51:47 | detainee | 1 | 82945 | 4 | 1.703 | 48705.2 |
| 450 | 2026-01-26 11:08:47 | detainee | 1 | 82945 | 4 | 1.516 | 54713.1 |
| 449 | 2026-01-25 02:30:39 | detainee | 1 | 82945 | 4 | 1.530 | 54212.4 |
| 448 | 2026-01-23 20:10:23 | detainee | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 447 | 2026-01-22 06:26:07 | detainee | 1 | 82945 | 4 | 6.296 | 13174.2 |
| 446 | 2026-01-21 08:30:05 | detainee | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 445 | 2026-01-11 06:36:17 | detainee | 1 | 82945 | 4 | 1.470 | 56425.2 |
| 444 | 2026-01-09 05:05:14 | detainee | 2 | 121059 | 19 | 6.750 | 17934.7 |
| 443 | 2026-01-08 04:10:28 | detainee | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 442 | 2026-01-06 13:51:08 | detainee | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 441 | 2026-01-06 13:33:57 | detainee | 1 | 82945 | 4 | 2.876 | 28840.4 |
| 440 | 2026-01-03 02:46:14 | detainee | 1 | 82945 | 4 | 1.390 | 59672.7 |
| 439 | 2026-01-03 02:44:21 | detainee | 1 | 82945 | 4 | 1.500 | 55296.7 |
| 438 | 2026-01-02 02:52:03 | detainee | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 437 | 2026-01-01 14:40:32 | detainee | 1 | 82945 | 4 | 1.326 | 62552.8 |
| 436 | 2025-12-18 08:31:36 | detainee | 1 | 82945 | 4 | 1.690 | 49079.9 |
| 435 | 2025-12-12 08:17:04 | detainee | 1 | 82945 | 4 | 1.546 | 53651.4 |
| 434 | 2025-11-27 19:14:07 | detainee | 1 | 82945 | 4 | 1.593 | 52068.4 |
| 433 | 2025-11-24 17:54:32 | detainee | 1 | 82945 | 4 | 3.080 | 26930.2 |
| 432 | 2025-10-21 07:33:52 | detainee | 1 | 82945 | 4 | 6.953 | 11929.4 |
| 431 | 2025-10-21 07:33:44 | detainee | 1 | 82945 | 4 | 6.670 | 12435.5 |
| 430 | 2025-10-21 07:33:34 | detainee | 1 | 82945 | 4 | 8.403 | 9870.9 |
| 429 | 2025-10-21 07:33:26 | detainee | 1 | 82945 | 4 | 8.623 | 9619.0 |
| 428 | 2025-09-19 10:38:32 | detainee | 1 | 82945 | 4 | 2.530 | 32784.6 |
| 427 | 2025-08-06 12:37:40 | detainee | 2 | 121059 | 19 | 16.156 | 7493.1 |
| 426 | 2025-08-05 22:18:00 | detainee | 2 | 121059 | 19 | 10.233 | 11830.3 |
| 425 | 2025-08-05 10:49:38 | detainee | 1 | 82945 | 4 | 3.063 | 27079.7 |
| 424 | 2025-08-05 04:01:08 | detainee | 1 | 82945 | 4 | 3.516 | 23590.7 |
| 423 | 2025-08-04 22:26:54 | detainee | 2 | 121059 | 19 | 8.640 | 14011.5 |
| 422 | 2025-08-02 00:37:26 | detainee | 2 | 121059 | 19 | 10.280 | 11776.2 |
| 421 | 2025-08-01 07:39:13 | detainee | 1 | 82945 | 4 | 8.093 | 10249.0 |
| 420 | 2025-07-27 09:41:08 | detainee | 1 | 82945 | 4 | 6.703 | 12374.3 |
| 419 | 2025-07-24 23:22:07 | detainee | 1 | 82945 | 4 | 5.203 | 15941.8 |
| 418 | 2025-07-24 10:36:04 | detainee | 1 | 82945 | 4 | 5.606 | 14795.8 |
| 417 | 2025-07-22 08:12:45 | detainee | 1 | 82945 | 4 | 4.593 | 18059.0 |
| 416 | 2025-07-10 00:16:19 | detainee | 2 | 121059 | 19 | 10.156 | 11919.9 |
| 415 | 2025-07-09 20:51:30 | detainee | 3 | 146162 | 112 | 8.170 | 17890.1 |
| 414 | 2025-07-07 16:04:53 | detainee | 2 | 121059 | 19 | 18.266 | 6627.6 |
| 413 | 2025-07-05 08:49:08 | detainee | 2 | 121059 | 19 | 16.860 | 7180.2 |
| 412 | 2025-07-05 04:09:34 | detainee | 3 | 146162 | 112 | 29.393 | 4972.7 |
| 411 | 2025-07-04 12:56:18 | detainee | 3 | 146162 | 112 | 42.550 | 3435.1 |
| 410 | 2025-07-04 03:01:35 | detainee | 1 | 82945 | 4 | 3.826 | 21679.3 |
| 409 | 2025-06-27 09:06:37 | detainee | 1 | 82945 | 4 | 7.233 | 11467.6 |
| 408 | 2025-06-25 01:53:54 | detainee | 3 | 146162 | 112 | 32.266 | 4529.9 |
| 407 | 2025-06-25 01:53:55 | detainee | 2 | 121059 | 19 | 19.656 | 6158.9 |
| 406 | 2025-06-20 00:29:17 | detainee | 1 | 82945 | 4 | 3.530 | 23497.2 |
| 405 | 2025-06-18 07:20:45 | detainee | 1 | 82945 | 4 | 5.953 | 13933.3 |
| 404 | 2025-06-14 12:35:54 | detainee | 1 | 82945 | 4 | 7.860 | 10552.8 |
| 403 | 2025-06-13 01:48:11 | detainee | 1 | 82945 | 4 | 1.436 | 57761.1 |
| 402 | 2025-06-04 02:16:17 | detainee | 1 | 82945 | 4 | 6.923 | 11981.1 |
| 401 | 2025-05-25 09:45:13 | detainee | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 400 | 2025-05-24 11:19:02 | detainee | 3 | 146162 | 112 | 39.470 | 3703.1 |
| 399 | 2025-05-23 20:53:03 | detainee | 3 | 146162 | 112 | 50.110 | 2916.8 |
| 398 | 2025-05-23 06:19:08 | detainee | 3 | 146162 | 112 | 28.690 | 5094.5 |
| 397 | 2025-05-23 01:50:45 | detainee | 2 | 121059 | 19 | 18.980 | 6378.2 |
| 396 | 2025-05-23 01:09:31 | detainee | 3 | 146162 | 112 | 38.640 | 3782.7 |
| 395 | 2025-05-22 18:00:06 | detainee | 3 | 146162 | 112 | 40.086 | 3646.2 |
| 394 | 2025-05-22 09:33:16 | detainee | 1 | 82945 | 4 | 3.436 | 24140.0 |
| 393 | 2025-05-20 13:01:28 | detainee | 3 | 146162 | 112 | 22.253 | 6568.2 |
| 392 | 2025-05-19 21:30:38 | detainee | 2 | 121059 | 19 | 26.173 | 4625.3 |
| 391 | 2025-05-19 09:35:26 | detainee | 1 | 82945 | 4 | 1.533 | 54106.3 |
| 390 | 2025-05-14 14:00:27 | detainee | 1 | 82945 | 4 | 4.686 | 17700.6 |
| 389 | 2025-05-06 06:17:27 | detainee | 1 | 82945 | 4 | 7.483 | 11084.5 |
| 388 | 2025-05-02 02:09:19 | detainee | 1 | 82945 | 4 | 4.186 | 19814.9 |
| 387 | 2025-04-29 03:57:17 | detainee | 3 | 146162 | 112 | 9.796 | 14920.6 |
| 386 | 2025-04-27 03:22:36 | detainee | 3 | 146162 | 112 | 7.843 | 18636.0 |
| 385 | 2025-04-22 17:18:13 | detainee | 3 | 146162 | 112 | 6.563 | 22270.6 |
| 384 | 2025-04-16 08:03:39 | detainee | 1 | 82945 | 4 | 3.610 | 22976.5 |
| 383 | 2025-04-12 21:47:55 | detainee | 3 | 146162 | 112 | 14.546 | 10048.3 |
| 382 | 2025-04-11 12:06:56 | detainee | 1 | 82945 | 4 | 5.140 | 16137.2 |
| 381 | 2025-04-11 09:32:50 | detainee | 1 | 82945 | 4 | 8.390 | 9886.2 |
| 380 | 2025-04-10 21:36:29 | detainee | 2 | 121059 | 19 | 18.796 | 6440.7 |
| 379 | 2025-04-07 16:01:52 | detainee | 3 | 146162 | 112 | 34.033 | 4294.7 |
| 378 | 2025-04-05 09:00:13 | detainee | 3 | 146162 | 112 | 11.220 | 13026.9 |
| 377 | 2025-04-03 04:44:22 | detainee | 3 | 146162 | 112 | 34.406 | 4248.2 |
| 376 | 2025-04-01 20:56:13 | detainee | 3 | 146162 | 112 | 46.203 | 3163.5 |
| 375 | 2025-03-31 04:30:10 | detainee | 3 | 146162 | 112 | 51.610 | 2832.0 |
| 374 | 2025-03-29 03:13:31 | detainee | 1 | 82945 | 4 | 4.296 | 19307.5 |
| 373 | 2025-03-28 00:32:58 | detainee | 3 | 146162 | 112 | 6.750 | 21653.6 |
| 372 | 2025-03-16 00:17:49 | detainee | 1 | 82945 | 4 | 5.516 | 15037.2 |
| 371 | 2025-03-15 08:02:26 | detainee | 2 | 121059 | 19 | 4.483 | 27004.0 |
| 370 | 2025-03-11 11:36:53 | detainee | 1 | 82945 | 4 | 4.763 | 17414.4 |
| 369 | 2025-03-10 15:13:08 | detainee | 1 | 82945 | 4 | 8.780 | 9447.0 |
| 368 | 2025-02-25 09:17:36 | detainee | 1 | 82945 | 4 | 6.846 | 12115.8 |
| 367 | 2025-02-24 11:58:34 | detainee | 3 | 146162 | 112 | 36.490 | 4005.5 |
| 366 | 2025-02-24 11:58:34 | detainee | 2 | 121059 | 19 | 21.940 | 5517.7 |
| 365 | 2025-02-24 09:41:08 | detainee | 3 | 146162 | 112 | 28.516 | 5125.6 |