History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"compote"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
420 | 2024-05-12 12:08:24 | compote | 3 | 134027 | 246 | 23.266 | 5760.6 |
419 | 2024-05-11 22:33:06 | compote | 2 | 107671 | 45 | 6.953 | 15485.5 |
418 | 2024-05-11 19:30:10 | compote | 3 | 134027 | 246 | 11.766 | 11391.0 |
417 | 2024-05-11 16:10:02 | compote | 1 | 69583 | 6 | 4.406 | 15792.8 |
416 | 2024-05-11 16:09:32 | compote | 3 | 134027 | 246 | 16.203 | 8271.7 |
415 | 2024-05-11 16:09:33 | compote | 2 | 107671 | 45 | 5.470 | 19683.9 |
414 | 2024-05-11 16:09:26 | compote | 1 | 69583 | 6 | 2.013 | 34566.8 |
413 | 2024-05-11 13:01:00 | compote | 1 | 69583 | 6 | 2.970 | 23428.6 |
412 | 2024-05-02 20:06:57 | compote | 1 | 69583 | 6 | 1.360 | 51164.0 |
411 | 2024-04-27 04:58:48 | compote | 1 | 69583 | 6 | 1.783 | 39025.8 |
410 | 2024-04-20 15:15:33 | compote | 2 | 107671 | 45 | 8.783 | 12259.0 |
409 | 2024-04-13 18:22:12 | compote | 3 | 134027 | 246 | 18.530 | 7233.0 |
408 | 2024-04-13 09:16:33 | compote | 3 | 134027 | 246 | 10.436 | 12842.8 |
407 | 2024-04-11 12:16:32 | compote | 2 | 107671 | 45 | 3.563 | 30219.2 |
406 | 2024-04-11 12:15:47 | compote | 3 | 134027 | 246 | 6.203 | 21606.8 |
405 | 2024-04-10 06:09:55 | compote | 2 | 107671 | 45 | 3.656 | 29450.5 |
404 | 2024-04-09 22:37:57 | compote | 3 | 134027 | 246 | 14.720 | 9105.1 |
403 | 2024-04-08 22:01:40 | compote | 2 | 107671 | 45 | 10.296 | 10457.6 |
402 | 2024-04-08 22:01:38 | compote | 3 | 134027 | 246 | 8.313 | 16122.6 |
401 | 2024-04-08 21:56:20 | compote | 1 | 69583 | 6 | 2.123 | 32775.8 |
400 | 2024-03-19 20:36:21 | compote | 1 | 69583 | 6 | 1.110 | 62687.4 |
399 | 2024-03-12 07:12:42 | compote | 2 | 107671 | 45 | 3.623 | 29718.7 |
398 | 2024-03-12 07:11:39 | compote | 3 | 134027 | 246 | 9.623 | 13927.8 |
397 | 2024-03-09 19:27:58 | compote | 2 | 107671 | 45 | 9.486 | 11350.5 |
396 | 2024-03-09 19:27:58 | compote | 3 | 134027 | 246 | 8.143 | 16459.2 |
395 | 2024-03-09 04:13:19 | compote | 1 | 69583 | 6 | 1.220 | 57035.2 |
394 | 2024-03-09 04:12:16 | compote | 2 | 107671 | 45 | 7.500 | 14356.1 |
393 | 2024-03-09 04:12:16 | compote | 3 | 134027 | 246 | 7.283 | 18402.7 |
392 | 2024-03-09 04:11:11 | compote | 1 | 69583 | 6 | 1.283 | 54234.6 |
391 | 2024-03-07 13:10:37 | compote | 1 | 69583 | 6 | 1.283 | 54234.6 |
390 | 2024-02-08 09:12:27 | compote | 2 | 107671 | 45 | 4.016 | 26810.5 |
389 | 2024-02-08 09:11:22 | compote | 3 | 134027 | 246 | 14.296 | 9375.1 |
388 | 2024-02-08 03:47:45 | compote | 3 | 134027 | 246 | 8.046 | 16657.6 |
387 | 2024-02-08 03:47:46 | compote | 2 | 107671 | 45 | 3.843 | 28017.4 |
386 | 2024-02-08 03:47:37 | compote | 1 | 69583 | 6 | 1.250 | 55666.4 |
385 | 2024-01-12 10:06:20 | compote | 1 | 69583 | 6 | 1.173 | 59320.5 |
384 | 2024-01-09 02:57:40 | compote | 1 | 69583 | 6 | 1.126 | 61796.6 |
383 | 2023-12-16 08:14:03 | compote | 2 | 107671 | 45 | 3.533 | 30475.8 |
382 | 2023-12-10 12:56:26 | compote | 3 | 134027 | 246 | 6.063 | 22105.7 |
381 | 2023-12-10 12:56:27 | compote | 2 | 107671 | 45 | 3.203 | 33615.7 |
380 | 2023-12-08 23:51:49 | compote | 1 | 69583 | 6 | 1.296 | 53690.6 |
379 | 2023-12-03 14:50:55 | compote | 3 | 134027 | 246 | 6.936 | 19323.4 |
378 | 2023-12-03 14:50:57 | compote | 2 | 107671 | 45 | 4.330 | 24866.3 |
377 | 2023-11-26 21:06:31 | compote | 3 | 134027 | 246 | 11.000 | 12184.3 |
376 | 2023-11-26 21:06:36 | compote | 2 | 107671 | 45 | 4.890 | 22018.6 |
375 | 2023-11-11 01:30:24 | compote | 1 | 69583 | 6 | 1.250 | 55666.4 |
374 | 2023-11-10 02:13:46 | compote | 1 | 69583 | 6 | 1.126 | 61796.6 |
373 | 2023-11-06 21:44:34 | compote | 1 | 69583 | 6 | 1.190 | 58473.1 |
372 | 2023-10-27 23:44:59 | compote | 1 | 69583 | 6 | 1.330 | 52318.0 |
371 | 2023-10-20 04:13:49 | compote | 1 | 69583 | 6 | 1.093 | 63662.4 |
370 | 2023-10-18 00:17:22 | compote | 1 | 69583 | 6 | 1.080 | 64428.7 |
369 | 2023-10-14 04:13:01 | compote | 1 | 69583 | 6 | 1.093 | 63662.4 |
368 | 2023-10-04 05:44:47 | compote | 1 | 69583 | 6 | 1.233 | 56433.9 |
367 | 2023-10-04 05:39:56 | compote | 2 | 107671 | 45 | 7.936 | 13567.4 |
366 | 2023-10-04 05:39:12 | compote | 3 | 134027 | 246 | 7.920 | 16922.6 |
365 | 2023-10-01 08:56:15 | compote | 3 | 134027 | 246 | 9.080 | 14760.7 |
364 | 2023-09-28 16:23:56 | compote | 3 | 134027 | 246 | 6.503 | 20610.0 |
363 | 2023-09-28 16:23:57 | compote | 2 | 107671 | 45 | 3.280 | 32826.5 |
362 | 2023-09-24 08:47:22 | compote | 1 | 69583 | 6 | 2.640 | 26357.2 |
361 | 2023-09-23 12:32:50 | compote | 1 | 69583 | 6 | 1.110 | 62687.4 |
360 | 2023-09-23 12:24:29 | compote | 2 | 107671 | 45 | 3.846 | 27995.6 |
359 | 2023-09-16 12:54:24 | compote | 2 | 107671 | 45 | 3.280 | 32826.5 |
358 | 2023-08-27 19:45:05 | compote | 1 | 69583 | 6 | 1.093 | 63662.4 |
357 | 2023-08-16 10:18:06 | compote | 1 | 69583 | 6 | 1.110 | 62687.4 |
356 | 2023-06-19 07:28:47 | compote | 2 | 107671 | 45 | 3.280 | 32826.5 |
355 | 2023-06-01 10:26:12 | compote | 1 | 69583 | 6 | 1.190 | 58473.1 |
354 | 2023-05-02 00:39:14 | compote | 1 | 69583 | 6 | 1.250 | 55666.4 |
353 | 2023-03-25 23:47:00 | compote | 1 | 69583 | 6 | 1.186 | 58670.3 |
352 | 2023-03-14 18:31:57 | compote | 2 | 107671 | 45 | 2.780 | 38730.6 |
351 | 2023-01-19 17:25:30 | compote | 1 | 69583 | 6 | 1.080 | 64428.7 |
350 | 2023-01-09 22:24:00 | compote | 1 | 69583 | 6 | 1.063 | 65459.1 |
349 | 2022-12-16 18:36:23 | compote | 2 | 107671 | 45 | 2.796 | 38508.9 |
348 | 2022-10-22 01:48:06 | compote | 1 | 69583 | 6 | 1.233 | 56433.9 |
347 | 2022-09-28 08:20:13 | compote | 1 | 69583 | 6 | 1.076 | 64668.2 |
346 | 2022-08-07 22:42:28 | compote | 2 | 107671 | 45 | 2.890 | 37256.4 |
345 | 2022-07-14 07:56:11 | compote | 3 | 134027 | 246 | 5.703 | 23501.1 |
344 | 2022-06-12 07:02:00 | compote | 1 | 69583 | 6 | 1.080 | 64428.7 |
343 | 2022-06-04 04:14:11 | compote | 1 | 69583 | 6 | 1.076 | 64668.2 |
342 | 2022-03-11 06:30:28 | compote | 2 | 107671 | 45 | 2.983 | 36094.9 |
341 | 2022-02-17 17:24:21 | compote | 1 | 69583 | 6 | 1.186 | 58670.3 |
340 | 2022-02-17 13:32:44 | compote | 1 | 69583 | 6 | 1.266 | 54962.9 |
339 | 2021-12-07 00:23:02 | compote | 1 | 69583 | 6 | 1.250 | 55666.4 |
338 | 2021-12-06 22:36:54 | compote | 2 | 107671 | 45 | 5.156 | 20882.7 |
337 | 2021-12-04 22:59:47 | compote | 1 | 69583 | 6 | 1.123 | 61961.7 |
336 | 2021-12-04 20:01:53 | compote | 2 | 107671 | 45 | 3.403 | 31640.0 |
335 | 2021-11-06 04:52:25 | compote | 1 | 69583 | 6 | 1.250 | 55666.4 |
334 | 2021-10-14 08:35:55 | compote | 1 | 69583 | 6 | 1.096 | 63488.1 |
333 | 2021-10-12 06:59:47 | compote | 1 | 69583 | 6 | 1.203 | 57841.2 |
332 | 2021-09-19 00:24:32 | compote | 2 | 107671 | 45 | 2.843 | 37872.3 |
331 | 2021-09-10 11:33:02 | compote | 1 | 69583 | 6 | 1.076 | 64668.2 |
330 | 2021-08-23 20:25:09 | compote | 1 | 69583 | 6 | 1.076 | 64668.2 |
329 | 2021-08-21 16:21:33 | compote | 1 | 69583 | 6 | 1.093 | 63662.4 |
328 | 2021-08-06 12:23:39 | compote | 1 | 69583 | 6 | 1.093 | 63662.4 |
327 | 2021-05-02 11:28:12 | compote | 1 | 69583 | 6 | 1.280 | 54361.7 |
326 | 2021-03-23 00:26:17 | compote | 1 | 69583 | 6 | 1.593 | 43680.5 |
325 | 2021-02-15 12:11:32 | compote | 1 | 69583 | 6 | 1.093 | 63662.4 |
324 | 2021-01-30 05:10:32 | compote | 1 | 69583 | 6 | 1.216 | 57222.9 |
323 | 2021-01-04 22:30:32 | compote | 1 | 69583 | 6 | 1.110 | 62687.4 |
322 | 2020-10-27 14:44:12 | compote | 1 | 69583 | 6 | 1.110 | 62687.4 |
321 | 2020-10-27 14:26:14 | compote | 1 | 69583 | 6 | 1.156 | 60192.9 |