History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sighting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
443 | 2025-08-13 19:38:14 | sighting | 1 | 82945 | 10 | 10.486 | 7910.1 |
442 | 2025-08-12 08:17:05 | sighting | 3 | 146162 | 282 | 16.700 | 8752.2 |
441 | 2025-08-08 23:13:51 | sighting | 1 | 82945 | 10 | 2.843 | 29175.2 |
440 | 2025-08-02 06:48:56 | sighting | 2 | 121059 | 34 | 12.893 | 9389.5 |
439 | 2025-08-01 15:05:36 | sighting | 1 | 82945 | 10 | 4.110 | 20181.3 |
438 | 2025-07-28 17:41:16 | sighting | 2 | 121059 | 34 | 16.686 | 7255.1 |
437 | 2025-07-26 22:02:28 | sighting | 1 | 82945 | 10 | 3.733 | 22219.4 |
436 | 2025-07-25 08:21:49 | sighting | 1 | 82945 | 10 | 3.096 | 26791.0 |
435 | 2025-07-25 00:18:12 | sighting | 1 | 82945 | 10 | 3.393 | 24445.9 |
434 | 2025-07-23 20:56:50 | sighting | 1 | 82945 | 10 | 3.376 | 24569.0 |
433 | 2025-07-13 11:32:52 | sighting | 1 | 82945 | 10 | 1.466 | 56579.1 |
432 | 2025-07-08 10:21:58 | sighting | 1 | 82945 | 10 | 4.203 | 19734.7 |
431 | 2025-07-07 06:44:00 | sighting | 2 | 121059 | 34 | 20.923 | 5785.9 |
430 | 2025-07-06 20:45:13 | sighting | 3 | 146162 | 282 | 11.750 | 12439.3 |
429 | 2025-07-02 21:46:48 | sighting | 1 | 82945 | 10 | 8.953 | 9264.5 |
428 | 2025-07-01 20:51:54 | sighting | 1 | 82945 | 10 | 3.830 | 21656.7 |
427 | 2025-07-01 00:12:54 | sighting | 2 | 121059 | 34 | 5.156 | 23479.2 |
426 | 2025-06-29 16:27:30 | sighting | 3 | 146162 | 282 | 31.613 | 4623.5 |
425 | 2025-06-28 15:25:10 | sighting | 2 | 121059 | 34 | 15.813 | 7655.7 |
424 | 2025-06-28 11:27:46 | sighting | 3 | 146162 | 282 | 31.003 | 4714.4 |
423 | 2025-06-28 01:31:24 | sighting | 3 | 146162 | 282 | 51.300 | 2849.2 |
422 | 2025-06-27 06:44:40 | sighting | 2 | 121059 | 34 | 13.470 | 8987.3 |
421 | 2025-06-26 23:58:47 | sighting | 3 | 146162 | 282 | 36.516 | 4002.7 |
420 | 2025-06-25 20:59:41 | sighting | 1 | 82945 | 10 | 1.593 | 52068.4 |
419 | 2025-06-24 12:33:55 | sighting | 1 | 82945 | 10 | 6.643 | 12486.1 |
418 | 2025-06-24 00:20:32 | sighting | 1 | 82945 | 10 | 5.720 | 14500.9 |
417 | 2025-06-23 01:53:37 | sighting | 1 | 82945 | 10 | 6.440 | 12879.7 |
416 | 2025-06-16 02:26:58 | sighting | 1 | 82945 | 10 | 3.750 | 22118.7 |
415 | 2025-06-01 02:08:21 | sighting | 1 | 82945 | 10 | 4.966 | 16702.6 |
414 | 2025-05-26 23:55:43 | sighting | 3 | 146162 | 282 | 38.796 | 3767.5 |
413 | 2025-05-26 16:17:17 | sighting | 2 | 121059 | 34 | 17.843 | 6784.7 |
412 | 2025-05-26 14:11:17 | sighting | 1 | 82945 | 10 | 7.063 | 11743.6 |
411 | 2025-05-26 12:05:53 | sighting | 3 | 146162 | 282 | 49.540 | 2950.4 |
410 | 2025-05-26 01:27:09 | sighting | 3 | 146162 | 282 | 30.203 | 4839.3 |
409 | 2025-05-24 17:03:05 | sighting | 3 | 146162 | 282 | 38.523 | 3794.1 |
408 | 2025-05-23 21:12:43 | sighting | 1 | 82945 | 10 | 5.280 | 15709.3 |
407 | 2025-05-23 19:57:06 | sighting | 2 | 121059 | 34 | 21.703 | 5578.0 |
406 | 2025-05-22 23:33:13 | sighting | 1 | 82945 | 10 | 3.453 | 24021.1 |
405 | 2025-05-20 13:13:33 | sighting | 1 | 82945 | 10 | 6.330 | 13103.5 |
404 | 2025-05-18 11:37:04 | sighting | 1 | 82945 | 10 | 7.250 | 11440.7 |
403 | 2025-05-16 02:34:28 | sighting | 1 | 82945 | 10 | 3.686 | 22502.7 |
402 | 2025-05-09 02:16:52 | sighting | 1 | 82945 | 10 | 1.440 | 57600.7 |
401 | 2025-04-26 13:17:07 | sighting | 1 | 82945 | 10 | 7.173 | 11563.5 |
400 | 2025-04-22 23:15:47 | sighting | 1 | 82945 | 10 | 6.653 | 12467.3 |
399 | 2025-04-22 20:37:41 | sighting | 1 | 82945 | 10 | 6.956 | 11924.2 |
398 | 2025-04-18 11:49:21 | sighting | 1 | 82945 | 10 | 4.653 | 17826.1 |
397 | 2025-04-16 00:34:12 | sighting | 1 | 82945 | 10 | 7.346 | 11291.2 |
396 | 2025-04-07 08:44:07 | sighting | 1 | 82945 | 10 | 5.283 | 15700.4 |
395 | 2025-04-04 16:23:53 | sighting | 1 | 82945 | 10 | 5.440 | 15247.2 |
394 | 2025-04-04 02:54:50 | sighting | 1 | 82945 | 10 | 6.873 | 12068.2 |
393 | 2025-04-03 20:38:44 | sighting | 3 | 146162 | 282 | 21.283 | 6867.5 |
392 | 2025-04-02 05:00:14 | sighting | 1 | 82945 | 10 | 10.610 | 7817.6 |
391 | 2025-03-29 07:24:47 | sighting | 2 | 121059 | 34 | 27.140 | 4460.5 |
390 | 2025-03-27 01:36:06 | sighting | 2 | 121059 | 34 | 11.186 | 10822.4 |
389 | 2025-03-24 19:04:51 | sighting | 2 | 121059 | 34 | 3.970 | 30493.5 |
388 | 2025-03-24 15:41:35 | sighting | 3 | 146162 | 282 | 6.453 | 22650.2 |
387 | 2025-03-23 15:30:00 | sighting | 1 | 82945 | 10 | 11.983 | 6921.9 |
386 | 2025-03-22 22:00:17 | sighting | 1 | 82945 | 10 | 3.673 | 22582.4 |
385 | 2025-03-22 00:38:29 | sighting | 1 | 82945 | 10 | 6.390 | 12980.4 |
384 | 2025-03-16 14:45:04 | sighting | 1 | 82945 | 10 | 3.703 | 22399.4 |
383 | 2025-03-13 18:02:39 | sighting | 1 | 82945 | 10 | 3.296 | 25165.4 |
382 | 2025-03-07 13:29:18 | sighting | 1 | 82945 | 10 | 7.686 | 10791.7 |
381 | 2025-03-04 20:17:02 | sighting | 3 | 146162 | 282 | 41.770 | 3499.2 |
380 | 2025-03-03 21:45:47 | sighting | 3 | 146162 | 282 | 19.080 | 7660.5 |
379 | 2025-03-03 09:44:16 | sighting | 3 | 146162 | 282 | 17.360 | 8419.5 |
378 | 2025-03-02 18:15:06 | sighting | 3 | 146162 | 282 | 33.703 | 4336.8 |
377 | 2025-03-02 14:06:42 | sighting | 3 | 146162 | 282 | 45.476 | 3214.0 |
376 | 2025-02-09 03:08:35 | sighting | 3 | 146162 | 282 | 6.483 | 22545.4 |
375 | 2025-02-08 18:56:30 | sighting | 2 | 121059 | 34 | 17.203 | 7037.1 |
374 | 2025-02-05 23:35:05 | sighting | 2 | 121059 | 34 | 12.360 | 9794.4 |
373 | 2025-02-02 21:53:58 | sighting | 2 | 121059 | 34 | 15.423 | 7849.3 |
372 | 2025-02-02 21:53:56 | sighting | 1 | 82945 | 10 | 5.750 | 14425.2 |
371 | 2025-01-27 21:30:42 | sighting | 3 | 146162 | 282 | 18.063 | 8091.8 |
370 | 2025-01-27 01:03:27 | sighting | 1 | 82945 | 10 | 1.483 | 55930.5 |
369 | 2025-01-26 19:43:03 | sighting | 1 | 82945 | 10 | 6.733 | 12319.2 |
368 | 2025-01-26 02:15:19 | sighting | 3 | 146162 | 282 | 35.986 | 4061.6 |
367 | 2025-01-24 18:01:42 | sighting | 3 | 146162 | 282 | 36.016 | 4058.3 |
366 | 2025-01-24 17:03:45 | sighting | 3 | 146162 | 282 | 40.376 | 3620.0 |
365 | 2025-01-21 01:56:35 | sighting | 3 | 146162 | 282 | 36.983 | 3952.1 |
364 | 2025-01-15 00:43:55 | sighting | 1 | 82945 | 10 | 7.673 | 10810.0 |
363 | 2025-01-06 22:15:25 | sighting | 2 | 121059 | 34 | 3.233 | 37444.8 |
362 | 2025-01-03 18:22:02 | sighting | 1 | 82945 | 10 | 6.220 | 13335.2 |
361 | 2025-01-03 14:12:53 | sighting | 2 | 121059 | 34 | 3.703 | 32692.1 |
360 | 2025-01-01 17:00:14 | sighting | 2 | 121059 | 34 | 15.123 | 8005.0 |
359 | 2024-12-29 00:54:33 | sighting | 2 | 121059 | 34 | 3.420 | 35397.4 |
358 | 2024-12-27 06:50:10 | sighting | 3 | 146162 | 282 | 51.453 | 2840.7 |
357 | 2024-12-25 22:18:09 | sighting | 3 | 146162 | 282 | 34.986 | 4177.7 |
356 | 2024-12-25 14:59:32 | sighting | 3 | 146162 | 282 | 25.346 | 5766.7 |
355 | 2024-12-25 09:18:08 | sighting | 1 | 82945 | 10 | 10.250 | 8092.2 |
354 | 2024-12-25 07:40:32 | sighting | 3 | 146162 | 282 | 37.173 | 3931.9 |
353 | 2024-12-25 07:40:30 | sighting | 2 | 121059 | 34 | 17.830 | 6789.6 |
352 | 2024-12-17 22:10:27 | sighting | 1 | 82945 | 10 | 3.796 | 21850.6 |
351 | 2024-12-14 06:20:07 | sighting | 1 | 82945 | 10 | 7.110 | 11666.0 |
350 | 2024-12-02 09:25:20 | sighting | 1 | 82945 | 10 | 7.063 | 11743.6 |
349 | 2024-11-24 18:39:45 | sighting | 3 | 146162 | 282 | 35.656 | 4099.2 |
348 | 2024-11-24 09:11:10 | sighting | 2 | 121059 | 34 | 3.156 | 38358.4 |
347 | 2024-11-24 09:11:00 | sighting | 3 | 146162 | 282 | 6.610 | 22112.3 |
346 | 2024-11-22 05:04:12 | sighting | 2 | 121059 | 34 | 15.936 | 7596.6 |
345 | 2024-11-21 12:19:47 | sighting | 3 | 146162 | 282 | 37.126 | 3936.9 |
344 | 2024-11-21 12:19:47 | sighting | 2 | 121059 | 34 | 18.876 | 6413.4 |