History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"complies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
357 | 2024-04-28 06:22:19 | complies | 1 | 82945 | 8 | 1.530 | 54212.4 |
356 | 2024-04-26 23:52:51 | complies | 1 | 82945 | 8 | 1.436 | 57761.1 |
355 | 2024-04-22 08:25:39 | complies | 1 | 82945 | 8 | 4.220 | 19655.2 |
354 | 2024-04-22 08:12:19 | complies | 3 | 146162 | 302 | 17.500 | 8352.1 |
353 | 2024-04-22 08:12:17 | complies | 2 | 121059 | 43 | 7.610 | 15907.9 |
352 | 2024-04-22 08:09:58 | complies | 2 | 121059 | 43 | 16.313 | 7421.0 |
351 | 2024-04-22 08:09:04 | complies | 3 | 146162 | 302 | 26.296 | 5558.3 |
350 | 2024-04-22 08:04:05 | complies | 1 | 82945 | 8 | 2.923 | 28376.7 |
349 | 2024-04-22 08:02:52 | complies | 1 | 82945 | 8 | 1.673 | 49578.6 |
348 | 2024-04-06 13:46:56 | complies | 3 | 146162 | 302 | 23.736 | 6157.8 |
347 | 2024-04-06 06:11:28 | complies | 3 | 146162 | 302 | 19.890 | 7348.5 |
346 | 2024-04-06 06:11:29 | complies | 2 | 121059 | 43 | 7.923 | 15279.4 |
345 | 2024-04-01 00:10:14 | complies | 1 | 82945 | 8 | 1.720 | 48223.8 |
344 | 2024-04-01 00:09:49 | complies | 2 | 121059 | 43 | 4.436 | 27290.1 |
343 | 2024-03-30 22:32:00 | complies | 3 | 146162 | 302 | 16.156 | 9046.9 |
342 | 2024-03-30 22:31:54 | complies | 2 | 121059 | 43 | 13.250 | 9136.5 |
341 | 2024-03-30 08:59:56 | complies | 3 | 146162 | 302 | 25.566 | 5717.0 |
340 | 2024-03-30 08:59:57 | complies | 2 | 121059 | 43 | 11.983 | 10102.6 |
339 | 2024-03-30 08:59:20 | complies | 1 | 82945 | 8 | 4.796 | 17294.6 |
338 | 2024-03-23 09:33:48 | complies | 1 | 82945 | 8 | 1.530 | 54212.4 |
337 | 2024-03-20 12:12:42 | complies | 2 | 121059 | 43 | 9.296 | 13022.7 |
336 | 2024-03-06 11:50:25 | complies | 1 | 82945 | 8 | 3.360 | 24686.0 |
335 | 2024-02-28 11:00:54 | complies | 1 | 82945 | 8 | 1.503 | 55186.3 |
334 | 2024-02-08 09:11:22 | complies | 3 | 146162 | 302 | 8.766 | 16673.7 |
333 | 2024-02-07 16:11:42 | complies | 2 | 121059 | 43 | 7.890 | 15343.3 |
332 | 2024-02-07 16:11:14 | complies | 3 | 146162 | 302 | 6.233 | 23449.7 |
331 | 2024-01-27 10:14:09 | complies | 2 | 121059 | 43 | 3.906 | 30993.1 |
330 | 2024-01-27 10:13:49 | complies | 3 | 146162 | 302 | 8.000 | 18270.3 |
329 | 2024-01-27 00:13:43 | complies | 2 | 121059 | 43 | 3.593 | 33693.0 |
328 | 2024-01-27 00:12:51 | complies | 3 | 146162 | 302 | 6.670 | 21913.3 |
327 | 2024-01-08 16:32:28 | complies | 3 | 146162 | 302 | 6.780 | 21557.8 |
326 | 2024-01-08 16:32:26 | complies | 2 | 121059 | 43 | 3.326 | 36397.8 |
325 | 2023-12-13 02:23:21 | complies | 1 | 82945 | 8 | 1.530 | 54212.4 |
324 | 2023-12-10 13:12:43 | complies | 1 | 82945 | 8 | 1.283 | 64649.3 |
323 | 2023-12-03 18:50:36 | complies | 1 | 82945 | 8 | 1.313 | 63172.1 |
322 | 2023-12-01 10:27:44 | complies | 2 | 121059 | 43 | 3.360 | 36029.5 |
321 | 2023-11-18 14:10:42 | complies | 1 | 82945 | 8 | 1.330 | 62364.7 |
320 | 2023-11-17 00:47:47 | complies | 1 | 82945 | 8 | 1.420 | 58412.0 |
319 | 2023-11-01 19:58:31 | complies | 1 | 82945 | 8 | 1.516 | 54713.1 |
318 | 2023-10-13 12:45:29 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
317 | 2023-09-25 03:27:45 | complies | 1 | 82945 | 8 | 1.516 | 54713.1 |
316 | 2023-09-24 16:53:51 | complies | 1 | 82945 | 8 | 1.313 | 63172.1 |
315 | 2023-08-30 09:09:04 | complies | 2 | 121059 | 43 | 3.470 | 34887.3 |
314 | 2023-08-05 11:16:50 | complies | 1 | 82945 | 8 | 1.296 | 64000.8 |
313 | 2023-07-21 00:49:17 | complies | 1 | 82945 | 8 | 1.283 | 64649.3 |
312 | 2023-05-17 23:01:16 | complies | 2 | 121059 | 43 | 3.220 | 37596.0 |
311 | 2023-04-27 22:46:35 | complies | 1 | 82945 | 8 | 1.313 | 63172.1 |
310 | 2023-04-27 04:03:49 | complies | 1 | 82945 | 8 | 1.343 | 61761.0 |
309 | 2023-04-20 16:47:25 | complies | 1 | 82945 | 8 | 1.266 | 65517.4 |
308 | 2023-03-19 16:58:15 | complies | 1 | 82945 | 8 | 1.280 | 64800.8 |
307 | 2023-02-26 23:15:45 | complies | 2 | 121059 | 43 | 3.236 | 37410.1 |
306 | 2023-02-10 15:47:23 | complies | 1 | 82945 | 8 | 1.250 | 66356.0 |
305 | 2023-01-19 08:13:59 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
304 | 2022-12-09 08:42:14 | complies | 1 | 82945 | 8 | 1.283 | 64649.3 |
303 | 2022-12-08 20:06:36 | complies | 2 | 121059 | 43 | 3.186 | 37997.2 |
302 | 2022-10-05 05:38:43 | complies | 1 | 82945 | 8 | 1.296 | 64000.8 |
301 | 2022-09-04 21:02:31 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
300 | 2022-08-10 10:02:56 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
299 | 2022-08-03 14:38:33 | complies | 1 | 82945 | 8 | 1.313 | 63172.1 |
298 | 2022-07-25 13:05:13 | complies | 2 | 121059 | 43 | 3.733 | 32429.4 |
297 | 2022-07-23 04:39:06 | complies | 2 | 121059 | 43 | 3.203 | 37795.5 |
296 | 2022-07-02 02:03:16 | complies | 1 | 82945 | 8 | 1.376 | 60279.8 |
295 | 2022-06-18 08:51:56 | complies | 1 | 82945 | 8 | 1.266 | 65517.4 |
294 | 2022-06-17 14:54:55 | complies | 1 | 82945 | 8 | 1.283 | 64649.3 |
293 | 2022-06-10 20:46:15 | complies | 1 | 82945 | 8 | 1.313 | 63172.1 |
292 | 2022-04-06 01:55:30 | complies | 1 | 82945 | 8 | 1.736 | 47779.4 |
291 | 2022-03-02 20:12:10 | complies | 1 | 82945 | 8 | 1.516 | 54713.1 |
290 | 2022-02-28 23:50:07 | complies | 2 | 121059 | 43 | 4.186 | 28920.0 |
289 | 2022-02-26 19:29:26 | complies | 2 | 121059 | 43 | 3.233 | 37444.8 |
288 | 2022-01-14 02:09:35 | complies | 1 | 82945 | 8 | 1.440 | 57600.7 |
287 | 2021-11-24 21:01:25 | complies | 2 | 121059 | 43 | 4.110 | 29454.7 |
286 | 2021-11-22 13:25:08 | complies | 1 | 82945 | 8 | 1.470 | 56425.2 |
285 | 2021-11-10 00:23:13 | complies | 1 | 82945 | 8 | 1.453 | 57085.3 |
284 | 2021-11-07 21:50:41 | complies | 1 | 82945 | 8 | 1.296 | 64000.8 |
283 | 2021-09-29 16:58:28 | complies | 1 | 82945 | 8 | 1.563 | 53067.8 |
282 | 2021-09-12 15:14:39 | complies | 1 | 82945 | 8 | 1.310 | 63316.8 |
281 | 2021-08-23 01:51:18 | complies | 1 | 82945 | 8 | 1.343 | 61761.0 |
280 | 2021-06-22 20:00:40 | complies | 1 | 82945 | 8 | 1.423 | 58288.8 |
279 | 2021-05-22 06:28:07 | complies | 1 | 82945 | 8 | 1.360 | 60989.0 |
278 | 2021-05-01 08:48:25 | complies | 1 | 82945 | 8 | 1.530 | 54212.4 |
277 | 2021-04-03 13:13:29 | complies | 1 | 82945 | 8 | 1.296 | 64000.8 |
276 | 2021-02-24 11:36:35 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
275 | 2021-02-15 20:39:40 | complies | 1 | 82945 | 8 | 1.330 | 62364.7 |
274 | 2021-01-18 14:52:28 | complies | 1 | 82945 | 8 | 1.330 | 62364.7 |
273 | 2020-11-24 03:20:54 | complies | 1 | 82945 | 8 | 1.283 | 64649.3 |
272 | 2020-11-11 14:01:33 | complies | 1 | 82945 | 8 | 1.343 | 61761.0 |
271 | 2020-11-08 13:00:16 | complies | 1 | 82945 | 8 | 1.580 | 52496.8 |
270 | 2020-11-01 08:37:13 | complies | 1 | 82945 | 8 | 1.686 | 49196.3 |
269 | 2020-10-26 06:22:15 | complies | 1 | 82945 | 8 | 1.310 | 63316.8 |
268 | 2020-10-22 20:54:45 | complies | 1 | 82945 | 8 | 1.623 | 51106.0 |
267 | 2020-10-19 17:52:03 | complies | 1 | 82945 | 8 | 1.313 | 63172.1 |
266 | 2020-10-18 13:19:00 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
265 | 2020-10-08 13:19:01 | complies | 1 | 82945 | 8 | 1.296 | 64000.8 |
264 | 2020-09-10 01:08:47 | complies | 1 | 82945 | 8 | 1.326 | 62552.8 |
263 | 2020-08-19 10:07:45 | complies | 1 | 82945 | 8 | 1.330 | 62364.7 |
262 | 2020-08-05 06:58:26 | complies | 1 | 82945 | 8 | 1.436 | 57761.1 |
261 | 2020-08-02 01:25:15 | complies | 1 | 82945 | 8 | 1.436 | 57761.1 |
260 | 2020-04-30 13:57:48 | complies | 1 | 82945 | 8 | 1.360 | 60989.0 |
259 | 2020-03-29 13:16:08 | complies | 1 | 82945 | 8 | 1.453 | 57085.3 |
258 | 2020-03-29 07:19:10 | complies | 1 | 82945 | 8 | 3.000 | 27648.3 |