History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"waterlily"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
118 | 2024-05-31 04:18:29 | waterlily | 1 | 81242 | 2 | 1.436 | 56575.2 |
117 | 2024-05-31 01:11:05 | waterlily | 4 | 165329 | 240 | 23.393 | 7067.5 |
116 | 2024-05-30 18:22:51 | waterlily | 1 | 81242 | 2 | 1.423 | 57092.1 |
115 | 2024-05-14 20:26:26 | waterlily | 1 | 81242 | 2 | 1.456 | 55798.1 |
114 | 2024-05-07 20:11:36 | waterlily | 3 | 148641 | 24 | 12.126 | 12258.0 |
113 | 2024-05-07 10:45:11 | waterlily | 1 | 81242 | 2 | 1.360 | 59736.8 |
112 | 2024-05-06 13:24:52 | waterlily | 3 | 148641 | 24 | 14.780 | 10056.9 |
111 | 2024-05-04 21:16:21 | waterlily | 4 | 165329 | 240 | 21.830 | 7573.5 |
110 | 2024-05-04 09:11:49 | waterlily | 4 | 165329 | 240 | 18.390 | 8990.2 |
109 | 2024-05-04 09:11:53 | waterlily | 3 | 148641 | 24 | 7.673 | 19372.0 |
108 | 2024-05-04 09:07:57 | waterlily | 2 | 121436 | 3 | 4.186 | 29010.0 |
107 | 2024-05-04 09:06:05 | waterlily | 1 | 81242 | 2 | 1.483 | 54782.2 |
106 | 2024-04-30 05:25:09 | waterlily | 1 | 81242 | 2 | 5.156 | 15756.8 |
105 | 2024-04-08 08:12:13 | waterlily | 1 | 81242 | 2 | 1.440 | 56418.1 |
104 | 2024-04-05 12:19:29 | waterlily | 3 | 148641 | 24 | 28.220 | 5267.2 |
103 | 2024-04-05 05:58:20 | waterlily | 3 | 148641 | 24 | 17.953 | 8279.5 |
102 | 2024-04-03 18:39:19 | waterlily | 4 | 165329 | 240 | 22.690 | 7286.4 |
101 | 2024-04-03 12:14:55 | waterlily | 4 | 165329 | 240 | 26.140 | 6324.8 |
100 | 2024-04-03 08:06:00 | waterlily | 4 | 165329 | 240 | 24.033 | 6879.2 |
99 | 2024-04-03 08:05:57 | waterlily | 3 | 148641 | 24 | 15.300 | 9715.1 |
98 | 2024-04-03 08:05:50 | waterlily | 2 | 121436 | 3 | 10.750 | 11296.4 |
97 | 2024-04-03 08:05:13 | waterlily | 1 | 81242 | 2 | 3.623 | 22424.0 |
96 | 2024-03-30 19:31:12 | waterlily | 1 | 81242 | 2 | 4.343 | 18706.4 |
95 | 2024-03-02 12:28:44 | waterlily | 1 | 81242 | 2 | 4.563 | 17804.5 |
94 | 2024-02-27 21:47:13 | waterlily | 1 | 81242 | 2 | 1.453 | 55913.3 |
93 | 2024-02-26 08:48:35 | waterlily | 1 | 81242 | 2 | 1.406 | 57782.4 |
92 | 2024-01-30 02:56:30 | waterlily | 1 | 81242 | 2 | 1.483 | 54782.2 |
91 | 2024-01-28 21:18:00 | waterlily | 1 | 81242 | 2 | 1.326 | 61268.5 |
90 | 2024-01-26 20:05:07 | waterlily | 1 | 81242 | 2 | 2.626 | 30937.5 |
89 | 2024-01-19 09:51:15 | waterlily | 1 | 81242 | 2 | 1.373 | 59171.2 |
88 | 2023-11-26 17:21:42 | waterlily | 1 | 81242 | 2 | 1.343 | 60492.9 |
87 | 2023-09-26 08:20:49 | waterlily | 1 | 81242 | 2 | 1.326 | 61268.5 |
86 | 2023-08-19 15:04:36 | waterlily | 1 | 81242 | 2 | 1.343 | 60492.9 |
85 | 2023-03-29 15:02:45 | waterlily | 1 | 81242 | 2 | 1.360 | 59736.8 |
84 | 2023-02-18 00:57:39 | waterlily | 1 | 81242 | 2 | 1.326 | 61268.5 |
83 | 2022-11-03 09:17:29 | waterlily | 1 | 81242 | 2 | 1.250 | 64993.6 |
82 | 2022-08-23 13:51:18 | waterlily | 1 | 81242 | 2 | 1.203 | 67532.8 |
81 | 2022-07-15 02:05:54 | waterlily | 3 | 148641 | 24 | 6.140 | 24208.6 |
80 | 2022-06-04 00:42:33 | waterlily | 1 | 81242 | 2 | 1.263 | 64324.6 |
79 | 2022-04-09 09:44:02 | waterlily | 1 | 81242 | 2 | 1.216 | 66810.9 |
78 | 2022-01-21 17:38:47 | waterlily | 1 | 81242 | 2 | 1.360 | 59736.8 |
77 | 2021-12-31 21:24:35 | waterlily | 1 | 81242 | 2 | 1.373 | 59171.2 |
76 | 2021-08-16 11:59:59 | waterlily | 1 | 81242 | 2 | 1.203 | 67532.8 |
75 | 2021-04-21 02:43:21 | waterlily | 1 | 81242 | 2 | 1.233 | 65889.7 |
74 | 2021-01-28 09:08:16 | waterlily | 1 | 81242 | 2 | 1.203 | 67532.8 |
73 | 2021-01-07 19:39:31 | waterlily | 1 | 81242 | 2 | 1.376 | 59042.2 |
72 | 2020-12-30 17:08:34 | waterlily | 1 | 81242 | 2 | 1.250 | 64993.6 |
71 | 2020-10-02 03:17:30 | waterlily | 1 | 81242 | 2 | 1.343 | 60492.9 |
70 | 2020-09-01 01:14:14 | waterlily | 1 | 81242 | 2 | 1.250 | 64993.6 |
69 | 2020-08-09 14:32:53 | waterlily | 1 | 81242 | 2 | 1.390 | 58447.5 |
68 | 2020-08-09 07:33:48 | waterlily | 1 | 81242 | 2 | 1.266 | 64172.2 |
67 | 2020-05-31 15:55:06 | waterlily | 1 | 81242 | 2 | 1.203 | 67532.8 |
66 | 2020-03-25 05:42:45 | waterlily | 1 | 81242 | 2 | 1.470 | 55266.7 |
65 | 2020-03-01 09:14:25 | waterlily | 1 | 81242 | 2 | 1.516 | 53589.7 |
64 | 2020-03-01 07:24:01 | waterlily | 1 | 81242 | 2 | 2.986 | 27207.6 |
63 | 2020-02-15 12:47:00 | waterlily | 1 | 81242 | 2 | 4.593 | 17688.2 |
62 | 2020-02-08 17:51:28 | waterlily | 1 | 81242 | 2 | 1.470 | 55266.7 |
61 | 2020-02-03 12:47:28 | waterlily | 1 | 81242 | 2 | 1.283 | 63321.9 |
60 | 2020-01-31 14:29:36 | waterlily | 1 | 81242 | 2 | 1.440 | 56418.1 |
59 | 2020-01-29 18:33:10 | waterlily | 1 | 81242 | 2 | 1.313 | 61875.1 |
58 | 2020-01-29 08:46:41 | waterlily | 1 | 81242 | 2 | 1.956 | 41534.8 |
57 | 2020-01-26 19:00:07 | waterlily | 1 | 81242 | 2 | 1.233 | 65889.7 |
56 | 2020-01-20 18:38:33 | waterlily | 1 | 81242 | 2 | 1.546 | 52549.8 |
55 | 2020-01-17 20:57:30 | waterlily | 1 | 81242 | 2 | 4.220 | 19251.7 |
54 | 2020-01-07 12:53:36 | waterlily | 1 | 81242 | 2 | 1.360 | 59736.8 |
53 | 2020-01-02 07:41:38 | waterlily | 1 | 81242 | 2 | 2.140 | 37963.6 |
52 | 2019-10-25 09:46:54 | waterlily | 1 | 81242 | 2 | 1.170 | 69437.6 |
51 | 2019-07-11 14:35:09 | waterlily | 1 | 81242 | 2 | 1.383 | 58743.3 |
50 | 2019-03-03 05:52:45 | waterlily | 1 | 81242 | 2 | 1.190 | 68270.6 |
49 | 2018-11-02 04:12:52 | waterlily | 1 | 81242 | 2 | 1.316 | 61734.0 |
48 | 2018-07-29 05:54:30 | waterlily | 1 | 81242 | 2 | 1.406 | 57782.4 |
47 | 2018-04-05 11:00:34 | waterlily | 1 | 81242 | 2 | 1.786 | 45488.2 |
46 | 2018-04-04 02:09:12 | waterlily | 1 | 81242 | 2 | 1.686 | 48186.2 |
45 | 2017-12-07 00:20:46 | waterlily | 1 | 81242 | 2 | 1.630 | 49841.7 |
44 | 2016-11-12 20:38:12 | waterlily | 1 | 81242 | 2 | 1.716 | 47343.8 |
43 | 2016-10-16 16:10:30 | waterlily | 4 | 165329 | 240 | 16.410 | 10074.9 |
42 | 2016-09-06 05:21:05 | waterlily | 1 | 81242 | 2 | 1.563 | 51978.2 |
41 | 2016-07-22 07:40:05 | waterlily | 3 | 148641 | 24 | 11.746 | 12654.6 |
40 | 2016-07-19 06:51:57 | waterlily | 4 | 165329 | 240 | 21.196 | 7800.0 |
39 | 2016-07-17 17:23:18 | waterlily | 1 | 81242 | 2 | 2.066 | 39323.3 |
38 | 2016-06-29 14:03:58 | waterlily | 1 | 81242 | 2 | 2.236 | 36333.6 |
37 | 2016-05-10 14:51:50 | waterlily | 1 | 81242 | 2 | 2.840 | 28606.3 |
36 | 2016-04-19 14:28:55 | waterlily | 1 | 81242 | 2 | 1.400 | 58030.0 |
35 | 2016-04-19 12:25:18 | waterlily | 1 | 81242 | 2 | 1.430 | 56812.6 |
34 | 2016-03-22 11:33:20 | waterlily | 1 | 81242 | 2 | 2.056 | 39514.6 |
33 | 2016-03-12 09:49:27 | waterlily | 2 | 121436 | 3 | 3.683 | 32972.0 |
32 | 2016-02-27 03:48:19 | waterlily | 1 | 81242 | 2 | 2.686 | 30246.5 |
31 | 2016-02-17 04:22:02 | waterlily | 1 | 81242 | 2 | 1.473 | 55154.1 |
30 | 2016-02-03 01:17:03 | waterlily | 1 | 81242 | 2 | 1.416 | 57374.3 |
29 | 2015-10-31 16:28:13 | waterlily | 1 | 81242 | 2 | 2.766 | 29371.7 |
28 | 2015-09-21 02:49:55 | waterlily | 1 | 81242 | 2 | 1.443 | 56300.8 |
27 | 2015-07-21 08:12:18 | waterlily | 4 | 165329 | 240 | 16.000 | 10333.1 |
26 | 2015-07-21 08:12:13 | waterlily | 3 | 148641 | 24 | 10.173 | 14611.3 |
25 | 2015-07-21 08:12:05 | waterlily | 2 | 121436 | 3 | 4.250 | 28573.2 |
24 | 2015-07-21 08:07:26 | waterlily | 1 | 81242 | 2 | 3.236 | 25105.7 |
23 | 2015-06-02 07:46:24 | waterlily | 1 | 81242 | 2 | 1.496 | 54306.1 |
22 | 2015-02-26 02:16:15 | waterlily | 3 | 148641 | 24 | 24.380 | 6096.8 |
21 | 2015-02-17 10:59:05 | waterlily | 1 | 81242 | 2 | 1.730 | 46960.7 |
20 | 2014-12-30 05:03:20 | waterlily | 1 | 81242 | 2 | 1.520 | 53448.7 |
19 | 2014-12-30 00:01:42 | waterlily | 3 | 148641 | 24 | 9.933 | 14964.4 |