History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"offices"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
398 | 2024-04-30 08:34:28 | offices | 1 | 69583 | 4 | 1.376 | 50569.0 |
397 | 2024-04-29 18:13:50 | offices | 2 | 107671 | 16 | 3.080 | 34958.1 |
396 | 2024-04-29 18:13:34 | offices | 3 | 134027 | 217 | 7.110 | 18850.5 |
395 | 2024-04-28 08:08:50 | offices | 2 | 107671 | 16 | 3.423 | 31455.2 |
394 | 2024-04-28 08:07:13 | offices | 3 | 134027 | 217 | 7.783 | 17220.5 |
393 | 2024-04-27 15:30:46 | offices | 1 | 69583 | 4 | 1.530 | 45479.1 |
392 | 2024-04-26 21:03:03 | offices | 2 | 107671 | 16 | 8.216 | 13105.0 |
391 | 2024-04-26 07:27:54 | offices | 2 | 107671 | 16 | 9.330 | 11540.3 |
390 | 2024-04-26 07:21:29 | offices | 3 | 134027 | 217 | 6.000 | 22337.8 |
389 | 2024-04-25 23:20:48 | offices | 3 | 134027 | 217 | 12.360 | 10843.6 |
388 | 2024-04-24 20:47:46 | offices | 3 | 134027 | 217 | 6.110 | 21935.7 |
387 | 2024-03-06 11:37:58 | offices | 1 | 69583 | 4 | 3.530 | 19711.9 |
386 | 2024-02-29 22:29:14 | offices | 1 | 69583 | 4 | 1.170 | 59472.6 |
385 | 2023-12-23 08:00:23 | offices | 3 | 134027 | 217 | 5.466 | 24520.1 |
384 | 2023-12-15 19:38:37 | offices | 3 | 134027 | 217 | 5.546 | 24166.4 |
383 | 2023-12-11 22:36:29 | offices | 1 | 69583 | 4 | 1.203 | 57841.2 |
382 | 2023-12-07 00:36:04 | offices | 1 | 69583 | 4 | 1.046 | 66522.9 |
381 | 2023-11-26 11:05:30 | offices | 1 | 69583 | 4 | 1.093 | 63662.4 |
380 | 2023-11-23 12:26:16 | offices | 1 | 69583 | 4 | 1.190 | 58473.1 |
379 | 2023-11-18 21:04:33 | offices | 1 | 69583 | 4 | 1.046 | 66522.9 |
378 | 2023-11-06 11:20:03 | offices | 1 | 69583 | 4 | 1.156 | 60192.9 |
377 | 2023-11-03 19:03:49 | offices | 1 | 69583 | 4 | 1.233 | 56433.9 |
376 | 2023-09-27 19:59:54 | offices | 3 | 134027 | 217 | 6.110 | 21935.7 |
375 | 2023-09-25 23:02:50 | offices | 1 | 69583 | 4 | 1.283 | 54234.6 |
374 | 2023-09-21 09:58:00 | offices | 1 | 69583 | 4 | 1.266 | 54962.9 |
373 | 2023-09-14 10:22:16 | offices | 3 | 134027 | 217 | 5.530 | 24236.3 |
372 | 2023-08-15 05:07:20 | offices | 3 | 134027 | 217 | 6.376 | 21020.5 |
371 | 2023-07-26 12:15:55 | offices | 1 | 69583 | 4 | 1.063 | 65459.1 |
370 | 2023-07-12 09:18:33 | offices | 1 | 69583 | 4 | 1.046 | 66522.9 |
369 | 2023-06-29 20:30:56 | offices | 3 | 134027 | 217 | 6.376 | 21020.5 |
368 | 2023-06-06 00:03:21 | offices | 3 | 134027 | 217 | 5.310 | 25240.5 |
367 | 2023-04-11 17:12:53 | offices | 1 | 69583 | 4 | 1.156 | 60192.9 |
366 | 2023-03-30 20:16:06 | offices | 1 | 69583 | 4 | 1.220 | 57035.2 |
365 | 2023-03-11 20:44:09 | offices | 3 | 134027 | 217 | 5.343 | 25084.6 |
364 | 2023-02-03 06:08:08 | offices | 1 | 69583 | 4 | 1.033 | 67360.1 |
363 | 2023-01-21 18:48:40 | offices | 2 | 107671 | 16 | 2.643 | 40738.2 |
362 | 2023-01-17 06:18:47 | offices | 3 | 134027 | 217 | 5.860 | 22871.5 |
361 | 2022-12-25 03:41:58 | offices | 3 | 134027 | 217 | 6.576 | 20381.2 |
360 | 2022-12-25 03:34:18 | offices | 3 | 134027 | 217 | 5.486 | 24430.7 |
359 | 2022-12-22 09:55:12 | offices | 3 | 134027 | 217 | 6.436 | 20824.6 |
358 | 2022-12-14 18:41:06 | offices | 3 | 134027 | 217 | 5.503 | 24355.3 |
357 | 2022-12-11 15:46:19 | offices | 2 | 107671 | 16 | 3.126 | 34443.7 |
356 | 2022-12-01 12:58:43 | offices | 1 | 69583 | 4 | 1.030 | 67556.3 |
355 | 2022-11-28 22:20:11 | offices | 1 | 69583 | 4 | 1.126 | 61796.6 |
354 | 2022-11-15 04:14:29 | offices | 3 | 134027 | 217 | 5.486 | 24430.7 |
353 | 2022-11-09 17:47:16 | offices | 3 | 134027 | 217 | 5.423 | 24714.5 |
352 | 2022-11-08 23:58:14 | offices | 3 | 134027 | 217 | 6.906 | 19407.3 |
351 | 2022-11-08 05:57:28 | offices | 3 | 134027 | 217 | 5.343 | 25084.6 |
350 | 2022-11-06 21:54:07 | offices | 3 | 134027 | 217 | 6.046 | 22167.9 |
349 | 2022-11-05 10:59:33 | offices | 3 | 134027 | 217 | 5.500 | 24368.5 |
348 | 2022-11-01 16:22:58 | offices | 3 | 134027 | 217 | 6.220 | 21547.7 |
347 | 2022-09-21 17:16:15 | offices | 3 | 134027 | 217 | 6.326 | 21186.7 |
346 | 2022-09-21 08:14:10 | offices | 3 | 134027 | 217 | 5.373 | 24944.5 |
345 | 2022-09-08 06:37:23 | offices | 1 | 69583 | 4 | 1.030 | 67556.3 |
344 | 2022-09-04 03:19:32 | offices | 1 | 69583 | 4 | 1.123 | 61961.7 |
343 | 2022-08-09 02:52:00 | offices | 3 | 134027 | 217 | 5.423 | 24714.5 |
342 | 2022-08-08 14:44:56 | offices | 1 | 69583 | 4 | 1.046 | 66522.9 |
341 | 2022-08-04 13:13:07 | offices | 3 | 134027 | 217 | 5.406 | 24792.3 |
340 | 2022-07-25 19:28:56 | offices | 1 | 69583 | 4 | 1.063 | 65459.1 |
339 | 2022-07-05 01:30:00 | offices | 3 | 134027 | 217 | 6.203 | 21606.8 |
338 | 2022-04-29 04:07:36 | offices | 3 | 134027 | 217 | 9.423 | 14223.4 |
337 | 2022-04-15 18:50:43 | offices | 3 | 134027 | 217 | 6.233 | 21502.8 |
336 | 2022-04-14 16:47:33 | offices | 3 | 134027 | 217 | 7.843 | 17088.7 |
335 | 2022-04-03 23:18:21 | offices | 1 | 69583 | 4 | 1.033 | 67360.1 |
334 | 2022-03-18 11:11:23 | offices | 1 | 69583 | 4 | 1.266 | 54962.9 |
333 | 2022-03-01 16:17:27 | offices | 3 | 134027 | 217 | 6.673 | 20085.0 |
332 | 2022-02-13 06:08:39 | offices | 3 | 134027 | 217 | 5.700 | 23513.5 |
331 | 2022-02-12 18:16:39 | offices | 3 | 134027 | 217 | 6.483 | 20673.6 |
330 | 2022-02-11 12:02:54 | offices | 3 | 134027 | 217 | 6.140 | 21828.5 |
329 | 2022-02-03 21:18:38 | offices | 3 | 134027 | 217 | 5.640 | 23763.7 |
328 | 2022-02-02 21:26:08 | offices | 3 | 134027 | 217 | 5.703 | 23501.1 |
327 | 2022-02-01 20:01:33 | offices | 3 | 134027 | 217 | 7.140 | 18771.3 |
326 | 2022-01-31 20:14:47 | offices | 3 | 134027 | 217 | 5.513 | 24311.1 |
325 | 2022-01-25 01:56:41 | offices | 3 | 134027 | 217 | 6.580 | 20368.8 |
324 | 2022-01-06 02:55:38 | offices | 3 | 134027 | 217 | 6.000 | 22337.8 |
323 | 2022-01-02 20:06:16 | offices | 3 | 134027 | 217 | 6.453 | 20769.7 |
322 | 2022-01-02 11:21:15 | offices | 3 | 134027 | 217 | 6.330 | 21173.3 |
321 | 2022-01-01 15:27:38 | offices | 3 | 134027 | 217 | 7.703 | 17399.3 |
320 | 2021-12-28 23:26:09 | offices | 3 | 134027 | 217 | 6.376 | 21020.5 |
319 | 2021-12-26 14:13:22 | offices | 1 | 69583 | 4 | 1.216 | 57222.9 |
318 | 2021-12-23 18:13:54 | offices | 3 | 134027 | 217 | 6.203 | 21606.8 |
317 | 2021-12-23 06:52:30 | offices | 3 | 134027 | 217 | 6.280 | 21341.9 |
316 | 2021-12-22 21:34:46 | offices | 3 | 134027 | 217 | 10.530 | 12728.1 |
315 | 2021-12-22 11:22:16 | offices | 3 | 134027 | 217 | 12.733 | 10526.0 |
314 | 2021-12-22 00:37:23 | offices | 3 | 134027 | 217 | 5.563 | 24092.6 |
313 | 2021-12-21 17:43:23 | offices | 3 | 134027 | 217 | 7.046 | 19021.7 |
312 | 2021-12-21 06:51:40 | offices | 3 | 134027 | 217 | 6.343 | 21129.9 |
311 | 2021-12-20 20:31:39 | offices | 3 | 134027 | 217 | 6.593 | 20328.7 |
310 | 2021-12-20 08:50:18 | offices | 3 | 134027 | 217 | 6.486 | 20664.0 |
309 | 2021-12-20 01:48:27 | offices | 3 | 134027 | 217 | 5.546 | 24166.4 |
308 | 2021-12-19 10:27:54 | offices | 3 | 134027 | 217 | 7.313 | 18327.2 |
307 | 2021-12-18 23:30:53 | offices | 3 | 134027 | 217 | 6.296 | 21287.6 |
306 | 2021-12-18 05:45:19 | offices | 3 | 134027 | 217 | 6.550 | 20462.1 |
305 | 2021-12-17 16:37:14 | offices | 3 | 134027 | 217 | 6.660 | 20124.2 |
304 | 2021-12-17 13:29:58 | offices | 3 | 134027 | 217 | 6.050 | 22153.2 |
303 | 2021-12-17 12:51:42 | offices | 3 | 134027 | 217 | 6.123 | 21889.1 |
302 | 2021-12-17 09:04:39 | offices | 3 | 134027 | 217 | 6.640 | 20184.8 |
301 | 2021-12-17 08:07:55 | offices | 3 | 134027 | 217 | 6.516 | 20568.9 |
300 | 2021-12-17 01:44:50 | offices | 3 | 134027 | 217 | 5.686 | 23571.4 |
299 | 2021-12-17 01:06:28 | offices | 3 | 134027 | 217 | 7.156 | 18729.3 |