History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"facility"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
359 | 2025-07-17 14:36:20 | facility | 3 | 146162 | 109 | 19.720 | 7411.9 |
358 | 2025-07-12 04:27:34 | facility | 1 | 82945 | 1 | 1.453 | 57085.3 |
357 | 2025-07-08 20:03:59 | facility | 1 | 82945 | 1 | 1.436 | 57761.1 |
356 | 2025-07-08 11:12:37 | facility | 2 | 121059 | 16 | 17.203 | 7037.1 |
355 | 2025-07-08 00:02:34 | facility | 1 | 82945 | 1 | 7.263 | 11420.2 |
354 | 2025-07-06 20:24:15 | facility | 3 | 146162 | 109 | 8.080 | 18089.4 |
353 | 2025-07-05 23:31:45 | facility | 3 | 146162 | 109 | 35.970 | 4063.4 |
352 | 2025-07-04 20:36:12 | facility | 3 | 146162 | 109 | 31.283 | 4672.3 |
351 | 2025-07-02 18:42:47 | facility | 2 | 121059 | 16 | 14.640 | 8269.1 |
350 | 2025-07-02 18:29:42 | facility | 3 | 146162 | 109 | 50.953 | 2868.6 |
349 | 2025-07-01 17:36:18 | facility | 1 | 82945 | 1 | 1.453 | 57085.3 |
348 | 2025-06-28 19:28:48 | facility | 1 | 82945 | 1 | 1.406 | 58993.6 |
347 | 2025-06-26 09:22:15 | facility | 1 | 82945 | 1 | 6.623 | 12523.8 |
346 | 2025-06-25 03:23:38 | facility | 2 | 121059 | 16 | 18.096 | 6689.8 |
345 | 2025-06-23 14:52:10 | facility | 2 | 121059 | 16 | 3.330 | 36354.1 |
344 | 2025-06-10 05:25:15 | facility | 1 | 82945 | 1 | 3.810 | 21770.3 |
343 | 2025-06-07 23:25:34 | facility | 1 | 82945 | 1 | 6.983 | 11878.1 |
342 | 2025-05-25 20:03:03 | facility | 3 | 146162 | 109 | 29.236 | 4999.4 |
341 | 2025-05-25 09:00:19 | facility | 1 | 82945 | 1 | 4.876 | 17010.9 |
340 | 2025-05-23 06:47:03 | facility | 1 | 82945 | 1 | 1.530 | 54212.4 |
339 | 2025-05-18 07:43:56 | facility | 1 | 82945 | 1 | 5.546 | 14955.8 |
338 | 2025-05-08 00:06:40 | facility | 1 | 82945 | 1 | 3.780 | 21943.1 |
337 | 2025-04-23 08:52:18 | facility | 1 | 82945 | 1 | 3.376 | 24569.0 |
336 | 2025-04-22 20:07:22 | facility | 3 | 146162 | 109 | 42.020 | 3478.4 |
335 | 2025-04-21 04:13:51 | facility | 3 | 146162 | 109 | 48.080 | 3040.0 |
334 | 2025-04-20 15:54:45 | facility | 1 | 82945 | 1 | 1.406 | 58993.6 |
333 | 2025-04-16 06:47:31 | facility | 1 | 82945 | 1 | 7.326 | 11322.0 |
332 | 2025-03-24 00:54:11 | facility | 2 | 121059 | 16 | 18.610 | 6505.1 |
331 | 2025-03-22 17:15:18 | facility | 3 | 146162 | 109 | 34.876 | 4190.9 |
330 | 2025-03-22 10:47:42 | facility | 1 | 82945 | 1 | 1.420 | 58412.0 |
329 | 2025-03-21 06:10:09 | facility | 3 | 146162 | 109 | 45.516 | 3211.2 |
328 | 2025-03-20 22:35:38 | facility | 1 | 82945 | 1 | 5.563 | 14910.1 |
327 | 2025-03-19 17:45:07 | facility | 3 | 146162 | 109 | 6.986 | 20922.1 |
326 | 2025-03-16 15:27:25 | facility | 2 | 121059 | 16 | 18.876 | 6413.4 |
325 | 2025-03-14 07:42:32 | facility | 2 | 121059 | 16 | 17.390 | 6961.4 |
324 | 2025-03-14 05:27:28 | facility | 2 | 121059 | 16 | 15.050 | 8043.8 |
323 | 2025-03-13 14:45:21 | facility | 1 | 82945 | 1 | 3.686 | 22502.7 |
322 | 2025-03-10 07:19:35 | facility | 1 | 82945 | 1 | 6.080 | 13642.3 |
321 | 2025-03-08 05:18:34 | facility | 2 | 121059 | 16 | 13.033 | 9288.7 |
320 | 2025-03-06 04:24:39 | facility | 2 | 121059 | 16 | 18.796 | 6440.7 |
319 | 2025-03-01 10:40:42 | facility | 3 | 146162 | 109 | 38.876 | 3759.7 |
318 | 2025-02-28 12:35:31 | facility | 3 | 146162 | 109 | 38.063 | 3840.0 |
317 | 2025-02-27 13:51:30 | facility | 3 | 146162 | 109 | 36.266 | 4030.3 |
316 | 2025-02-27 07:57:33 | facility | 3 | 146162 | 109 | 28.770 | 5080.4 |
315 | 2025-02-27 05:09:00 | facility | 3 | 146162 | 109 | 30.843 | 4738.9 |
314 | 2025-02-09 13:57:17 | facility | 1 | 82945 | 1 | 3.263 | 25419.9 |
313 | 2025-02-05 15:22:46 | facility | 2 | 121059 | 16 | 9.686 | 12498.3 |
312 | 2025-01-30 04:07:11 | facility | 3 | 146162 | 109 | 46.923 | 3114.9 |
311 | 2025-01-30 04:07:08 | facility | 2 | 121059 | 16 | 9.173 | 13197.3 |
310 | 2025-01-27 19:35:55 | facility | 3 | 146162 | 109 | 36.780 | 3974.0 |
309 | 2025-01-27 02:04:04 | facility | 2 | 121059 | 16 | 9.266 | 13064.9 |
308 | 2025-01-27 01:02:49 | facility | 3 | 146162 | 109 | 11.140 | 13120.5 |
307 | 2025-01-26 13:33:51 | facility | 1 | 82945 | 1 | 9.876 | 8398.6 |
306 | 2025-01-25 00:20:39 | facility | 3 | 146162 | 109 | 8.173 | 17883.5 |
305 | 2025-01-25 00:20:36 | facility | 2 | 121059 | 16 | 3.813 | 31749.0 |
304 | 2025-01-25 00:19:58 | facility | 1 | 82945 | 1 | 2.936 | 28251.0 |
303 | 2025-01-08 18:08:19 | facility | 1 | 82945 | 1 | 6.610 | 12548.4 |
302 | 2025-01-02 18:18:45 | facility | 1 | 82945 | 1 | 4.173 | 19876.6 |
301 | 2024-12-19 19:17:58 | facility | 1 | 82945 | 1 | 9.250 | 8967.0 |
300 | 2024-12-16 13:37:31 | facility | 1 | 82945 | 1 | 3.516 | 23590.7 |
299 | 2024-11-16 05:30:52 | facility | 3 | 146162 | 109 | 35.910 | 4070.2 |
298 | 2024-11-14 15:58:17 | facility | 2 | 121059 | 16 | 16.110 | 7514.5 |
297 | 2024-11-13 16:46:17 | facility | 2 | 121059 | 16 | 3.656 | 33112.4 |
296 | 2024-11-12 15:36:00 | facility | 3 | 146162 | 109 | 23.923 | 6109.7 |
295 | 2024-11-12 14:50:06 | facility | 3 | 146162 | 109 | 47.110 | 3102.6 |
294 | 2024-11-12 11:41:04 | facility | 3 | 146162 | 109 | 48.656 | 3004.0 |
293 | 2024-11-12 11:41:03 | facility | 2 | 121059 | 16 | 17.763 | 6815.2 |
292 | 2024-11-12 10:53:30 | facility | 1 | 82945 | 1 | 6.643 | 12486.1 |
291 | 2024-11-12 05:39:42 | facility | 1 | 82945 | 1 | 1.500 | 55296.7 |
290 | 2024-11-05 13:01:48 | facility | 1 | 82945 | 1 | 6.826 | 12151.3 |
289 | 2024-10-29 16:10:46 | facility | 1 | 82945 | 1 | 6.843 | 12121.1 |
288 | 2024-10-16 14:16:06 | facility | 1 | 82945 | 1 | 7.313 | 11342.1 |
287 | 2024-10-09 12:25:20 | facility | 1 | 82945 | 1 | 5.750 | 14425.2 |
286 | 2024-10-06 01:58:54 | facility | 1 | 82945 | 1 | 15.703 | 5282.1 |
285 | 2024-09-11 17:18:20 | facility | 1 | 82945 | 1 | 4.093 | 20265.1 |
284 | 2024-09-11 17:18:13 | facility | 1 | 82945 | 1 | 7.766 | 10680.5 |
283 | 2024-09-08 02:27:40 | facility | 1 | 82945 | 1 | 5.986 | 13856.5 |
282 | 2024-09-04 17:10:47 | facility | 1 | 82945 | 1 | 18.673 | 4442.0 |
281 | 2024-08-28 00:03:40 | facility | 1 | 82945 | 1 | 16.200 | 5120.1 |
280 | 2024-08-20 04:50:51 | facility | 1 | 82945 | 1 | 19.016 | 4361.9 |
279 | 2024-08-16 05:51:32 | facility | 1 | 82945 | 1 | 6.593 | 12580.8 |
278 | 2024-08-01 23:36:01 | facility | 1 | 82945 | 1 | 6.860 | 12091.1 |
277 | 2024-07-23 06:34:31 | facility | 1 | 82945 | 1 | 6.296 | 13174.2 |
276 | 2024-07-11 00:28:32 | facility | 1 | 82945 | 1 | 5.236 | 15841.3 |
275 | 2024-07-09 02:59:30 | facility | 1 | 82945 | 1 | 6.516 | 12729.4 |
274 | 2024-07-07 02:58:07 | facility | 1 | 82945 | 1 | 5.280 | 15709.3 |
273 | 2024-07-02 05:50:38 | facility | 3 | 146162 | 109 | 31.753 | 4603.1 |
272 | 2024-07-01 02:35:51 | facility | 3 | 146162 | 109 | 41.050 | 3560.6 |
271 | 2024-06-26 09:30:47 | facility | 2 | 121059 | 16 | 4.346 | 27855.3 |
270 | 2024-06-24 19:26:49 | facility | 3 | 146162 | 109 | 39.656 | 3685.7 |
269 | 2024-06-24 14:07:27 | facility | 3 | 146162 | 109 | 30.236 | 4834.0 |
268 | 2024-06-22 22:38:57 | facility | 2 | 121059 | 16 | 9.940 | 12179.0 |
267 | 2024-06-22 22:36:42 | facility | 3 | 146162 | 109 | 8.733 | 16736.7 |
266 | 2024-06-21 14:22:17 | facility | 3 | 146162 | 109 | 18.063 | 8091.8 |
265 | 2024-06-21 14:22:19 | facility | 2 | 121059 | 16 | 14.080 | 8597.9 |
264 | 2024-06-21 14:22:21 | facility | 1 | 82945 | 1 | 7.280 | 11393.5 |
263 | 2024-06-13 05:12:32 | facility | 1 | 82945 | 1 | 4.796 | 17294.6 |
262 | 2024-06-11 12:07:39 | facility | 2 | 121059 | 16 | 6.626 | 18270.3 |
261 | 2024-06-10 09:40:28 | facility | 2 | 121059 | 16 | 11.126 | 10880.7 |
260 | 2024-06-10 02:22:21 | facility | 1 | 82945 | 1 | 5.156 | 16087.1 |