History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offence"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
430 | 2025-08-13 11:45:05 | offence | 1 | 69583 | 3 | 1.063 | 65459.1 |
429 | 2025-08-09 05:30:41 | offence | 1 | 69583 | 3 | 2.750 | 25302.9 |
428 | 2025-08-08 15:23:41 | offence | 3 | 134027 | 79 | 8.576 | 15628.1 |
427 | 2025-08-04 17:35:02 | offence | 1 | 69583 | 3 | 2.843 | 24475.2 |
426 | 2025-07-31 22:25:19 | offence | 3 | 134027 | 79 | 16.093 | 8328.3 |
425 | 2025-07-31 14:49:33 | offence | 4 | 151207 | 594 | 57.156 | 2645.5 |
424 | 2025-07-29 22:14:02 | offence | 3 | 134027 | 79 | 26.360 | 5084.5 |
423 | 2025-07-27 22:33:58 | offence | 4 | 151207 | 594 | 38.676 | 3909.6 |
422 | 2025-07-27 22:33:58 | offence | 4 | 151207 | 594 | 31.690 | 4771.4 |
421 | 2025-07-27 13:01:36 | offence | 4 | 151207 | 594 | 29.033 | 5208.1 |
420 | 2025-07-27 10:55:13 | offence | 1 | 69583 | 3 | 2.920 | 23829.8 |
419 | 2025-07-26 21:46:39 | offence | 4 | 151207 | 594 | 60.050 | 2518.0 |
418 | 2025-07-25 21:47:50 | offence | 4 | 151207 | 594 | 12.220 | 12373.7 |
417 | 2025-07-25 01:40:54 | offence | 4 | 151207 | 594 | 31.220 | 4843.3 |
416 | 2025-07-24 20:22:22 | offence | 1 | 69583 | 3 | 4.123 | 16876.8 |
415 | 2025-07-24 05:19:28 | offence | 4 | 151207 | 594 | 48.613 | 3110.4 |
414 | 2025-07-24 03:00:24 | offence | 4 | 151207 | 594 | 35.566 | 4251.4 |
413 | 2025-07-23 23:41:22 | offence | 4 | 151207 | 594 | 35.860 | 4216.6 |
412 | 2025-07-23 22:17:31 | offence | 4 | 151207 | 594 | 47.190 | 3204.2 |
411 | 2025-07-23 22:10:08 | offence | 4 | 151207 | 594 | 52.520 | 2879.0 |
410 | 2025-07-23 20:04:04 | offence | 1 | 69583 | 3 | 4.376 | 15901.1 |
409 | 2025-07-23 13:47:45 | offence | 4 | 151207 | 594 | 37.643 | 4016.9 |
408 | 2025-07-20 02:25:36 | offence | 4 | 151207 | 594 | 13.000 | 11631.3 |
407 | 2025-07-19 11:41:41 | offence | 1 | 69583 | 3 | 4.250 | 16372.5 |
406 | 2025-07-18 05:44:46 | offence | 3 | 134027 | 79 | 16.113 | 8317.9 |
405 | 2025-07-18 05:05:02 | offence | 4 | 151207 | 594 | 64.550 | 2342.5 |
404 | 2025-07-16 11:53:24 | offence | 3 | 134027 | 79 | 14.626 | 9163.6 |
403 | 2025-07-11 03:52:19 | offence | 3 | 134027 | 79 | 33.720 | 3974.7 |
402 | 2025-07-10 21:20:49 | offence | 3 | 134027 | 79 | 33.900 | 3953.6 |
401 | 2025-07-10 17:39:28 | offence | 1 | 69583 | 3 | 2.873 | 24219.6 |
400 | 2025-07-10 07:35:10 | offence | 3 | 134027 | 79 | 44.516 | 3010.8 |
399 | 2025-07-09 04:11:59 | offence | 3 | 134027 | 79 | 6.173 | 21711.8 |
398 | 2025-07-07 23:22:02 | offence | 3 | 134027 | 79 | 31.723 | 4224.9 |
397 | 2025-07-07 05:32:00 | offence | 1 | 69583 | 3 | 4.500 | 15462.9 |
396 | 2025-06-28 06:43:58 | offence | 1 | 69583 | 3 | 5.830 | 11935.3 |
395 | 2025-06-26 09:24:08 | offence | 1 | 69583 | 3 | 8.766 | 7937.8 |
394 | 2025-06-25 08:21:57 | offence | 3 | 134027 | 79 | 18.123 | 7395.4 |
393 | 2025-06-23 01:44:47 | offence | 3 | 134027 | 79 | 30.533 | 4389.6 |
392 | 2025-06-20 20:12:28 | offence | 1 | 69583 | 3 | 5.016 | 13872.2 |
391 | 2025-06-15 19:11:35 | offence | 3 | 134027 | 79 | 45.190 | 2965.9 |
390 | 2025-06-14 07:41:46 | offence | 1 | 69583 | 3 | 8.546 | 8142.2 |
389 | 2025-06-10 15:00:21 | offence | 1 | 69583 | 3 | 8.313 | 8370.4 |
388 | 2025-06-06 02:44:08 | offence | 3 | 134027 | 79 | 35.753 | 3748.7 |
387 | 2025-06-04 14:54:38 | offence | 3 | 134027 | 79 | 29.283 | 4577.0 |
386 | 2025-06-04 11:12:31 | offence | 1 | 69583 | 3 | 5.060 | 13751.6 |
385 | 2025-06-04 02:04:46 | offence | 3 | 134027 | 79 | 26.426 | 5071.8 |
384 | 2025-06-04 01:27:57 | offence | 3 | 134027 | 79 | 29.330 | 4569.6 |
383 | 2025-06-02 22:08:29 | offence | 3 | 134027 | 79 | 9.376 | 14294.7 |
382 | 2025-06-02 06:18:53 | offence | 4 | 151207 | 594 | 50.066 | 3020.2 |
381 | 2025-05-29 13:12:22 | offence | 4 | 151207 | 594 | 60.143 | 2514.1 |
380 | 2025-05-28 04:11:35 | offence | 3 | 134027 | 79 | 6.733 | 19906.0 |
379 | 2025-05-27 23:03:56 | offence | 2 | 107671 | 14 | 3.343 | 32207.9 |
378 | 2025-05-26 08:04:35 | offence | 3 | 134027 | 79 | 35.236 | 3803.7 |
377 | 2025-05-25 01:07:07 | offence | 1 | 69583 | 3 | 1.203 | 57841.2 |
376 | 2025-05-21 19:01:12 | offence | 3 | 134027 | 79 | 7.330 | 18284.7 |
375 | 2025-05-20 08:56:46 | offence | 3 | 134027 | 79 | 30.500 | 4394.3 |
374 | 2025-05-20 04:51:14 | offence | 1 | 69583 | 3 | 4.670 | 14900.0 |
373 | 2025-05-17 16:24:56 | offence | 4 | 151207 | 594 | 14.626 | 10338.2 |
372 | 2025-05-17 07:17:14 | offence | 4 | 151207 | 594 | 62.423 | 2422.3 |
371 | 2025-05-17 05:15:30 | offence | 4 | 151207 | 594 | 65.016 | 2325.7 |
370 | 2025-05-17 01:49:03 | offence | 4 | 151207 | 594 | 54.363 | 2781.4 |
369 | 2025-05-15 18:58:00 | offence | 4 | 151207 | 594 | 11.283 | 13401.3 |
368 | 2025-05-14 07:16:14 | offence | 1 | 69583 | 3 | 2.800 | 24851.1 |
367 | 2025-05-10 15:55:02 | offence | 1 | 69583 | 3 | 7.500 | 9277.7 |
366 | 2025-05-06 15:44:34 | offence | 1 | 69583 | 3 | 4.580 | 15192.8 |
365 | 2025-05-05 20:01:19 | offence | 4 | 151207 | 594 | 46.363 | 3261.4 |
364 | 2025-05-05 10:22:27 | offence | 1 | 69583 | 3 | 1.313 | 52995.4 |
363 | 2025-05-03 06:50:44 | offence | 4 | 151207 | 594 | 68.753 | 2199.3 |
362 | 2025-04-29 02:17:41 | offence | 3 | 134027 | 79 | 12.686 | 10565.0 |
361 | 2025-04-25 14:20:33 | offence | 3 | 134027 | 79 | 8.533 | 15706.9 |
360 | 2025-04-23 07:49:39 | offence | 3 | 134027 | 79 | 34.456 | 3889.8 |
359 | 2025-04-23 06:49:07 | offence | 2 | 107671 | 14 | 20.860 | 5161.6 |
358 | 2025-04-22 17:31:37 | offence | 2 | 107671 | 14 | 2.873 | 37476.9 |
357 | 2025-04-20 07:41:57 | offence | 1 | 69583 | 3 | 4.843 | 14367.7 |
356 | 2025-04-20 03:46:56 | offence | 1 | 69583 | 3 | 5.653 | 12309.0 |
355 | 2025-04-16 06:52:02 | offence | 4 | 151207 | 594 | 48.990 | 3086.5 |
354 | 2025-04-15 05:22:18 | offence | 4 | 151207 | 594 | 50.750 | 2979.4 |
353 | 2025-04-15 01:49:04 | offence | 4 | 151207 | 594 | 10.203 | 14819.9 |
352 | 2025-04-14 18:59:00 | offence | 4 | 151207 | 594 | 11.706 | 12917.1 |
351 | 2025-04-14 15:37:16 | offence | 4 | 151207 | 594 | 45.926 | 3292.4 |
350 | 2025-04-13 06:46:02 | offence | 4 | 151207 | 594 | 9.440 | 16017.7 |
349 | 2025-04-11 07:12:10 | offence | 1 | 69583 | 3 | 5.203 | 13373.6 |
348 | 2025-04-08 14:07:50 | offence | 1 | 69583 | 3 | 5.750 | 12101.4 |
347 | 2025-04-06 14:56:04 | offence | 1 | 69583 | 3 | 5.783 | 12032.3 |
346 | 2025-03-20 10:05:34 | offence | 1 | 69583 | 3 | 4.813 | 14457.3 |
345 | 2025-03-18 14:57:36 | offence | 1 | 69583 | 3 | 2.283 | 30478.8 |
344 | 2025-03-08 06:58:59 | offence | 3 | 134027 | 79 | 12.236 | 10953.5 |
343 | 2025-03-07 06:54:53 | offence | 3 | 134027 | 79 | 31.826 | 4211.2 |
342 | 2025-03-07 03:24:23 | offence | 3 | 134027 | 79 | 31.936 | 4196.7 |
341 | 2025-03-05 19:26:18 | offence | 3 | 134027 | 79 | 23.096 | 5803.0 |
340 | 2025-03-04 04:46:43 | offence | 1 | 69583 | 3 | 3.126 | 22259.4 |
339 | 2025-03-04 03:10:36 | offence | 1 | 69583 | 3 | 3.860 | 18026.7 |
338 | 2025-02-27 06:36:41 | offence | 1 | 69583 | 3 | 3.360 | 20709.2 |
337 | 2025-02-26 03:25:12 | offence | 3 | 134027 | 79 | 47.880 | 2799.2 |
336 | 2025-02-24 01:26:34 | offence | 3 | 134027 | 79 | 40.643 | 3297.7 |
335 | 2025-02-21 05:19:28 | offence | 2 | 107671 | 14 | 22.393 | 4808.2 |
334 | 2025-02-20 18:25:49 | offence | 3 | 134027 | 79 | 24.733 | 5419.0 |
333 | 2025-02-19 17:28:18 | offence | 3 | 134027 | 79 | 17.160 | 7810.4 |
332 | 2025-02-01 15:07:36 | offence | 1 | 69583 | 3 | 2.780 | 25029.9 |
331 | 2025-01-27 21:49:44 | offence | 3 | 134027 | 79 | 15.846 | 8458.1 |