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 |
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 |
343 | 2024-11-21 12:18:03 | sighting | 1 | 82945 | 10 | 2.453 | 33813.7 |
342 | 2024-11-12 18:42:25 | sighting | 1 | 82945 | 10 | 8.390 | 9886.2 |
341 | 2024-11-02 07:28:56 | sighting | 1 | 82945 | 10 | 2.580 | 32149.2 |
340 | 2024-10-24 13:26:52 | sighting | 3 | 146162 | 282 | 32.876 | 4445.9 |
339 | 2024-10-23 09:47:17 | sighting | 3 | 146162 | 282 | 20.720 | 7054.2 |
338 | 2024-10-23 09:47:20 | sighting | 2 | 121059 | 34 | 8.796 | 13763.0 |
337 | 2024-10-21 10:14:11 | sighting | 2 | 121059 | 34 | 9.290 | 13031.1 |
336 | 2024-10-21 10:11:37 | sighting | 3 | 146162 | 282 | 7.640 | 19131.2 |
335 | 2024-10-18 02:43:18 | sighting | 3 | 146162 | 282 | 25.293 | 5778.8 |
334 | 2024-10-18 02:43:16 | sighting | 2 | 121059 | 34 | 10.906 | 11100.2 |
333 | 2024-10-18 02:43:15 | sighting | 1 | 82945 | 10 | 2.623 | 31622.2 |
332 | 2024-10-13 14:17:35 | sighting | 1 | 82945 | 10 | 6.546 | 12671.1 |
331 | 2024-10-10 03:23:37 | sighting | 1 | 82945 | 10 | 3.186 | 26034.2 |
330 | 2024-09-30 10:08:20 | sighting | 1 | 82945 | 10 | 10.860 | 7637.7 |
329 | 2024-09-21 18:18:02 | sighting | 3 | 146162 | 282 | 43.910 | 3328.7 |
328 | 2024-09-20 09:13:31 | sighting | 3 | 146162 | 282 | 33.830 | 4320.5 |
327 | 2024-09-16 16:30:23 | sighting | 3 | 146162 | 282 | 66.893 | 2185.0 |
326 | 2024-09-16 05:55:29 | sighting | 3 | 146162 | 282 | 46.390 | 3150.7 |
325 | 2024-09-16 05:55:30 | sighting | 2 | 121059 | 34 | 19.610 | 6173.3 |
324 | 2024-09-16 05:54:48 | sighting | 1 | 82945 | 10 | 5.046 | 16437.8 |
323 | 2024-08-24 11:33:06 | sighting | 1 | 82945 | 10 | 10.033 | 8267.2 |
322 | 2024-08-23 02:09:05 | sighting | 1 | 82945 | 10 | 3.810 | 21770.3 |
321 | 2024-08-20 16:02:57 | sighting | 3 | 146162 | 282 | 40.393 | 3618.5 |
320 | 2024-08-20 11:02:06 | sighting | 3 | 146162 | 282 | 51.096 | 2860.5 |
319 | 2024-08-20 11:01:52 | sighting | 2 | 121059 | 34 | 14.036 | 8624.9 |
318 | 2024-08-17 20:44:42 | sighting | 1 | 82945 | 10 | 14.486 | 5725.9 |
317 | 2024-08-17 20:35:34 | sighting | 3 | 146162 | 282 | 25.690 | 5689.5 |
316 | 2024-08-17 13:36:05 | sighting | 1 | 82945 | 10 | 9.780 | 8481.1 |
315 | 2024-08-16 23:35:15 | sighting | 3 | 146162 | 282 | 60.333 | 2422.6 |
314 | 2024-08-16 23:35:11 | sighting | 2 | 121059 | 34 | 24.620 | 4917.1 |
313 | 2024-08-16 23:34:47 | sighting | 1 | 82945 | 10 | 11.716 | 7079.6 |
312 | 2024-08-15 14:26:16 | sighting | 3 | 146162 | 282 | 54.033 | 2705.1 |
311 | 2024-08-15 14:26:06 | sighting | 2 | 121059 | 34 | 28.316 | 4275.3 |
310 | 2024-08-15 14:17:39 | sighting | 1 | 82945 | 10 | 3.296 | 25165.4 |
309 | 2024-07-22 01:25:22 | sighting | 1 | 82945 | 10 | 7.736 | 10721.9 |
308 | 2024-07-15 18:36:41 | sighting | 1 | 82945 | 10 | 7.033 | 11793.7 |
307 | 2024-07-15 09:52:46 | sighting | 1 | 82945 | 10 | 7.390 | 11224.0 |
306 | 2024-07-14 10:07:25 | sighting | 1 | 82945 | 10 | 8.343 | 9941.9 |
305 | 2024-07-07 05:55:04 | sighting | 1 | 82945 | 10 | 2.843 | 29175.2 |
304 | 2024-07-07 05:48:57 | sighting | 1 | 82945 | 10 | 5.970 | 13893.6 |
303 | 2024-07-01 08:09:28 | sighting | 1 | 82945 | 10 | 6.593 | 12580.8 |