History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"visitations"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
336 | 2024-05-03 02:28:38 | visitations | 3 | 121633 | 56 | 15.330 | 7934.3 |
335 | 2024-05-03 01:48:11 | visitations | 1 | 49908 | 2 | 0.813 | 61387.5 |
334 | 2024-05-02 23:12:49 | visitations | 1 | 49908 | 2 | 1.593 | 31329.6 |
333 | 2024-04-24 10:43:09 | visitations | 1 | 49908 | 2 | 2.500 | 19963.2 |
332 | 2024-04-16 11:11:20 | visitations | 2 | 86808 | 7 | 8.813 | 9850.0 |
331 | 2024-04-15 16:24:27 | visitations | 2 | 86808 | 7 | 6.970 | 12454.5 |
330 | 2024-04-15 16:17:20 | visitations | 1 | 49908 | 2 | 1.530 | 32619.6 |
329 | 2024-04-14 12:32:36 | visitations | 3 | 121633 | 56 | 15.826 | 7685.6 |
328 | 2024-04-14 11:43:19 | visitations | 3 | 121633 | 56 | 18.796 | 6471.2 |
327 | 2024-04-14 11:43:21 | visitations | 2 | 86808 | 7 | 8.343 | 10404.9 |
326 | 2024-04-14 11:08:28 | visitations | 1 | 49908 | 2 | 0.703 | 70992.9 |
325 | 2024-04-07 05:37:33 | visitations | 4 | 148819 | 363 | 33.656 | 4421.8 |
324 | 2024-04-06 05:37:53 | visitations | 1 | 49908 | 2 | 0.796 | 62698.5 |
323 | 2024-04-06 02:29:29 | visitations | 4 | 148819 | 363 | 16.003 | 9299.4 |
322 | 2024-04-02 12:04:36 | visitations | 4 | 148819 | 363 | 29.750 | 5002.3 |
321 | 2024-04-02 12:04:36 | visitations | 2 | 86808 | 7 | 8.266 | 10501.8 |
320 | 2024-04-02 12:01:25 | visitations | 1 | 49908 | 2 | 0.906 | 55086.1 |
319 | 2024-03-15 22:21:10 | visitations | 2 | 86808 | 7 | 4.406 | 19702.2 |
318 | 2024-03-14 23:47:19 | visitations | 2 | 86808 | 7 | 5.500 | 15783.3 |
317 | 2024-03-14 23:46:12 | visitations | 1 | 49908 | 2 | 1.813 | 27527.9 |
316 | 2024-03-06 05:00:21 | visitations | 2 | 86808 | 7 | 4.813 | 18036.2 |
315 | 2024-03-06 04:57:35 | visitations | 3 | 121633 | 56 | 12.110 | 10044.0 |
314 | 2024-03-06 04:56:09 | visitations | 1 | 49908 | 2 | 1.780 | 28038.2 |
313 | 2024-03-06 04:48:15 | visitations | 3 | 121633 | 56 | 18.220 | 6675.8 |
312 | 2024-03-05 01:42:24 | visitations | 4 | 148819 | 363 | 22.720 | 6550.1 |
311 | 2024-03-05 01:42:18 | visitations | 2 | 86808 | 7 | 10.860 | 7993.4 |
310 | 2024-03-05 01:42:11 | visitations | 3 | 121633 | 56 | 10.593 | 11482.4 |
309 | 2024-03-05 00:41:06 | visitations | 1 | 49908 | 2 | 1.860 | 26832.3 |
308 | 2024-03-02 10:43:05 | visitations | 4 | 148819 | 363 | 13.843 | 10750.5 |
307 | 2024-03-02 10:43:03 | visitations | 2 | 86808 | 7 | 2.626 | 33057.1 |
306 | 2024-03-02 10:42:32 | visitations | 1 | 49908 | 2 | 1.330 | 37524.8 |
305 | 2024-02-10 21:53:02 | visitations | 1 | 49908 | 2 | 0.923 | 54071.5 |
304 | 2024-02-07 03:58:45 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
303 | 2024-02-04 08:04:34 | visitations | 1 | 49908 | 2 | 2.453 | 20345.7 |
302 | 2024-01-31 06:13:14 | visitations | 1 | 49908 | 2 | 0.750 | 66544.0 |
301 | 2024-01-30 22:45:11 | visitations | 1 | 49908 | 2 | 0.903 | 55269.1 |
300 | 2024-01-21 23:52:52 | visitations | 4 | 148819 | 363 | 9.860 | 15093.2 |
299 | 2024-01-12 17:02:30 | visitations | 3 | 121633 | 56 | 4.266 | 28512.2 |
298 | 2024-01-06 14:47:34 | visitations | 2 | 86808 | 7 | 2.126 | 40831.6 |
297 | 2023-12-23 12:05:35 | visitations | 1 | 49908 | 2 | 0.766 | 65154.0 |
296 | 2023-12-22 16:29:43 | visitations | 4 | 148819 | 363 | 8.906 | 16710.0 |
295 | 2023-12-16 20:26:00 | visitations | 1 | 49908 | 2 | 0.796 | 62698.5 |
294 | 2023-12-13 19:07:50 | visitations | 1 | 49908 | 2 | 0.826 | 60421.3 |
293 | 2023-12-11 15:27:09 | visitations | 1 | 49908 | 2 | 0.733 | 68087.3 |
292 | 2023-12-02 22:46:28 | visitations | 4 | 148819 | 363 | 9.846 | 15114.7 |
291 | 2023-12-01 04:16:01 | visitations | 1 | 49908 | 2 | 0.716 | 69703.9 |
290 | 2023-11-01 16:31:31 | visitations | 4 | 148819 | 363 | 9.013 | 16511.6 |
289 | 2023-10-22 20:35:26 | visitations | 1 | 49908 | 2 | 0.826 | 60421.3 |
288 | 2023-10-21 11:32:55 | visitations | 3 | 121633 | 56 | 4.843 | 25115.2 |
287 | 2023-10-13 02:41:15 | visitations | 2 | 86808 | 7 | 2.326 | 37320.7 |
286 | 2023-10-06 11:35:52 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
285 | 2023-09-24 10:45:54 | visitations | 1 | 49908 | 2 | 1.576 | 31667.5 |
284 | 2023-09-15 17:02:09 | visitations | 1 | 49908 | 2 | 0.703 | 70992.9 |
283 | 2023-08-17 06:49:11 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
282 | 2023-08-13 23:52:28 | visitations | 1 | 49908 | 2 | 0.703 | 70992.9 |
281 | 2023-08-08 17:45:15 | visitations | 4 | 148819 | 363 | 9.203 | 16170.7 |
280 | 2023-08-01 14:38:33 | visitations | 3 | 121633 | 56 | 4.733 | 25698.9 |
279 | 2023-07-22 20:40:19 | visitations | 2 | 86808 | 7 | 2.250 | 38581.3 |
278 | 2023-07-08 23:34:25 | visitations | 1 | 49908 | 2 | 0.813 | 61387.5 |
277 | 2023-04-21 21:35:59 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
276 | 2023-04-19 09:49:24 | visitations | 4 | 148819 | 363 | 7.686 | 19362.3 |
275 | 2023-04-18 07:52:15 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
274 | 2023-04-11 00:33:00 | visitations | 3 | 121633 | 56 | 4.126 | 29479.6 |
273 | 2023-04-05 20:22:27 | visitations | 2 | 86808 | 7 | 3.906 | 22224.3 |
272 | 2023-02-10 03:08:46 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
271 | 2023-01-18 11:30:13 | visitations | 4 | 148819 | 363 | 7.656 | 19438.2 |
270 | 2023-01-17 17:25:27 | visitations | 3 | 121633 | 56 | 4.203 | 28939.6 |
269 | 2023-01-04 01:11:20 | visitations | 2 | 86808 | 7 | 2.313 | 37530.5 |
268 | 2022-12-31 12:46:01 | visitations | 3 | 121633 | 56 | 5.063 | 24023.9 |
267 | 2022-12-18 09:35:36 | visitations | 1 | 49908 | 2 | 0.783 | 63739.5 |
266 | 2022-12-09 10:55:46 | visitations | 3 | 121633 | 56 | 4.690 | 25934.5 |
265 | 2022-12-06 14:59:56 | visitations | 1 | 49908 | 2 | 0.690 | 72330.4 |
264 | 2022-10-31 17:15:16 | visitations | 4 | 148819 | 363 | 8.500 | 17508.1 |
263 | 2022-10-28 20:47:21 | visitations | 4 | 148819 | 363 | 7.703 | 19319.6 |
262 | 2022-10-28 08:31:05 | visitations | 3 | 121633 | 56 | 4.140 | 29380.0 |
261 | 2022-09-11 21:40:41 | visitations | 2 | 86808 | 7 | 2.360 | 36783.1 |
260 | 2022-08-15 00:39:14 | visitations | 1 | 49908 | 2 | 0.736 | 67809.8 |
259 | 2022-08-08 11:20:27 | visitations | 4 | 148819 | 363 | 9.110 | 16335.8 |
258 | 2022-08-06 04:03:40 | visitations | 1 | 49908 | 2 | 0.733 | 68087.3 |
257 | 2022-08-03 18:20:31 | visitations | 1 | 49908 | 2 | 0.736 | 67809.8 |
256 | 2022-07-06 20:30:50 | visitations | 4 | 148819 | 363 | 7.906 | 18823.6 |
255 | 2022-05-30 19:08:35 | visitations | 4 | 148819 | 363 | 8.470 | 17570.1 |
254 | 2022-05-30 04:16:30 | visitations | 3 | 121633 | 56 | 4.156 | 29266.8 |
253 | 2022-04-14 06:52:14 | visitations | 1 | 49908 | 2 | 0.716 | 69703.9 |
252 | 2022-04-12 08:44:50 | visitations | 1 | 49908 | 2 | 1.110 | 44962.2 |
251 | 2022-04-10 18:19:11 | visitations | 1 | 49908 | 2 | 0.733 | 68087.3 |
250 | 2022-04-10 01:44:20 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
249 | 2022-01-11 07:48:30 | visitations | 1 | 49908 | 2 | 0.936 | 53320.5 |
248 | 2021-12-23 08:28:34 | visitations | 1 | 49908 | 2 | 0.750 | 66544.0 |
247 | 2021-12-11 11:46:07 | visitations | 1 | 49908 | 2 | 0.843 | 59202.8 |
246 | 2021-10-30 16:24:34 | visitations | 1 | 49908 | 2 | 0.826 | 60421.3 |
245 | 2021-10-30 09:33:02 | visitations | 1 | 49908 | 2 | 0.813 | 61387.5 |
244 | 2021-10-29 22:53:43 | visitations | 1 | 49908 | 2 | 0.813 | 61387.5 |
243 | 2021-10-29 04:38:56 | visitations | 1 | 49908 | 2 | 0.796 | 62698.5 |
242 | 2021-10-28 22:02:43 | visitations | 1 | 49908 | 2 | 0.720 | 69316.7 |
241 | 2021-10-27 07:09:53 | visitations | 1 | 49908 | 2 | 0.733 | 68087.3 |
240 | 2021-10-04 19:38:34 | visitations | 4 | 148819 | 363 | 9.330 | 15950.6 |
239 | 2021-09-30 23:15:02 | visitations | 4 | 148819 | 363 | 8.203 | 18142.0 |
238 | 2021-09-12 21:59:28 | visitations | 1 | 49908 | 2 | 0.780 | 63984.6 |
237 | 2021-08-14 22:01:39 | visitations | 4 | 148819 | 363 | 8.813 | 16886.3 |