History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"openings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
289 | 2024-04-16 00:30:12 | openings | 2 | 121059 | 6 | 6.970 | 17368.6 |
288 | 2024-04-16 00:29:43 | openings | 1 | 82945 | 2 | 1.420 | 58412.0 |
287 | 2024-04-09 02:53:49 | openings | 2 | 121059 | 6 | 3.610 | 33534.3 |
286 | 2024-04-09 02:53:39 | openings | 1 | 82945 | 2 | 2.716 | 30539.4 |
285 | 2024-04-09 02:53:26 | openings | 3 | 146162 | 156 | 8.516 | 17163.2 |
284 | 2024-04-06 17:13:58 | openings | 2 | 121059 | 6 | 14.673 | 8250.5 |
283 | 2024-04-06 17:13:50 | openings | 1 | 82945 | 2 | 5.483 | 15127.7 |
282 | 2024-04-06 16:24:44 | openings | 3 | 146162 | 156 | 12.906 | 11325.1 |
281 | 2024-04-05 10:14:59 | openings | 3 | 146162 | 156 | 9.313 | 15694.4 |
280 | 2024-04-05 10:14:54 | openings | 1 | 82945 | 2 | 5.046 | 16437.8 |
279 | 2024-03-30 06:12:28 | openings | 1 | 82945 | 2 | 3.186 | 26034.2 |
278 | 2024-03-28 16:07:05 | openings | 1 | 82945 | 2 | 1.530 | 54212.4 |
277 | 2024-03-25 07:39:51 | openings | 2 | 121059 | 6 | 3.126 | 38726.5 |
276 | 2024-03-25 07:39:20 | openings | 3 | 146162 | 156 | 6.436 | 22710.1 |
275 | 2024-03-25 04:44:10 | openings | 1 | 82945 | 2 | 1.296 | 64000.8 |
274 | 2024-03-22 06:51:46 | openings | 2 | 121059 | 6 | 4.093 | 29577.1 |
273 | 2024-03-22 06:51:30 | openings | 3 | 146162 | 156 | 8.296 | 17618.4 |
272 | 2024-03-21 22:16:19 | openings | 3 | 146162 | 156 | 10.343 | 14131.5 |
271 | 2024-03-08 23:37:10 | openings | 2 | 121059 | 6 | 3.640 | 33258.0 |
270 | 2024-03-08 23:37:09 | openings | 1 | 82945 | 2 | 1.436 | 57761.1 |
269 | 2024-03-08 23:36:57 | openings | 3 | 146162 | 156 | 7.420 | 19698.4 |
268 | 2024-03-06 09:15:03 | openings | 2 | 121059 | 6 | 12.626 | 9588.1 |
267 | 2024-03-06 09:14:44 | openings | 1 | 82945 | 2 | 3.376 | 24569.0 |
266 | 2024-03-06 00:41:59 | openings | 3 | 146162 | 156 | 15.970 | 9152.3 |
265 | 2024-03-05 20:12:20 | openings | 3 | 146162 | 156 | 20.003 | 7307.0 |
264 | 2024-03-05 20:12:19 | openings | 2 | 121059 | 6 | 4.263 | 28397.6 |
263 | 2024-03-05 19:48:14 | openings | 1 | 82945 | 2 | 1.483 | 55930.5 |
262 | 2024-01-31 05:33:23 | openings | 3 | 146162 | 156 | 15.533 | 9409.8 |
261 | 2024-01-30 07:53:01 | openings | 2 | 121059 | 6 | 7.376 | 16412.6 |
260 | 2024-01-30 07:52:49 | openings | 3 | 146162 | 156 | 7.686 | 19016.7 |
259 | 2024-01-30 05:41:35 | openings | 2 | 121059 | 6 | 3.640 | 33258.0 |
258 | 2024-01-30 05:41:31 | openings | 3 | 146162 | 156 | 6.970 | 20970.2 |
257 | 2024-01-30 05:41:27 | openings | 1 | 82945 | 2 | 1.453 | 57085.3 |
256 | 2024-01-25 03:14:10 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
255 | 2024-01-19 08:16:37 | openings | 2 | 121059 | 6 | 3.500 | 34588.3 |
254 | 2023-12-10 06:07:48 | openings | 1 | 82945 | 2 | 1.440 | 57600.7 |
253 | 2023-11-30 21:20:40 | openings | 3 | 146162 | 156 | 7.420 | 19698.4 |
252 | 2023-11-29 00:34:27 | openings | 1 | 82945 | 2 | 1.266 | 65517.4 |
251 | 2023-11-26 14:53:01 | openings | 1 | 82945 | 2 | 1.390 | 59672.7 |
250 | 2023-11-22 14:09:53 | openings | 1 | 82945 | 2 | 1.310 | 63316.8 |
249 | 2023-11-21 05:00:18 | openings | 1 | 82945 | 2 | 1.406 | 58993.6 |
248 | 2023-11-06 19:49:22 | openings | 1 | 82945 | 2 | 1.406 | 58993.6 |
247 | 2023-11-06 11:19:06 | openings | 1 | 82945 | 2 | 1.360 | 60989.0 |
246 | 2023-10-29 22:19:43 | openings | 2 | 121059 | 6 | 3.190 | 37949.5 |
245 | 2023-10-16 07:16:10 | openings | 1 | 82945 | 2 | 1.423 | 58288.8 |
244 | 2023-10-07 00:59:13 | openings | 1 | 82945 | 2 | 1.233 | 67270.9 |
243 | 2023-09-06 15:57:39 | openings | 1 | 82945 | 2 | 1.266 | 65517.4 |
242 | 2023-08-29 13:47:07 | openings | 3 | 146162 | 156 | 7.300 | 20022.2 |
241 | 2023-08-07 02:59:18 | openings | 1 | 82945 | 2 | 1.453 | 57085.3 |
240 | 2023-08-06 18:14:24 | openings | 2 | 121059 | 6 | 3.170 | 38189.0 |
239 | 2023-07-03 00:36:07 | openings | 1 | 82945 | 2 | 1.360 | 60989.0 |
238 | 2023-06-09 21:20:24 | openings | 1 | 82945 | 2 | 1.233 | 67270.9 |
237 | 2023-05-16 04:29:12 | openings | 3 | 146162 | 156 | 6.156 | 23743.0 |
236 | 2023-04-17 11:17:15 | openings | 2 | 121059 | 6 | 3.343 | 36212.7 |
235 | 2023-04-11 04:47:27 | openings | 1 | 82945 | 2 | 1.236 | 67107.6 |
234 | 2023-03-29 15:38:59 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
233 | 2023-02-22 02:26:53 | openings | 3 | 146162 | 156 | 6.076 | 24055.6 |
232 | 2023-01-22 13:15:04 | openings | 2 | 121059 | 6 | 3.533 | 34265.2 |
231 | 2023-01-12 13:25:57 | openings | 1 | 82945 | 2 | 1.356 | 61168.9 |
230 | 2022-12-19 16:43:03 | openings | 1 | 82945 | 2 | 1.233 | 67270.9 |
229 | 2022-12-12 06:47:48 | openings | 1 | 82945 | 2 | 1.733 | 47862.1 |
228 | 2022-12-02 10:55:25 | openings | 3 | 146162 | 156 | 7.140 | 20470.9 |
227 | 2022-11-02 07:47:00 | openings | 2 | 121059 | 6 | 3.423 | 35366.3 |
226 | 2022-10-30 18:16:42 | openings | 1 | 82945 | 2 | 1.296 | 64000.8 |
225 | 2022-09-19 16:46:35 | openings | 1 | 82945 | 2 | 1.360 | 60989.0 |
224 | 2022-08-23 09:56:01 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
223 | 2022-08-14 17:41:56 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
222 | 2022-08-08 19:00:40 | openings | 1 | 82945 | 2 | 1.266 | 65517.4 |
221 | 2022-07-29 01:55:05 | openings | 1 | 82945 | 2 | 1.233 | 67270.9 |
220 | 2022-07-09 18:11:21 | openings | 3 | 146162 | 156 | 6.330 | 23090.4 |
219 | 2022-06-19 12:01:25 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
218 | 2022-06-01 01:50:39 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
217 | 2022-05-24 02:55:50 | openings | 2 | 121059 | 6 | 3.376 | 35858.7 |
216 | 2022-04-25 15:08:14 | openings | 1 | 82945 | 2 | 1.876 | 44213.8 |
215 | 2022-04-07 14:05:40 | openings | 1 | 82945 | 2 | 1.593 | 52068.4 |
214 | 2022-02-26 21:08:04 | openings | 1 | 82945 | 2 | 1.280 | 64800.8 |
213 | 2022-02-20 21:29:32 | openings | 3 | 146162 | 156 | 7.750 | 18859.6 |
212 | 2021-12-15 21:24:19 | openings | 1 | 82945 | 2 | 2.750 | 30161.8 |
211 | 2021-12-13 23:36:11 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
210 | 2021-12-13 18:13:21 | openings | 1 | 82945 | 2 | 1.296 | 64000.8 |
209 | 2021-08-27 19:57:54 | openings | 1 | 82945 | 2 | 1.440 | 57600.7 |
208 | 2021-07-25 20:37:11 | openings | 1 | 82945 | 2 | 1.233 | 67270.9 |
207 | 2021-06-01 21:30:37 | openings | 1 | 82945 | 2 | 1.406 | 58993.6 |
206 | 2021-05-20 11:44:03 | openings | 1 | 82945 | 2 | 1.686 | 49196.3 |
205 | 2021-05-15 10:53:48 | openings | 1 | 82945 | 2 | 1.263 | 65673.0 |
204 | 2021-04-14 14:07:39 | openings | 1 | 82945 | 2 | 1.420 | 58412.0 |
203 | 2021-03-18 06:42:38 | openings | 1 | 82945 | 2 | 1.533 | 54106.3 |
202 | 2021-02-17 21:25:08 | openings | 1 | 82945 | 2 | 1.280 | 64800.8 |
201 | 2020-12-30 10:30:13 | openings | 1 | 82945 | 2 | 1.283 | 64649.3 |
200 | 2020-12-02 16:22:19 | openings | 1 | 82945 | 2 | 1.376 | 60279.8 |
199 | 2020-11-08 15:30:42 | openings | 1 | 82945 | 2 | 1.436 | 57761.1 |
198 | 2020-10-16 22:21:36 | openings | 1 | 82945 | 2 | 1.250 | 66356.0 |
197 | 2020-10-09 06:21:05 | openings | 1 | 82945 | 2 | 1.233 | 67270.9 |
196 | 2020-10-09 05:51:06 | openings | 1 | 82945 | 2 | 1.313 | 63172.1 |
195 | 2020-09-11 13:53:42 | openings | 1 | 82945 | 2 | 1.263 | 65673.0 |
194 | 2020-08-27 15:06:37 | openings | 1 | 82945 | 2 | 1.360 | 60989.0 |
193 | 2020-08-25 00:47:41 | openings | 1 | 82945 | 2 | 1.343 | 61761.0 |
192 | 2020-08-03 11:57:01 | openings | 1 | 82945 | 2 | 1.376 | 60279.8 |
191 | 2020-07-21 19:58:40 | openings | 1 | 82945 | 2 | 1.593 | 52068.4 |
190 | 2020-07-21 16:18:52 | openings | 1 | 82945 | 2 | 1.343 | 61761.0 |