History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sunray"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
295 | 2024-05-04 02:30:57 | sunray | 1 | 48755 | 2 | 0.936 | 52088.7 |
294 | 2024-04-29 20:32:35 | sunray | 2 | 82551 | 33 | 2.690 | 30688.1 |
293 | 2024-04-29 20:32:10 | sunray | 3 | 112716 | 443 | 5.626 | 20034.8 |
292 | 2024-04-26 16:55:11 | sunray | 3 | 112716 | 443 | 5.703 | 19764.3 |
291 | 2024-04-25 22:00:40 | sunray | 1 | 48755 | 2 | 2.606 | 18708.7 |
290 | 2024-04-05 21:20:23 | sunray | 1 | 48755 | 2 | 2.830 | 17227.9 |
289 | 2024-04-05 06:42:18 | sunray | 2 | 82551 | 33 | 2.780 | 29694.6 |
288 | 2024-04-05 06:42:16 | sunray | 1 | 48755 | 2 | 0.923 | 52822.3 |
287 | 2024-04-02 18:45:33 | sunray | 3 | 112716 | 443 | 9.360 | 12042.3 |
286 | 2024-04-01 16:58:39 | sunray | 3 | 112716 | 443 | 12.626 | 8927.3 |
285 | 2024-03-31 13:51:23 | sunray | 3 | 112716 | 443 | 17.173 | 6563.6 |
284 | 2024-03-31 02:24:15 | sunray | 2 | 82551 | 33 | 2.890 | 28564.4 |
283 | 2024-03-31 02:24:14 | sunray | 1 | 48755 | 2 | 1.843 | 26454.2 |
282 | 2024-03-31 02:23:54 | sunray | 3 | 112716 | 443 | 9.046 | 12460.3 |
281 | 2024-03-30 01:27:45 | sunray | 3 | 112716 | 443 | 15.173 | 7428.7 |
280 | 2024-03-30 01:27:46 | sunray | 2 | 82551 | 33 | 10.216 | 8080.6 |
279 | 2024-03-30 01:05:22 | sunray | 3 | 112716 | 443 | 12.906 | 8733.6 |
278 | 2024-03-30 01:05:19 | sunray | 2 | 82551 | 33 | 5.000 | 16510.2 |
277 | 2024-03-30 01:03:29 | sunray | 1 | 48755 | 2 | 2.890 | 16870.2 |
276 | 2024-03-28 23:46:23 | sunray | 1 | 48755 | 2 | 2.986 | 16327.9 |
275 | 2024-03-06 19:37:46 | sunray | 1 | 48755 | 2 | 2.263 | 21544.4 |
274 | 2024-03-01 05:32:33 | sunray | 3 | 112716 | 443 | 11.970 | 9416.5 |
273 | 2024-02-28 06:10:27 | sunray | 2 | 82551 | 33 | 5.280 | 15634.7 |
272 | 2024-02-28 06:09:47 | sunray | 3 | 112716 | 443 | 6.080 | 18538.8 |
271 | 2024-02-28 03:27:15 | sunray | 2 | 82551 | 33 | 2.873 | 28733.4 |
270 | 2024-02-27 21:49:58 | sunray | 3 | 112716 | 443 | 16.660 | 6765.7 |
269 | 2024-02-27 21:03:24 | sunray | 3 | 112716 | 443 | 5.610 | 20092.0 |
268 | 2024-02-27 21:03:23 | sunray | 2 | 82551 | 33 | 2.670 | 30918.0 |
267 | 2024-02-27 21:03:20 | sunray | 1 | 48755 | 2 | 0.890 | 54780.9 |
266 | 2024-01-16 11:08:45 | sunray | 1 | 48755 | 2 | 0.763 | 63899.1 |
265 | 2023-12-12 21:28:17 | sunray | 3 | 112716 | 443 | 6.076 | 18551.0 |
264 | 2023-12-12 21:28:14 | sunray | 2 | 82551 | 33 | 2.656 | 31080.9 |
263 | 2023-11-19 17:38:29 | sunray | 1 | 48755 | 2 | 0.860 | 56691.9 |
262 | 2023-11-11 06:10:11 | sunray | 1 | 48755 | 2 | 0.813 | 59969.2 |
261 | 2023-11-11 03:51:11 | sunray | 1 | 48755 | 2 | 0.856 | 56956.8 |
260 | 2023-11-05 17:53:52 | sunray | 1 | 48755 | 2 | 0.873 | 55847.7 |
259 | 2023-11-04 03:22:25 | sunray | 1 | 48755 | 2 | 0.750 | 65006.7 |
258 | 2023-10-31 04:56:58 | sunray | 1 | 48755 | 2 | 0.860 | 56691.9 |
257 | 2023-10-15 12:29:26 | sunray | 1 | 48755 | 2 | 0.766 | 63648.8 |
256 | 2023-10-08 03:51:33 | sunray | 1 | 48755 | 2 | 0.890 | 54780.9 |
255 | 2023-10-05 06:14:41 | sunray | 1 | 48755 | 2 | 0.923 | 52822.3 |
254 | 2023-09-26 09:37:06 | sunray | 1 | 48755 | 2 | 0.750 | 65006.7 |
253 | 2023-09-13 13:40:58 | sunray | 1 | 48755 | 2 | 0.856 | 56956.8 |
252 | 2023-08-31 00:14:50 | sunray | 1 | 48755 | 2 | 0.750 | 65006.7 |
251 | 2023-06-01 12:46:02 | sunray | 1 | 48755 | 2 | 1.483 | 32875.9 |
250 | 2023-02-09 16:13:33 | sunray | 1 | 48755 | 2 | 0.733 | 66514.3 |
249 | 2022-10-01 08:21:02 | sunray | 1 | 48755 | 2 | 0.813 | 59969.2 |
248 | 2022-05-14 16:27:30 | sunray | 1 | 48755 | 2 | 0.766 | 63648.8 |
247 | 2022-01-10 03:29:17 | sunray | 1 | 48755 | 2 | 0.796 | 61250.0 |
246 | 2021-09-21 04:12:40 | sunray | 1 | 48755 | 2 | 0.860 | 56691.9 |
245 | 2021-07-03 01:47:52 | sunray | 1 | 48755 | 2 | 0.763 | 63899.1 |
244 | 2021-04-16 04:37:39 | sunray | 1 | 48755 | 2 | 0.766 | 63648.8 |
243 | 2021-01-29 01:55:52 | sunray | 1 | 48755 | 2 | 0.826 | 59025.4 |
242 | 2020-12-31 11:38:47 | sunray | 1 | 48755 | 2 | 0.750 | 65006.7 |
241 | 2020-11-09 14:15:15 | sunray | 1 | 48755 | 2 | 0.936 | 52088.7 |
240 | 2020-10-24 09:33:32 | sunray | 1 | 48755 | 2 | 1.453 | 33554.7 |
239 | 2020-09-09 15:24:54 | sunray | 1 | 48755 | 2 | 0.860 | 56691.9 |
238 | 2020-08-24 04:57:25 | sunray | 1 | 48755 | 2 | 0.766 | 63648.8 |
237 | 2020-06-07 01:16:27 | sunray | 1 | 48755 | 2 | 0.796 | 61250.0 |
236 | 2020-03-26 17:14:36 | sunray | 1 | 48755 | 2 | 1.796 | 27146.4 |
235 | 2020-03-25 17:21:01 | sunray | 1 | 48755 | 2 | 0.936 | 52088.7 |
234 | 2020-03-24 18:04:53 | sunray | 1 | 48755 | 2 | 0.906 | 53813.5 |
233 | 2020-03-23 03:59:50 | sunray | 1 | 48755 | 2 | 0.860 | 56691.9 |
232 | 2020-03-23 01:42:28 | sunray | 1 | 48755 | 2 | 0.890 | 54780.9 |
231 | 2020-03-21 01:07:42 | sunray | 1 | 48755 | 2 | 0.906 | 53813.5 |
230 | 2020-03-19 00:02:09 | sunray | 1 | 48755 | 2 | 0.750 | 65006.7 |
229 | 2020-03-17 22:58:34 | sunray | 1 | 48755 | 2 | 0.783 | 62266.9 |
228 | 2020-03-16 05:02:01 | sunray | 1 | 48755 | 2 | 0.766 | 63648.8 |
227 | 2020-02-26 02:10:39 | sunray | 1 | 48755 | 2 | 1.720 | 28345.9 |
226 | 2020-02-23 23:58:04 | sunray | 1 | 48755 | 2 | 1.796 | 27146.4 |
225 | 2020-02-23 00:46:38 | sunray | 1 | 48755 | 2 | 0.953 | 51159.5 |
224 | 2020-02-17 15:15:14 | sunray | 1 | 48755 | 2 | 0.826 | 59025.4 |
223 | 2020-02-11 21:31:07 | sunray | 1 | 48755 | 2 | 1.986 | 24549.3 |
222 | 2020-02-01 13:51:41 | sunray | 1 | 48755 | 2 | 0.986 | 49447.3 |
221 | 2020-01-31 11:44:51 | sunray | 1 | 48755 | 2 | 0.983 | 49598.2 |
220 | 2020-01-30 04:24:38 | sunray | 1 | 48755 | 2 | 0.953 | 51159.5 |
219 | 2020-01-25 11:37:48 | sunray | 1 | 48755 | 2 | 0.983 | 49598.2 |
218 | 2020-01-24 18:49:26 | sunray | 1 | 48755 | 2 | 1.936 | 25183.4 |
217 | 2020-01-22 01:32:18 | sunray | 1 | 48755 | 2 | 0.970 | 50262.9 |
216 | 2020-01-12 07:32:16 | sunray | 1 | 48755 | 2 | 1.013 | 48129.3 |
215 | 2020-01-12 06:15:15 | sunray | 1 | 48755 | 2 | 1.923 | 25353.6 |
214 | 2020-01-11 18:54:56 | sunray | 1 | 48755 | 2 | 0.763 | 63899.1 |
213 | 2020-01-08 05:11:32 | sunray | 1 | 48755 | 2 | 1.953 | 24964.2 |
212 | 2020-01-03 09:17:37 | sunray | 1 | 48755 | 2 | 0.906 | 53813.5 |
211 | 2019-12-26 13:06:50 | sunray | 1 | 48755 | 2 | 0.920 | 52994.6 |
210 | 2019-12-24 11:57:09 | sunray | 1 | 48755 | 2 | 0.780 | 62506.4 |
209 | 2019-12-24 07:59:20 | sunray | 1 | 48755 | 2 | 0.846 | 57630.0 |
208 | 2019-12-23 23:21:10 | sunray | 1 | 48755 | 2 | 0.796 | 61250.0 |
207 | 2019-12-10 12:29:42 | sunray | 1 | 48755 | 2 | 0.860 | 56691.9 |
206 | 2019-10-20 06:31:04 | sunray | 1 | 48755 | 2 | 0.796 | 61250.0 |
205 | 2019-09-08 16:32:07 | sunray | 1 | 48755 | 2 | 0.696 | 70050.3 |
204 | 2019-08-29 04:38:29 | sunray | 1 | 48755 | 2 | 0.853 | 57157.1 |
203 | 2019-06-10 16:31:22 | sunray | 1 | 48755 | 2 | 0.840 | 58041.7 |
202 | 2019-06-09 00:16:03 | sunray | 1 | 48755 | 2 | 0.836 | 58319.4 |
201 | 2019-06-03 23:38:14 | sunray | 1 | 48755 | 2 | 0.863 | 56494.8 |
200 | 2019-03-12 20:40:18 | sunray | 1 | 48755 | 2 | 0.756 | 64490.7 |
199 | 2019-02-24 14:54:14 | sunray | 1 | 48755 | 2 | 0.760 | 64151.3 |
198 | 2019-01-14 03:25:30 | sunray | 1 | 48755 | 2 | 0.850 | 57358.8 |
197 | 2019-01-08 16:29:56 | sunray | 1 | 48755 | 2 | 0.743 | 65619.1 |
196 | 2019-01-07 12:28:50 | sunray | 1 | 48755 | 2 | 0.740 | 65885.1 |