History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"variants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
286 | 2024-04-05 05:25:04 | variants | 2 | 121059 | 20 | 8.076 | 14990.0 |
285 | 2024-04-05 05:24:57 | variants | 1 | 82945 | 3 | 1.640 | 50576.2 |
284 | 2024-04-01 20:15:48 | variants | 3 | 146162 | 167 | 17.580 | 8314.1 |
283 | 2024-03-31 22:20:06 | variants | 2 | 121059 | 20 | 4.800 | 25220.6 |
282 | 2024-03-31 19:56:16 | variants | 3 | 146162 | 167 | 30.673 | 4765.2 |
281 | 2024-03-30 20:25:18 | variants | 1 | 82945 | 3 | 1.280 | 64800.8 |
280 | 2024-03-30 15:57:08 | variants | 2 | 121059 | 20 | 7.640 | 15845.4 |
279 | 2024-03-30 15:56:35 | variants | 3 | 146162 | 167 | 16.936 | 8630.3 |
278 | 2024-03-30 14:16:48 | variants | 3 | 146162 | 167 | 29.736 | 4915.3 |
277 | 2024-03-30 14:16:48 | variants | 2 | 121059 | 20 | 12.796 | 9460.7 |
276 | 2024-03-30 14:05:18 | variants | 1 | 82945 | 3 | 1.483 | 55930.5 |
275 | 2024-03-28 16:33:01 | variants | 1 | 82945 | 3 | 1.470 | 56425.2 |
274 | 2024-03-09 02:05:41 | variants | 2 | 121059 | 20 | 7.346 | 16479.6 |
273 | 2024-03-09 02:04:59 | variants | 3 | 146162 | 167 | 8.376 | 17450.1 |
272 | 2024-03-07 14:46:35 | variants | 3 | 146162 | 167 | 7.593 | 19249.6 |
271 | 2024-03-07 13:29:32 | variants | 1 | 82945 | 3 | 1.406 | 58993.6 |
270 | 2024-03-05 23:51:44 | variants | 1 | 82945 | 3 | 4.843 | 17126.8 |
269 | 2024-03-01 13:57:16 | variants | 1 | 82945 | 3 | 1.623 | 51106.0 |
268 | 2024-02-29 08:33:56 | variants | 1 | 82945 | 3 | 1.390 | 59672.7 |
267 | 2024-02-09 07:34:14 | variants | 1 | 82945 | 3 | 1.453 | 57085.3 |
266 | 2024-02-04 08:00:52 | variants | 1 | 82945 | 3 | 4.623 | 17941.8 |
265 | 2023-12-28 04:56:42 | variants | 1 | 82945 | 3 | 1.360 | 60989.0 |
264 | 2023-12-21 15:08:22 | variants | 1 | 82945 | 3 | 1.483 | 55930.5 |
263 | 2023-12-08 15:08:48 | variants | 1 | 82945 | 3 | 1.390 | 59672.7 |
262 | 2023-11-05 10:54:50 | variants | 1 | 82945 | 3 | 1.373 | 60411.5 |
261 | 2023-10-31 09:50:22 | variants | 1 | 82945 | 3 | 1.313 | 63172.1 |
260 | 2023-10-20 05:12:33 | variants | 1 | 82945 | 3 | 1.313 | 63172.1 |
259 | 2023-10-14 00:49:44 | variants | 1 | 82945 | 3 | 1.266 | 65517.4 |
258 | 2023-10-08 19:13:18 | variants | 1 | 82945 | 3 | 1.250 | 66356.0 |
257 | 2023-09-27 07:29:39 | variants | 1 | 82945 | 3 | 1.423 | 58288.8 |
256 | 2023-08-05 17:13:21 | variants | 1 | 82945 | 3 | 1.220 | 67987.7 |
255 | 2023-05-28 05:30:16 | variants | 1 | 82945 | 3 | 1.250 | 66356.0 |
254 | 2023-05-24 22:22:15 | variants | 1 | 82945 | 3 | 1.233 | 67270.9 |
253 | 2023-05-03 07:32:01 | variants | 1 | 82945 | 3 | 1.376 | 60279.8 |
252 | 2023-02-25 14:29:18 | variants | 1 | 82945 | 3 | 1.233 | 67270.9 |
251 | 2023-01-21 15:41:16 | variants | 1 | 82945 | 3 | 1.250 | 66356.0 |
250 | 2022-12-22 10:35:32 | variants | 1 | 82945 | 3 | 1.283 | 64649.3 |
249 | 2022-09-12 03:48:59 | variants | 1 | 82945 | 3 | 1.250 | 66356.0 |
248 | 2022-09-07 16:35:37 | variants | 1 | 82945 | 3 | 1.236 | 67107.6 |
247 | 2022-09-04 08:14:46 | variants | 1 | 82945 | 3 | 1.236 | 67107.6 |
246 | 2022-09-02 16:43:57 | variants | 1 | 82945 | 3 | 1.266 | 65517.4 |
245 | 2022-07-15 02:10:51 | variants | 3 | 146162 | 167 | 6.300 | 23200.3 |
244 | 2022-04-25 12:34:40 | variants | 1 | 82945 | 3 | 1.720 | 48223.8 |
243 | 2022-04-16 15:37:24 | variants | 1 | 82945 | 3 | 1.373 | 60411.5 |
242 | 2022-01-10 05:24:09 | variants | 1 | 82945 | 3 | 1.283 | 64649.3 |
241 | 2021-12-30 09:14:15 | variants | 1 | 82945 | 3 | 1.440 | 57600.7 |
240 | 2021-12-17 23:25:42 | variants | 1 | 82945 | 3 | 1.403 | 59119.7 |
239 | 2021-11-06 07:32:48 | variants | 1 | 82945 | 3 | 1.423 | 58288.8 |
238 | 2021-11-04 05:57:38 | variants | 1 | 82945 | 3 | 1.313 | 63172.1 |
237 | 2021-10-06 11:22:19 | variants | 1 | 82945 | 3 | 1.390 | 59672.7 |
236 | 2021-09-27 19:36:46 | variants | 1 | 82945 | 3 | 2.780 | 29836.3 |
235 | 2021-09-26 14:38:55 | variants | 1 | 82945 | 3 | 1.376 | 60279.8 |
234 | 2021-09-22 01:39:28 | variants | 1 | 82945 | 3 | 1.266 | 65517.4 |
233 | 2021-09-13 16:08:48 | variants | 1 | 82945 | 3 | 1.390 | 59672.7 |
232 | 2021-06-09 14:21:22 | variants | 1 | 82945 | 3 | 1.356 | 61168.9 |
231 | 2021-05-26 07:30:32 | variants | 1 | 82945 | 3 | 1.500 | 55296.7 |
230 | 2021-04-30 07:36:57 | variants | 1 | 82945 | 3 | 1.436 | 57761.1 |
229 | 2021-03-29 16:57:34 | variants | 1 | 82945 | 3 | 1.300 | 63803.8 |
228 | 2021-03-23 21:36:41 | variants | 1 | 82945 | 3 | 1.406 | 58993.6 |
227 | 2021-03-10 14:25:03 | variants | 1 | 82945 | 3 | 1.233 | 67270.9 |
226 | 2021-01-13 09:48:19 | variants | 1 | 82945 | 3 | 1.266 | 65517.4 |
225 | 2020-11-24 01:36:41 | variants | 1 | 82945 | 3 | 1.220 | 67987.7 |
224 | 2020-11-01 08:45:38 | variants | 1 | 82945 | 3 | 1.393 | 59544.1 |
223 | 2020-11-01 04:01:20 | variants | 3 | 146162 | 167 | 6.766 | 21602.4 |
222 | 2020-10-28 21:42:44 | variants | 1 | 82945 | 3 | 1.423 | 58288.8 |
221 | 2020-10-14 22:22:53 | variants | 3 | 146162 | 167 | 7.393 | 19770.3 |
220 | 2020-09-30 18:19:57 | variants | 1 | 82945 | 3 | 1.250 | 66356.0 |
219 | 2020-08-31 23:52:41 | variants | 1 | 82945 | 3 | 1.280 | 64800.8 |
218 | 2020-08-27 21:02:30 | variants | 1 | 82945 | 3 | 1.266 | 65517.4 |
217 | 2020-08-24 20:50:28 | variants | 1 | 82945 | 3 | 1.313 | 63172.1 |
216 | 2020-08-20 00:30:43 | variants | 3 | 146162 | 167 | 6.923 | 21112.5 |
215 | 2020-08-20 00:30:29 | variants | 2 | 121059 | 20 | 3.376 | 35858.7 |
214 | 2020-08-17 11:11:25 | variants | 1 | 82945 | 3 | 1.313 | 63172.1 |
213 | 2020-08-07 03:00:32 | variants | 1 | 82945 | 3 | 1.280 | 64800.8 |
212 | 2020-07-29 06:25:27 | variants | 1 | 82945 | 3 | 1.546 | 53651.4 |
211 | 2020-07-24 19:50:31 | variants | 1 | 82945 | 3 | 1.313 | 63172.1 |
210 | 2020-05-05 16:58:21 | variants | 1 | 82945 | 3 | 1.626 | 51011.7 |
209 | 2020-03-29 20:23:38 | variants | 1 | 82945 | 3 | 1.280 | 64800.8 |
208 | 2020-03-25 17:06:35 | variants | 1 | 82945 | 3 | 1.780 | 46598.3 |
207 | 2020-03-23 11:10:58 | variants | 1 | 82945 | 3 | 1.420 | 58412.0 |
206 | 2020-03-21 08:38:33 | variants | 1 | 82945 | 3 | 1.640 | 50576.2 |
205 | 2020-02-29 14:16:17 | variants | 1 | 82945 | 3 | 1.436 | 57761.1 |
204 | 2020-02-26 19:11:53 | variants | 1 | 82945 | 3 | 1.610 | 51518.6 |
203 | 2020-02-23 10:23:03 | variants | 1 | 82945 | 3 | 1.483 | 55930.5 |
202 | 2020-02-21 03:13:04 | variants | 1 | 82945 | 3 | 3.326 | 24938.4 |
201 | 2020-02-11 20:13:48 | variants | 1 | 82945 | 3 | 1.766 | 46967.7 |
200 | 2020-02-07 22:37:19 | variants | 1 | 82945 | 3 | 1.470 | 56425.2 |
199 | 2020-02-07 18:41:05 | variants | 1 | 82945 | 3 | 1.500 | 55296.7 |
198 | 2020-02-03 09:01:11 | variants | 1 | 82945 | 3 | 1.263 | 65673.0 |
197 | 2020-02-01 10:56:39 | variants | 1 | 82945 | 3 | 1.500 | 55296.7 |
196 | 2020-01-31 15:09:22 | variants | 1 | 82945 | 3 | 1.500 | 55296.7 |
195 | 2020-01-31 09:51:23 | variants | 1 | 82945 | 3 | 3.220 | 25759.3 |
194 | 2020-01-26 22:05:16 | variants | 1 | 82945 | 3 | 3.096 | 26791.0 |
193 | 2020-01-21 20:07:48 | variants | 1 | 82945 | 3 | 3.013 | 27529.0 |
192 | 2020-01-19 22:04:53 | variants | 1 | 82945 | 3 | 1.656 | 50087.6 |
191 | 2020-01-15 09:51:35 | variants | 1 | 82945 | 3 | 3.283 | 25265.0 |
190 | 2020-01-07 09:13:09 | variants | 1 | 82945 | 3 | 2.953 | 28088.4 |
189 | 2020-01-02 11:16:36 | variants | 1 | 82945 | 3 | 1.453 | 57085.3 |
188 | 2019-12-29 21:54:54 | variants | 1 | 82945 | 3 | 1.423 | 58288.8 |
187 | 2019-12-29 20:27:21 | variants | 1 | 82945 | 3 | 1.326 | 62552.8 |