History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"penicillium"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
208 | 2024-04-28 02:29:16 | penicillium | 3 | 121633 | 6 | 6.046 | 20117.9 |
207 | 2024-04-28 00:39:39 | penicillium | 2 | 86808 | 4 | 3.826 | 22689.0 |
206 | 2024-04-27 21:31:19 | penicillium | 4 | 148819 | 21 | 23.860 | 6237.2 |
205 | 2024-04-27 10:56:10 | penicillium | 4 | 148819 | 21 | 24.533 | 6066.1 |
204 | 2024-03-28 02:36:25 | penicillium | 1 | 49908 | 1 | 0.763 | 65410.2 |
203 | 2024-03-14 17:19:02 | penicillium | 5 | 164607 | 78 | 60.503 | 2720.6 |
202 | 2024-03-11 07:12:54 | penicillium | 5 | 164607 | 78 | 55.910 | 2944.1 |
201 | 2024-03-11 03:23:43 | penicillium | 1 | 49908 | 1 | 0.923 | 54071.5 |
200 | 2024-03-06 13:50:16 | penicillium | 5 | 164607 | 78 | 27.830 | 5914.7 |
199 | 2024-03-06 13:47:02 | penicillium | 5 | 164607 | 78 | 26.253 | 6270.0 |
198 | 2024-03-03 07:33:12 | penicillium | 2 | 86808 | 4 | 8.440 | 10285.3 |
197 | 2024-03-03 07:32:58 | penicillium | 3 | 121633 | 6 | 13.390 | 9083.9 |
196 | 2024-03-02 02:39:01 | penicillium | 2 | 86808 | 4 | 3.016 | 28782.5 |
195 | 2024-03-02 02:36:35 | penicillium | 4 | 148819 | 21 | 24.003 | 6200.0 |
194 | 2024-02-24 20:42:02 | penicillium | 2 | 86808 | 4 | 6.186 | 14033.0 |
193 | 2024-02-24 20:41:54 | penicillium | 3 | 121633 | 6 | 9.313 | 13060.6 |
192 | 2024-02-22 12:36:59 | penicillium | 5 | 164607 | 78 | 40.940 | 4020.7 |
191 | 2024-02-21 09:00:10 | penicillium | 5 | 164607 | 78 | 51.253 | 3211.7 |
190 | 2024-02-20 07:32:22 | penicillium | 4 | 148819 | 21 | 11.360 | 13100.3 |
189 | 2024-02-20 07:32:21 | penicillium | 2 | 86808 | 4 | 3.200 | 27127.5 |
188 | 2024-02-20 04:06:13 | penicillium | 5 | 164607 | 78 | 17.813 | 9240.8 |
187 | 2024-02-20 04:03:58 | penicillium | 3 | 121633 | 6 | 10.376 | 11722.5 |
186 | 2024-02-19 22:24:08 | penicillium | 1 | 49908 | 1 | 0.890 | 56076.4 |
185 | 2024-02-18 08:22:53 | penicillium | 3 | 121633 | 6 | 10.220 | 11901.5 |
184 | 2024-02-18 03:46:53 | penicillium | 3 | 121633 | 6 | 5.830 | 20863.3 |
183 | 2024-02-18 03:46:50 | penicillium | 1 | 49908 | 1 | 0.876 | 56972.6 |
182 | 2024-02-17 21:27:08 | penicillium | 1 | 49908 | 1 | 0.876 | 56972.6 |
181 | 2024-01-19 20:57:41 | penicillium | 6 | 173545 | 538 | 43.050 | 4031.2 |
180 | 2024-01-19 20:57:42 | penicillium | 5 | 164607 | 78 | 19.843 | 8295.5 |
179 | 2024-01-19 20:57:30 | penicillium | 4 | 148819 | 21 | 10.796 | 13784.6 |
178 | 2024-01-14 00:21:57 | penicillium | 2 | 86808 | 4 | 2.453 | 35388.5 |
177 | 2023-12-24 01:01:42 | penicillium | 4 | 148819 | 21 | 8.533 | 17440.4 |
176 | 2023-12-15 14:53:11 | penicillium | 1 | 49908 | 1 | 1.720 | 29016.3 |
175 | 2023-12-13 11:59:39 | penicillium | 1 | 49908 | 1 | 0.780 | 63984.6 |
174 | 2023-12-13 08:33:46 | penicillium | 1 | 49908 | 1 | 0.783 | 63739.5 |
173 | 2023-11-26 19:35:11 | penicillium | 6 | 173545 | 538 | 22.113 | 7848.1 |
172 | 2023-10-26 03:23:51 | penicillium | 2 | 86808 | 4 | 2.360 | 36783.1 |
171 | 2023-09-28 20:10:31 | penicillium | 1 | 49908 | 1 | 0.766 | 65154.0 |
170 | 2023-09-22 10:13:00 | penicillium | 4 | 148819 | 21 | 8.706 | 17093.8 |
169 | 2023-08-31 06:05:37 | penicillium | 1 | 49908 | 1 | 0.860 | 58032.6 |
168 | 2023-08-26 10:31:45 | penicillium | 6 | 173545 | 538 | 23.126 | 7504.3 |
167 | 2023-08-23 08:49:08 | penicillium | 5 | 164607 | 78 | 14.253 | 11548.9 |
166 | 2023-08-04 22:17:32 | penicillium | 2 | 86808 | 4 | 2.343 | 37049.9 |
165 | 2023-07-26 10:26:52 | penicillium | 1 | 49908 | 1 | 1.656 | 30137.7 |
164 | 2023-07-26 10:16:02 | penicillium | 1 | 49908 | 1 | 0.750 | 66544.0 |
163 | 2023-06-21 23:02:36 | penicillium | 4 | 148819 | 21 | 9.373 | 15877.4 |
162 | 2023-06-03 01:01:01 | penicillium | 5 | 164607 | 78 | 14.560 | 11305.4 |
161 | 2023-05-13 08:21:39 | penicillium | 6 | 173545 | 538 | 19.376 | 8956.7 |
160 | 2023-05-06 19:04:05 | penicillium | 6 | 173545 | 538 | 21.830 | 7949.8 |
159 | 2023-04-22 15:33:38 | penicillium | 1 | 49908 | 1 | 0.750 | 66544.0 |
158 | 2023-04-18 22:55:28 | penicillium | 2 | 86808 | 4 | 2.140 | 40564.5 |
157 | 2023-04-17 14:37:47 | penicillium | 5 | 164607 | 78 | 12.890 | 12770.1 |
156 | 2023-04-16 13:34:50 | penicillium | 5 | 164607 | 78 | 14.220 | 11575.7 |
155 | 2023-03-27 06:53:39 | penicillium | 6 | 173545 | 538 | 19.220 | 9029.4 |
154 | 2023-03-21 18:01:28 | penicillium | 5 | 164607 | 78 | 13.143 | 12524.3 |
153 | 2023-03-19 23:29:05 | penicillium | 4 | 148819 | 21 | 8.190 | 18170.8 |
152 | 2023-03-19 08:58:55 | penicillium | 6 | 173545 | 538 | 34.750 | 4994.1 |
151 | 2023-03-07 09:42:34 | penicillium | 1 | 49908 | 1 | 0.750 | 66544.0 |
150 | 2023-02-22 00:44:36 | penicillium | 6 | 173545 | 538 | 19.236 | 9021.9 |
149 | 2023-02-20 08:45:05 | penicillium | 5 | 164607 | 78 | 13.390 | 12293.3 |
148 | 2023-02-11 13:50:49 | penicillium | 1 | 49908 | 1 | 0.860 | 58032.6 |
147 | 2023-01-21 17:27:06 | penicillium | 2 | 86808 | 4 | 2.080 | 41734.6 |
146 | 2023-01-02 05:28:50 | penicillium | 6 | 173545 | 538 | 19.546 | 8878.8 |
145 | 2023-01-01 03:27:47 | penicillium | 5 | 164607 | 78 | 16.720 | 9844.9 |
144 | 2022-12-29 14:37:59 | penicillium | 6 | 173545 | 538 | 21.173 | 8196.5 |
143 | 2022-12-21 16:44:01 | penicillium | 4 | 148819 | 21 | 8.093 | 18388.6 |
142 | 2022-12-16 13:33:54 | penicillium | 6 | 173545 | 538 | 20.266 | 8563.4 |
141 | 2022-12-07 19:38:00 | penicillium | 1 | 49908 | 1 | 0.766 | 65154.0 |
140 | 2022-12-04 14:38:03 | penicillium | 6 | 173545 | 538 | 18.986 | 9140.7 |
139 | 2022-11-20 07:27:33 | penicillium | 6 | 173545 | 538 | 24.876 | 6976.4 |
138 | 2022-11-20 04:09:06 | penicillium | 6 | 173545 | 538 | 26.923 | 6446.0 |
137 | 2022-11-13 15:59:43 | penicillium | 6 | 173545 | 538 | 20.690 | 8387.9 |
136 | 2022-11-01 18:23:22 | penicillium | 2 | 86808 | 4 | 2.110 | 41141.2 |
135 | 2022-09-28 22:18:36 | penicillium | 6 | 173545 | 538 | 19.796 | 8766.7 |
134 | 2022-09-11 15:29:02 | penicillium | 1 | 49908 | 1 | 0.893 | 55888.0 |
133 | 2022-09-10 04:07:08 | penicillium | 6 | 173545 | 538 | 19.736 | 8793.3 |
132 | 2022-08-21 14:18:54 | penicillium | 6 | 173545 | 538 | 19.940 | 8703.4 |
131 | 2022-08-20 11:44:19 | penicillium | 4 | 148819 | 21 | 8.266 | 18003.8 |
130 | 2022-08-15 05:40:35 | penicillium | 6 | 173545 | 538 | 20.533 | 8452.0 |
129 | 2022-08-08 09:10:38 | penicillium | 1 | 49908 | 1 | 0.763 | 65410.2 |
128 | 2022-08-06 02:09:30 | penicillium | 1 | 49908 | 1 | 0.843 | 59202.8 |
127 | 2022-07-01 18:39:10 | penicillium | 6 | 173545 | 538 | 20.640 | 8408.2 |
126 | 2022-05-21 21:14:55 | penicillium | 2 | 86808 | 4 | 2.123 | 40889.3 |
125 | 2022-04-12 17:45:28 | penicillium | 6 | 173545 | 538 | 22.780 | 7618.3 |
124 | 2022-03-26 16:45:42 | penicillium | 1 | 49908 | 1 | 0.766 | 65154.0 |
123 | 2022-03-24 13:14:46 | penicillium | 1 | 49908 | 1 | 1.126 | 44323.3 |
122 | 2022-03-07 19:15:16 | penicillium | 1 | 49908 | 1 | 1.186 | 42080.9 |
121 | 2021-10-19 19:09:56 | penicillium | 1 | 49908 | 1 | 0.826 | 60421.3 |
120 | 2021-09-06 17:59:02 | penicillium | 1 | 49908 | 1 | 0.856 | 58303.7 |
119 | 2021-07-28 12:01:16 | penicillium | 1 | 49908 | 1 | 0.763 | 65410.2 |
118 | 2021-06-26 18:17:36 | penicillium | 1 | 49908 | 1 | 0.890 | 56076.4 |
117 | 2021-06-18 11:52:48 | penicillium | 1 | 49908 | 1 | 0.796 | 62698.5 |
116 | 2021-05-03 13:54:59 | penicillium | 1 | 49908 | 1 | 0.796 | 62698.5 |
115 | 2021-03-22 12:20:58 | penicillium | 1 | 49908 | 1 | 0.766 | 65154.0 |
114 | 2021-02-25 00:08:03 | penicillium | 1 | 49908 | 1 | 0.780 | 63984.6 |
113 | 2020-12-28 20:53:41 | penicillium | 1 | 49908 | 1 | 0.780 | 63984.6 |
112 | 2020-10-27 23:51:36 | penicillium | 1 | 49908 | 1 | 0.766 | 65154.0 |
111 | 2020-08-25 02:42:48 | penicillium | 1 | 49908 | 1 | 0.970 | 51451.5 |
110 | 2020-04-13 08:14:00 | penicillium | 1 | 49908 | 1 | 0.800 | 62385.0 |
109 | 2020-03-27 20:22:50 | penicillium | 1 | 49908 | 1 | 0.906 | 55086.1 |