History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"addresses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
396 | 2024-03-28 14:16:47 | addresses | 1 | 81242 | 6 | 1.420 | 57212.7 |
395 | 2024-03-24 15:26:12 | addresses | 1 | 81242 | 6 | 3.296 | 24648.7 |
394 | 2024-03-20 03:56:13 | addresses | 2 | 121436 | 21 | 11.720 | 10361.4 |
393 | 2024-03-20 01:36:25 | addresses | 1 | 81242 | 6 | 2.860 | 28406.3 |
392 | 2024-03-12 10:57:51 | addresses | 4 | 165329 | 542 | 25.313 | 6531.4 |
391 | 2024-03-12 10:57:18 | addresses | 1 | 81242 | 6 | 1.860 | 43678.5 |
390 | 2024-03-08 10:41:15 | addresses | 1 | 81242 | 6 | 4.796 | 16939.5 |
389 | 2024-03-05 17:36:43 | addresses | 2 | 121436 | 21 | 5.513 | 22027.2 |
388 | 2024-03-05 16:57:20 | addresses | 1 | 81242 | 6 | 1.420 | 57212.7 |
387 | 2024-03-04 09:42:43 | addresses | 4 | 165329 | 542 | 19.640 | 8418.0 |
386 | 2024-03-03 02:58:25 | addresses | 3 | 148641 | 94 | 7.203 | 20636.0 |
385 | 2024-03-03 02:46:36 | addresses | 1 | 81242 | 6 | 4.530 | 17934.2 |
384 | 2024-03-01 08:47:18 | addresses | 2 | 121436 | 21 | 4.390 | 27662.0 |
383 | 2024-02-26 01:21:47 | addresses | 3 | 148641 | 94 | 23.236 | 6397.0 |
382 | 2024-02-26 01:21:02 | addresses | 2 | 121436 | 21 | 6.890 | 17625.0 |
381 | 2024-02-22 23:15:24 | addresses | 4 | 165329 | 542 | 20.186 | 8190.3 |
380 | 2024-02-22 23:15:27 | addresses | 3 | 148641 | 94 | 8.186 | 18158.0 |
379 | 2024-02-22 23:15:26 | addresses | 2 | 121436 | 21 | 4.110 | 29546.5 |
378 | 2024-02-22 16:27:54 | addresses | 1 | 81242 | 6 | 1.453 | 55913.3 |
377 | 2024-02-10 18:03:25 | addresses | 2 | 121436 | 21 | 8.970 | 13538.0 |
376 | 2024-02-06 22:04:26 | addresses | 1 | 81242 | 6 | 1.360 | 59736.8 |
375 | 2024-01-31 02:18:19 | addresses | 1 | 81242 | 6 | 1.936 | 41963.8 |
374 | 2024-01-29 20:23:06 | addresses | 1 | 81242 | 6 | 2.970 | 27354.2 |
373 | 2024-01-25 17:50:01 | addresses | 1 | 81242 | 6 | 1.516 | 53589.7 |
372 | 2024-01-23 17:42:59 | addresses | 4 | 165329 | 542 | 48.626 | 3400.0 |
371 | 2024-01-23 13:00:10 | addresses | 4 | 165329 | 542 | 36.813 | 4491.0 |
370 | 2024-01-23 13:00:10 | addresses | 3 | 148641 | 94 | 12.063 | 12322.1 |
369 | 2024-01-23 13:00:10 | addresses | 2 | 121436 | 21 | 8.423 | 14417.2 |
368 | 2024-01-23 08:57:42 | addresses | 1 | 81242 | 6 | 1.516 | 53589.7 |
367 | 2023-12-11 22:01:52 | addresses | 2 | 121436 | 21 | 2.923 | 41545.0 |
366 | 2023-12-02 17:07:19 | addresses | 4 | 165329 | 542 | 11.390 | 14515.3 |
365 | 2023-12-02 17:07:24 | addresses | 2 | 121436 | 21 | 3.500 | 34696.0 |
364 | 2023-12-02 17:07:16 | addresses | 3 | 148641 | 94 | 6.373 | 23323.6 |
363 | 2023-11-25 21:50:52 | addresses | 4 | 165329 | 542 | 12.186 | 13567.1 |
362 | 2023-11-21 15:10:38 | addresses | 1 | 81242 | 6 | 1.330 | 61084.2 |
361 | 2023-11-15 23:24:39 | addresses | 1 | 81242 | 6 | 1.360 | 59736.8 |
360 | 2023-11-12 11:32:32 | addresses | 1 | 81242 | 6 | 1.250 | 64993.6 |
359 | 2023-11-10 08:46:52 | addresses | 1 | 81242 | 6 | 1.326 | 61268.5 |
358 | 2023-10-16 17:40:36 | addresses | 1 | 81242 | 6 | 1.186 | 68500.8 |
357 | 2023-09-12 01:15:25 | addresses | 4 | 165329 | 542 | 15.203 | 10874.8 |
356 | 2023-09-11 07:59:33 | addresses | 2 | 121436 | 21 | 3.970 | 30588.4 |
355 | 2023-09-07 19:50:25 | addresses | 1 | 81242 | 6 | 1.236 | 65729.8 |
354 | 2023-08-25 01:32:21 | addresses | 4 | 165329 | 542 | 10.953 | 15094.4 |
353 | 2023-06-26 01:41:45 | addresses | 1 | 81242 | 6 | 1.326 | 61268.5 |
352 | 2023-06-12 16:26:58 | addresses | 1 | 81242 | 6 | 1.283 | 63321.9 |
351 | 2023-05-28 12:50:17 | addresses | 2 | 121436 | 21 | 2.890 | 42019.4 |
350 | 2023-05-17 01:48:39 | addresses | 4 | 165329 | 542 | 9.940 | 16632.7 |
349 | 2023-05-11 02:38:17 | addresses | 4 | 165329 | 542 | 10.143 | 16299.8 |
348 | 2023-04-05 05:04:45 | addresses | 4 | 165329 | 542 | 11.720 | 14106.6 |
347 | 2023-03-29 18:37:29 | addresses | 1 | 81242 | 6 | 1.360 | 59736.8 |
346 | 2023-03-27 12:54:17 | addresses | 4 | 165329 | 542 | 10.110 | 16353.0 |
345 | 2023-03-06 18:24:50 | addresses | 2 | 121436 | 21 | 2.873 | 42268.0 |
344 | 2023-03-03 18:41:36 | addresses | 1 | 81242 | 6 | 1.220 | 66591.8 |
343 | 2023-02-18 02:08:18 | addresses | 4 | 165329 | 542 | 10.393 | 15907.7 |
342 | 2023-01-12 07:54:09 | addresses | 1 | 81242 | 6 | 1.203 | 67532.8 |
341 | 2022-12-11 23:11:19 | addresses | 2 | 121436 | 21 | 2.873 | 42268.0 |
340 | 2022-11-28 08:08:07 | addresses | 4 | 165329 | 542 | 11.186 | 14780.0 |
339 | 2022-11-04 11:30:51 | addresses | 1 | 81242 | 6 | 1.233 | 65889.7 |
338 | 2022-10-19 19:12:53 | addresses | 1 | 81242 | 6 | 1.390 | 58447.5 |
337 | 2022-07-27 15:23:36 | addresses | 2 | 121436 | 21 | 2.936 | 41361.0 |
336 | 2022-07-14 17:56:23 | addresses | 1 | 81242 | 6 | 1.313 | 61875.1 |
335 | 2022-06-29 11:05:37 | addresses | 3 | 148641 | 94 | 5.846 | 25426.1 |
334 | 2022-06-10 21:22:46 | addresses | 1 | 81242 | 6 | 1.326 | 61268.5 |
333 | 2022-05-19 11:05:40 | addresses | 4 | 165329 | 542 | 11.843 | 13960.1 |
332 | 2022-05-18 17:59:23 | addresses | 1 | 81242 | 6 | 1.390 | 58447.5 |
331 | 2022-04-23 16:49:37 | addresses | 4 | 165329 | 542 | 10.470 | 15790.7 |
330 | 2022-03-21 03:21:04 | addresses | 1 | 81242 | 6 | 1.236 | 65729.8 |
329 | 2022-03-17 16:46:02 | addresses | 1 | 81242 | 6 | 1.593 | 50999.4 |
328 | 2022-02-24 23:18:15 | addresses | 1 | 81242 | 6 | 1.813 | 44810.8 |
327 | 2021-12-29 01:16:40 | addresses | 4 | 165329 | 542 | 12.016 | 13759.1 |
326 | 2021-12-26 22:59:32 | addresses | 4 | 165329 | 542 | 11.813 | 13995.5 |
325 | 2021-12-14 02:50:34 | addresses | 1 | 81242 | 6 | 1.923 | 42247.5 |
324 | 2021-12-11 23:20:21 | addresses | 1 | 81242 | 6 | 2.673 | 30393.6 |
323 | 2021-12-07 05:36:04 | addresses | 1 | 81242 | 6 | 1.200 | 67701.7 |
322 | 2021-12-03 22:49:36 | addresses | 1 | 81242 | 6 | 1.486 | 54671.6 |
321 | 2021-10-19 04:24:12 | addresses | 1 | 81242 | 6 | 1.233 | 65889.7 |
320 | 2021-10-09 03:24:21 | addresses | 4 | 165329 | 542 | 10.890 | 15181.7 |
319 | 2021-09-06 20:40:49 | addresses | 1 | 81242 | 6 | 1.310 | 62016.8 |
318 | 2021-08-27 13:20:04 | addresses | 1 | 81242 | 6 | 1.343 | 60492.9 |
317 | 2021-08-20 05:52:32 | addresses | 1 | 81242 | 6 | 1.216 | 66810.9 |
316 | 2021-05-23 12:10:05 | addresses | 1 | 81242 | 6 | 1.470 | 55266.7 |
315 | 2021-05-03 21:50:24 | addresses | 1 | 81242 | 6 | 2.813 | 28880.9 |
314 | 2021-02-21 10:44:24 | addresses | 1 | 81242 | 6 | 2.750 | 29542.5 |
313 | 2021-01-17 02:36:09 | addresses | 1 | 81242 | 6 | 1.220 | 66591.8 |
312 | 2020-12-27 02:45:40 | addresses | 1 | 81242 | 6 | 1.346 | 60358.1 |
311 | 2020-11-13 06:12:38 | addresses | 1 | 81242 | 6 | 1.203 | 67532.8 |
310 | 2020-11-06 06:37:53 | addresses | 1 | 81242 | 6 | 1.406 | 57782.4 |
309 | 2020-11-01 09:12:18 | addresses | 1 | 81242 | 6 | 1.640 | 49537.8 |
308 | 2020-09-24 12:56:19 | addresses | 1 | 81242 | 6 | 1.343 | 60492.9 |
307 | 2020-08-12 11:43:32 | addresses | 1 | 81242 | 6 | 1.283 | 63321.9 |
306 | 2020-08-06 08:54:39 | addresses | 1 | 81242 | 6 | 1.360 | 59736.8 |
305 | 2020-05-01 18:37:27 | addresses | 1 | 81242 | 6 | 1.236 | 65729.8 |
304 | 2020-03-24 12:36:10 | addresses | 1 | 81242 | 6 | 1.516 | 53589.7 |
303 | 2020-02-26 23:11:09 | addresses | 1 | 81242 | 6 | 1.516 | 53589.7 |
302 | 2020-02-25 05:32:15 | addresses | 1 | 81242 | 6 | 1.516 | 53589.7 |
301 | 2020-02-24 09:47:21 | addresses | 1 | 81242 | 6 | 1.343 | 60492.9 |
300 | 2020-02-08 08:32:43 | addresses | 1 | 81242 | 6 | 2.783 | 29192.2 |
299 | 2020-02-05 22:18:21 | addresses | 1 | 81242 | 6 | 2.640 | 30773.5 |
298 | 2020-01-30 23:08:08 | addresses | 1 | 81242 | 6 | 2.406 | 33766.4 |
297 | 2020-01-30 16:39:21 | addresses | 1 | 81242 | 6 | 1.343 | 60492.9 |