History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
303 | 2024-04-22 05:52:54 | violates | 1 | 82945 | 5 | 1.656 | 50087.6 |
302 | 2024-04-07 18:35:34 | violates | 2 | 121059 | 27 | 3.656 | 33112.4 |
301 | 2024-04-07 18:35:15 | violates | 3 | 146162 | 235 | 8.126 | 17987.0 |
300 | 2024-04-06 10:07:30 | violates | 3 | 146162 | 235 | 24.250 | 6027.3 |
299 | 2024-04-06 10:07:31 | violates | 2 | 121059 | 27 | 12.486 | 9695.6 |
298 | 2024-04-06 10:07:27 | violates | 1 | 82945 | 5 | 3.596 | 23065.9 |
297 | 2024-03-31 18:18:22 | violates | 2 | 121059 | 27 | 7.703 | 15715.8 |
296 | 2024-03-31 18:18:17 | violates | 3 | 146162 | 235 | 10.546 | 13859.5 |
295 | 2024-03-31 18:18:07 | violates | 1 | 82945 | 5 | 3.033 | 27347.5 |
294 | 2024-03-31 18:17:49 | violates | 3 | 146162 | 235 | 8.330 | 17546.5 |
293 | 2024-03-31 13:35:19 | violates | 3 | 146162 | 235 | 22.343 | 6541.7 |
292 | 2024-03-31 13:35:19 | violates | 2 | 121059 | 27 | 4.296 | 28179.5 |
291 | 2024-03-31 12:20:55 | violates | 1 | 82945 | 5 | 1.453 | 57085.3 |
290 | 2024-03-30 03:48:22 | violates | 1 | 82945 | 5 | 4.326 | 19173.6 |
289 | 2024-03-23 02:21:49 | violates | 1 | 82945 | 5 | 1.390 | 59672.7 |
288 | 2024-03-01 15:01:50 | violates | 3 | 146162 | 235 | 13.033 | 11214.8 |
287 | 2024-03-01 00:21:34 | violates | 1 | 82945 | 5 | 1.546 | 53651.4 |
286 | 2024-02-29 09:06:39 | violates | 1 | 82945 | 5 | 1.390 | 59672.7 |
285 | 2024-02-26 14:41:16 | violates | 2 | 121059 | 27 | 3.296 | 36729.1 |
284 | 2024-02-26 14:40:59 | violates | 3 | 146162 | 235 | 7.673 | 19048.9 |
283 | 2024-02-22 05:48:22 | violates | 2 | 121059 | 27 | 3.673 | 32959.2 |
282 | 2024-02-22 02:58:16 | violates | 3 | 146162 | 235 | 13.530 | 10802.8 |
281 | 2024-02-21 22:38:31 | violates | 2 | 121059 | 27 | 3.406 | 35542.9 |
280 | 2024-02-21 20:49:20 | violates | 1 | 82945 | 5 | 1.390 | 59672.7 |
279 | 2024-02-21 14:37:34 | violates | 3 | 146162 | 235 | 14.453 | 10112.9 |
278 | 2024-02-21 06:20:00 | violates | 1 | 82945 | 5 | 3.033 | 27347.5 |
277 | 2024-01-21 11:58:18 | violates | 1 | 82945 | 5 | 1.390 | 59672.7 |
276 | 2024-01-16 00:03:08 | violates | 1 | 82945 | 5 | 1.376 | 60279.8 |
275 | 2023-12-28 00:28:42 | violates | 3 | 146162 | 235 | 6.530 | 22383.2 |
274 | 2023-12-28 00:28:38 | violates | 2 | 121059 | 27 | 3.186 | 37997.2 |
273 | 2023-12-08 15:01:51 | violates | 1 | 82945 | 5 | 1.236 | 67107.6 |
272 | 2023-12-04 16:45:08 | violates | 1 | 82945 | 5 | 1.313 | 63172.1 |
271 | 2023-11-02 21:41:18 | violates | 1 | 82945 | 5 | 1.360 | 60989.0 |
270 | 2023-10-30 08:50:14 | violates | 1 | 82945 | 5 | 1.596 | 51970.6 |
269 | 2023-10-11 21:52:23 | violates | 1 | 82945 | 5 | 1.486 | 55817.6 |
268 | 2023-09-23 09:12:56 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
267 | 2023-09-22 06:53:05 | violates | 1 | 82945 | 5 | 1.330 | 62364.7 |
266 | 2023-09-17 15:32:35 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
265 | 2023-07-14 20:10:56 | violates | 1 | 82945 | 5 | 1.250 | 66356.0 |
264 | 2023-05-18 05:34:39 | violates | 1 | 82945 | 5 | 1.346 | 61623.3 |
263 | 2023-04-17 12:20:30 | violates | 1 | 82945 | 5 | 1.186 | 69936.8 |
262 | 2023-02-09 04:53:27 | violates | 1 | 82945 | 5 | 1.203 | 68948.5 |
261 | 2023-01-17 20:53:57 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
260 | 2022-12-08 11:09:41 | violates | 1 | 82945 | 5 | 1.330 | 62364.7 |
259 | 2022-09-12 03:49:18 | violates | 1 | 82945 | 5 | 1.233 | 67270.9 |
258 | 2022-08-08 16:43:45 | violates | 1 | 82945 | 5 | 1.203 | 68948.5 |
257 | 2022-04-29 05:56:57 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
256 | 2022-03-29 03:08:52 | violates | 1 | 82945 | 5 | 1.406 | 58993.6 |
255 | 2022-01-06 02:46:17 | violates | 1 | 82945 | 5 | 1.483 | 55930.5 |
254 | 2022-01-05 19:19:48 | violates | 1 | 82945 | 5 | 1.500 | 55296.7 |
253 | 2021-11-16 17:27:20 | violates | 1 | 82945 | 5 | 1.250 | 66356.0 |
252 | 2021-10-14 22:21:39 | violates | 1 | 82945 | 5 | 1.233 | 67270.9 |
251 | 2021-10-12 18:06:44 | violates | 1 | 82945 | 5 | 2.516 | 32967.0 |
250 | 2021-10-11 21:02:34 | violates | 1 | 82945 | 5 | 1.453 | 57085.3 |
249 | 2021-10-10 18:00:22 | violates | 1 | 82945 | 5 | 1.266 | 65517.4 |
248 | 2021-09-26 10:39:47 | violates | 1 | 82945 | 5 | 1.236 | 67107.6 |
247 | 2021-09-23 07:38:37 | violates | 1 | 82945 | 5 | 1.360 | 60989.0 |
246 | 2021-09-21 04:39:17 | violates | 1 | 82945 | 5 | 2.546 | 32578.6 |
245 | 2021-09-20 10:12:58 | violates | 1 | 82945 | 5 | 1.953 | 42470.6 |
244 | 2021-09-14 03:47:10 | violates | 1 | 82945 | 5 | 1.343 | 61761.0 |
243 | 2021-07-24 08:49:49 | violates | 1 | 82945 | 5 | 2.720 | 30494.5 |
242 | 2021-06-20 05:14:27 | violates | 1 | 82945 | 5 | 1.356 | 61168.9 |
241 | 2021-06-16 23:38:22 | violates | 1 | 82945 | 5 | 1.420 | 58412.0 |
240 | 2021-05-14 09:34:21 | violates | 1 | 82945 | 5 | 2.453 | 33813.7 |
239 | 2021-04-30 12:10:09 | violates | 1 | 82945 | 5 | 1.420 | 58412.0 |
238 | 2021-04-13 10:13:53 | violates | 1 | 82945 | 5 | 1.393 | 59544.1 |
237 | 2021-03-17 05:21:24 | violates | 1 | 82945 | 5 | 1.233 | 67270.9 |
236 | 2021-03-14 04:33:36 | violates | 1 | 82945 | 5 | 1.233 | 67270.9 |
235 | 2020-11-28 18:20:48 | violates | 1 | 82945 | 5 | 1.373 | 60411.5 |
234 | 2020-11-13 11:31:49 | violates | 1 | 82945 | 5 | 1.326 | 62552.8 |
233 | 2020-11-07 14:15:08 | violates | 1 | 82945 | 5 | 1.326 | 62552.8 |
232 | 2020-11-04 08:59:58 | violates | 1 | 82945 | 5 | 1.483 | 55930.5 |
231 | 2020-10-26 01:17:27 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
230 | 2020-08-12 23:49:56 | violates | 1 | 82945 | 5 | 1.250 | 66356.0 |
229 | 2020-05-08 21:19:08 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
228 | 2020-03-26 00:58:01 | violates | 1 | 82945 | 5 | 1.420 | 58412.0 |
227 | 2020-03-24 07:24:55 | violates | 1 | 82945 | 5 | 2.953 | 28088.4 |
226 | 2020-03-21 23:31:00 | violates | 1 | 82945 | 5 | 1.406 | 58993.6 |
225 | 2020-02-29 04:59:33 | violates | 1 | 82945 | 5 | 1.390 | 59672.7 |
224 | 2020-02-28 10:38:49 | violates | 1 | 82945 | 5 | 3.050 | 27195.1 |
223 | 2020-02-25 10:23:49 | violates | 1 | 82945 | 5 | 1.346 | 61623.3 |
222 | 2020-02-24 11:42:13 | violates | 1 | 82945 | 5 | 1.483 | 55930.5 |
221 | 2020-02-10 00:21:04 | violates | 1 | 82945 | 5 | 1.483 | 55930.5 |
220 | 2020-02-06 07:30:11 | violates | 1 | 82945 | 5 | 1.390 | 59672.7 |
219 | 2020-02-05 11:38:59 | violates | 1 | 82945 | 5 | 1.580 | 52496.8 |
218 | 2020-02-05 10:57:33 | violates | 1 | 82945 | 5 | 1.623 | 51106.0 |
217 | 2020-01-31 09:56:25 | violates | 1 | 82945 | 5 | 1.516 | 54713.1 |
216 | 2020-01-31 07:32:34 | violates | 1 | 82945 | 5 | 1.500 | 55296.7 |
215 | 2020-01-27 22:27:33 | violates | 1 | 82945 | 5 | 1.420 | 58412.0 |
214 | 2020-01-18 11:33:57 | violates | 1 | 82945 | 5 | 3.140 | 26415.6 |
213 | 2020-01-14 11:34:27 | violates | 1 | 82945 | 5 | 1.626 | 51011.7 |
212 | 2020-01-08 20:54:41 | violates | 1 | 82945 | 5 | 1.470 | 56425.2 |
211 | 2020-01-07 06:39:14 | violates | 1 | 82945 | 5 | 1.736 | 47779.4 |
210 | 2020-01-02 13:35:41 | violates | 1 | 82945 | 5 | 3.110 | 26670.4 |
209 | 2019-12-29 07:42:23 | violates | 1 | 82945 | 5 | 3.063 | 27079.7 |
208 | 2019-12-29 02:10:57 | violates | 1 | 82945 | 5 | 1.483 | 55930.5 |
207 | 2019-11-02 13:16:03 | violates | 1 | 82945 | 5 | 1.250 | 66356.0 |
206 | 2019-10-18 07:02:09 | violates | 1 | 82945 | 5 | 1.220 | 67987.7 |
205 | 2019-08-01 09:23:24 | violates | 1 | 82945 | 5 | 1.206 | 68776.9 |
204 | 2019-06-12 06:22:28 | violates | 1 | 82945 | 5 | 1.226 | 67655.0 |