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 |
| 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 |
| 397 | 2025-04-30 00:14:49 | offences | 1 | 82945 | 3 | 7.236 | 11462.8 |
| 396 | 2025-04-27 00:30:58 | offences | 3 | 146162 | 74 | 6.360 | 22981.4 |
| 395 | 2025-04-25 20:50:16 | offences | 3 | 146162 | 74 | 35.490 | 4118.4 |
| 394 | 2025-04-23 16:46:36 | offences | 2 | 121059 | 14 | 16.173 | 7485.3 |
| 393 | 2025-04-23 09:01:20 | offences | 3 | 146162 | 74 | 30.356 | 4814.9 |
| 392 | 2025-04-22 12:04:11 | offences | 1 | 82945 | 3 | 1.483 | 55930.5 |
| 391 | 2025-03-31 16:13:46 | offences | 3 | 146162 | 74 | 29.906 | 4887.4 |
| 390 | 2025-03-22 18:49:35 | offences | 2 | 121059 | 14 | 3.376 | 35858.7 |
| 389 | 2025-03-22 14:34:29 | offences | 1 | 82945 | 3 | 8.423 | 9847.4 |
| 388 | 2025-03-20 11:07:51 | offences | 3 | 146162 | 74 | 35.033 | 4172.1 |
| 387 | 2025-03-20 01:09:20 | offences | 1 | 82945 | 3 | 4.076 | 20349.6 |
| 386 | 2025-03-19 10:28:42 | offences | 2 | 121059 | 14 | 3.453 | 35059.1 |
| 385 | 2025-03-17 19:06:21 | offences | 3 | 146162 | 74 | 51.380 | 2844.7 |
| 384 | 2025-03-11 00:24:28 | offences | 3 | 146162 | 74 | 37.313 | 3917.2 |
| 383 | 2025-03-10 07:09:30 | offences | 3 | 146162 | 74 | 30.000 | 4872.1 |
| 382 | 2025-03-10 04:17:39 | offences | 3 | 146162 | 74 | 28.190 | 5184.9 |
| 381 | 2025-03-10 00:22:34 | offences | 1 | 82945 | 3 | 6.346 | 13070.4 |
| 380 | 2025-03-09 03:53:03 | offences | 3 | 146162 | 74 | 35.796 | 4083.2 |
| 379 | 2025-03-01 13:50:41 | offences | 4 | 161609 | 592 | 52.503 | 3078.1 |
| 378 | 2025-02-28 09:10:57 | offences | 4 | 161609 | 592 | 57.673 | 2802.2 |
| 377 | 2025-02-28 07:36:20 | offences | 4 | 161609 | 592 | 56.720 | 2849.2 |
| 376 | 2025-02-25 18:02:47 | offences | 4 | 161609 | 592 | 41.406 | 3903.0 |
| 375 | 2025-02-25 08:04:07 | offences | 4 | 161609 | 592 | 12.000 | 13467.4 |
| 374 | 2025-02-24 13:09:07 | offences | 1 | 82945 | 3 | 6.516 | 12729.4 |
| 373 | 2025-02-16 20:34:53 | offences | 3 | 146162 | 74 | 18.376 | 7954.0 |
| 372 | 2025-02-12 17:11:48 | offences | 1 | 82945 | 3 | 6.830 | 12144.2 |
| 371 | 2025-02-10 07:35:48 | offences | 1 | 82945 | 3 | 5.280 | 15709.3 |
| 370 | 2025-02-05 00:57:04 | offences | 1 | 82945 | 3 | 8.033 | 10325.5 |
| 369 | 2025-02-04 09:43:23 | offences | 3 | 146162 | 74 | 32.910 | 4441.3 |
| 368 | 2025-02-03 01:19:04 | offences | 3 | 146162 | 74 | 36.173 | 4040.6 |