History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stretta"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 212 | 2024-04-13 01:19:56 | stretta | 1 | 69583 | 5 | 1.346 | 51696.1 |
| 211 | 2024-04-08 14:21:02 | stretta | 2 | 107671 | 14 | 8.310 | 12956.8 |
| 210 | 2024-04-08 14:20:35 | stretta | 3 | 134027 | 121 | 8.533 | 15706.9 |
| 209 | 2024-04-07 21:10:38 | stretta | 3 | 134027 | 121 | 22.826 | 5871.7 |
| 208 | 2024-04-06 18:52:07 | stretta | 3 | 134027 | 121 | 11.406 | 11750.6 |
| 207 | 2024-04-05 05:26:45 | stretta | 2 | 107671 | 14 | 8.253 | 13046.3 |
| 206 | 2024-04-04 19:44:57 | stretta | 3 | 134027 | 121 | 20.110 | 6664.7 |
| 205 | 2024-04-04 05:44:07 | stretta | 3 | 134027 | 121 | 15.283 | 8769.7 |
| 204 | 2024-04-04 05:44:08 | stretta | 2 | 107671 | 14 | 4.500 | 23926.9 |
| 203 | 2024-04-04 05:44:00 | stretta | 1 | 69583 | 5 | 1.283 | 54234.6 |
| 202 | 2024-04-04 05:43:48 | stretta | 3 | 134027 | 121 | 8.030 | 16690.8 |
| 201 | 2024-04-04 05:43:51 | stretta | 2 | 107671 | 14 | 3.766 | 28590.3 |
| 200 | 2024-04-04 05:43:35 | stretta | 1 | 69583 | 5 | 2.343 | 29698.3 |
| 199 | 2024-01-11 14:10:51 | stretta | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 198 | 2023-12-31 06:20:36 | stretta | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 197 | 2023-11-20 06:44:06 | stretta | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 196 | 2023-11-19 17:36:58 | stretta | 1 | 69583 | 5 | 1.170 | 59472.6 |
| 195 | 2023-10-19 19:34:10 | stretta | 1 | 69583 | 5 | 1.220 | 57035.2 |
| 194 | 2023-09-29 07:01:59 | stretta | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 193 | 2023-09-23 03:45:52 | stretta | 1 | 69583 | 5 | 1.156 | 60192.9 |
| 192 | 2023-08-15 10:12:15 | stretta | 1 | 69583 | 5 | 1.123 | 61961.7 |
| 191 | 2023-08-01 10:40:38 | stretta | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 190 | 2023-05-15 06:24:48 | stretta | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 189 | 2023-03-02 08:17:45 | stretta | 1 | 69583 | 5 | 1.143 | 60877.5 |
| 188 | 2023-02-26 17:53:29 | stretta | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 187 | 2022-12-31 22:44:38 | stretta | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 186 | 2022-10-05 00:30:06 | stretta | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 185 | 2022-09-22 01:55:41 | stretta | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 184 | 2022-08-28 22:55:00 | stretta | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 183 | 2022-08-18 15:45:43 | stretta | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 182 | 2022-07-26 09:50:43 | stretta | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 181 | 2022-05-03 16:04:39 | stretta | 1 | 69583 | 5 | 1.500 | 46388.7 |
| 180 | 2022-04-29 06:41:02 | stretta | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 179 | 2022-04-26 19:56:45 | stretta | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 178 | 2021-12-05 21:02:06 | stretta | 1 | 69583 | 5 | 1.126 | 61796.6 |
| 177 | 2021-08-02 10:54:05 | stretta | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 176 | 2021-05-08 12:48:01 | stretta | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 175 | 2021-04-27 02:37:31 | stretta | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 174 | 2021-03-11 06:00:35 | stretta | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 173 | 2020-11-11 05:14:55 | stretta | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 172 | 2020-11-02 03:42:22 | stretta | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 171 | 2020-10-27 03:46:51 | stretta | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 170 | 2020-09-23 11:31:36 | stretta | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 169 | 2020-03-30 07:57:04 | stretta | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 168 | 2020-03-29 16:34:57 | stretta | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 167 | 2020-03-28 14:16:58 | stretta | 1 | 69583 | 5 | 1.360 | 51164.0 |
| 166 | 2020-03-21 23:58:07 | stretta | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 165 | 2020-03-01 01:52:15 | stretta | 1 | 69583 | 5 | 1.293 | 53815.2 |
| 164 | 2020-02-26 07:05:15 | stretta | 1 | 69583 | 5 | 2.706 | 25714.3 |
| 163 | 2020-02-20 15:46:22 | stretta | 1 | 69583 | 5 | 1.330 | 52318.0 |
| 162 | 2020-02-17 15:40:56 | stretta | 1 | 69583 | 5 | 1.376 | 50569.0 |
| 161 | 2020-02-15 03:44:06 | stretta | 1 | 69583 | 5 | 1.373 | 50679.5 |
| 160 | 2020-02-02 06:25:46 | stretta | 1 | 69583 | 5 | 2.423 | 28717.7 |
| 159 | 2020-02-01 11:14:48 | stretta | 1 | 69583 | 5 | 1.140 | 61037.7 |
| 158 | 2020-01-23 11:12:18 | stretta | 1 | 69583 | 5 | 1.403 | 49595.9 |
| 157 | 2020-01-22 17:20:05 | stretta | 1 | 69583 | 5 | 2.546 | 27330.3 |
| 156 | 2020-01-22 12:03:39 | stretta | 1 | 69583 | 5 | 2.830 | 24587.6 |
| 155 | 2020-01-17 01:30:41 | stretta | 3 | 134027 | 121 | 9.843 | 13616.5 |
| 154 | 2020-01-17 00:38:48 | stretta | 3 | 134027 | 121 | 6.686 | 20045.9 |
| 153 | 2020-01-16 20:07:06 | stretta | 2 | 107671 | 14 | 4.610 | 23356.0 |
| 152 | 2020-01-16 20:06:50 | stretta | 3 | 134027 | 121 | 10.736 | 12483.9 |
| 151 | 2020-01-16 15:29:22 | stretta | 1 | 69583 | 5 | 1.406 | 49490.0 |
| 150 | 2020-01-11 20:24:51 | stretta | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 149 | 2019-12-31 07:21:57 | stretta | 1 | 69583 | 5 | 1.813 | 38380.0 |
| 148 | 2019-12-30 05:53:46 | stretta | 1 | 69583 | 5 | 2.546 | 27330.3 |
| 147 | 2019-12-19 06:59:02 | stretta | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 146 | 2019-09-18 00:24:47 | stretta | 1 | 69583 | 5 | 0.990 | 70285.9 |
| 145 | 2019-07-23 16:32:39 | stretta | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 144 | 2019-06-12 03:49:42 | stretta | 1 | 69583 | 5 | 1.266 | 54962.9 |
| 143 | 2019-02-21 13:36:32 | stretta | 1 | 69583 | 5 | 1.213 | 57364.4 |
| 142 | 2019-01-28 23:40:19 | stretta | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 141 | 2019-01-27 07:05:18 | stretta | 1 | 69583 | 5 | 1.246 | 55845.1 |
| 140 | 2019-01-25 11:50:53 | stretta | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 139 | 2019-01-21 22:25:47 | stretta | 1 | 69583 | 5 | 1.066 | 65274.9 |
| 138 | 2019-01-16 03:25:56 | stretta | 1 | 69583 | 5 | 1.163 | 59830.6 |
| 137 | 2018-11-20 09:48:40 | stretta | 1 | 69583 | 5 | 2.180 | 31918.8 |
| 136 | 2018-10-29 21:00:08 | stretta | 1 | 69583 | 5 | 1.146 | 60718.2 |
| 135 | 2018-10-08 06:24:43 | stretta | 1 | 69583 | 5 | 1.270 | 54789.8 |
| 134 | 2018-09-16 00:11:56 | stretta | 1 | 69583 | 5 | 1.176 | 59169.2 |
| 133 | 2018-08-26 01:37:57 | stretta | 1 | 69583 | 5 | 1.073 | 64849.0 |
| 132 | 2018-07-22 18:01:31 | stretta | 1 | 69583 | 5 | 1.176 | 59169.2 |
| 131 | 2018-06-25 19:08:09 | stretta | 1 | 69583 | 5 | 1.056 | 65893.0 |
| 130 | 2018-06-25 16:40:31 | stretta | 1 | 69583 | 5 | 1.333 | 52200.3 |
| 129 | 2018-06-25 15:11:35 | stretta | 1 | 69583 | 5 | 1.193 | 58326.1 |
| 128 | 2018-06-25 03:10:37 | stretta | 1 | 69583 | 5 | 1.153 | 60349.5 |
| 127 | 2018-05-04 15:22:40 | stretta | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 126 | 2018-03-21 15:44:52 | stretta | 1 | 69583 | 5 | 2.953 | 23563.5 |
| 125 | 2018-02-26 01:33:53 | stretta | 1 | 69583 | 5 | 3.060 | 22739.5 |
| 124 | 2018-01-30 14:30:00 | stretta | 1 | 69583 | 5 | 1.523 | 45688.1 |
| 123 | 2017-10-30 04:58:16 | stretta | 1 | 69583 | 5 | 1.530 | 45479.1 |
| 122 | 2017-10-24 11:07:52 | stretta | 1 | 69583 | 5 | 2.363 | 29446.9 |
| 121 | 2017-10-21 02:13:53 | stretta | 1 | 69583 | 5 | 1.576 | 44151.6 |
| 120 | 2017-08-22 04:23:30 | stretta | 1 | 69583 | 5 | 1.776 | 39179.6 |
| 119 | 2017-08-03 00:12:52 | stretta | 1 | 69583 | 5 | 1.643 | 42351.2 |
| 118 | 2017-05-17 22:47:39 | stretta | 1 | 69583 | 5 | 1.386 | 50204.2 |
| 117 | 2016-12-04 13:02:12 | stretta | 1 | 69583 | 5 | 2.850 | 24415.1 |
| 116 | 2016-11-28 07:30:37 | stretta | 1 | 69583 | 5 | 1.526 | 45598.3 |
| 115 | 2016-11-27 06:00:10 | stretta | 1 | 69583 | 5 | 1.540 | 45183.8 |
| 114 | 2016-11-26 05:42:22 | stretta | 1 | 69583 | 5 | 1.470 | 47335.4 |
| 113 | 2016-11-26 01:01:09 | stretta | 1 | 69583 | 5 | 1.660 | 41917.5 |