History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"occupant"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
399 | 2025-08-18 20:42:51 | occupant | 1 | 82945 | 2 | 6.813 | 12174.5 |
398 | 2025-08-08 23:36:37 | occupant | 1 | 82945 | 2 | 5.906 | 14044.2 |
397 | 2025-08-06 00:30:44 | occupant | 3 | 146162 | 25 | 17.393 | 8403.5 |
396 | 2025-08-01 01:38:41 | occupant | 3 | 146162 | 25 | 21.830 | 6695.5 |
395 | 2025-07-23 22:17:26 | occupant | 1 | 82945 | 2 | 5.000 | 16589.0 |
394 | 2025-07-11 16:44:41 | occupant | 2 | 121059 | 5 | 13.593 | 8906.0 |
393 | 2025-07-09 20:35:07 | occupant | 1 | 82945 | 2 | 1.483 | 55930.5 |
392 | 2025-07-06 22:53:09 | occupant | 1 | 82945 | 2 | 6.830 | 12144.2 |
391 | 2025-05-30 19:31:27 | occupant | 3 | 146162 | 25 | 30.156 | 4846.9 |
390 | 2025-05-26 14:12:45 | occupant | 1 | 82945 | 2 | 10.236 | 8103.3 |
389 | 2025-05-25 20:48:16 | occupant | 1 | 82945 | 2 | 3.706 | 22381.3 |
388 | 2025-05-22 14:34:02 | occupant | 1 | 82945 | 2 | 5.346 | 15515.3 |
387 | 2025-05-22 08:48:32 | occupant | 3 | 146162 | 25 | 39.220 | 3726.7 |
386 | 2025-05-18 07:32:24 | occupant | 3 | 146162 | 25 | 25.436 | 5746.3 |
385 | 2025-05-18 01:36:19 | occupant | 2 | 121059 | 5 | 18.063 | 6702.0 |
384 | 2025-05-17 15:13:05 | occupant | 1 | 82945 | 2 | 1.546 | 53651.4 |
383 | 2025-05-17 07:12:38 | occupant | 3 | 146162 | 25 | 34.083 | 4288.4 |
382 | 2025-05-10 22:28:17 | occupant | 4 | 161609 | 186 | 66.030 | 2447.5 |
381 | 2025-05-10 20:00:01 | occupant | 4 | 161609 | 186 | 63.080 | 2562.0 |
380 | 2025-05-10 19:34:20 | occupant | 3 | 146162 | 25 | 29.456 | 4962.0 |
379 | 2025-05-10 18:18:35 | occupant | 4 | 161609 | 186 | 60.630 | 2665.5 |
378 | 2025-05-10 03:03:42 | occupant | 1 | 82945 | 2 | 5.956 | 13926.3 |
377 | 2025-05-08 07:41:02 | occupant | 4 | 161609 | 186 | 62.083 | 2603.1 |
376 | 2025-05-07 23:16:13 | occupant | 1 | 82945 | 2 | 8.203 | 10111.5 |
375 | 2025-05-07 00:28:09 | occupant | 1 | 82945 | 2 | 3.046 | 27230.8 |
374 | 2025-05-07 00:15:51 | occupant | 2 | 121059 | 5 | 3.920 | 30882.4 |
373 | 2025-05-06 22:13:09 | occupant | 3 | 146162 | 25 | 28.486 | 5131.0 |
372 | 2025-05-05 19:39:40 | occupant | 1 | 82945 | 2 | 1.500 | 55296.7 |
371 | 2025-04-24 20:51:46 | occupant | 1 | 82945 | 2 | 1.373 | 60411.5 |
370 | 2025-04-06 13:30:32 | occupant | 1 | 82945 | 2 | 10.233 | 8105.6 |
369 | 2025-03-27 02:24:28 | occupant | 2 | 121059 | 5 | 26.670 | 4539.1 |
368 | 2025-03-25 07:04:31 | occupant | 3 | 146162 | 25 | 36.113 | 4047.4 |
367 | 2025-03-24 13:39:42 | occupant | 2 | 121059 | 5 | 16.156 | 7493.1 |
366 | 2025-03-24 11:36:45 | occupant | 3 | 146162 | 25 | 41.956 | 3483.7 |
365 | 2025-03-21 21:39:13 | occupant | 1 | 82945 | 2 | 1.360 | 60989.0 |
364 | 2025-03-21 09:17:07 | occupant | 3 | 146162 | 25 | 25.033 | 5838.8 |
363 | 2025-03-21 01:50:23 | occupant | 2 | 121059 | 5 | 17.970 | 6736.7 |
362 | 2025-03-20 04:06:21 | occupant | 1 | 82945 | 2 | 3.483 | 23814.2 |
361 | 2025-03-17 17:53:28 | occupant | 1 | 82945 | 2 | 8.830 | 9393.5 |
360 | 2025-03-13 22:11:13 | occupant | 1 | 82945 | 2 | 7.046 | 11771.9 |
359 | 2025-03-12 17:08:00 | occupant | 3 | 146162 | 25 | 42.643 | 3427.6 |
358 | 2025-03-12 11:34:54 | occupant | 3 | 146162 | 25 | 32.923 | 4439.5 |
357 | 2025-03-08 14:37:47 | occupant | 3 | 146162 | 25 | 55.160 | 2649.8 |
356 | 2025-03-05 11:25:32 | occupant | 2 | 121059 | 5 | 8.423 | 14372.4 |
355 | 2025-03-05 11:18:55 | occupant | 1 | 82945 | 2 | 3.516 | 23590.7 |
354 | 2025-03-04 06:59:31 | occupant | 4 | 161609 | 186 | 58.056 | 2783.7 |
353 | 2025-03-04 00:01:16 | occupant | 4 | 161609 | 186 | 58.423 | 2766.2 |
352 | 2025-03-04 00:01:15 | occupant | 2 | 121059 | 5 | 18.520 | 6536.7 |
351 | 2025-03-03 19:56:10 | occupant | 3 | 146162 | 25 | 25.610 | 5707.2 |
350 | 2025-03-02 00:01:13 | occupant | 3 | 146162 | 25 | 35.656 | 4099.2 |
349 | 2025-02-24 17:00:14 | occupant | 4 | 161609 | 186 | 47.843 | 3377.9 |
348 | 2025-02-16 20:21:06 | occupant | 3 | 146162 | 25 | 28.500 | 5128.5 |
347 | 2025-02-13 14:15:24 | occupant | 1 | 82945 | 2 | 5.310 | 15620.5 |
346 | 2025-02-12 09:51:38 | occupant | 2 | 121059 | 5 | 10.173 | 11900.0 |
345 | 2025-02-02 18:53:45 | occupant | 3 | 146162 | 25 | 43.513 | 3359.0 |
344 | 2025-02-01 19:08:16 | occupant | 2 | 121059 | 5 | 22.470 | 5387.6 |
343 | 2025-01-29 02:39:16 | occupant | 1 | 82945 | 2 | 3.236 | 25632.0 |
342 | 2025-01-26 23:56:24 | occupant | 2 | 121059 | 5 | 12.686 | 9542.7 |
341 | 2025-01-26 22:42:52 | occupant | 4 | 161609 | 186 | 53.830 | 3002.2 |
340 | 2025-01-24 22:49:00 | occupant | 4 | 161609 | 186 | 53.753 | 3006.5 |
339 | 2025-01-24 19:06:52 | occupant | 4 | 161609 | 186 | 10.860 | 14881.1 |
338 | 2025-01-24 19:06:34 | occupant | 3 | 146162 | 25 | 6.903 | 21173.7 |
337 | 2025-01-23 02:19:52 | occupant | 3 | 146162 | 25 | 34.850 | 4194.0 |
336 | 2025-01-21 02:04:37 | occupant | 3 | 146162 | 25 | 18.220 | 8022.1 |
335 | 2025-01-14 07:59:19 | occupant | 1 | 82945 | 2 | 7.546 | 10991.9 |
334 | 2025-01-14 07:57:29 | occupant | 3 | 146162 | 25 | 7.313 | 19986.6 |
333 | 2025-01-09 21:36:02 | occupant | 2 | 121059 | 5 | 3.436 | 35232.5 |
332 | 2025-01-09 21:36:02 | occupant | 1 | 82945 | 2 | 1.406 | 58993.6 |
331 | 2024-12-26 15:35:35 | occupant | 2 | 121059 | 5 | 3.483 | 34757.1 |
330 | 2024-12-26 14:24:25 | occupant | 3 | 146162 | 25 | 45.800 | 3191.3 |
329 | 2024-12-25 19:14:30 | occupant | 2 | 121059 | 5 | 27.300 | 4434.4 |
328 | 2024-12-25 19:14:16 | occupant | 1 | 82945 | 2 | 9.983 | 8308.6 |
327 | 2024-12-25 07:10:24 | occupant | 3 | 146162 | 25 | 30.126 | 4851.7 |
326 | 2024-12-21 00:41:45 | occupant | 4 | 161609 | 186 | 23.876 | 6768.7 |
325 | 2024-12-21 00:41:48 | occupant | 3 | 146162 | 25 | 13.063 | 11189.0 |
324 | 2024-12-19 22:58:32 | occupant | 3 | 146162 | 25 | 7.296 | 20033.2 |
323 | 2024-12-19 22:58:33 | occupant | 2 | 121059 | 5 | 3.970 | 30493.5 |
322 | 2024-12-15 08:57:59 | occupant | 4 | 161609 | 186 | 44.720 | 3613.8 |
321 | 2024-12-14 23:53:37 | occupant | 1 | 82945 | 2 | 6.623 | 12523.8 |
320 | 2024-12-13 16:46:00 | occupant | 4 | 161609 | 186 | 57.676 | 2802.0 |
319 | 2024-12-11 00:23:40 | occupant | 4 | 161609 | 186 | 13.233 | 12212.6 |
318 | 2024-11-28 00:14:49 | occupant | 4 | 161609 | 186 | 63.770 | 2534.2 |
317 | 2024-11-26 00:26:57 | occupant | 1 | 82945 | 2 | 6.830 | 12144.2 |
316 | 2024-11-20 13:12:35 | occupant | 4 | 161609 | 186 | 58.940 | 2741.9 |
315 | 2024-11-20 08:24:53 | occupant | 1 | 82945 | 2 | 5.030 | 16490.1 |
314 | 2024-11-08 16:40:03 | occupant | 4 | 161609 | 186 | 51.393 | 3144.6 |
313 | 2024-11-08 04:08:31 | occupant | 4 | 161609 | 186 | 28.736 | 5623.9 |
312 | 2024-11-07 20:27:19 | occupant | 4 | 161609 | 186 | 11.970 | 13501.2 |
311 | 2024-11-07 20:27:19 | occupant | 2 | 121059 | 5 | 3.546 | 34139.6 |
310 | 2024-11-07 20:27:08 | occupant | 1 | 82945 | 2 | 1.330 | 62364.7 |
309 | 2024-11-02 12:41:26 | occupant | 1 | 82945 | 2 | 3.593 | 23085.2 |
308 | 2024-10-24 10:28:30 | occupant | 3 | 146162 | 25 | 17.203 | 8496.3 |
307 | 2024-10-20 04:11:10 | occupant | 3 | 146162 | 25 | 19.283 | 7579.8 |
306 | 2024-10-20 04:11:06 | occupant | 2 | 121059 | 5 | 9.670 | 12519.0 |
305 | 2024-10-20 04:10:50 | occupant | 1 | 82945 | 2 | 5.920 | 14011.0 |
304 | 2024-10-20 00:08:40 | occupant | 3 | 146162 | 25 | 63.446 | 2303.7 |
303 | 2024-10-19 16:00:19 | occupant | 3 | 146162 | 25 | 34.580 | 4226.8 |
302 | 2024-10-07 23:10:57 | occupant | 1 | 82945 | 2 | 10.296 | 8056.0 |
301 | 2024-09-19 00:40:34 | occupant | 3 | 146162 | 25 | 43.876 | 3331.3 |
300 | 2024-09-18 15:31:22 | occupant | 3 | 146162 | 25 | 57.613 | 2537.0 |