History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
318 | 2025-06-28 14:26:45 | violation | 1 | 81242 | 2 | 8.640 | 9403.0 |
317 | 2025-06-26 11:30:05 | violation | 1 | 81242 | 2 | 10.063 | 8073.3 |
316 | 2025-06-16 15:39:19 | violation | 1 | 81242 | 2 | 3.170 | 25628.4 |
315 | 2025-06-16 00:50:35 | violation | 1 | 81242 | 2 | 9.470 | 8578.9 |
314 | 2025-06-14 07:27:59 | violation | 1 | 81242 | 2 | 9.420 | 8624.4 |
313 | 2025-06-08 07:17:58 | violation | 1 | 81242 | 2 | 5.436 | 14945.2 |
312 | 2025-05-31 11:11:13 | violation | 1 | 81242 | 2 | 2.830 | 28707.4 |
311 | 2025-05-26 14:31:49 | violation | 1 | 81242 | 2 | 4.016 | 20229.6 |
310 | 2025-05-14 15:38:30 | violation | 1 | 81242 | 2 | 9.173 | 8856.6 |
309 | 2025-05-06 07:55:40 | violation | 1 | 81242 | 2 | 6.826 | 11901.8 |
308 | 2025-05-06 05:22:50 | violation | 2 | 121436 | 17 | 20.126 | 6033.8 |
307 | 2025-05-05 00:07:09 | violation | 1 | 81242 | 2 | 3.076 | 26411.6 |
306 | 2025-04-26 10:36:34 | violation | 1 | 81242 | 2 | 6.186 | 13133.2 |
305 | 2025-04-25 11:51:49 | violation | 3 | 148641 | 132 | 55.396 | 2683.2 |
304 | 2025-04-24 14:52:34 | violation | 3 | 148641 | 132 | 19.206 | 7739.3 |
303 | 2025-04-21 06:27:04 | violation | 3 | 148641 | 132 | 43.173 | 3442.9 |
302 | 2025-04-20 19:28:59 | violation | 2 | 121436 | 17 | 13.393 | 9067.1 |
301 | 2025-04-18 12:35:19 | violation | 3 | 148641 | 132 | 32.720 | 4542.8 |
300 | 2025-04-18 07:00:31 | violation | 1 | 81242 | 2 | 7.470 | 10875.8 |
299 | 2025-04-17 23:17:10 | violation | 2 | 121436 | 17 | 13.826 | 8783.2 |
298 | 2025-04-17 16:11:43 | violation | 1 | 81242 | 2 | 1.220 | 66591.8 |
297 | 2025-03-29 17:40:01 | violation | 1 | 81242 | 2 | 6.250 | 12998.7 |
296 | 2025-03-23 12:04:04 | violation | 1 | 81242 | 2 | 9.453 | 8594.3 |
295 | 2025-03-18 00:59:29 | violation | 2 | 121436 | 17 | 17.313 | 7014.2 |
294 | 2025-03-13 22:57:22 | violation | 3 | 148641 | 132 | 34.473 | 4311.8 |
293 | 2025-03-13 22:57:20 | violation | 2 | 121436 | 17 | 16.860 | 7202.6 |
292 | 2025-03-13 22:55:34 | violation | 1 | 81242 | 2 | 4.063 | 19995.6 |
291 | 2025-03-07 06:35:45 | violation | 1 | 81242 | 2 | 6.876 | 11815.3 |
290 | 2025-03-05 22:34:00 | violation | 3 | 148641 | 132 | 49.690 | 2991.4 |
289 | 2025-03-05 21:45:47 | violation | 1 | 81242 | 2 | 7.110 | 11426.4 |
288 | 2025-03-04 07:34:44 | violation | 3 | 148641 | 132 | 27.440 | 5416.9 |
287 | 2025-03-04 07:34:30 | violation | 2 | 121436 | 17 | 17.643 | 6883.0 |
286 | 2025-03-04 07:30:37 | violation | 1 | 81242 | 2 | 3.170 | 25628.4 |
285 | 2025-03-04 04:18:45 | violation | 3 | 148641 | 132 | 53.283 | 2789.7 |
284 | 2025-03-04 00:36:28 | violation | 3 | 148641 | 132 | 28.720 | 5175.5 |
283 | 2025-03-04 00:36:27 | violation | 2 | 121436 | 17 | 11.423 | 10630.8 |
282 | 2025-03-04 00:35:41 | violation | 1 | 81242 | 2 | 4.000 | 20310.5 |
281 | 2025-02-02 02:10:22 | violation | 1 | 81242 | 2 | 4.673 | 17385.4 |
280 | 2025-01-28 19:59:21 | violation | 3 | 148641 | 132 | 32.546 | 4567.1 |
279 | 2025-01-27 11:55:54 | violation | 3 | 148641 | 132 | 40.423 | 3677.1 |
278 | 2025-01-27 11:55:44 | violation | 2 | 121436 | 17 | 15.453 | 7858.4 |
277 | 2025-01-26 22:30:24 | violation | 1 | 81242 | 2 | 6.063 | 13399.6 |
276 | 2025-01-26 16:21:16 | violation | 3 | 148641 | 132 | 29.940 | 4964.6 |
275 | 2025-01-26 16:21:10 | violation | 2 | 121436 | 17 | 12.343 | 9838.5 |
274 | 2025-01-21 02:32:53 | violation | 1 | 81242 | 2 | 9.890 | 8214.6 |
273 | 2024-12-30 00:28:29 | violation | 1 | 81242 | 2 | 5.046 | 16100.3 |
272 | 2024-12-19 08:48:34 | violation | 3 | 148641 | 132 | 30.516 | 4870.9 |
271 | 2024-12-18 12:25:37 | violation | 3 | 148641 | 132 | 34.266 | 4337.9 |
270 | 2024-12-17 23:52:53 | violation | 2 | 121436 | 17 | 18.016 | 6740.5 |
269 | 2024-12-17 23:52:52 | violation | 3 | 148641 | 132 | 18.643 | 7973.0 |
268 | 2024-12-17 22:01:23 | violation | 1 | 81242 | 2 | 3.750 | 21664.5 |
267 | 2024-12-15 12:58:19 | violation | 1 | 81242 | 2 | 4.843 | 16775.1 |
266 | 2024-12-11 21:07:50 | violation | 1 | 81242 | 2 | 6.406 | 12682.2 |
265 | 2024-11-26 08:07:29 | violation | 1 | 81242 | 2 | 6.300 | 12895.6 |
264 | 2024-11-13 00:42:08 | violation | 1 | 81242 | 2 | 6.983 | 11634.3 |
263 | 2024-11-11 15:49:25 | violation | 1 | 81242 | 2 | 6.500 | 12498.8 |
262 | 2024-11-10 10:13:46 | violation | 2 | 121436 | 17 | 18.783 | 6465.2 |
261 | 2024-11-09 23:54:16 | violation | 1 | 81242 | 2 | 1.500 | 54161.3 |
260 | 2024-10-27 04:32:05 | violation | 3 | 148641 | 132 | 26.580 | 5592.2 |
259 | 2024-10-26 21:35:05 | violation | 3 | 148641 | 132 | 18.813 | 7901.0 |
258 | 2024-10-26 21:23:21 | violation | 1 | 81242 | 2 | 7.126 | 11400.8 |
257 | 2024-10-24 12:00:12 | violation | 2 | 121436 | 17 | 17.330 | 7007.3 |
256 | 2024-10-15 07:58:45 | violation | 2 | 121436 | 17 | 17.236 | 7045.5 |
255 | 2024-10-13 14:18:28 | violation | 2 | 121436 | 17 | 16.140 | 7523.9 |
254 | 2024-10-10 14:19:54 | violation | 1 | 81242 | 2 | 3.563 | 22801.6 |
253 | 2024-10-09 20:51:56 | violation | 1 | 81242 | 2 | 7.376 | 11014.4 |
252 | 2024-10-09 16:27:44 | violation | 2 | 121436 | 17 | 23.063 | 5265.4 |
251 | 2024-10-09 16:02:04 | violation | 1 | 81242 | 2 | 1.423 | 57092.1 |
250 | 2024-09-20 23:15:20 | violation | 3 | 148641 | 132 | 49.550 | 2999.8 |
249 | 2024-09-15 03:12:17 | violation | 3 | 148641 | 132 | 19.266 | 7715.2 |
248 | 2024-09-14 06:12:13 | violation | 3 | 148641 | 132 | 42.486 | 3498.6 |
247 | 2024-09-08 22:39:01 | violation | 3 | 148641 | 132 | 54.783 | 2713.3 |
246 | 2024-09-08 22:39:12 | violation | 2 | 121436 | 17 | 25.753 | 4715.4 |
245 | 2024-09-08 22:28:32 | violation | 1 | 81242 | 2 | 9.233 | 8799.1 |
244 | 2024-09-05 06:22:07 | violation | 1 | 81242 | 2 | 11.830 | 6867.5 |
243 | 2024-08-27 01:26:06 | violation | 1 | 81242 | 2 | 9.843 | 8253.8 |
242 | 2024-08-09 10:54:30 | violation | 1 | 81242 | 2 | 6.610 | 12290.8 |
241 | 2024-08-08 17:14:08 | violation | 1 | 81242 | 2 | 4.423 | 18368.1 |
240 | 2024-07-29 03:12:06 | violation | 1 | 81242 | 2 | 1.483 | 54782.2 |
239 | 2024-07-25 00:01:44 | violation | 2 | 121436 | 17 | 11.800 | 10291.2 |
238 | 2024-07-24 03:00:31 | violation | 1 | 81242 | 2 | 5.216 | 15575.5 |
237 | 2024-07-23 04:11:11 | violation | 3 | 148641 | 132 | 20.610 | 7212.1 |
236 | 2024-07-23 00:25:59 | violation | 3 | 148641 | 132 | 25.800 | 5761.3 |
235 | 2024-07-22 20:37:50 | violation | 3 | 148641 | 132 | 13.500 | 11010.4 |
234 | 2024-07-22 20:37:32 | violation | 2 | 121436 | 17 | 17.686 | 6866.2 |
233 | 2024-07-22 20:31:52 | violation | 1 | 81242 | 2 | 1.343 | 60492.9 |
232 | 2024-07-22 20:27:34 | violation | 3 | 148641 | 132 | 25.643 | 5796.6 |
231 | 2024-07-21 19:14:10 | violation | 3 | 148641 | 132 | 25.533 | 5821.5 |
230 | 2024-07-21 19:14:13 | violation | 2 | 121436 | 17 | 13.343 | 9101.1 |
229 | 2024-07-20 07:15:40 | violation | 1 | 81242 | 2 | 2.576 | 31538.0 |
228 | 2024-07-02 21:33:51 | violation | 1 | 81242 | 2 | 4.126 | 19690.3 |
227 | 2024-06-10 13:24:34 | violation | 3 | 148641 | 132 | 34.423 | 4318.1 |
226 | 2024-06-09 21:26:31 | violation | 3 | 148641 | 132 | 40.050 | 3711.4 |
225 | 2024-06-09 21:26:27 | violation | 2 | 121436 | 17 | 19.613 | 6191.6 |
224 | 2024-06-09 06:46:54 | violation | 3 | 148641 | 132 | 39.673 | 3746.7 |
223 | 2024-06-09 05:50:05 | violation | 2 | 121436 | 17 | 8.420 | 14422.3 |
222 | 2024-06-09 05:49:59 | violation | 3 | 148641 | 132 | 13.846 | 10735.3 |
221 | 2024-06-09 05:43:35 | violation | 1 | 81242 | 2 | 4.563 | 17804.5 |
220 | 2024-06-08 21:15:07 | violation | 3 | 148641 | 132 | 35.456 | 4192.3 |
219 | 2024-06-08 21:15:09 | violation | 2 | 121436 | 17 | 15.236 | 7970.3 |