History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"thermostat"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
345 | 2025-08-19 06:58:12 | thermostat | 4 | 161450 | 61 | 40.273 | 4008.9 |
344 | 2025-08-17 12:07:25 | thermostat | 1 | 67641 | 2 | 2.216 | 30523.9 |
343 | 2025-08-11 09:30:07 | thermostat | 1 | 67641 | 2 | 2.873 | 23543.7 |
342 | 2025-08-04 13:01:12 | thermostat | 1 | 67641 | 2 | 5.686 | 11896.1 |
341 | 2025-07-23 20:30:51 | thermostat | 1 | 67641 | 2 | 3.796 | 17819.0 |
340 | 2025-07-21 22:05:55 | thermostat | 4 | 161450 | 61 | 23.813 | 6779.9 |
339 | 2025-07-18 18:24:32 | thermostat | 4 | 161450 | 61 | 44.626 | 3617.8 |
338 | 2025-07-17 17:14:51 | thermostat | 1 | 67641 | 2 | 3.076 | 21989.9 |
337 | 2025-07-17 15:43:06 | thermostat | 4 | 161450 | 61 | 30.016 | 5378.8 |
336 | 2025-07-16 10:36:36 | thermostat | 2 | 108824 | 7 | 8.093 | 13446.7 |
335 | 2025-07-16 07:02:21 | thermostat | 4 | 161450 | 61 | 51.533 | 3132.9 |
334 | 2025-07-16 04:37:33 | thermostat | 3 | 140603 | 20 | 21.780 | 6455.6 |
333 | 2025-07-15 14:56:37 | thermostat | 1 | 67641 | 2 | 2.593 | 26086.0 |
332 | 2025-07-04 12:44:37 | thermostat | 1 | 67641 | 2 | 6.923 | 9770.5 |
331 | 2025-06-14 15:03:52 | thermostat | 1 | 67641 | 2 | 2.716 | 24904.6 |
330 | 2025-06-12 12:43:26 | thermostat | 1 | 67641 | 2 | 5.686 | 11896.1 |
329 | 2025-05-20 10:43:52 | thermostat | 1 | 67641 | 2 | 7.606 | 8893.1 |
328 | 2025-05-20 09:35:01 | thermostat | 1 | 67641 | 2 | 5.513 | 12269.4 |
327 | 2025-05-20 05:17:01 | thermostat | 1 | 67641 | 2 | 7.986 | 8469.9 |
326 | 2025-05-12 23:47:50 | thermostat | 1 | 67641 | 2 | 6.876 | 9837.3 |
325 | 2025-05-12 18:22:36 | thermostat | 1 | 67641 | 2 | 2.250 | 30062.7 |
324 | 2025-05-08 15:07:20 | thermostat | 1 | 67641 | 2 | 4.660 | 14515.2 |
323 | 2025-04-20 12:02:57 | thermostat | 1 | 67641 | 2 | 4.733 | 14291.4 |
322 | 2025-03-23 16:54:19 | thermostat | 1 | 67641 | 2 | 5.773 | 11716.8 |
321 | 2025-03-20 10:04:47 | thermostat | 3 | 140603 | 20 | 20.890 | 6730.6 |
320 | 2025-03-06 04:40:57 | thermostat | 3 | 140603 | 20 | 33.440 | 4204.6 |
319 | 2025-03-06 04:40:54 | thermostat | 2 | 108824 | 7 | 15.703 | 6930.1 |
318 | 2025-03-06 04:40:04 | thermostat | 1 | 67641 | 2 | 5.343 | 12659.7 |
317 | 2025-03-01 16:48:01 | thermostat | 3 | 140603 | 20 | 31.030 | 4531.2 |
316 | 2025-02-25 02:57:03 | thermostat | 1 | 67641 | 2 | 5.156 | 13118.9 |
315 | 2025-02-23 15:29:02 | thermostat | 1 | 67641 | 2 | 5.140 | 13159.7 |
314 | 2025-02-18 18:05:25 | thermostat | 2 | 108824 | 7 | 15.186 | 7166.1 |
313 | 2025-02-16 10:08:33 | thermostat | 3 | 140603 | 20 | 34.373 | 4090.5 |
312 | 2025-02-16 05:43:50 | thermostat | 3 | 140603 | 20 | 37.673 | 3732.2 |
311 | 2025-02-16 05:43:40 | thermostat | 3 | 140603 | 20 | 29.140 | 4825.1 |
310 | 2025-02-16 05:42:12 | thermostat | 1 | 67641 | 2 | 3.783 | 17880.3 |
309 | 2025-02-03 01:54:45 | thermostat | 3 | 140603 | 20 | 32.546 | 4320.1 |
308 | 2025-02-03 01:54:34 | thermostat | 2 | 108824 | 7 | 8.173 | 13315.1 |
307 | 2025-02-01 07:02:58 | thermostat | 3 | 140603 | 20 | 33.063 | 4252.6 |
306 | 2025-01-28 20:02:29 | thermostat | 3 | 140603 | 20 | 24.470 | 5745.9 |
305 | 2025-01-28 20:01:49 | thermostat | 3 | 140603 | 20 | 34.236 | 4106.9 |
304 | 2025-01-28 20:01:49 | thermostat | 3 | 140603 | 20 | 31.940 | 4402.1 |
303 | 2025-01-28 20:01:49 | thermostat | 2 | 108824 | 7 | 7.536 | 14440.6 |
302 | 2025-01-28 19:13:15 | thermostat | 1 | 67641 | 2 | 1.080 | 62630.6 |
301 | 2025-01-23 13:02:23 | thermostat | 3 | 140603 | 20 | 38.940 | 3610.8 |
300 | 2025-01-23 13:02:25 | thermostat | 3 | 140603 | 20 | 30.830 | 4560.6 |
299 | 2025-01-19 03:28:01 | thermostat | 1 | 67641 | 2 | 7.673 | 8815.5 |
298 | 2025-01-03 01:19:20 | thermostat | 2 | 108824 | 7 | 12.656 | 8598.6 |
297 | 2025-01-03 00:00:20 | thermostat | 2 | 108824 | 7 | 19.423 | 5602.8 |
296 | 2025-01-02 23:57:27 | thermostat | 1 | 67641 | 2 | 2.296 | 29460.4 |
295 | 2025-01-01 09:07:46 | thermostat | 3 | 140603 | 20 | 32.643 | 4307.3 |
294 | 2024-12-31 21:35:53 | thermostat | 3 | 140603 | 20 | 33.396 | 4210.2 |
293 | 2024-12-30 07:50:42 | thermostat | 3 | 140603 | 20 | 39.736 | 3538.4 |
292 | 2024-12-30 07:50:47 | thermostat | 3 | 140603 | 20 | 30.876 | 4553.8 |
291 | 2024-12-30 07:50:42 | thermostat | 2 | 108824 | 7 | 15.813 | 6881.9 |
290 | 2024-12-30 07:50:39 | thermostat | 3 | 140603 | 20 | 16.763 | 8387.7 |
289 | 2024-12-30 06:16:28 | thermostat | 1 | 67641 | 2 | 1.076 | 62863.4 |
288 | 2024-12-28 14:29:16 | thermostat | 1 | 67641 | 2 | 2.236 | 30250.9 |
287 | 2024-12-19 16:41:46 | thermostat | 1 | 67641 | 2 | 3.110 | 21749.5 |
286 | 2024-11-30 22:29:12 | thermostat | 3 | 140603 | 20 | 31.250 | 4499.3 |
285 | 2024-11-30 22:29:09 | thermostat | 3 | 140603 | 20 | 34.233 | 4107.2 |
284 | 2024-11-26 11:07:34 | thermostat | 1 | 67641 | 2 | 0.983 | 68810.8 |
283 | 2024-11-26 03:53:06 | thermostat | 1 | 67641 | 2 | 4.216 | 16043.9 |
282 | 2024-11-17 17:05:42 | thermostat | 1 | 67641 | 2 | 5.610 | 12057.2 |
281 | 2024-11-15 14:37:33 | thermostat | 3 | 140603 | 20 | 30.296 | 4641.0 |
280 | 2024-11-15 14:37:34 | thermostat | 2 | 108824 | 7 | 10.876 | 10005.9 |
279 | 2024-11-15 14:36:47 | thermostat | 3 | 140603 | 20 | 42.446 | 3312.5 |
278 | 2024-11-15 14:36:47 | thermostat | 3 | 140603 | 20 | 34.443 | 4082.2 |
277 | 2024-11-15 14:31:41 | thermostat | 1 | 67641 | 2 | 3.906 | 17317.2 |
276 | 2024-10-26 22:12:03 | thermostat | 1 | 67641 | 2 | 2.546 | 26567.6 |
275 | 2024-10-25 23:57:32 | thermostat | 1 | 67641 | 2 | 1.173 | 57665.0 |
274 | 2024-10-17 14:19:49 | thermostat | 3 | 140603 | 20 | 33.470 | 4200.9 |
273 | 2024-10-15 09:11:55 | thermostat | 3 | 140603 | 20 | 33.626 | 4181.4 |
272 | 2024-10-15 09:11:54 | thermostat | 3 | 140603 | 20 | 31.846 | 4415.1 |
271 | 2024-10-15 09:12:10 | thermostat | 2 | 108824 | 7 | 15.500 | 7020.9 |
270 | 2024-10-15 09:06:23 | thermostat | 1 | 67641 | 2 | 4.733 | 14291.4 |
269 | 2024-10-13 14:34:25 | thermostat | 3 | 140603 | 20 | 33.250 | 4228.7 |
268 | 2024-10-11 10:17:24 | thermostat | 3 | 140603 | 20 | 28.550 | 4924.8 |
267 | 2024-10-11 10:17:30 | thermostat | 2 | 108824 | 7 | 12.266 | 8872.0 |
266 | 2024-10-11 10:01:03 | thermostat | 1 | 67641 | 2 | 1.093 | 61885.6 |
265 | 2024-09-17 20:12:22 | thermostat | 1 | 67641 | 2 | 10.750 | 6292.2 |
264 | 2024-09-13 03:34:49 | thermostat | 3 | 140603 | 20 | 56.656 | 2481.7 |
263 | 2024-09-10 07:31:57 | thermostat | 3 | 140603 | 20 | 50.316 | 2794.4 |
262 | 2024-09-09 03:46:04 | thermostat | 1 | 67641 | 2 | 10.890 | 6211.3 |
261 | 2024-09-08 08:31:38 | thermostat | 3 | 140603 | 20 | 49.410 | 2845.6 |
260 | 2024-08-25 18:45:41 | thermostat | 3 | 140603 | 20 | 60.173 | 2336.6 |
259 | 2024-08-23 22:41:38 | thermostat | 3 | 140603 | 20 | 42.816 | 3283.9 |
258 | 2024-08-23 12:52:54 | thermostat | 3 | 140603 | 20 | 38.903 | 3614.2 |
257 | 2024-08-23 12:52:35 | thermostat | 3 | 140603 | 20 | 49.796 | 2823.6 |
256 | 2024-08-23 12:52:41 | thermostat | 2 | 108824 | 7 | 25.720 | 4231.1 |
255 | 2024-08-14 21:18:39 | thermostat | 4 | 161450 | 61 | 96.163 | 1678.9 |
254 | 2024-08-14 21:18:53 | thermostat | 3 | 140603 | 20 | 70.506 | 1994.2 |
253 | 2024-08-14 21:18:52 | thermostat | 2 | 108824 | 7 | 24.906 | 4369.4 |
252 | 2024-08-14 21:17:21 | thermostat | 1 | 67641 | 2 | 7.406 | 9133.3 |
251 | 2024-08-10 01:01:14 | thermostat | 4 | 161450 | 61 | 44.910 | 3595.0 |
250 | 2024-08-06 18:30:57 | thermostat | 4 | 161450 | 61 | 31.656 | 5100.1 |
249 | 2024-08-06 18:30:42 | thermostat | 1 | 67641 | 2 | 2.000 | 33820.5 |
248 | 2024-08-06 18:30:38 | thermostat | 2 | 108824 | 7 | 4.470 | 24345.4 |
247 | 2024-08-06 17:58:26 | thermostat | 1 | 67641 | 2 | 5.173 | 13075.8 |
246 | 2024-08-04 02:13:44 | thermostat | 4 | 161450 | 61 | 43.300 | 3728.6 |