History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"purple"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
453 | 2024-04-25 10:52:28 | purple | 3 | 112716 | 546 | 19.376 | 5817.3 |
452 | 2024-04-11 22:42:23 | purple | 3 | 112716 | 546 | 9.296 | 12125.2 |
451 | 2024-04-10 05:11:35 | purple | 2 | 82551 | 49 | 5.873 | 14056.0 |
450 | 2024-04-10 05:11:07 | purple | 3 | 112716 | 546 | 5.906 | 19085.0 |
449 | 2024-04-08 22:11:33 | purple | 3 | 112716 | 546 | 16.110 | 6996.6 |
448 | 2024-04-08 22:11:43 | purple | 1 | 48755 | 6 | 4.140 | 11776.6 |
447 | 2024-04-08 22:11:35 | purple | 2 | 82551 | 49 | 3.030 | 27244.6 |
446 | 2024-04-01 13:23:02 | purple | 2 | 82551 | 49 | 7.406 | 11146.5 |
445 | 2024-04-01 13:22:11 | purple | 3 | 112716 | 546 | 7.986 | 14114.2 |
444 | 2024-03-10 21:18:39 | purple | 2 | 82551 | 49 | 2.500 | 33020.4 |
443 | 2024-03-10 21:17:42 | purple | 3 | 112716 | 546 | 6.783 | 16617.4 |
442 | 2024-03-10 20:12:28 | purple | 3 | 112716 | 546 | 19.800 | 5692.7 |
441 | 2024-03-08 21:52:05 | purple | 1 | 48755 | 6 | 0.923 | 52822.3 |
440 | 2024-03-08 21:51:47 | purple | 2 | 82551 | 49 | 5.670 | 14559.3 |
439 | 2024-03-08 21:51:30 | purple | 3 | 112716 | 546 | 6.563 | 17174.5 |
438 | 2024-03-04 07:13:21 | purple | 1 | 48755 | 6 | 2.970 | 16415.8 |
437 | 2024-02-10 20:14:29 | purple | 1 | 48755 | 6 | 1.373 | 35509.8 |
436 | 2024-02-07 01:08:05 | purple | 3 | 112716 | 546 | 5.250 | 21469.7 |
435 | 2024-01-31 23:29:44 | purple | 2 | 82551 | 49 | 2.500 | 33020.4 |
434 | 2024-01-31 23:29:24 | purple | 3 | 112716 | 546 | 5.936 | 18988.5 |
433 | 2024-01-31 20:59:12 | purple | 2 | 82551 | 49 | 5.330 | 15488.0 |
432 | 2024-01-31 20:58:52 | purple | 3 | 112716 | 546 | 5.283 | 21335.6 |
431 | 2024-01-13 02:58:54 | purple | 2 | 82551 | 49 | 2.343 | 35233.0 |
430 | 2024-01-10 14:51:55 | purple | 1 | 48755 | 6 | 0.843 | 57835.1 |
429 | 2024-01-10 01:50:57 | purple | 3 | 112716 | 546 | 5.373 | 20978.2 |
428 | 2024-01-09 05:54:24 | purple | 2 | 82551 | 49 | 2.093 | 39441.5 |
427 | 2024-01-06 21:58:27 | purple | 3 | 112716 | 546 | 5.063 | 22262.7 |
426 | 2024-01-06 21:58:25 | purple | 2 | 82551 | 49 | 2.436 | 33887.9 |
425 | 2024-01-05 02:35:11 | purple | 3 | 112716 | 546 | 5.610 | 20092.0 |
424 | 2023-12-13 06:27:02 | purple | 3 | 112716 | 546 | 5.393 | 20900.4 |
423 | 2023-11-28 22:43:00 | purple | 1 | 48755 | 6 | 1.826 | 26700.4 |
422 | 2023-11-18 00:17:59 | purple | 1 | 48755 | 6 | 0.843 | 57835.1 |
421 | 2023-11-14 20:26:19 | purple | 3 | 112716 | 546 | 5.186 | 21734.7 |
420 | 2023-11-14 20:26:16 | purple | 2 | 82551 | 49 | 2.436 | 33887.9 |
419 | 2023-11-14 15:40:47 | purple | 1 | 48755 | 6 | 0.733 | 66514.3 |
418 | 2023-11-06 13:41:05 | purple | 1 | 48755 | 6 | 0.813 | 59969.2 |
417 | 2023-10-21 10:06:42 | purple | 1 | 48755 | 6 | 0.826 | 59025.4 |
416 | 2023-10-19 07:25:02 | purple | 1 | 48755 | 6 | 0.826 | 59025.4 |
415 | 2023-10-17 02:25:13 | purple | 2 | 82551 | 49 | 2.110 | 39123.7 |
414 | 2023-10-14 01:59:44 | purple | 1 | 48755 | 6 | 0.796 | 61250.0 |
413 | 2023-10-05 01:02:25 | purple | 1 | 48755 | 6 | 0.920 | 52994.6 |
412 | 2023-09-30 22:14:09 | purple | 3 | 112716 | 546 | 5.890 | 19136.8 |
411 | 2023-09-29 03:42:55 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
410 | 2023-09-27 05:59:20 | purple | 3 | 112716 | 546 | 5.170 | 21801.9 |
409 | 2023-09-22 19:27:03 | purple | 1 | 48755 | 6 | 0.766 | 63648.8 |
408 | 2023-09-13 20:30:46 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
407 | 2023-09-11 18:01:49 | purple | 3 | 112716 | 546 | 5.560 | 20272.7 |
406 | 2023-09-04 05:06:28 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
405 | 2023-08-31 23:32:53 | purple | 1 | 48755 | 6 | 1.606 | 30358.0 |
404 | 2023-08-20 07:49:04 | purple | 3 | 112716 | 546 | 4.923 | 22895.8 |
403 | 2023-07-28 15:03:37 | purple | 2 | 82551 | 49 | 2.360 | 34979.2 |
402 | 2023-07-07 14:37:50 | purple | 3 | 112716 | 546 | 4.986 | 22606.5 |
401 | 2023-06-29 15:06:46 | purple | 1 | 48755 | 6 | 0.733 | 66514.3 |
400 | 2023-05-29 08:50:48 | purple | 3 | 112716 | 546 | 4.516 | 24959.3 |
399 | 2023-05-07 23:39:25 | purple | 1 | 48755 | 6 | 0.783 | 62266.9 |
398 | 2023-04-11 05:13:52 | purple | 2 | 82551 | 49 | 2.093 | 39441.5 |
397 | 2023-04-10 22:25:53 | purple | 1 | 48755 | 6 | 0.810 | 60191.4 |
396 | 2023-03-07 09:12:26 | purple | 3 | 112716 | 546 | 5.093 | 22131.6 |
395 | 2023-02-02 09:39:05 | purple | 1 | 48755 | 6 | 0.826 | 59025.4 |
394 | 2023-01-18 04:01:22 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
393 | 2023-01-17 18:39:53 | purple | 2 | 82551 | 49 | 2.140 | 38575.2 |
392 | 2022-12-10 23:06:33 | purple | 3 | 112716 | 546 | 4.576 | 24632.0 |
391 | 2022-11-30 13:47:12 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
390 | 2022-10-28 00:51:21 | purple | 2 | 82551 | 49 | 2.063 | 40015.0 |
389 | 2022-09-23 06:08:36 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
388 | 2022-07-25 08:46:49 | purple | 1 | 48755 | 6 | 0.736 | 66243.2 |
387 | 2022-07-25 03:51:35 | purple | 3 | 112716 | 546 | 4.720 | 23880.5 |
386 | 2022-07-22 19:45:04 | purple | 3 | 112716 | 546 | 4.673 | 24120.7 |
385 | 2022-05-22 13:16:18 | purple | 2 | 82551 | 49 | 2.250 | 36689.3 |
384 | 2022-05-17 06:40:20 | purple | 1 | 48755 | 6 | 0.763 | 63899.1 |
383 | 2022-05-13 17:47:09 | purple | 1 | 48755 | 6 | 0.966 | 50471.0 |
382 | 2022-03-22 07:40:17 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
381 | 2022-03-20 04:50:30 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
380 | 2022-02-28 16:00:05 | purple | 3 | 112716 | 546 | 5.453 | 20670.5 |
379 | 2022-02-24 07:00:37 | purple | 3 | 112716 | 546 | 4.686 | 24053.8 |
378 | 2022-01-19 03:48:54 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
377 | 2022-01-15 21:29:13 | purple | 1 | 48755 | 6 | 1.796 | 27146.4 |
376 | 2022-01-13 06:11:47 | purple | 2 | 82551 | 49 | 2.173 | 37989.4 |
375 | 2022-01-12 14:32:24 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
374 | 2022-01-11 03:27:58 | purple | 2 | 82551 | 49 | 2.156 | 38289.0 |
373 | 2021-12-21 22:49:16 | purple | 1 | 48755 | 6 | 0.906 | 53813.5 |
372 | 2021-11-22 11:10:32 | purple | 3 | 112716 | 546 | 9.500 | 11864.8 |
371 | 2021-10-30 22:47:11 | purple | 1 | 48755 | 6 | 0.906 | 53813.5 |
370 | 2021-10-28 21:44:54 | purple | 1 | 48755 | 6 | 0.873 | 55847.7 |
369 | 2021-10-23 19:33:44 | purple | 2 | 82551 | 49 | 2.280 | 36206.6 |
368 | 2021-09-29 22:57:18 | purple | 1 | 48755 | 6 | 0.840 | 58041.7 |
367 | 2021-08-24 02:20:29 | purple | 1 | 48755 | 6 | 0.763 | 63899.1 |
366 | 2021-07-14 08:28:54 | purple | 1 | 48755 | 6 | 0.843 | 57835.1 |
365 | 2021-06-30 13:14:56 | purple | 1 | 48755 | 6 | 0.890 | 54780.9 |
364 | 2021-04-01 12:53:58 | purple | 1 | 48755 | 6 | 0.813 | 59969.2 |
363 | 2021-03-30 09:36:34 | purple | 1 | 48755 | 6 | 0.856 | 56956.8 |
362 | 2021-03-26 01:15:30 | purple | 1 | 48755 | 6 | 0.813 | 59969.2 |
361 | 2021-03-21 15:35:25 | purple | 1 | 48755 | 6 | 0.840 | 58041.7 |
360 | 2021-01-26 00:02:04 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
359 | 2021-01-16 15:32:43 | purple | 1 | 48755 | 6 | 0.813 | 59969.2 |
358 | 2020-12-18 19:20:10 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
357 | 2020-12-17 11:38:11 | purple | 1 | 48755 | 6 | 0.780 | 62506.4 |
356 | 2020-10-18 02:10:56 | purple | 1 | 48755 | 6 | 0.750 | 65006.7 |
355 | 2020-10-17 12:56:45 | purple | 1 | 48755 | 6 | 0.733 | 66514.3 |
354 | 2020-10-09 19:24:43 | purple | 1 | 48755 | 6 | 0.830 | 58741.0 |