History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trolls"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
444 | 2024-05-07 13:23:11 | trolls | 1 | 48755 | 9 | 1.186 | 41108.8 |
443 | 2024-05-06 23:03:43 | trolls | 1 | 48755 | 9 | 0.843 | 57835.1 |
442 | 2024-05-01 08:01:10 | trolls | 2 | 82551 | 93 | 8.220 | 10042.7 |
441 | 2024-05-01 08:01:06 | trolls | 1 | 48755 | 9 | 2.750 | 17729.1 |
440 | 2024-04-29 17:57:47 | trolls | 3 | 112716 | 888 | 13.906 | 8105.6 |
439 | 2024-04-29 10:36:51 | trolls | 3 | 112716 | 888 | 11.170 | 10091.0 |
438 | 2024-04-28 21:46:18 | trolls | 2 | 82551 | 93 | 4.236 | 19488.0 |
437 | 2024-04-28 21:45:53 | trolls | 3 | 112716 | 888 | 5.720 | 19705.6 |
436 | 2024-04-28 21:16:21 | trolls | 3 | 112716 | 888 | 13.016 | 8659.8 |
435 | 2024-04-27 16:00:36 | trolls | 2 | 82551 | 93 | 3.233 | 25533.9 |
434 | 2024-04-27 11:38:33 | trolls | 2 | 82551 | 93 | 3.123 | 26433.2 |
433 | 2024-04-27 11:38:31 | trolls | 1 | 48755 | 9 | 0.936 | 52088.7 |
432 | 2024-04-27 11:37:55 | trolls | 3 | 112716 | 888 | 6.453 | 17467.2 |
431 | 2024-04-27 10:33:14 | trolls | 3 | 112716 | 888 | 6.733 | 16740.8 |
430 | 2024-03-29 18:06:01 | trolls | 3 | 112716 | 888 | 5.300 | 21267.2 |
429 | 2024-03-29 18:06:02 | trolls | 2 | 82551 | 93 | 2.483 | 33246.5 |
428 | 2024-03-29 18:05:48 | trolls | 1 | 48755 | 9 | 1.623 | 30040.0 |
427 | 2024-03-28 08:33:03 | trolls | 1 | 48755 | 9 | 0.873 | 55847.7 |
426 | 2024-03-04 20:49:55 | trolls | 2 | 82551 | 93 | 5.736 | 14391.7 |
425 | 2024-03-04 16:11:31 | trolls | 2 | 82551 | 93 | 2.703 | 30540.5 |
424 | 2024-03-04 14:22:29 | trolls | 3 | 112716 | 888 | 11.190 | 10072.9 |
423 | 2024-03-04 11:18:35 | trolls | 2 | 82551 | 93 | 2.343 | 35233.0 |
422 | 2024-03-04 11:18:34 | trolls | 1 | 48755 | 9 | 0.890 | 54780.9 |
421 | 2024-03-04 11:18:10 | trolls | 3 | 112716 | 888 | 5.516 | 20434.4 |
420 | 2024-03-04 03:16:02 | trolls | 3 | 112716 | 888 | 6.046 | 18643.1 |
419 | 2024-03-04 03:15:58 | trolls | 2 | 82551 | 93 | 5.220 | 15814.4 |
418 | 2024-03-04 03:15:56 | trolls | 1 | 48755 | 9 | 1.013 | 48129.3 |
417 | 2024-02-22 21:43:32 | trolls | 1 | 48755 | 9 | 0.923 | 52822.3 |
416 | 2024-01-17 20:10:48 | trolls | 3 | 112716 | 888 | 5.563 | 20261.7 |
415 | 2024-01-14 10:01:02 | trolls | 3 | 112716 | 888 | 6.330 | 17806.6 |
414 | 2024-01-14 10:01:00 | trolls | 2 | 82551 | 93 | 2.250 | 36689.3 |
413 | 2023-12-15 10:54:46 | trolls | 1 | 48755 | 9 | 0.940 | 51867.0 |
412 | 2023-12-06 00:59:54 | trolls | 1 | 48755 | 9 | 0.846 | 57630.0 |
411 | 2023-11-20 15:04:25 | trolls | 1 | 48755 | 9 | 0.796 | 61250.0 |
410 | 2023-11-16 12:08:41 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
409 | 2023-11-11 23:57:50 | trolls | 1 | 48755 | 9 | 1.390 | 35075.5 |
408 | 2023-11-04 16:07:18 | trolls | 1 | 48755 | 9 | 0.796 | 61250.0 |
407 | 2023-11-02 07:44:37 | trolls | 3 | 112716 | 888 | 5.466 | 20621.3 |
406 | 2023-11-02 02:31:10 | trolls | 2 | 82551 | 93 | 2.813 | 29346.2 |
405 | 2023-11-02 02:31:03 | trolls | 3 | 112716 | 888 | 7.063 | 15958.7 |
404 | 2023-10-30 08:29:16 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
403 | 2023-10-21 10:12:59 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
402 | 2023-10-16 04:15:11 | trolls | 1 | 48755 | 9 | 0.906 | 53813.5 |
401 | 2023-10-11 21:45:20 | trolls | 1 | 48755 | 9 | 0.826 | 59025.4 |
400 | 2023-10-09 09:23:00 | trolls | 1 | 48755 | 9 | 0.813 | 59969.2 |
399 | 2023-09-29 05:02:21 | trolls | 1 | 48755 | 9 | 0.766 | 63648.8 |
398 | 2023-09-24 10:36:47 | trolls | 1 | 48755 | 9 | 0.813 | 59969.2 |
397 | 2023-09-19 22:39:54 | trolls | 1 | 48755 | 9 | 0.733 | 66514.3 |
396 | 2023-07-11 09:37:55 | trolls | 1 | 48755 | 9 | 0.826 | 59025.4 |
395 | 2023-06-15 14:34:38 | trolls | 1 | 48755 | 9 | 0.733 | 66514.3 |
394 | 2023-04-17 14:04:10 | trolls | 1 | 48755 | 9 | 0.876 | 55656.4 |
393 | 2023-02-09 08:35:11 | trolls | 1 | 48755 | 9 | 0.843 | 57835.1 |
392 | 2023-02-07 01:20:23 | trolls | 1 | 48755 | 9 | 1.563 | 31193.2 |
391 | 2022-12-07 06:42:39 | trolls | 1 | 48755 | 9 | 0.736 | 66243.2 |
390 | 2022-10-02 09:27:30 | trolls | 1 | 48755 | 9 | 0.733 | 66514.3 |
389 | 2022-09-04 13:42:42 | trolls | 1 | 48755 | 9 | 0.733 | 66514.3 |
388 | 2022-08-15 02:23:24 | trolls | 1 | 48755 | 9 | 0.826 | 59025.4 |
387 | 2022-08-08 19:44:15 | trolls | 1 | 48755 | 9 | 0.733 | 66514.3 |
386 | 2022-08-06 11:30:16 | trolls | 1 | 48755 | 9 | 0.733 | 66514.3 |
385 | 2022-07-10 11:13:32 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
384 | 2022-07-02 20:20:36 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
383 | 2022-06-26 10:15:38 | trolls | 2 | 82551 | 93 | 2.173 | 37989.4 |
382 | 2022-06-15 22:12:34 | trolls | 1 | 48755 | 9 | 0.783 | 62266.9 |
381 | 2022-06-01 08:59:12 | trolls | 1 | 48755 | 9 | 0.906 | 53813.5 |
380 | 2022-03-31 09:19:33 | trolls | 1 | 48755 | 9 | 0.856 | 56956.8 |
379 | 2022-02-07 19:47:04 | trolls | 2 | 82551 | 93 | 2.296 | 35954.3 |
378 | 2022-01-31 08:40:34 | trolls | 1 | 48755 | 9 | 0.860 | 56691.9 |
377 | 2022-01-06 07:25:12 | trolls | 1 | 48755 | 9 | 0.873 | 55847.7 |
376 | 2021-11-12 22:07:22 | trolls | 2 | 82551 | 93 | 2.283 | 36159.0 |
375 | 2021-11-04 14:00:31 | trolls | 1 | 48755 | 9 | 0.796 | 61250.0 |
374 | 2021-10-11 05:35:45 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
373 | 2021-09-24 01:41:52 | trolls | 1 | 48755 | 9 | 0.813 | 59969.2 |
372 | 2021-09-21 23:10:14 | trolls | 1 | 48755 | 9 | 0.736 | 66243.2 |
371 | 2021-07-09 16:02:04 | trolls | 1 | 48755 | 9 | 0.830 | 58741.0 |
370 | 2021-06-07 07:41:39 | trolls | 1 | 48755 | 9 | 0.830 | 58741.0 |
369 | 2021-05-13 10:17:31 | trolls | 1 | 48755 | 9 | 0.830 | 58741.0 |
368 | 2021-04-12 08:39:57 | trolls | 1 | 48755 | 9 | 0.906 | 53813.5 |
367 | 2021-04-05 19:40:20 | trolls | 1 | 48755 | 9 | 1.750 | 27860.0 |
366 | 2021-02-26 04:19:21 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
365 | 2021-01-25 08:54:09 | trolls | 1 | 48755 | 9 | 0.810 | 60191.4 |
364 | 2020-12-28 01:52:38 | trolls | 1 | 48755 | 9 | 0.783 | 62266.9 |
363 | 2020-10-23 03:02:37 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
362 | 2020-10-09 14:08:07 | trolls | 1 | 48755 | 9 | 0.720 | 67715.3 |
361 | 2020-09-28 13:44:14 | trolls | 1 | 48755 | 9 | 0.860 | 56691.9 |
360 | 2020-08-05 22:11:04 | trolls | 1 | 48755 | 9 | 0.923 | 52822.3 |
359 | 2020-06-10 01:41:10 | trolls | 1 | 48755 | 9 | 0.763 | 63899.1 |
358 | 2020-06-03 14:00:21 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
357 | 2020-03-28 08:42:17 | trolls | 1 | 48755 | 9 | 1.796 | 27146.4 |
356 | 2020-03-23 12:51:52 | trolls | 1 | 48755 | 9 | 2.093 | 23294.3 |
355 | 2020-03-23 01:45:25 | trolls | 1 | 48755 | 9 | 0.906 | 53813.5 |
354 | 2020-03-19 21:18:20 | trolls | 1 | 48755 | 9 | 0.843 | 57835.1 |
353 | 2020-03-18 22:17:38 | trolls | 1 | 48755 | 9 | 0.736 | 66243.2 |
352 | 2020-03-14 01:50:08 | trolls | 1 | 48755 | 9 | 0.750 | 65006.7 |
351 | 2020-03-08 12:48:52 | trolls | 1 | 48755 | 9 | 0.796 | 61250.0 |
350 | 2020-03-05 02:06:59 | trolls | 1 | 48755 | 9 | 0.843 | 57835.1 |
349 | 2020-02-23 08:44:46 | trolls | 1 | 48755 | 9 | 0.920 | 52994.6 |
348 | 2020-02-21 09:51:23 | trolls | 1 | 48755 | 9 | 2.046 | 23829.4 |
347 | 2020-02-19 10:34:48 | trolls | 1 | 48755 | 9 | 1.000 | 48755.0 |
346 | 2020-02-01 09:51:20 | trolls | 1 | 48755 | 9 | 1.846 | 26411.2 |
345 | 2020-02-01 09:42:10 | trolls | 1 | 48755 | 9 | 0.910 | 53576.9 |