History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offences"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 497 | 2026-02-14 03:14:04 | offences | 4 | 161609 | 592 | 21.110 | 7655.6 |
| 496 | 2026-02-11 04:06:47 | offences | 1 | 82945 | 3 | 2.030 | 40859.6 |
| 495 | 2026-02-08 11:22:38 | offences | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 494 | 2026-02-08 01:07:13 | offences | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 493 | 2026-02-07 12:54:41 | offences | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 492 | 2026-02-05 16:45:13 | offences | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 491 | 2026-02-04 07:01:11 | offences | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 490 | 2026-02-01 12:42:24 | offences | 1 | 82945 | 3 | 1.410 | 58826.2 |
| 489 | 2026-01-29 18:00:11 | offences | 4 | 161609 | 592 | 11.296 | 14306.7 |
| 488 | 2026-01-29 13:35:22 | offences | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 487 | 2026-01-29 08:54:03 | offences | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 486 | 2026-01-29 01:44:52 | offences | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 485 | 2026-01-26 00:46:44 | offences | 1 | 82945 | 3 | 6.763 | 12264.5 |
| 484 | 2026-01-26 00:46:28 | offences | 1 | 82945 | 3 | 6.623 | 12523.8 |
| 483 | 2026-01-25 17:30:20 | offences | 1 | 82945 | 3 | 1.843 | 45005.4 |
| 482 | 2026-01-24 16:13:41 | offences | 1 | 82945 | 3 | 6.500 | 12760.8 |
| 481 | 2026-01-24 00:38:32 | offences | 4 | 161609 | 592 | 11.923 | 13554.4 |
| 480 | 2026-01-20 17:38:18 | offences | 4 | 161609 | 592 | 67.523 | 2393.4 |
| 479 | 2026-01-20 17:37:52 | offences | 4 | 161609 | 592 | 49.803 | 3245.0 |
| 478 | 2026-01-17 12:01:03 | offences | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 477 | 2026-01-14 13:50:17 | offences | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 476 | 2026-01-11 08:36:27 | offences | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 475 | 2026-01-09 12:13:42 | offences | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 474 | 2026-01-04 16:05:13 | offences | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 473 | 2026-01-04 08:21:45 | offences | 1 | 82945 | 3 | 1.440 | 57600.7 |
| 472 | 2025-12-31 12:08:16 | offences | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 471 | 2025-12-31 03:06:38 | offences | 1 | 82945 | 3 | 1.513 | 54821.5 |
| 470 | 2025-12-27 01:33:44 | offences | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 469 | 2025-12-20 23:15:02 | offences | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 468 | 2025-12-15 15:54:45 | offences | 1 | 82945 | 3 | 2.390 | 34705.0 |
| 467 | 2025-12-10 05:11:11 | offences | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 466 | 2025-12-08 09:10:10 | offences | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 465 | 2025-12-07 23:48:48 | offences | 1 | 82945 | 3 | 1.453 | 57085.3 |
| 464 | 2025-12-02 23:31:15 | offences | 1 | 82945 | 3 | 4.686 | 17700.6 |
| 463 | 2025-11-29 17:07:16 | offences | 3 | 146162 | 74 | 10.236 | 14279.2 |
| 462 | 2025-11-28 03:25:14 | offences | 3 | 146162 | 74 | 13.813 | 10581.5 |
| 461 | 2025-11-27 11:11:13 | offences | 1 | 82945 | 3 | 1.516 | 54713.1 |
| 460 | 2025-11-26 11:37:58 | offences | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 459 | 2025-11-22 20:03:58 | offences | 1 | 82945 | 3 | 4.406 | 18825.5 |
| 458 | 2025-11-21 11:16:03 | offences | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 457 | 2025-11-18 13:02:45 | offences | 1 | 82945 | 3 | 2.983 | 27805.9 |
| 456 | 2025-11-18 13:02:21 | offences | 1 | 82945 | 3 | 3.843 | 21583.4 |
| 455 | 2025-11-14 05:40:35 | offences | 1 | 82945 | 3 | 1.393 | 59544.1 |
| 454 | 2025-11-13 20:32:14 | offences | 1 | 82945 | 3 | 1.486 | 55817.6 |
| 453 | 2025-11-01 12:43:30 | offences | 1 | 82945 | 3 | 1.403 | 59119.7 |
| 452 | 2025-10-26 14:25:56 | offences | 2 | 121059 | 14 | 3.640 | 33258.0 |
| 451 | 2025-10-26 12:37:41 | offences | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 450 | 2025-10-24 13:03:58 | offences | 1 | 82945 | 3 | 1.360 | 60989.0 |
| 449 | 2025-10-24 12:21:42 | offences | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 448 | 2025-10-24 11:47:40 | offences | 1 | 82945 | 3 | 1.750 | 47397.1 |
| 447 | 2025-10-22 10:53:25 | offences | 1 | 82945 | 3 | 5.843 | 14195.6 |
| 446 | 2025-10-22 10:53:11 | offences | 1 | 82945 | 3 | 6.906 | 12010.6 |
| 445 | 2025-10-13 14:06:26 | offences | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 444 | 2025-10-01 09:57:56 | offences | 1 | 82945 | 3 | 1.470 | 56425.2 |
| 443 | 2025-09-26 04:13:07 | offences | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 442 | 2025-09-26 04:13:06 | offences | 1 | 82945 | 3 | 1.796 | 46183.2 |
| 441 | 2025-09-23 15:04:28 | offences | 2 | 121059 | 14 | 3.343 | 36212.7 |
| 440 | 2025-09-20 00:47:44 | offences | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 439 | 2025-09-15 19:55:26 | offences | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 438 | 2025-09-14 20:11:23 | offences | 1 | 82945 | 3 | 1.436 | 57761.1 |
| 437 | 2025-09-08 00:38:31 | offences | 1 | 82945 | 3 | 1.406 | 58993.6 |
| 436 | 2025-09-04 10:50:06 | offences | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 435 | 2025-09-02 18:16:36 | offences | 1 | 82945 | 3 | 1.423 | 58288.8 |
| 434 | 2025-08-21 14:27:50 | offences | 1 | 82945 | 3 | 2.813 | 29486.3 |
| 433 | 2025-08-15 04:26:50 | offences | 1 | 82945 | 3 | 6.640 | 12491.7 |
| 432 | 2025-08-12 00:38:52 | offences | 1 | 82945 | 3 | 5.860 | 14154.4 |
| 431 | 2025-08-08 00:22:30 | offences | 2 | 121059 | 14 | 3.906 | 30993.1 |
| 430 | 2025-08-04 01:54:44 | offences | 1 | 82945 | 3 | 2.780 | 29836.3 |
| 429 | 2025-07-26 08:59:28 | offences | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 428 | 2025-07-24 17:56:41 | offences | 1 | 82945 | 3 | 6.783 | 12228.4 |
| 427 | 2025-07-23 07:38:34 | offences | 1 | 82945 | 3 | 5.813 | 14268.9 |
| 426 | 2025-07-23 06:37:46 | offences | 1 | 82945 | 3 | 7.686 | 10791.7 |
| 425 | 2025-07-18 10:20:09 | offences | 1 | 82945 | 3 | 10.436 | 7948.0 |
| 424 | 2025-07-17 18:59:21 | offences | 3 | 146162 | 74 | 25.783 | 5668.9 |
| 423 | 2025-07-08 07:09:52 | offences | 3 | 146162 | 74 | 35.040 | 4171.3 |
| 422 | 2025-07-07 12:44:28 | offences | 3 | 146162 | 74 | 29.300 | 4988.5 |
| 421 | 2025-07-06 16:17:31 | offences | 3 | 146162 | 74 | 6.220 | 23498.7 |
| 420 | 2025-07-05 18:01:13 | offences | 2 | 121059 | 14 | 16.203 | 7471.4 |
| 419 | 2025-07-05 10:25:13 | offences | 3 | 146162 | 74 | 33.316 | 4387.1 |
| 418 | 2025-07-04 12:44:40 | offences | 1 | 82945 | 3 | 6.030 | 13755.4 |
| 417 | 2025-07-04 01:26:25 | offences | 1 | 82945 | 3 | 6.766 | 12259.1 |
| 416 | 2025-07-02 10:48:19 | offences | 1 | 82945 | 3 | 6.810 | 12179.9 |
| 415 | 2025-07-02 01:09:50 | offences | 1 | 82945 | 3 | 10.330 | 8029.5 |
| 414 | 2025-06-29 19:40:59 | offences | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 413 | 2025-06-14 13:49:16 | offences | 1 | 82945 | 3 | 6.846 | 12115.8 |
| 412 | 2025-06-04 00:24:35 | offences | 1 | 82945 | 3 | 4.250 | 19516.5 |
| 411 | 2025-06-01 12:17:43 | offences | 1 | 82945 | 3 | 3.030 | 27374.6 |
| 410 | 2025-05-29 03:05:22 | offences | 1 | 82945 | 3 | 6.470 | 12819.9 |
| 409 | 2025-05-13 12:33:42 | offences | 3 | 146162 | 74 | 17.580 | 8314.1 |
| 408 | 2025-05-13 12:02:06 | offences | 2 | 121059 | 14 | 3.686 | 32842.9 |
| 407 | 2025-05-12 07:01:10 | offences | 3 | 146162 | 74 | 23.160 | 6311.0 |
| 406 | 2025-05-12 06:20:01 | offences | 2 | 121059 | 14 | 15.940 | 7594.7 |
| 405 | 2025-05-11 16:51:34 | offences | 1 | 82945 | 3 | 1.533 | 54106.3 |
| 404 | 2025-05-06 00:29:40 | offences | 1 | 82945 | 3 | 6.890 | 12038.5 |
| 403 | 2025-05-04 06:03:21 | offences | 4 | 161609 | 592 | 57.130 | 2828.8 |
| 402 | 2025-05-04 03:51:18 | offences | 4 | 161609 | 592 | 53.326 | 3030.6 |
| 401 | 2025-05-03 13:58:08 | offences | 4 | 161609 | 592 | 12.346 | 13090.0 |
| 400 | 2025-05-03 13:41:08 | offences | 4 | 161609 | 592 | 28.720 | 5627.1 |
| 399 | 2025-05-03 04:38:54 | offences | 4 | 161609 | 592 | 50.380 | 3207.8 |
| 398 | 2025-05-01 15:01:04 | offences | 4 | 161609 | 592 | 13.000 | 12431.5 |