History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offense"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
449 | 2025-08-28 14:09:42 | offense | 1 | 69583 | 3 | 1.253 | 55533.1 |
448 | 2025-08-27 21:27:59 | offense | 1 | 69583 | 3 | 1.140 | 61037.7 |
447 | 2025-08-11 02:08:21 | offense | 2 | 107671 | 12 | 8.750 | 12305.3 |
446 | 2025-08-05 19:28:43 | offense | 4 | 151207 | 879 | 51.720 | 2923.6 |
445 | 2025-08-05 06:38:35 | offense | 2 | 107671 | 12 | 14.453 | 7449.7 |
444 | 2025-08-04 08:26:38 | offense | 1 | 69583 | 3 | 1.173 | 59320.5 |
443 | 2025-08-03 19:23:08 | offense | 2 | 107671 | 12 | 3.453 | 31181.9 |
442 | 2025-08-01 13:19:40 | offense | 1 | 69583 | 3 | 2.733 | 25460.3 |
441 | 2025-07-29 00:23:38 | offense | 1 | 69583 | 3 | 7.703 | 9033.2 |
440 | 2025-07-26 23:48:18 | offense | 1 | 69583 | 3 | 3.046 | 22844.1 |
439 | 2025-07-26 18:59:10 | offense | 2 | 107671 | 12 | 15.873 | 6783.3 |
438 | 2025-07-24 23:18:20 | offense | 1 | 69583 | 3 | 4.876 | 14270.5 |
437 | 2025-07-24 02:13:48 | offense | 1 | 69583 | 3 | 2.560 | 27180.9 |
436 | 2025-07-24 00:55:39 | offense | 1 | 69583 | 3 | 2.716 | 25619.7 |
435 | 2025-07-22 19:12:04 | offense | 2 | 107671 | 12 | 7.873 | 13676.0 |
434 | 2025-07-22 12:40:37 | offense | 1 | 69583 | 3 | 5.686 | 12237.6 |
433 | 2025-07-19 14:42:20 | offense | 2 | 107671 | 12 | 3.253 | 33099.0 |
432 | 2025-07-18 02:27:01 | offense | 2 | 107671 | 12 | 16.066 | 6701.8 |
431 | 2025-07-17 07:08:07 | offense | 3 | 134027 | 84 | 17.983 | 7453.0 |
430 | 2025-07-16 07:05:58 | offense | 1 | 69583 | 3 | 5.826 | 11943.5 |
429 | 2025-07-15 21:25:04 | offense | 1 | 69583 | 3 | 1.250 | 55666.4 |
428 | 2025-07-15 08:48:26 | offense | 1 | 69583 | 3 | 4.656 | 14944.8 |
427 | 2025-07-13 08:40:02 | offense | 1 | 69583 | 3 | 1.450 | 47988.3 |
426 | 2025-07-10 13:52:26 | offense | 2 | 107671 | 12 | 3.126 | 34443.7 |
425 | 2025-07-10 12:49:35 | offense | 2 | 107671 | 12 | 14.846 | 7252.5 |
424 | 2025-07-09 23:55:27 | offense | 3 | 134027 | 84 | 24.956 | 5370.5 |
423 | 2025-07-09 14:42:56 | offense | 1 | 69583 | 3 | 2.890 | 24077.2 |
422 | 2025-06-16 10:53:12 | offense | 4 | 151207 | 879 | 36.453 | 4148.0 |
421 | 2025-06-16 06:24:27 | offense | 1 | 69583 | 3 | 7.483 | 9298.8 |
420 | 2025-06-15 23:46:58 | offense | 4 | 151207 | 879 | 49.843 | 3033.7 |
419 | 2025-06-14 15:33:00 | offense | 4 | 151207 | 879 | 48.530 | 3115.7 |
418 | 2025-06-14 09:07:32 | offense | 1 | 69583 | 3 | 6.046 | 11508.9 |
417 | 2025-06-13 23:11:49 | offense | 1 | 69583 | 3 | 4.373 | 15912.0 |
416 | 2025-06-05 13:53:44 | offense | 1 | 69583 | 3 | 4.436 | 15686.0 |
415 | 2025-06-04 11:06:35 | offense | 1 | 69583 | 3 | 4.856 | 14329.3 |
414 | 2025-06-01 00:02:20 | offense | 1 | 69583 | 3 | 7.156 | 9723.7 |
413 | 2025-05-30 06:25:40 | offense | 1 | 69583 | 3 | 6.623 | 10506.3 |
412 | 2025-05-26 22:51:50 | offense | 1 | 69583 | 3 | 4.156 | 16742.8 |
411 | 2025-05-26 07:18:43 | offense | 4 | 151207 | 879 | 45.176 | 3347.1 |
410 | 2025-05-26 01:02:11 | offense | 2 | 107671 | 12 | 9.423 | 11426.4 |
409 | 2025-05-22 04:30:37 | offense | 1 | 69583 | 3 | 2.533 | 27470.6 |
408 | 2025-05-12 00:17:14 | offense | 3 | 134027 | 84 | 18.796 | 7130.6 |
407 | 2025-05-10 06:11:48 | offense | 3 | 134027 | 84 | 47.350 | 2830.6 |
406 | 2025-05-08 11:05:44 | offense | 3 | 134027 | 84 | 40.206 | 3333.5 |
405 | 2025-05-06 21:22:32 | offense | 3 | 134027 | 84 | 6.466 | 20728.0 |
404 | 2025-05-05 08:06:51 | offense | 1 | 69583 | 3 | 2.970 | 23428.6 |
403 | 2025-05-04 22:16:51 | offense | 1 | 69583 | 3 | 3.190 | 21812.9 |
402 | 2025-05-04 12:01:56 | offense | 1 | 69583 | 3 | 3.673 | 18944.5 |
401 | 2025-05-03 07:51:43 | offense | 3 | 134027 | 84 | 32.660 | 4103.7 |
400 | 2025-05-02 06:02:24 | offense | 1 | 69583 | 3 | 5.923 | 11747.9 |
399 | 2025-05-02 02:31:44 | offense | 4 | 151207 | 879 | 43.640 | 3464.9 |
398 | 2025-05-01 23:07:05 | offense | 4 | 151207 | 879 | 60.190 | 2512.2 |
397 | 2025-05-01 16:35:03 | offense | 4 | 151207 | 879 | 11.593 | 13043.0 |
396 | 2025-05-01 10:22:30 | offense | 4 | 151207 | 879 | 11.266 | 13421.5 |
395 | 2025-04-30 21:47:01 | offense | 4 | 151207 | 879 | 55.186 | 2740.0 |
394 | 2025-04-29 17:03:00 | offense | 4 | 151207 | 879 | 13.406 | 11279.1 |
393 | 2025-04-22 23:49:56 | offense | 2 | 107671 | 12 | 15.986 | 6735.3 |
392 | 2025-04-22 07:40:54 | offense | 1 | 69583 | 3 | 1.186 | 58670.3 |
391 | 2025-04-22 05:24:25 | offense | 1 | 69583 | 3 | 1.046 | 66522.9 |
390 | 2025-04-22 03:19:50 | offense | 1 | 69583 | 3 | 1.483 | 46920.4 |
389 | 2025-04-21 07:22:27 | offense | 2 | 107671 | 12 | 14.000 | 7690.8 |
388 | 2025-04-11 05:10:10 | offense | 3 | 134027 | 84 | 17.953 | 7465.4 |
387 | 2025-04-10 03:07:23 | offense | 2 | 107671 | 12 | 3.690 | 29179.1 |
386 | 2025-04-08 04:16:26 | offense | 3 | 134027 | 84 | 35.376 | 3788.6 |
385 | 2025-04-06 05:39:59 | offense | 3 | 134027 | 84 | 36.103 | 3712.4 |
384 | 2025-04-05 21:21:16 | offense | 3 | 134027 | 84 | 20.156 | 6649.5 |
383 | 2025-04-03 19:01:26 | offense | 3 | 134027 | 84 | 17.203 | 7790.9 |
382 | 2025-04-03 10:30:42 | offense | 1 | 69583 | 3 | 1.186 | 58670.3 |
381 | 2025-03-31 06:09:21 | offense | 2 | 107671 | 12 | 22.033 | 4886.8 |
380 | 2025-03-28 23:10:09 | offense | 1 | 69583 | 3 | 8.656 | 8038.7 |
379 | 2025-03-26 12:17:41 | offense | 4 | 151207 | 879 | 51.986 | 2908.6 |
378 | 2025-03-21 00:04:22 | offense | 4 | 151207 | 879 | 29.163 | 5184.9 |
377 | 2025-03-19 18:59:45 | offense | 4 | 151207 | 879 | 11.860 | 12749.3 |
376 | 2025-03-16 18:47:14 | offense | 1 | 69583 | 3 | 4.423 | 15732.1 |
375 | 2025-03-16 15:14:19 | offense | 4 | 151207 | 879 | 51.096 | 2959.3 |
374 | 2025-03-15 23:03:47 | offense | 4 | 151207 | 879 | 42.716 | 3539.8 |
373 | 2025-03-15 19:58:45 | offense | 4 | 151207 | 879 | 67.503 | 2240.0 |
372 | 2025-03-14 17:05:31 | offense | 1 | 69583 | 3 | 5.826 | 11943.5 |
371 | 2025-03-08 17:30:26 | offense | 3 | 134027 | 84 | 6.046 | 22167.9 |
370 | 2025-03-06 07:50:02 | offense | 3 | 134027 | 84 | 32.923 | 4070.9 |
369 | 2025-03-04 04:46:38 | offense | 2 | 107671 | 12 | 14.690 | 7329.5 |
368 | 2025-03-04 04:46:05 | offense | 1 | 69583 | 3 | 4.220 | 16488.9 |
367 | 2025-03-04 03:37:28 | offense | 3 | 134027 | 84 | 46.783 | 2864.9 |
366 | 2025-03-04 03:10:21 | offense | 3 | 134027 | 84 | 31.360 | 4273.8 |
365 | 2025-03-04 03:10:19 | offense | 2 | 107671 | 12 | 15.220 | 7074.3 |
364 | 2025-03-04 03:09:45 | offense | 1 | 69583 | 3 | 6.063 | 11476.7 |
363 | 2025-03-04 02:25:00 | offense | 4 | 151207 | 879 | 53.393 | 2832.0 |
362 | 2025-03-03 01:19:04 | offense | 2 | 107671 | 12 | 8.046 | 13381.9 |
361 | 2025-03-01 03:26:44 | offense | 2 | 107671 | 12 | 22.330 | 4821.8 |
360 | 2025-02-24 06:01:03 | offense | 4 | 151207 | 879 | 56.610 | 2671.0 |
359 | 2025-02-23 10:51:08 | offense | 1 | 69583 | 3 | 2.766 | 25156.5 |
358 | 2025-02-23 04:54:36 | offense | 4 | 151207 | 879 | 58.880 | 2568.1 |
357 | 2025-02-20 22:39:12 | offense | 4 | 151207 | 879 | 46.190 | 3273.6 |
356 | 2025-02-16 20:54:31 | offense | 4 | 151207 | 879 | 60.953 | 2480.7 |
355 | 2025-02-16 11:35:37 | offense | 4 | 151207 | 879 | 43.300 | 3492.1 |
354 | 2025-02-06 18:51:47 | offense | 2 | 107671 | 12 | 17.406 | 6185.9 |
353 | 2025-02-06 18:15:41 | offense | 3 | 134027 | 84 | 6.470 | 20715.1 |
352 | 2025-02-05 18:49:28 | offense | 3 | 134027 | 84 | 18.830 | 7117.7 |
351 | 2025-02-03 22:26:42 | offense | 1 | 69583 | 3 | 5.530 | 12582.8 |
350 | 2025-01-23 21:20:15 | offense | 2 | 107671 | 12 | 15.403 | 6990.3 |