History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"midstream"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
378 | 2024-04-28 13:15:58 | midstream | 3 | 148641 | 27 | 23.063 | 6445.0 |
377 | 2024-04-27 21:13:23 | midstream | 4 | 165329 | 141 | 38.470 | 4297.6 |
376 | 2024-04-27 21:13:02 | midstream | 3 | 148641 | 27 | 24.220 | 6137.1 |
375 | 2024-04-27 21:13:11 | midstream | 2 | 121436 | 8 | 10.440 | 11631.8 |
374 | 2024-04-27 18:23:49 | midstream | 1 | 81242 | 2 | 1.393 | 58321.6 |
373 | 2024-04-25 02:15:36 | midstream | 1 | 81242 | 2 | 1.346 | 60358.1 |
372 | 2024-04-17 14:15:23 | midstream | 4 | 165329 | 141 | 27.796 | 5947.9 |
371 | 2024-04-17 13:51:21 | midstream | 1 | 81242 | 2 | 1.373 | 59171.2 |
370 | 2024-04-15 10:25:26 | midstream | 2 | 121436 | 8 | 6.326 | 19196.3 |
369 | 2024-04-15 10:25:00 | midstream | 1 | 81242 | 2 | 1.546 | 52549.8 |
368 | 2024-04-12 23:32:01 | midstream | 1 | 81242 | 2 | 2.873 | 28277.8 |
367 | 2024-04-12 09:33:59 | midstream | 4 | 165329 | 141 | 10.360 | 15958.4 |
366 | 2024-04-04 16:40:19 | midstream | 3 | 148641 | 27 | 20.893 | 7114.4 |
365 | 2024-04-04 13:22:52 | midstream | 2 | 121436 | 8 | 3.046 | 39867.4 |
364 | 2024-04-01 17:40:03 | midstream | 3 | 148641 | 27 | 33.066 | 4495.3 |
363 | 2024-04-01 07:33:20 | midstream | 3 | 148641 | 27 | 12.566 | 11828.8 |
362 | 2024-04-01 07:33:11 | midstream | 2 | 121436 | 8 | 7.513 | 16163.5 |
361 | 2024-04-01 04:56:25 | midstream | 1 | 81242 | 2 | 1.596 | 50903.5 |
360 | 2024-03-27 13:10:16 | midstream | 3 | 148641 | 27 | 17.623 | 8434.5 |
359 | 2024-03-27 13:10:09 | midstream | 2 | 121436 | 8 | 14.656 | 8285.8 |
358 | 2024-03-27 06:07:49 | midstream | 1 | 81242 | 2 | 1.440 | 56418.1 |
357 | 2024-03-25 20:46:57 | midstream | 4 | 165329 | 141 | 30.546 | 5412.5 |
356 | 2024-03-25 20:47:01 | midstream | 3 | 148641 | 27 | 22.470 | 6615.1 |
355 | 2024-03-25 20:47:01 | midstream | 2 | 121436 | 8 | 5.326 | 22800.6 |
354 | 2024-03-25 17:22:40 | midstream | 1 | 81242 | 2 | 1.376 | 59042.2 |
353 | 2024-03-16 16:16:48 | midstream | 1 | 81242 | 2 | 1.563 | 51978.2 |
352 | 2024-03-05 17:33:17 | midstream | 2 | 121436 | 8 | 8.813 | 13779.2 |
351 | 2024-03-05 17:07:40 | midstream | 1 | 81242 | 2 | 1.546 | 52549.8 |
350 | 2024-03-03 13:32:41 | midstream | 1 | 81242 | 2 | 1.423 | 57092.1 |
349 | 2024-03-03 10:49:24 | midstream | 2 | 121436 | 8 | 4.533 | 26789.3 |
348 | 2024-03-03 10:49:18 | midstream | 3 | 148641 | 27 | 7.250 | 20502.2 |
347 | 2024-03-02 04:44:21 | midstream | 3 | 148641 | 27 | 20.096 | 7396.5 |
346 | 2024-03-02 04:44:22 | midstream | 2 | 121436 | 8 | 12.360 | 9824.9 |
345 | 2024-03-02 03:09:48 | midstream | 1 | 81242 | 2 | 3.126 | 25989.1 |
344 | 2024-02-26 05:57:36 | midstream | 4 | 165329 | 141 | 34.770 | 4754.9 |
343 | 2024-02-20 05:52:17 | midstream | 4 | 165329 | 141 | 28.003 | 5904.0 |
342 | 2024-02-20 05:52:19 | midstream | 2 | 121436 | 8 | 8.033 | 15117.1 |
341 | 2024-02-20 04:43:47 | midstream | 3 | 148641 | 27 | 13.156 | 11298.3 |
340 | 2024-02-19 21:51:35 | midstream | 1 | 81242 | 2 | 3.046 | 26671.7 |
339 | 2024-02-18 05:20:29 | midstream | 3 | 148641 | 27 | 26.846 | 5536.8 |
338 | 2024-02-16 03:10:14 | midstream | 3 | 148641 | 27 | 8.623 | 17237.7 |
337 | 2024-02-09 15:57:51 | midstream | 3 | 148641 | 27 | 5.936 | 25040.6 |
336 | 2024-01-29 01:00:19 | midstream | 1 | 81242 | 2 | 1.203 | 67532.8 |
335 | 2024-01-02 22:14:25 | midstream | 1 | 81242 | 2 | 1.483 | 54782.2 |
334 | 2023-12-16 10:07:44 | midstream | 4 | 165329 | 141 | 12.016 | 13759.1 |
333 | 2023-12-16 10:07:46 | midstream | 2 | 121436 | 8 | 3.656 | 33215.5 |
332 | 2023-12-16 10:07:41 | midstream | 3 | 148641 | 27 | 6.343 | 23433.9 |
331 | 2023-12-12 20:21:21 | midstream | 4 | 165329 | 141 | 10.513 | 15726.1 |
330 | 2023-12-12 03:45:19 | midstream | 1 | 81242 | 2 | 1.393 | 58321.6 |
329 | 2023-12-07 19:50:58 | midstream | 2 | 121436 | 8 | 3.623 | 33518.1 |
328 | 2023-11-14 13:40:47 | midstream | 3 | 148641 | 27 | 5.890 | 25236.2 |
327 | 2023-11-12 00:54:55 | midstream | 1 | 81242 | 2 | 1.343 | 60492.9 |
326 | 2023-10-22 23:08:19 | midstream | 1 | 81242 | 2 | 1.360 | 59736.8 |
325 | 2023-09-11 15:51:55 | midstream | 4 | 165329 | 141 | 17.110 | 9662.7 |
324 | 2023-09-09 12:05:37 | midstream | 4 | 165329 | 141 | 10.063 | 16429.4 |
323 | 2023-09-05 03:46:03 | midstream | 2 | 121436 | 8 | 3.016 | 40263.9 |
322 | 2023-08-19 13:59:38 | midstream | 1 | 81242 | 2 | 1.220 | 66591.8 |
321 | 2023-08-15 21:20:21 | midstream | 3 | 148641 | 27 | 6.093 | 24395.4 |
320 | 2023-05-29 23:39:57 | midstream | 4 | 165329 | 141 | 10.033 | 16478.5 |
319 | 2023-05-17 00:59:34 | midstream | 1 | 81242 | 2 | 1.220 | 66591.8 |
318 | 2023-05-16 16:42:30 | midstream | 2 | 121436 | 8 | 3.000 | 40478.7 |
317 | 2023-05-01 19:39:57 | midstream | 3 | 148641 | 27 | 5.953 | 24969.1 |
316 | 2023-04-26 16:12:45 | midstream | 1 | 81242 | 2 | 2.780 | 29223.7 |
315 | 2023-03-21 00:55:01 | midstream | 1 | 81242 | 2 | 1.220 | 66591.8 |
314 | 2023-03-12 21:36:49 | midstream | 1 | 81242 | 2 | 1.376 | 59042.2 |
313 | 2023-03-07 03:01:06 | midstream | 4 | 165329 | 141 | 10.050 | 16450.6 |
312 | 2023-02-22 10:49:23 | midstream | 2 | 121436 | 8 | 3.483 | 34865.3 |
311 | 2023-02-07 06:06:59 | midstream | 3 | 148641 | 27 | 6.123 | 24275.8 |
310 | 2023-01-02 03:07:43 | midstream | 1 | 81242 | 2 | 1.343 | 60492.9 |
309 | 2022-12-13 17:29:15 | midstream | 4 | 165329 | 141 | 12.300 | 13441.4 |
308 | 2022-12-02 14:43:28 | midstream | 2 | 121436 | 8 | 2.966 | 40942.7 |
307 | 2022-11-22 04:44:12 | midstream | 3 | 148641 | 27 | 5.953 | 24969.1 |
306 | 2022-09-21 22:00:09 | midstream | 1 | 81242 | 2 | 1.220 | 66591.8 |
305 | 2022-07-31 02:42:03 | midstream | 4 | 165329 | 141 | 10.330 | 16004.7 |
304 | 2022-07-10 07:09:47 | midstream | 2 | 121436 | 8 | 3.016 | 40263.9 |
303 | 2022-05-03 06:08:07 | midstream | 1 | 81242 | 2 | 1.356 | 59913.0 |
302 | 2022-05-03 01:02:14 | midstream | 3 | 148641 | 27 | 6.953 | 21378.0 |
301 | 2022-04-30 21:05:32 | midstream | 3 | 148641 | 27 | 7.406 | 20070.3 |
300 | 2022-01-24 10:26:26 | midstream | 1 | 81242 | 2 | 1.330 | 61084.2 |
299 | 2022-01-15 14:37:31 | midstream | 3 | 148641 | 27 | 6.233 | 23847.4 |
298 | 2021-12-06 13:37:10 | midstream | 1 | 81242 | 2 | 1.406 | 57782.4 |
297 | 2021-12-04 10:55:06 | midstream | 1 | 81242 | 2 | 1.576 | 51549.5 |
296 | 2021-09-26 20:13:39 | midstream | 1 | 81242 | 2 | 1.220 | 66591.8 |
295 | 2021-08-11 05:40:12 | midstream | 4 | 165329 | 141 | 10.250 | 16129.7 |
294 | 2021-08-08 02:02:07 | midstream | 4 | 165329 | 141 | 10.966 | 15076.5 |
293 | 2021-08-05 09:14:54 | midstream | 4 | 165329 | 141 | 10.640 | 15538.4 |
292 | 2021-08-02 00:26:52 | midstream | 4 | 165329 | 141 | 10.233 | 16156.5 |
291 | 2021-07-04 09:09:10 | midstream | 4 | 165329 | 141 | 15.220 | 10862.6 |
290 | 2021-07-03 22:48:12 | midstream | 4 | 165329 | 141 | 16.686 | 9908.2 |
289 | 2021-07-03 19:56:39 | midstream | 4 | 165329 | 141 | 11.953 | 13831.6 |
288 | 2021-07-02 22:52:04 | midstream | 4 | 165329 | 141 | 11.656 | 14184.0 |
287 | 2021-07-02 11:41:03 | midstream | 4 | 165329 | 141 | 12.466 | 13262.4 |
286 | 2021-07-01 23:40:09 | midstream | 4 | 165329 | 141 | 12.483 | 13244.3 |
285 | 2021-06-30 17:04:29 | midstream | 4 | 165329 | 141 | 11.983 | 13797.0 |
284 | 2021-06-26 17:32:15 | midstream | 4 | 165329 | 141 | 11.360 | 14553.6 |
283 | 2021-06-26 09:00:39 | midstream | 4 | 165329 | 141 | 10.873 | 15205.5 |
282 | 2021-06-25 14:40:33 | midstream | 4 | 165329 | 141 | 12.953 | 12763.8 |
281 | 2021-06-24 10:26:06 | midstream | 4 | 165329 | 141 | 12.830 | 12886.1 |
280 | 2021-06-23 21:28:23 | midstream | 4 | 165329 | 141 | 11.780 | 14034.7 |
279 | 2021-06-23 11:48:01 | midstream | 4 | 165329 | 141 | 11.033 | 14985.0 |