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 |
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 |
330 | 2025-01-27 15:06:29 | offence | 3 | 134027 | 79 | 10.640 | 12596.5 |
329 | 2025-01-21 20:04:33 | offence | 3 | 134027 | 79 | 36.526 | 3669.4 |
328 | 2025-01-21 20:04:45 | offence | 2 | 107671 | 14 | 15.463 | 6963.1 |
327 | 2025-01-21 20:03:17 | offence | 1 | 69583 | 3 | 5.846 | 11902.7 |
326 | 2025-01-16 15:33:54 | offence | 4 | 151207 | 594 | 52.580 | 2875.8 |
325 | 2025-01-16 15:22:56 | offence | 4 | 151207 | 594 | 54.770 | 2760.8 |
324 | 2025-01-16 14:18:05 | offence | 4 | 151207 | 594 | 53.220 | 2841.2 |
323 | 2025-01-16 04:22:51 | offence | 4 | 151207 | 594 | 46.360 | 3261.6 |
322 | 2025-01-16 04:22:54 | offence | 3 | 134027 | 79 | 29.720 | 4509.7 |
321 | 2025-01-16 04:22:54 | offence | 2 | 107671 | 14 | 13.750 | 7830.6 |
320 | 2025-01-16 04:22:32 | offence | 1 | 69583 | 3 | 5.640 | 12337.4 |
319 | 2024-12-29 20:28:03 | offence | 1 | 69583 | 3 | 2.736 | 25432.4 |
318 | 2024-12-15 02:31:37 | offence | 1 | 69583 | 3 | 5.576 | 12479.0 |
317 | 2024-12-09 01:11:41 | offence | 2 | 107671 | 14 | 16.140 | 6671.1 |
316 | 2024-12-09 01:10:20 | offence | 3 | 134027 | 79 | 7.716 | 17370.0 |
315 | 2024-12-08 16:12:35 | offence | 2 | 107671 | 14 | 15.453 | 6967.6 |
314 | 2024-12-08 16:12:14 | offence | 3 | 134027 | 79 | 32.956 | 4066.8 |
313 | 2024-12-08 16:12:04 | offence | 1 | 69583 | 3 | 2.560 | 27180.9 |
312 | 2024-12-08 16:11:31 | offence | 3 | 134027 | 79 | 22.986 | 5830.8 |
311 | 2024-12-07 03:11:30 | offence | 2 | 107671 | 14 | 14.406 | 7474.0 |
310 | 2024-12-07 00:49:23 | offence | 3 | 134027 | 79 | 31.173 | 4299.5 |
309 | 2024-12-06 22:10:37 | offence | 4 | 151207 | 594 | 57.330 | 2637.5 |
308 | 2024-12-06 18:57:18 | offence | 4 | 151207 | 594 | 34.266 | 4412.7 |
307 | 2024-12-06 18:57:15 | offence | 3 | 134027 | 79 | 21.923 | 6113.5 |
306 | 2024-12-06 18:57:13 | offence | 2 | 107671 | 14 | 7.440 | 14471.9 |
305 | 2024-11-28 13:38:01 | offence | 1 | 69583 | 3 | 7.830 | 8886.7 |
304 | 2024-11-02 22:40:09 | offence | 1 | 69583 | 3 | 4.143 | 16795.3 |
303 | 2024-10-20 03:31:07 | offence | 1 | 69583 | 3 | 5.453 | 12760.5 |
302 | 2024-10-11 15:17:49 | offence | 1 | 69583 | 3 | 4.546 | 15306.4 |
301 | 2024-09-30 22:44:56 | offence | 1 | 69583 | 3 | 7.950 | 8752.6 |
300 | 2024-09-10 20:20:57 | offence | 1 | 69583 | 3 | 5.563 | 12508.2 |
299 | 2024-09-09 08:38:21 | offence | 1 | 69583 | 3 | 4.046 | 17198.0 |
298 | 2024-08-28 14:32:10 | offence | 1 | 69583 | 3 | 6.780 | 10263.0 |
297 | 2024-08-27 04:21:44 | offence | 1 | 69583 | 3 | 10.936 | 6362.7 |
296 | 2024-08-04 02:58:18 | offence | 1 | 69583 | 3 | 4.610 | 15093.9 |
295 | 2024-08-04 02:58:07 | offence | 1 | 69583 | 3 | 3.106 | 22402.8 |
294 | 2024-07-26 06:22:17 | offence | 1 | 69583 | 3 | 4.250 | 16372.5 |
293 | 2024-07-26 06:20:14 | offence | 1 | 69583 | 3 | 3.670 | 18959.9 |
292 | 2024-07-22 16:52:13 | offence | 1 | 69583 | 3 | 2.016 | 34515.4 |
291 | 2024-07-22 01:49:23 | offence | 1 | 69583 | 3 | 4.923 | 14134.3 |
290 | 2024-07-13 20:40:24 | offence | 1 | 69583 | 3 | 6.563 | 10602.3 |
289 | 2024-07-07 22:01:58 | offence | 1 | 69583 | 3 | 2.173 | 32021.6 |
288 | 2024-07-07 21:57:51 | offence | 1 | 69583 | 3 | 2.156 | 32274.1 |
287 | 2024-07-06 06:45:48 | offence | 1 | 69583 | 3 | 7.160 | 9718.3 |
286 | 2024-07-01 19:12:00 | offence | 1 | 69583 | 3 | 5.890 | 11813.8 |
285 | 2024-06-26 05:58:08 | offence | 1 | 69583 | 3 | 6.110 | 11388.4 |
284 | 2024-06-19 17:13:07 | offence | 1 | 69583 | 3 | 2.233 | 31161.2 |
283 | 2024-05-30 03:48:32 | offence | 1 | 69583 | 3 | 3.966 | 17544.9 |
282 | 2024-05-27 13:45:19 | offence | 1 | 69583 | 3 | 2.580 | 26970.2 |
281 | 2024-05-16 19:43:30 | offence | 4 | 151207 | 594 | 10.373 | 14577.0 |
280 | 2024-05-10 07:36:21 | offence | 4 | 151207 | 594 | 13.280 | 11386.1 |
279 | 2024-05-08 15:14:49 | offence | 1 | 69583 | 3 | 1.330 | 52318.0 |
278 | 2024-05-01 04:33:17 | offence | 4 | 151207 | 594 | 12.360 | 12233.6 |
277 | 2024-04-25 18:42:17 | offence | 4 | 151207 | 594 | 16.440 | 9197.5 |
276 | 2024-04-25 18:39:57 | offence | 4 | 151207 | 594 | 28.080 | 5384.9 |
275 | 2024-04-25 13:08:08 | offence | 4 | 151207 | 594 | 10.826 | 13967.0 |
274 | 2024-04-25 05:47:40 | offence | 4 | 151207 | 594 | 11.720 | 12901.6 |
273 | 2024-04-22 06:19:46 | offence | 4 | 151207 | 594 | 33.940 | 4455.1 |
272 | 2024-04-22 05:35:39 | offence | 1 | 69583 | 3 | 1.610 | 43219.3 |
271 | 2024-04-20 22:42:31 | offence | 3 | 134027 | 79 | 21.910 | 6117.2 |
270 | 2024-04-20 22:42:29 | offence | 2 | 107671 | 14 | 7.670 | 14037.9 |
269 | 2024-04-20 21:42:56 | offence | 3 | 134027 | 79 | 20.766 | 6454.2 |
268 | 2024-04-20 15:01:29 | offence | 3 | 134027 | 79 | 10.440 | 12837.8 |
267 | 2024-04-20 15:01:28 | offence | 2 | 107671 | 14 | 4.106 | 26222.8 |
266 | 2024-04-07 09:10:28 | offence | 1 | 69583 | 3 | 3.906 | 17814.4 |
265 | 2024-03-30 13:10:21 | offence | 1 | 69583 | 3 | 1.690 | 41173.4 |
264 | 2024-03-25 22:04:22 | offence | 4 | 151207 | 594 | 19.893 | 7601.0 |
263 | 2024-03-25 06:44:45 | offence | 4 | 151207 | 594 | 10.703 | 14127.5 |
262 | 2024-03-22 10:19:42 | offence | 4 | 151207 | 594 | 18.923 | 7990.6 |
261 | 2024-03-21 23:03:27 | offence | 4 | 151207 | 594 | 33.393 | 4528.1 |
260 | 2024-03-21 05:42:33 | offence | 4 | 151207 | 594 | 29.003 | 5213.5 |
259 | 2024-03-20 19:42:38 | offence | 4 | 151207 | 594 | 21.906 | 6902.5 |
258 | 2024-03-20 19:42:04 | offence | 1 | 69583 | 3 | 2.673 | 26031.8 |