History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hydrant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
426 | 2024-04-27 08:46:27 | hydrant | 1 | 69583 | 3 | 1.013 | 68690.0 |
425 | 2024-04-18 20:42:49 | hydrant | 1 | 69583 | 3 | 1.046 | 66522.9 |
424 | 2024-04-10 10:17:30 | hydrant | 1 | 69583 | 3 | 4.093 | 17000.5 |
423 | 2024-04-08 10:14:16 | hydrant | 4 | 151207 | 777 | 41.893 | 3609.4 |
422 | 2024-04-07 10:40:26 | hydrant | 4 | 151207 | 777 | 35.080 | 4310.3 |
421 | 2024-04-07 09:22:55 | hydrant | 4 | 151207 | 777 | 14.563 | 10383.0 |
420 | 2024-04-06 10:24:54 | hydrant | 4 | 151207 | 777 | 40.440 | 3739.0 |
419 | 2024-04-02 01:37:25 | hydrant | 4 | 151207 | 777 | 10.656 | 14189.8 |
418 | 2024-03-31 12:09:23 | hydrant | 1 | 69583 | 3 | 2.830 | 24587.6 |
417 | 2024-03-28 22:09:26 | hydrant | 1 | 69583 | 3 | 3.876 | 17952.3 |
416 | 2024-03-08 23:48:53 | hydrant | 4 | 151207 | 777 | 36.876 | 4100.4 |
415 | 2024-03-07 10:15:07 | hydrant | 4 | 151207 | 777 | 36.206 | 4176.3 |
414 | 2024-03-07 08:58:17 | hydrant | 2 | 107671 | 10 | 8.483 | 12692.6 |
413 | 2024-03-07 03:14:04 | hydrant | 4 | 151207 | 777 | 16.440 | 9197.5 |
412 | 2024-03-06 23:54:12 | hydrant | 4 | 151207 | 777 | 25.003 | 6047.6 |
411 | 2024-03-06 06:22:36 | hydrant | 1 | 69583 | 3 | 2.453 | 28366.5 |
410 | 2024-03-06 04:22:54 | hydrant | 4 | 151207 | 777 | 19.376 | 7803.8 |
409 | 2024-03-06 04:22:54 | hydrant | 2 | 107671 | 10 | 7.313 | 14723.2 |
408 | 2024-03-06 04:20:44 | hydrant | 4 | 151207 | 777 | 17.626 | 8578.6 |
407 | 2024-03-06 04:20:42 | hydrant | 3 | 134027 | 76 | 11.923 | 11241.0 |
406 | 2024-03-06 04:20:43 | hydrant | 2 | 107671 | 10 | 6.986 | 15412.4 |
405 | 2024-03-06 04:20:36 | hydrant | 1 | 69583 | 3 | 2.610 | 26660.2 |
404 | 2024-03-06 04:20:20 | hydrant | 3 | 134027 | 76 | 7.233 | 18529.9 |
403 | 2024-03-05 01:19:25 | hydrant | 3 | 134027 | 76 | 20.910 | 6409.7 |
402 | 2024-03-03 17:59:47 | hydrant | 3 | 134027 | 76 | 6.970 | 19229.1 |
401 | 2024-03-02 14:27:41 | hydrant | 1 | 69583 | 3 | 2.640 | 26357.2 |
400 | 2024-02-07 23:07:14 | hydrant | 1 | 69583 | 3 | 2.330 | 29863.9 |
399 | 2024-02-04 17:15:21 | hydrant | 4 | 151207 | 777 | 14.486 | 10438.1 |
398 | 2024-02-02 20:28:56 | hydrant | 4 | 151207 | 777 | 14.436 | 10474.3 |
397 | 2024-02-02 17:33:48 | hydrant | 4 | 151207 | 777 | 9.813 | 15408.8 |
396 | 2024-02-02 16:28:11 | hydrant | 4 | 151207 | 777 | 10.406 | 14530.8 |
395 | 2024-02-02 07:12:35 | hydrant | 4 | 151207 | 777 | 9.313 | 16236.1 |
394 | 2024-01-29 06:38:12 | hydrant | 1 | 69583 | 3 | 1.186 | 58670.3 |
393 | 2024-01-20 21:53:06 | hydrant | 1 | 69583 | 3 | 1.030 | 67556.3 |
392 | 2023-12-31 14:08:14 | hydrant | 1 | 69583 | 3 | 1.220 | 57035.2 |
391 | 2023-12-07 16:32:41 | hydrant | 4 | 151207 | 777 | 11.063 | 13667.8 |
390 | 2023-11-29 08:55:22 | hydrant | 4 | 151207 | 777 | 28.926 | 5227.4 |
389 | 2023-11-28 20:35:41 | hydrant | 1 | 69583 | 3 | 1.013 | 68690.0 |
388 | 2023-11-25 13:14:36 | hydrant | 1 | 69583 | 3 | 1.203 | 57841.2 |
387 | 2023-11-24 04:18:15 | hydrant | 3 | 134027 | 76 | 6.000 | 22337.8 |
386 | 2023-11-13 03:18:15 | hydrant | 4 | 151207 | 777 | 9.876 | 15310.6 |
385 | 2023-11-12 17:08:42 | hydrant | 4 | 151207 | 777 | 14.326 | 10554.7 |
384 | 2023-11-11 05:41:33 | hydrant | 4 | 151207 | 777 | 10.770 | 14039.6 |
383 | 2023-10-30 05:35:22 | hydrant | 4 | 151207 | 777 | 11.876 | 12732.1 |
382 | 2023-10-21 10:53:41 | hydrant | 1 | 69583 | 3 | 1.610 | 43219.3 |
381 | 2023-10-20 06:40:11 | hydrant | 4 | 151207 | 777 | 12.500 | 12096.6 |
380 | 2023-10-17 18:36:52 | hydrant | 1 | 69583 | 3 | 1.030 | 67556.3 |
379 | 2023-10-13 19:14:39 | hydrant | 4 | 151207 | 777 | 9.486 | 15940.0 |
378 | 2023-10-03 16:24:59 | hydrant | 3 | 134027 | 76 | 5.920 | 22639.7 |
377 | 2023-09-29 21:49:19 | hydrant | 1 | 69583 | 3 | 1.140 | 61037.7 |
376 | 2023-09-27 13:18:20 | hydrant | 1 | 69583 | 3 | 1.063 | 65459.1 |
375 | 2023-09-14 09:13:37 | hydrant | 1 | 69583 | 3 | 1.206 | 57697.3 |
374 | 2023-09-13 12:25:54 | hydrant | 4 | 151207 | 777 | 10.860 | 13923.3 |
373 | 2023-09-11 08:35:22 | hydrant | 4 | 151207 | 777 | 17.780 | 8504.3 |
372 | 2023-09-08 12:01:40 | hydrant | 4 | 151207 | 777 | 9.983 | 15146.4 |
371 | 2023-08-23 05:39:09 | hydrant | 3 | 134027 | 76 | 6.156 | 21771.8 |
370 | 2023-08-17 00:12:50 | hydrant | 1 | 69583 | 3 | 1.033 | 67360.1 |
369 | 2023-08-13 17:18:53 | hydrant | 4 | 151207 | 777 | 10.813 | 13983.8 |
368 | 2023-07-27 21:00:32 | hydrant | 4 | 151207 | 777 | 9.406 | 16075.6 |
367 | 2023-07-19 01:42:53 | hydrant | 4 | 151207 | 777 | 11.250 | 13440.6 |
366 | 2023-07-16 14:12:27 | hydrant | 3 | 134027 | 76 | 5.626 | 23822.8 |
365 | 2023-06-16 14:40:36 | hydrant | 3 | 134027 | 76 | 6.063 | 22105.7 |
364 | 2023-06-16 00:25:29 | hydrant | 4 | 151207 | 777 | 10.080 | 15000.7 |
363 | 2023-06-13 14:20:45 | hydrant | 3 | 134027 | 76 | 5.720 | 23431.3 |
362 | 2023-06-04 01:35:24 | hydrant | 1 | 69583 | 3 | 1.000 | 69583.0 |
361 | 2023-05-22 13:17:59 | hydrant | 4 | 151207 | 777 | 10.640 | 14211.2 |
360 | 2023-05-21 23:34:38 | hydrant | 3 | 134027 | 76 | 5.360 | 25005.0 |
359 | 2023-05-20 14:57:08 | hydrant | 1 | 69583 | 3 | 1.030 | 67556.3 |
358 | 2023-05-17 22:09:16 | hydrant | 1 | 69583 | 3 | 1.076 | 64668.2 |
357 | 2023-05-07 10:10:08 | hydrant | 3 | 134027 | 76 | 6.186 | 21666.2 |
356 | 2023-04-30 02:29:25 | hydrant | 4 | 151207 | 777 | 9.220 | 16399.9 |
355 | 2023-04-03 07:52:24 | hydrant | 4 | 151207 | 777 | 12.033 | 12566.0 |
354 | 2023-04-02 20:17:03 | hydrant | 3 | 134027 | 76 | 5.376 | 24930.6 |
353 | 2023-03-31 13:08:17 | hydrant | 4 | 151207 | 777 | 11.250 | 13440.6 |
352 | 2023-03-25 07:19:20 | hydrant | 4 | 151207 | 777 | 9.093 | 16628.9 |
351 | 2023-03-18 13:27:46 | hydrant | 1 | 69583 | 3 | 1.000 | 69583.0 |
350 | 2023-02-15 17:22:47 | hydrant | 1 | 69583 | 3 | 1.096 | 63488.1 |
349 | 2023-02-12 23:01:57 | hydrant | 3 | 134027 | 76 | 5.313 | 25226.2 |
348 | 2023-02-03 17:10:55 | hydrant | 4 | 151207 | 777 | 9.126 | 16568.8 |
347 | 2023-01-13 15:05:52 | hydrant | 4 | 151207 | 777 | 10.063 | 15026.0 |
346 | 2023-01-06 09:07:57 | hydrant | 1 | 69583 | 3 | 1.030 | 67556.3 |
345 | 2022-12-01 03:32:38 | hydrant | 4 | 151207 | 777 | 13.660 | 11069.3 |
344 | 2022-11-29 11:50:18 | hydrant | 4 | 151207 | 777 | 10.236 | 14772.1 |
343 | 2022-11-25 19:24:57 | hydrant | 1 | 69583 | 3 | 1.170 | 59472.6 |
342 | 2022-11-24 12:03:46 | hydrant | 3 | 134027 | 76 | 5.326 | 25164.7 |
341 | 2022-11-16 18:23:07 | hydrant | 4 | 151207 | 777 | 11.423 | 13237.1 |
340 | 2022-11-13 07:27:31 | hydrant | 4 | 151207 | 777 | 9.220 | 16399.9 |
339 | 2022-11-10 01:52:53 | hydrant | 1 | 69583 | 3 | 1.126 | 61796.6 |
338 | 2022-11-05 13:41:40 | hydrant | 4 | 151207 | 777 | 9.190 | 16453.4 |
337 | 2022-11-05 12:40:35 | hydrant | 4 | 151207 | 777 | 11.296 | 13385.9 |
336 | 2022-10-22 07:09:06 | hydrant | 1 | 69583 | 3 | 1.000 | 69583.0 |
335 | 2022-10-22 06:09:22 | hydrant | 4 | 151207 | 777 | 9.033 | 16739.4 |
334 | 2022-10-06 09:27:15 | hydrant | 1 | 69583 | 3 | 1.033 | 67360.1 |
333 | 2022-09-20 07:58:41 | hydrant | 4 | 151207 | 777 | 9.296 | 16265.8 |
332 | 2022-07-09 21:32:02 | hydrant | 1 | 69583 | 3 | 1.203 | 57841.2 |
331 | 2022-06-20 10:48:05 | hydrant | 4 | 151207 | 777 | 9.376 | 16127.0 |
330 | 2022-06-18 05:33:10 | hydrant | 4 | 151207 | 777 | 10.046 | 15051.5 |
329 | 2022-06-09 20:46:23 | hydrant | 1 | 69583 | 3 | 1.156 | 60192.9 |
328 | 2022-06-06 06:09:35 | hydrant | 1 | 69583 | 3 | 1.030 | 67556.3 |
327 | 2022-05-29 11:12:55 | hydrant | 1 | 69583 | 3 | 1.033 | 67360.1 |