History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shootings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
366 | 2025-04-29 09:41:46 | shootings | 3 | 148641 | 165 | 8.173 | 18186.8 |
365 | 2025-04-28 15:17:10 | shootings | 3 | 148641 | 165 | 28.830 | 5155.8 |
364 | 2025-04-27 14:59:11 | shootings | 2 | 121436 | 24 | 3.546 | 34245.9 |
363 | 2025-04-25 02:40:57 | shootings | 2 | 121436 | 24 | 18.820 | 6452.5 |
362 | 2025-04-23 02:50:50 | shootings | 1 | 81242 | 2 | 3.576 | 22718.7 |
361 | 2025-04-18 02:25:40 | shootings | 1 | 81242 | 2 | 3.656 | 22221.6 |
360 | 2025-04-02 16:22:51 | shootings | 2 | 121436 | 24 | 17.890 | 6787.9 |
359 | 2025-04-01 22:29:09 | shootings | 3 | 148641 | 165 | 35.313 | 4209.2 |
358 | 2025-04-01 16:29:17 | shootings | 1 | 81242 | 2 | 1.516 | 53589.7 |
357 | 2025-03-27 08:42:33 | shootings | 1 | 81242 | 2 | 6.580 | 12346.8 |
356 | 2025-03-23 04:25:17 | shootings | 1 | 81242 | 2 | 2.923 | 27794.0 |
355 | 2025-03-22 09:52:38 | shootings | 2 | 121436 | 24 | 17.156 | 7078.3 |
354 | 2025-03-21 04:42:34 | shootings | 3 | 148641 | 165 | 39.376 | 3774.9 |
353 | 2025-03-20 06:53:35 | shootings | 1 | 81242 | 2 | 6.546 | 12410.9 |
352 | 2025-03-19 10:10:00 | shootings | 3 | 148641 | 165 | 19.813 | 7502.2 |
351 | 2025-03-19 05:36:31 | shootings | 2 | 121436 | 24 | 5.436 | 22339.2 |
350 | 2025-03-18 13:38:02 | shootings | 1 | 81242 | 2 | 5.640 | 14404.6 |
349 | 2025-03-11 07:45:07 | shootings | 3 | 148641 | 165 | 38.176 | 3893.6 |
348 | 2025-03-05 10:45:52 | shootings | 1 | 81242 | 2 | 2.813 | 28880.9 |
347 | 2025-03-02 15:30:30 | shootings | 3 | 148641 | 165 | 36.893 | 4029.0 |
346 | 2025-03-02 10:13:07 | shootings | 1 | 81242 | 2 | 3.610 | 22504.7 |
345 | 2025-02-25 04:49:15 | shootings | 3 | 148641 | 165 | 35.610 | 4174.1 |
344 | 2025-02-24 13:08:13 | shootings | 1 | 81242 | 2 | 7.486 | 10852.5 |
343 | 2025-02-24 10:24:30 | shootings | 1 | 81242 | 2 | 4.610 | 17623.0 |
342 | 2025-02-24 03:57:51 | shootings | 3 | 148641 | 165 | 56.143 | 2647.5 |
341 | 2025-02-24 03:57:48 | shootings | 2 | 121436 | 24 | 16.123 | 7531.8 |
340 | 2025-02-19 05:43:00 | shootings | 1 | 81242 | 2 | 3.483 | 23325.3 |
339 | 2025-02-10 11:06:23 | shootings | 1 | 81242 | 2 | 1.236 | 65729.8 |
338 | 2025-02-09 08:56:51 | shootings | 1 | 81242 | 2 | 1.423 | 57092.1 |
337 | 2025-02-09 04:20:11 | shootings | 1 | 81242 | 2 | 3.403 | 23873.6 |
336 | 2025-01-27 00:44:46 | shootings | 1 | 81242 | 2 | 8.236 | 9864.3 |
335 | 2025-01-24 19:30:28 | shootings | 1 | 81242 | 2 | 5.220 | 15563.6 |
334 | 2025-01-15 10:25:43 | shootings | 2 | 121436 | 24 | 16.950 | 7164.4 |
333 | 2025-01-15 06:49:52 | shootings | 3 | 148641 | 165 | 42.066 | 3533.5 |
332 | 2025-01-15 01:25:08 | shootings | 3 | 148641 | 165 | 33.830 | 4393.8 |
331 | 2025-01-13 23:58:13 | shootings | 3 | 148641 | 165 | 35.173 | 4226.0 |
330 | 2025-01-13 21:26:57 | shootings | 3 | 148641 | 165 | 29.300 | 5073.1 |
329 | 2025-01-13 17:17:14 | shootings | 3 | 148641 | 165 | 43.486 | 3418.1 |
328 | 2025-01-13 17:17:17 | shootings | 2 | 121436 | 24 | 17.983 | 6752.8 |
327 | 2025-01-13 17:15:51 | shootings | 1 | 81242 | 2 | 6.013 | 13511.1 |
326 | 2025-01-11 23:47:50 | shootings | 2 | 121436 | 24 | 14.203 | 8550.0 |
325 | 2024-12-25 02:39:43 | shootings | 1 | 81242 | 2 | 3.656 | 22221.6 |
324 | 2024-12-16 13:13:54 | shootings | 1 | 81242 | 2 | 6.656 | 12205.8 |
323 | 2024-12-13 15:17:56 | shootings | 2 | 121436 | 24 | 13.376 | 9078.6 |
322 | 2024-12-13 15:17:35 | shootings | 1 | 81242 | 2 | 1.296 | 62686.7 |
321 | 2024-12-11 04:16:47 | shootings | 3 | 148641 | 165 | 29.393 | 5057.0 |
320 | 2024-12-11 04:16:45 | shootings | 2 | 121436 | 24 | 18.360 | 6614.2 |
319 | 2024-12-10 07:21:36 | shootings | 3 | 148641 | 165 | 35.876 | 4143.2 |
318 | 2024-12-10 01:08:54 | shootings | 3 | 148641 | 165 | 40.970 | 3628.0 |
317 | 2024-12-09 22:05:55 | shootings | 3 | 148641 | 165 | 32.610 | 4558.1 |
316 | 2024-12-09 22:05:55 | shootings | 2 | 121436 | 24 | 15.203 | 7987.6 |
315 | 2024-12-09 22:02:18 | shootings | 1 | 81242 | 2 | 3.796 | 21402.0 |
314 | 2024-11-22 12:54:56 | shootings | 1 | 81242 | 2 | 4.923 | 16502.5 |
313 | 2024-11-08 21:41:07 | shootings | 1 | 81242 | 2 | 3.936 | 20640.8 |
312 | 2024-10-15 18:53:57 | shootings | 1 | 81242 | 2 | 5.656 | 14363.9 |
311 | 2024-10-09 15:41:52 | shootings | 1 | 81242 | 2 | 6.580 | 12346.8 |
310 | 2024-10-07 01:01:07 | shootings | 1 | 81242 | 2 | 15.266 | 5321.8 |
309 | 2024-10-02 11:46:00 | shootings | 3 | 148641 | 165 | 51.440 | 2889.6 |
308 | 2024-09-26 16:14:13 | shootings | 3 | 148641 | 165 | 98.693 | 1506.1 |
307 | 2024-09-14 08:22:55 | shootings | 1 | 81242 | 2 | 13.436 | 6046.6 |
306 | 2024-09-14 07:57:07 | shootings | 2 | 121436 | 24 | 28.070 | 4326.2 |
305 | 2024-09-13 23:00:47 | shootings | 3 | 148641 | 165 | 63.096 | 2355.8 |
304 | 2024-09-13 23:00:47 | shootings | 2 | 121436 | 24 | 46.046 | 2637.3 |
303 | 2024-09-13 22:31:53 | shootings | 1 | 81242 | 2 | 4.576 | 17753.9 |
302 | 2024-09-10 17:12:31 | shootings | 1 | 81242 | 2 | 5.250 | 15474.7 |
301 | 2024-08-27 09:11:19 | shootings | 1 | 81242 | 2 | 15.360 | 5289.2 |
300 | 2024-08-13 21:26:10 | shootings | 1 | 81242 | 2 | 5.160 | 15744.6 |
299 | 2024-08-07 22:22:55 | shootings | 1 | 81242 | 2 | 4.920 | 16512.6 |
298 | 2024-07-30 10:33:31 | shootings | 1 | 81242 | 2 | 6.766 | 12007.4 |
297 | 2024-07-24 14:24:21 | shootings | 1 | 81242 | 2 | 2.983 | 27235.0 |
296 | 2024-07-22 18:23:52 | shootings | 2 | 121436 | 24 | 6.533 | 18588.1 |
295 | 2024-07-22 12:56:26 | shootings | 2 | 121436 | 24 | 13.670 | 8883.4 |
294 | 2024-07-22 12:51:49 | shootings | 1 | 81242 | 2 | 2.390 | 33992.5 |
293 | 2024-07-14 21:16:03 | shootings | 3 | 148641 | 165 | 33.156 | 4483.1 |
292 | 2024-07-14 08:54:10 | shootings | 3 | 148641 | 165 | 15.576 | 9543.0 |
291 | 2024-07-12 20:28:09 | shootings | 3 | 148641 | 165 | 40.906 | 3633.7 |
290 | 2024-07-12 18:16:55 | shootings | 1 | 81242 | 2 | 5.533 | 14683.2 |
289 | 2024-07-11 06:24:46 | shootings | 1 | 81242 | 2 | 1.216 | 66810.9 |
288 | 2024-07-02 00:04:35 | shootings | 1 | 81242 | 2 | 6.250 | 12998.7 |
287 | 2024-06-30 08:53:25 | shootings | 1 | 81242 | 2 | 7.186 | 11305.6 |
286 | 2024-06-29 01:30:43 | shootings | 1 | 81242 | 2 | 11.393 | 7130.9 |
285 | 2024-06-23 13:39:26 | shootings | 3 | 148641 | 165 | 35.483 | 4189.1 |
284 | 2024-06-23 13:39:22 | shootings | 2 | 121436 | 24 | 6.923 | 17541.0 |
283 | 2024-06-14 21:46:36 | shootings | 1 | 81242 | 2 | 4.813 | 16879.7 |
282 | 2024-06-01 19:55:02 | shootings | 3 | 148641 | 165 | 33.316 | 4461.6 |
281 | 2024-06-01 18:13:40 | shootings | 2 | 121436 | 24 | 23.440 | 5180.7 |
280 | 2024-05-31 05:06:06 | shootings | 2 | 121436 | 24 | 10.470 | 11598.5 |
279 | 2024-05-29 18:54:43 | shootings | 3 | 148641 | 165 | 37.626 | 3950.5 |
278 | 2024-05-29 18:54:42 | shootings | 2 | 121436 | 24 | 12.500 | 9714.9 |
277 | 2024-05-29 12:54:52 | shootings | 1 | 81242 | 2 | 2.466 | 32944.8 |
276 | 2024-05-23 09:02:01 | shootings | 1 | 81242 | 2 | 3.220 | 25230.4 |
275 | 2024-05-03 15:09:16 | shootings | 1 | 81242 | 2 | 1.483 | 54782.2 |
274 | 2024-04-30 10:21:25 | shootings | 1 | 81242 | 2 | 1.796 | 45235.0 |
273 | 2024-04-29 23:39:47 | shootings | 3 | 148641 | 165 | 12.080 | 12304.7 |
272 | 2024-04-27 14:23:57 | shootings | 3 | 148641 | 165 | 26.816 | 5543.0 |
271 | 2024-04-27 12:27:13 | shootings | 1 | 81242 | 2 | 3.356 | 24208.0 |
270 | 2024-04-22 13:56:22 | shootings | 1 | 81242 | 2 | 3.250 | 24997.5 |
269 | 2024-04-09 17:13:01 | shootings | 1 | 81242 | 2 | 1.563 | 51978.2 |
268 | 2024-03-30 00:08:00 | shootings | 1 | 81242 | 2 | 1.516 | 53589.7 |
267 | 2024-03-27 03:29:51 | shootings | 3 | 148641 | 165 | 15.123 | 9828.8 |