History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prosects"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
268 | 2024-04-08 07:14:39 | prosects | 1 | 82945 | 5 | 1.453 | 57085.3 |
267 | 2024-03-29 12:32:21 | prosects | 1 | 82945 | 5 | 2.263 | 36652.7 |
266 | 2024-03-01 13:51:57 | prosects | 3 | 146162 | 182 | 9.160 | 15956.6 |
265 | 2024-03-01 01:31:57 | prosects | 1 | 82945 | 5 | 1.533 | 54106.3 |
264 | 2024-02-28 06:16:12 | prosects | 1 | 82945 | 5 | 1.500 | 55296.7 |
263 | 2024-02-27 21:47:15 | prosects | 2 | 121059 | 26 | 4.076 | 29700.4 |
262 | 2024-02-27 21:40:54 | prosects | 3 | 146162 | 182 | 12.016 | 12163.9 |
261 | 2024-02-27 05:10:21 | prosects | 3 | 146162 | 182 | 8.530 | 17135.1 |
260 | 2024-02-27 05:10:10 | prosects | 2 | 121059 | 26 | 4.203 | 28803.0 |
259 | 2024-02-22 15:34:02 | prosects | 2 | 121059 | 26 | 4.093 | 29577.1 |
258 | 2024-01-31 16:36:48 | prosects | 1 | 82945 | 5 | 1.533 | 54106.3 |
257 | 2024-01-22 02:08:06 | prosects | 1 | 82945 | 5 | 1.486 | 55817.6 |
256 | 2023-12-28 11:54:23 | prosects | 3 | 146162 | 182 | 10.563 | 13837.2 |
255 | 2023-12-28 11:54:24 | prosects | 2 | 121059 | 26 | 6.986 | 17328.8 |
254 | 2023-12-22 19:31:14 | prosects | 1 | 82945 | 5 | 1.390 | 59672.7 |
253 | 2023-12-14 11:08:33 | prosects | 1 | 82945 | 5 | 1.326 | 62552.8 |
252 | 2023-12-04 06:44:56 | prosects | 1 | 82945 | 5 | 1.330 | 62364.7 |
251 | 2023-12-04 06:44:54 | prosects | 1 | 82945 | 5 | 1.296 | 64000.8 |
250 | 2023-12-04 06:42:27 | prosects | 1 | 82945 | 5 | 1.766 | 46967.7 |
249 | 2023-11-19 23:59:47 | prosects | 2 | 121059 | 26 | 3.580 | 33815.4 |
248 | 2023-11-18 04:52:19 | prosects | 1 | 82945 | 5 | 1.420 | 58412.0 |
247 | 2023-11-15 23:08:06 | prosects | 1 | 82945 | 5 | 1.406 | 58993.6 |
246 | 2023-11-13 17:05:25 | prosects | 1 | 82945 | 5 | 1.280 | 64800.8 |
245 | 2023-11-05 04:23:17 | prosects | 1 | 82945 | 5 | 1.343 | 61761.0 |
244 | 2023-09-27 21:57:41 | prosects | 1 | 82945 | 5 | 1.516 | 54713.1 |
243 | 2023-09-05 08:25:45 | prosects | 1 | 82945 | 5 | 1.263 | 65673.0 |
242 | 2023-08-20 06:39:38 | prosects | 2 | 121059 | 26 | 3.610 | 33534.3 |
241 | 2023-08-20 03:35:14 | prosects | 1 | 82945 | 5 | 1.310 | 63316.8 |
240 | 2023-08-16 19:04:52 | prosects | 1 | 82945 | 5 | 1.393 | 59544.1 |
239 | 2023-08-10 06:34:27 | prosects | 1 | 82945 | 5 | 2.796 | 29665.6 |
238 | 2023-07-09 22:59:49 | prosects | 1 | 82945 | 5 | 1.280 | 64800.8 |
237 | 2023-06-01 17:29:09 | prosects | 2 | 121059 | 26 | 3.640 | 33258.0 |
236 | 2023-05-06 02:04:09 | prosects | 2 | 121059 | 26 | 3.203 | 37795.5 |
235 | 2023-04-25 00:53:54 | prosects | 1 | 82945 | 5 | 1.266 | 65517.4 |
234 | 2023-04-13 01:55:50 | prosects | 2 | 121059 | 26 | 3.860 | 31362.4 |
233 | 2023-03-04 22:38:05 | prosects | 1 | 82945 | 5 | 1.470 | 56425.2 |
232 | 2023-02-14 08:40:10 | prosects | 2 | 121059 | 26 | 3.156 | 38358.4 |
231 | 2022-12-28 13:16:16 | prosects | 1 | 82945 | 5 | 1.423 | 58288.8 |
230 | 2022-12-21 09:02:51 | prosects | 1 | 82945 | 5 | 1.266 | 65517.4 |
229 | 2022-11-25 02:56:43 | prosects | 2 | 121059 | 26 | 3.830 | 31608.1 |
228 | 2022-09-16 10:11:16 | prosects | 1 | 82945 | 5 | 1.296 | 64000.8 |
227 | 2022-08-14 13:21:25 | prosects | 1 | 82945 | 5 | 1.296 | 64000.8 |
226 | 2022-06-29 18:01:31 | prosects | 1 | 82945 | 5 | 1.280 | 64800.8 |
225 | 2022-04-17 06:34:28 | prosects | 1 | 82945 | 5 | 1.266 | 65517.4 |
224 | 2022-04-16 17:54:33 | prosects | 2 | 121059 | 26 | 3.330 | 36354.1 |
223 | 2022-03-02 12:04:23 | prosects | 1 | 82945 | 5 | 2.000 | 41472.5 |
222 | 2022-02-28 08:06:13 | prosects | 1 | 82945 | 5 | 1.390 | 59672.7 |
221 | 2022-01-06 02:06:01 | prosects | 2 | 121059 | 26 | 3.250 | 37248.9 |
220 | 2021-12-28 05:51:27 | prosects | 1 | 82945 | 5 | 1.453 | 57085.3 |
219 | 2021-12-26 01:27:23 | prosects | 1 | 82945 | 5 | 1.313 | 63172.1 |
218 | 2021-12-10 23:16:35 | prosects | 1 | 82945 | 5 | 1.500 | 55296.7 |
217 | 2021-11-22 21:02:19 | prosects | 2 | 121059 | 26 | 3.750 | 32282.4 |
216 | 2021-11-11 15:54:07 | prosects | 1 | 82945 | 5 | 1.546 | 53651.4 |
215 | 2021-11-05 16:22:41 | prosects | 1 | 82945 | 5 | 1.453 | 57085.3 |
214 | 2021-09-12 11:03:42 | prosects | 1 | 82945 | 5 | 1.360 | 60989.0 |
213 | 2021-07-15 20:07:53 | prosects | 1 | 82945 | 5 | 2.643 | 31382.9 |
212 | 2021-06-12 05:22:09 | prosects | 1 | 82945 | 5 | 1.296 | 64000.8 |
211 | 2021-05-30 10:59:08 | prosects | 1 | 82945 | 5 | 1.343 | 61761.0 |
210 | 2021-05-17 23:06:34 | prosects | 1 | 82945 | 5 | 1.533 | 54106.3 |
209 | 2021-05-05 04:04:12 | prosects | 1 | 82945 | 5 | 1.516 | 54713.1 |
208 | 2021-04-03 06:53:31 | prosects | 1 | 82945 | 5 | 1.436 | 57761.1 |
207 | 2021-03-09 03:55:10 | prosects | 1 | 82945 | 5 | 1.280 | 64800.8 |
206 | 2021-03-07 18:08:11 | prosects | 1 | 82945 | 5 | 1.440 | 57600.7 |
205 | 2021-03-05 22:56:18 | prosects | 1 | 82945 | 5 | 1.453 | 57085.3 |
204 | 2020-12-01 11:15:09 | prosects | 1 | 82945 | 5 | 1.420 | 58412.0 |
203 | 2020-11-10 22:39:08 | prosects | 1 | 82945 | 5 | 1.423 | 58288.8 |
202 | 2020-11-01 01:35:55 | prosects | 1 | 82945 | 5 | 1.423 | 58288.8 |
201 | 2020-10-29 14:47:01 | prosects | 1 | 82945 | 5 | 1.313 | 63172.1 |
200 | 2020-10-27 08:03:26 | prosects | 1 | 82945 | 5 | 1.283 | 64649.3 |
199 | 2020-10-09 21:32:16 | prosects | 1 | 82945 | 5 | 1.436 | 57761.1 |
198 | 2020-08-18 00:08:06 | prosects | 1 | 82945 | 5 | 1.343 | 61761.0 |
197 | 2020-05-07 17:53:11 | prosects | 1 | 82945 | 5 | 1.470 | 56425.2 |
196 | 2020-03-27 06:58:36 | prosects | 1 | 82945 | 5 | 1.640 | 50576.2 |
195 | 2020-03-27 03:44:49 | prosects | 1 | 82945 | 5 | 1.580 | 52496.8 |
194 | 2020-03-21 03:57:55 | prosects | 1 | 82945 | 5 | 1.343 | 61761.0 |
193 | 2020-02-29 23:58:37 | prosects | 1 | 82945 | 5 | 2.516 | 32967.0 |
192 | 2020-02-29 18:58:34 | prosects | 1 | 82945 | 5 | 3.110 | 26670.4 |
191 | 2020-02-18 14:32:45 | prosects | 1 | 82945 | 5 | 1.483 | 55930.5 |
190 | 2020-02-13 05:51:32 | prosects | 1 | 82945 | 5 | 1.483 | 55930.5 |
189 | 2020-02-09 11:07:07 | prosects | 1 | 82945 | 5 | 3.140 | 26415.6 |
188 | 2020-02-07 01:09:13 | prosects | 1 | 82945 | 5 | 3.216 | 25791.4 |
187 | 2020-02-02 06:27:04 | prosects | 1 | 82945 | 5 | 1.563 | 53067.8 |
186 | 2020-01-30 05:38:56 | prosects | 1 | 82945 | 5 | 1.470 | 56425.2 |
185 | 2020-01-30 01:51:18 | prosects | 1 | 82945 | 5 | 1.516 | 54713.1 |
184 | 2020-01-27 06:15:41 | prosects | 1 | 82945 | 5 | 1.516 | 54713.1 |
183 | 2020-01-24 14:16:10 | prosects | 1 | 82945 | 5 | 1.296 | 64000.8 |
182 | 2020-01-23 03:48:30 | prosects | 1 | 82945 | 5 | 3.783 | 21925.7 |
181 | 2020-01-20 23:24:55 | prosects | 1 | 82945 | 5 | 3.220 | 25759.3 |
180 | 2020-01-14 16:44:48 | prosects | 1 | 82945 | 5 | 3.283 | 25265.0 |
179 | 2020-01-09 00:06:48 | prosects | 1 | 82945 | 5 | 1.580 | 52496.8 |
178 | 2020-01-08 22:14:15 | prosects | 1 | 82945 | 5 | 3.343 | 24811.5 |
177 | 2019-12-30 18:05:14 | prosects | 1 | 82945 | 5 | 1.376 | 60279.8 |
176 | 2019-12-29 01:05:32 | prosects | 1 | 82945 | 5 | 1.546 | 53651.4 |
175 | 2019-10-25 21:51:04 | prosects | 1 | 82945 | 5 | 1.360 | 60989.0 |
174 | 2019-07-24 21:04:12 | prosects | 1 | 82945 | 5 | 1.383 | 59974.7 |
173 | 2019-04-20 16:28:14 | prosects | 1 | 82945 | 5 | 1.553 | 53409.5 |
172 | 2019-04-17 11:19:32 | prosects | 1 | 82945 | 5 | 1.440 | 57600.7 |
171 | 2019-01-03 21:37:58 | prosects | 1 | 82945 | 5 | 1.416 | 58577.0 |
170 | 2018-12-28 11:17:40 | prosects | 1 | 82945 | 5 | 1.253 | 66197.1 |
169 | 2018-12-14 02:14:48 | prosects | 1 | 82945 | 5 | 1.280 | 64800.8 |