History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoplifter"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 476 | 2025-11-29 04:48:53 | shoplifter | 1 | 67641 | 3 | 1.046 | 64666.3 |
| 475 | 2025-11-24 18:50:59 | shoplifter | 2 | 108824 | 5 | 6.016 | 18089.1 |
| 474 | 2025-11-21 08:46:09 | shoplifter | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 473 | 2025-11-16 02:04:28 | shoplifter | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 472 | 2025-11-12 22:46:40 | shoplifter | 5 | 173545 | 837 | 21.813 | 7956.0 |
| 471 | 2025-11-12 07:47:54 | shoplifter | 5 | 173545 | 837 | 15.796 | 10986.6 |
| 470 | 2025-11-12 07:47:16 | shoplifter | 5 | 173545 | 837 | 15.610 | 11117.6 |
| 469 | 2025-11-11 22:17:19 | shoplifter | 5 | 173545 | 837 | 16.080 | 10792.6 |
| 468 | 2025-11-07 22:12:27 | shoplifter | 5 | 173545 | 837 | 16.940 | 10244.7 |
| 467 | 2025-11-05 14:16:50 | shoplifter | 5 | 173545 | 837 | 23.610 | 7350.5 |
| 466 | 2025-10-23 10:11:25 | shoplifter | 5 | 173545 | 837 | 99.346 | 1746.9 |
| 465 | 2025-10-13 12:51:36 | shoplifter | 5 | 173545 | 837 | 17.800 | 9749.7 |
| 464 | 2025-10-09 19:22:06 | shoplifter | 5 | 173545 | 837 | 17.003 | 10206.7 |
| 463 | 2025-10-02 08:04:25 | shoplifter | 5 | 173545 | 837 | 15.393 | 11274.3 |
| 462 | 2025-10-01 10:49:28 | shoplifter | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 461 | 2025-09-29 19:36:14 | shoplifter | 5 | 173545 | 837 | 15.703 | 11051.7 |
| 460 | 2025-09-24 23:17:45 | shoplifter | 5 | 173545 | 837 | 66.813 | 2597.5 |
| 459 | 2025-09-24 16:45:55 | shoplifter | 2 | 108824 | 5 | 3.076 | 35378.4 |
| 458 | 2025-09-18 03:14:59 | shoplifter | 5 | 173545 | 837 | 16.250 | 10679.7 |
| 457 | 2025-09-15 00:15:40 | shoplifter | 2 | 108824 | 5 | 3.170 | 34329.3 |
| 456 | 2025-09-14 22:13:59 | shoplifter | 1 | 67641 | 3 | 1.063 | 63632.2 |
| 455 | 2025-09-11 23:29:37 | shoplifter | 5 | 173545 | 837 | 15.656 | 11084.9 |
| 454 | 2025-09-09 09:18:15 | shoplifter | 5 | 173545 | 837 | 17.876 | 9708.3 |
| 453 | 2025-09-03 01:39:17 | shoplifter | 5 | 173545 | 837 | 16.813 | 10322.1 |
| 452 | 2025-08-27 12:22:02 | shoplifter | 5 | 173545 | 837 | 19.640 | 8836.3 |
| 451 | 2025-08-25 21:17:06 | shoplifter | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 450 | 2025-08-14 16:20:07 | shoplifter | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 449 | 2025-08-10 01:20:26 | shoplifter | 1 | 67641 | 3 | 2.576 | 26258.2 |
| 448 | 2025-08-09 05:25:20 | shoplifter | 1 | 67641 | 3 | 7.563 | 8943.7 |
| 447 | 2025-08-05 19:51:32 | shoplifter | 1 | 67641 | 3 | 2.076 | 32582.4 |
| 446 | 2025-07-28 18:48:36 | shoplifter | 1 | 67641 | 3 | 2.716 | 24904.6 |
| 445 | 2025-07-24 00:32:54 | shoplifter | 1 | 67641 | 3 | 5.003 | 13520.1 |
| 444 | 2025-07-14 20:11:05 | shoplifter | 2 | 108824 | 5 | 21.516 | 5057.8 |
| 443 | 2025-07-14 13:06:58 | shoplifter | 1 | 67641 | 3 | 3.046 | 22206.5 |
| 442 | 2025-07-12 00:43:36 | shoplifter | 4 | 161450 | 88 | 10.656 | 15151.1 |
| 441 | 2025-07-10 16:08:45 | shoplifter | 1 | 67641 | 3 | 2.560 | 26422.3 |
| 440 | 2025-07-10 10:22:20 | shoplifter | 3 | 140603 | 15 | 13.140 | 10700.4 |
| 439 | 2025-07-05 17:06:08 | shoplifter | 3 | 140603 | 15 | 21.766 | 6459.8 |
| 438 | 2025-07-05 08:08:40 | shoplifter | 3 | 140603 | 15 | 32.406 | 4338.8 |
| 437 | 2025-07-04 00:11:38 | shoplifter | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 436 | 2025-07-03 04:24:35 | shoplifter | 4 | 161450 | 88 | 54.863 | 2942.8 |
| 435 | 2025-07-01 00:01:30 | shoplifter | 4 | 161450 | 88 | 11.330 | 14249.8 |
| 434 | 2025-06-27 21:09:53 | shoplifter | 4 | 161450 | 88 | 54.876 | 2942.1 |
| 433 | 2025-06-21 10:29:49 | shoplifter | 1 | 67641 | 3 | 5.096 | 13273.4 |
| 432 | 2025-06-21 07:02:45 | shoplifter | 2 | 108824 | 5 | 15.140 | 7187.8 |
| 431 | 2025-06-20 10:37:18 | shoplifter | 3 | 140603 | 15 | 6.533 | 21522.0 |
| 430 | 2025-06-02 07:57:48 | shoplifter | 3 | 140603 | 15 | 34.190 | 4112.4 |
| 429 | 2025-05-17 10:15:43 | shoplifter | 3 | 140603 | 15 | 44.390 | 3167.4 |
| 428 | 2025-05-14 14:25:40 | shoplifter | 3 | 140603 | 15 | 38.910 | 3613.5 |
| 427 | 2025-05-13 21:37:16 | shoplifter | 4 | 161450 | 88 | 51.596 | 3129.1 |
| 426 | 2025-05-13 13:16:55 | shoplifter | 1 | 67641 | 3 | 4.310 | 15694.0 |
| 425 | 2025-05-12 23:02:01 | shoplifter | 3 | 140603 | 15 | 5.720 | 24580.9 |
| 424 | 2025-05-08 11:20:42 | shoplifter | 4 | 161450 | 88 | 44.956 | 3591.3 |
| 423 | 2025-05-08 00:16:00 | shoplifter | 1 | 67641 | 3 | 3.623 | 18669.9 |
| 422 | 2025-05-03 11:08:21 | shoplifter | 1 | 67641 | 3 | 2.063 | 32787.7 |
| 421 | 2025-04-30 15:53:43 | shoplifter | 3 | 140603 | 15 | 43.503 | 3232.0 |
| 420 | 2025-04-28 20:27:08 | shoplifter | 4 | 161450 | 88 | 14.423 | 11193.9 |
| 419 | 2025-04-27 07:25:36 | shoplifter | 4 | 161450 | 88 | 35.816 | 4507.8 |
| 418 | 2025-04-26 01:29:36 | shoplifter | 1 | 67641 | 3 | 7.096 | 9532.3 |
| 417 | 2025-04-16 02:34:34 | shoplifter | 1 | 67641 | 3 | 2.626 | 25758.2 |
| 416 | 2025-04-15 00:29:09 | shoplifter | 2 | 108824 | 5 | 6.783 | 16043.6 |
| 415 | 2025-04-05 06:57:27 | shoplifter | 4 | 161450 | 88 | 37.816 | 4269.4 |
| 414 | 2025-04-05 00:18:37 | shoplifter | 4 | 161450 | 88 | 11.063 | 14593.7 |
| 413 | 2025-04-04 21:55:05 | shoplifter | 2 | 108824 | 5 | 23.596 | 4612.0 |
| 412 | 2025-04-04 21:25:10 | shoplifter | 3 | 140603 | 15 | 27.076 | 5192.9 |
| 411 | 2025-03-30 19:57:06 | shoplifter | 2 | 108824 | 5 | 15.690 | 6935.9 |
| 410 | 2025-03-28 15:14:29 | shoplifter | 3 | 140603 | 15 | 5.720 | 24580.9 |
| 409 | 2025-03-27 01:45:11 | shoplifter | 1 | 67641 | 3 | 3.156 | 21432.5 |
| 408 | 2025-03-21 02:02:56 | shoplifter | 1 | 67641 | 3 | 5.220 | 12958.0 |
| 407 | 2025-03-17 07:48:17 | shoplifter | 1 | 67641 | 3 | 7.830 | 8638.7 |
| 406 | 2025-03-15 19:06:01 | shoplifter | 1 | 67641 | 3 | 2.640 | 25621.6 |
| 405 | 2025-03-15 18:55:50 | shoplifter | 3 | 140603 | 15 | 30.546 | 4603.0 |
| 404 | 2025-03-13 06:45:31 | shoplifter | 2 | 108824 | 5 | 15.706 | 6928.8 |
| 403 | 2025-03-13 04:06:30 | shoplifter | 2 | 108824 | 5 | 16.033 | 6787.5 |
| 402 | 2025-03-13 04:06:17 | shoplifter | 3 | 140603 | 15 | 25.626 | 5486.7 |
| 401 | 2025-03-13 04:03:38 | shoplifter | 1 | 67641 | 3 | 5.533 | 12225.0 |
| 400 | 2025-03-08 15:51:48 | shoplifter | 3 | 140603 | 15 | 45.766 | 3072.2 |
| 399 | 2025-02-23 07:05:59 | shoplifter | 3 | 140603 | 15 | 20.503 | 6857.7 |
| 398 | 2025-02-12 01:44:36 | shoplifter | 3 | 140603 | 15 | 35.990 | 3906.7 |
| 397 | 2025-02-04 21:18:13 | shoplifter | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 396 | 2025-02-01 23:17:54 | shoplifter | 3 | 140603 | 15 | 28.063 | 5010.3 |
| 395 | 2025-02-01 23:15:04 | shoplifter | 1 | 67641 | 3 | 3.910 | 17299.5 |
| 394 | 2025-01-29 10:29:04 | shoplifter | 1 | 67641 | 3 | 4.546 | 14879.2 |
| 393 | 2025-01-20 12:47:25 | shoplifter | 3 | 140603 | 15 | 36.706 | 3830.5 |
| 392 | 2025-01-19 19:56:19 | shoplifter | 3 | 140603 | 15 | 26.906 | 5225.7 |
| 391 | 2025-01-19 19:51:47 | shoplifter | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 390 | 2025-01-17 00:28:47 | shoplifter | 2 | 108824 | 5 | 14.846 | 7330.2 |
| 389 | 2025-01-12 11:53:10 | shoplifter | 3 | 140603 | 15 | 30.453 | 4617.0 |
| 388 | 2024-12-31 01:58:43 | shoplifter | 3 | 140603 | 15 | 31.190 | 4508.0 |
| 387 | 2024-12-31 01:57:00 | shoplifter | 1 | 67641 | 3 | 3.983 | 16982.4 |
| 386 | 2024-12-29 23:52:54 | shoplifter | 3 | 140603 | 15 | 26.050 | 5397.4 |
| 385 | 2024-12-29 23:52:37 | shoplifter | 1 | 67641 | 3 | 2.313 | 29243.8 |
| 384 | 2024-12-24 23:46:02 | shoplifter | 2 | 108824 | 5 | 15.486 | 7027.3 |
| 383 | 2024-12-23 04:26:26 | shoplifter | 3 | 140603 | 15 | 39.910 | 3523.0 |
| 382 | 2024-12-23 04:26:27 | shoplifter | 2 | 108824 | 5 | 14.563 | 7472.6 |
| 381 | 2024-12-23 04:23:17 | shoplifter | 1 | 67641 | 3 | 3.296 | 20522.1 |
| 380 | 2024-12-16 09:44:58 | shoplifter | 3 | 140603 | 15 | 33.626 | 4181.4 |
| 379 | 2024-12-11 07:26:19 | shoplifter | 2 | 108824 | 5 | 12.670 | 8589.1 |
| 378 | 2024-12-05 03:19:23 | shoplifter | 3 | 140603 | 15 | 31.613 | 4447.6 |
| 377 | 2024-12-04 09:27:45 | shoplifter | 4 | 161450 | 88 | 71.350 | 2262.8 |