History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violator"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
424 | 2025-06-30 09:20:59 | violator | 4 | 161609 | 472 | 58.036 | 2784.6 |
423 | 2025-06-29 00:34:08 | violator | 4 | 161609 | 472 | 44.160 | 3659.6 |
422 | 2025-06-27 05:17:22 | violator | 4 | 161609 | 472 | 58.453 | 2764.8 |
421 | 2025-06-27 03:02:15 | violator | 4 | 161609 | 472 | 46.066 | 3508.2 |
420 | 2025-06-27 01:29:39 | violator | 4 | 161609 | 472 | 40.313 | 4008.9 |
419 | 2025-06-25 16:33:48 | violator | 4 | 161609 | 472 | 75.113 | 2151.5 |
418 | 2025-06-25 14:33:22 | violator | 2 | 121059 | 14 | 8.906 | 13593.0 |
417 | 2025-06-25 06:01:16 | violator | 3 | 146162 | 77 | 28.423 | 5142.4 |
416 | 2025-06-25 04:36:05 | violator | 3 | 146162 | 77 | 35.203 | 4152.0 |
415 | 2025-06-21 06:32:38 | violator | 3 | 146162 | 77 | 36.156 | 4042.5 |
414 | 2025-06-20 07:02:22 | violator | 3 | 146162 | 77 | 42.286 | 3456.5 |
413 | 2025-06-06 15:18:45 | violator | 1 | 82945 | 3 | 7.280 | 11393.5 |
412 | 2025-05-28 00:38:37 | violator | 1 | 82945 | 3 | 1.466 | 56579.1 |
411 | 2025-05-26 15:05:17 | violator | 1 | 82945 | 3 | 3.356 | 24715.4 |
410 | 2025-05-22 15:24:01 | violator | 1 | 82945 | 3 | 8.173 | 10148.7 |
409 | 2025-05-22 12:58:04 | violator | 3 | 146162 | 77 | 34.050 | 4292.6 |
408 | 2025-05-13 16:19:46 | violator | 3 | 146162 | 77 | 71.160 | 2054.0 |
407 | 2025-05-13 14:26:52 | violator | 2 | 121059 | 14 | 6.720 | 18014.7 |
406 | 2025-05-12 08:01:16 | violator | 1 | 82945 | 3 | 6.716 | 12350.4 |
405 | 2025-05-10 05:14:21 | violator | 3 | 146162 | 77 | 35.603 | 4105.3 |
404 | 2025-05-06 15:30:50 | violator | 3 | 146162 | 77 | 35.063 | 4168.6 |
403 | 2025-05-05 03:31:28 | violator | 3 | 146162 | 77 | 6.626 | 22058.9 |
402 | 2025-05-03 15:06:15 | violator | 3 | 146162 | 77 | 7.173 | 20376.7 |
401 | 2025-04-25 13:12:36 | violator | 4 | 161609 | 472 | 12.516 | 12912.2 |
400 | 2025-04-24 12:13:01 | violator | 1 | 82945 | 3 | 3.300 | 25134.8 |
399 | 2025-04-23 13:18:26 | violator | 1 | 82945 | 3 | 7.173 | 11563.5 |
398 | 2025-04-16 14:11:01 | violator | 1 | 82945 | 3 | 3.126 | 26533.9 |
397 | 2025-04-08 08:05:45 | violator | 4 | 161609 | 472 | 64.516 | 2504.9 |
396 | 2025-04-08 00:28:37 | violator | 4 | 161609 | 472 | 48.783 | 3312.8 |
395 | 2025-04-07 15:10:58 | violator | 3 | 146162 | 77 | 15.830 | 9233.2 |
394 | 2025-04-06 16:47:39 | violator | 4 | 161609 | 472 | 71.380 | 2264.1 |
393 | 2025-04-05 14:12:54 | violator | 2 | 121059 | 14 | 3.406 | 35542.9 |
392 | 2025-04-05 06:11:54 | violator | 3 | 146162 | 77 | 6.750 | 21653.6 |
391 | 2025-03-25 04:58:22 | violator | 3 | 146162 | 77 | 39.016 | 3746.2 |
390 | 2025-03-25 03:33:24 | violator | 2 | 121059 | 14 | 10.060 | 12033.7 |
389 | 2025-03-23 15:28:33 | violator | 1 | 82945 | 3 | 4.033 | 20566.6 |
388 | 2025-03-21 22:06:55 | violator | 4 | 161609 | 472 | 12.873 | 12554.1 |
387 | 2025-03-20 14:13:20 | violator | 1 | 82945 | 3 | 6.640 | 12491.7 |
386 | 2025-03-19 04:42:42 | violator | 1 | 82945 | 3 | 1.343 | 61761.0 |
385 | 2025-03-19 01:04:05 | violator | 4 | 161609 | 472 | 31.500 | 5130.4 |
384 | 2025-03-18 12:44:39 | violator | 1 | 82945 | 3 | 1.343 | 61761.0 |
383 | 2025-03-13 07:17:34 | violator | 1 | 82945 | 3 | 2.953 | 28088.4 |
382 | 2025-03-12 01:05:13 | violator | 4 | 161609 | 472 | 58.830 | 2747.1 |
381 | 2025-03-08 04:00:58 | violator | 4 | 161609 | 472 | 70.660 | 2287.1 |
380 | 2025-03-06 18:50:52 | violator | 4 | 161609 | 472 | 94.166 | 1716.2 |
379 | 2025-03-06 14:13:00 | violator | 4 | 161609 | 472 | 78.566 | 2057.0 |
378 | 2025-03-05 17:48:53 | violator | 4 | 161609 | 472 | 45.076 | 3585.3 |
377 | 2025-03-04 04:33:07 | violator | 4 | 161609 | 472 | 61.223 | 2639.7 |
376 | 2025-03-02 22:47:37 | violator | 1 | 82945 | 3 | 6.343 | 13076.6 |
375 | 2025-02-13 12:28:05 | violator | 4 | 161609 | 472 | 50.426 | 3204.9 |
374 | 2025-02-11 21:00:12 | violator | 2 | 121059 | 14 | 16.360 | 7399.7 |
373 | 2025-02-10 12:17:12 | violator | 1 | 82945 | 3 | 6.673 | 12429.9 |
372 | 2025-02-10 12:12:26 | violator | 2 | 121059 | 14 | 3.750 | 32282.4 |
371 | 2025-02-07 23:46:09 | violator | 3 | 146162 | 77 | 24.940 | 5860.5 |
370 | 2025-02-07 20:43:39 | violator | 3 | 146162 | 77 | 20.610 | 7091.8 |
369 | 2025-02-04 19:51:27 | violator | 3 | 146162 | 77 | 46.410 | 3149.4 |
368 | 2025-02-04 12:49:02 | violator | 3 | 146162 | 77 | 24.860 | 5879.4 |
367 | 2025-02-04 12:49:04 | violator | 2 | 121059 | 14 | 17.986 | 6730.7 |
366 | 2025-02-04 12:37:31 | violator | 1 | 82945 | 3 | 2.233 | 37145.1 |
365 | 2025-02-02 06:56:05 | violator | 4 | 161609 | 472 | 60.490 | 2671.7 |
364 | 2025-02-01 10:23:14 | violator | 1 | 82945 | 3 | 3.233 | 25655.7 |
363 | 2025-01-31 03:18:00 | violator | 1 | 82945 | 3 | 6.843 | 12121.1 |
362 | 2025-01-30 16:43:07 | violator | 4 | 161609 | 472 | 79.053 | 2044.3 |
361 | 2025-01-30 16:36:35 | violator | 4 | 161609 | 472 | 64.256 | 2515.1 |
360 | 2025-01-30 15:54:37 | violator | 4 | 161609 | 472 | 67.440 | 2396.3 |
359 | 2025-01-10 15:21:19 | violator | 1 | 82945 | 3 | 3.440 | 24111.9 |
358 | 2024-12-30 13:37:41 | violator | 2 | 121059 | 14 | 18.080 | 6695.7 |
357 | 2024-12-30 13:32:00 | violator | 1 | 82945 | 3 | 1.360 | 60989.0 |
356 | 2024-12-30 00:28:16 | violator | 3 | 146162 | 77 | 16.313 | 8959.8 |
355 | 2024-12-30 00:28:16 | violator | 3 | 146162 | 77 | 15.313 | 9545.0 |
354 | 2024-12-30 00:28:22 | violator | 1 | 82945 | 3 | 2.406 | 34474.2 |
353 | 2024-12-30 00:28:14 | violator | 2 | 121059 | 14 | 7.420 | 16315.2 |
352 | 2024-12-29 21:56:39 | violator | 3 | 146162 | 77 | 45.393 | 3219.9 |
351 | 2024-12-29 21:56:22 | violator | 3 | 146162 | 77 | 55.973 | 2611.3 |
350 | 2024-12-29 19:39:20 | violator | 4 | 161609 | 472 | 59.160 | 2731.7 |
349 | 2024-12-29 19:39:23 | violator | 3 | 146162 | 77 | 33.706 | 4336.4 |
348 | 2024-12-29 19:39:22 | violator | 2 | 121059 | 14 | 17.203 | 7037.1 |
347 | 2024-12-29 19:39:09 | violator | 1 | 82945 | 3 | 9.846 | 8424.2 |
346 | 2024-12-11 01:57:55 | violator | 3 | 146162 | 77 | 7.560 | 19333.6 |
345 | 2024-12-11 01:57:56 | violator | 2 | 121059 | 14 | 3.780 | 32026.2 |
344 | 2024-12-11 01:57:53 | violator | 1 | 82945 | 3 | 1.420 | 58412.0 |
343 | 2024-12-03 23:30:12 | violator | 3 | 146162 | 77 | 38.500 | 3796.4 |
342 | 2024-11-27 16:02:24 | violator | 1 | 82945 | 3 | 3.813 | 21753.2 |
341 | 2024-11-22 09:19:47 | violator | 1 | 82945 | 3 | 6.596 | 12575.0 |
340 | 2024-11-22 05:19:33 | violator | 3 | 146162 | 77 | 27.596 | 5296.5 |
339 | 2024-11-22 05:19:24 | violator | 1 | 82945 | 3 | 1.300 | 63803.8 |
338 | 2024-11-20 05:21:17 | violator | 3 | 146162 | 77 | 30.283 | 4826.5 |
337 | 2024-11-17 12:12:26 | violator | 3 | 146162 | 77 | 27.093 | 5394.8 |
336 | 2024-11-16 17:19:40 | violator | 3 | 146162 | 77 | 35.720 | 4091.9 |
335 | 2024-11-14 09:42:54 | violator | 3 | 146162 | 77 | 24.330 | 6007.5 |
334 | 2024-11-10 17:39:24 | violator | 2 | 121059 | 14 | 18.016 | 6719.5 |
333 | 2024-11-10 07:36:22 | violator | 3 | 146162 | 77 | 44.813 | 3261.6 |
332 | 2024-11-10 07:36:22 | violator | 2 | 121059 | 14 | 12.250 | 9882.4 |
331 | 2024-11-09 21:18:06 | violator | 1 | 82945 | 3 | 1.296 | 64000.8 |
330 | 2024-10-23 11:59:14 | violator | 1 | 82945 | 3 | 6.783 | 12228.4 |
329 | 2024-10-23 04:06:15 | violator | 1 | 82945 | 3 | 10.093 | 8218.1 |
328 | 2024-10-20 17:05:21 | violator | 1 | 82945 | 3 | 6.593 | 12580.8 |
327 | 2024-10-16 13:33:10 | violator | 3 | 146162 | 77 | 35.580 | 4108.0 |
326 | 2024-10-15 20:13:15 | violator | 3 | 146162 | 77 | 52.300 | 2794.7 |
325 | 2024-10-15 15:07:49 | violator | 3 | 146162 | 77 | 37.003 | 3950.0 |