History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"proprietor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
454 | 2024-05-01 22:53:07 | proprietor | 1 | 67641 | 4 | 1.263 | 53555.8 |
453 | 2024-05-01 14:28:07 | proprietor | 1 | 67641 | 4 | 1.203 | 56226.9 |
452 | 2024-05-01 14:28:06 | proprietor | 1 | 67641 | 4 | 1.186 | 57032.9 |
451 | 2024-04-23 23:40:58 | proprietor | 4 | 161450 | 71 | 24.330 | 6635.8 |
450 | 2024-04-22 00:53:07 | proprietor | 4 | 161450 | 71 | 38.546 | 4188.5 |
449 | 2024-04-21 15:03:39 | proprietor | 4 | 161450 | 71 | 36.596 | 4411.7 |
448 | 2024-04-21 15:03:42 | proprietor | 2 | 108824 | 9 | 9.126 | 11924.6 |
447 | 2024-04-21 14:58:33 | proprietor | 1 | 67641 | 4 | 1.063 | 63632.2 |
446 | 2024-04-18 05:19:52 | proprietor | 1 | 67641 | 4 | 1.970 | 34335.5 |
445 | 2024-04-11 22:23:22 | proprietor | 5 | 173545 | 543 | 76.036 | 2282.4 |
444 | 2024-04-10 18:19:34 | proprietor | 5 | 173545 | 543 | 50.673 | 3424.8 |
443 | 2024-04-10 13:58:37 | proprietor | 5 | 173545 | 543 | 64.130 | 2706.1 |
442 | 2024-04-09 19:41:24 | proprietor | 5 | 173545 | 543 | 45.723 | 3795.6 |
441 | 2024-04-03 01:38:01 | proprietor | 2 | 108824 | 9 | 6.876 | 15826.6 |
440 | 2024-04-03 01:30:07 | proprietor | 1 | 67641 | 4 | 1.203 | 56226.9 |
439 | 2024-04-03 01:29:21 | proprietor | 3 | 140603 | 19 | 6.703 | 20976.1 |
438 | 2024-03-31 13:26:52 | proprietor | 3 | 140603 | 19 | 15.690 | 8961.3 |
437 | 2024-03-31 13:26:19 | proprietor | 5 | 173545 | 543 | 39.236 | 4423.1 |
436 | 2024-03-31 13:26:50 | proprietor | 2 | 108824 | 9 | 7.610 | 14300.1 |
435 | 2024-03-31 13:26:24 | proprietor | 4 | 161450 | 71 | 14.513 | 11124.5 |
434 | 2024-03-31 12:37:57 | proprietor | 1 | 67641 | 4 | 1.106 | 61158.2 |
433 | 2024-03-29 19:52:04 | proprietor | 3 | 140603 | 19 | 23.580 | 5962.8 |
432 | 2024-03-25 19:27:35 | proprietor | 3 | 140603 | 19 | 10.546 | 13332.4 |
431 | 2024-03-25 19:27:31 | proprietor | 2 | 108824 | 9 | 4.610 | 23606.1 |
430 | 2024-03-25 19:25:07 | proprietor | 1 | 67641 | 4 | 1.326 | 51011.3 |
429 | 2024-03-11 11:42:55 | proprietor | 4 | 161450 | 71 | 27.533 | 5863.9 |
428 | 2024-03-10 06:31:55 | proprietor | 4 | 161450 | 71 | 33.096 | 4878.2 |
427 | 2024-03-10 01:08:12 | proprietor | 4 | 161450 | 71 | 32.363 | 4988.7 |
426 | 2024-03-10 01:08:12 | proprietor | 3 | 140603 | 19 | 15.173 | 9266.7 |
425 | 2024-03-10 01:08:13 | proprietor | 2 | 108824 | 9 | 7.266 | 14977.2 |
424 | 2024-03-10 01:03:43 | proprietor | 1 | 67641 | 4 | 2.563 | 26391.3 |
423 | 2024-03-08 21:07:00 | proprietor | 2 | 108824 | 9 | 6.296 | 17284.6 |
422 | 2024-03-08 12:05:03 | proprietor | 5 | 173545 | 543 | 59.940 | 2895.3 |
421 | 2024-03-08 11:07:41 | proprietor | 5 | 173545 | 543 | 56.253 | 3085.1 |
420 | 2024-03-08 10:49:52 | proprietor | 5 | 173545 | 543 | 43.783 | 3963.8 |
419 | 2024-02-28 14:12:59 | proprietor | 1 | 67641 | 4 | 1.156 | 58513.0 |
418 | 2024-02-12 12:02:31 | proprietor | 1 | 67641 | 4 | 3.813 | 17739.6 |
417 | 2024-02-11 02:53:11 | proprietor | 5 | 173545 | 543 | 16.563 | 10477.9 |
416 | 2024-02-09 18:17:54 | proprietor | 1 | 67641 | 4 | 1.220 | 55443.4 |
415 | 2024-02-08 18:38:39 | proprietor | 3 | 140603 | 19 | 14.143 | 9941.5 |
414 | 2024-02-08 18:38:36 | proprietor | 2 | 108824 | 9 | 8.686 | 12528.7 |
413 | 2024-02-08 18:22:53 | proprietor | 1 | 67641 | 4 | 1.330 | 50857.9 |
412 | 2024-02-07 22:23:48 | proprietor | 1 | 67641 | 4 | 1.283 | 52721.0 |
411 | 2024-02-07 14:46:58 | proprietor | 1 | 67641 | 4 | 1.186 | 57032.9 |
410 | 2024-02-05 16:40:37 | proprietor | 1 | 67641 | 4 | 1.233 | 54858.9 |
409 | 2024-01-29 07:02:00 | proprietor | 1 | 67641 | 4 | 1.016 | 66575.8 |
408 | 2024-01-21 06:41:52 | proprietor | 4 | 161450 | 71 | 11.203 | 14411.3 |
407 | 2024-01-18 13:24:33 | proprietor | 5 | 173545 | 543 | 18.330 | 9467.8 |
406 | 2024-01-16 10:02:25 | proprietor | 3 | 140603 | 19 | 6.093 | 23076.2 |
405 | 2024-01-16 10:02:27 | proprietor | 2 | 108824 | 9 | 3.126 | 34812.5 |
404 | 2024-01-12 03:24:39 | proprietor | 4 | 161450 | 71 | 26.126 | 6179.7 |
403 | 2024-01-06 19:56:08 | proprietor | 5 | 173545 | 543 | 18.690 | 9285.4 |
402 | 2024-01-01 03:32:40 | proprietor | 1 | 67641 | 4 | 1.170 | 57812.8 |
401 | 2023-12-28 10:17:15 | proprietor | 5 | 173545 | 543 | 33.566 | 5170.3 |
400 | 2023-11-29 10:16:13 | proprietor | 1 | 67641 | 4 | 1.060 | 63812.3 |
399 | 2023-11-24 10:45:18 | proprietor | 2 | 108824 | 9 | 2.783 | 39103.1 |
398 | 2023-11-16 03:49:03 | proprietor | 1 | 67641 | 4 | 1.203 | 56226.9 |
397 | 2023-11-14 08:51:39 | proprietor | 5 | 173545 | 543 | 16.986 | 10216.9 |
396 | 2023-10-31 02:19:49 | proprietor | 4 | 161450 | 71 | 9.670 | 16696.0 |
395 | 2023-10-25 06:14:03 | proprietor | 1 | 67641 | 4 | 1.076 | 62863.4 |
394 | 2023-10-14 04:39:39 | proprietor | 1 | 67641 | 4 | 1.186 | 57032.9 |
393 | 2023-09-15 17:09:35 | proprietor | 1 | 67641 | 4 | 1.280 | 52844.5 |
392 | 2023-08-24 16:29:07 | proprietor | 2 | 108824 | 9 | 2.766 | 39343.5 |
391 | 2023-08-16 00:22:52 | proprietor | 5 | 173545 | 543 | 15.410 | 11261.8 |
390 | 2023-08-11 09:30:10 | proprietor | 4 | 161450 | 71 | 16.733 | 9648.6 |
389 | 2023-08-09 12:03:17 | proprietor | 1 | 67641 | 4 | 1.030 | 65670.9 |
388 | 2023-06-25 19:55:07 | proprietor | 1 | 67641 | 4 | 1.126 | 60071.9 |
387 | 2023-05-10 03:31:22 | proprietor | 2 | 108824 | 9 | 2.750 | 39572.4 |
386 | 2023-04-28 09:22:22 | proprietor | 5 | 173545 | 543 | 14.893 | 11652.8 |
385 | 2023-04-19 21:34:18 | proprietor | 4 | 161450 | 71 | 10.390 | 15539.0 |
384 | 2023-04-04 15:26:36 | proprietor | 1 | 67641 | 4 | 1.016 | 66575.8 |
383 | 2023-03-26 00:52:29 | proprietor | 1 | 67641 | 4 | 1.030 | 65670.9 |
382 | 2023-02-15 07:21:28 | proprietor | 2 | 108824 | 9 | 2.796 | 38921.3 |
381 | 2023-02-02 15:50:16 | proprietor | 5 | 173545 | 543 | 15.623 | 11108.3 |
380 | 2023-01-20 18:34:35 | proprietor | 4 | 161450 | 71 | 9.593 | 16830.0 |
379 | 2023-01-18 10:49:43 | proprietor | 1 | 67641 | 4 | 1.030 | 65670.9 |
378 | 2022-11-27 18:06:28 | proprietor | 2 | 108824 | 9 | 2.656 | 40972.9 |
377 | 2022-11-17 05:09:51 | proprietor | 5 | 173545 | 543 | 15.080 | 11508.3 |
376 | 2022-11-14 16:20:47 | proprietor | 1 | 67641 | 4 | 1.140 | 59334.2 |
375 | 2022-11-03 11:56:02 | proprietor | 1 | 67641 | 4 | 1.110 | 60937.8 |
374 | 2022-10-31 13:24:40 | proprietor | 4 | 161450 | 71 | 9.736 | 16582.8 |
373 | 2022-07-04 21:18:55 | proprietor | 1 | 67641 | 4 | 1.033 | 65480.2 |
372 | 2022-07-04 13:13:09 | proprietor | 2 | 108824 | 9 | 2.780 | 39145.3 |
371 | 2022-06-19 12:09:36 | proprietor | 5 | 173545 | 543 | 15.096 | 11496.1 |
370 | 2022-06-14 22:07:55 | proprietor | 1 | 67641 | 4 | 1.046 | 64666.3 |
369 | 2022-06-03 01:14:42 | proprietor | 4 | 161450 | 71 | 9.500 | 16994.7 |
368 | 2022-03-06 01:52:29 | proprietor | 1 | 67641 | 4 | 1.016 | 66575.8 |
367 | 2022-03-05 21:26:42 | proprietor | 1 | 67641 | 4 | 1.013 | 66773.0 |
366 | 2022-03-05 08:52:39 | proprietor | 1 | 67641 | 4 | 1.046 | 64666.3 |
365 | 2022-03-03 04:43:15 | proprietor | 1 | 67641 | 4 | 1.110 | 60937.8 |
364 | 2022-02-06 21:40:00 | proprietor | 3 | 140603 | 19 | 6.143 | 22888.3 |
363 | 2022-02-05 17:30:22 | proprietor | 3 | 140603 | 19 | 12.610 | 11150.1 |
362 | 2022-02-04 18:39:28 | proprietor | 3 | 140603 | 19 | 5.893 | 23859.3 |
361 | 2022-02-03 14:43:51 | proprietor | 3 | 140603 | 19 | 6.250 | 22496.5 |
360 | 2022-02-02 11:58:27 | proprietor | 3 | 140603 | 19 | 5.623 | 25005.0 |
359 | 2022-02-01 13:28:33 | proprietor | 3 | 140603 | 19 | 6.830 | 20586.1 |
358 | 2022-01-31 13:38:02 | proprietor | 3 | 140603 | 19 | 6.766 | 20780.8 |
357 | 2022-01-30 19:45:01 | proprietor | 3 | 140603 | 19 | 5.610 | 25062.9 |
356 | 2022-01-29 19:55:51 | proprietor | 3 | 140603 | 19 | 5.783 | 24313.2 |
355 | 2022-01-24 09:45:43 | proprietor | 4 | 161450 | 71 | 11.216 | 14394.6 |