History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"diapause"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
267 | 2024-04-12 23:13:25 | diapause | 4 | 161609 | 384 | 13.376 | 12082.0 |
266 | 2024-04-10 22:05:50 | diapause | 4 | 161609 | 384 | 26.546 | 6087.9 |
265 | 2024-04-10 22:05:49 | diapause | 3 | 146162 | 35 | 24.423 | 5984.6 |
264 | 2024-04-10 22:05:49 | diapause | 2 | 121059 | 4 | 10.470 | 11562.5 |
263 | 2024-04-10 22:05:13 | diapause | 1 | 82945 | 3 | 3.236 | 25632.0 |
262 | 2024-04-10 12:00:50 | diapause | 3 | 146162 | 35 | 10.953 | 13344.5 |
261 | 2024-04-10 12:00:40 | diapause | 2 | 121059 | 4 | 3.593 | 33693.0 |
260 | 2024-04-09 17:13:13 | diapause | 4 | 161609 | 384 | 17.406 | 9284.7 |
259 | 2024-04-08 23:19:52 | diapause | 4 | 161609 | 384 | 30.813 | 5244.8 |
258 | 2024-04-07 19:28:18 | diapause | 4 | 161609 | 384 | 11.546 | 13997.0 |
257 | 2024-04-07 19:28:11 | diapause | 2 | 121059 | 4 | 3.733 | 32429.4 |
256 | 2024-04-07 19:28:12 | diapause | 1 | 82945 | 3 | 1.516 | 54713.1 |
255 | 2024-04-04 16:19:40 | diapause | 1 | 82945 | 3 | 1.843 | 45005.4 |
254 | 2024-04-04 16:19:28 | diapause | 2 | 121059 | 4 | 8.093 | 14958.5 |
253 | 2024-04-04 16:19:27 | diapause | 1 | 82945 | 3 | 1.576 | 52630.1 |
252 | 2024-03-30 01:00:49 | diapause | 3 | 146162 | 35 | 19.233 | 7599.5 |
251 | 2024-03-26 20:50:58 | diapause | 1 | 82945 | 3 | 1.453 | 57085.3 |
250 | 2024-03-26 20:50:54 | diapause | 2 | 121059 | 4 | 3.610 | 33534.3 |
249 | 2024-03-23 06:30:01 | diapause | 3 | 146162 | 35 | 8.190 | 17846.4 |
248 | 2024-03-20 21:20:03 | diapause | 3 | 146162 | 35 | 17.626 | 8292.4 |
247 | 2024-03-20 05:17:21 | diapause | 3 | 146162 | 35 | 7.483 | 19532.5 |
246 | 2024-03-20 05:17:22 | diapause | 2 | 121059 | 4 | 3.983 | 30393.9 |
245 | 2024-03-20 05:16:50 | diapause | 1 | 82945 | 3 | 1.516 | 54713.1 |
244 | 2024-03-11 17:12:32 | diapause | 4 | 161609 | 384 | 34.910 | 4629.3 |
243 | 2024-03-10 18:44:05 | diapause | 1 | 82945 | 3 | 4.313 | 19231.4 |
242 | 2024-03-10 11:44:57 | diapause | 4 | 161609 | 384 | 42.970 | 3761.0 |
241 | 2024-03-09 20:49:50 | diapause | 1 | 82945 | 3 | 2.813 | 29486.3 |
240 | 2024-03-09 19:23:39 | diapause | 4 | 161609 | 384 | 24.173 | 6685.5 |
239 | 2024-03-06 13:47:13 | diapause | 4 | 161609 | 384 | 25.123 | 6432.7 |
238 | 2024-03-05 18:59:45 | diapause | 4 | 161609 | 384 | 33.173 | 4871.7 |
237 | 2024-03-05 13:02:59 | diapause | 4 | 161609 | 384 | 25.123 | 6432.7 |
236 | 2024-03-05 13:03:00 | diapause | 2 | 121059 | 4 | 3.750 | 32282.4 |
235 | 2024-03-05 13:02:52 | diapause | 1 | 82945 | 3 | 1.436 | 57761.1 |
234 | 2024-03-03 05:25:02 | diapause | 1 | 82945 | 3 | 1.640 | 50576.2 |
233 | 2024-02-25 09:26:03 | diapause | 2 | 121059 | 4 | 3.923 | 30858.8 |
232 | 2024-02-25 09:26:01 | diapause | 1 | 82945 | 3 | 1.533 | 54106.3 |
231 | 2024-02-08 08:21:16 | diapause | 4 | 161609 | 384 | 21.843 | 7398.7 |
230 | 2024-02-05 23:34:02 | diapause | 4 | 161609 | 384 | 13.750 | 11753.4 |
229 | 2024-02-05 20:31:42 | diapause | 3 | 146162 | 35 | 14.766 | 9898.6 |
228 | 2024-02-05 05:32:34 | diapause | 3 | 146162 | 35 | 16.970 | 8613.0 |
227 | 2024-02-04 02:42:49 | diapause | 3 | 146162 | 35 | 11.563 | 12640.5 |
226 | 2024-02-04 02:42:09 | diapause | 2 | 121059 | 4 | 3.533 | 34265.2 |
225 | 2024-02-04 02:12:21 | diapause | 1 | 82945 | 3 | 1.423 | 58288.8 |
224 | 2024-01-26 11:23:09 | diapause | 4 | 161609 | 384 | 18.796 | 8598.1 |
223 | 2024-01-26 11:07:11 | diapause | 4 | 161609 | 384 | 27.126 | 5957.7 |
222 | 2024-01-26 11:05:23 | diapause | 4 | 161609 | 384 | 13.550 | 11926.9 |
221 | 2024-01-23 14:58:14 | diapause | 1 | 82945 | 3 | 4.640 | 17876.1 |
220 | 2024-01-06 00:16:24 | diapause | 1 | 82945 | 3 | 1.330 | 62364.7 |
219 | 2024-01-05 18:50:19 | diapause | 1 | 82945 | 3 | 1.266 | 65517.4 |
218 | 2023-12-22 12:11:53 | diapause | 3 | 146162 | 35 | 7.546 | 19369.5 |
217 | 2023-12-22 11:47:34 | diapause | 2 | 121059 | 4 | 3.186 | 37997.2 |
216 | 2023-12-20 13:24:30 | diapause | 4 | 161609 | 384 | 10.686 | 15123.4 |
215 | 2023-12-15 16:35:45 | diapause | 1 | 82945 | 3 | 1.436 | 57761.1 |
214 | 2023-10-28 20:46:47 | diapause | 1 | 82945 | 3 | 1.313 | 63172.1 |
213 | 2023-10-14 08:07:25 | diapause | 1 | 82945 | 3 | 1.250 | 66356.0 |
212 | 2023-10-09 19:54:19 | diapause | 1 | 82945 | 3 | 1.280 | 64800.8 |
211 | 2023-09-23 17:13:12 | diapause | 2 | 121059 | 4 | 3.343 | 36212.7 |
210 | 2023-09-23 05:42:38 | diapause | 3 | 146162 | 35 | 7.393 | 19770.3 |
209 | 2023-09-20 19:55:30 | diapause | 4 | 161609 | 384 | 11.203 | 14425.5 |
208 | 2023-08-27 14:23:28 | diapause | 1 | 82945 | 3 | 1.250 | 66356.0 |
207 | 2023-08-24 01:25:59 | diapause | 1 | 82945 | 3 | 1.250 | 66356.0 |
206 | 2023-07-05 13:46:13 | diapause | 2 | 121059 | 4 | 3.170 | 38189.0 |
205 | 2023-07-02 05:12:03 | diapause | 3 | 146162 | 35 | 6.313 | 23152.5 |
204 | 2023-06-29 06:51:39 | diapause | 4 | 161609 | 384 | 11.140 | 14507.1 |
203 | 2023-05-23 15:58:18 | diapause | 1 | 82945 | 3 | 1.236 | 67107.6 |
202 | 2023-05-03 01:25:22 | diapause | 1 | 82945 | 3 | 1.466 | 56579.1 |
201 | 2023-03-25 23:50:51 | diapause | 2 | 121059 | 4 | 3.233 | 37444.8 |
200 | 2023-03-23 06:52:41 | diapause | 3 | 146162 | 35 | 7.046 | 20744.0 |
199 | 2023-03-22 10:37:23 | diapause | 4 | 161609 | 384 | 10.800 | 14963.8 |
198 | 2023-03-21 03:46:38 | diapause | 1 | 82945 | 3 | 1.220 | 67987.7 |
197 | 2023-01-06 07:36:27 | diapause | 1 | 82945 | 3 | 1.236 | 67107.6 |
196 | 2023-01-05 20:23:37 | diapause | 1 | 82945 | 3 | 1.296 | 64000.8 |
195 | 2022-12-24 00:59:37 | diapause | 2 | 121059 | 4 | 3.110 | 38925.7 |
194 | 2022-12-22 10:32:45 | diapause | 3 | 146162 | 35 | 7.720 | 18932.9 |
193 | 2022-12-21 18:10:52 | diapause | 4 | 161609 | 384 | 10.406 | 15530.4 |
192 | 2022-10-01 04:37:34 | diapause | 1 | 82945 | 3 | 1.266 | 65517.4 |
191 | 2022-09-04 08:14:42 | diapause | 1 | 82945 | 3 | 1.266 | 65517.4 |
190 | 2022-08-22 09:57:14 | diapause | 4 | 161609 | 384 | 10.593 | 15256.2 |
189 | 2022-08-21 10:31:49 | diapause | 2 | 121059 | 4 | 3.123 | 38763.7 |
188 | 2022-08-18 12:23:19 | diapause | 3 | 146162 | 35 | 6.186 | 23627.9 |
187 | 2022-07-20 09:58:36 | diapause | 1 | 82945 | 3 | 1.263 | 65673.0 |
186 | 2022-04-24 17:38:45 | diapause | 1 | 82945 | 3 | 1.266 | 65517.4 |
185 | 2021-12-29 17:09:17 | diapause | 1 | 82945 | 3 | 1.563 | 53067.8 |
184 | 2021-09-12 23:36:37 | diapause | 1 | 82945 | 3 | 1.266 | 65517.4 |
183 | 2021-06-08 19:34:13 | diapause | 1 | 82945 | 3 | 1.390 | 59672.7 |
182 | 2021-05-02 08:59:37 | diapause | 1 | 82945 | 3 | 1.533 | 54106.3 |
181 | 2021-03-09 19:55:15 | diapause | 1 | 82945 | 3 | 1.483 | 55930.5 |
180 | 2020-12-02 05:13:07 | diapause | 1 | 82945 | 3 | 1.250 | 66356.0 |
179 | 2020-11-17 10:32:20 | diapause | 1 | 82945 | 3 | 2.593 | 31988.0 |
178 | 2020-10-22 04:45:25 | diapause | 1 | 82945 | 3 | 1.376 | 60279.8 |
177 | 2020-08-31 06:34:35 | diapause | 1 | 82945 | 3 | 1.296 | 64000.8 |
176 | 2020-08-26 23:35:22 | diapause | 1 | 82945 | 3 | 1.296 | 64000.8 |
175 | 2020-08-02 07:12:15 | diapause | 1 | 82945 | 3 | 1.373 | 60411.5 |
174 | 2020-08-01 16:06:05 | diapause | 1 | 82945 | 3 | 1.533 | 54106.3 |
173 | 2020-05-23 11:35:59 | diapause | 1 | 82945 | 3 | 1.280 | 64800.8 |
172 | 2020-03-29 05:09:19 | diapause | 1 | 82945 | 3 | 1.440 | 57600.7 |
171 | 2020-03-21 09:05:29 | diapause | 1 | 82945 | 3 | 2.643 | 31382.9 |
170 | 2020-03-06 07:26:39 | diapause | 1 | 82945 | 3 | 3.093 | 26817.0 |
169 | 2020-03-02 22:48:23 | diapause | 1 | 82945 | 3 | 1.326 | 62552.8 |
168 | 2020-02-27 22:50:15 | diapause | 1 | 82945 | 3 | 1.546 | 53651.4 |