History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"affective"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
429 | 2025-04-18 10:01:25 | affective | 1 | 81242 | 2 | 3.406 | 23852.6 |
428 | 2025-04-18 06:13:50 | affective | 1 | 81242 | 2 | 5.703 | 14245.5 |
427 | 2025-04-17 03:15:08 | affective | 3 | 148641 | 58 | 7.313 | 20325.6 |
426 | 2025-04-15 21:58:06 | affective | 1 | 81242 | 2 | 5.986 | 13572.0 |
425 | 2025-04-11 01:24:07 | affective | 3 | 148641 | 58 | 32.893 | 4518.9 |
424 | 2025-04-10 07:36:33 | affective | 3 | 148641 | 58 | 7.000 | 21234.4 |
423 | 2025-04-10 01:13:12 | affective | 1 | 81242 | 2 | 1.406 | 57782.4 |
422 | 2025-04-06 09:57:25 | affective | 1 | 81242 | 2 | 4.436 | 18314.2 |
421 | 2025-04-03 23:48:57 | affective | 3 | 148641 | 58 | 48.363 | 3073.4 |
420 | 2025-04-02 06:55:20 | affective | 3 | 148641 | 58 | 36.986 | 4018.8 |
419 | 2025-03-25 01:30:10 | affective | 3 | 148641 | 58 | 30.500 | 4873.5 |
418 | 2025-03-23 10:45:55 | affective | 1 | 81242 | 2 | 8.156 | 9961.0 |
417 | 2025-03-15 20:23:54 | affective | 3 | 148641 | 58 | 38.580 | 3852.8 |
416 | 2025-03-13 14:40:29 | affective | 3 | 148641 | 58 | 37.720 | 3940.6 |
415 | 2025-03-13 12:49:37 | affective | 3 | 148641 | 58 | 51.783 | 2870.5 |
414 | 2025-03-13 10:44:12 | affective | 1 | 81242 | 2 | 6.796 | 11954.4 |
413 | 2025-03-11 00:44:47 | affective | 4 | 165329 | 218 | 55.283 | 2990.6 |
412 | 2025-03-11 00:44:28 | affective | 3 | 148641 | 58 | 47.190 | 3149.8 |
411 | 2025-03-10 04:07:56 | affective | 3 | 148641 | 58 | 22.453 | 6620.1 |
410 | 2025-03-08 23:43:39 | affective | 4 | 165329 | 218 | 84.630 | 1953.6 |
409 | 2025-03-08 23:43:35 | affective | 3 | 148641 | 58 | 33.750 | 4404.2 |
408 | 2025-03-08 23:43:29 | affective | 2 | 121436 | 12 | 8.186 | 14834.6 |
407 | 2025-03-08 23:40:55 | affective | 1 | 81242 | 2 | 6.313 | 12869.0 |
406 | 2025-03-08 23:38:37 | affective | 1 | 81242 | 2 | 3.486 | 23305.2 |
405 | 2025-03-06 23:52:00 | affective | 1 | 81242 | 2 | 6.486 | 12525.7 |
404 | 2025-01-27 09:49:49 | affective | 1 | 81242 | 2 | 5.046 | 16100.3 |
403 | 2025-01-22 22:52:35 | affective | 3 | 148641 | 58 | 29.330 | 5067.9 |
402 | 2025-01-17 23:18:39 | affective | 3 | 148641 | 58 | 34.656 | 4289.0 |
401 | 2025-01-12 06:40:08 | affective | 3 | 148641 | 58 | 32.470 | 4577.8 |
400 | 2025-01-12 06:40:08 | affective | 2 | 121436 | 12 | 24.720 | 4912.5 |
399 | 2025-01-12 06:20:12 | affective | 1 | 81242 | 2 | 4.500 | 18053.8 |
398 | 2024-12-27 19:05:12 | affective | 1 | 81242 | 2 | 1.356 | 59913.0 |
397 | 2024-12-18 15:00:17 | affective | 1 | 81242 | 2 | 3.313 | 24522.2 |
396 | 2024-12-18 00:19:02 | affective | 3 | 148641 | 58 | 33.940 | 4379.5 |
395 | 2024-12-14 15:07:33 | affective | 3 | 148641 | 58 | 34.753 | 4277.1 |
394 | 2024-12-13 17:48:02 | affective | 2 | 121436 | 12 | 18.846 | 6443.6 |
393 | 2024-12-11 04:54:05 | affective | 1 | 81242 | 2 | 3.686 | 22040.7 |
392 | 2024-12-10 21:06:58 | affective | 2 | 121436 | 12 | 16.300 | 7450.1 |
391 | 2024-12-07 20:13:47 | affective | 3 | 148641 | 58 | 34.483 | 4310.6 |
390 | 2024-11-28 13:50:41 | affective | 3 | 148641 | 58 | 40.756 | 3647.1 |
389 | 2024-11-28 13:50:47 | affective | 2 | 121436 | 12 | 24.736 | 4909.3 |
388 | 2024-11-26 11:06:09 | affective | 1 | 81242 | 2 | 6.673 | 12174.7 |
387 | 2024-11-22 07:54:48 | affective | 4 | 165329 | 218 | 58.080 | 2846.6 |
386 | 2024-11-21 15:19:38 | affective | 4 | 165329 | 218 | 36.283 | 4556.7 |
385 | 2024-11-21 15:15:39 | affective | 1 | 81242 | 2 | 1.360 | 59736.8 |
384 | 2024-11-17 16:05:25 | affective | 2 | 121436 | 12 | 18.216 | 6666.4 |
383 | 2024-11-16 00:52:22 | affective | 3 | 148641 | 58 | 24.783 | 5997.7 |
382 | 2024-11-12 19:38:21 | affective | 3 | 148641 | 58 | 42.456 | 3501.1 |
381 | 2024-11-10 16:12:58 | affective | 1 | 81242 | 2 | 3.080 | 26377.3 |
380 | 2024-11-08 07:17:48 | affective | 1 | 81242 | 2 | 6.063 | 13399.6 |
379 | 2024-11-05 20:52:02 | affective | 3 | 148641 | 58 | 35.706 | 4162.9 |
378 | 2024-11-05 20:52:02 | affective | 2 | 121436 | 12 | 16.376 | 7415.5 |
377 | 2024-10-24 11:40:09 | affective | 1 | 81242 | 2 | 4.923 | 16502.5 |
376 | 2024-10-19 11:07:06 | affective | 3 | 148641 | 58 | 35.283 | 4212.8 |
375 | 2024-10-16 16:23:31 | affective | 3 | 148641 | 58 | 50.753 | 2928.7 |
374 | 2024-10-13 03:04:58 | affective | 3 | 148641 | 58 | 34.346 | 4327.8 |
373 | 2024-10-13 03:05:07 | affective | 2 | 121436 | 12 | 16.843 | 7209.9 |
372 | 2024-10-13 03:02:50 | affective | 1 | 81242 | 2 | 6.503 | 12493.0 |
371 | 2024-10-13 02:17:43 | affective | 3 | 148641 | 58 | 32.986 | 4506.2 |
370 | 2024-10-13 02:17:43 | affective | 2 | 121436 | 12 | 23.576 | 5150.8 |
369 | 2024-10-13 02:14:23 | affective | 1 | 81242 | 2 | 4.390 | 18506.2 |
368 | 2024-10-07 22:38:48 | affective | 1 | 81242 | 2 | 10.016 | 8111.2 |
367 | 2024-09-07 06:43:10 | affective | 1 | 81242 | 2 | 4.686 | 17337.2 |
366 | 2024-09-06 18:14:28 | affective | 1 | 81242 | 2 | 10.156 | 7999.4 |
365 | 2024-08-28 06:06:02 | affective | 1 | 81242 | 2 | 9.986 | 8135.6 |
364 | 2024-08-07 15:53:41 | affective | 1 | 81242 | 2 | 7.673 | 10588.0 |
363 | 2024-07-29 19:08:21 | affective | 1 | 81242 | 2 | 4.733 | 17165.0 |
362 | 2024-07-26 18:36:05 | affective | 1 | 81242 | 2 | 5.953 | 13647.2 |
361 | 2024-07-20 18:26:40 | affective | 1 | 81242 | 2 | 5.030 | 16151.5 |
360 | 2024-07-13 08:26:57 | affective | 1 | 81242 | 2 | 4.640 | 17509.1 |
359 | 2024-07-02 14:43:30 | affective | 1 | 81242 | 2 | 2.360 | 34424.6 |
358 | 2024-06-19 15:10:31 | affective | 3 | 148641 | 58 | 37.016 | 4015.6 |
357 | 2024-06-15 06:29:55 | affective | 3 | 148641 | 58 | 19.156 | 7759.5 |
356 | 2024-06-09 17:35:36 | affective | 2 | 121436 | 12 | 9.423 | 12887.2 |
355 | 2024-06-07 13:06:58 | affective | 1 | 81242 | 2 | 4.970 | 16346.5 |
354 | 2024-06-07 11:22:01 | affective | 3 | 148641 | 58 | 16.393 | 9067.3 |
353 | 2024-06-07 11:21:52 | affective | 2 | 121436 | 12 | 16.626 | 7304.0 |
352 | 2024-06-05 20:50:01 | affective | 4 | 165329 | 218 | 58.973 | 2803.5 |
351 | 2024-06-05 20:50:03 | affective | 3 | 148641 | 58 | 17.750 | 8374.1 |
350 | 2024-06-05 20:49:55 | affective | 2 | 121436 | 12 | 16.453 | 7380.8 |
349 | 2024-06-05 18:56:37 | affective | 1 | 81242 | 2 | 1.390 | 58447.5 |
348 | 2024-06-03 09:05:20 | affective | 1 | 81242 | 2 | 1.376 | 59042.2 |
347 | 2024-05-27 09:24:40 | affective | 3 | 148641 | 58 | 24.096 | 6168.7 |
346 | 2024-05-27 09:24:09 | affective | 1 | 81242 | 2 | 1.513 | 53696.0 |
345 | 2024-05-23 15:46:10 | affective | 4 | 165329 | 218 | 46.363 | 3566.0 |
344 | 2024-05-23 10:37:25 | affective | 4 | 165329 | 218 | 45.393 | 3642.2 |
343 | 2024-05-23 06:14:45 | affective | 4 | 165329 | 218 | 34.346 | 4813.6 |
342 | 2024-05-23 02:11:15 | affective | 4 | 165329 | 218 | 39.690 | 4165.5 |
341 | 2024-05-23 01:44:33 | affective | 4 | 165329 | 218 | 16.376 | 10095.8 |
340 | 2024-05-15 02:16:12 | affective | 3 | 148641 | 58 | 25.643 | 5796.6 |
339 | 2024-05-10 04:57:24 | affective | 4 | 165329 | 218 | 40.033 | 4129.8 |
338 | 2024-05-10 04:57:22 | affective | 3 | 148641 | 58 | 24.780 | 5998.4 |
337 | 2024-05-10 04:57:21 | affective | 2 | 121436 | 12 | 12.236 | 9924.5 |
336 | 2024-05-04 07:15:01 | affective | 1 | 81242 | 2 | 3.890 | 20884.8 |
335 | 2024-05-03 15:58:16 | affective | 1 | 81242 | 2 | 1.530 | 53099.3 |
334 | 2024-04-26 12:49:10 | affective | 1 | 81242 | 2 | 1.966 | 41323.5 |
333 | 2024-04-20 02:15:45 | affective | 4 | 165329 | 218 | 26.126 | 6328.1 |
332 | 2024-04-20 02:15:44 | affective | 3 | 148641 | 58 | 13.110 | 11338.0 |
331 | 2024-04-19 20:36:01 | affective | 4 | 165329 | 218 | 20.720 | 7979.2 |
330 | 2024-04-19 17:06:10 | affective | 3 | 148641 | 58 | 16.376 | 9076.8 |