History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"promoter"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
293 | 2024-04-22 23:33:30 | promoter | 1 | 82945 | 6 | 1.563 | 53067.8 |
292 | 2024-04-05 04:30:03 | promoter | 2 | 121059 | 21 | 4.546 | 26629.8 |
291 | 2024-04-03 15:07:09 | promoter | 3 | 146162 | 196 | 12.030 | 12149.8 |
290 | 2024-04-03 15:07:08 | promoter | 2 | 121059 | 21 | 6.160 | 19652.4 |
289 | 2024-04-03 05:48:46 | promoter | 1 | 82945 | 6 | 1.580 | 52496.8 |
288 | 2024-03-31 06:16:28 | promoter | 3 | 146162 | 196 | 23.623 | 6187.3 |
287 | 2024-03-31 06:16:30 | promoter | 2 | 121059 | 21 | 13.236 | 9146.2 |
286 | 2024-03-31 06:06:32 | promoter | 1 | 82945 | 6 | 1.593 | 52068.4 |
285 | 2024-03-18 11:11:01 | promoter | 2 | 121059 | 21 | 3.516 | 34430.9 |
284 | 2024-03-18 11:10:27 | promoter | 3 | 146162 | 196 | 7.813 | 18707.5 |
283 | 2024-03-18 02:55:29 | promoter | 2 | 121059 | 21 | 12.860 | 9413.6 |
282 | 2024-03-18 02:53:32 | promoter | 3 | 146162 | 196 | 8.220 | 17781.3 |
281 | 2024-03-17 01:53:27 | promoter | 2 | 121059 | 21 | 4.703 | 25740.8 |
280 | 2024-03-17 01:53:28 | promoter | 1 | 82945 | 6 | 2.653 | 31264.6 |
279 | 2024-03-17 01:53:13 | promoter | 3 | 146162 | 196 | 7.690 | 19006.8 |
278 | 2024-03-15 22:50:23 | promoter | 3 | 146162 | 196 | 10.530 | 13880.5 |
277 | 2024-03-15 06:43:19 | promoter | 3 | 146162 | 196 | 6.563 | 22270.6 |
276 | 2024-03-07 05:12:22 | promoter | 1 | 82945 | 6 | 3.343 | 24811.5 |
275 | 2024-02-28 13:40:47 | promoter | 1 | 82945 | 6 | 1.470 | 56425.2 |
274 | 2024-02-26 08:14:13 | promoter | 1 | 82945 | 6 | 1.686 | 49196.3 |
273 | 2024-02-07 22:41:05 | promoter | 2 | 121059 | 21 | 8.923 | 13567.1 |
272 | 2024-02-07 22:39:41 | promoter | 3 | 146162 | 196 | 9.143 | 15986.2 |
271 | 2024-02-06 00:50:02 | promoter | 3 | 146162 | 196 | 8.033 | 18195.2 |
270 | 2024-02-06 00:50:06 | promoter | 2 | 121059 | 21 | 4.110 | 29454.7 |
269 | 2024-01-29 12:55:07 | promoter | 2 | 121059 | 21 | 3.860 | 31362.4 |
268 | 2024-01-29 06:34:53 | promoter | 2 | 121059 | 21 | 3.313 | 36540.6 |
267 | 2024-01-28 18:26:43 | promoter | 3 | 146162 | 196 | 7.173 | 20376.7 |
266 | 2024-01-28 18:24:43 | promoter | 2 | 121059 | 21 | 3.530 | 34294.3 |
265 | 2024-01-25 08:14:00 | promoter | 2 | 121059 | 21 | 3.173 | 38152.9 |
264 | 2024-01-16 01:09:36 | promoter | 3 | 146162 | 196 | 8.080 | 18089.4 |
263 | 2024-01-13 09:34:03 | promoter | 1 | 82945 | 6 | 1.280 | 64800.8 |
262 | 2023-12-23 12:34:10 | promoter | 1 | 82945 | 6 | 1.640 | 50576.2 |
261 | 2023-12-06 19:26:08 | promoter | 2 | 121059 | 21 | 3.326 | 36397.8 |
260 | 2023-12-03 00:46:24 | promoter | 2 | 121059 | 21 | 4.093 | 29577.1 |
259 | 2023-11-28 22:39:29 | promoter | 1 | 82945 | 6 | 1.313 | 63172.1 |
258 | 2023-11-24 23:48:13 | promoter | 3 | 146162 | 196 | 7.503 | 19480.5 |
257 | 2023-11-16 17:20:20 | promoter | 1 | 82945 | 6 | 1.313 | 63172.1 |
256 | 2023-11-11 19:02:49 | promoter | 1 | 82945 | 6 | 1.703 | 48705.2 |
255 | 2023-11-06 11:17:05 | promoter | 2 | 121059 | 21 | 7.830 | 15460.9 |
254 | 2023-10-24 23:02:35 | promoter | 1 | 82945 | 6 | 1.343 | 61761.0 |
253 | 2023-10-15 01:49:24 | promoter | 1 | 82945 | 6 | 1.500 | 55296.7 |
252 | 2023-10-10 02:29:31 | promoter | 1 | 82945 | 6 | 1.296 | 64000.8 |
251 | 2023-09-20 08:19:30 | promoter | 1 | 82945 | 6 | 1.280 | 64800.8 |
250 | 2023-08-25 00:30:05 | promoter | 3 | 146162 | 196 | 6.296 | 23215.1 |
249 | 2023-08-10 21:37:01 | promoter | 2 | 121059 | 21 | 3.626 | 33386.4 |
248 | 2023-08-06 01:03:06 | promoter | 1 | 82945 | 6 | 1.266 | 65517.4 |
247 | 2023-06-03 03:45:33 | promoter | 1 | 82945 | 6 | 1.266 | 65517.4 |
246 | 2023-05-30 21:16:49 | promoter | 1 | 82945 | 6 | 1.266 | 65517.4 |
245 | 2023-05-08 06:56:49 | promoter | 3 | 146162 | 196 | 6.203 | 23563.1 |
244 | 2023-05-03 01:15:39 | promoter | 1 | 82945 | 6 | 1.283 | 64649.3 |
243 | 2023-04-24 16:24:06 | promoter | 2 | 121059 | 21 | 5.250 | 23058.9 |
242 | 2023-02-25 05:43:29 | promoter | 1 | 82945 | 6 | 1.283 | 64649.3 |
241 | 2023-02-14 13:17:03 | promoter | 3 | 146162 | 196 | 6.640 | 22012.3 |
240 | 2023-02-11 10:25:45 | promoter | 1 | 82945 | 6 | 1.250 | 66356.0 |
239 | 2023-01-29 08:02:13 | promoter | 2 | 121059 | 21 | 3.596 | 33664.9 |
238 | 2022-11-25 13:55:48 | promoter | 3 | 146162 | 196 | 6.420 | 22766.7 |
237 | 2022-11-11 16:52:30 | promoter | 2 | 121059 | 21 | 3.953 | 30624.6 |
236 | 2022-10-24 22:31:12 | promoter | 1 | 82945 | 6 | 1.390 | 59672.7 |
235 | 2022-07-05 05:08:43 | promoter | 1 | 82945 | 6 | 1.436 | 57761.1 |
234 | 2022-06-13 08:16:36 | promoter | 2 | 121059 | 21 | 3.436 | 35232.5 |
233 | 2022-06-11 04:18:53 | promoter | 2 | 121059 | 21 | 3.190 | 37949.5 |
232 | 2022-04-25 17:07:13 | promoter | 3 | 146162 | 196 | 7.906 | 18487.5 |
231 | 2022-04-15 10:47:53 | promoter | 1 | 82945 | 6 | 1.936 | 42843.5 |
230 | 2022-03-28 04:14:34 | promoter | 1 | 82945 | 6 | 1.313 | 63172.1 |
229 | 2022-02-10 03:10:12 | promoter | 2 | 121059 | 21 | 3.593 | 33693.0 |
228 | 2022-01-13 08:28:47 | promoter | 1 | 82945 | 6 | 1.516 | 54713.1 |
227 | 2022-01-11 05:17:35 | promoter | 1 | 82945 | 6 | 1.780 | 46598.3 |
226 | 2021-12-17 02:53:22 | promoter | 1 | 82945 | 6 | 1.513 | 54821.5 |
225 | 2021-11-23 17:24:26 | promoter | 1 | 82945 | 6 | 1.330 | 62364.7 |
224 | 2021-09-09 21:06:16 | promoter | 1 | 82945 | 6 | 1.483 | 55930.5 |
223 | 2021-06-08 22:57:10 | promoter | 1 | 82945 | 6 | 1.266 | 65517.4 |
222 | 2021-05-28 06:26:53 | promoter | 1 | 82945 | 6 | 1.343 | 61761.0 |
221 | 2021-05-08 12:44:16 | promoter | 1 | 82945 | 6 | 1.470 | 56425.2 |
220 | 2021-03-06 16:21:20 | promoter | 1 | 82945 | 6 | 1.313 | 63172.1 |
219 | 2021-03-05 12:23:16 | promoter | 1 | 82945 | 6 | 1.313 | 63172.1 |
218 | 2020-12-06 12:41:41 | promoter | 1 | 82945 | 6 | 1.293 | 64149.3 |
217 | 2020-11-09 20:24:55 | promoter | 1 | 82945 | 6 | 1.313 | 63172.1 |
216 | 2020-10-31 22:57:06 | promoter | 3 | 146162 | 196 | 6.513 | 22441.6 |
215 | 2020-10-31 04:33:08 | promoter | 1 | 82945 | 6 | 1.343 | 61761.0 |
214 | 2020-10-30 19:43:54 | promoter | 1 | 82945 | 6 | 1.406 | 58993.6 |
213 | 2020-10-27 11:32:04 | promoter | 1 | 82945 | 6 | 1.326 | 62552.8 |
212 | 2020-10-22 04:40:30 | promoter | 1 | 82945 | 6 | 1.346 | 61623.3 |
211 | 2020-08-28 04:42:41 | promoter | 1 | 82945 | 6 | 1.283 | 64649.3 |
210 | 2020-06-11 00:24:15 | promoter | 1 | 82945 | 6 | 1.310 | 63316.8 |
209 | 2020-05-26 14:41:35 | promoter | 1 | 82945 | 6 | 1.296 | 64000.8 |
208 | 2020-03-28 23:53:39 | promoter | 1 | 82945 | 6 | 1.530 | 54212.4 |
207 | 2020-03-25 19:57:54 | promoter | 1 | 82945 | 6 | 1.453 | 57085.3 |
206 | 2020-03-24 14:34:08 | promoter | 1 | 82945 | 6 | 1.500 | 55296.7 |
205 | 2020-03-20 16:42:09 | promoter | 1 | 82945 | 6 | 1.530 | 54212.4 |
204 | 2020-02-27 19:39:58 | promoter | 3 | 146162 | 196 | 8.703 | 16794.4 |
203 | 2020-02-27 15:46:40 | promoter | 3 | 146162 | 196 | 7.703 | 18974.7 |
202 | 2020-02-27 09:21:02 | promoter | 3 | 146162 | 196 | 22.736 | 6428.7 |
201 | 2020-02-26 18:24:48 | promoter | 3 | 146162 | 196 | 15.173 | 9633.0 |
200 | 2020-02-26 05:44:29 | promoter | 3 | 146162 | 196 | 7.736 | 18893.7 |
199 | 2020-02-26 02:06:26 | promoter | 1 | 82945 | 6 | 2.360 | 35146.2 |
198 | 2020-02-25 22:52:44 | promoter | 3 | 146162 | 196 | 13.296 | 10992.9 |
197 | 2020-02-25 15:45:01 | promoter | 3 | 146162 | 196 | 7.033 | 20782.3 |
196 | 2020-02-25 02:12:37 | promoter | 1 | 82945 | 6 | 1.623 | 51106.0 |
195 | 2020-02-23 09:51:36 | promoter | 1 | 82945 | 6 | 1.563 | 53067.8 |
194 | 2020-02-18 09:35:08 | promoter | 1 | 82945 | 6 | 1.390 | 59672.7 |