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 |
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 |
306 | 2024-09-28 14:46:34 | transact | 2 | 121059 | 11 | 42.126 | 2873.7 |
305 | 2024-09-24 19:22:30 | transact | 3 | 146162 | 43 | 61.080 | 2393.0 |
304 | 2024-09-23 22:36:17 | transact | 3 | 146162 | 43 | 56.720 | 2576.9 |
303 | 2024-09-21 01:06:22 | transact | 3 | 146162 | 43 | 45.253 | 3229.9 |
302 | 2024-09-21 01:06:22 | transact | 2 | 121059 | 11 | 27.846 | 4347.4 |
301 | 2024-09-21 01:05:56 | transact | 1 | 82945 | 3 | 7.530 | 11015.3 |
300 | 2024-09-18 05:53:14 | transact | 1 | 82945 | 3 | 12.610 | 6577.7 |
299 | 2024-09-06 02:18:30 | transact | 4 | 161609 | 322 | 100.333 | 1610.7 |
298 | 2024-09-05 09:21:53 | transact | 4 | 161609 | 322 | 48.273 | 3347.8 |
297 | 2024-09-04 12:08:33 | transact | 4 | 161609 | 322 | 70.143 | 2304.0 |
296 | 2024-09-04 09:08:46 | transact | 4 | 161609 | 322 | 91.860 | 1759.3 |
295 | 2024-08-17 06:59:43 | transact | 1 | 82945 | 3 | 10.796 | 7682.9 |
294 | 2024-08-06 17:07:43 | transact | 4 | 161609 | 322 | 19.470 | 8300.4 |
293 | 2024-08-04 18:37:41 | transact | 3 | 146162 | 43 | 20.390 | 7168.3 |
292 | 2024-08-03 12:32:54 | transact | 4 | 161609 | 322 | 56.703 | 2850.1 |
291 | 2024-08-03 12:07:37 | transact | 4 | 161609 | 322 | 41.923 | 3854.9 |
290 | 2024-08-03 02:56:58 | transact | 4 | 161609 | 322 | 63.006 | 2565.0 |
289 | 2024-08-03 02:56:21 | transact | 1 | 82945 | 3 | 5.503 | 15072.7 |
288 | 2024-08-03 02:56:14 | transact | 2 | 121059 | 11 | 4.703 | 25740.8 |