History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"transact"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
406 | 2025-09-13 10:27:27 | transact | 1 | 82945 | 3 | 1.393 | 59544.1 |
405 | 2025-09-10 21:00:10 | transact | 1 | 82945 | 3 | 1.296 | 64000.8 |
404 | 2025-08-28 17:20:32 | transact | 3 | 146162 | 43 | 7.266 | 20115.9 |
403 | 2025-08-28 12:48:24 | transact | 1 | 82945 | 3 | 1.326 | 62552.8 |
402 | 2025-08-28 06:26:19 | transact | 2 | 121059 | 11 | 3.610 | 33534.3 |
401 | 2025-08-23 10:10:57 | transact | 3 | 146162 | 43 | 20.266 | 7212.2 |
400 | 2025-08-21 00:57:31 | transact | 2 | 121059 | 11 | 25.080 | 4826.9 |
399 | 2025-08-20 07:04:56 | transact | 1 | 82945 | 3 | 3.580 | 23169.0 |
398 | 2025-08-19 02:28:11 | transact | 3 | 146162 | 43 | 34.843 | 4194.9 |
397 | 2025-08-18 13:02:39 | transact | 1 | 82945 | 3 | 1.516 | 54713.1 |
396 | 2025-08-04 10:10:23 | transact | 3 | 146162 | 43 | 42.440 | 3444.0 |
395 | 2025-07-30 03:33:41 | transact | 1 | 82945 | 3 | 3.456 | 24000.3 |
394 | 2025-07-29 07:16:56 | transact | 3 | 146162 | 43 | 26.123 | 5595.1 |
393 | 2025-07-29 01:57:44 | transact | 3 | 146162 | 43 | 37.153 | 3934.1 |
392 | 2025-07-27 08:27:38 | transact | 2 | 121059 | 11 | 7.813 | 15494.6 |
391 | 2025-07-26 00:22:21 | transact | 3 | 146162 | 43 | 8.160 | 17912.0 |
390 | 2025-07-20 21:39:40 | transact | 3 | 146162 | 43 | 7.546 | 19369.5 |
389 | 2025-07-19 13:59:23 | transact | 1 | 82945 | 3 | 1.546 | 53651.4 |
388 | 2025-07-16 02:59:47 | transact | 2 | 121059 | 11 | 3.656 | 33112.4 |
387 | 2025-07-05 18:28:06 | transact | 2 | 121059 | 11 | 18.690 | 6477.2 |
386 | 2025-06-28 10:13:31 | transact | 1 | 82945 | 3 | 6.783 | 12228.4 |
385 | 2025-06-24 14:08:54 | transact | 1 | 82945 | 3 | 7.326 | 11322.0 |
384 | 2025-06-15 19:30:19 | transact | 1 | 82945 | 3 | 1.500 | 55296.7 |
383 | 2025-06-07 15:56:18 | transact | 1 | 82945 | 3 | 5.013 | 16546.0 |
382 | 2025-05-28 19:55:20 | transact | 1 | 82945 | 3 | 6.700 | 12379.9 |
381 | 2025-05-16 10:10:28 | transact | 1 | 82945 | 3 | 10.016 | 8281.3 |
380 | 2025-04-13 12:56:19 | transact | 1 | 82945 | 3 | 1.593 | 52068.4 |
379 | 2025-04-09 23:38:40 | transact | 2 | 121059 | 11 | 4.030 | 30039.5 |
378 | 2025-04-09 10:39:52 | transact | 3 | 146162 | 43 | 41.813 | 3495.6 |
377 | 2025-04-07 01:06:44 | transact | 1 | 82945 | 3 | 7.296 | 11368.6 |
376 | 2025-04-06 09:55:41 | transact | 1 | 82945 | 3 | 10.266 | 8079.6 |
375 | 2025-04-02 03:30:58 | transact | 3 | 146162 | 43 | 35.976 | 4062.8 |
374 | 2025-04-02 03:29:04 | transact | 2 | 121059 | 11 | 20.080 | 6028.8 |
373 | 2025-03-16 05:24:50 | transact | 1 | 82945 | 3 | 6.906 | 12010.6 |
372 | 2025-03-11 12:12:55 | transact | 3 | 146162 | 43 | 44.500 | 3284.5 |
371 | 2025-03-11 12:12:48 | transact | 2 | 121059 | 11 | 14.440 | 8383.6 |
370 | 2025-03-11 12:12:48 | transact | 1 | 82945 | 3 | 12.016 | 6902.9 |
369 | 2025-03-10 21:16:56 | transact | 3 | 146162 | 43 | 43.296 | 3375.9 |
368 | 2025-03-10 05:29:58 | transact | 3 | 146162 | 43 | 45.236 | 3231.1 |
367 | 2025-03-09 17:56:38 | transact | 1 | 82945 | 3 | 4.123 | 20117.6 |
366 | 2025-03-05 13:58:48 | transact | 3 | 146162 | 43 | 54.190 | 2697.2 |
365 | 2025-03-05 13:58:49 | transact | 3 | 146162 | 43 | 23.673 | 6174.2 |
364 | 2025-03-05 13:59:04 | transact | 1 | 82945 | 3 | 5.656 | 14665.0 |
363 | 2025-03-05 13:58:46 | transact | 2 | 121059 | 11 | 14.750 | 8207.4 |
362 | 2025-02-18 15:17:22 | transact | 1 | 82945 | 3 | 6.983 | 11878.1 |
361 | 2025-02-18 15:15:22 | transact | 2 | 121059 | 11 | 17.393 | 6960.2 |
360 | 2025-02-05 17:58:36 | transact | 2 | 121059 | 11 | 17.796 | 6802.6 |
359 | 2025-02-05 17:58:10 | transact | 1 | 82945 | 3 | 5.910 | 14034.7 |
358 | 2025-02-04 17:31:55 | transact | 2 | 121059 | 11 | 24.690 | 4903.2 |
357 | 2025-02-02 18:07:38 | transact | 1 | 82945 | 3 | 3.843 | 21583.4 |
356 | 2025-02-02 09:11:30 | transact | 2 | 121059 | 11 | 19.093 | 6340.5 |
355 | 2025-01-29 13:32:24 | transact | 2 | 121059 | 11 | 20.876 | 5799.0 |
354 | 2025-01-27 20:04:19 | transact | 3 | 146162 | 43 | 46.216 | 3162.6 |
353 | 2025-01-26 04:36:04 | transact | 4 | 161609 | 322 | 91.566 | 1764.9 |
352 | 2025-01-25 19:11:51 | transact | 4 | 161609 | 322 | 40.050 | 4035.2 |
351 | 2025-01-25 18:35:14 | transact | 4 | 161609 | 322 | 12.720 | 12705.1 |
350 | 2025-01-25 18:34:16 | transact | 3 | 146162 | 43 | 8.000 | 18270.3 |
349 | 2025-01-23 08:37:48 | transact | 3 | 146162 | 43 | 36.173 | 4040.6 |
348 | 2025-01-23 02:32:25 | transact | 3 | 146162 | 43 | 26.330 | 5551.2 |
347 | 2025-01-22 03:37:58 | transact | 3 | 146162 | 43 | 37.063 | 3943.6 |
346 | 2025-01-04 02:17:16 | transact | 1 | 82945 | 3 | 7.453 | 11129.1 |
345 | 2025-01-04 01:10:32 | transact | 1 | 82945 | 3 | 9.733 | 8522.0 |
344 | 2025-01-01 23:23:57 | transact | 1 | 82945 | 3 | 7.470 | 11103.7 |
343 | 2024-12-29 16:50:39 | transact | 2 | 121059 | 11 | 10.486 | 11544.8 |
342 | 2024-12-29 16:50:13 | transact | 1 | 82945 | 3 | 5.533 | 14991.0 |
341 | 2024-12-25 08:15:08 | transact | 3 | 146162 | 43 | 30.486 | 4794.4 |
340 | 2024-12-21 04:20:09 | transact | 3 | 146162 | 43 | 35.516 | 4115.4 |
339 | 2024-12-18 18:03:42 | transact | 3 | 146162 | 43 | 42.753 | 3418.8 |
338 | 2024-12-18 18:03:46 | transact | 2 | 121059 | 11 | 13.093 | 9246.1 |
337 | 2024-12-18 01:40:51 | transact | 2 | 121059 | 11 | 12.893 | 9389.5 |
336 | 2024-12-18 01:36:49 | transact | 3 | 146162 | 43 | 53.516 | 2731.2 |
335 | 2024-12-16 16:27:25 | transact | 3 | 146162 | 43 | 7.453 | 19611.2 |
334 | 2024-12-16 16:27:26 | transact | 2 | 121059 | 11 | 3.983 | 30393.9 |
333 | 2024-12-13 13:36:13 | transact | 4 | 161609 | 322 | 50.376 | 3208.1 |
332 | 2024-12-08 16:21:22 | transact | 4 | 161609 | 322 | 62.206 | 2598.0 |
331 | 2024-12-06 06:06:29 | transact | 4 | 161609 | 322 | 12.703 | 12722.1 |
330 | 2024-12-05 19:53:37 | transact | 4 | 161609 | 322 | 69.330 | 2331.0 |
329 | 2024-11-30 10:09:42 | transact | 1 | 82945 | 3 | 5.923 | 14003.9 |
328 | 2024-11-29 15:46:35 | transact | 1 | 82945 | 3 | 6.173 | 13436.7 |
327 | 2024-11-29 01:54:17 | transact | 1 | 82945 | 3 | 9.330 | 8890.1 |
326 | 2024-11-26 17:57:30 | transact | 1 | 82945 | 3 | 3.640 | 22787.1 |
325 | 2024-11-26 12:49:27 | transact | 4 | 161609 | 322 | 70.160 | 2303.4 |
324 | 2024-11-16 13:27:12 | transact | 2 | 121059 | 11 | 15.550 | 7785.1 |
323 | 2024-11-14 04:10:01 | transact | 3 | 146162 | 43 | 29.516 | 4952.0 |
322 | 2024-11-13 11:47:10 | transact | 4 | 161609 | 322 | 19.673 | 8214.8 |
321 | 2024-11-08 04:10:04 | transact | 4 | 161609 | 322 | 32.643 | 4950.8 |
320 | 2024-11-07 12:45:31 | transact | 2 | 121059 | 11 | 3.563 | 33976.7 |
319 | 2024-11-07 12:43:53 | transact | 3 | 146162 | 43 | 20.593 | 7097.7 |
318 | 2024-11-07 09:05:15 | transact | 3 | 146162 | 43 | 29.016 | 5037.3 |
317 | 2024-11-07 09:05:07 | transact | 2 | 121059 | 11 | 22.533 | 5372.5 |
316 | 2024-11-06 13:00:23 | transact | 3 | 146162 | 43 | 7.780 | 18786.9 |
315 | 2024-11-06 13:00:20 | transact | 2 | 121059 | 11 | 3.703 | 32692.1 |
314 | 2024-11-05 23:46:41 | transact | 4 | 161609 | 322 | 12.706 | 12719.1 |
313 | 2024-11-05 11:06:44 | transact | 4 | 161609 | 322 | 34.343 | 4705.7 |
312 | 2024-10-24 05:49:34 | transact | 1 | 82945 | 3 | 3.796 | 21850.6 |
311 | 2024-10-21 18:02:44 | transact | 1 | 82945 | 3 | 1.406 | 58993.6 |
310 | 2024-10-14 12:01:53 | transact | 3 | 146162 | 43 | 29.020 | 5036.6 |
309 | 2024-09-30 02:15:00 | transact | 1 | 82945 | 3 | 12.326 | 6729.3 |
308 | 2024-09-29 15:02:12 | transact | 2 | 121059 | 11 | 26.300 | 4603.0 |
307 | 2024-09-28 20:59:49 | transact | 2 | 121059 | 11 | 27.050 | 4475.4 |