History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thereby"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 147 | 2024-04-30 09:06:00 | thereby | 1 | 69583 | 3 | 1.720 | 40455.2 |
| 146 | 2024-04-27 15:19:36 | thereby | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 145 | 2024-04-19 10:12:57 | thereby | 3 | 134027 | 120 | 9.593 | 13971.3 |
| 144 | 2024-04-09 11:41:58 | thereby | 1 | 69583 | 3 | 2.000 | 34791.5 |
| 143 | 2024-04-04 14:28:59 | thereby | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 142 | 2024-04-01 00:06:31 | thereby | 3 | 134027 | 120 | 8.423 | 15912.0 |
| 141 | 2024-03-31 05:09:30 | thereby | 3 | 134027 | 120 | 13.266 | 10103.0 |
| 140 | 2024-03-31 05:09:28 | thereby | 2 | 107671 | 13 | 10.266 | 10488.1 |
| 139 | 2024-03-31 03:01:29 | thereby | 1 | 69583 | 3 | 1.390 | 50059.7 |
| 138 | 2024-03-04 04:11:55 | thereby | 2 | 107671 | 13 | 11.346 | 9489.8 |
| 137 | 2024-03-04 00:37:58 | thereby | 3 | 134027 | 120 | 7.470 | 17942.0 |
| 136 | 2024-03-01 15:56:44 | thereby | 3 | 134027 | 120 | 10.080 | 13296.3 |
| 135 | 2024-02-28 15:31:28 | thereby | 3 | 134027 | 120 | 27.626 | 4851.5 |
| 134 | 2024-02-28 09:01:55 | thereby | 3 | 134027 | 120 | 23.126 | 5795.5 |
| 133 | 2024-02-28 09:01:54 | thereby | 2 | 107671 | 13 | 15.000 | 7178.1 |
| 132 | 2024-02-28 06:21:50 | thereby | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 131 | 2023-12-24 12:33:26 | thereby | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 130 | 2023-12-15 14:27:45 | thereby | 3 | 134027 | 120 | 7.343 | 18252.3 |
| 129 | 2023-12-03 10:01:19 | thereby | 2 | 107671 | 13 | 3.266 | 32967.2 |
| 128 | 2023-12-03 10:01:14 | thereby | 3 | 134027 | 120 | 6.623 | 20236.6 |
| 127 | 2023-12-02 06:23:52 | thereby | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 126 | 2023-11-20 07:34:57 | thereby | 1 | 69583 | 3 | 1.923 | 36184.6 |
| 125 | 2023-11-10 22:58:04 | thereby | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 124 | 2023-10-12 01:46:50 | thereby | 1 | 69583 | 3 | 1.330 | 52318.0 |
| 123 | 2023-09-24 19:39:07 | thereby | 3 | 134027 | 120 | 6.596 | 20319.4 |
| 122 | 2023-09-23 20:59:03 | thereby | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 121 | 2023-09-20 19:16:26 | thereby | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 120 | 2023-09-16 05:21:58 | thereby | 3 | 134027 | 120 | 5.953 | 22514.2 |
| 119 | 2023-06-21 06:05:27 | thereby | 3 | 134027 | 120 | 5.546 | 24166.4 |
| 118 | 2023-03-17 04:12:10 | thereby | 3 | 134027 | 120 | 5.533 | 24223.2 |
| 117 | 2022-12-18 18:49:00 | thereby | 3 | 134027 | 120 | 5.703 | 23501.1 |
| 116 | 2022-08-27 18:14:07 | thereby | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 115 | 2022-08-14 21:53:16 | thereby | 3 | 134027 | 120 | 5.563 | 24092.6 |
| 114 | 2022-04-10 06:19:02 | thereby | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 113 | 2022-04-08 20:28:37 | thereby | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 112 | 2022-01-08 05:41:56 | thereby | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 111 | 2021-12-25 13:54:46 | thereby | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 110 | 2021-11-06 10:28:19 | thereby | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 109 | 2021-09-28 03:44:15 | thereby | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 108 | 2021-09-26 01:05:21 | thereby | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 107 | 2021-09-08 20:50:49 | thereby | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 106 | 2021-05-30 23:47:51 | thereby | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 105 | 2021-05-05 17:12:32 | thereby | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 104 | 2021-02-12 04:45:26 | thereby | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 103 | 2020-11-06 16:00:18 | thereby | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 102 | 2020-11-06 15:46:13 | thereby | 2 | 107671 | 13 | 2.830 | 38046.3 |
| 101 | 2020-10-30 09:59:11 | thereby | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 100 | 2020-10-29 16:00:49 | thereby | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 99 | 2020-10-04 08:34:47 | thereby | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 98 | 2020-03-28 03:22:50 | thereby | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 97 | 2020-03-28 01:29:35 | thereby | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 96 | 2020-03-21 09:48:29 | thereby | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 95 | 2020-03-13 00:00:52 | thereby | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 94 | 2020-02-28 20:07:07 | thereby | 1 | 69583 | 3 | 2.860 | 24329.7 |
| 93 | 2020-02-26 18:20:44 | thereby | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 92 | 2020-02-25 11:21:23 | thereby | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 91 | 2020-02-19 23:13:57 | thereby | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 90 | 2020-02-10 15:45:10 | thereby | 1 | 69583 | 3 | 2.813 | 24736.2 |
| 89 | 2020-02-01 02:21:04 | thereby | 1 | 69583 | 3 | 2.420 | 28753.3 |
| 88 | 2020-01-28 00:22:12 | thereby | 1 | 69583 | 3 | 2.640 | 26357.2 |
| 87 | 2020-01-27 02:04:42 | thereby | 1 | 69583 | 3 | 1.313 | 52995.4 |
| 86 | 2020-01-25 01:05:29 | thereby | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 85 | 2020-01-23 01:27:54 | thereby | 1 | 69583 | 3 | 1.986 | 35036.8 |
| 84 | 2020-01-13 14:18:22 | thereby | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 83 | 2020-01-12 01:02:17 | thereby | 1 | 69583 | 3 | 1.626 | 42794.0 |
| 82 | 2019-12-31 01:43:57 | thereby | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 81 | 2019-12-25 22:31:07 | thereby | 1 | 69583 | 3 | 1.190 | 58473.1 |
| 80 | 2019-12-04 06:55:13 | thereby | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 79 | 2019-09-10 04:24:11 | thereby | 1 | 69583 | 3 | 0.986 | 70571.0 |
| 78 | 2019-09-02 01:17:26 | thereby | 1 | 69583 | 3 | 1.230 | 56571.5 |
| 77 | 2019-05-27 04:21:19 | thereby | 1 | 69583 | 3 | 1.176 | 59169.2 |
| 76 | 2019-01-29 22:39:45 | thereby | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 75 | 2019-01-04 03:31:40 | thereby | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 74 | 2018-09-23 17:59:59 | thereby | 1 | 69583 | 3 | 1.146 | 60718.2 |
| 73 | 2018-09-19 00:33:49 | thereby | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 72 | 2018-06-26 07:57:21 | thereby | 1 | 69583 | 3 | 1.113 | 62518.4 |
| 71 | 2018-06-24 19:38:47 | thereby | 1 | 69583 | 3 | 1.130 | 61577.9 |
| 70 | 2018-06-24 17:54:08 | thereby | 1 | 69583 | 3 | 1.163 | 59830.6 |
| 69 | 2018-06-24 16:30:52 | thereby | 1 | 69583 | 3 | 1.210 | 57506.6 |
| 68 | 2018-06-23 18:21:15 | thereby | 1 | 69583 | 3 | 1.210 | 57506.6 |
| 67 | 2018-05-18 11:06:12 | thereby | 1 | 69583 | 3 | 1.056 | 65893.0 |
| 66 | 2018-05-12 02:44:58 | thereby | 1 | 69583 | 3 | 1.023 | 68018.6 |
| 65 | 2018-04-17 07:55:21 | thereby | 1 | 69583 | 3 | 1.046 | 66522.9 |
| 64 | 2018-02-14 00:21:59 | thereby | 1 | 69583 | 3 | 1.696 | 41027.7 |
| 63 | 2018-01-01 10:27:32 | thereby | 1 | 69583 | 3 | 1.620 | 42952.5 |
| 62 | 2017-12-11 04:51:15 | thereby | 1 | 69583 | 3 | 1.490 | 46700.0 |
| 61 | 2017-10-28 14:29:39 | thereby | 1 | 69583 | 3 | 1.453 | 47889.2 |
| 60 | 2017-10-28 03:00:40 | thereby | 1 | 69583 | 3 | 1.566 | 44433.6 |
| 59 | 2017-01-10 06:44:26 | thereby | 1 | 69583 | 3 | 1.326 | 52475.9 |
| 58 | 2017-01-04 13:08:53 | thereby | 1 | 69583 | 3 | 1.426 | 48795.9 |
| 57 | 2017-01-03 17:29:13 | thereby | 1 | 69583 | 3 | 1.570 | 44320.4 |
| 56 | 2016-12-26 14:52:22 | thereby | 1 | 69583 | 3 | 1.353 | 51428.7 |
| 55 | 2016-10-17 14:59:15 | thereby | 1 | 69583 | 3 | 1.546 | 45008.4 |
| 54 | 2016-10-13 19:35:51 | thereby | 1 | 69583 | 3 | 1.450 | 47988.3 |
| 53 | 2016-09-17 17:31:03 | thereby | 1 | 69583 | 3 | 1.776 | 39179.6 |
| 52 | 2016-09-15 23:57:37 | thereby | 1 | 69583 | 3 | 1.486 | 46825.7 |
| 51 | 2016-09-05 18:45:05 | thereby | 1 | 69583 | 3 | 3.443 | 20210.0 |
| 50 | 2016-09-02 22:39:16 | thereby | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 49 | 2016-08-30 06:31:52 | thereby | 1 | 69583 | 3 | 1.393 | 49951.9 |
| 48 | 2016-08-05 06:44:40 | thereby | 1 | 69583 | 3 | 1.896 | 36699.9 |