History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"comedy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-04-24 09:45:58 | comedy | 1 | 48755 | 3 | 0.966 | 50471.0 |
420 | 2024-04-21 08:39:32 | comedy | 1 | 48755 | 3 | 1.703 | 28628.9 |
419 | 2024-04-15 09:43:02 | comedy | 3 | 112716 | 591 | 11.513 | 9790.3 |
418 | 2024-04-10 21:43:28 | comedy | 1 | 48755 | 3 | 2.546 | 19149.6 |
417 | 2024-04-08 05:41:08 | comedy | 3 | 112716 | 591 | 17.110 | 6587.7 |
416 | 2024-04-06 01:56:36 | comedy | 1 | 48755 | 3 | 1.076 | 45311.3 |
415 | 2024-04-06 01:16:58 | comedy | 2 | 82551 | 46 | 4.593 | 17973.2 |
414 | 2024-04-05 23:52:33 | comedy | 3 | 112716 | 591 | 19.533 | 5770.5 |
413 | 2024-04-05 11:00:50 | comedy | 2 | 82551 | 46 | 9.970 | 8279.9 |
412 | 2024-04-05 11:00:45 | comedy | 1 | 48755 | 3 | 1.796 | 27146.4 |
411 | 2024-04-05 09:59:28 | comedy | 3 | 112716 | 591 | 20.050 | 5621.7 |
410 | 2024-04-05 08:16:39 | comedy | 3 | 112716 | 591 | 10.140 | 11116.0 |
409 | 2024-04-03 17:15:15 | comedy | 3 | 112716 | 591 | 19.236 | 5859.6 |
408 | 2024-04-03 11:37:01 | comedy | 3 | 112716 | 591 | 14.686 | 7675.1 |
407 | 2024-04-01 18:20:06 | comedy | 1 | 48755 | 3 | 0.796 | 61250.0 |
406 | 2024-03-10 23:35:03 | comedy | 3 | 112716 | 591 | 6.940 | 16241.5 |
405 | 2024-03-10 16:25:19 | comedy | 3 | 112716 | 591 | 13.610 | 8281.9 |
404 | 2024-03-06 23:19:33 | comedy | 2 | 82551 | 46 | 5.983 | 13797.6 |
403 | 2024-03-06 23:19:36 | comedy | 1 | 48755 | 3 | 2.953 | 16510.3 |
402 | 2024-03-06 21:42:17 | comedy | 1 | 48755 | 3 | 0.970 | 50262.9 |
401 | 2024-03-06 19:43:30 | comedy | 3 | 112716 | 591 | 7.670 | 14695.7 |
400 | 2024-03-06 05:36:24 | comedy | 3 | 112716 | 591 | 19.906 | 5662.4 |
399 | 2024-03-06 05:36:28 | comedy | 2 | 82551 | 46 | 8.813 | 9367.0 |
398 | 2024-03-06 05:36:14 | comedy | 1 | 48755 | 3 | 2.986 | 16327.9 |
397 | 2024-02-27 08:29:31 | comedy | 2 | 82551 | 46 | 6.703 | 12315.5 |
396 | 2024-02-27 08:29:09 | comedy | 3 | 112716 | 591 | 8.296 | 13586.8 |
395 | 2024-02-26 21:56:54 | comedy | 3 | 112716 | 591 | 5.670 | 19879.4 |
394 | 2024-02-26 21:56:55 | comedy | 2 | 82551 | 46 | 2.640 | 31269.3 |
393 | 2024-02-26 21:56:38 | comedy | 1 | 48755 | 3 | 0.750 | 65006.7 |
392 | 2024-01-27 16:58:13 | comedy | 1 | 48755 | 3 | 0.873 | 55847.7 |
391 | 2024-01-16 13:01:31 | comedy | 2 | 82551 | 46 | 2.393 | 34496.9 |
390 | 2023-12-27 13:58:46 | comedy | 1 | 48755 | 3 | 0.843 | 57835.1 |
389 | 2023-12-11 09:14:29 | comedy | 3 | 112716 | 591 | 5.453 | 20670.5 |
388 | 2023-12-11 09:14:27 | comedy | 2 | 82551 | 46 | 2.453 | 33653.1 |
387 | 2023-12-07 12:22:08 | comedy | 3 | 112716 | 591 | 4.843 | 23274.0 |
386 | 2023-12-03 17:46:17 | comedy | 3 | 112716 | 591 | 5.796 | 19447.2 |
385 | 2023-11-26 19:50:37 | comedy | 2 | 82551 | 46 | 2.483 | 33246.5 |
384 | 2023-11-26 19:50:34 | comedy | 3 | 112716 | 591 | 5.483 | 20557.4 |
383 | 2023-11-18 14:31:05 | comedy | 2 | 82551 | 46 | 2.156 | 38289.0 |
382 | 2023-11-18 08:55:17 | comedy | 1 | 48755 | 3 | 0.843 | 57835.1 |
381 | 2023-11-11 03:26:59 | comedy | 1 | 48755 | 3 | 0.826 | 59025.4 |
380 | 2023-11-10 02:08:14 | comedy | 1 | 48755 | 3 | 0.826 | 59025.4 |
379 | 2023-10-27 23:55:14 | comedy | 1 | 48755 | 3 | 0.843 | 57835.1 |
378 | 2023-10-26 23:27:26 | comedy | 2 | 82551 | 46 | 2.250 | 36689.3 |
377 | 2023-10-20 04:09:29 | comedy | 1 | 48755 | 3 | 0.750 | 65006.7 |
376 | 2023-10-18 01:04:39 | comedy | 1 | 48755 | 3 | 0.766 | 63648.8 |
375 | 2023-10-17 03:40:06 | comedy | 1 | 48755 | 3 | 0.783 | 62266.9 |
374 | 2023-10-11 23:34:07 | comedy | 1 | 48755 | 3 | 0.796 | 61250.0 |
373 | 2023-10-04 05:47:21 | comedy | 1 | 48755 | 3 | 0.830 | 58741.0 |
372 | 2023-09-24 20:37:51 | comedy | 3 | 112716 | 591 | 5.936 | 18988.5 |
371 | 2023-09-24 20:37:50 | comedy | 2 | 82551 | 46 | 2.563 | 32208.7 |
370 | 2023-09-23 22:44:23 | comedy | 1 | 48755 | 3 | 1.030 | 47335.0 |
369 | 2023-09-19 12:18:35 | comedy | 1 | 48755 | 3 | 0.733 | 66514.3 |
368 | 2023-09-12 05:33:19 | comedy | 3 | 112716 | 591 | 12.283 | 9176.6 |
367 | 2023-09-04 10:14:19 | comedy | 3 | 112716 | 591 | 4.690 | 24033.3 |
366 | 2023-08-13 10:57:15 | comedy | 1 | 48755 | 3 | 0.856 | 56956.8 |
365 | 2023-08-05 10:52:36 | comedy | 2 | 82551 | 46 | 2.406 | 34310.5 |
364 | 2023-07-17 03:20:53 | comedy | 1 | 48755 | 3 | 0.830 | 58741.0 |
363 | 2023-05-12 14:30:47 | comedy | 1 | 48755 | 3 | 0.783 | 62266.9 |
362 | 2023-04-15 23:03:50 | comedy | 2 | 82551 | 46 | 2.173 | 37989.4 |
361 | 2023-03-22 03:49:50 | comedy | 1 | 48755 | 3 | 0.860 | 56691.9 |
360 | 2023-03-06 11:51:35 | comedy | 1 | 48755 | 3 | 0.873 | 55847.7 |
359 | 2023-01-21 09:51:40 | comedy | 2 | 82551 | 46 | 2.203 | 37472.1 |
358 | 2023-01-14 21:46:49 | comedy | 3 | 112716 | 591 | 4.766 | 23650.0 |
357 | 2023-01-06 03:36:06 | comedy | 3 | 112716 | 591 | 4.640 | 24292.2 |
356 | 2022-12-30 02:49:33 | comedy | 1 | 48755 | 3 | 0.830 | 58741.0 |
355 | 2022-12-13 21:37:25 | comedy | 3 | 112716 | 591 | 5.360 | 21029.1 |
354 | 2022-11-30 22:16:38 | comedy | 3 | 112716 | 591 | 4.813 | 23419.1 |
353 | 2022-11-30 18:40:35 | comedy | 1 | 48755 | 3 | 0.780 | 62506.4 |
352 | 2022-11-27 11:56:15 | comedy | 1 | 48755 | 3 | 0.763 | 63899.1 |
351 | 2022-11-03 17:53:18 | comedy | 3 | 112716 | 591 | 5.503 | 20482.6 |
350 | 2022-11-01 08:15:51 | comedy | 2 | 82551 | 46 | 2.530 | 32628.9 |
349 | 2022-09-16 07:22:31 | comedy | 1 | 48755 | 3 | 0.750 | 65006.7 |
348 | 2022-09-12 08:13:04 | comedy | 3 | 112716 | 591 | 5.186 | 21734.7 |
347 | 2022-07-31 09:53:11 | comedy | 1 | 48755 | 3 | 0.826 | 59025.4 |
346 | 2022-06-12 11:15:12 | comedy | 1 | 48755 | 3 | 0.766 | 63648.8 |
345 | 2022-05-23 13:20:16 | comedy | 2 | 82551 | 46 | 2.373 | 34787.6 |
344 | 2022-05-17 19:32:50 | comedy | 1 | 48755 | 3 | 0.860 | 56691.9 |
343 | 2022-04-27 20:28:00 | comedy | 1 | 48755 | 3 | 1.313 | 37132.5 |
342 | 2022-03-26 11:47:40 | comedy | 1 | 48755 | 3 | 0.780 | 62506.4 |
341 | 2022-02-12 13:39:24 | comedy | 1 | 48755 | 3 | 0.860 | 56691.9 |
340 | 2022-01-23 09:32:52 | comedy | 1 | 48755 | 3 | 0.876 | 55656.4 |
339 | 2022-01-20 08:21:32 | comedy | 1 | 48755 | 3 | 0.936 | 52088.7 |
338 | 2021-12-09 03:07:02 | comedy | 1 | 48755 | 3 | 1.813 | 26891.9 |
337 | 2021-11-17 04:01:16 | comedy | 1 | 48755 | 3 | 0.813 | 59969.2 |
336 | 2021-11-12 18:08:17 | comedy | 1 | 48755 | 3 | 0.766 | 63648.8 |
335 | 2021-09-30 09:09:02 | comedy | 1 | 48755 | 3 | 0.860 | 56691.9 |
334 | 2021-09-09 00:20:13 | comedy | 1 | 48755 | 3 | 0.763 | 63899.1 |
333 | 2021-09-05 01:21:08 | comedy | 1 | 48755 | 3 | 0.826 | 59025.4 |
332 | 2021-09-01 17:57:56 | comedy | 1 | 48755 | 3 | 0.873 | 55847.7 |
331 | 2021-07-25 23:17:04 | comedy | 1 | 48755 | 3 | 0.766 | 63648.8 |
330 | 2021-07-04 15:11:37 | comedy | 1 | 48755 | 3 | 0.876 | 55656.4 |
329 | 2021-06-15 05:33:27 | comedy | 1 | 48755 | 3 | 0.813 | 59969.2 |
328 | 2021-06-12 00:11:45 | comedy | 1 | 48755 | 3 | 0.780 | 62506.4 |
327 | 2021-05-22 01:41:14 | comedy | 1 | 48755 | 3 | 0.923 | 52822.3 |
326 | 2021-05-22 00:45:40 | comedy | 1 | 48755 | 3 | 0.876 | 55656.4 |
325 | 2021-05-18 17:26:39 | comedy | 1 | 48755 | 3 | 0.860 | 56691.9 |
324 | 2021-05-01 15:41:38 | comedy | 1 | 48755 | 3 | 0.936 | 52088.7 |
323 | 2021-04-23 12:33:23 | comedy | 1 | 48755 | 3 | 0.843 | 57835.1 |
322 | 2021-04-09 20:25:03 | comedy | 3 | 112716 | 591 | 5.203 | 21663.7 |