History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"serotypes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
354 | 2025-07-15 15:06:35 | serotypes | 1 | 81242 | 4 | 1.486 | 54671.6 |
353 | 2025-07-15 02:26:14 | serotypes | 4 | 165329 | 338 | 76.660 | 2156.7 |
352 | 2025-07-12 21:29:58 | serotypes | 4 | 165329 | 338 | 33.500 | 4935.2 |
351 | 2025-07-11 18:44:54 | serotypes | 4 | 165329 | 338 | 54.176 | 3051.7 |
350 | 2025-07-10 15:38:57 | serotypes | 1 | 81242 | 4 | 7.423 | 10944.6 |
349 | 2025-07-10 08:56:13 | serotypes | 1 | 81242 | 4 | 7.796 | 10421.0 |
348 | 2025-07-07 04:02:30 | serotypes | 4 | 165329 | 338 | 92.020 | 1796.7 |
347 | 2025-06-23 02:53:42 | serotypes | 1 | 81242 | 4 | 3.406 | 23852.6 |
346 | 2025-06-12 22:25:59 | serotypes | 4 | 165329 | 338 | 13.920 | 11877.1 |
345 | 2025-06-12 20:45:54 | serotypes | 2 | 121436 | 12 | 18.826 | 6450.4 |
344 | 2025-06-12 12:34:45 | serotypes | 4 | 165329 | 338 | 70.300 | 2351.8 |
343 | 2025-06-11 20:38:16 | serotypes | 4 | 165329 | 338 | 67.660 | 2443.5 |
342 | 2025-06-10 18:20:02 | serotypes | 4 | 165329 | 338 | 83.580 | 1978.1 |
341 | 2025-06-10 17:21:32 | serotypes | 2 | 121436 | 12 | 13.453 | 9026.7 |
340 | 2025-06-09 03:59:15 | serotypes | 1 | 81242 | 4 | 1.313 | 61875.1 |
339 | 2025-05-24 07:06:37 | serotypes | 1 | 81242 | 4 | 6.783 | 11977.3 |
338 | 2025-05-23 20:26:41 | serotypes | 3 | 148641 | 55 | 8.216 | 18091.7 |
337 | 2025-05-23 14:45:20 | serotypes | 2 | 121436 | 12 | 19.393 | 6261.8 |
336 | 2025-05-23 13:30:41 | serotypes | 3 | 148641 | 55 | 37.813 | 3930.9 |
335 | 2025-05-22 21:48:44 | serotypes | 1 | 81242 | 4 | 1.470 | 55266.7 |
334 | 2025-05-19 02:13:19 | serotypes | 1 | 81242 | 4 | 9.513 | 8540.1 |
333 | 2025-05-14 20:10:48 | serotypes | 1 | 81242 | 4 | 1.906 | 42624.3 |
332 | 2025-05-14 07:12:34 | serotypes | 1 | 81242 | 4 | 7.063 | 11502.5 |
331 | 2025-05-07 08:07:09 | serotypes | 1 | 81242 | 4 | 1.483 | 54782.2 |
330 | 2025-04-16 03:01:48 | serotypes | 1 | 81242 | 4 | 10.066 | 8070.9 |
329 | 2025-04-11 04:35:02 | serotypes | 1 | 81242 | 4 | 7.140 | 11378.4 |
328 | 2025-04-03 19:18:46 | serotypes | 1 | 81242 | 4 | 3.110 | 26122.8 |
327 | 2025-03-23 12:02:49 | serotypes | 1 | 81242 | 4 | 10.206 | 7960.2 |
326 | 2025-03-06 05:11:22 | serotypes | 3 | 148641 | 55 | 45.390 | 3274.8 |
325 | 2025-03-06 05:11:21 | serotypes | 3 | 148641 | 55 | 31.206 | 4763.2 |
324 | 2025-03-06 05:11:18 | serotypes | 2 | 121436 | 12 | 17.046 | 7124.0 |
323 | 2025-03-06 05:08:33 | serotypes | 1 | 81242 | 4 | 7.500 | 10832.3 |
322 | 2025-03-05 21:21:35 | serotypes | 3 | 148641 | 55 | 51.363 | 2893.9 |
321 | 2025-03-05 21:02:53 | serotypes | 1 | 81242 | 4 | 6.593 | 12322.5 |
320 | 2025-03-05 19:20:31 | serotypes | 3 | 148641 | 55 | 47.283 | 3143.6 |
319 | 2025-03-05 19:20:20 | serotypes | 3 | 148641 | 55 | 56.720 | 2620.6 |
318 | 2025-03-05 19:20:10 | serotypes | 2 | 121436 | 12 | 25.066 | 4844.7 |
317 | 2025-03-05 19:19:03 | serotypes | 1 | 81242 | 4 | 18.610 | 4365.5 |
316 | 2025-03-04 19:20:44 | serotypes | 3 | 148641 | 55 | 42.770 | 3475.4 |
315 | 2025-03-04 18:35:05 | serotypes | 3 | 148641 | 55 | 28.906 | 5142.2 |
314 | 2025-03-04 18:35:04 | serotypes | 2 | 121436 | 12 | 17.453 | 6957.9 |
313 | 2025-03-04 18:32:01 | serotypes | 1 | 81242 | 4 | 4.190 | 19389.5 |
312 | 2025-01-31 07:18:40 | serotypes | 2 | 121436 | 12 | 19.110 | 6354.6 |
311 | 2025-01-31 07:16:52 | serotypes | 1 | 81242 | 4 | 3.313 | 24522.2 |
310 | 2025-01-24 08:00:01 | serotypes | 3 | 148641 | 55 | 39.813 | 3733.5 |
309 | 2025-01-24 07:59:59 | serotypes | 2 | 121436 | 12 | 19.953 | 6086.1 |
308 | 2025-01-24 07:57:47 | serotypes | 1 | 81242 | 4 | 5.080 | 15992.5 |
307 | 2025-01-09 22:21:14 | serotypes | 1 | 81242 | 4 | 3.360 | 24179.2 |
306 | 2025-01-01 21:19:35 | serotypes | 1 | 81242 | 4 | 9.906 | 8201.3 |
305 | 2024-12-30 17:55:47 | serotypes | 1 | 81242 | 4 | 1.453 | 55913.3 |
304 | 2024-12-19 15:59:14 | serotypes | 1 | 81242 | 4 | 8.703 | 9334.9 |
303 | 2024-12-03 06:02:06 | serotypes | 3 | 148641 | 55 | 45.006 | 3302.7 |
302 | 2024-12-03 06:02:10 | serotypes | 2 | 121436 | 12 | 16.283 | 7457.8 |
301 | 2024-12-03 06:02:00 | serotypes | 1 | 81242 | 4 | 6.593 | 12322.5 |
300 | 2024-12-01 17:42:57 | serotypes | 3 | 148641 | 55 | 39.096 | 3801.9 |
299 | 2024-12-01 09:53:28 | serotypes | 3 | 148641 | 55 | 37.426 | 3971.6 |
298 | 2024-12-01 08:36:25 | serotypes | 3 | 148641 | 55 | 34.876 | 4262.0 |
297 | 2024-11-26 10:21:15 | serotypes | 1 | 81242 | 4 | 1.486 | 54671.6 |
296 | 2024-11-25 04:32:29 | serotypes | 1 | 81242 | 4 | 3.670 | 22136.8 |
295 | 2024-11-15 06:09:33 | serotypes | 3 | 148641 | 55 | 32.376 | 4591.1 |
294 | 2024-11-01 18:31:48 | serotypes | 2 | 121436 | 12 | 13.830 | 8780.6 |
293 | 2024-10-29 09:45:08 | serotypes | 3 | 148641 | 55 | 44.676 | 3327.1 |
292 | 2024-10-29 09:45:10 | serotypes | 3 | 148641 | 55 | 22.046 | 6742.3 |
291 | 2024-10-29 09:45:12 | serotypes | 2 | 121436 | 12 | 18.503 | 6563.0 |
290 | 2024-10-29 09:22:19 | serotypes | 1 | 81242 | 4 | 4.093 | 19849.0 |
289 | 2024-10-26 01:01:31 | serotypes | 1 | 81242 | 4 | 6.813 | 11924.6 |
288 | 2024-10-17 18:20:23 | serotypes | 2 | 121436 | 12 | 25.313 | 4797.4 |
287 | 2024-10-17 18:14:17 | serotypes | 1 | 81242 | 4 | 7.253 | 11201.2 |
286 | 2024-10-10 10:20:37 | serotypes | 2 | 121436 | 12 | 17.393 | 6981.9 |
285 | 2024-10-10 09:45:01 | serotypes | 1 | 81242 | 4 | 8.110 | 10017.5 |
284 | 2024-10-09 00:18:47 | serotypes | 2 | 121436 | 12 | 18.783 | 6465.2 |
283 | 2024-09-25 03:18:24 | serotypes | 2 | 121436 | 12 | 44.000 | 2759.9 |
282 | 2024-09-24 13:03:20 | serotypes | 2 | 121436 | 12 | 29.626 | 4099.0 |
281 | 2024-09-24 13:01:37 | serotypes | 1 | 81242 | 4 | 1.533 | 52995.4 |
280 | 2024-09-22 20:46:08 | serotypes | 3 | 148641 | 55 | 80.263 | 1851.9 |
279 | 2024-09-14 10:25:22 | serotypes | 3 | 148641 | 55 | 65.783 | 2259.6 |
278 | 2024-09-12 09:10:36 | serotypes | 1 | 81242 | 4 | 5.423 | 14981.0 |
277 | 2024-09-11 16:53:16 | serotypes | 3 | 148641 | 55 | 29.143 | 5100.4 |
276 | 2024-08-26 04:37:31 | serotypes | 3 | 148641 | 55 | 46.626 | 3187.9 |
275 | 2024-08-23 22:39:06 | serotypes | 3 | 148641 | 55 | 56.990 | 2608.2 |
274 | 2024-08-21 14:46:42 | serotypes | 4 | 165329 | 338 | 69.276 | 2386.5 |
273 | 2024-08-18 07:07:18 | serotypes | 4 | 165329 | 338 | 90.536 | 1826.1 |
272 | 2024-08-09 12:35:06 | serotypes | 3 | 148641 | 55 | 27.750 | 5356.4 |
271 | 2024-08-09 12:35:07 | serotypes | 2 | 121436 | 12 | 20.376 | 5959.8 |
270 | 2024-08-09 12:33:20 | serotypes | 1 | 81242 | 4 | 5.190 | 15653.6 |
269 | 2024-08-09 07:14:31 | serotypes | 4 | 165329 | 338 | 78.863 | 2096.4 |
268 | 2024-08-08 21:00:24 | serotypes | 4 | 165329 | 338 | 28.966 | 5707.7 |
267 | 2024-08-08 14:24:24 | serotypes | 4 | 165329 | 338 | 58.343 | 2833.7 |
266 | 2024-08-08 02:24:44 | serotypes | 4 | 165329 | 338 | 59.176 | 2793.9 |
265 | 2024-08-08 02:24:50 | serotypes | 2 | 121436 | 12 | 19.016 | 6386.0 |
264 | 2024-08-08 02:18:08 | serotypes | 1 | 81242 | 4 | 5.453 | 14898.6 |
263 | 2024-07-31 05:11:40 | serotypes | 1 | 81242 | 4 | 1.533 | 52995.4 |
262 | 2024-07-29 18:47:47 | serotypes | 1 | 81242 | 4 | 8.156 | 9961.0 |
261 | 2024-07-27 19:38:10 | serotypes | 1 | 81242 | 4 | 5.643 | 14397.0 |
260 | 2024-07-24 05:42:16 | serotypes | 3 | 148641 | 55 | 25.440 | 5842.8 |
259 | 2024-07-23 14:50:17 | serotypes | 3 | 148641 | 55 | 37.906 | 3921.3 |
258 | 2024-07-21 15:22:37 | serotypes | 3 | 148641 | 55 | 23.533 | 6316.3 |
257 | 2024-07-15 21:06:20 | serotypes | 3 | 148641 | 55 | 35.233 | 4218.8 |
256 | 2024-07-15 21:06:16 | serotypes | 2 | 121436 | 12 | 20.873 | 5817.9 |
255 | 2024-07-15 21:06:15 | serotypes | 3 | 148641 | 55 | 17.296 | 8594.0 |