History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reference"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
408 | 2025-09-08 17:11:00 | reference | 1 | 81242 | 6 | 1.546 | 52549.8 |
407 | 2025-09-07 03:23:39 | reference | 1 | 81242 | 6 | 1.313 | 61875.1 |
406 | 2025-08-28 06:16:26 | reference | 1 | 81242 | 6 | 1.533 | 52995.4 |
405 | 2025-08-27 15:55:46 | reference | 2 | 121436 | 18 | 3.563 | 34082.5 |
404 | 2025-08-25 00:45:17 | reference | 2 | 121436 | 18 | 11.173 | 10868.7 |
403 | 2025-08-21 15:38:45 | reference | 1 | 81242 | 6 | 3.783 | 21475.5 |
402 | 2025-08-18 05:04:36 | reference | 1 | 81242 | 6 | 1.343 | 60492.9 |
401 | 2025-08-10 10:08:03 | reference | 1 | 81242 | 6 | 6.440 | 12615.2 |
400 | 2025-08-09 23:00:51 | reference | 1 | 81242 | 6 | 3.220 | 25230.4 |
399 | 2025-08-09 10:32:05 | reference | 1 | 81242 | 6 | 6.733 | 12066.2 |
398 | 2025-08-04 23:03:10 | reference | 1 | 81242 | 6 | 3.170 | 25628.4 |
397 | 2025-08-04 07:44:14 | reference | 1 | 81242 | 6 | 4.843 | 16775.1 |
396 | 2025-07-23 05:32:33 | reference | 1 | 81242 | 6 | 3.170 | 25628.4 |
395 | 2025-07-14 11:33:14 | reference | 2 | 121436 | 18 | 13.623 | 8914.0 |
394 | 2025-07-14 03:11:17 | reference | 3 | 148641 | 63 | 42.236 | 3519.3 |
393 | 2025-07-13 03:23:42 | reference | 1 | 81242 | 6 | 2.813 | 28880.9 |
392 | 2025-07-12 00:39:28 | reference | 1 | 81242 | 6 | 3.500 | 23212.0 |
391 | 2025-07-11 08:46:17 | reference | 3 | 148641 | 63 | 41.116 | 3615.2 |
390 | 2025-07-10 13:54:27 | reference | 1 | 81242 | 6 | 2.873 | 28277.8 |
389 | 2025-07-10 12:39:07 | reference | 1 | 81242 | 6 | 3.920 | 20725.0 |
388 | 2025-07-05 11:21:20 | reference | 3 | 148641 | 63 | 26.236 | 5665.5 |
387 | 2025-07-05 07:48:28 | reference | 2 | 121436 | 18 | 17.173 | 7071.3 |
386 | 2025-07-05 05:14:59 | reference | 3 | 148641 | 63 | 27.033 | 5498.5 |
385 | 2025-07-04 23:18:36 | reference | 3 | 148641 | 63 | 40.516 | 3668.7 |
384 | 2025-07-04 20:28:57 | reference | 2 | 121436 | 18 | 25.033 | 4851.0 |
383 | 2025-07-04 09:24:40 | reference | 1 | 81242 | 6 | 4.483 | 18122.2 |
382 | 2025-07-03 21:25:34 | reference | 1 | 81242 | 6 | 3.673 | 22118.7 |
381 | 2025-07-01 23:55:42 | reference | 1 | 81242 | 6 | 3.953 | 20552.0 |
380 | 2025-06-28 14:52:23 | reference | 1 | 81242 | 6 | 6.860 | 11842.9 |
379 | 2025-06-28 09:24:17 | reference | 1 | 81242 | 6 | 7.656 | 10611.5 |
378 | 2025-06-25 23:33:34 | reference | 1 | 81242 | 6 | 11.986 | 6778.1 |
377 | 2025-06-08 07:36:13 | reference | 1 | 81242 | 6 | 4.826 | 16834.2 |
376 | 2025-06-04 09:16:42 | reference | 1 | 81242 | 6 | 5.516 | 14728.4 |
375 | 2025-06-01 02:47:05 | reference | 1 | 81242 | 6 | 7.033 | 11551.5 |
374 | 2025-05-31 10:15:16 | reference | 3 | 148641 | 63 | 34.720 | 4281.1 |
373 | 2025-05-22 15:04:35 | reference | 3 | 148641 | 63 | 34.596 | 4296.5 |
372 | 2025-05-21 08:21:02 | reference | 1 | 81242 | 6 | 1.530 | 53099.3 |
371 | 2025-05-16 05:28:27 | reference | 3 | 148641 | 63 | 21.986 | 6760.7 |
370 | 2025-05-15 14:43:42 | reference | 3 | 148641 | 63 | 18.860 | 7881.3 |
369 | 2025-05-08 22:42:16 | reference | 3 | 148641 | 63 | 7.486 | 19855.9 |
368 | 2025-04-27 08:38:31 | reference | 1 | 81242 | 6 | 1.546 | 52549.8 |
367 | 2025-04-24 09:13:03 | reference | 1 | 81242 | 6 | 6.593 | 12322.5 |
366 | 2025-04-23 10:36:55 | reference | 3 | 148641 | 63 | 35.796 | 4152.4 |
365 | 2025-04-18 13:50:38 | reference | 3 | 148641 | 63 | 30.460 | 4879.9 |
364 | 2025-04-18 04:33:48 | reference | 3 | 148641 | 63 | 27.220 | 5460.7 |
363 | 2025-04-18 03:27:32 | reference | 3 | 148641 | 63 | 28.033 | 5302.4 |
362 | 2025-04-18 00:54:25 | reference | 2 | 121436 | 18 | 19.813 | 6129.1 |
361 | 2025-04-16 23:29:14 | reference | 1 | 81242 | 6 | 1.470 | 55266.7 |
360 | 2025-04-12 11:41:39 | reference | 3 | 148641 | 63 | 46.176 | 3219.0 |
359 | 2025-04-11 20:16:48 | reference | 2 | 121436 | 18 | 9.703 | 12515.3 |
358 | 2025-04-11 01:50:19 | reference | 3 | 148641 | 63 | 26.203 | 5672.7 |
357 | 2025-04-10 20:53:28 | reference | 1 | 81242 | 6 | 2.986 | 27207.6 |
356 | 2025-04-09 05:01:49 | reference | 3 | 148641 | 63 | 46.516 | 3195.5 |
355 | 2025-04-09 02:52:20 | reference | 3 | 148641 | 63 | 28.890 | 5145.1 |
354 | 2025-03-23 11:20:56 | reference | 1 | 81242 | 6 | 3.750 | 21664.5 |
353 | 2025-03-22 11:08:59 | reference | 3 | 148641 | 63 | 42.676 | 3483.0 |
352 | 2025-03-20 19:14:37 | reference | 3 | 148641 | 63 | 50.296 | 2955.3 |
351 | 2025-03-08 23:36:08 | reference | 1 | 81242 | 6 | 7.140 | 11378.4 |
350 | 2025-03-05 05:17:01 | reference | 3 | 148641 | 63 | 38.220 | 3889.1 |
349 | 2025-03-05 05:15:04 | reference | 1 | 81242 | 6 | 3.173 | 25604.2 |
348 | 2025-02-22 12:26:57 | reference | 3 | 148641 | 63 | 41.753 | 3560.0 |
347 | 2025-02-21 12:48:16 | reference | 3 | 148641 | 63 | 34.893 | 4259.9 |
346 | 2025-02-21 09:31:30 | reference | 3 | 148641 | 63 | 45.503 | 3266.6 |
345 | 2025-02-21 09:31:29 | reference | 2 | 121436 | 18 | 19.256 | 6306.4 |
344 | 2025-02-20 20:52:26 | reference | 3 | 148641 | 63 | 36.736 | 4046.2 |
343 | 2025-02-20 20:52:17 | reference | 3 | 148641 | 63 | 33.376 | 4453.5 |
342 | 2025-02-20 19:34:54 | reference | 3 | 148641 | 63 | 47.923 | 3101.7 |
341 | 2025-02-14 00:44:02 | reference | 2 | 121436 | 18 | 28.220 | 4303.2 |
340 | 2025-02-10 07:36:49 | reference | 2 | 121436 | 18 | 18.343 | 6620.3 |
339 | 2025-02-10 02:46:52 | reference | 1 | 81242 | 6 | 8.326 | 9757.6 |
338 | 2025-02-01 07:21:37 | reference | 1 | 81242 | 6 | 10.156 | 7999.4 |
337 | 2025-01-16 06:27:34 | reference | 3 | 148641 | 63 | 36.110 | 4116.3 |
336 | 2025-01-12 06:23:16 | reference | 3 | 148641 | 63 | 29.706 | 5003.7 |
335 | 2025-01-12 04:43:59 | reference | 3 | 148641 | 63 | 56.330 | 2638.8 |
334 | 2025-01-12 02:59:14 | reference | 3 | 148641 | 63 | 39.000 | 3811.3 |
333 | 2025-01-12 02:43:55 | reference | 4 | 165329 | 314 | 65.596 | 2520.4 |
332 | 2025-01-12 02:44:25 | reference | 3 | 148641 | 63 | 36.253 | 4100.1 |
331 | 2025-01-12 02:42:57 | reference | 1 | 81242 | 6 | 10.436 | 7784.8 |
330 | 2025-01-10 21:28:59 | reference | 3 | 148641 | 63 | 28.346 | 5243.8 |
329 | 2025-01-10 21:28:56 | reference | 2 | 121436 | 18 | 19.110 | 6354.6 |
328 | 2025-01-10 21:28:50 | reference | 1 | 81242 | 6 | 5.670 | 14328.4 |
327 | 2025-01-10 16:12:03 | reference | 3 | 148641 | 63 | 36.233 | 4102.4 |
326 | 2025-01-10 08:53:21 | reference | 2 | 121436 | 18 | 9.063 | 13399.1 |
325 | 2025-01-10 08:53:17 | reference | 1 | 81242 | 6 | 3.780 | 21492.6 |
324 | 2025-01-02 13:19:22 | reference | 2 | 121436 | 18 | 18.326 | 6626.4 |
323 | 2024-12-31 19:13:34 | reference | 2 | 121436 | 18 | 16.720 | 7262.9 |
322 | 2024-12-31 19:13:27 | reference | 1 | 81242 | 6 | 3.470 | 23412.7 |
321 | 2024-12-15 20:51:44 | reference | 3 | 148641 | 63 | 37.126 | 4003.7 |
320 | 2024-12-12 19:05:51 | reference | 1 | 81242 | 6 | 10.030 | 8099.9 |
319 | 2024-12-12 16:53:16 | reference | 3 | 148641 | 63 | 39.266 | 3785.5 |
318 | 2024-12-08 22:19:55 | reference | 3 | 148641 | 63 | 51.093 | 2909.2 |
317 | 2024-12-08 22:19:58 | reference | 3 | 148641 | 63 | 37.856 | 3926.5 |
316 | 2024-12-08 22:18:53 | reference | 1 | 81242 | 6 | 1.483 | 54782.2 |
315 | 2024-11-30 03:29:08 | reference | 1 | 81242 | 6 | 8.033 | 10113.5 |
314 | 2024-11-25 05:18:22 | reference | 1 | 81242 | 6 | 8.233 | 9867.8 |
313 | 2024-11-20 21:02:03 | reference | 2 | 121436 | 18 | 21.520 | 5642.9 |
312 | 2024-11-14 18:11:33 | reference | 3 | 148641 | 63 | 36.130 | 4114.1 |
311 | 2024-11-07 11:57:45 | reference | 3 | 148641 | 63 | 37.173 | 3998.6 |
310 | 2024-11-07 11:57:47 | reference | 2 | 121436 | 18 | 18.626 | 6519.7 |
309 | 2024-11-07 11:10:48 | reference | 1 | 81242 | 6 | 6.046 | 13437.3 |