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 |
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 |
367 | 2025-01-28 14:54:57 | offences | 3 | 146162 | 74 | 29.203 | 5005.0 |
366 | 2025-01-28 14:55:01 | offences | 2 | 121059 | 14 | 17.280 | 7005.7 |
365 | 2025-01-28 10:36:18 | offences | 2 | 121059 | 14 | 15.253 | 7936.7 |
364 | 2025-01-27 21:49:46 | offences | 3 | 146162 | 74 | 28.363 | 5153.3 |
363 | 2025-01-27 16:12:02 | offences | 3 | 146162 | 74 | 26.000 | 5621.6 |
362 | 2025-01-26 21:17:52 | offences | 4 | 161609 | 592 | 58.536 | 2760.8 |
361 | 2025-01-26 17:49:55 | offences | 4 | 161609 | 592 | 55.426 | 2915.8 |
360 | 2025-01-26 14:34:45 | offences | 4 | 161609 | 592 | 15.156 | 10663.0 |
359 | 2025-01-22 16:24:56 | offences | 4 | 161609 | 592 | 63.283 | 2553.8 |
358 | 2025-01-21 20:03:58 | offences | 1 | 82945 | 3 | 6.830 | 12144.2 |
357 | 2025-01-21 17:01:56 | offences | 4 | 161609 | 592 | 32.470 | 4977.2 |
356 | 2025-01-08 03:19:54 | offences | 2 | 121059 | 14 | 10.940 | 11065.7 |
355 | 2025-01-08 03:19:46 | offences | 1 | 82945 | 3 | 2.736 | 30316.2 |
354 | 2025-01-05 11:39:22 | offences | 1 | 82945 | 3 | 5.563 | 14910.1 |
353 | 2024-12-29 20:27:30 | offences | 2 | 121059 | 14 | 11.890 | 10181.6 |
352 | 2024-12-27 19:47:23 | offences | 3 | 146162 | 74 | 26.563 | 5502.5 |
351 | 2024-12-27 16:00:24 | offences | 4 | 161609 | 592 | 43.393 | 3724.3 |
350 | 2024-12-27 09:40:42 | offences | 4 | 161609 | 592 | 67.016 | 2411.5 |
349 | 2024-12-27 09:12:46 | offences | 4 | 161609 | 592 | 12.703 | 12722.1 |
348 | 2024-12-27 09:12:46 | offences | 2 | 121059 | 14 | 6.266 | 19320.0 |
347 | 2024-12-27 09:12:14 | offences | 3 | 146162 | 74 | 7.266 | 20115.9 |
346 | 2024-12-23 21:30:41 | offences | 3 | 146162 | 74 | 48.436 | 3017.6 |
345 | 2024-12-23 21:05:51 | offences | 3 | 146162 | 74 | 27.343 | 5345.5 |
344 | 2024-12-18 00:44:53 | offences | 1 | 82945 | 3 | 6.546 | 12671.1 |
343 | 2024-12-09 00:14:53 | offences | 1 | 82945 | 3 | 3.453 | 24021.1 |
342 | 2024-12-06 18:11:35 | offences | 3 | 146162 | 74 | 30.500 | 4792.2 |
341 | 2024-12-06 18:11:29 | offences | 1 | 82945 | 3 | 4.123 | 20117.6 |
340 | 2024-11-24 09:45:26 | offences | 3 | 146162 | 74 | 34.360 | 4253.8 |
339 | 2024-11-20 07:57:17 | offences | 3 | 146162 | 74 | 37.970 | 3849.4 |
338 | 2024-11-18 09:13:15 | offences | 3 | 146162 | 74 | 6.203 | 23563.1 |
337 | 2024-11-18 09:13:08 | offences | 3 | 146162 | 74 | 7.376 | 19815.9 |
336 | 2024-11-18 09:13:10 | offences | 2 | 121059 | 14 | 3.796 | 31891.2 |