History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sickness"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
359 | 2024-04-05 07:07:25 | sickness | 2 | 121059 | 29 | 3.860 | 31362.4 |
358 | 2024-04-05 07:07:25 | sickness | 1 | 82945 | 2 | 1.530 | 54212.4 |
357 | 2024-03-29 06:41:31 | sickness | 1 | 82945 | 2 | 2.266 | 36604.1 |
356 | 2024-03-08 23:23:01 | sickness | 2 | 121059 | 29 | 5.266 | 22988.8 |
355 | 2024-03-08 23:22:44 | sickness | 3 | 146162 | 250 | 8.280 | 17652.4 |
354 | 2024-03-07 23:07:16 | sickness | 2 | 121059 | 29 | 8.190 | 14781.3 |
353 | 2024-03-07 18:08:34 | sickness | 2 | 121059 | 29 | 3.966 | 30524.2 |
352 | 2024-03-07 17:30:09 | sickness | 3 | 146162 | 250 | 8.453 | 17291.1 |
351 | 2024-03-07 15:04:33 | sickness | 3 | 146162 | 250 | 7.610 | 19206.6 |
350 | 2024-03-07 13:50:37 | sickness | 1 | 82945 | 2 | 1.406 | 58993.6 |
349 | 2024-02-28 06:19:22 | sickness | 1 | 82945 | 2 | 1.470 | 56425.2 |
348 | 2024-02-20 13:46:30 | sickness | 1 | 82945 | 2 | 3.250 | 25521.5 |
347 | 2024-02-06 22:16:06 | sickness | 2 | 121059 | 29 | 5.846 | 20708.0 |
346 | 2024-01-31 11:42:35 | sickness | 2 | 121059 | 29 | 3.530 | 34294.3 |
345 | 2024-01-31 03:12:15 | sickness | 3 | 146162 | 250 | 11.030 | 13251.3 |
344 | 2024-01-30 22:04:59 | sickness | 2 | 121059 | 29 | 4.076 | 29700.4 |
343 | 2024-01-30 21:59:39 | sickness | 3 | 146162 | 250 | 8.140 | 17956.0 |
342 | 2024-01-29 03:04:50 | sickness | 1 | 82945 | 2 | 1.500 | 55296.7 |
341 | 2024-01-14 02:56:36 | sickness | 3 | 146162 | 250 | 7.250 | 20160.3 |
340 | 2024-01-14 02:56:35 | sickness | 2 | 121059 | 29 | 3.576 | 33853.2 |
339 | 2024-01-12 21:33:11 | sickness | 1 | 82945 | 2 | 1.280 | 64800.8 |
338 | 2023-12-13 22:35:04 | sickness | 1 | 82945 | 2 | 1.330 | 62364.7 |
337 | 2023-11-21 12:59:49 | sickness | 1 | 82945 | 2 | 1.500 | 55296.7 |
336 | 2023-11-18 18:27:32 | sickness | 1 | 82945 | 2 | 1.280 | 64800.8 |
335 | 2023-11-17 22:23:57 | sickness | 1 | 82945 | 2 | 1.440 | 57600.7 |
334 | 2023-11-06 19:37:45 | sickness | 1 | 82945 | 2 | 1.423 | 58288.8 |
333 | 2023-10-31 04:43:41 | sickness | 1 | 82945 | 2 | 1.563 | 53067.8 |
332 | 2023-10-15 09:19:29 | sickness | 1 | 82945 | 2 | 1.406 | 58993.6 |
331 | 2023-09-29 18:43:57 | sickness | 1 | 82945 | 2 | 1.516 | 54713.1 |
330 | 2023-08-28 13:29:06 | sickness | 1 | 82945 | 2 | 1.313 | 63172.1 |
329 | 2023-06-18 04:05:11 | sickness | 1 | 82945 | 2 | 1.313 | 63172.1 |
328 | 2023-06-14 21:58:00 | sickness | 1 | 82945 | 2 | 2.890 | 28700.7 |
327 | 2023-06-03 04:07:55 | sickness | 1 | 82945 | 2 | 1.280 | 64800.8 |
326 | 2023-03-27 12:22:33 | sickness | 1 | 82945 | 2 | 1.266 | 65517.4 |
325 | 2023-02-20 06:40:02 | sickness | 1 | 82945 | 2 | 1.530 | 54212.4 |
324 | 2023-01-09 09:31:28 | sickness | 1 | 82945 | 2 | 1.263 | 65673.0 |
323 | 2022-10-23 10:33:54 | sickness | 1 | 82945 | 2 | 1.283 | 64649.3 |
322 | 2022-10-13 11:04:39 | sickness | 1 | 82945 | 2 | 1.436 | 57761.1 |
321 | 2022-06-18 09:03:28 | sickness | 1 | 82945 | 2 | 1.283 | 64649.3 |
320 | 2022-06-02 22:43:55 | sickness | 1 | 82945 | 2 | 1.296 | 64000.8 |
319 | 2022-05-31 16:16:26 | sickness | 1 | 82945 | 2 | 1.280 | 64800.8 |
318 | 2022-02-17 04:58:51 | sickness | 1 | 82945 | 2 | 1.436 | 57761.1 |
317 | 2022-01-17 19:57:06 | sickness | 1 | 82945 | 2 | 1.326 | 62552.8 |
316 | 2021-11-17 17:18:47 | sickness | 1 | 82945 | 2 | 1.546 | 53651.4 |
315 | 2021-10-26 17:13:57 | sickness | 1 | 82945 | 2 | 1.483 | 55930.5 |
314 | 2021-10-19 22:45:46 | sickness | 1 | 82945 | 2 | 1.423 | 58288.8 |
313 | 2021-07-26 11:58:35 | sickness | 1 | 82945 | 2 | 1.313 | 63172.1 |
312 | 2021-07-23 13:28:14 | sickness | 1 | 82945 | 2 | 1.343 | 61761.0 |
311 | 2021-05-17 05:18:46 | sickness | 1 | 82945 | 2 | 1.406 | 58993.6 |
310 | 2021-04-17 15:29:31 | sickness | 1 | 82945 | 2 | 1.470 | 56425.2 |
309 | 2021-04-17 03:42:16 | sickness | 1 | 82945 | 2 | 2.910 | 28503.4 |
308 | 2021-03-21 08:12:35 | sickness | 1 | 82945 | 2 | 2.346 | 35355.9 |
307 | 2021-03-20 00:56:30 | sickness | 1 | 82945 | 2 | 1.610 | 51518.6 |
306 | 2021-02-22 19:17:15 | sickness | 1 | 82945 | 2 | 1.310 | 63316.8 |
305 | 2021-01-03 00:12:50 | sickness | 1 | 82945 | 2 | 1.453 | 57085.3 |
304 | 2021-01-01 08:31:25 | sickness | 1 | 82945 | 2 | 1.296 | 64000.8 |
303 | 2020-12-06 04:59:32 | sickness | 1 | 82945 | 2 | 1.313 | 63172.1 |
302 | 2020-11-07 22:23:58 | sickness | 1 | 82945 | 2 | 1.406 | 58993.6 |
301 | 2020-10-17 15:47:37 | sickness | 1 | 82945 | 2 | 1.313 | 63172.1 |
300 | 2020-09-24 21:06:53 | sickness | 1 | 82945 | 2 | 1.326 | 62552.8 |
299 | 2020-07-28 06:21:22 | sickness | 1 | 82945 | 2 | 1.576 | 52630.1 |
298 | 2020-03-28 14:45:29 | sickness | 1 | 82945 | 2 | 1.610 | 51518.6 |
297 | 2020-03-23 08:29:57 | sickness | 1 | 82945 | 2 | 1.453 | 57085.3 |
296 | 2020-02-28 11:16:51 | sickness | 1 | 82945 | 2 | 4.876 | 17010.9 |
295 | 2020-02-25 03:06:39 | sickness | 1 | 82945 | 2 | 1.610 | 51518.6 |
294 | 2020-02-24 01:50:50 | sickness | 1 | 82945 | 2 | 3.123 | 26559.4 |
293 | 2020-02-17 20:26:47 | sickness | 1 | 82945 | 2 | 1.610 | 51518.6 |
292 | 2020-02-14 18:26:57 | sickness | 1 | 82945 | 2 | 3.393 | 24445.9 |
291 | 2020-02-09 10:15:45 | sickness | 1 | 82945 | 2 | 3.360 | 24686.0 |
290 | 2020-02-05 03:14:29 | sickness | 1 | 82945 | 2 | 1.436 | 57761.1 |
289 | 2020-02-02 23:30:54 | sickness | 1 | 82945 | 2 | 3.063 | 27079.7 |
288 | 2020-01-28 00:58:07 | sickness | 1 | 82945 | 2 | 3.296 | 25165.4 |
287 | 2020-01-23 18:25:11 | sickness | 1 | 82945 | 2 | 1.593 | 52068.4 |
286 | 2020-01-21 04:31:16 | sickness | 1 | 82945 | 2 | 4.906 | 16906.8 |
285 | 2020-01-14 23:18:19 | sickness | 1 | 82945 | 2 | 1.500 | 55296.7 |
284 | 2020-01-06 18:52:49 | sickness | 1 | 82945 | 2 | 1.720 | 48223.8 |
283 | 2020-01-06 08:32:06 | sickness | 1 | 82945 | 2 | 1.580 | 52496.8 |
282 | 2019-12-30 20:39:11 | sickness | 1 | 82945 | 2 | 1.533 | 54106.3 |
281 | 2019-12-29 00:31:04 | sickness | 1 | 82945 | 2 | 1.596 | 51970.6 |
280 | 2019-11-23 07:48:48 | sickness | 1 | 82945 | 2 | 1.486 | 55817.6 |
279 | 2019-08-21 08:57:22 | sickness | 1 | 82945 | 2 | 1.386 | 59844.9 |
278 | 2019-06-15 08:03:15 | sickness | 3 | 146162 | 250 | 6.880 | 21244.5 |
277 | 2019-05-18 12:40:28 | sickness | 1 | 82945 | 2 | 1.443 | 57480.9 |
276 | 2019-02-28 20:45:50 | sickness | 1 | 82945 | 2 | 1.286 | 64498.4 |
275 | 2019-02-13 13:44:38 | sickness | 1 | 82945 | 2 | 1.520 | 54569.1 |
274 | 2019-02-06 00:01:32 | sickness | 1 | 82945 | 2 | 1.260 | 65829.4 |
273 | 2019-02-03 03:21:15 | sickness | 1 | 82945 | 2 | 2.800 | 29623.2 |
272 | 2019-01-13 16:42:10 | sickness | 1 | 82945 | 2 | 1.243 | 66729.7 |
271 | 2018-10-24 01:53:11 | sickness | 1 | 82945 | 2 | 1.256 | 66039.0 |
270 | 2018-09-24 22:49:31 | sickness | 1 | 82945 | 2 | 1.496 | 55444.5 |
269 | 2018-07-22 22:02:31 | sickness | 1 | 82945 | 2 | 2.716 | 30539.4 |
268 | 2018-07-15 16:23:43 | sickness | 1 | 82945 | 2 | 1.813 | 45750.1 |
267 | 2018-07-08 00:33:45 | sickness | 1 | 82945 | 2 | 1.533 | 54106.3 |
266 | 2018-07-04 20:56:33 | sickness | 1 | 82945 | 2 | 1.236 | 67107.6 |
265 | 2018-06-19 19:45:42 | sickness | 1 | 82945 | 2 | 1.356 | 61168.9 |
264 | 2018-05-29 06:03:50 | sickness | 1 | 82945 | 2 | 1.300 | 63803.8 |
263 | 2018-05-27 21:38:21 | sickness | 1 | 82945 | 2 | 1.306 | 63510.7 |
262 | 2018-05-21 17:21:19 | sickness | 1 | 82945 | 2 | 1.320 | 62837.1 |
261 | 2018-05-21 17:10:18 | sickness | 1 | 82945 | 2 | 1.406 | 58993.6 |
260 | 2018-05-20 13:08:44 | sickness | 1 | 82945 | 2 | 1.343 | 61761.0 |