History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"profiles"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
362 | 2024-04-27 06:27:24 | profiles | 1 | 82945 | 6 | 6.876 | 12063.0 |
361 | 2024-04-10 21:35:34 | profiles | 2 | 121059 | 25 | 4.236 | 28578.6 |
360 | 2024-04-08 23:35:04 | profiles | 2 | 121059 | 25 | 13.156 | 9201.8 |
359 | 2024-04-08 10:36:42 | profiles | 2 | 121059 | 25 | 11.643 | 10397.6 |
358 | 2024-04-08 04:57:30 | profiles | 1 | 82945 | 6 | 1.830 | 45325.1 |
357 | 2024-03-31 20:17:10 | profiles | 1 | 82945 | 6 | 1.890 | 43886.2 |
356 | 2024-03-29 20:21:28 | profiles | 1 | 82945 | 6 | 3.906 | 21235.3 |
355 | 2024-03-07 05:59:52 | profiles | 1 | 82945 | 6 | 1.766 | 46967.7 |
354 | 2024-03-06 19:36:40 | profiles | 1 | 82945 | 6 | 3.873 | 21416.2 |
353 | 2024-03-06 17:21:32 | profiles | 2 | 121059 | 25 | 9.953 | 12163.1 |
352 | 2024-03-06 17:21:31 | profiles | 3 | 146162 | 233 | 8.936 | 16356.5 |
351 | 2024-03-05 00:37:09 | profiles | 1 | 82945 | 6 | 2.766 | 29987.3 |
350 | 2024-03-04 01:40:38 | profiles | 2 | 121059 | 25 | 3.766 | 32145.2 |
349 | 2024-03-01 09:36:40 | profiles | 2 | 121059 | 25 | 8.983 | 13476.5 |
348 | 2024-03-01 07:27:07 | profiles | 3 | 146162 | 233 | 7.296 | 20033.2 |
347 | 2024-02-28 18:34:19 | profiles | 3 | 146162 | 233 | 7.563 | 19325.9 |
346 | 2024-02-28 18:33:54 | profiles | 2 | 121059 | 25 | 3.186 | 37997.2 |
345 | 2024-02-28 17:29:54 | profiles | 1 | 82945 | 6 | 1.406 | 58993.6 |
344 | 2024-02-07 22:40:38 | profiles | 3 | 146162 | 233 | 25.410 | 5752.1 |
343 | 2024-02-05 06:05:21 | profiles | 1 | 82945 | 6 | 1.610 | 51518.6 |
342 | 2024-01-31 04:00:26 | profiles | 3 | 146162 | 233 | 6.893 | 21204.4 |
341 | 2024-01-30 23:06:23 | profiles | 3 | 146162 | 233 | 7.893 | 18517.9 |
340 | 2024-01-30 23:06:19 | profiles | 2 | 121059 | 25 | 3.800 | 31857.6 |
339 | 2024-01-30 23:06:15 | profiles | 1 | 82945 | 6 | 1.576 | 52630.1 |
338 | 2024-01-30 17:14:44 | profiles | 1 | 82945 | 6 | 1.500 | 55296.7 |
337 | 2024-01-24 01:11:34 | profiles | 1 | 82945 | 6 | 1.250 | 66356.0 |
336 | 2024-01-22 17:54:27 | profiles | 2 | 121059 | 25 | 3.530 | 34294.3 |
335 | 2024-01-20 00:04:48 | profiles | 1 | 82945 | 6 | 1.343 | 61761.0 |
334 | 2024-01-19 06:23:39 | profiles | 2 | 121059 | 25 | 3.813 | 31749.0 |
333 | 2024-01-11 11:04:46 | profiles | 3 | 146162 | 233 | 6.283 | 23263.1 |
332 | 2023-12-31 05:28:21 | profiles | 1 | 82945 | 6 | 1.283 | 64649.3 |
331 | 2023-12-04 00:31:03 | profiles | 1 | 82945 | 6 | 1.266 | 65517.4 |
330 | 2023-11-15 19:43:31 | profiles | 1 | 82945 | 6 | 1.406 | 58993.6 |
329 | 2023-11-14 14:04:10 | profiles | 1 | 82945 | 6 | 1.266 | 65517.4 |
328 | 2023-11-02 13:40:47 | profiles | 3 | 146162 | 233 | 6.283 | 23263.1 |
327 | 2023-10-25 08:29:15 | profiles | 1 | 82945 | 6 | 1.453 | 57085.3 |
326 | 2023-10-24 22:46:19 | profiles | 3 | 146162 | 233 | 14.846 | 9845.2 |
325 | 2023-10-24 22:46:08 | profiles | 1 | 82945 | 6 | 1.436 | 57761.1 |
324 | 2023-10-19 11:13:15 | profiles | 3 | 146162 | 233 | 7.126 | 20511.1 |
323 | 2023-10-10 02:47:55 | profiles | 1 | 82945 | 6 | 1.410 | 58826.2 |
322 | 2023-10-06 19:26:15 | profiles | 1 | 82945 | 6 | 1.440 | 57600.7 |
321 | 2023-09-29 03:39:37 | profiles | 1 | 82945 | 6 | 1.266 | 65517.4 |
320 | 2023-09-01 20:16:31 | profiles | 1 | 82945 | 6 | 1.423 | 58288.8 |
319 | 2023-07-31 10:59:10 | profiles | 3 | 146162 | 233 | 7.063 | 20694.0 |
318 | 2023-06-23 02:46:08 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
317 | 2023-06-04 04:15:06 | profiles | 1 | 82945 | 6 | 1.280 | 64800.8 |
316 | 2023-04-23 23:09:38 | profiles | 3 | 146162 | 233 | 6.216 | 23513.8 |
315 | 2023-04-07 21:55:44 | profiles | 3 | 146162 | 233 | 6.483 | 22545.4 |
314 | 2023-03-26 02:41:34 | profiles | 1 | 82945 | 6 | 1.263 | 65673.0 |
313 | 2023-03-24 20:39:03 | profiles | 3 | 146162 | 233 | 6.830 | 21400.0 |
312 | 2023-03-07 15:37:39 | profiles | 1 | 82945 | 6 | 1.283 | 64649.3 |
311 | 2023-03-02 01:16:12 | profiles | 3 | 146162 | 233 | 6.580 | 22213.1 |
310 | 2023-01-10 00:15:52 | profiles | 3 | 146162 | 233 | 6.236 | 23438.4 |
309 | 2023-01-09 18:40:04 | profiles | 1 | 82945 | 6 | 1.250 | 66356.0 |
308 | 2023-01-05 21:09:49 | profiles | 3 | 146162 | 233 | 6.576 | 22226.6 |
307 | 2022-12-24 20:52:39 | profiles | 3 | 146162 | 233 | 7.640 | 19131.2 |
306 | 2022-12-14 10:16:24 | profiles | 3 | 146162 | 233 | 6.423 | 22756.0 |
305 | 2022-12-11 07:35:28 | profiles | 3 | 146162 | 233 | 6.186 | 23627.9 |
304 | 2022-12-07 13:51:07 | profiles | 1 | 82945 | 6 | 1.406 | 58993.6 |
303 | 2022-11-25 12:56:13 | profiles | 3 | 146162 | 233 | 6.186 | 23627.9 |
302 | 2022-11-25 06:49:43 | profiles | 1 | 82945 | 6 | 1.453 | 57085.3 |
301 | 2022-11-19 05:12:24 | profiles | 1 | 82945 | 6 | 1.406 | 58993.6 |
300 | 2022-11-08 01:03:22 | profiles | 3 | 146162 | 233 | 7.326 | 19951.1 |
299 | 2022-11-07 10:28:46 | profiles | 1 | 82945 | 6 | 1.283 | 64649.3 |
298 | 2022-10-28 00:27:35 | profiles | 3 | 146162 | 233 | 7.736 | 18893.7 |
297 | 2022-10-06 05:27:51 | profiles | 1 | 82945 | 6 | 1.280 | 64800.8 |
296 | 2022-09-11 03:44:06 | profiles | 3 | 146162 | 233 | 6.826 | 21412.5 |
295 | 2022-09-03 21:19:50 | profiles | 1 | 82945 | 6 | 1.406 | 58993.6 |
294 | 2022-07-29 13:55:53 | profiles | 1 | 82945 | 6 | 1.360 | 60989.0 |
293 | 2022-07-26 11:16:56 | profiles | 1 | 82945 | 6 | 1.360 | 60989.0 |
292 | 2022-07-22 19:23:20 | profiles | 1 | 82945 | 6 | 2.843 | 29175.2 |
291 | 2022-05-22 03:01:58 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
290 | 2022-03-28 12:32:05 | profiles | 1 | 82945 | 6 | 1.720 | 48223.8 |
289 | 2022-02-05 15:03:59 | profiles | 1 | 82945 | 6 | 1.516 | 54713.1 |
288 | 2021-12-14 05:50:11 | profiles | 1 | 82945 | 6 | 1.453 | 57085.3 |
287 | 2021-12-07 19:13:57 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
286 | 2021-10-19 06:07:35 | profiles | 1 | 82945 | 6 | 1.313 | 63172.1 |
285 | 2021-09-26 07:25:26 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
284 | 2021-09-06 23:09:48 | profiles | 1 | 82945 | 6 | 1.280 | 64800.8 |
283 | 2021-07-25 14:30:42 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
282 | 2021-06-20 19:57:00 | profiles | 3 | 146162 | 233 | 6.343 | 23043.0 |
281 | 2021-06-11 19:15:06 | profiles | 1 | 82945 | 6 | 1.546 | 53651.4 |
280 | 2021-06-05 23:15:52 | profiles | 1 | 82945 | 6 | 1.436 | 57761.1 |
279 | 2021-06-02 19:03:49 | profiles | 1 | 82945 | 6 | 1.483 | 55930.5 |
278 | 2021-05-15 18:50:06 | profiles | 1 | 82945 | 6 | 1.450 | 57203.4 |
277 | 2021-05-04 10:09:10 | profiles | 1 | 82945 | 6 | 1.530 | 54212.4 |
276 | 2021-04-24 00:42:55 | profiles | 1 | 82945 | 6 | 1.310 | 63316.8 |
275 | 2021-04-01 06:01:03 | profiles | 3 | 146162 | 233 | 6.580 | 22213.1 |
274 | 2021-03-18 13:55:44 | profiles | 1 | 82945 | 6 | 1.326 | 62552.8 |
273 | 2021-02-28 05:40:43 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
272 | 2021-02-24 18:45:51 | profiles | 1 | 82945 | 6 | 1.470 | 56425.2 |
271 | 2021-02-23 21:18:57 | profiles | 1 | 82945 | 6 | 1.313 | 63172.1 |
270 | 2021-02-21 10:25:15 | profiles | 1 | 82945 | 6 | 1.453 | 57085.3 |
269 | 2021-02-09 22:23:19 | profiles | 3 | 146162 | 233 | 6.736 | 21698.6 |
268 | 2021-01-28 08:59:16 | profiles | 1 | 82945 | 6 | 2.703 | 30686.3 |
267 | 2021-01-16 06:04:36 | profiles | 3 | 146162 | 233 | 6.330 | 23090.4 |
266 | 2020-12-30 19:23:24 | profiles | 1 | 82945 | 6 | 1.313 | 63172.1 |
265 | 2020-11-23 16:27:00 | profiles | 1 | 82945 | 6 | 1.296 | 64000.8 |
264 | 2020-11-16 21:28:57 | profiles | 3 | 146162 | 233 | 7.063 | 20694.0 |
263 | 2020-11-11 13:41:57 | profiles | 1 | 82945 | 6 | 1.310 | 63316.8 |