History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"activity"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
433 | 2025-09-05 00:29:25 | activity | 4 | 161609 | 394 | 11.813 | 13680.6 |
432 | 2025-08-28 20:31:09 | activity | 1 | 82945 | 1 | 1.436 | 57761.1 |
431 | 2025-08-22 02:57:17 | activity | 1 | 82945 | 1 | 1.546 | 53651.4 |
430 | 2025-08-19 02:24:48 | activity | 4 | 161609 | 394 | 59.990 | 2693.9 |
429 | 2025-08-11 16:52:34 | activity | 1 | 82945 | 1 | 2.813 | 29486.3 |
428 | 2025-08-09 02:13:55 | activity | 1 | 82945 | 1 | 10.546 | 7865.1 |
427 | 2025-08-08 10:29:13 | activity | 4 | 161609 | 394 | 12.440 | 12991.1 |
426 | 2025-08-07 16:48:56 | activity | 2 | 121059 | 18 | 7.703 | 15715.8 |
425 | 2025-08-07 10:08:19 | activity | 4 | 161609 | 394 | 48.846 | 3308.5 |
424 | 2025-08-07 01:51:01 | activity | 2 | 121059 | 18 | 18.623 | 6500.5 |
423 | 2025-08-06 22:52:13 | activity | 4 | 161609 | 394 | 53.986 | 2993.5 |
422 | 2025-08-06 16:41:26 | activity | 1 | 82945 | 1 | 3.076 | 26965.2 |
421 | 2025-08-05 13:33:19 | activity | 1 | 82945 | 1 | 4.766 | 17403.5 |
420 | 2025-08-04 18:20:50 | activity | 4 | 161609 | 394 | 46.660 | 3463.5 |
419 | 2025-08-04 01:32:35 | activity | 1 | 82945 | 1 | 4.030 | 20581.9 |
418 | 2025-08-02 13:36:32 | activity | 4 | 161609 | 394 | 69.393 | 2328.9 |
417 | 2025-08-02 07:37:38 | activity | 2 | 121059 | 18 | 11.280 | 10732.2 |
416 | 2025-08-02 07:37:09 | activity | 3 | 146162 | 70 | 19.503 | 7494.3 |
415 | 2025-07-31 10:53:22 | activity | 1 | 82945 | 1 | 1.576 | 52630.1 |
414 | 2025-07-23 20:24:49 | activity | 1 | 82945 | 1 | 8.846 | 9376.6 |
413 | 2025-07-21 12:39:41 | activity | 1 | 82945 | 1 | 1.483 | 55930.5 |
412 | 2025-07-20 21:42:12 | activity | 1 | 82945 | 1 | 1.546 | 53651.4 |
411 | 2025-07-20 18:10:44 | activity | 1 | 82945 | 1 | 1.563 | 53067.8 |
410 | 2025-07-07 18:13:16 | activity | 1 | 82945 | 1 | 1.326 | 62552.8 |
409 | 2025-07-07 05:23:38 | activity | 1 | 82945 | 1 | 3.123 | 26559.4 |
408 | 2025-07-03 00:51:43 | activity | 1 | 82945 | 1 | 7.376 | 11245.3 |
407 | 2025-06-26 01:37:29 | activity | 1 | 82945 | 1 | 3.893 | 21306.2 |
406 | 2025-06-23 15:27:44 | activity | 1 | 82945 | 1 | 10.110 | 8204.3 |
405 | 2025-06-22 13:05:10 | activity | 1 | 82945 | 1 | 3.326 | 24938.4 |
404 | 2025-06-19 20:34:02 | activity | 1 | 82945 | 1 | 6.813 | 12174.5 |
403 | 2025-05-31 09:49:21 | activity | 1 | 82945 | 1 | 7.216 | 11494.6 |
402 | 2025-05-25 06:35:54 | activity | 1 | 82945 | 1 | 3.890 | 21322.6 |
401 | 2025-05-22 17:44:33 | activity | 1 | 82945 | 1 | 6.393 | 12974.3 |
400 | 2025-05-17 12:23:56 | activity | 1 | 82945 | 1 | 1.440 | 57600.7 |
399 | 2025-05-08 00:25:13 | activity | 1 | 82945 | 1 | 6.580 | 12605.6 |
398 | 2025-04-28 15:04:01 | activity | 2 | 121059 | 18 | 18.896 | 6406.6 |
397 | 2025-04-27 01:04:59 | activity | 1 | 82945 | 1 | 1.373 | 60411.5 |
396 | 2025-04-23 04:27:18 | activity | 1 | 82945 | 1 | 7.500 | 11059.3 |
395 | 2025-04-20 16:37:08 | activity | 1 | 82945 | 1 | 1.440 | 57600.7 |
394 | 2025-04-10 04:01:54 | activity | 1 | 82945 | 1 | 2.656 | 31229.3 |
393 | 2025-04-05 20:25:16 | activity | 1 | 82945 | 1 | 3.673 | 22582.4 |
392 | 2025-04-01 23:49:40 | activity | 1 | 82945 | 1 | 7.063 | 11743.6 |
391 | 2025-03-21 04:46:31 | activity | 1 | 82945 | 1 | 3.266 | 25396.5 |
390 | 2025-03-21 03:08:05 | activity | 1 | 82945 | 1 | 3.233 | 25655.7 |
389 | 2025-03-20 23:54:58 | activity | 1 | 82945 | 1 | 1.453 | 57085.3 |
388 | 2025-03-08 06:30:33 | activity | 1 | 82945 | 1 | 5.563 | 14910.1 |
387 | 2025-03-01 20:25:35 | activity | 1 | 82945 | 1 | 3.420 | 24252.9 |
386 | 2025-02-08 14:53:54 | activity | 1 | 82945 | 1 | 6.783 | 12228.4 |
385 | 2025-02-07 17:04:09 | activity | 1 | 82945 | 1 | 4.843 | 17126.8 |
384 | 2025-02-04 13:19:36 | activity | 1 | 82945 | 1 | 3.546 | 23391.1 |
383 | 2025-01-10 13:11:18 | activity | 1 | 82945 | 1 | 3.920 | 21159.4 |
382 | 2025-01-08 13:50:21 | activity | 1 | 82945 | 1 | 3.690 | 22478.3 |
381 | 2025-01-02 22:19:49 | activity | 1 | 82945 | 1 | 6.580 | 12605.6 |
380 | 2024-12-16 00:42:48 | activity | 3 | 146162 | 70 | 55.006 | 2657.2 |
379 | 2024-12-15 19:54:45 | activity | 3 | 146162 | 70 | 12.313 | 11870.5 |
378 | 2024-12-14 10:12:52 | activity | 3 | 146162 | 70 | 28.703 | 5092.2 |
377 | 2024-12-12 17:37:53 | activity | 3 | 146162 | 70 | 37.406 | 3907.4 |
376 | 2024-12-05 08:49:36 | activity | 1 | 82945 | 1 | 4.610 | 17992.4 |
375 | 2024-12-02 15:40:12 | activity | 1 | 82945 | 1 | 6.220 | 13335.2 |
374 | 2024-11-22 14:24:12 | activity | 3 | 146162 | 70 | 19.236 | 7598.4 |
373 | 2024-11-22 12:52:04 | activity | 1 | 82945 | 1 | 8.906 | 9313.4 |
372 | 2024-11-08 04:48:42 | activity | 3 | 146162 | 70 | 31.880 | 4584.8 |
371 | 2024-11-05 08:06:48 | activity | 3 | 146162 | 70 | 34.970 | 4179.6 |
370 | 2024-11-05 08:06:47 | activity | 2 | 121059 | 18 | 13.783 | 8783.2 |
369 | 2024-11-04 16:16:20 | activity | 4 | 161609 | 394 | 75.193 | 2149.3 |
368 | 2024-11-04 16:15:58 | activity | 3 | 146162 | 70 | 23.033 | 6345.8 |
367 | 2024-11-04 10:31:39 | activity | 4 | 161609 | 394 | 73.723 | 2192.1 |
366 | 2024-11-04 07:22:52 | activity | 4 | 161609 | 394 | 38.283 | 4221.4 |
365 | 2024-11-03 21:43:21 | activity | 4 | 161609 | 394 | 10.906 | 14818.4 |
364 | 2024-11-03 21:15:02 | activity | 3 | 146162 | 70 | 6.890 | 21213.6 |
363 | 2024-11-03 21:15:03 | activity | 2 | 121059 | 18 | 3.513 | 34460.3 |
362 | 2024-11-03 21:14:56 | activity | 1 | 82945 | 1 | 1.406 | 58993.6 |
361 | 2024-11-01 14:32:05 | activity | 1 | 82945 | 1 | 3.610 | 22976.5 |
360 | 2024-10-28 05:08:46 | activity | 1 | 82945 | 1 | 5.610 | 14785.2 |
359 | 2024-10-19 03:08:17 | activity | 1 | 82945 | 1 | 6.360 | 13041.7 |
358 | 2024-10-18 07:42:14 | activity | 1 | 82945 | 1 | 7.233 | 11467.6 |
357 | 2024-10-03 06:14:56 | activity | 1 | 82945 | 1 | 9.656 | 8590.0 |
356 | 2024-09-20 10:29:29 | activity | 1 | 82945 | 1 | 9.060 | 9155.1 |
355 | 2024-07-29 03:33:57 | activity | 1 | 82945 | 1 | 2.826 | 29350.7 |
354 | 2024-07-23 06:34:40 | activity | 1 | 82945 | 1 | 4.813 | 17233.5 |
353 | 2024-07-16 13:47:03 | activity | 3 | 146162 | 70 | 32.173 | 4543.0 |
352 | 2024-07-16 08:01:09 | activity | 3 | 146162 | 70 | 23.470 | 6227.6 |
351 | 2024-07-14 22:43:47 | activity | 1 | 82945 | 1 | 5.343 | 15524.1 |
350 | 2024-07-13 05:44:51 | activity | 2 | 121059 | 18 | 17.846 | 6783.5 |
349 | 2024-07-12 05:25:07 | activity | 3 | 146162 | 70 | 41.000 | 3564.9 |
348 | 2024-07-11 21:41:01 | activity | 3 | 146162 | 70 | 26.830 | 5447.7 |
347 | 2024-07-11 17:20:25 | activity | 4 | 161609 | 394 | 46.456 | 3478.8 |
346 | 2024-07-11 17:20:15 | activity | 3 | 146162 | 70 | 32.533 | 4492.7 |
345 | 2024-07-11 10:42:03 | activity | 4 | 161609 | 394 | 58.003 | 2786.2 |
344 | 2024-07-11 06:35:52 | activity | 3 | 146162 | 70 | 26.753 | 5463.4 |
343 | 2024-07-11 00:25:52 | activity | 4 | 161609 | 394 | 72.550 | 2227.6 |
342 | 2024-07-11 00:26:00 | activity | 3 | 146162 | 70 | 31.576 | 4628.9 |
341 | 2024-07-11 00:26:14 | activity | 1 | 82945 | 1 | 6.920 | 11986.3 |
340 | 2024-07-11 00:26:07 | activity | 2 | 121059 | 18 | 11.970 | 10113.5 |
339 | 2024-06-18 10:33:09 | activity | 1 | 82945 | 1 | 5.326 | 15573.6 |
338 | 2024-06-05 12:50:02 | activity | 1 | 82945 | 1 | 6.486 | 12788.3 |
337 | 2024-06-05 03:15:17 | activity | 2 | 121059 | 18 | 6.470 | 18710.8 |
336 | 2024-06-03 23:08:16 | activity | 2 | 121059 | 18 | 5.376 | 22518.4 |
335 | 2024-06-03 23:08:12 | activity | 3 | 146162 | 70 | 7.830 | 18666.9 |
334 | 2024-06-03 20:02:39 | activity | 2 | 121059 | 18 | 8.923 | 13567.1 |