History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sightings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
438 | 2024-05-09 14:24:17 | sightings | 1 | 81242 | 4 | 1.486 | 54671.6 |
437 | 2024-05-07 02:56:07 | sightings | 1 | 81242 | 4 | 3.156 | 25742.1 |
436 | 2024-04-26 03:36:04 | sightings | 1 | 81242 | 4 | 1.266 | 64172.2 |
435 | 2024-04-25 20:48:50 | sightings | 1 | 81242 | 4 | 1.533 | 52995.4 |
434 | 2024-04-08 07:37:55 | sightings | 1 | 81242 | 4 | 2.406 | 33766.4 |
433 | 2024-04-01 18:03:22 | sightings | 2 | 121436 | 16 | 4.376 | 27750.5 |
432 | 2024-03-28 17:16:42 | sightings | 4 | 165329 | 761 | 33.830 | 4887.1 |
431 | 2024-03-27 19:27:33 | sightings | 4 | 165329 | 761 | 18.390 | 8990.2 |
430 | 2024-03-27 09:30:33 | sightings | 4 | 165329 | 761 | 12.563 | 13160.0 |
429 | 2024-03-27 03:29:41 | sightings | 4 | 165329 | 761 | 24.143 | 6847.9 |
428 | 2024-03-27 03:29:35 | sightings | 3 | 148641 | 93 | 27.686 | 5368.8 |
427 | 2024-03-27 03:29:44 | sightings | 2 | 121436 | 16 | 8.560 | 14186.4 |
426 | 2024-03-27 01:31:26 | sightings | 1 | 81242 | 4 | 1.513 | 53696.0 |
425 | 2024-02-29 05:40:55 | sightings | 1 | 81242 | 4 | 3.033 | 26786.0 |
424 | 2024-02-25 07:02:17 | sightings | 1 | 81242 | 4 | 1.406 | 57782.4 |
423 | 2024-02-20 08:47:15 | sightings | 1 | 81242 | 4 | 3.000 | 27080.7 |
422 | 2024-02-12 19:27:58 | sightings | 1 | 81242 | 4 | 1.516 | 53589.7 |
421 | 2024-01-29 13:52:46 | sightings | 1 | 81242 | 4 | 1.436 | 56575.2 |
420 | 2023-12-19 08:54:05 | sightings | 1 | 81242 | 4 | 1.283 | 63321.9 |
419 | 2023-12-04 17:53:57 | sightings | 1 | 81242 | 4 | 1.360 | 59736.8 |
418 | 2023-11-08 17:04:54 | sightings | 1 | 81242 | 4 | 1.326 | 61268.5 |
417 | 2023-11-04 00:23:11 | sightings | 1 | 81242 | 4 | 1.406 | 57782.4 |
416 | 2023-10-31 18:05:10 | sightings | 1 | 81242 | 4 | 2.936 | 27671.0 |
415 | 2023-10-23 14:47:53 | sightings | 1 | 81242 | 4 | 1.440 | 56418.1 |
414 | 2023-09-18 13:38:23 | sightings | 1 | 81242 | 4 | 1.440 | 56418.1 |
413 | 2023-06-30 18:29:27 | sightings | 1 | 81242 | 4 | 1.356 | 59913.0 |
412 | 2023-06-27 01:49:03 | sightings | 1 | 81242 | 4 | 1.390 | 58447.5 |
411 | 2023-04-09 13:43:49 | sightings | 1 | 81242 | 4 | 1.220 | 66591.8 |
410 | 2023-02-22 09:14:17 | sightings | 1 | 81242 | 4 | 1.326 | 61268.5 |
409 | 2022-10-18 13:01:02 | sightings | 1 | 81242 | 4 | 1.236 | 65729.8 |
408 | 2022-10-14 19:42:46 | sightings | 1 | 81242 | 4 | 1.250 | 64993.6 |
407 | 2022-07-10 14:40:07 | sightings | 1 | 81242 | 4 | 1.233 | 65889.7 |
406 | 2022-06-13 07:17:47 | sightings | 1 | 81242 | 4 | 1.266 | 64172.2 |
405 | 2022-05-13 22:59:09 | sightings | 1 | 81242 | 4 | 2.143 | 37910.4 |
404 | 2022-02-02 00:17:33 | sightings | 1 | 81242 | 4 | 1.263 | 64324.6 |
403 | 2022-01-30 19:09:12 | sightings | 1 | 81242 | 4 | 1.263 | 64324.6 |
402 | 2022-01-29 08:48:04 | sightings | 1 | 81242 | 4 | 1.233 | 65889.7 |
401 | 2021-12-10 13:33:31 | sightings | 1 | 81242 | 4 | 1.560 | 52078.2 |
400 | 2021-10-12 14:37:43 | sightings | 1 | 81242 | 4 | 1.346 | 60358.1 |
399 | 2021-09-27 06:45:58 | sightings | 1 | 81242 | 4 | 1.453 | 55913.3 |
398 | 2021-09-26 20:16:26 | sightings | 1 | 81242 | 4 | 1.470 | 55266.7 |
397 | 2021-09-21 22:34:45 | sightings | 1 | 81242 | 4 | 1.420 | 57212.7 |
396 | 2021-07-11 11:47:33 | sightings | 1 | 81242 | 4 | 1.750 | 46424.0 |
395 | 2021-06-07 18:40:49 | sightings | 2 | 121436 | 16 | 3.216 | 37760.0 |
394 | 2021-05-23 11:25:03 | sightings | 4 | 165329 | 761 | 12.330 | 13408.7 |
393 | 2021-04-12 10:48:02 | sightings | 4 | 165329 | 761 | 13.406 | 12332.5 |
392 | 2021-04-07 13:26:05 | sightings | 1 | 81242 | 4 | 1.263 | 64324.6 |
391 | 2021-04-03 09:54:08 | sightings | 1 | 81242 | 4 | 1.406 | 57782.4 |
390 | 2021-03-25 10:27:53 | sightings | 3 | 148641 | 93 | 6.890 | 21573.4 |
389 | 2021-03-21 03:22:06 | sightings | 1 | 81242 | 4 | 1.233 | 65889.7 |
388 | 2021-03-16 19:16:53 | sightings | 2 | 121436 | 16 | 3.890 | 31217.5 |
387 | 2021-02-28 19:03:55 | sightings | 4 | 165329 | 761 | 11.123 | 14863.7 |
386 | 2021-02-23 18:56:13 | sightings | 1 | 81242 | 4 | 1.233 | 65889.7 |
385 | 2021-02-04 19:28:45 | sightings | 4 | 165329 | 761 | 10.420 | 15866.5 |
384 | 2021-02-03 17:20:04 | sightings | 3 | 148641 | 93 | 7.126 | 20859.0 |
383 | 2021-02-01 16:08:06 | sightings | 4 | 165329 | 761 | 11.830 | 13975.4 |
382 | 2021-01-30 18:27:46 | sightings | 1 | 81242 | 4 | 1.280 | 63470.3 |
381 | 2021-01-26 19:19:34 | sightings | 2 | 121436 | 16 | 3.343 | 36325.5 |
380 | 2020-12-18 14:21:27 | sightings | 1 | 81242 | 4 | 1.266 | 64172.2 |
379 | 2020-12-05 23:26:25 | sightings | 1 | 81242 | 4 | 1.250 | 64993.6 |
378 | 2020-11-10 02:26:14 | sightings | 1 | 81242 | 4 | 1.313 | 61875.1 |
377 | 2020-10-25 22:47:00 | sightings | 1 | 81242 | 4 | 1.440 | 56418.1 |
376 | 2020-09-14 14:01:21 | sightings | 1 | 81242 | 4 | 1.530 | 53099.3 |
375 | 2020-08-24 23:52:16 | sightings | 1 | 81242 | 4 | 1.250 | 64993.6 |
374 | 2020-08-12 04:29:24 | sightings | 1 | 81242 | 4 | 1.283 | 63321.9 |
373 | 2020-08-03 19:36:24 | sightings | 1 | 81242 | 4 | 1.280 | 63470.3 |
372 | 2020-06-02 11:07:41 | sightings | 1 | 81242 | 4 | 1.406 | 57782.4 |
371 | 2020-04-02 06:44:02 | sightings | 4 | 165329 | 761 | 10.530 | 15700.8 |
370 | 2020-03-24 16:16:32 | sightings | 1 | 81242 | 4 | 1.483 | 54782.2 |
369 | 2020-03-22 20:26:45 | sightings | 1 | 81242 | 4 | 3.046 | 26671.7 |
368 | 2020-03-22 10:46:25 | sightings | 4 | 165329 | 761 | 12.326 | 13413.0 |
367 | 2020-03-21 20:28:26 | sightings | 4 | 165329 | 761 | 13.890 | 11902.7 |
366 | 2020-03-08 11:17:11 | sightings | 4 | 165329 | 761 | 10.236 | 16151.7 |
365 | 2020-02-27 01:45:11 | sightings | 1 | 81242 | 4 | 1.500 | 54161.3 |
364 | 2020-02-26 02:03:30 | sightings | 4 | 165329 | 761 | 16.126 | 10252.3 |
363 | 2020-02-24 20:30:52 | sightings | 1 | 81242 | 4 | 1.596 | 50903.5 |
362 | 2020-02-24 10:03:29 | sightings | 1 | 81242 | 4 | 1.516 | 53589.7 |
361 | 2020-02-23 18:38:45 | sightings | 4 | 165329 | 761 | 12.003 | 13774.0 |
360 | 2020-02-23 11:33:05 | sightings | 4 | 165329 | 761 | 22.876 | 7227.2 |
359 | 2020-02-23 06:36:56 | sightings | 4 | 165329 | 761 | 16.233 | 10184.7 |
358 | 2020-02-17 08:32:13 | sightings | 1 | 81242 | 4 | 2.953 | 27511.7 |
357 | 2020-02-17 06:19:43 | sightings | 1 | 81242 | 4 | 3.220 | 25230.4 |
356 | 2020-02-17 02:33:03 | sightings | 3 | 148641 | 93 | 8.486 | 17516.0 |
355 | 2020-02-15 12:14:58 | sightings | 1 | 81242 | 4 | 1.830 | 44394.5 |
354 | 2020-02-14 22:01:07 | sightings | 3 | 148641 | 93 | 21.483 | 6919.0 |
353 | 2020-02-13 12:54:49 | sightings | 4 | 165329 | 761 | 18.533 | 8920.8 |
352 | 2020-02-04 19:50:05 | sightings | 1 | 81242 | 4 | 2.623 | 30972.9 |
351 | 2020-02-04 15:51:17 | sightings | 3 | 148641 | 93 | 7.373 | 20160.2 |
350 | 2020-02-04 15:48:19 | sightings | 2 | 121436 | 16 | 4.576 | 26537.6 |
349 | 2020-02-04 14:08:03 | sightings | 1 | 81242 | 4 | 2.123 | 38267.5 |
348 | 2020-02-02 21:39:52 | sightings | 4 | 165329 | 761 | 13.530 | 12219.4 |
347 | 2020-02-02 01:49:51 | sightings | 4 | 165329 | 761 | 12.593 | 13128.6 |
346 | 2020-01-31 15:44:35 | sightings | 4 | 165329 | 761 | 39.876 | 4146.1 |
345 | 2020-01-31 08:26:30 | sightings | 4 | 165329 | 761 | 26.486 | 6242.1 |
344 | 2020-01-31 03:51:17 | sightings | 4 | 165329 | 761 | 25.423 | 6503.1 |
343 | 2020-01-30 21:05:10 | sightings | 1 | 81242 | 4 | 2.750 | 29542.5 |
342 | 2020-01-27 21:53:57 | sightings | 4 | 165329 | 761 | 14.236 | 11613.4 |
341 | 2020-01-24 15:44:08 | sightings | 3 | 148641 | 93 | 21.093 | 7046.9 |
340 | 2020-01-24 02:20:25 | sightings | 3 | 148641 | 93 | 14.423 | 10305.8 |
339 | 2020-01-24 02:18:32 | sightings | 2 | 121436 | 16 | 5.843 | 20783.2 |