History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"querying"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
329 | 2024-05-16 02:10:46 | querying | 3 | 146162 | 215 | 21.393 | 6832.2 |
328 | 2024-05-14 16:18:31 | querying | 3 | 146162 | 215 | 23.376 | 6252.7 |
327 | 2024-05-08 16:20:53 | querying | 3 | 146162 | 215 | 12.623 | 11579.0 |
326 | 2024-05-02 12:58:51 | querying | 1 | 82945 | 1 | 1.326 | 62552.8 |
325 | 2024-04-30 19:58:53 | querying | 3 | 146162 | 215 | 12.296 | 11887.0 |
324 | 2024-04-28 12:42:45 | querying | 2 | 121059 | 16 | 7.563 | 16006.7 |
323 | 2024-04-28 12:42:32 | querying | 3 | 146162 | 215 | 7.296 | 20033.2 |
322 | 2024-04-26 08:26:24 | querying | 2 | 121059 | 16 | 3.593 | 33693.0 |
321 | 2024-04-26 08:26:02 | querying | 3 | 146162 | 215 | 12.343 | 11841.7 |
320 | 2024-04-26 08:26:06 | querying | 2 | 121059 | 16 | 3.860 | 31362.4 |
319 | 2024-04-26 08:25:52 | querying | 1 | 82945 | 1 | 2.920 | 28405.8 |
318 | 2024-04-26 08:25:36 | querying | 3 | 146162 | 215 | 9.000 | 16240.2 |
317 | 2024-04-25 22:51:53 | querying | 3 | 146162 | 215 | 12.813 | 11407.3 |
316 | 2024-04-22 17:25:30 | querying | 1 | 82945 | 1 | 1.876 | 44213.8 |
315 | 2024-04-16 01:25:36 | querying | 3 | 146162 | 215 | 17.063 | 8566.0 |
314 | 2024-04-16 01:25:20 | querying | 2 | 121059 | 16 | 10.516 | 11511.9 |
313 | 2024-04-16 00:59:24 | querying | 1 | 82945 | 1 | 1.373 | 60411.5 |
312 | 2024-03-30 00:25:41 | querying | 1 | 82945 | 1 | 3.063 | 27079.7 |
311 | 2024-03-25 10:47:25 | querying | 2 | 121059 | 16 | 5.406 | 22393.5 |
310 | 2024-03-25 10:47:13 | querying | 3 | 146162 | 215 | 7.236 | 20199.3 |
309 | 2024-03-23 07:17:32 | querying | 1 | 82945 | 1 | 1.593 | 52068.4 |
308 | 2024-03-20 00:26:04 | querying | 2 | 121059 | 16 | 4.033 | 30017.1 |
307 | 2024-03-18 22:19:52 | querying | 3 | 146162 | 215 | 30.236 | 4834.0 |
306 | 2024-03-18 07:15:35 | querying | 2 | 121059 | 16 | 3.156 | 38358.4 |
305 | 2024-03-18 04:30:25 | querying | 3 | 146162 | 215 | 8.766 | 16673.7 |
304 | 2024-03-18 02:43:04 | querying | 3 | 146162 | 215 | 11.093 | 13176.1 |
303 | 2024-03-17 01:53:58 | querying | 3 | 146162 | 215 | 15.656 | 9335.8 |
302 | 2024-03-16 11:40:41 | querying | 3 | 146162 | 215 | 18.953 | 7711.8 |
301 | 2024-03-16 11:40:44 | querying | 2 | 121059 | 16 | 7.796 | 15528.3 |
300 | 2024-03-16 11:36:01 | querying | 1 | 82945 | 1 | 3.096 | 26791.0 |
299 | 2024-03-06 05:54:43 | querying | 1 | 82945 | 1 | 4.533 | 18298.0 |
298 | 2024-02-21 20:18:36 | querying | 1 | 82945 | 1 | 1.563 | 53067.8 |
297 | 2024-02-07 07:48:02 | querying | 2 | 121059 | 16 | 3.326 | 36397.8 |
296 | 2024-02-07 07:47:50 | querying | 3 | 146162 | 215 | 7.173 | 20376.7 |
295 | 2024-02-04 23:29:47 | querying | 3 | 146162 | 215 | 7.596 | 19242.0 |
294 | 2024-02-03 11:30:14 | querying | 1 | 82945 | 1 | 1.250 | 66356.0 |
293 | 2024-01-29 08:35:40 | querying | 2 | 121059 | 16 | 3.033 | 39913.9 |
292 | 2024-01-29 08:35:35 | querying | 1 | 82945 | 1 | 1.283 | 64649.3 |
291 | 2024-01-27 19:25:08 | querying | 3 | 146162 | 215 | 7.670 | 19056.3 |
290 | 2024-01-11 15:27:19 | querying | 1 | 82945 | 1 | 1.186 | 69936.8 |
289 | 2024-01-03 20:42:11 | querying | 3 | 146162 | 215 | 7.220 | 20244.0 |
288 | 2023-12-31 12:03:45 | querying | 3 | 146162 | 215 | 7.033 | 20782.3 |
287 | 2023-11-27 02:49:40 | querying | 1 | 82945 | 1 | 1.313 | 63172.1 |
286 | 2023-11-19 12:27:09 | querying | 1 | 82945 | 1 | 1.266 | 65517.4 |
285 | 2023-11-06 22:42:47 | querying | 1 | 82945 | 1 | 1.233 | 67270.9 |
284 | 2023-11-05 20:40:06 | querying | 1 | 82945 | 1 | 1.343 | 61761.0 |
283 | 2023-10-13 16:46:15 | querying | 1 | 82945 | 1 | 1.266 | 65517.4 |
282 | 2023-10-06 21:58:25 | querying | 1 | 82945 | 1 | 1.393 | 59544.1 |
281 | 2023-10-05 13:00:50 | querying | 3 | 146162 | 215 | 6.046 | 24175.0 |
280 | 2023-10-02 22:18:20 | querying | 3 | 146162 | 215 | 6.563 | 22270.6 |
279 | 2023-09-15 06:39:42 | querying | 1 | 82945 | 1 | 1.203 | 68948.5 |
278 | 2023-08-27 15:43:34 | querying | 1 | 82945 | 1 | 1.296 | 64000.8 |
277 | 2023-07-13 12:33:08 | querying | 3 | 146162 | 215 | 6.403 | 22827.1 |
276 | 2023-07-05 09:30:03 | querying | 3 | 146162 | 215 | 6.813 | 21453.4 |
275 | 2023-06-03 13:06:30 | querying | 1 | 82945 | 1 | 1.186 | 69936.8 |
274 | 2023-05-31 18:36:57 | querying | 1 | 82945 | 1 | 1.220 | 67987.7 |
273 | 2023-05-16 19:47:11 | querying | 1 | 82945 | 1 | 1.266 | 65517.4 |
272 | 2023-04-01 12:11:37 | querying | 3 | 146162 | 215 | 7.266 | 20115.9 |
271 | 2023-03-27 14:11:22 | querying | 1 | 82945 | 1 | 1.360 | 60989.0 |
270 | 2023-03-25 03:15:27 | querying | 1 | 82945 | 1 | 1.220 | 67987.7 |
269 | 2023-01-28 17:03:04 | querying | 1 | 82945 | 1 | 1.453 | 57085.3 |
268 | 2023-01-09 02:03:13 | querying | 1 | 82945 | 1 | 1.186 | 69936.8 |
267 | 2023-01-07 17:55:46 | querying | 1 | 82945 | 1 | 1.186 | 69936.8 |
266 | 2023-01-07 15:35:23 | querying | 3 | 146162 | 215 | 5.940 | 24606.4 |
265 | 2022-12-28 18:18:29 | querying | 3 | 146162 | 215 | 5.970 | 24482.7 |
264 | 2022-11-27 09:14:58 | querying | 1 | 82945 | 1 | 2.656 | 31229.3 |
263 | 2022-10-14 13:41:26 | querying | 1 | 82945 | 1 | 1.653 | 50178.5 |
262 | 2022-09-22 16:49:11 | querying | 1 | 82945 | 1 | 1.203 | 68948.5 |
261 | 2022-08-29 08:06:55 | querying | 3 | 146162 | 215 | 8.126 | 17987.0 |
260 | 2022-08-29 07:44:04 | querying | 3 | 146162 | 215 | 7.046 | 20744.0 |
259 | 2022-08-15 02:27:26 | querying | 1 | 82945 | 1 | 1.203 | 68948.5 |
258 | 2022-07-29 10:58:43 | querying | 1 | 82945 | 1 | 1.330 | 62364.7 |
257 | 2022-06-03 09:30:40 | querying | 1 | 82945 | 1 | 1.220 | 67987.7 |
256 | 2022-05-06 06:33:01 | querying | 1 | 82945 | 1 | 1.220 | 67987.7 |
255 | 2022-02-15 09:47:32 | querying | 1 | 82945 | 1 | 1.216 | 68211.3 |
254 | 2022-01-02 09:12:31 | querying | 1 | 82945 | 1 | 1.466 | 56579.1 |
253 | 2021-12-25 18:47:12 | querying | 1 | 82945 | 1 | 1.470 | 56425.2 |
252 | 2021-09-13 10:48:50 | querying | 1 | 82945 | 1 | 1.233 | 67270.9 |
251 | 2021-07-12 02:33:34 | querying | 1 | 82945 | 1 | 1.250 | 66356.0 |
250 | 2021-06-09 08:24:29 | querying | 1 | 82945 | 1 | 1.343 | 61761.0 |
249 | 2021-04-30 15:35:01 | querying | 1 | 82945 | 1 | 1.220 | 67987.7 |
248 | 2021-03-31 00:26:22 | querying | 1 | 82945 | 1 | 1.420 | 58412.0 |
247 | 2021-03-29 23:41:39 | querying | 1 | 82945 | 1 | 1.250 | 66356.0 |
246 | 2021-03-10 08:52:21 | querying | 1 | 82945 | 1 | 1.236 | 67107.6 |
245 | 2021-02-07 19:03:20 | querying | 1 | 82945 | 1 | 1.250 | 66356.0 |
244 | 2021-01-13 14:29:16 | querying | 1 | 82945 | 1 | 1.203 | 68948.5 |
243 | 2020-12-07 00:00:23 | querying | 1 | 82945 | 1 | 1.266 | 65517.4 |
242 | 2020-11-20 09:52:05 | querying | 1 | 82945 | 1 | 1.216 | 68211.3 |
241 | 2020-10-31 11:37:23 | querying | 1 | 82945 | 1 | 1.360 | 60989.0 |
240 | 2020-10-25 17:56:42 | querying | 1 | 82945 | 1 | 1.216 | 68211.3 |
239 | 2020-08-28 12:54:08 | querying | 1 | 82945 | 1 | 1.466 | 56579.1 |
238 | 2020-05-14 14:23:26 | querying | 1 | 82945 | 1 | 1.343 | 61761.0 |
237 | 2020-03-25 12:46:50 | querying | 1 | 82945 | 1 | 1.453 | 57085.3 |
236 | 2020-02-23 10:32:30 | querying | 1 | 82945 | 1 | 1.563 | 53067.8 |
235 | 2020-02-22 15:26:48 | querying | 3 | 146162 | 215 | 7.923 | 18447.8 |
234 | 2020-02-22 14:59:50 | querying | 1 | 82945 | 1 | 1.420 | 58412.0 |
233 | 2020-02-22 12:44:03 | querying | 1 | 82945 | 1 | 3.093 | 26817.0 |
232 | 2020-02-17 21:49:13 | querying | 1 | 82945 | 1 | 1.503 | 55186.3 |
231 | 2020-02-17 08:52:53 | querying | 3 | 146162 | 215 | 9.063 | 16127.3 |
230 | 2020-02-14 04:36:43 | querying | 3 | 146162 | 215 | 19.846 | 7364.8 |