History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"substance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
370 | 2025-09-09 05:19:55 | substance | 1 | 81242 | 2 | 1.453 | 55913.3 |
369 | 2025-09-08 22:11:06 | substance | 1 | 81242 | 2 | 1.283 | 63321.9 |
368 | 2025-08-29 20:50:41 | substance | 1 | 81242 | 2 | 1.470 | 55266.7 |
367 | 2025-08-09 19:03:03 | substance | 1 | 81242 | 2 | 8.283 | 9808.3 |
366 | 2025-07-25 16:28:10 | substance | 1 | 81242 | 2 | 3.576 | 22718.7 |
365 | 2025-07-24 03:01:03 | substance | 1 | 81242 | 2 | 6.436 | 12623.1 |
364 | 2025-07-10 17:45:22 | substance | 3 | 148641 | 33 | 28.343 | 5244.4 |
363 | 2025-07-09 22:36:36 | substance | 1 | 81242 | 2 | 5.423 | 14981.0 |
362 | 2025-07-08 02:59:53 | substance | 3 | 148641 | 33 | 56.410 | 2635.0 |
361 | 2025-07-06 23:15:20 | substance | 1 | 81242 | 2 | 3.390 | 23965.2 |
360 | 2025-07-05 12:02:45 | substance | 4 | 165329 | 247 | 47.986 | 3445.4 |
359 | 2025-07-05 05:22:19 | substance | 3 | 148641 | 33 | 28.563 | 5204.0 |
358 | 2025-07-02 00:13:30 | substance | 4 | 165329 | 247 | 38.240 | 4323.5 |
357 | 2025-06-30 23:33:07 | substance | 2 | 121436 | 5 | 3.140 | 38673.9 |
356 | 2025-06-30 22:36:14 | substance | 4 | 165329 | 247 | 19.440 | 8504.6 |
355 | 2025-06-29 19:18:05 | substance | 3 | 148641 | 33 | 6.876 | 21617.4 |
354 | 2025-06-26 17:44:43 | substance | 1 | 81242 | 2 | 8.703 | 9334.9 |
353 | 2025-06-21 12:08:24 | substance | 1 | 81242 | 2 | 1.263 | 64324.6 |
352 | 2025-06-12 07:09:02 | substance | 3 | 148641 | 33 | 33.513 | 4435.3 |
351 | 2025-05-31 10:39:41 | substance | 3 | 148641 | 33 | 38.050 | 3906.5 |
350 | 2025-05-31 06:21:32 | substance | 1 | 81242 | 2 | 6.643 | 12229.7 |
349 | 2025-05-28 07:31:49 | substance | 1 | 81242 | 2 | 1.500 | 54161.3 |
348 | 2025-05-23 22:22:11 | substance | 1 | 81242 | 2 | 5.750 | 14129.0 |
347 | 2025-05-20 02:41:38 | substance | 1 | 81242 | 2 | 3.703 | 21939.5 |
346 | 2025-05-19 22:21:40 | substance | 1 | 81242 | 2 | 3.813 | 21306.6 |
345 | 2025-05-15 07:08:52 | substance | 1 | 81242 | 2 | 1.310 | 62016.8 |
344 | 2025-05-02 03:07:53 | substance | 1 | 81242 | 2 | 5.390 | 15072.7 |
343 | 2025-04-25 23:37:32 | substance | 2 | 121436 | 5 | 9.796 | 12396.5 |
342 | 2025-04-25 19:01:58 | substance | 3 | 148641 | 33 | 63.613 | 2336.6 |
341 | 2025-04-25 16:27:24 | substance | 1 | 81242 | 2 | 3.640 | 22319.2 |
340 | 2025-04-23 00:38:40 | substance | 1 | 81242 | 2 | 4.190 | 19389.5 |
339 | 2025-04-19 21:35:38 | substance | 1 | 81242 | 2 | 3.830 | 21212.0 |
338 | 2025-04-19 18:49:21 | substance | 1 | 81242 | 2 | 1.483 | 54782.2 |
337 | 2025-04-15 21:53:08 | substance | 1 | 81242 | 2 | 7.266 | 11181.1 |
336 | 2025-04-09 16:41:22 | substance | 1 | 81242 | 2 | 8.843 | 9187.2 |
335 | 2025-04-03 02:12:51 | substance | 1 | 81242 | 2 | 1.766 | 46003.4 |
334 | 2025-03-24 00:33:09 | substance | 2 | 121436 | 5 | 12.953 | 9375.1 |
333 | 2025-03-23 20:05:14 | substance | 3 | 148641 | 33 | 38.573 | 3853.5 |
332 | 2025-03-22 18:42:22 | substance | 1 | 81242 | 2 | 1.470 | 55266.7 |
331 | 2025-03-18 10:31:01 | substance | 1 | 81242 | 2 | 5.843 | 13904.2 |
330 | 2025-02-11 10:15:05 | substance | 1 | 81242 | 2 | 7.313 | 11109.3 |
329 | 2025-02-10 02:16:02 | substance | 1 | 81242 | 2 | 8.206 | 9900.3 |
328 | 2025-02-05 18:24:58 | substance | 1 | 81242 | 2 | 5.390 | 15072.7 |
327 | 2025-01-26 20:32:16 | substance | 1 | 81242 | 2 | 1.390 | 58447.5 |
326 | 2025-01-25 12:33:23 | substance | 1 | 81242 | 2 | 11.440 | 7101.6 |
325 | 2025-01-09 17:09:09 | substance | 1 | 81242 | 2 | 1.470 | 55266.7 |
324 | 2025-01-03 19:09:05 | substance | 3 | 148641 | 33 | 41.173 | 3610.2 |
323 | 2025-01-03 19:09:01 | substance | 2 | 121436 | 5 | 24.093 | 5040.3 |
322 | 2025-01-03 19:06:30 | substance | 1 | 81242 | 2 | 5.486 | 14809.0 |
321 | 2025-01-03 15:33:48 | substance | 3 | 148641 | 33 | 44.723 | 3323.6 |
320 | 2025-01-03 15:33:51 | substance | 3 | 148641 | 33 | 35.766 | 4155.9 |
319 | 2025-01-03 14:52:31 | substance | 1 | 81242 | 2 | 1.280 | 63470.3 |
318 | 2025-01-03 11:31:42 | substance | 3 | 148641 | 33 | 40.126 | 3704.4 |
317 | 2025-01-03 06:37:53 | substance | 3 | 148641 | 33 | 45.580 | 3261.1 |
316 | 2025-01-03 06:37:44 | substance | 4 | 165329 | 247 | 49.440 | 3344.0 |
315 | 2025-01-03 06:37:50 | substance | 2 | 121436 | 5 | 17.533 | 6926.1 |
314 | 2024-12-14 03:42:27 | substance | 1 | 81242 | 2 | 3.156 | 25742.1 |
313 | 2024-12-06 17:30:22 | substance | 1 | 81242 | 2 | 3.813 | 21306.6 |
312 | 2024-12-02 15:29:15 | substance | 1 | 81242 | 2 | 9.750 | 8332.5 |
311 | 2024-11-25 09:17:43 | substance | 1 | 81242 | 2 | 2.936 | 27671.0 |
310 | 2024-11-08 03:41:30 | substance | 1 | 81242 | 2 | 1.250 | 64993.6 |
309 | 2024-11-07 09:35:57 | substance | 3 | 148641 | 33 | 24.470 | 6074.4 |
308 | 2024-11-03 13:16:42 | substance | 2 | 121436 | 5 | 17.483 | 6945.9 |
307 | 2024-11-03 13:09:11 | substance | 1 | 81242 | 2 | 10.096 | 8046.9 |
306 | 2024-11-02 10:54:38 | substance | 3 | 148641 | 33 | 36.596 | 4061.7 |
305 | 2024-11-02 09:15:42 | substance | 3 | 148641 | 33 | 35.220 | 4220.4 |
304 | 2024-11-02 09:15:24 | substance | 3 | 148641 | 33 | 35.660 | 4168.3 |
303 | 2024-11-02 09:15:28 | substance | 2 | 121436 | 5 | 26.660 | 4555.0 |
302 | 2024-11-02 09:15:02 | substance | 1 | 81242 | 2 | 3.453 | 23527.9 |
301 | 2024-10-24 13:14:29 | substance | 1 | 81242 | 2 | 8.280 | 9811.8 |
300 | 2024-10-08 08:36:13 | substance | 1 | 81242 | 2 | 12.940 | 6278.4 |
299 | 2024-09-23 12:06:31 | substance | 3 | 148641 | 33 | 41.833 | 3553.2 |
298 | 2024-09-20 21:32:55 | substance | 2 | 121436 | 5 | 24.936 | 4869.9 |
297 | 2024-09-20 21:31:59 | substance | 1 | 81242 | 2 | 5.033 | 16141.9 |
296 | 2024-09-15 01:49:58 | substance | 1 | 81242 | 2 | 10.470 | 7759.5 |
295 | 2024-09-10 22:41:56 | substance | 2 | 121436 | 5 | 18.156 | 6688.5 |
294 | 2024-09-06 13:17:21 | substance | 2 | 121436 | 5 | 41.720 | 2910.7 |
293 | 2024-09-04 16:29:53 | substance | 3 | 148641 | 33 | 64.223 | 2314.5 |
292 | 2024-09-04 16:29:59 | substance | 2 | 121436 | 5 | 36.283 | 3346.9 |
291 | 2024-09-03 15:24:07 | substance | 1 | 81242 | 2 | 11.780 | 6896.6 |
290 | 2024-08-18 23:52:54 | substance | 1 | 81242 | 2 | 8.473 | 9588.3 |
289 | 2024-08-10 01:57:30 | substance | 1 | 81242 | 2 | 3.733 | 21763.2 |
288 | 2024-08-09 11:38:03 | substance | 2 | 121436 | 5 | 11.920 | 10187.6 |
287 | 2024-08-07 14:48:35 | substance | 3 | 148641 | 33 | 27.296 | 5445.5 |
286 | 2024-08-07 07:53:52 | substance | 3 | 148641 | 33 | 34.860 | 4263.9 |
285 | 2024-08-03 15:18:45 | substance | 3 | 148641 | 33 | 30.033 | 4949.3 |
284 | 2024-07-26 07:54:31 | substance | 3 | 148641 | 33 | 36.206 | 4105.4 |
283 | 2024-07-21 20:52:38 | substance | 4 | 165329 | 247 | 62.143 | 2660.5 |
282 | 2024-07-20 03:04:50 | substance | 1 | 81242 | 2 | 6.280 | 12936.6 |
281 | 2024-07-19 22:12:48 | substance | 4 | 165329 | 247 | 50.266 | 3289.1 |
280 | 2024-07-18 14:54:22 | substance | 4 | 165329 | 247 | 65.113 | 2539.1 |
279 | 2024-07-18 10:28:50 | substance | 4 | 165329 | 247 | 55.970 | 2953.9 |
278 | 2024-07-18 10:01:35 | substance | 4 | 165329 | 247 | 25.410 | 6506.5 |
277 | 2024-07-18 10:01:37 | substance | 3 | 148641 | 33 | 21.613 | 6877.4 |
276 | 2024-07-18 10:01:40 | substance | 2 | 121436 | 5 | 12.096 | 10039.4 |
275 | 2024-07-18 09:59:27 | substance | 1 | 81242 | 2 | 2.623 | 30972.9 |
274 | 2024-07-04 03:15:32 | substance | 1 | 81242 | 2 | 7.300 | 11129.0 |
273 | 2024-06-28 02:56:48 | substance | 4 | 165329 | 247 | 16.516 | 10010.2 |
272 | 2024-06-20 04:26:45 | substance | 3 | 148641 | 33 | 25.410 | 5849.7 |
271 | 2024-06-17 17:32:20 | substance | 3 | 148641 | 33 | 21.530 | 6903.9 |