History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"luminaire"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
332 | 2025-08-12 16:47:18 | luminaire | 4 | 165329 | 162 | 30.360 | 5445.6 |
331 | 2025-08-10 23:22:51 | luminaire | 4 | 165329 | 162 | 36.846 | 4487.0 |
330 | 2025-07-31 23:54:57 | luminaire | 4 | 165329 | 162 | 58.220 | 2839.7 |
329 | 2025-07-25 22:35:51 | luminaire | 1 | 81242 | 2 | 1.376 | 59042.2 |
328 | 2025-07-25 06:45:19 | luminaire | 1 | 81242 | 2 | 4.123 | 19704.6 |
327 | 2025-07-24 11:36:02 | luminaire | 1 | 81242 | 2 | 7.593 | 10699.6 |
326 | 2025-07-24 02:25:48 | luminaire | 1 | 81242 | 2 | 6.296 | 12903.7 |
325 | 2025-07-22 22:06:03 | luminaire | 4 | 165329 | 162 | 39.366 | 4199.8 |
324 | 2025-07-22 00:57:40 | luminaire | 4 | 165329 | 162 | 82.146 | 2012.6 |
323 | 2025-07-18 18:49:56 | luminaire | 4 | 165329 | 162 | 64.533 | 2561.9 |
322 | 2025-07-14 12:19:51 | luminaire | 4 | 165329 | 162 | 53.736 | 3076.7 |
321 | 2025-07-14 05:18:35 | luminaire | 4 | 165329 | 162 | 86.926 | 1902.0 |
320 | 2025-07-13 19:05:14 | luminaire | 2 | 121436 | 6 | 23.126 | 5251.1 |
319 | 2025-07-11 19:50:57 | luminaire | 2 | 121436 | 6 | 17.716 | 6854.6 |
318 | 2025-07-11 09:44:25 | luminaire | 4 | 165329 | 162 | 58.890 | 2807.4 |
317 | 2025-07-11 03:00:58 | luminaire | 3 | 148641 | 24 | 27.876 | 5332.2 |
316 | 2025-07-10 16:44:56 | luminaire | 1 | 81242 | 2 | 7.173 | 11326.1 |
315 | 2025-07-10 08:40:50 | luminaire | 1 | 81242 | 2 | 1.423 | 57092.1 |
314 | 2025-06-29 22:19:48 | luminaire | 2 | 121436 | 6 | 8.956 | 13559.2 |
313 | 2025-06-24 03:56:28 | luminaire | 2 | 121436 | 6 | 12.360 | 9824.9 |
312 | 2025-06-23 09:14:44 | luminaire | 1 | 81242 | 2 | 1.406 | 57782.4 |
311 | 2025-06-10 01:50:00 | luminaire | 1 | 81242 | 2 | 6.876 | 11815.3 |
310 | 2025-06-06 16:32:19 | luminaire | 4 | 165329 | 162 | 36.673 | 4508.2 |
309 | 2025-05-28 16:39:45 | luminaire | 3 | 148641 | 24 | 11.703 | 12701.1 |
308 | 2025-05-26 09:43:46 | luminaire | 3 | 148641 | 24 | 35.016 | 4244.9 |
307 | 2025-05-18 16:56:30 | luminaire | 1 | 81242 | 2 | 5.783 | 14048.4 |
306 | 2025-05-17 19:53:42 | luminaire | 3 | 148641 | 24 | 30.296 | 4906.3 |
305 | 2025-05-07 12:59:40 | luminaire | 1 | 81242 | 2 | 1.390 | 58447.5 |
304 | 2025-05-06 11:38:45 | luminaire | 4 | 165329 | 162 | 46.643 | 3544.6 |
303 | 2025-05-05 00:40:46 | luminaire | 3 | 148641 | 24 | 6.953 | 21378.0 |
302 | 2025-05-04 14:37:44 | luminaire | 1 | 81242 | 2 | 7.923 | 10253.9 |
301 | 2025-05-03 23:46:26 | luminaire | 3 | 148641 | 24 | 22.360 | 6647.6 |
300 | 2025-05-02 16:57:24 | luminaire | 4 | 165329 | 162 | 66.536 | 2484.8 |
299 | 2025-05-01 23:40:52 | luminaire | 3 | 148641 | 24 | 19.156 | 7759.5 |
298 | 2025-05-01 06:39:28 | luminaire | 2 | 121436 | 6 | 24.613 | 4933.8 |
297 | 2025-04-27 09:12:04 | luminaire | 1 | 81242 | 2 | 1.343 | 60492.9 |
296 | 2025-04-27 03:56:22 | luminaire | 4 | 165329 | 162 | 15.453 | 10698.8 |
295 | 2025-04-27 01:17:04 | luminaire | 2 | 121436 | 6 | 3.610 | 33638.8 |
294 | 2025-04-26 22:55:13 | luminaire | 3 | 148641 | 24 | 6.296 | 23608.8 |
293 | 2025-04-25 16:55:42 | luminaire | 3 | 148641 | 24 | 7.673 | 19372.0 |
292 | 2025-04-23 01:28:33 | luminaire | 1 | 81242 | 2 | 5.076 | 16005.1 |
291 | 2025-04-22 11:35:43 | luminaire | 3 | 148641 | 24 | 27.470 | 5411.0 |
290 | 2025-04-09 05:17:52 | luminaire | 1 | 81242 | 2 | 6.456 | 12584.0 |
289 | 2025-04-05 10:34:54 | luminaire | 2 | 121436 | 6 | 3.360 | 36141.7 |
288 | 2025-04-03 19:17:36 | luminaire | 3 | 148641 | 24 | 6.843 | 21721.6 |
287 | 2025-03-31 18:02:11 | luminaire | 1 | 81242 | 2 | 7.140 | 11378.4 |
286 | 2025-03-31 18:00:48 | luminaire | 2 | 121436 | 6 | 8.750 | 13878.4 |
285 | 2025-03-31 17:49:50 | luminaire | 3 | 148641 | 24 | 26.626 | 5582.6 |
284 | 2025-03-27 17:50:50 | luminaire | 1 | 81242 | 2 | 3.140 | 25873.2 |
283 | 2025-03-27 17:20:37 | luminaire | 1 | 81242 | 2 | 12.283 | 6614.2 |
282 | 2025-03-27 16:17:14 | luminaire | 2 | 121436 | 6 | 14.420 | 8421.4 |
281 | 2025-03-26 02:55:58 | luminaire | 4 | 165329 | 162 | 49.876 | 3314.8 |
280 | 2025-03-26 00:16:48 | luminaire | 3 | 148641 | 24 | 7.143 | 20809.3 |
279 | 2025-03-25 11:03:28 | luminaire | 4 | 165329 | 162 | 72.756 | 2272.4 |
278 | 2025-03-24 11:42:40 | luminaire | 1 | 81242 | 2 | 4.483 | 18122.2 |
277 | 2025-03-24 05:29:11 | luminaire | 4 | 165329 | 162 | 50.970 | 3243.7 |
276 | 2025-03-24 02:30:20 | luminaire | 2 | 121436 | 6 | 8.593 | 14132.0 |
275 | 2025-03-23 02:12:18 | luminaire | 1 | 81242 | 2 | 3.033 | 26786.0 |
274 | 2025-03-22 18:27:59 | luminaire | 3 | 148641 | 24 | 6.500 | 22867.8 |
273 | 2025-03-17 16:09:24 | luminaire | 3 | 148641 | 24 | 22.580 | 6582.9 |
272 | 2025-02-21 04:25:01 | luminaire | 3 | 148641 | 24 | 42.313 | 3512.9 |
271 | 2025-02-21 04:25:07 | luminaire | 3 | 148641 | 24 | 27.143 | 5476.2 |
270 | 2025-02-21 04:25:07 | luminaire | 2 | 121436 | 6 | 25.656 | 4733.2 |
269 | 2025-02-21 04:23:13 | luminaire | 1 | 81242 | 2 | 4.893 | 16603.7 |
268 | 2025-02-04 21:27:44 | luminaire | 3 | 148641 | 24 | 33.266 | 4468.3 |
267 | 2025-02-03 06:28:55 | luminaire | 3 | 148641 | 24 | 41.890 | 3548.4 |
266 | 2025-02-03 06:28:48 | luminaire | 2 | 121436 | 6 | 23.796 | 5103.2 |
265 | 2025-02-03 06:28:27 | luminaire | 1 | 81242 | 2 | 6.576 | 12354.3 |
264 | 2025-01-29 09:22:34 | luminaire | 3 | 148641 | 24 | 36.240 | 4101.6 |
263 | 2025-01-29 09:22:27 | luminaire | 2 | 121436 | 6 | 17.380 | 6987.1 |
262 | 2025-01-29 09:22:02 | luminaire | 3 | 148641 | 24 | 22.083 | 6731.0 |
261 | 2025-01-29 09:21:06 | luminaire | 1 | 81242 | 2 | 5.250 | 15474.7 |
260 | 2025-01-22 19:08:43 | luminaire | 1 | 81242 | 2 | 9.970 | 8148.6 |
259 | 2025-01-21 04:15:48 | luminaire | 2 | 121436 | 6 | 25.796 | 4707.6 |
258 | 2025-01-21 04:15:35 | luminaire | 3 | 148641 | 24 | 37.220 | 3993.6 |
257 | 2025-01-21 04:15:17 | luminaire | 3 | 148641 | 24 | 46.113 | 3223.4 |
256 | 2025-01-21 04:13:44 | luminaire | 1 | 81242 | 2 | 5.186 | 15665.6 |
255 | 2024-12-21 11:49:43 | luminaire | 1 | 81242 | 2 | 6.576 | 12354.3 |
254 | 2024-12-19 10:58:23 | luminaire | 2 | 121436 | 6 | 16.613 | 7309.7 |
253 | 2024-12-19 10:57:32 | luminaire | 1 | 81242 | 2 | 6.330 | 12834.4 |
252 | 2024-12-16 09:49:39 | luminaire | 3 | 148641 | 24 | 37.500 | 3963.8 |
251 | 2024-12-16 09:49:43 | luminaire | 2 | 121436 | 6 | 21.063 | 5765.4 |
250 | 2024-12-16 09:48:01 | luminaire | 1 | 81242 | 2 | 4.640 | 17509.1 |
249 | 2024-12-13 05:31:08 | luminaire | 2 | 121436 | 6 | 8.673 | 14001.6 |
248 | 2024-12-13 05:29:02 | luminaire | 1 | 81242 | 2 | 2.796 | 29056.5 |
247 | 2024-12-06 10:25:23 | luminaire | 3 | 148641 | 24 | 31.596 | 4704.4 |
246 | 2024-12-03 05:39:01 | luminaire | 3 | 148641 | 24 | 24.143 | 6156.7 |
245 | 2024-11-18 23:13:44 | luminaire | 4 | 165329 | 162 | 69.240 | 2387.8 |
244 | 2024-11-18 23:13:52 | luminaire | 3 | 148641 | 24 | 34.613 | 4294.4 |
243 | 2024-11-18 23:13:56 | luminaire | 2 | 121436 | 6 | 17.720 | 6853.0 |
242 | 2024-11-12 10:48:50 | luminaire | 2 | 121436 | 6 | 17.596 | 6901.3 |
241 | 2024-11-12 02:03:02 | luminaire | 1 | 81242 | 2 | 1.360 | 59736.8 |
240 | 2024-11-06 23:31:00 | luminaire | 1 | 81242 | 2 | 5.190 | 15653.6 |
239 | 2024-11-03 13:21:55 | luminaire | 4 | 165329 | 162 | 32.313 | 5116.5 |
238 | 2024-11-03 13:21:30 | luminaire | 3 | 148641 | 24 | 24.113 | 6164.4 |
237 | 2024-11-03 13:21:23 | luminaire | 2 | 121436 | 6 | 18.360 | 6614.2 |
236 | 2024-11-03 02:35:58 | luminaire | 4 | 165329 | 162 | 51.880 | 3186.8 |
235 | 2024-11-03 02:35:42 | luminaire | 3 | 148641 | 24 | 37.266 | 3988.6 |
234 | 2024-11-01 20:45:13 | luminaire | 4 | 165329 | 162 | 67.940 | 2433.5 |
233 | 2024-11-01 20:45:22 | luminaire | 2 | 121436 | 6 | 21.423 | 5668.5 |