History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spotters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
436 | 2024-04-15 01:14:10 | spotters | 1 | 82945 | 10 | 3.466 | 23931.0 |
435 | 2024-04-15 00:17:33 | spotters | 2 | 121059 | 74 | 13.533 | 8945.5 |
434 | 2024-04-15 00:13:30 | spotters | 2 | 121059 | 74 | 14.250 | 8495.4 |
433 | 2024-04-15 00:13:08 | spotters | 1 | 82945 | 10 | 5.640 | 14706.6 |
432 | 2024-04-14 23:59:20 | spotters | 1 | 82945 | 10 | 5.783 | 14342.9 |
431 | 2024-04-07 16:21:29 | spotters | 2 | 121059 | 74 | 4.500 | 26902.0 |
430 | 2024-04-03 10:52:32 | spotters | 1 | 82945 | 10 | 1.736 | 47779.4 |
429 | 2024-04-03 10:46:40 | spotters | 3 | 146162 | 504 | 11.406 | 12814.5 |
428 | 2024-04-03 10:46:25 | spotters | 2 | 121059 | 74 | 8.626 | 14034.2 |
427 | 2024-04-02 03:31:57 | spotters | 1 | 82945 | 10 | 1.423 | 58288.8 |
426 | 2024-04-02 03:31:45 | spotters | 2 | 121059 | 74 | 3.513 | 34460.3 |
425 | 2024-04-02 03:31:39 | spotters | 1 | 82945 | 10 | 1.453 | 57085.3 |
424 | 2024-03-31 17:50:00 | spotters | 1 | 82945 | 10 | 1.893 | 43816.7 |
423 | 2024-03-31 05:24:03 | spotters | 3 | 146162 | 504 | 26.220 | 5574.4 |
422 | 2024-03-31 05:24:04 | spotters | 2 | 121059 | 74 | 9.203 | 13154.3 |
421 | 2024-03-31 03:36:49 | spotters | 1 | 82945 | 10 | 2.656 | 31229.3 |
420 | 2024-03-29 09:07:28 | spotters | 3 | 146162 | 504 | 14.860 | 9835.9 |
419 | 2024-03-29 06:56:21 | spotters | 2 | 121059 | 74 | 8.906 | 13593.0 |
418 | 2024-03-29 06:55:56 | spotters | 3 | 146162 | 504 | 16.423 | 8899.8 |
417 | 2024-03-29 06:55:27 | spotters | 1 | 82945 | 10 | 1.640 | 50576.2 |
416 | 2024-03-28 20:10:09 | spotters | 1 | 82945 | 10 | 1.486 | 55817.6 |
415 | 2024-03-04 07:15:04 | spotters | 2 | 121059 | 74 | 12.313 | 9831.8 |
414 | 2024-03-04 07:14:48 | spotters | 1 | 82945 | 10 | 4.796 | 17294.6 |
413 | 2024-03-02 02:56:22 | spotters | 1 | 82945 | 10 | 3.393 | 24445.9 |
412 | 2024-02-29 22:07:34 | spotters | 1 | 82945 | 10 | 3.173 | 26140.9 |
411 | 2024-02-25 18:56:26 | spotters | 1 | 82945 | 10 | 5.033 | 16480.2 |
410 | 2024-01-31 16:40:32 | spotters | 2 | 121059 | 74 | 3.326 | 36397.8 |
409 | 2024-01-31 16:30:24 | spotters | 3 | 146162 | 504 | 7.486 | 19524.7 |
408 | 2024-01-31 12:59:35 | spotters | 2 | 121059 | 74 | 4.000 | 30264.8 |
407 | 2024-01-31 12:59:11 | spotters | 3 | 146162 | 504 | 7.033 | 20782.3 |
406 | 2024-01-31 11:14:19 | spotters | 1 | 82945 | 10 | 1.486 | 55817.6 |
405 | 2024-01-31 11:02:47 | spotters | 3 | 146162 | 504 | 7.406 | 19735.6 |
404 | 2024-01-31 11:02:39 | spotters | 2 | 121059 | 74 | 3.783 | 32000.8 |
403 | 2024-01-30 15:38:40 | spotters | 1 | 82945 | 10 | 1.563 | 53067.8 |
402 | 2024-01-01 10:47:46 | spotters | 1 | 82945 | 10 | 1.453 | 57085.3 |
401 | 2023-12-31 17:42:11 | spotters | 3 | 146162 | 504 | 6.326 | 23105.0 |
400 | 2023-12-20 08:03:25 | spotters | 1 | 82945 | 10 | 2.843 | 29175.2 |
399 | 2023-12-04 18:28:17 | spotters | 2 | 121059 | 74 | 3.843 | 31501.2 |
398 | 2023-11-30 05:58:27 | spotters | 1 | 82945 | 10 | 1.266 | 65517.4 |
397 | 2023-11-28 06:25:40 | spotters | 1 | 82945 | 10 | 1.280 | 64800.8 |
396 | 2023-11-24 11:56:11 | spotters | 2 | 121059 | 74 | 3.453 | 35059.1 |
395 | 2023-11-24 11:56:06 | spotters | 3 | 146162 | 504 | 6.766 | 21602.4 |
394 | 2023-11-20 15:10:47 | spotters | 3 | 146162 | 504 | 6.423 | 22756.0 |
393 | 2023-11-20 15:10:43 | spotters | 2 | 121059 | 74 | 3.656 | 33112.4 |
392 | 2023-11-06 07:42:59 | spotters | 1 | 82945 | 10 | 1.453 | 57085.3 |
391 | 2023-10-27 08:17:27 | spotters | 1 | 82945 | 10 | 1.593 | 52068.4 |
390 | 2023-10-22 10:21:07 | spotters | 1 | 82945 | 10 | 1.360 | 60989.0 |
389 | 2023-10-08 15:17:14 | spotters | 1 | 82945 | 10 | 1.283 | 64649.3 |
388 | 2023-10-03 19:17:00 | spotters | 3 | 146162 | 504 | 7.093 | 20606.5 |
387 | 2023-09-27 19:22:00 | spotters | 2 | 121059 | 74 | 4.093 | 29577.1 |
386 | 2023-09-27 19:21:56 | spotters | 3 | 146162 | 504 | 7.656 | 19091.2 |
385 | 2023-09-19 18:42:38 | spotters | 1 | 82945 | 10 | 1.440 | 57600.7 |
384 | 2023-09-02 06:38:10 | spotters | 2 | 121059 | 74 | 3.830 | 31608.1 |
383 | 2023-08-04 03:03:09 | spotters | 1 | 82945 | 10 | 1.280 | 64800.8 |
382 | 2023-07-30 22:28:55 | spotters | 1 | 82945 | 10 | 1.280 | 64800.8 |
381 | 2023-07-14 01:29:21 | spotters | 3 | 146162 | 504 | 6.843 | 21359.3 |
380 | 2023-05-28 16:43:35 | spotters | 3 | 146162 | 504 | 6.140 | 23804.9 |
379 | 2023-05-20 15:02:27 | spotters | 2 | 121059 | 74 | 3.140 | 38553.8 |
378 | 2023-05-03 23:22:59 | spotters | 1 | 82945 | 10 | 3.766 | 22024.7 |
377 | 2023-04-19 16:36:03 | spotters | 3 | 146162 | 504 | 7.266 | 20115.9 |
376 | 2023-04-07 22:48:56 | spotters | 1 | 82945 | 10 | 1.406 | 58993.6 |
375 | 2023-03-29 20:28:35 | spotters | 3 | 146162 | 504 | 7.096 | 20597.8 |
374 | 2023-03-01 07:04:39 | spotters | 2 | 121059 | 74 | 3.423 | 35366.3 |
373 | 2023-02-24 02:45:20 | spotters | 1 | 82945 | 10 | 1.266 | 65517.4 |
372 | 2023-01-19 03:51:56 | spotters | 3 | 146162 | 504 | 6.143 | 23793.3 |
371 | 2022-12-26 20:31:48 | spotters | 3 | 146162 | 504 | 6.170 | 23689.1 |
370 | 2022-12-26 19:36:48 | spotters | 3 | 146162 | 504 | 6.190 | 23612.6 |
369 | 2022-12-22 20:02:13 | spotters | 1 | 82945 | 10 | 1.280 | 64800.8 |
368 | 2022-12-22 14:29:59 | spotters | 1 | 82945 | 10 | 1.420 | 58412.0 |
367 | 2022-12-07 21:09:09 | spotters | 2 | 121059 | 74 | 3.126 | 38726.5 |
366 | 2022-11-10 07:27:18 | spotters | 3 | 146162 | 504 | 6.296 | 23215.1 |
365 | 2022-11-10 05:34:18 | spotters | 3 | 146162 | 504 | 6.423 | 22756.0 |
364 | 2022-11-07 15:29:45 | spotters | 3 | 146162 | 504 | 6.936 | 21073.0 |
363 | 2022-11-05 00:23:24 | spotters | 3 | 146162 | 504 | 6.533 | 22372.9 |
362 | 2022-10-05 01:50:16 | spotters | 3 | 146162 | 504 | 6.923 | 21112.5 |
361 | 2022-09-04 22:50:37 | spotters | 1 | 82945 | 10 | 1.296 | 64000.8 |
360 | 2022-08-28 01:40:43 | spotters | 3 | 146162 | 504 | 6.266 | 23326.2 |
359 | 2022-08-26 02:27:29 | spotters | 1 | 82945 | 10 | 1.390 | 59672.7 |
358 | 2022-06-21 21:26:10 | spotters | 3 | 146162 | 504 | 6.440 | 22696.0 |
357 | 2022-05-05 08:22:49 | spotters | 3 | 146162 | 504 | 6.936 | 21073.0 |
356 | 2022-04-29 05:44:13 | spotters | 1 | 82945 | 10 | 1.453 | 57085.3 |
355 | 2022-04-21 18:55:15 | spotters | 1 | 82945 | 10 | 1.876 | 44213.8 |
354 | 2022-04-05 09:52:26 | spotters | 2 | 121059 | 74 | 4.283 | 28265.0 |
353 | 2022-03-29 11:51:53 | spotters | 3 | 146162 | 504 | 7.420 | 19698.4 |
352 | 2022-01-22 12:27:05 | spotters | 1 | 82945 | 10 | 1.423 | 58288.8 |
351 | 2022-01-20 09:29:25 | spotters | 1 | 82945 | 10 | 1.436 | 57761.1 |
350 | 2022-01-05 14:27:18 | spotters | 1 | 82945 | 10 | 2.000 | 41472.5 |
349 | 2021-12-18 05:51:44 | spotters | 1 | 82945 | 10 | 1.453 | 57085.3 |
348 | 2021-12-16 18:43:25 | spotters | 2 | 121059 | 74 | 3.906 | 30993.1 |
347 | 2021-12-12 02:03:22 | spotters | 3 | 146162 | 504 | 10.766 | 13576.3 |
346 | 2021-11-13 22:36:42 | spotters | 1 | 82945 | 10 | 1.640 | 50576.2 |
345 | 2021-10-03 17:54:54 | spotters | 1 | 82945 | 10 | 1.593 | 52068.4 |
344 | 2021-09-29 11:58:29 | spotters | 1 | 82945 | 10 | 1.390 | 59672.7 |
343 | 2021-09-14 13:48:42 | spotters | 1 | 82945 | 10 | 1.356 | 61168.9 |
342 | 2021-07-23 07:01:08 | spotters | 3 | 146162 | 504 | 6.890 | 21213.6 |
341 | 2021-06-26 12:15:50 | spotters | 1 | 82945 | 10 | 1.500 | 55296.7 |
340 | 2021-06-23 05:21:48 | spotters | 1 | 82945 | 10 | 1.563 | 53067.8 |
339 | 2021-06-07 16:39:57 | spotters | 3 | 146162 | 504 | 7.716 | 18942.7 |
338 | 2021-06-03 06:37:53 | spotters | 3 | 146162 | 504 | 6.673 | 21903.5 |
337 | 2021-06-01 07:57:07 | spotters | 3 | 146162 | 504 | 7.283 | 20068.9 |