History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pothole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
405 | 2025-08-27 11:21:18 | pothole | 3 | 134027 | 174 | 6.470 | 20715.1 |
404 | 2025-08-26 05:07:13 | pothole | 3 | 134027 | 174 | 34.423 | 3893.5 |
403 | 2025-08-23 01:48:44 | pothole | 3 | 134027 | 174 | 25.203 | 5317.9 |
402 | 2025-08-21 13:27:34 | pothole | 3 | 134027 | 174 | 15.390 | 8708.7 |
401 | 2025-08-21 04:02:11 | pothole | 2 | 107671 | 25 | 11.016 | 9774.1 |
400 | 2025-08-19 21:49:40 | pothole | 1 | 69583 | 5 | 2.076 | 33517.8 |
399 | 2025-08-10 13:07:43 | pothole | 1 | 69583 | 5 | 2.643 | 26327.3 |
398 | 2025-08-09 20:02:26 | pothole | 1 | 69583 | 5 | 3.013 | 23094.3 |
397 | 2025-08-06 21:38:33 | pothole | 2 | 107671 | 25 | 12.486 | 8623.3 |
396 | 2025-08-05 00:55:55 | pothole | 1 | 69583 | 5 | 3.000 | 23194.3 |
395 | 2025-08-03 10:25:37 | pothole | 2 | 107671 | 25 | 2.936 | 36672.7 |
394 | 2025-07-31 06:54:18 | pothole | 1 | 69583 | 5 | 1.263 | 55093.4 |
393 | 2025-07-17 20:04:39 | pothole | 1 | 69583 | 5 | 4.470 | 15566.7 |
392 | 2025-07-15 15:06:13 | pothole | 2 | 107671 | 25 | 3.720 | 28943.8 |
391 | 2025-07-15 00:07:17 | pothole | 1 | 69583 | 5 | 5.796 | 12005.3 |
390 | 2025-07-08 18:37:19 | pothole | 3 | 134027 | 174 | 6.670 | 20094.0 |
389 | 2025-07-07 11:43:46 | pothole | 1 | 69583 | 5 | 5.810 | 11976.4 |
388 | 2025-07-05 12:38:43 | pothole | 3 | 134027 | 174 | 36.566 | 3665.3 |
387 | 2025-07-05 00:50:51 | pothole | 2 | 107671 | 25 | 12.440 | 8655.2 |
386 | 2025-07-04 00:13:21 | pothole | 1 | 69583 | 5 | 1.283 | 54234.6 |
385 | 2025-07-01 22:05:36 | pothole | 1 | 69583 | 5 | 4.190 | 16606.9 |
384 | 2025-06-25 22:02:30 | pothole | 1 | 69583 | 5 | 5.576 | 12479.0 |
383 | 2025-06-24 18:25:06 | pothole | 1 | 69583 | 5 | 9.140 | 7613.0 |
382 | 2025-06-18 05:15:09 | pothole | 1 | 69583 | 5 | 3.280 | 21214.3 |
381 | 2025-06-09 20:24:48 | pothole | 2 | 107671 | 25 | 14.640 | 7354.6 |
380 | 2025-06-06 22:40:53 | pothole | 1 | 69583 | 5 | 2.813 | 24736.2 |
379 | 2025-06-06 11:05:23 | pothole | 1 | 69583 | 5 | 5.780 | 12038.6 |
378 | 2025-06-03 23:56:03 | pothole | 1 | 69583 | 5 | 7.360 | 9454.2 |
377 | 2025-06-02 02:29:46 | pothole | 3 | 134027 | 174 | 32.406 | 4135.9 |
376 | 2025-05-30 14:12:57 | pothole | 3 | 134027 | 174 | 26.533 | 5051.3 |
375 | 2025-05-29 20:20:35 | pothole | 2 | 107671 | 25 | 3.580 | 30075.7 |
374 | 2025-05-28 10:14:01 | pothole | 2 | 107671 | 25 | 3.563 | 30219.2 |
373 | 2025-05-27 22:59:53 | pothole | 3 | 134027 | 174 | 6.720 | 19944.5 |
372 | 2025-05-27 13:07:05 | pothole | 3 | 134027 | 174 | 24.703 | 5425.5 |
371 | 2025-05-25 22:13:47 | pothole | 1 | 69583 | 5 | 3.283 | 21194.9 |
370 | 2025-05-25 02:31:41 | pothole | 1 | 69583 | 5 | 5.436 | 12800.4 |
369 | 2025-05-24 09:02:13 | pothole | 2 | 107671 | 25 | 8.703 | 12371.7 |
368 | 2025-05-24 06:43:21 | pothole | 3 | 134027 | 174 | 29.876 | 4486.1 |
367 | 2025-05-22 18:47:44 | pothole | 1 | 69583 | 5 | 1.173 | 59320.5 |
366 | 2025-05-17 04:39:09 | pothole | 1 | 69583 | 5 | 3.030 | 22964.7 |
365 | 2025-05-16 17:56:01 | pothole | 1 | 69583 | 5 | 3.406 | 20429.5 |
364 | 2025-05-13 20:18:18 | pothole | 1 | 69583 | 5 | 8.313 | 8370.4 |
363 | 2025-04-24 22:33:36 | pothole | 1 | 69583 | 5 | 2.826 | 24622.4 |
362 | 2025-04-20 16:48:20 | pothole | 1 | 69583 | 5 | 1.126 | 61796.6 |
361 | 2025-04-18 09:53:19 | pothole | 1 | 69583 | 5 | 2.860 | 24329.7 |
360 | 2025-04-14 05:07:59 | pothole | 1 | 69583 | 5 | 9.250 | 7522.5 |
359 | 2025-04-04 10:07:40 | pothole | 1 | 69583 | 5 | 8.110 | 8579.9 |
358 | 2025-04-03 04:46:26 | pothole | 2 | 107671 | 25 | 18.296 | 5884.9 |
357 | 2025-04-02 17:11:52 | pothole | 3 | 134027 | 174 | 42.343 | 3165.3 |
356 | 2025-04-01 17:23:58 | pothole | 3 | 134027 | 174 | 7.203 | 18607.1 |
355 | 2025-03-31 14:41:39 | pothole | 3 | 134027 | 174 | 32.446 | 4130.8 |
354 | 2025-03-31 00:50:20 | pothole | 1 | 69583 | 5 | 3.203 | 21724.3 |
353 | 2025-03-22 09:25:44 | pothole | 2 | 107671 | 25 | 15.016 | 7170.4 |
352 | 2025-03-22 06:45:51 | pothole | 3 | 134027 | 174 | 45.033 | 2976.2 |
351 | 2025-03-20 19:12:18 | pothole | 1 | 69583 | 5 | 3.490 | 19937.8 |
350 | 2025-03-19 22:57:29 | pothole | 1 | 69583 | 5 | 6.110 | 11388.4 |
349 | 2025-03-16 08:54:13 | pothole | 1 | 69583 | 5 | 4.093 | 17000.5 |
348 | 2025-03-12 21:12:37 | pothole | 1 | 69583 | 5 | 3.203 | 21724.3 |
347 | 2025-03-12 08:33:45 | pothole | 1 | 69583 | 5 | 4.140 | 16807.5 |
346 | 2025-03-03 03:43:05 | pothole | 1 | 69583 | 5 | 2.813 | 24736.2 |
345 | 2025-02-22 22:04:44 | pothole | 1 | 69583 | 5 | 4.593 | 15149.8 |
344 | 2025-02-16 12:04:00 | pothole | 1 | 69583 | 5 | 3.970 | 17527.2 |
343 | 2025-02-04 11:44:58 | pothole | 1 | 69583 | 5 | 5.953 | 11688.7 |
342 | 2025-02-03 14:10:14 | pothole | 1 | 69583 | 5 | 1.360 | 51164.0 |
341 | 2025-01-06 20:13:36 | pothole | 3 | 134027 | 174 | 41.316 | 3243.9 |
340 | 2025-01-06 13:14:24 | pothole | 3 | 134027 | 174 | 40.283 | 3327.1 |
339 | 2025-01-06 13:14:10 | pothole | 2 | 107671 | 25 | 16.640 | 6470.6 |
338 | 2025-01-06 13:13:10 | pothole | 1 | 69583 | 5 | 5.920 | 11753.9 |
337 | 2025-01-03 23:59:58 | pothole | 1 | 69583 | 5 | 2.907 | 23936.4 |
336 | 2024-12-29 01:52:25 | pothole | 1 | 69583 | 5 | 7.346 | 9472.2 |
335 | 2024-12-15 07:47:27 | pothole | 1 | 69583 | 5 | 8.000 | 8697.9 |
334 | 2024-12-04 22:59:31 | pothole | 1 | 69583 | 5 | 5.720 | 12164.9 |
333 | 2024-11-11 04:34:52 | pothole | 1 | 69583 | 5 | 1.123 | 61961.7 |
332 | 2024-10-20 17:08:36 | pothole | 1 | 69583 | 5 | 8.250 | 8434.3 |
331 | 2024-10-20 17:03:56 | pothole | 1 | 69583 | 5 | 3.326 | 20920.9 |
330 | 2024-10-20 16:58:53 | pothole | 1 | 69583 | 5 | 6.813 | 10213.3 |
329 | 2024-10-20 16:53:00 | pothole | 1 | 69583 | 5 | 2.686 | 25905.8 |
328 | 2024-10-12 20:06:18 | pothole | 3 | 134027 | 174 | 38.330 | 3496.7 |
327 | 2024-10-12 20:06:11 | pothole | 2 | 107671 | 25 | 17.436 | 6175.2 |
326 | 2024-10-09 12:10:05 | pothole | 2 | 107671 | 25 | 3.626 | 29694.2 |
325 | 2024-10-07 00:33:54 | pothole | 2 | 107671 | 25 | 25.203 | 4272.2 |
324 | 2024-10-07 00:32:55 | pothole | 1 | 69583 | 5 | 11.173 | 6227.8 |
323 | 2024-10-05 09:09:18 | pothole | 3 | 134027 | 174 | 77.586 | 1727.5 |
322 | 2024-10-04 08:11:47 | pothole | 3 | 134027 | 174 | 37.173 | 3605.5 |
321 | 2024-10-03 02:19:20 | pothole | 3 | 134027 | 174 | 46.583 | 2877.2 |
320 | 2024-10-03 02:19:17 | pothole | 2 | 107671 | 25 | 13.233 | 8136.6 |
319 | 2024-10-03 02:17:35 | pothole | 1 | 69583 | 5 | 3.530 | 19711.9 |
318 | 2024-09-22 04:18:50 | pothole | 1 | 69583 | 5 | 4.750 | 14649.1 |
317 | 2024-09-16 22:23:43 | pothole | 1 | 69583 | 5 | 7.516 | 9258.0 |
316 | 2024-08-30 19:11:30 | pothole | 1 | 69583 | 5 | 1.220 | 57035.2 |
315 | 2024-08-25 03:10:46 | pothole | 1 | 69583 | 5 | 6.796 | 10238.8 |
314 | 2024-08-15 12:41:58 | pothole | 1 | 69583 | 5 | 8.953 | 7772.0 |
313 | 2024-08-15 10:35:16 | pothole | 1 | 69583 | 5 | 7.103 | 9796.3 |
312 | 2024-08-12 07:33:37 | pothole | 1 | 69583 | 5 | 13.016 | 5346.0 |
311 | 2024-08-11 19:21:56 | pothole | 1 | 69583 | 5 | 2.733 | 25460.3 |
310 | 2024-07-29 04:40:25 | pothole | 1 | 69583 | 5 | 5.406 | 12871.4 |
309 | 2024-07-24 17:27:37 | pothole | 1 | 69583 | 5 | 6.533 | 10651.0 |
308 | 2024-07-24 05:41:50 | pothole | 1 | 69583 | 5 | 4.250 | 16372.5 |
307 | 2024-07-16 07:54:13 | pothole | 1 | 69583 | 5 | 2.173 | 32021.6 |
306 | 2024-06-20 11:09:33 | pothole | 3 | 134027 | 174 | 27.970 | 4791.8 |