History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"incidents"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
419 | 2025-04-22 23:54:26 | incidents | 1 | 81242 | 2 | 6.656 | 12205.8 |
418 | 2025-04-18 10:09:59 | incidents | 1 | 81242 | 2 | 8.453 | 9611.0 |
417 | 2025-04-15 04:12:24 | incidents | 1 | 81242 | 2 | 9.720 | 8358.2 |
416 | 2025-04-06 10:44:29 | incidents | 1 | 81242 | 2 | 4.110 | 19766.9 |
415 | 2025-03-27 17:09:10 | incidents | 1 | 81242 | 2 | 7.906 | 10276.0 |
414 | 2025-03-23 17:17:50 | incidents | 1 | 81242 | 2 | 3.436 | 23644.4 |
413 | 2025-02-24 12:43:30 | incidents | 1 | 81242 | 2 | 7.296 | 11135.1 |
412 | 2025-02-19 02:35:55 | incidents | 1 | 81242 | 2 | 6.186 | 13133.2 |
411 | 2025-02-14 09:43:25 | incidents | 3 | 148641 | 53 | 35.926 | 4137.4 |
410 | 2025-02-12 13:13:27 | incidents | 1 | 81242 | 2 | 3.110 | 26122.8 |
409 | 2025-02-01 20:53:55 | incidents | 2 | 121436 | 13 | 17.346 | 7000.8 |
408 | 2025-01-26 10:21:01 | incidents | 3 | 148641 | 53 | 35.286 | 4212.5 |
407 | 2025-01-26 10:20:42 | incidents | 3 | 148641 | 53 | 35.673 | 4166.8 |
406 | 2025-01-26 10:20:56 | incidents | 2 | 121436 | 13 | 19.360 | 6272.5 |
405 | 2025-01-22 10:05:12 | incidents | 1 | 81242 | 2 | 3.376 | 24064.6 |
404 | 2025-01-18 17:34:58 | incidents | 1 | 81242 | 2 | 6.173 | 13160.9 |
403 | 2025-01-08 13:52:08 | incidents | 1 | 81242 | 2 | 3.903 | 20815.3 |
402 | 2025-01-05 15:29:58 | incidents | 1 | 81242 | 2 | 4.063 | 19995.6 |
401 | 2024-12-21 09:17:06 | incidents | 1 | 81242 | 2 | 6.313 | 12869.0 |
400 | 2024-12-16 13:25:06 | incidents | 1 | 81242 | 2 | 7.843 | 10358.5 |
399 | 2024-12-06 00:48:53 | incidents | 1 | 81242 | 2 | 5.690 | 14278.0 |
398 | 2024-11-20 09:49:10 | incidents | 1 | 81242 | 2 | 6.643 | 12229.7 |
397 | 2024-11-06 22:50:21 | incidents | 3 | 148641 | 53 | 45.576 | 3261.4 |
396 | 2024-10-27 08:07:04 | incidents | 1 | 81242 | 2 | 3.206 | 25340.6 |
395 | 2024-10-21 09:58:43 | incidents | 3 | 148641 | 53 | 36.393 | 4084.3 |
394 | 2024-10-21 09:58:41 | incidents | 3 | 148641 | 53 | 29.876 | 4975.3 |
393 | 2024-10-21 09:58:43 | incidents | 2 | 121436 | 13 | 18.330 | 6625.0 |
392 | 2024-10-21 09:52:32 | incidents | 1 | 81242 | 2 | 4.516 | 17989.8 |
391 | 2024-10-20 22:12:38 | incidents | 2 | 121436 | 13 | 19.233 | 6313.9 |
390 | 2024-10-15 10:28:55 | incidents | 1 | 81242 | 2 | 6.720 | 12089.6 |
389 | 2024-10-08 15:11:37 | incidents | 1 | 81242 | 2 | 1.343 | 60492.9 |
388 | 2024-10-02 01:59:52 | incidents | 2 | 121436 | 13 | 34.750 | 3494.6 |
387 | 2024-09-30 14:06:32 | incidents | 2 | 121436 | 13 | 28.926 | 4198.2 |
386 | 2024-09-22 07:03:59 | incidents | 3 | 148641 | 53 | 54.143 | 2745.3 |
385 | 2024-09-19 01:08:26 | incidents | 2 | 121436 | 13 | 29.270 | 4148.8 |
384 | 2024-09-19 00:04:50 | incidents | 1 | 81242 | 2 | 9.686 | 8387.6 |
383 | 2024-09-18 18:16:44 | incidents | 3 | 148641 | 53 | 55.453 | 2680.5 |
382 | 2024-09-15 21:43:40 | incidents | 2 | 121436 | 13 | 17.373 | 6989.9 |
381 | 2024-09-15 21:43:22 | incidents | 1 | 81242 | 2 | 8.203 | 9903.9 |
380 | 2024-09-15 21:08:32 | incidents | 3 | 148641 | 53 | 43.000 | 3456.8 |
379 | 2024-09-15 06:23:16 | incidents | 3 | 148641 | 53 | 62.190 | 2390.1 |
378 | 2024-09-12 06:26:39 | incidents | 1 | 81242 | 2 | 13.673 | 5941.8 |
377 | 2024-09-11 12:18:40 | incidents | 3 | 148641 | 53 | 78.973 | 1882.2 |
376 | 2024-09-08 22:31:46 | incidents | 3 | 148641 | 53 | 35.723 | 4160.9 |
375 | 2024-09-05 23:24:38 | incidents | 4 | 165329 | 332 | 121.913 | 1356.1 |
374 | 2024-09-05 23:24:36 | incidents | 3 | 148641 | 53 | 35.220 | 4220.4 |
373 | 2024-09-05 23:24:35 | incidents | 2 | 121436 | 13 | 27.610 | 4398.3 |
372 | 2024-09-05 22:10:12 | incidents | 1 | 81242 | 2 | 1.250 | 64993.6 |
371 | 2024-09-01 13:22:02 | incidents | 4 | 165329 | 332 | 51.126 | 3233.8 |
370 | 2024-09-01 12:33:37 | incidents | 2 | 121436 | 13 | 41.970 | 2893.4 |
369 | 2024-08-28 02:26:45 | incidents | 1 | 81242 | 2 | 8.173 | 9940.3 |
368 | 2024-08-18 18:15:33 | incidents | 4 | 165329 | 332 | 112.956 | 1463.7 |
367 | 2024-08-18 10:02:28 | incidents | 4 | 165329 | 332 | 116.430 | 1420.0 |
366 | 2024-08-17 07:44:15 | incidents | 4 | 165329 | 332 | 113.193 | 1460.6 |
365 | 2024-08-15 16:45:57 | incidents | 2 | 121436 | 13 | 30.613 | 3966.8 |
364 | 2024-08-13 09:01:03 | incidents | 1 | 81242 | 2 | 14.953 | 5433.2 |
363 | 2024-08-11 23:26:41 | incidents | 4 | 165329 | 332 | 75.536 | 2188.7 |
362 | 2024-08-11 23:26:45 | incidents | 3 | 148641 | 53 | 25.346 | 5864.5 |
361 | 2024-08-09 05:24:40 | incidents | 1 | 81242 | 2 | 3.013 | 26963.8 |
360 | 2024-08-07 20:27:37 | incidents | 3 | 148641 | 53 | 27.720 | 5362.2 |
359 | 2024-08-03 07:45:53 | incidents | 1 | 81242 | 2 | 4.706 | 17263.5 |
358 | 2024-08-01 22:33:58 | incidents | 1 | 81242 | 2 | 9.470 | 8578.9 |
357 | 2024-08-01 16:24:26 | incidents | 3 | 148641 | 53 | 25.736 | 5775.6 |
356 | 2024-08-01 05:20:28 | incidents | 3 | 148641 | 53 | 48.826 | 3044.3 |
355 | 2024-07-31 01:43:32 | incidents | 3 | 148641 | 53 | 20.783 | 7152.0 |
354 | 2024-07-30 21:01:34 | incidents | 4 | 165329 | 332 | 70.333 | 2350.7 |
353 | 2024-07-30 21:01:37 | incidents | 3 | 148641 | 53 | 44.786 | 3318.9 |
352 | 2024-07-30 21:01:35 | incidents | 2 | 121436 | 13 | 17.470 | 6951.1 |
351 | 2024-07-30 20:27:32 | incidents | 1 | 81242 | 2 | 3.186 | 25499.7 |
350 | 2024-07-24 00:21:14 | incidents | 3 | 148641 | 53 | 24.873 | 5976.0 |
349 | 2024-07-24 00:21:05 | incidents | 2 | 121436 | 13 | 16.470 | 7373.2 |
348 | 2024-07-19 23:24:02 | incidents | 1 | 81242 | 2 | 3.186 | 25499.7 |
347 | 2024-07-19 14:01:25 | incidents | 4 | 165329 | 332 | 44.353 | 3727.6 |
346 | 2024-07-19 09:54:54 | incidents | 4 | 165329 | 332 | 61.703 | 2679.4 |
345 | 2024-07-10 15:31:33 | incidents | 1 | 81242 | 2 | 2.826 | 28748.1 |
344 | 2024-07-07 17:53:59 | incidents | 1 | 81242 | 2 | 3.810 | 21323.4 |
343 | 2024-07-03 07:55:09 | incidents | 1 | 81242 | 2 | 2.486 | 32679.8 |
342 | 2024-06-27 16:41:29 | incidents | 4 | 165329 | 332 | 46.443 | 3559.8 |
341 | 2024-06-27 08:41:29 | incidents | 4 | 165329 | 332 | 46.443 | 3559.8 |
340 | 2024-06-26 12:41:30 | incidents | 4 | 165329 | 332 | 55.020 | 3004.9 |
339 | 2024-06-26 05:49:05 | incidents | 4 | 165329 | 332 | 44.663 | 3701.7 |
338 | 2024-06-25 09:37:48 | incidents | 4 | 165329 | 332 | 51.380 | 3217.8 |
337 | 2024-06-23 01:17:51 | incidents | 3 | 148641 | 53 | 24.330 | 6109.4 |
336 | 2024-06-19 16:01:14 | incidents | 3 | 148641 | 53 | 26.110 | 5692.9 |
335 | 2024-06-19 16:01:06 | incidents | 3 | 148641 | 53 | 15.860 | 9372.1 |
334 | 2024-06-19 16:00:59 | incidents | 2 | 121436 | 13 | 13.203 | 9197.6 |
333 | 2024-06-09 01:54:56 | incidents | 1 | 81242 | 2 | 7.330 | 11083.5 |
332 | 2024-06-09 01:54:41 | incidents | 1 | 81242 | 2 | 5.203 | 15614.5 |
331 | 2024-06-09 01:44:34 | incidents | 1 | 81242 | 2 | 7.436 | 10925.5 |
330 | 2024-06-04 01:50:58 | incidents | 2 | 121436 | 13 | 12.516 | 9702.5 |
329 | 2024-06-04 01:50:42 | incidents | 1 | 81242 | 2 | 7.470 | 10875.8 |
328 | 2024-06-03 20:49:32 | incidents | 3 | 148641 | 53 | 31.440 | 4727.8 |
327 | 2024-06-03 13:16:16 | incidents | 2 | 121436 | 13 | 17.266 | 7033.2 |
326 | 2024-06-03 13:16:20 | incidents | 3 | 148641 | 53 | 12.980 | 11451.5 |
325 | 2024-06-03 11:54:19 | incidents | 1 | 81242 | 2 | 5.876 | 13826.1 |
324 | 2024-06-03 11:53:26 | incidents | 1 | 81242 | 2 | 6.736 | 12060.9 |
323 | 2024-05-28 03:57:37 | incidents | 4 | 165329 | 332 | 46.770 | 3534.9 |
322 | 2024-05-27 11:16:23 | incidents | 4 | 165329 | 332 | 24.453 | 6761.1 |
321 | 2024-05-25 00:05:52 | incidents | 4 | 165329 | 332 | 31.580 | 5235.2 |
320 | 2024-05-24 00:46:09 | incidents | 3 | 148641 | 53 | 19.033 | 7809.6 |