History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sensate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
325 | 2024-04-10 00:36:28 | sensate | 1 | 69583 | 4 | 1.140 | 61037.7 |
324 | 2024-04-06 00:19:42 | sensate | 1 | 69583 | 4 | 3.376 | 20611.1 |
323 | 2024-03-15 16:07:34 | sensate | 1 | 69583 | 4 | 2.563 | 27149.0 |
322 | 2024-02-21 08:13:22 | sensate | 1 | 69583 | 4 | 1.466 | 47464.5 |
321 | 2024-01-17 21:21:32 | sensate | 3 | 134027 | 306 | 6.170 | 21722.4 |
320 | 2023-12-30 09:53:09 | sensate | 3 | 134027 | 306 | 6.046 | 22167.9 |
319 | 2023-12-22 20:56:20 | sensate | 1 | 69583 | 4 | 1.110 | 62687.4 |
318 | 2023-12-22 12:02:48 | sensate | 1 | 69583 | 4 | 1.203 | 57841.2 |
317 | 2023-12-08 14:09:32 | sensate | 1 | 69583 | 4 | 1.250 | 55666.4 |
316 | 2023-12-07 00:23:25 | sensate | 3 | 134027 | 306 | 5.953 | 22514.2 |
315 | 2023-12-07 00:23:19 | sensate | 3 | 134027 | 306 | 5.923 | 22628.2 |
314 | 2023-12-06 00:18:14 | sensate | 3 | 134027 | 306 | 7.500 | 17870.3 |
313 | 2023-12-06 00:18:10 | sensate | 2 | 107671 | 21 | 3.343 | 32207.9 |
312 | 2023-11-20 12:10:54 | sensate | 1 | 69583 | 4 | 1.123 | 61961.7 |
311 | 2023-11-20 02:11:32 | sensate | 1 | 69583 | 4 | 1.110 | 62687.4 |
310 | 2023-11-12 14:47:13 | sensate | 3 | 134027 | 306 | 14.046 | 9542.0 |
309 | 2023-11-10 12:11:57 | sensate | 1 | 69583 | 4 | 1.250 | 55666.4 |
308 | 2023-11-05 11:47:43 | sensate | 1 | 69583 | 4 | 1.346 | 51696.1 |
307 | 2023-10-26 07:13:54 | sensate | 3 | 134027 | 306 | 6.656 | 20136.3 |
306 | 2023-10-09 08:52:13 | sensate | 1 | 69583 | 4 | 1.110 | 62687.4 |
305 | 2023-09-29 10:38:44 | sensate | 1 | 69583 | 4 | 1.220 | 57035.2 |
304 | 2023-09-25 23:40:41 | sensate | 1 | 69583 | 4 | 1.126 | 61796.6 |
303 | 2023-08-09 03:38:28 | sensate | 1 | 69583 | 4 | 1.250 | 55666.4 |
302 | 2023-08-06 06:16:51 | sensate | 1 | 69583 | 4 | 1.140 | 61037.7 |
301 | 2023-08-04 10:28:20 | sensate | 3 | 134027 | 306 | 5.936 | 22578.7 |
300 | 2023-05-06 13:26:23 | sensate | 1 | 69583 | 4 | 1.080 | 64428.7 |
299 | 2023-04-20 11:56:57 | sensate | 1 | 69583 | 4 | 1.076 | 64668.2 |
298 | 2023-04-12 08:04:18 | sensate | 3 | 134027 | 306 | 5.890 | 22755.0 |
297 | 2023-02-28 02:07:30 | sensate | 1 | 69583 | 4 | 1.093 | 63662.4 |
296 | 2023-01-15 06:55:07 | sensate | 3 | 134027 | 306 | 5.890 | 22755.0 |
295 | 2022-12-31 14:48:48 | sensate | 1 | 69583 | 4 | 1.233 | 56433.9 |
294 | 2022-12-30 12:50:33 | sensate | 3 | 134027 | 306 | 5.856 | 22887.1 |
293 | 2022-12-24 16:23:30 | sensate | 1 | 69583 | 4 | 1.093 | 63662.4 |
292 | 2022-11-26 16:55:18 | sensate | 3 | 134027 | 306 | 7.046 | 19021.7 |
291 | 2022-10-15 08:41:47 | sensate | 3 | 134027 | 306 | 5.876 | 22809.2 |
290 | 2022-09-09 18:21:19 | sensate | 1 | 69583 | 4 | 1.110 | 62687.4 |
289 | 2022-09-07 16:05:31 | sensate | 1 | 69583 | 4 | 1.093 | 63662.4 |
288 | 2022-08-24 00:27:39 | sensate | 1 | 69583 | 4 | 1.126 | 61796.6 |
287 | 2022-06-29 01:08:52 | sensate | 2 | 107671 | 21 | 3.190 | 33752.7 |
286 | 2022-05-16 03:34:50 | sensate | 3 | 134027 | 306 | 6.190 | 21652.2 |
285 | 2022-04-23 03:17:13 | sensate | 1 | 69583 | 4 | 1.686 | 41271.1 |
284 | 2022-04-16 11:01:15 | sensate | 1 | 69583 | 4 | 1.280 | 54361.7 |
283 | 2022-01-20 23:53:04 | sensate | 1 | 69583 | 4 | 1.266 | 54962.9 |
282 | 2021-12-31 15:58:26 | sensate | 1 | 69583 | 4 | 1.143 | 60877.5 |
281 | 2021-11-14 13:00:13 | sensate | 1 | 69583 | 4 | 1.326 | 52475.9 |
280 | 2021-10-04 08:29:05 | sensate | 1 | 69583 | 4 | 1.093 | 63662.4 |
279 | 2021-10-02 06:20:50 | sensate | 1 | 69583 | 4 | 1.263 | 55093.4 |
278 | 2021-09-18 03:32:18 | sensate | 1 | 69583 | 4 | 1.093 | 63662.4 |
277 | 2021-06-18 07:13:01 | sensate | 1 | 69583 | 4 | 1.123 | 61961.7 |
276 | 2021-05-19 10:41:32 | sensate | 1 | 69583 | 4 | 1.390 | 50059.7 |
275 | 2021-03-28 19:19:39 | sensate | 1 | 69583 | 4 | 1.126 | 61796.6 |
274 | 2021-03-19 02:10:56 | sensate | 1 | 69583 | 4 | 1.140 | 61037.7 |
273 | 2021-03-02 20:57:34 | sensate | 1 | 69583 | 4 | 1.170 | 59472.6 |
272 | 2021-02-18 14:05:53 | sensate | 1 | 69583 | 4 | 1.796 | 38743.3 |
271 | 2020-12-16 05:04:04 | sensate | 1 | 69583 | 4 | 1.126 | 61796.6 |
270 | 2020-12-13 15:48:05 | sensate | 1 | 69583 | 4 | 1.140 | 61037.7 |
269 | 2020-11-06 02:19:36 | sensate | 1 | 69583 | 4 | 1.220 | 57035.2 |
268 | 2020-10-31 04:11:33 | sensate | 1 | 69583 | 4 | 1.343 | 51811.6 |
267 | 2020-10-22 16:24:12 | sensate | 1 | 69583 | 4 | 1.330 | 52318.0 |
266 | 2020-10-22 03:34:11 | sensate | 1 | 69583 | 4 | 1.126 | 61796.6 |
265 | 2020-10-17 20:47:59 | sensate | 1 | 69583 | 4 | 1.186 | 58670.3 |
264 | 2020-09-15 19:12:58 | sensate | 1 | 69583 | 4 | 1.093 | 63662.4 |
263 | 2020-09-08 16:43:49 | sensate | 1 | 69583 | 4 | 1.106 | 62914.1 |
262 | 2020-07-22 09:41:58 | sensate | 1 | 69583 | 4 | 1.280 | 54361.7 |
261 | 2020-07-14 02:29:48 | sensate | 1 | 69583 | 4 | 1.203 | 57841.2 |
260 | 2020-06-03 14:38:13 | sensate | 1 | 69583 | 4 | 1.173 | 59320.5 |
259 | 2020-04-12 21:17:28 | sensate | 1 | 69583 | 4 | 1.296 | 53690.6 |
258 | 2020-03-29 14:31:38 | sensate | 1 | 69583 | 4 | 1.250 | 55666.4 |
257 | 2020-03-25 07:45:24 | sensate | 1 | 69583 | 4 | 1.750 | 39761.7 |
256 | 2020-03-24 15:31:18 | sensate | 1 | 69583 | 4 | 1.186 | 58670.3 |
255 | 2020-03-20 21:44:03 | sensate | 1 | 69583 | 4 | 1.343 | 51811.6 |
254 | 2020-03-01 02:36:34 | sensate | 1 | 69583 | 4 | 1.343 | 51811.6 |
253 | 2020-02-27 15:51:55 | sensate | 3 | 134027 | 306 | 8.703 | 15400.1 |
252 | 2020-02-27 10:57:15 | sensate | 3 | 134027 | 306 | 8.330 | 16089.7 |
251 | 2020-02-27 09:28:23 | sensate | 3 | 134027 | 306 | 6.186 | 21666.2 |
250 | 2020-02-25 16:37:44 | sensate | 1 | 69583 | 4 | 1.843 | 37755.3 |
249 | 2020-02-25 01:36:27 | sensate | 1 | 69583 | 4 | 1.266 | 54962.9 |
248 | 2020-02-17 15:03:18 | sensate | 3 | 134027 | 306 | 15.126 | 8860.7 |
247 | 2020-02-17 12:54:21 | sensate | 3 | 134027 | 306 | 9.143 | 14659.0 |
246 | 2020-02-17 11:22:27 | sensate | 3 | 134027 | 306 | 8.766 | 15289.4 |
245 | 2020-02-17 04:33:23 | sensate | 3 | 134027 | 306 | 16.406 | 8169.4 |
244 | 2020-02-10 17:07:38 | sensate | 1 | 69583 | 4 | 4.330 | 16070.0 |
243 | 2020-02-08 01:50:28 | sensate | 1 | 69583 | 4 | 1.950 | 35683.6 |
242 | 2020-02-07 18:56:37 | sensate | 1 | 69583 | 4 | 1.310 | 53116.8 |
241 | 2020-02-05 23:21:21 | sensate | 1 | 69583 | 4 | 4.373 | 15912.0 |
240 | 2020-02-05 18:58:41 | sensate | 1 | 69583 | 4 | 2.563 | 27149.0 |
239 | 2020-02-04 20:02:59 | sensate | 1 | 69583 | 4 | 4.420 | 15742.8 |
238 | 2020-01-31 07:45:43 | sensate | 1 | 69583 | 4 | 1.266 | 54962.9 |
237 | 2020-01-17 20:51:25 | sensate | 1 | 69583 | 4 | 2.186 | 31831.2 |
236 | 2020-01-16 11:22:46 | sensate | 1 | 69583 | 4 | 2.873 | 24219.6 |
235 | 2020-01-14 11:10:13 | sensate | 3 | 134027 | 306 | 8.983 | 14920.1 |
234 | 2020-01-14 11:05:52 | sensate | 3 | 134027 | 306 | 16.296 | 8224.5 |
233 | 2020-01-14 04:27:53 | sensate | 2 | 107671 | 21 | 4.096 | 26286.9 |
232 | 2020-01-14 04:27:29 | sensate | 3 | 134027 | 306 | 8.016 | 16719.9 |
231 | 2020-01-13 21:20:20 | sensate | 1 | 69583 | 4 | 2.190 | 31773.1 |
230 | 2020-01-08 20:46:09 | sensate | 1 | 69583 | 4 | 1.296 | 53690.6 |
229 | 2020-01-07 22:39:45 | sensate | 1 | 69583 | 4 | 2.813 | 24736.2 |
228 | 2019-12-29 04:28:29 | sensate | 1 | 69583 | 4 | 1.296 | 53690.6 |
227 | 2019-12-28 20:19:26 | sensate | 1 | 69583 | 4 | 1.330 | 52318.0 |
226 | 2019-12-26 22:31:55 | sensate | 1 | 69583 | 4 | 1.343 | 51811.6 |