History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sonata"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
433 | 2024-03-31 17:14:30 | sonata | 1 | 48755 | 3 | 2.016 | 24184.0 |
432 | 2024-03-30 14:42:13 | sonata | 1 | 48755 | 3 | 1.170 | 41670.9 |
431 | 2024-03-29 06:00:27 | sonata | 1 | 48755 | 3 | 0.936 | 52088.7 |
430 | 2024-03-10 13:31:34 | sonata | 3 | 112716 | 416 | 16.783 | 6716.1 |
429 | 2024-03-07 03:32:50 | sonata | 3 | 112716 | 416 | 10.030 | 11237.9 |
428 | 2024-03-07 03:32:51 | sonata | 2 | 82551 | 22 | 6.093 | 13548.5 |
427 | 2024-03-07 02:26:56 | sonata | 1 | 48755 | 3 | 0.860 | 56691.9 |
426 | 2024-03-01 01:57:12 | sonata | 2 | 82551 | 22 | 2.830 | 29170.0 |
425 | 2024-03-01 01:56:45 | sonata | 3 | 112716 | 416 | 6.013 | 18745.4 |
424 | 2024-03-01 01:51:05 | sonata | 2 | 82551 | 22 | 5.310 | 15546.3 |
423 | 2024-03-01 01:50:46 | sonata | 3 | 112716 | 416 | 5.670 | 19879.4 |
422 | 2024-02-29 07:21:15 | sonata | 3 | 112716 | 416 | 7.080 | 15920.3 |
421 | 2024-02-29 07:21:19 | sonata | 1 | 48755 | 3 | 1.796 | 27146.4 |
420 | 2024-02-29 07:21:11 | sonata | 2 | 82551 | 22 | 2.783 | 29662.6 |
419 | 2024-01-18 11:42:27 | sonata | 1 | 48755 | 3 | 0.940 | 51867.0 |
418 | 2024-01-14 06:24:10 | sonata | 3 | 112716 | 416 | 5.626 | 20034.8 |
417 | 2024-01-11 10:59:44 | sonata | 2 | 82551 | 22 | 2.373 | 34787.6 |
416 | 2024-01-05 06:25:36 | sonata | 2 | 82551 | 22 | 2.436 | 33887.9 |
415 | 2023-11-29 16:06:53 | sonata | 1 | 48755 | 3 | 0.873 | 55847.7 |
414 | 2023-11-20 05:07:29 | sonata | 1 | 48755 | 3 | 0.830 | 58741.0 |
413 | 2023-11-17 17:26:08 | sonata | 1 | 48755 | 3 | 0.906 | 53813.5 |
412 | 2023-11-13 20:39:46 | sonata | 1 | 48755 | 3 | 0.890 | 54780.9 |
411 | 2023-11-03 19:14:17 | sonata | 1 | 48755 | 3 | 0.876 | 55656.4 |
410 | 2023-11-02 07:40:50 | sonata | 1 | 48755 | 3 | 0.890 | 54780.9 |
409 | 2023-10-29 22:27:47 | sonata | 1 | 48755 | 3 | 0.780 | 62506.4 |
408 | 2023-10-19 22:30:59 | sonata | 1 | 48755 | 3 | 0.800 | 60943.8 |
407 | 2023-10-11 15:29:00 | sonata | 1 | 48755 | 3 | 0.860 | 56691.9 |
406 | 2023-10-11 09:18:41 | sonata | 2 | 82551 | 22 | 2.440 | 33832.4 |
405 | 2023-09-29 07:02:02 | sonata | 1 | 48755 | 3 | 0.860 | 56691.9 |
404 | 2023-09-19 10:27:54 | sonata | 1 | 48755 | 3 | 0.843 | 57835.1 |
403 | 2023-09-02 17:03:24 | sonata | 1 | 48755 | 3 | 0.766 | 63648.8 |
402 | 2023-07-21 12:44:47 | sonata | 2 | 82551 | 22 | 2.376 | 34743.7 |
401 | 2023-07-15 09:33:12 | sonata | 1 | 48755 | 3 | 0.846 | 57630.0 |
400 | 2023-06-02 01:51:14 | sonata | 1 | 48755 | 3 | 0.766 | 63648.8 |
399 | 2023-04-04 14:34:55 | sonata | 2 | 82551 | 22 | 4.466 | 18484.3 |
398 | 2023-03-26 14:41:09 | sonata | 1 | 48755 | 3 | 0.750 | 65006.7 |
397 | 2023-03-17 10:31:10 | sonata | 1 | 48755 | 3 | 0.766 | 63648.8 |
396 | 2023-01-10 05:10:32 | sonata | 1 | 48755 | 3 | 0.763 | 63899.1 |
395 | 2023-01-01 09:12:58 | sonata | 2 | 82551 | 22 | 2.123 | 38884.1 |
394 | 2022-11-11 20:39:18 | sonata | 1 | 48755 | 3 | 0.783 | 62266.9 |
393 | 2022-10-14 00:53:42 | sonata | 1 | 48755 | 3 | 0.780 | 62506.4 |
392 | 2022-09-14 21:17:23 | sonata | 1 | 48755 | 3 | 0.783 | 62266.9 |
391 | 2022-09-01 22:36:51 | sonata | 2 | 82551 | 22 | 2.173 | 37989.4 |
390 | 2022-07-05 11:47:44 | sonata | 1 | 48755 | 3 | 0.813 | 59969.2 |
389 | 2022-06-04 08:15:16 | sonata | 1 | 48755 | 3 | 0.843 | 57835.1 |
388 | 2022-06-02 02:51:35 | sonata | 1 | 48755 | 3 | 0.763 | 63899.1 |
387 | 2022-03-01 02:04:53 | sonata | 1 | 48755 | 3 | 0.826 | 59025.4 |
386 | 2022-02-25 16:08:35 | sonata | 1 | 48755 | 3 | 0.923 | 52822.3 |
385 | 2022-02-25 01:58:56 | sonata | 2 | 82551 | 22 | 3.250 | 25400.3 |
384 | 2022-02-24 07:55:53 | sonata | 2 | 82551 | 22 | 2.656 | 31080.9 |
383 | 2022-02-23 20:52:57 | sonata | 2 | 82551 | 22 | 2.906 | 28407.1 |
382 | 2022-02-23 13:08:48 | sonata | 2 | 82551 | 22 | 2.673 | 30883.3 |
381 | 2022-02-22 20:44:53 | sonata | 2 | 82551 | 22 | 2.640 | 31269.3 |
380 | 2022-02-22 12:18:50 | sonata | 2 | 82551 | 22 | 2.733 | 30205.3 |
379 | 2022-02-21 17:42:20 | sonata | 2 | 82551 | 22 | 2.690 | 30688.1 |
378 | 2022-02-21 00:45:33 | sonata | 2 | 82551 | 22 | 2.593 | 31836.1 |
377 | 2022-02-20 12:04:19 | sonata | 2 | 82551 | 22 | 2.766 | 29844.9 |
376 | 2022-02-20 02:15:13 | sonata | 2 | 82551 | 22 | 2.190 | 37694.5 |
375 | 2022-02-19 11:22:11 | sonata | 2 | 82551 | 22 | 4.923 | 16768.4 |
374 | 2022-02-19 01:15:06 | sonata | 2 | 82551 | 22 | 2.250 | 36689.3 |
373 | 2022-02-18 15:01:06 | sonata | 2 | 82551 | 22 | 2.423 | 34069.7 |
372 | 2022-02-18 06:45:49 | sonata | 2 | 82551 | 22 | 2.190 | 37694.5 |
371 | 2022-02-17 16:56:49 | sonata | 2 | 82551 | 22 | 2.516 | 32810.4 |
370 | 2022-02-17 05:19:31 | sonata | 2 | 82551 | 22 | 2.673 | 30883.3 |
369 | 2022-02-16 13:22:33 | sonata | 2 | 82551 | 22 | 2.610 | 31628.7 |
368 | 2022-02-15 19:45:09 | sonata | 2 | 82551 | 22 | 2.483 | 33246.5 |
367 | 2022-02-15 04:44:21 | sonata | 2 | 82551 | 22 | 2.203 | 37472.1 |
366 | 2022-02-14 18:11:59 | sonata | 2 | 82551 | 22 | 2.716 | 30394.3 |
365 | 2022-02-14 01:10:37 | sonata | 2 | 82551 | 22 | 2.220 | 37185.1 |
364 | 2022-02-13 14:50:57 | sonata | 2 | 82551 | 22 | 2.576 | 32046.2 |
363 | 2022-02-13 09:21:45 | sonata | 2 | 82551 | 22 | 2.203 | 37472.1 |
362 | 2022-02-12 16:50:29 | sonata | 2 | 82551 | 22 | 2.330 | 35429.6 |
361 | 2022-02-12 01:13:58 | sonata | 2 | 82551 | 22 | 5.000 | 16510.2 |
360 | 2022-02-12 00:38:55 | sonata | 1 | 48755 | 3 | 1.063 | 45865.5 |
359 | 2022-02-11 08:08:08 | sonata | 2 | 82551 | 22 | 4.720 | 17489.6 |
358 | 2022-02-11 04:40:56 | sonata | 2 | 82551 | 22 | 2.250 | 36689.3 |
357 | 2022-02-10 11:08:09 | sonata | 2 | 82551 | 22 | 2.856 | 28904.4 |
356 | 2022-02-09 16:10:31 | sonata | 2 | 82551 | 22 | 2.533 | 32590.2 |
355 | 2022-02-08 23:48:03 | sonata | 2 | 82551 | 22 | 2.596 | 31799.3 |
354 | 2022-02-08 12:01:54 | sonata | 2 | 82551 | 22 | 2.360 | 34979.2 |
353 | 2022-02-07 17:02:53 | sonata | 2 | 82551 | 22 | 2.296 | 35954.3 |
352 | 2021-12-31 23:20:51 | sonata | 2 | 82551 | 22 | 2.546 | 32423.8 |
351 | 2021-12-31 12:37:45 | sonata | 2 | 82551 | 22 | 2.670 | 30918.0 |
350 | 2021-12-30 18:40:03 | sonata | 2 | 82551 | 22 | 2.346 | 35188.0 |
349 | 2021-12-30 00:30:39 | sonata | 2 | 82551 | 22 | 2.266 | 36430.3 |
348 | 2021-12-29 14:58:17 | sonata | 2 | 82551 | 22 | 2.860 | 28864.0 |
347 | 2021-12-29 05:32:26 | sonata | 2 | 82551 | 22 | 3.766 | 21920.1 |
346 | 2021-12-28 14:18:32 | sonata | 2 | 82551 | 22 | 2.500 | 33020.4 |
345 | 2021-12-27 22:07:02 | sonata | 2 | 82551 | 22 | 2.236 | 36919.1 |
344 | 2021-12-27 10:51:11 | sonata | 2 | 82551 | 22 | 2.250 | 36689.3 |
343 | 2021-12-26 22:24:46 | sonata | 2 | 82551 | 22 | 2.470 | 33421.5 |
342 | 2021-12-26 10:52:34 | sonata | 2 | 82551 | 22 | 2.266 | 36430.3 |
341 | 2021-12-26 02:24:35 | sonata | 2 | 82551 | 22 | 2.453 | 33653.1 |
340 | 2021-12-25 12:56:04 | sonata | 2 | 82551 | 22 | 2.500 | 33020.4 |
339 | 2021-12-25 01:52:41 | sonata | 2 | 82551 | 22 | 2.343 | 35233.0 |
338 | 2021-12-24 13:48:10 | sonata | 2 | 82551 | 22 | 2.736 | 30172.1 |
337 | 2021-12-24 02:22:33 | sonata | 2 | 82551 | 22 | 2.750 | 30018.5 |
336 | 2021-12-23 21:15:30 | sonata | 2 | 82551 | 22 | 2.250 | 36689.3 |
335 | 2021-12-23 09:48:05 | sonata | 2 | 82551 | 22 | 2.530 | 32628.9 |
334 | 2021-12-23 01:14:57 | sonata | 2 | 82551 | 22 | 2.326 | 35490.5 |