History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"penality"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
298 | 2024-06-02 18:37:53 | penality | 1 | 82945 | 3 | 5.280 | 15709.3 |
297 | 2024-05-09 12:18:51 | penality | 3 | 146162 | 118 | 10.920 | 13384.8 |
296 | 2024-05-08 06:46:42 | penality | 1 | 82945 | 3 | 1.703 | 48705.2 |
295 | 2024-05-08 06:46:15 | penality | 2 | 121059 | 20 | 4.423 | 27370.3 |
294 | 2024-05-08 06:46:07 | penality | 3 | 146162 | 118 | 9.750 | 14991.0 |
293 | 2024-05-07 07:54:12 | penality | 2 | 121059 | 20 | 3.986 | 30371.0 |
292 | 2024-05-07 07:54:08 | penality | 1 | 82945 | 3 | 2.313 | 35860.4 |
291 | 2024-05-07 07:53:40 | penality | 3 | 146162 | 118 | 9.206 | 15876.8 |
290 | 2024-05-06 20:10:25 | penality | 3 | 146162 | 118 | 18.390 | 7947.9 |
289 | 2024-05-06 10:22:19 | penality | 3 | 146162 | 118 | 10.796 | 13538.5 |
288 | 2024-05-05 21:22:49 | penality | 3 | 146162 | 118 | 10.186 | 14349.3 |
287 | 2024-05-01 21:25:37 | penality | 3 | 146162 | 118 | 8.703 | 16794.4 |
286 | 2024-04-30 02:07:29 | penality | 1 | 82945 | 3 | 1.283 | 64649.3 |
285 | 2024-04-19 16:21:31 | penality | 2 | 121059 | 20 | 14.766 | 8198.5 |
284 | 2024-04-19 13:32:51 | penality | 1 | 82945 | 3 | 1.516 | 54713.1 |
283 | 2024-04-09 21:08:38 | penality | 1 | 82945 | 3 | 3.190 | 26001.6 |
282 | 2024-04-08 10:39:21 | penality | 3 | 146162 | 118 | 26.813 | 5451.2 |
281 | 2024-04-07 17:09:48 | penality | 3 | 146162 | 118 | 21.830 | 6695.5 |
280 | 2024-04-06 09:59:14 | penality | 3 | 146162 | 118 | 20.050 | 7289.9 |
279 | 2024-04-05 14:15:14 | penality | 3 | 146162 | 118 | 15.500 | 9429.8 |
278 | 2024-04-05 02:50:25 | penality | 3 | 146162 | 118 | 16.610 | 8799.6 |
277 | 2024-04-05 02:50:26 | penality | 2 | 121059 | 20 | 4.406 | 27475.9 |
276 | 2024-04-05 02:50:10 | penality | 3 | 146162 | 118 | 14.186 | 10303.3 |
275 | 2024-04-05 02:50:21 | penality | 1 | 82945 | 3 | 1.653 | 50178.5 |
274 | 2024-04-05 02:50:11 | penality | 2 | 121059 | 20 | 4.986 | 24279.8 |
273 | 2024-04-05 02:50:09 | penality | 1 | 82945 | 3 | 1.750 | 47397.1 |
272 | 2024-03-15 01:30:17 | penality | 1 | 82945 | 3 | 1.686 | 49196.3 |
271 | 2024-01-31 02:17:23 | penality | 1 | 82945 | 3 | 1.483 | 55930.5 |
270 | 2024-01-30 11:14:32 | penality | 1 | 82945 | 3 | 1.530 | 54212.4 |
269 | 2024-01-29 20:30:45 | penality | 2 | 121059 | 20 | 4.000 | 30264.8 |
268 | 2024-01-27 04:40:21 | penality | 2 | 121059 | 20 | 3.890 | 31120.6 |
267 | 2024-01-08 09:59:27 | penality | 1 | 82945 | 3 | 1.313 | 63172.1 |
266 | 2023-12-23 15:08:00 | penality | 3 | 146162 | 118 | 7.250 | 20160.3 |
265 | 2023-11-28 18:59:03 | penality | 1 | 82945 | 3 | 1.266 | 65517.4 |
264 | 2023-11-14 11:46:21 | penality | 1 | 82945 | 3 | 1.453 | 57085.3 |
263 | 2023-11-03 21:11:21 | penality | 2 | 121059 | 20 | 3.266 | 37066.4 |
262 | 2023-11-02 00:00:24 | penality | 1 | 82945 | 3 | 1.280 | 64800.8 |
261 | 2023-10-13 08:08:44 | penality | 1 | 82945 | 3 | 1.360 | 60989.0 |
260 | 2023-09-30 12:27:40 | penality | 3 | 146162 | 118 | 6.516 | 22431.2 |
259 | 2023-09-29 06:06:17 | penality | 1 | 82945 | 3 | 1.483 | 55930.5 |
258 | 2023-09-23 06:11:11 | penality | 3 | 146162 | 118 | 8.140 | 17956.0 |
257 | 2023-08-26 10:18:06 | penality | 1 | 82945 | 3 | 1.360 | 60989.0 |
256 | 2023-08-09 10:17:26 | penality | 2 | 121059 | 20 | 3.690 | 32807.3 |
255 | 2023-06-23 21:16:31 | penality | 3 | 146162 | 118 | 6.423 | 22756.0 |
254 | 2023-06-02 07:21:25 | penality | 1 | 82945 | 3 | 1.250 | 66356.0 |
253 | 2023-05-28 23:03:35 | penality | 1 | 82945 | 3 | 1.436 | 57761.1 |
252 | 2023-04-20 02:59:58 | penality | 2 | 121059 | 20 | 3.250 | 37248.9 |
251 | 2023-03-22 09:51:59 | penality | 1 | 82945 | 3 | 1.466 | 56579.1 |
250 | 2023-03-17 10:42:07 | penality | 3 | 146162 | 118 | 6.470 | 22590.7 |
249 | 2023-02-10 13:19:54 | penality | 1 | 82945 | 3 | 1.436 | 57761.1 |
248 | 2023-01-21 01:41:04 | penality | 2 | 121059 | 20 | 5.406 | 22393.5 |
247 | 2023-01-08 21:39:34 | penality | 1 | 82945 | 3 | 1.466 | 56579.1 |
246 | 2022-12-23 17:07:56 | penality | 3 | 146162 | 118 | 6.343 | 23043.0 |
245 | 2022-12-18 16:13:42 | penality | 3 | 146162 | 118 | 7.436 | 19656.0 |
244 | 2022-11-25 22:10:47 | penality | 1 | 82945 | 3 | 1.313 | 63172.1 |
243 | 2022-11-20 04:08:14 | penality | 3 | 146162 | 118 | 7.593 | 19249.6 |
242 | 2022-11-06 20:32:42 | penality | 3 | 146162 | 118 | 7.436 | 19656.0 |
241 | 2022-10-31 16:46:10 | penality | 2 | 121059 | 20 | 3.406 | 35542.9 |
240 | 2022-10-29 20:04:02 | penality | 3 | 146162 | 118 | 6.873 | 21266.1 |
239 | 2022-10-13 01:31:40 | penality | 1 | 82945 | 3 | 1.296 | 64000.8 |
238 | 2022-10-06 20:03:31 | penality | 1 | 82945 | 3 | 1.296 | 64000.8 |
237 | 2022-10-02 09:35:01 | penality | 1 | 82945 | 3 | 1.263 | 65673.0 |
236 | 2022-09-13 09:19:29 | penality | 3 | 146162 | 118 | 6.406 | 22816.4 |
235 | 2022-08-15 05:05:25 | penality | 3 | 146162 | 118 | 6.516 | 22431.2 |
234 | 2022-06-11 14:00:41 | penality | 1 | 82945 | 3 | 1.326 | 62552.8 |
233 | 2022-06-07 23:14:31 | penality | 1 | 82945 | 3 | 1.343 | 61761.0 |
232 | 2022-06-02 11:51:12 | penality | 2 | 121059 | 20 | 3.250 | 37248.9 |
231 | 2022-05-31 06:43:37 | penality | 2 | 121059 | 20 | 3.250 | 37248.9 |
230 | 2022-05-23 11:02:36 | penality | 1 | 82945 | 3 | 1.326 | 62552.8 |
229 | 2022-05-16 12:17:41 | penality | 1 | 82945 | 3 | 1.970 | 42104.1 |
228 | 2022-03-13 14:44:16 | penality | 3 | 146162 | 118 | 6.563 | 22270.6 |
227 | 2022-02-08 02:08:52 | penality | 2 | 121059 | 20 | 3.250 | 37248.9 |
226 | 2022-02-07 06:44:54 | penality | 1 | 82945 | 3 | 1.280 | 64800.8 |
225 | 2022-01-31 12:12:09 | penality | 1 | 82945 | 3 | 1.453 | 57085.3 |
224 | 2021-12-15 11:22:30 | penality | 1 | 82945 | 3 | 1.436 | 57761.1 |
223 | 2021-10-14 08:02:54 | penality | 1 | 82945 | 3 | 1.280 | 64800.8 |
222 | 2021-07-13 06:43:23 | penality | 1 | 82945 | 3 | 1.296 | 64000.8 |
221 | 2021-06-11 01:51:06 | penality | 3 | 146162 | 118 | 7.093 | 20606.5 |
220 | 2021-06-11 01:28:02 | penality | 1 | 82945 | 3 | 1.313 | 63172.1 |
219 | 2021-06-06 09:56:15 | penality | 3 | 146162 | 118 | 7.186 | 20339.8 |
218 | 2021-05-26 17:22:26 | penality | 1 | 82945 | 3 | 1.453 | 57085.3 |
217 | 2021-05-12 09:00:12 | penality | 3 | 146162 | 118 | 7.813 | 18707.5 |
216 | 2021-04-11 04:00:52 | penality | 3 | 146162 | 118 | 9.110 | 16044.1 |
215 | 2021-04-09 19:08:59 | penality | 1 | 82945 | 3 | 1.596 | 51970.6 |
214 | 2021-04-08 04:05:01 | penality | 1 | 82945 | 3 | 1.360 | 60989.0 |
213 | 2021-03-30 05:32:39 | penality | 1 | 82945 | 3 | 1.280 | 64800.8 |
212 | 2021-03-04 02:04:54 | penality | 1 | 82945 | 3 | 1.436 | 57761.1 |
211 | 2021-02-23 09:00:11 | penality | 2 | 121059 | 20 | 4.483 | 27004.0 |
210 | 2021-02-21 08:43:07 | penality | 3 | 146162 | 118 | 6.783 | 21548.3 |
209 | 2020-12-27 20:19:03 | penality | 1 | 82945 | 3 | 1.313 | 63172.1 |
208 | 2020-11-04 23:24:46 | penality | 2 | 121059 | 20 | 3.313 | 36540.6 |
207 | 2020-11-03 06:56:26 | penality | 1 | 82945 | 3 | 1.360 | 60989.0 |
206 | 2020-10-20 01:18:29 | penality | 1 | 82945 | 3 | 1.483 | 55930.5 |
205 | 2020-09-24 05:51:41 | penality | 1 | 82945 | 3 | 1.280 | 64800.8 |
204 | 2020-08-21 14:14:43 | penality | 1 | 82945 | 3 | 1.296 | 64000.8 |
203 | 2020-06-09 21:43:59 | penality | 1 | 82945 | 3 | 1.406 | 58993.6 |
202 | 2020-03-22 12:06:05 | penality | 1 | 82945 | 3 | 1.533 | 54106.3 |
201 | 2020-03-05 11:51:26 | penality | 1 | 82945 | 3 | 1.470 | 56425.2 |
200 | 2020-02-27 11:48:31 | penality | 1 | 82945 | 3 | 1.673 | 49578.6 |
199 | 2020-02-24 19:46:06 | penality | 3 | 146162 | 118 | 8.283 | 17646.0 |