History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affecter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
435 | 2024-05-06 11:06:32 | affecter | 4 | 161609 | 603 | 11.876 | 13608.0 |
434 | 2024-05-06 09:33:35 | affecter | 4 | 161609 | 603 | 18.983 | 8513.4 |
433 | 2024-05-05 22:25:48 | affecter | 4 | 161609 | 603 | 11.453 | 14110.6 |
432 | 2024-05-05 17:20:37 | affecter | 4 | 161609 | 603 | 13.533 | 11941.8 |
431 | 2024-05-05 17:20:43 | affecter | 2 | 121059 | 11 | 6.610 | 18314.5 |
430 | 2024-05-05 17:20:33 | affecter | 3 | 146162 | 71 | 15.376 | 9505.9 |
429 | 2024-05-05 17:20:45 | affecter | 1 | 82945 | 4 | 1.546 | 53651.4 |
428 | 2024-04-20 16:04:08 | affecter | 2 | 121059 | 11 | 4.000 | 30264.8 |
427 | 2024-04-20 16:03:58 | affecter | 1 | 82945 | 4 | 3.813 | 21753.2 |
426 | 2024-04-13 13:03:55 | affecter | 1 | 82945 | 4 | 1.546 | 53651.4 |
425 | 2024-04-06 01:00:03 | affecter | 4 | 161609 | 603 | 17.953 | 9001.8 |
424 | 2024-04-05 05:33:52 | affecter | 4 | 161609 | 603 | 31.360 | 5153.3 |
423 | 2024-04-02 21:59:36 | affecter | 3 | 146162 | 71 | 12.593 | 11606.6 |
422 | 2024-04-01 09:49:44 | affecter | 3 | 146162 | 71 | 8.766 | 16673.7 |
421 | 2024-04-01 06:21:29 | affecter | 4 | 161609 | 603 | 25.360 | 6372.6 |
420 | 2024-04-01 02:58:04 | affecter | 1 | 82945 | 4 | 3.236 | 25632.0 |
419 | 2024-03-31 02:31:23 | affecter | 3 | 146162 | 71 | 12.376 | 11810.1 |
418 | 2024-03-30 18:39:46 | affecter | 4 | 161609 | 603 | 28.453 | 5679.9 |
417 | 2024-03-30 00:43:26 | affecter | 3 | 146162 | 71 | 22.873 | 6390.2 |
416 | 2024-03-29 20:54:10 | affecter | 4 | 161609 | 603 | 24.563 | 6579.4 |
415 | 2024-03-29 20:54:11 | affecter | 3 | 146162 | 71 | 13.420 | 10891.4 |
414 | 2024-03-26 14:38:32 | affecter | 1 | 82945 | 4 | 3.170 | 26165.6 |
413 | 2024-03-18 20:30:37 | affecter | 2 | 121059 | 11 | 4.063 | 29795.5 |
412 | 2024-03-18 20:30:32 | affecter | 1 | 82945 | 4 | 1.563 | 53067.8 |
411 | 2024-03-15 10:23:01 | affecter | 2 | 121059 | 11 | 3.923 | 30858.8 |
410 | 2024-03-15 10:22:14 | affecter | 3 | 146162 | 71 | 8.046 | 18165.8 |
409 | 2024-03-13 20:45:41 | affecter | 3 | 146162 | 71 | 8.763 | 16679.4 |
408 | 2024-03-11 01:18:34 | affecter | 2 | 121059 | 11 | 10.860 | 11147.2 |
407 | 2024-03-10 03:29:10 | affecter | 2 | 121059 | 11 | 4.170 | 29030.9 |
406 | 2024-03-10 03:28:56 | affecter | 1 | 82945 | 4 | 3.203 | 25896.0 |
405 | 2024-03-06 22:06:58 | affecter | 4 | 161609 | 603 | 36.440 | 4434.9 |
404 | 2024-03-05 23:46:02 | affecter | 4 | 161609 | 603 | 14.906 | 10841.9 |
403 | 2024-03-02 13:06:55 | affecter | 3 | 146162 | 71 | 23.513 | 6216.2 |
402 | 2024-03-02 03:49:36 | affecter | 4 | 161609 | 603 | 12.206 | 13240.1 |
401 | 2024-02-25 18:47:26 | affecter | 3 | 146162 | 71 | 10.033 | 14568.1 |
400 | 2024-02-25 06:43:23 | affecter | 4 | 161609 | 603 | 11.546 | 13997.0 |
399 | 2024-02-25 06:43:21 | affecter | 3 | 146162 | 71 | 6.826 | 21412.5 |
398 | 2024-02-25 06:43:23 | affecter | 2 | 121059 | 11 | 3.610 | 33534.3 |
397 | 2024-02-25 06:42:29 | affecter | 1 | 82945 | 4 | 1.266 | 65517.4 |
396 | 2024-02-17 14:12:33 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |
395 | 2024-02-12 21:06:03 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |
394 | 2024-02-04 10:28:26 | affecter | 4 | 161609 | 603 | 10.813 | 14945.8 |
393 | 2024-02-03 16:28:53 | affecter | 1 | 82945 | 4 | 1.686 | 49196.3 |
392 | 2024-01-31 00:01:35 | affecter | 1 | 82945 | 4 | 1.453 | 57085.3 |
391 | 2024-01-30 02:38:01 | affecter | 2 | 121059 | 11 | 3.703 | 32692.1 |
390 | 2024-01-26 03:01:09 | affecter | 4 | 161609 | 603 | 12.783 | 12642.5 |
389 | 2024-01-26 01:46:16 | affecter | 3 | 146162 | 71 | 15.593 | 9373.6 |
388 | 2024-01-26 01:46:11 | affecter | 4 | 161609 | 603 | 13.970 | 11568.3 |
387 | 2024-01-26 01:46:03 | affecter | 2 | 121059 | 11 | 4.033 | 30017.1 |
386 | 2024-01-26 01:45:59 | affecter | 2 | 121059 | 11 | 3.940 | 30725.6 |
385 | 2024-01-20 22:53:58 | affecter | 2 | 121059 | 11 | 4.096 | 29555.4 |
384 | 2024-01-13 01:37:42 | affecter | 1 | 82945 | 4 | 1.283 | 64649.3 |
383 | 2023-12-10 09:59:10 | affecter | 4 | 161609 | 603 | 35.643 | 4534.1 |
382 | 2023-12-10 09:59:11 | affecter | 3 | 146162 | 71 | 8.766 | 16673.7 |
381 | 2023-12-10 09:59:11 | affecter | 2 | 121059 | 11 | 8.203 | 14757.9 |
380 | 2023-11-30 08:05:52 | affecter | 1 | 82945 | 4 | 1.233 | 67270.9 |
379 | 2023-11-30 04:16:54 | affecter | 3 | 146162 | 71 | 6.546 | 22328.4 |
378 | 2023-11-11 01:04:06 | affecter | 1 | 82945 | 4 | 2.626 | 31586.1 |
377 | 2023-10-31 20:57:57 | affecter | 2 | 121059 | 11 | 3.703 | 32692.1 |
376 | 2023-10-07 15:35:06 | affecter | 1 | 82945 | 4 | 1.360 | 60989.0 |
375 | 2023-10-05 10:45:17 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |
374 | 2023-09-26 19:10:18 | affecter | 1 | 82945 | 4 | 1.313 | 63172.1 |
373 | 2023-09-14 22:21:06 | affecter | 1 | 82945 | 4 | 1.263 | 65673.0 |
372 | 2023-08-29 08:06:24 | affecter | 3 | 146162 | 71 | 5.940 | 24606.4 |
371 | 2023-08-08 00:31:03 | affecter | 2 | 121059 | 11 | 3.173 | 38152.9 |
370 | 2023-06-28 09:08:37 | affecter | 1 | 82945 | 4 | 1.326 | 62552.8 |
369 | 2023-06-02 02:07:30 | affecter | 1 | 82945 | 4 | 1.233 | 67270.9 |
368 | 2023-05-16 18:44:33 | affecter | 3 | 146162 | 71 | 5.970 | 24482.7 |
367 | 2023-04-21 11:29:14 | affecter | 2 | 121059 | 11 | 3.283 | 36874.5 |
366 | 2023-04-11 23:38:43 | affecter | 1 | 82945 | 4 | 1.236 | 67107.6 |
365 | 2023-02-22 11:36:53 | affecter | 3 | 146162 | 71 | 6.656 | 21959.4 |
364 | 2023-02-06 15:02:19 | affecter | 1 | 82945 | 4 | 1.233 | 67270.9 |
363 | 2023-02-01 06:31:53 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |
362 | 2023-01-26 22:42:37 | affecter | 2 | 121059 | 11 | 2.966 | 40815.6 |
361 | 2023-01-18 10:02:43 | affecter | 1 | 82945 | 4 | 1.233 | 67270.9 |
360 | 2022-12-04 12:59:51 | affecter | 1 | 82945 | 4 | 1.233 | 67270.9 |
359 | 2022-12-03 00:05:31 | affecter | 3 | 146162 | 71 | 5.983 | 24429.6 |
358 | 2022-12-01 00:21:35 | affecter | 1 | 82945 | 4 | 1.233 | 67270.9 |
357 | 2022-11-29 14:47:22 | affecter | 1 | 82945 | 4 | 1.343 | 61761.0 |
356 | 2022-11-09 09:22:26 | affecter | 2 | 121059 | 11 | 3.530 | 34294.3 |
355 | 2022-11-05 23:07:28 | affecter | 1 | 82945 | 4 | 1.220 | 67987.7 |
354 | 2022-10-05 14:16:59 | affecter | 1 | 82945 | 4 | 1.453 | 57085.3 |
353 | 2022-10-02 06:59:34 | affecter | 1 | 82945 | 4 | 1.266 | 65517.4 |
352 | 2022-07-25 22:55:10 | affecter | 1 | 82945 | 4 | 1.453 | 57085.3 |
351 | 2022-05-28 20:08:25 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |
350 | 2022-05-18 15:22:37 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |
349 | 2022-05-13 20:07:30 | affecter | 2 | 121059 | 11 | 3.516 | 34430.9 |
348 | 2022-04-13 16:31:34 | affecter | 3 | 146162 | 71 | 6.876 | 21256.8 |
347 | 2022-04-11 11:03:40 | affecter | 3 | 146162 | 71 | 7.123 | 20519.7 |
346 | 2022-03-22 21:39:19 | affecter | 1 | 82945 | 4 | 1.563 | 53067.8 |
345 | 2022-01-30 23:57:16 | affecter | 1 | 82945 | 4 | 1.296 | 64000.8 |
344 | 2022-01-27 13:00:12 | affecter | 1 | 82945 | 4 | 1.300 | 63803.8 |
343 | 2021-12-28 20:16:16 | affecter | 1 | 82945 | 4 | 1.533 | 54106.3 |
342 | 2021-12-14 23:59:26 | affecter | 3 | 146162 | 71 | 7.733 | 18901.1 |
341 | 2021-12-08 08:48:37 | affecter | 1 | 82945 | 4 | 1.423 | 58288.8 |
340 | 2021-11-11 07:38:13 | affecter | 1 | 82945 | 4 | 1.670 | 49667.7 |
339 | 2021-11-04 15:27:02 | affecter | 1 | 82945 | 4 | 1.483 | 55930.5 |
338 | 2021-10-14 02:57:00 | affecter | 1 | 82945 | 4 | 1.390 | 59672.7 |
337 | 2021-10-10 20:39:48 | affecter | 1 | 82945 | 4 | 1.373 | 60411.5 |
336 | 2021-09-26 07:53:23 | affecter | 1 | 82945 | 4 | 1.250 | 66356.0 |