History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoplifters"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 448 | 2025-11-26 22:30:07 | shoplifters | 4 | 148819 | 58 | 35.240 | 4223.0 |
| 447 | 2025-11-20 02:27:32 | shoplifters | 1 | 49908 | 2 | 0.766 | 65154.0 |
| 446 | 2025-08-10 03:08:31 | shoplifters | 3 | 121633 | 13 | 21.236 | 5727.7 |
| 445 | 2025-08-09 03:25:53 | shoplifters | 1 | 49908 | 2 | 5.313 | 9393.6 |
| 444 | 2025-07-25 09:53:43 | shoplifters | 1 | 49908 | 2 | 1.436 | 34754.9 |
| 443 | 2025-07-24 15:47:18 | shoplifters | 1 | 49908 | 2 | 2.000 | 24954.0 |
| 442 | 2025-07-23 07:51:20 | shoplifters | 1 | 49908 | 2 | 3.093 | 16135.8 |
| 441 | 2025-07-12 04:06:36 | shoplifters | 1 | 49908 | 2 | 0.893 | 55888.0 |
| 440 | 2025-07-11 00:29:10 | shoplifters | 1 | 49908 | 2 | 2.063 | 24192.0 |
| 439 | 2025-07-08 22:27:18 | shoplifters | 3 | 121633 | 13 | 13.783 | 8824.9 |
| 438 | 2025-07-08 21:55:21 | shoplifters | 2 | 86808 | 4 | 2.250 | 38581.3 |
| 437 | 2025-07-08 20:04:52 | shoplifters | 5 | 164607 | 546 | 15.593 | 10556.5 |
| 436 | 2025-07-08 17:30:27 | shoplifters | 5 | 164607 | 546 | 17.733 | 9282.5 |
| 435 | 2025-07-08 09:06:13 | shoplifters | 5 | 164607 | 546 | 58.436 | 2816.9 |
| 434 | 2025-07-07 01:14:53 | shoplifters | 5 | 164607 | 546 | 89.550 | 1838.2 |
| 433 | 2025-07-06 08:51:29 | shoplifters | 1 | 49908 | 2 | 1.703 | 29305.9 |
| 432 | 2025-07-05 22:58:57 | shoplifters | 4 | 148819 | 58 | 8.970 | 16590.7 |
| 431 | 2025-07-05 04:00:57 | shoplifters | 4 | 148819 | 58 | 47.003 | 3166.2 |
| 430 | 2025-07-04 19:05:48 | shoplifters | 5 | 164607 | 546 | 15.610 | 10545.0 |
| 429 | 2025-07-04 17:26:17 | shoplifters | 2 | 86808 | 4 | 4.500 | 19290.7 |
| 428 | 2025-07-04 02:54:45 | shoplifters | 1 | 49908 | 2 | 1.970 | 25334.0 |
| 427 | 2025-07-03 23:30:30 | shoplifters | 3 | 121633 | 13 | 26.923 | 4517.8 |
| 426 | 2025-07-03 21:36:20 | shoplifters | 1 | 49908 | 2 | 5.766 | 8655.6 |
| 425 | 2025-07-03 13:57:21 | shoplifters | 4 | 148819 | 58 | 7.970 | 18672.4 |
| 424 | 2025-06-24 00:34:35 | shoplifters | 4 | 148819 | 58 | 25.110 | 5926.7 |
| 423 | 2025-06-24 00:03:47 | shoplifters | 4 | 148819 | 58 | 50.220 | 2963.3 |
| 422 | 2025-06-22 12:23:05 | shoplifters | 4 | 148819 | 58 | 41.473 | 3588.3 |
| 421 | 2025-06-21 05:53:52 | shoplifters | 1 | 49908 | 2 | 0.750 | 66544.0 |
| 420 | 2025-06-10 06:47:49 | shoplifters | 1 | 49908 | 2 | 2.923 | 17074.2 |
| 419 | 2025-06-09 21:51:13 | shoplifters | 1 | 49908 | 2 | 5.390 | 9259.4 |
| 418 | 2025-06-05 13:41:58 | shoplifters | 3 | 121633 | 13 | 12.250 | 9929.2 |
| 417 | 2025-05-14 08:23:30 | shoplifters | 3 | 121633 | 13 | 30.206 | 4026.8 |
| 416 | 2025-05-09 11:17:22 | shoplifters | 1 | 49908 | 2 | 1.063 | 46950.1 |
| 415 | 2025-05-04 12:00:07 | shoplifters | 3 | 121633 | 13 | 22.923 | 5306.2 |
| 414 | 2025-04-29 21:49:45 | shoplifters | 1 | 49908 | 2 | 2.623 | 19027.1 |
| 413 | 2025-04-22 16:49:28 | shoplifters | 3 | 121633 | 13 | 5.843 | 20816.9 |
| 412 | 2025-04-13 23:30:44 | shoplifters | 3 | 121633 | 13 | 25.563 | 4758.2 |
| 411 | 2025-03-25 19:51:39 | shoplifters | 3 | 121633 | 13 | 23.970 | 5074.4 |
| 410 | 2025-03-23 03:39:18 | shoplifters | 1 | 49908 | 2 | 2.220 | 22481.1 |
| 409 | 2025-03-15 20:49:58 | shoplifters | 1 | 49908 | 2 | 4.076 | 12244.4 |
| 408 | 2025-03-15 19:06:13 | shoplifters | 3 | 121633 | 13 | 29.516 | 4120.9 |
| 407 | 2025-03-15 19:06:04 | shoplifters | 2 | 86808 | 4 | 10.593 | 8194.8 |
| 406 | 2025-03-15 19:04:40 | shoplifters | 1 | 49908 | 2 | 3.920 | 12731.6 |
| 405 | 2025-03-15 18:55:52 | shoplifters | 4 | 148819 | 58 | 44.390 | 3352.5 |
| 404 | 2025-03-14 09:23:49 | shoplifters | 1 | 49908 | 2 | 3.970 | 12571.3 |
| 403 | 2025-03-13 06:45:36 | shoplifters | 3 | 121633 | 13 | 23.423 | 5192.9 |
| 402 | 2025-03-13 06:45:28 | shoplifters | 2 | 86808 | 4 | 10.766 | 8063.2 |
| 401 | 2025-03-13 04:06:08 | shoplifters | 4 | 148819 | 58 | 35.706 | 4167.9 |
| 400 | 2025-03-13 04:06:07 | shoplifters | 3 | 121633 | 13 | 26.813 | 4536.3 |
| 399 | 2025-03-13 04:06:02 | shoplifters | 2 | 86808 | 4 | 12.190 | 7121.2 |
| 398 | 2025-03-13 04:04:52 | shoplifters | 1 | 49908 | 2 | 3.893 | 12819.9 |
| 397 | 2025-03-08 15:51:57 | shoplifters | 4 | 148819 | 58 | 35.330 | 4212.3 |
| 396 | 2025-02-18 23:23:04 | shoplifters | 4 | 148819 | 58 | 50.503 | 2946.7 |
| 395 | 2025-02-14 20:29:07 | shoplifters | 4 | 148819 | 58 | 26.440 | 5628.6 |
| 394 | 2025-02-14 09:14:44 | shoplifters | 4 | 148819 | 58 | 53.626 | 2775.1 |
| 393 | 2025-02-12 01:44:51 | shoplifters | 4 | 148819 | 58 | 37.616 | 3956.3 |
| 392 | 2025-02-04 21:18:21 | shoplifters | 1 | 49908 | 2 | 0.796 | 62698.5 |
| 391 | 2025-02-03 17:36:46 | shoplifters | 1 | 49908 | 2 | 4.060 | 12292.6 |
| 390 | 2025-01-30 01:08:31 | shoplifters | 4 | 148819 | 58 | 54.223 | 2744.6 |
| 389 | 2025-01-29 03:37:47 | shoplifters | 1 | 49908 | 2 | 3.936 | 12679.9 |
| 388 | 2025-01-21 23:05:50 | shoplifters | 3 | 121633 | 13 | 26.550 | 4581.3 |
| 387 | 2025-01-17 00:28:44 | shoplifters | 2 | 86808 | 4 | 17.876 | 4856.1 |
| 386 | 2025-01-13 21:09:50 | shoplifters | 3 | 121633 | 13 | 24.830 | 4898.6 |
| 385 | 2025-01-13 15:48:14 | shoplifters | 3 | 121633 | 13 | 36.096 | 3369.7 |
| 384 | 2025-01-13 03:47:19 | shoplifters | 3 | 121633 | 13 | 17.893 | 6797.8 |
| 383 | 2025-01-12 11:53:27 | shoplifters | 4 | 148819 | 58 | 51.486 | 2890.5 |
| 382 | 2025-01-12 11:52:58 | shoplifters | 3 | 121633 | 13 | 31.126 | 3907.8 |
| 381 | 2024-12-29 23:52:44 | shoplifters | 1 | 49908 | 2 | 2.123 | 23508.2 |
| 380 | 2024-12-28 14:31:58 | shoplifters | 4 | 148819 | 58 | 23.970 | 6208.6 |
| 379 | 2024-12-25 23:50:29 | shoplifters | 1 | 49908 | 2 | 1.936 | 25778.9 |
| 378 | 2024-12-24 23:46:01 | shoplifters | 2 | 86808 | 4 | 10.970 | 7913.2 |
| 377 | 2024-12-23 04:25:29 | shoplifters | 4 | 148819 | 58 | 55.066 | 2702.6 |
| 376 | 2024-12-23 04:25:40 | shoplifters | 3 | 121633 | 13 | 24.673 | 4929.8 |
| 375 | 2024-12-23 04:25:29 | shoplifters | 2 | 86808 | 4 | 17.270 | 5026.5 |
| 374 | 2024-12-23 04:23:30 | shoplifters | 1 | 49908 | 2 | 2.763 | 18063.0 |
| 373 | 2024-12-16 00:01:41 | shoplifters | 1 | 49908 | 2 | 3.860 | 12929.5 |
| 372 | 2024-12-11 07:26:35 | shoplifters | 4 | 148819 | 58 | 48.483 | 3069.5 |
| 371 | 2024-12-11 07:26:31 | shoplifters | 3 | 121633 | 13 | 27.670 | 4395.8 |
| 370 | 2024-12-11 07:26:07 | shoplifters | 2 | 86808 | 4 | 11.810 | 7350.4 |
| 369 | 2024-12-06 11:16:15 | shoplifters | 4 | 148819 | 58 | 49.753 | 2991.2 |
| 368 | 2024-12-05 03:17:27 | shoplifters | 4 | 148819 | 58 | 52.516 | 2833.8 |
| 367 | 2024-12-05 03:17:02 | shoplifters | 3 | 121633 | 13 | 25.390 | 4790.6 |
| 366 | 2024-11-30 16:58:09 | shoplifters | 3 | 121633 | 13 | 34.186 | 3558.0 |
| 365 | 2024-11-24 17:45:41 | shoplifters | 1 | 49908 | 2 | 1.826 | 27331.9 |
| 364 | 2024-11-24 01:38:35 | shoplifters | 5 | 164607 | 546 | 108.146 | 1522.1 |
| 363 | 2024-11-23 14:42:19 | shoplifters | 2 | 86808 | 4 | 2.140 | 40564.5 |
| 362 | 2024-11-23 14:42:14 | shoplifters | 1 | 49908 | 2 | 1.986 | 25129.9 |
| 361 | 2024-11-23 14:40:50 | shoplifters | 5 | 164607 | 546 | 49.486 | 3326.3 |
| 360 | 2024-11-23 03:38:18 | shoplifters | 5 | 164607 | 546 | 78.116 | 2107.2 |
| 359 | 2024-11-23 03:36:40 | shoplifters | 1 | 49908 | 2 | 3.280 | 15215.9 |
| 358 | 2024-11-14 21:13:43 | shoplifters | 3 | 121633 | 13 | 31.893 | 3813.8 |
| 357 | 2024-11-14 21:13:43 | shoplifters | 2 | 86808 | 4 | 8.313 | 10442.4 |
| 356 | 2024-11-05 08:35:18 | shoplifters | 2 | 86808 | 4 | 11.126 | 7802.3 |
| 355 | 2024-11-05 08:35:14 | shoplifters | 3 | 121633 | 13 | 14.000 | 8688.1 |
| 354 | 2024-11-05 08:35:08 | shoplifters | 4 | 148819 | 58 | 12.000 | 12401.6 |
| 353 | 2024-11-05 08:34:46 | shoplifters | 1 | 49908 | 2 | 2.190 | 22789.0 |
| 352 | 2024-10-25 16:37:46 | shoplifters | 4 | 148819 | 58 | 36.940 | 4028.7 |
| 351 | 2024-10-25 01:31:50 | shoplifters | 4 | 148819 | 58 | 46.223 | 3219.6 |
| 350 | 2024-10-25 01:31:43 | shoplifters | 3 | 121633 | 13 | 25.470 | 4775.5 |
| 349 | 2024-10-24 09:04:39 | shoplifters | 4 | 148819 | 58 | 49.006 | 3036.8 |