History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rurban"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
325 | 2024-05-07 11:49:21 | rurban | 2 | 82551 | 20 | 3.250 | 25400.3 |
324 | 2024-05-02 01:58:30 | rurban | 1 | 48755 | 3 | 0.953 | 51159.5 |
323 | 2024-05-01 16:43:35 | rurban | 2 | 82551 | 20 | 2.923 | 28241.9 |
322 | 2024-05-01 16:43:30 | rurban | 3 | 112716 | 298 | 6.626 | 17011.2 |
321 | 2024-05-01 16:43:28 | rurban | 2 | 82551 | 20 | 4.626 | 17845.0 |
320 | 2024-05-01 16:43:27 | rurban | 1 | 48755 | 3 | 1.033 | 47197.5 |
319 | 2024-05-01 16:43:09 | rurban | 3 | 112716 | 298 | 6.500 | 17340.9 |
318 | 2024-04-30 06:36:29 | rurban | 3 | 112716 | 298 | 18.393 | 6128.2 |
317 | 2024-04-16 13:52:49 | rurban | 3 | 112716 | 298 | 10.953 | 10290.9 |
316 | 2024-04-06 00:51:41 | rurban | 1 | 48755 | 3 | 2.233 | 21833.9 |
315 | 2024-03-31 14:29:12 | rurban | 1 | 48755 | 3 | 0.983 | 49598.2 |
314 | 2024-03-29 09:14:25 | rurban | 1 | 48755 | 3 | 1.936 | 25183.4 |
313 | 2024-03-04 07:06:54 | rurban | 1 | 48755 | 3 | 2.173 | 22436.7 |
312 | 2024-02-28 04:50:12 | rurban | 1 | 48755 | 3 | 2.873 | 16970.1 |
311 | 2024-01-30 16:11:08 | rurban | 1 | 48755 | 3 | 0.813 | 59969.2 |
310 | 2024-01-02 23:43:04 | rurban | 2 | 82551 | 20 | 2.516 | 32810.4 |
309 | 2023-12-29 21:39:14 | rurban | 3 | 112716 | 298 | 5.436 | 20735.1 |
308 | 2023-12-29 21:39:12 | rurban | 2 | 82551 | 20 | 2.530 | 32628.9 |
307 | 2023-12-13 20:28:24 | rurban | 3 | 112716 | 298 | 5.673 | 19868.9 |
306 | 2023-12-05 00:32:07 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
305 | 2023-11-29 16:36:39 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
304 | 2023-11-25 04:30:29 | rurban | 1 | 48755 | 3 | 0.843 | 57835.1 |
303 | 2023-11-13 22:07:15 | rurban | 1 | 48755 | 3 | 0.813 | 59969.2 |
302 | 2023-11-05 20:53:51 | rurban | 1 | 48755 | 3 | 0.860 | 56691.9 |
301 | 2023-10-24 21:49:25 | rurban | 1 | 48755 | 3 | 0.826 | 59025.4 |
300 | 2023-10-16 06:10:49 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
299 | 2023-10-09 05:00:41 | rurban | 2 | 82551 | 20 | 2.436 | 33887.9 |
298 | 2023-10-05 06:18:17 | rurban | 1 | 48755 | 3 | 0.856 | 56956.8 |
297 | 2023-09-30 22:14:20 | rurban | 3 | 112716 | 298 | 6.486 | 17378.4 |
296 | 2023-09-26 22:03:57 | rurban | 3 | 112716 | 298 | 6.016 | 18736.0 |
295 | 2023-09-24 20:45:34 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
294 | 2023-09-13 14:02:45 | rurban | 1 | 48755 | 3 | 0.843 | 57835.1 |
293 | 2023-09-12 04:35:46 | rurban | 3 | 112716 | 298 | 9.780 | 11525.2 |
292 | 2023-09-10 17:06:40 | rurban | 1 | 48755 | 3 | 0.763 | 63899.1 |
291 | 2023-07-20 23:23:37 | rurban | 1 | 48755 | 3 | 0.843 | 57835.1 |
290 | 2023-07-20 02:10:24 | rurban | 2 | 82551 | 20 | 2.140 | 38575.2 |
289 | 2023-06-20 17:11:20 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
288 | 2023-06-02 10:08:39 | rurban | 3 | 112716 | 298 | 4.703 | 23966.8 |
287 | 2023-04-05 22:51:04 | rurban | 2 | 82551 | 20 | 2.140 | 38575.2 |
286 | 2023-04-04 07:02:37 | rurban | 1 | 48755 | 3 | 0.733 | 66514.3 |
285 | 2023-03-12 08:29:47 | rurban | 1 | 48755 | 3 | 0.720 | 67715.3 |
284 | 2023-03-10 10:34:08 | rurban | 3 | 112716 | 298 | 4.626 | 24365.8 |
283 | 2023-01-16 06:38:18 | rurban | 1 | 48755 | 3 | 0.733 | 66514.3 |
282 | 2023-01-04 04:52:07 | rurban | 2 | 82551 | 20 | 2.436 | 33887.9 |
281 | 2022-12-14 09:54:13 | rurban | 3 | 112716 | 298 | 4.626 | 24365.8 |
280 | 2022-11-17 11:55:22 | rurban | 3 | 112716 | 298 | 5.563 | 20261.7 |
279 | 2022-11-07 15:49:04 | rurban | 1 | 48755 | 3 | 0.890 | 54780.9 |
278 | 2022-11-03 00:24:15 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
277 | 2022-09-25 18:45:12 | rurban | 3 | 112716 | 298 | 4.920 | 22909.8 |
276 | 2022-09-08 22:50:06 | rurban | 2 | 82551 | 20 | 2.250 | 36689.3 |
275 | 2022-08-28 07:02:05 | rurban | 3 | 112716 | 298 | 5.656 | 19928.6 |
274 | 2022-08-23 05:50:07 | rurban | 1 | 48755 | 3 | 0.733 | 66514.3 |
273 | 2022-08-04 19:41:39 | rurban | 3 | 112716 | 298 | 5.346 | 21084.2 |
272 | 2022-06-27 22:00:51 | rurban | 1 | 48755 | 3 | 0.860 | 56691.9 |
271 | 2022-06-18 03:38:18 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
270 | 2022-03-07 04:07:31 | rurban | 1 | 48755 | 3 | 0.783 | 62266.9 |
269 | 2022-02-02 23:59:44 | rurban | 1 | 48755 | 3 | 0.763 | 63899.1 |
268 | 2021-12-21 20:53:02 | rurban | 1 | 48755 | 3 | 0.843 | 57835.1 |
267 | 2021-12-19 18:38:31 | rurban | 1 | 48755 | 3 | 0.796 | 61250.0 |
266 | 2021-12-11 15:39:05 | rurban | 1 | 48755 | 3 | 0.826 | 59025.4 |
265 | 2021-11-13 19:23:45 | rurban | 1 | 48755 | 3 | 0.796 | 61250.0 |
264 | 2021-10-24 18:43:34 | rurban | 1 | 48755 | 3 | 0.846 | 57630.0 |
263 | 2021-10-22 18:05:59 | rurban | 1 | 48755 | 3 | 0.843 | 57835.1 |
262 | 2021-10-21 20:24:40 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
261 | 2021-10-20 22:54:15 | rurban | 1 | 48755 | 3 | 1.656 | 29441.4 |
260 | 2021-10-14 16:43:36 | rurban | 1 | 48755 | 3 | 0.763 | 63899.1 |
259 | 2021-10-13 19:54:14 | rurban | 1 | 48755 | 3 | 0.813 | 59969.2 |
258 | 2021-10-12 12:27:17 | rurban | 1 | 48755 | 3 | 0.906 | 53813.5 |
257 | 2021-10-11 15:17:03 | rurban | 1 | 48755 | 3 | 0.876 | 55656.4 |
256 | 2021-10-10 12:19:19 | rurban | 1 | 48755 | 3 | 0.890 | 54780.9 |
255 | 2021-10-03 23:40:31 | rurban | 1 | 48755 | 3 | 0.846 | 57630.0 |
254 | 2021-09-22 18:04:45 | rurban | 1 | 48755 | 3 | 0.813 | 59969.2 |
253 | 2021-09-22 01:53:10 | rurban | 1 | 48755 | 3 | 0.860 | 56691.9 |
252 | 2021-09-21 21:18:31 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
251 | 2021-09-21 04:06:56 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
250 | 2021-09-15 01:45:08 | rurban | 1 | 48755 | 3 | 0.780 | 62506.4 |
249 | 2021-09-10 15:30:13 | rurban | 1 | 48755 | 3 | 0.736 | 66243.2 |
248 | 2021-08-21 20:30:35 | rurban | 1 | 48755 | 3 | 1.046 | 46610.9 |
247 | 2021-07-24 13:27:00 | rurban | 1 | 48755 | 3 | 0.736 | 66243.2 |
246 | 2021-07-01 09:36:33 | rurban | 1 | 48755 | 3 | 0.813 | 59969.2 |
245 | 2021-06-30 02:38:47 | rurban | 1 | 48755 | 3 | 0.843 | 57835.1 |
244 | 2021-06-08 10:52:41 | rurban | 1 | 48755 | 3 | 0.876 | 55656.4 |
243 | 2021-04-13 16:01:46 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
242 | 2021-04-08 09:01:06 | rurban | 1 | 48755 | 3 | 0.860 | 56691.9 |
241 | 2021-03-31 11:23:04 | rurban | 1 | 48755 | 3 | 1.266 | 38511.1 |
240 | 2021-02-20 07:51:10 | rurban | 1 | 48755 | 3 | 0.783 | 62266.9 |
239 | 2020-12-26 23:13:28 | rurban | 1 | 48755 | 3 | 0.763 | 63899.1 |
238 | 2020-11-29 23:03:46 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
237 | 2020-11-08 09:31:10 | rurban | 1 | 48755 | 3 | 0.780 | 62506.4 |
236 | 2020-10-21 22:52:03 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
235 | 2020-10-15 10:58:02 | rurban | 1 | 48755 | 3 | 0.780 | 62506.4 |
234 | 2020-10-13 08:14:15 | rurban | 1 | 48755 | 3 | 0.860 | 56691.9 |
233 | 2020-10-08 21:37:15 | rurban | 1 | 48755 | 3 | 0.810 | 60191.4 |
232 | 2020-10-01 05:57:34 | rurban | 1 | 48755 | 3 | 0.733 | 66514.3 |
231 | 2020-09-23 07:54:13 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
230 | 2020-08-03 01:17:57 | rurban | 1 | 48755 | 3 | 0.750 | 65006.7 |
229 | 2020-08-02 01:30:08 | rurban | 1 | 48755 | 3 | 0.783 | 62266.9 |
228 | 2020-06-15 07:49:56 | rurban | 1 | 48755 | 3 | 0.766 | 63648.8 |
227 | 2020-06-15 05:58:06 | rurban | 1 | 48755 | 3 | 0.763 | 63899.1 |
226 | 2020-06-12 06:41:13 | rurban | 1 | 48755 | 3 | 0.783 | 62266.9 |