History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canapes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
439 | 2024-04-17 20:02:13 | canapes | 3 | 134027 | 588 | 10.530 | 12728.1 |
438 | 2024-04-17 19:08:37 | canapes | 2 | 107671 | 34 | 8.500 | 12667.2 |
437 | 2024-04-17 13:18:33 | canapes | 3 | 134027 | 588 | 11.093 | 12082.1 |
436 | 2024-04-16 06:37:23 | canapes | 2 | 107671 | 34 | 3.186 | 33795.0 |
435 | 2024-04-16 06:36:29 | canapes | 3 | 134027 | 588 | 7.406 | 18097.1 |
434 | 2024-04-16 00:48:00 | canapes | 3 | 134027 | 588 | 16.486 | 8129.7 |
433 | 2024-04-16 00:45:21 | canapes | 2 | 107671 | 34 | 4.346 | 24774.7 |
432 | 2024-04-15 22:02:53 | canapes | 2 | 107671 | 34 | 5.483 | 19637.2 |
431 | 2024-04-01 18:53:28 | canapes | 1 | 69583 | 2 | 2.423 | 28717.7 |
430 | 2024-02-27 00:27:51 | canapes | 1 | 69583 | 2 | 2.580 | 26970.2 |
429 | 2024-02-09 05:38:37 | canapes | 2 | 107671 | 34 | 3.280 | 32826.5 |
428 | 2024-02-09 05:37:30 | canapes | 3 | 134027 | 588 | 7.296 | 18369.9 |
427 | 2024-01-31 21:15:08 | canapes | 3 | 134027 | 588 | 6.360 | 21073.4 |
426 | 2024-01-31 21:15:03 | canapes | 2 | 107671 | 34 | 3.576 | 30109.3 |
425 | 2024-01-31 18:52:32 | canapes | 2 | 107671 | 34 | 3.576 | 30109.3 |
424 | 2024-01-31 18:51:32 | canapes | 3 | 134027 | 588 | 7.123 | 18816.1 |
423 | 2024-01-31 18:45:44 | canapes | 3 | 134027 | 588 | 7.046 | 19021.7 |
422 | 2024-01-22 23:17:03 | canapes | 3 | 134027 | 588 | 6.140 | 21828.5 |
421 | 2024-01-15 09:44:11 | canapes | 1 | 69583 | 2 | 1.090 | 63837.6 |
420 | 2024-01-13 15:16:10 | canapes | 1 | 69583 | 2 | 1.283 | 54234.6 |
419 | 2023-12-17 23:49:58 | canapes | 2 | 107671 | 34 | 3.343 | 32207.9 |
418 | 2023-12-15 19:44:00 | canapes | 2 | 107671 | 34 | 2.953 | 36461.6 |
417 | 2023-12-12 01:02:45 | canapes | 3 | 134027 | 588 | 7.406 | 18097.1 |
416 | 2023-12-09 01:30:16 | canapes | 2 | 107671 | 34 | 2.906 | 37051.3 |
415 | 2023-12-01 19:08:50 | canapes | 2 | 107671 | 34 | 3.140 | 34290.1 |
414 | 2023-11-30 12:45:29 | canapes | 3 | 134027 | 588 | 9.203 | 14563.4 |
413 | 2023-11-24 17:32:56 | canapes | 1 | 69583 | 2 | 1.076 | 64668.2 |
412 | 2023-11-23 02:32:12 | canapes | 2 | 107671 | 34 | 3.170 | 33965.6 |
411 | 2023-11-12 04:34:12 | canapes | 1 | 69583 | 2 | 1.220 | 57035.2 |
410 | 2023-11-10 16:01:55 | canapes | 1 | 69583 | 2 | 1.253 | 55533.1 |
409 | 2023-11-10 04:10:31 | canapes | 1 | 69583 | 2 | 1.110 | 62687.4 |
408 | 2023-11-08 01:28:43 | canapes | 1 | 69583 | 2 | 1.266 | 54962.9 |
407 | 2023-11-03 22:23:48 | canapes | 3 | 134027 | 588 | 6.110 | 21935.7 |
406 | 2023-10-31 20:49:35 | canapes | 3 | 134027 | 588 | 8.393 | 15968.9 |
405 | 2023-10-29 00:32:25 | canapes | 1 | 69583 | 2 | 1.156 | 60192.9 |
404 | 2023-10-22 11:36:52 | canapes | 3 | 134027 | 588 | 16.626 | 8061.3 |
403 | 2023-10-22 11:30:31 | canapes | 1 | 69583 | 2 | 1.220 | 57035.2 |
402 | 2023-10-19 03:06:53 | canapes | 1 | 69583 | 2 | 1.106 | 62914.1 |
401 | 2023-10-15 02:50:16 | canapes | 1 | 69583 | 2 | 1.233 | 56433.9 |
400 | 2023-10-11 20:27:07 | canapes | 3 | 134027 | 588 | 7.453 | 17983.0 |
399 | 2023-10-09 13:43:05 | canapes | 1 | 69583 | 2 | 1.283 | 54234.6 |
398 | 2023-10-09 08:42:00 | canapes | 3 | 134027 | 588 | 7.610 | 17612.0 |
397 | 2023-10-01 16:23:22 | canapes | 3 | 134027 | 588 | 10.440 | 12837.8 |
396 | 2023-09-29 06:13:41 | canapes | 3 | 134027 | 588 | 6.843 | 19586.0 |
395 | 2023-09-29 06:13:41 | canapes | 2 | 107671 | 34 | 3.453 | 31181.9 |
394 | 2023-09-27 20:19:52 | canapes | 1 | 69583 | 2 | 1.220 | 57035.2 |
393 | 2023-09-25 18:43:27 | canapes | 1 | 69583 | 2 | 2.780 | 25029.9 |
392 | 2023-09-09 03:09:02 | canapes | 2 | 107671 | 34 | 5.796 | 18576.8 |
391 | 2023-08-29 13:13:30 | canapes | 1 | 69583 | 2 | 1.140 | 61037.7 |
390 | 2023-08-09 10:38:02 | canapes | 3 | 134027 | 588 | 7.096 | 18887.7 |
389 | 2023-07-20 07:22:59 | canapes | 1 | 69583 | 2 | 1.216 | 57222.9 |
388 | 2023-07-09 17:50:00 | canapes | 1 | 69583 | 2 | 1.093 | 63662.4 |
387 | 2023-06-02 08:49:24 | canapes | 2 | 107671 | 34 | 2.940 | 36622.8 |
386 | 2023-05-29 10:18:22 | canapes | 1 | 69583 | 2 | 1.173 | 59320.5 |
385 | 2023-04-21 22:32:18 | canapes | 3 | 134027 | 588 | 5.876 | 22809.2 |
384 | 2023-04-02 05:10:26 | canapes | 1 | 69583 | 2 | 1.250 | 55666.4 |
383 | 2023-03-23 09:08:27 | canapes | 1 | 69583 | 2 | 1.093 | 63662.4 |
382 | 2023-03-10 09:12:51 | canapes | 2 | 107671 | 34 | 2.923 | 36835.8 |
381 | 2023-02-04 09:58:02 | canapes | 3 | 134027 | 588 | 7.216 | 18573.6 |
380 | 2023-01-27 12:43:49 | canapes | 3 | 134027 | 588 | 6.436 | 20824.6 |
379 | 2023-01-09 13:12:11 | canapes | 1 | 69583 | 2 | 1.296 | 53690.6 |
378 | 2022-12-29 21:28:48 | canapes | 3 | 134027 | 588 | 7.160 | 18718.9 |
377 | 2022-12-24 08:23:15 | canapes | 1 | 69583 | 2 | 1.250 | 55666.4 |
376 | 2022-12-21 12:11:08 | canapes | 3 | 134027 | 588 | 6.376 | 21020.5 |
375 | 2022-12-14 15:15:02 | canapes | 2 | 107671 | 34 | 3.423 | 31455.2 |
374 | 2022-11-08 20:40:52 | canapes | 3 | 134027 | 588 | 6.186 | 21666.2 |
373 | 2022-10-07 11:49:30 | canapes | 1 | 69583 | 2 | 1.173 | 59320.5 |
372 | 2022-09-13 15:36:10 | canapes | 1 | 69583 | 2 | 1.110 | 62687.4 |
371 | 2022-08-28 11:23:58 | canapes | 3 | 134027 | 588 | 6.110 | 21935.7 |
370 | 2022-08-06 03:29:19 | canapes | 2 | 107671 | 34 | 3.016 | 35699.9 |
369 | 2022-08-03 19:32:45 | canapes | 2 | 107671 | 34 | 3.250 | 33129.5 |
368 | 2022-07-31 00:31:17 | canapes | 3 | 134027 | 588 | 6.096 | 21986.1 |
367 | 2022-07-18 15:03:20 | canapes | 3 | 134027 | 588 | 6.360 | 21073.4 |
366 | 2022-07-08 03:06:47 | canapes | 3 | 134027 | 588 | 6.013 | 22289.5 |
365 | 2022-06-15 09:31:59 | canapes | 3 | 134027 | 588 | 6.236 | 21492.5 |
364 | 2022-06-10 17:19:50 | canapes | 1 | 69583 | 2 | 1.096 | 63488.1 |
363 | 2022-05-24 09:05:23 | canapes | 1 | 69583 | 2 | 1.360 | 51164.0 |
362 | 2022-05-22 04:13:59 | canapes | 1 | 69583 | 2 | 1.093 | 63662.4 |
361 | 2022-05-21 19:43:02 | canapes | 1 | 69583 | 2 | 1.250 | 55666.4 |
360 | 2022-05-20 14:59:56 | canapes | 3 | 134027 | 588 | 6.016 | 22278.4 |
359 | 2022-05-18 09:58:22 | canapes | 1 | 69583 | 2 | 1.126 | 61796.6 |
358 | 2022-05-14 23:12:08 | canapes | 3 | 134027 | 588 | 5.936 | 22578.7 |
357 | 2022-05-12 18:42:40 | canapes | 3 | 134027 | 588 | 7.016 | 19103.1 |
356 | 2022-05-04 09:32:05 | canapes | 3 | 134027 | 588 | 9.313 | 14391.4 |
355 | 2022-04-28 05:05:53 | canapes | 1 | 69583 | 2 | 1.110 | 62687.4 |
354 | 2022-04-23 09:59:09 | canapes | 2 | 107671 | 34 | 3.266 | 32967.2 |
353 | 2022-04-02 00:02:55 | canapes | 3 | 134027 | 588 | 5.966 | 22465.1 |
352 | 2022-03-25 23:23:56 | canapes | 3 | 134027 | 588 | 6.703 | 19995.1 |
351 | 2022-03-22 11:32:51 | canapes | 2 | 107671 | 34 | 3.670 | 29338.1 |
350 | 2022-03-07 19:10:57 | canapes | 3 | 134027 | 588 | 7.563 | 17721.4 |
349 | 2022-02-08 15:37:50 | canapes | 1 | 69583 | 2 | 1.110 | 62687.4 |
348 | 2022-02-06 18:21:25 | canapes | 1 | 69583 | 2 | 1.153 | 60349.5 |
347 | 2022-02-03 13:43:19 | canapes | 1 | 69583 | 2 | 1.250 | 55666.4 |
346 | 2022-02-01 09:21:12 | canapes | 1 | 69583 | 2 | 1.310 | 53116.8 |
345 | 2022-01-28 15:06:01 | canapes | 3 | 134027 | 588 | 7.033 | 19056.9 |
344 | 2022-01-26 03:24:30 | canapes | 3 | 134027 | 588 | 7.296 | 18369.9 |
343 | 2022-01-08 00:31:48 | canapes | 3 | 134027 | 588 | 5.936 | 22578.7 |
342 | 2021-12-29 05:43:14 | canapes | 1 | 69583 | 2 | 1.250 | 55666.4 |
341 | 2021-12-26 11:53:26 | canapes | 1 | 69583 | 2 | 1.453 | 47889.2 |
340 | 2021-11-21 05:27:25 | canapes | 1 | 69583 | 2 | 1.280 | 54361.7 |