History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparkily"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
220 | 2024-05-04 15:27:38 | sparkily | 1 | 82945 | 3 | 1.826 | 45424.4 |
219 | 2024-05-02 11:07:38 | sparkily | 1 | 82945 | 3 | 4.453 | 18626.8 |
218 | 2024-04-30 17:47:57 | sparkily | 1 | 82945 | 3 | 5.076 | 16340.6 |
217 | 2024-04-18 22:39:45 | sparkily | 1 | 82945 | 3 | 1.640 | 50576.2 |
216 | 2024-04-11 07:42:04 | sparkily | 2 | 121059 | 25 | 3.406 | 35542.9 |
215 | 2024-04-11 07:41:53 | sparkily | 3 | 146162 | 142 | 8.436 | 17326.0 |
214 | 2024-04-08 22:12:04 | sparkily | 3 | 146162 | 142 | 17.030 | 8582.6 |
213 | 2024-04-08 05:59:08 | sparkily | 3 | 146162 | 142 | 14.673 | 9961.3 |
212 | 2024-04-07 17:39:55 | sparkily | 3 | 146162 | 142 | 9.610 | 15209.4 |
211 | 2024-04-06 15:10:12 | sparkily | 3 | 146162 | 142 | 15.986 | 9143.1 |
210 | 2024-04-06 15:10:07 | sparkily | 2 | 121059 | 25 | 8.140 | 14872.1 |
209 | 2024-04-06 15:09:52 | sparkily | 1 | 82945 | 3 | 3.080 | 26930.2 |
208 | 2024-04-05 06:28:45 | sparkily | 1 | 82945 | 3 | 1.733 | 47862.1 |
207 | 2024-03-30 03:19:12 | sparkily | 1 | 82945 | 3 | 3.360 | 24686.0 |
206 | 2024-03-30 03:19:02 | sparkily | 2 | 121059 | 25 | 9.670 | 12519.0 |
205 | 2024-03-19 21:44:50 | sparkily | 1 | 82945 | 3 | 2.390 | 34705.0 |
204 | 2024-03-12 03:17:40 | sparkily | 2 | 121059 | 25 | 3.653 | 33139.6 |
203 | 2024-03-12 03:17:33 | sparkily | 1 | 82945 | 3 | 1.450 | 57203.4 |
202 | 2024-03-12 03:17:22 | sparkily | 3 | 146162 | 142 | 7.096 | 20597.8 |
201 | 2024-03-08 19:11:33 | sparkily | 3 | 146162 | 142 | 19.000 | 7692.7 |
200 | 2024-03-08 19:11:28 | sparkily | 2 | 121059 | 25 | 13.686 | 8845.5 |
199 | 2024-03-08 18:55:00 | sparkily | 3 | 146162 | 142 | 25.986 | 5624.6 |
198 | 2024-03-08 18:54:58 | sparkily | 2 | 121059 | 25 | 8.530 | 14192.1 |
197 | 2024-03-08 10:16:02 | sparkily | 3 | 146162 | 142 | 25.706 | 5685.9 |
196 | 2024-03-07 08:28:25 | sparkily | 3 | 146162 | 142 | 25.360 | 5763.5 |
195 | 2024-03-07 08:28:25 | sparkily | 2 | 121059 | 25 | 13.266 | 9125.5 |
194 | 2024-03-07 06:25:33 | sparkily | 1 | 82945 | 3 | 1.766 | 46967.7 |
193 | 2024-02-11 16:33:47 | sparkily | 1 | 82945 | 3 | 1.656 | 50087.6 |
192 | 2024-02-01 03:12:56 | sparkily | 1 | 82945 | 3 | 1.483 | 55930.5 |
191 | 2024-01-21 04:01:46 | sparkily | 1 | 82945 | 3 | 3.080 | 26930.2 |
190 | 2023-12-09 09:39:35 | sparkily | 1 | 82945 | 3 | 1.313 | 63172.1 |
189 | 2023-12-01 00:00:02 | sparkily | 1 | 82945 | 3 | 1.470 | 56425.2 |
188 | 2023-11-29 21:35:44 | sparkily | 1 | 82945 | 3 | 1.436 | 57761.1 |
187 | 2023-11-27 23:32:13 | sparkily | 1 | 82945 | 3 | 1.483 | 55930.5 |
186 | 2023-10-25 01:15:05 | sparkily | 1 | 82945 | 3 | 1.470 | 56425.2 |
185 | 2023-10-17 22:38:28 | sparkily | 1 | 82945 | 3 | 1.356 | 61168.9 |
184 | 2023-09-29 00:48:47 | sparkily | 1 | 82945 | 3 | 1.423 | 58288.8 |
183 | 2023-09-14 13:40:45 | sparkily | 1 | 82945 | 3 | 1.280 | 64800.8 |
182 | 2023-09-07 04:44:15 | sparkily | 1 | 82945 | 3 | 1.283 | 64649.3 |
181 | 2023-07-01 14:22:43 | sparkily | 1 | 82945 | 3 | 1.296 | 64000.8 |
180 | 2023-05-07 07:59:36 | sparkily | 1 | 82945 | 3 | 1.310 | 63316.8 |
179 | 2023-04-10 09:35:07 | sparkily | 1 | 82945 | 3 | 1.346 | 61623.3 |
178 | 2023-01-27 12:05:42 | sparkily | 1 | 82945 | 3 | 1.266 | 65517.4 |
177 | 2023-01-06 08:22:46 | sparkily | 1 | 82945 | 3 | 1.280 | 64800.8 |
176 | 2022-11-25 20:48:56 | sparkily | 1 | 82945 | 3 | 1.470 | 56425.2 |
175 | 2022-11-15 05:04:43 | sparkily | 1 | 82945 | 3 | 1.440 | 57600.7 |
174 | 2022-08-25 23:55:55 | sparkily | 1 | 82945 | 3 | 1.330 | 62364.7 |
173 | 2022-08-15 18:55:03 | sparkily | 1 | 82945 | 3 | 1.360 | 60989.0 |
172 | 2022-07-20 16:34:05 | sparkily | 1 | 82945 | 3 | 1.313 | 63172.1 |
171 | 2022-07-19 10:50:47 | sparkily | 1 | 82945 | 3 | 1.296 | 64000.8 |
170 | 2022-04-04 09:33:25 | sparkily | 1 | 82945 | 3 | 1.640 | 50576.2 |
169 | 2022-03-20 03:52:47 | sparkily | 1 | 82945 | 3 | 1.296 | 64000.8 |
168 | 2021-12-26 03:08:49 | sparkily | 1 | 82945 | 3 | 1.390 | 59672.7 |
167 | 2021-11-27 14:26:33 | sparkily | 1 | 82945 | 3 | 1.470 | 56425.2 |
166 | 2021-11-12 07:41:26 | sparkily | 1 | 82945 | 3 | 1.406 | 58993.6 |
165 | 2021-08-07 22:55:22 | sparkily | 1 | 82945 | 3 | 2.953 | 28088.4 |
164 | 2021-08-02 06:31:18 | sparkily | 1 | 82945 | 3 | 1.283 | 64649.3 |
163 | 2021-06-05 04:44:28 | sparkily | 2 | 121059 | 25 | 3.376 | 35858.7 |
162 | 2021-05-11 01:59:12 | sparkily | 2 | 121059 | 25 | 6.436 | 18809.7 |
161 | 2021-05-09 04:09:02 | sparkily | 1 | 82945 | 3 | 1.483 | 55930.5 |
160 | 2021-04-22 18:57:03 | sparkily | 1 | 82945 | 3 | 1.530 | 54212.4 |
159 | 2021-04-09 19:50:08 | sparkily | 2 | 121059 | 25 | 3.983 | 30393.9 |
158 | 2021-04-07 13:55:52 | sparkily | 1 | 82945 | 3 | 1.440 | 57600.7 |
157 | 2021-01-24 09:23:57 | sparkily | 2 | 121059 | 25 | 3.780 | 32026.2 |
156 | 2021-01-22 16:16:27 | sparkily | 1 | 82945 | 3 | 1.483 | 55930.5 |
155 | 2021-01-10 01:18:11 | sparkily | 1 | 82945 | 3 | 1.580 | 52496.8 |
154 | 2021-01-05 14:41:34 | sparkily | 1 | 82945 | 3 | 1.500 | 55296.7 |
153 | 2020-12-26 20:31:02 | sparkily | 3 | 146162 | 142 | 6.453 | 22650.2 |
152 | 2020-12-26 02:58:23 | sparkily | 2 | 121059 | 25 | 3.233 | 37444.8 |
151 | 2020-12-23 22:38:34 | sparkily | 1 | 82945 | 3 | 1.310 | 63316.8 |
150 | 2020-10-27 22:04:30 | sparkily | 1 | 82945 | 3 | 1.283 | 64649.3 |
149 | 2020-10-27 10:45:42 | sparkily | 1 | 82945 | 3 | 1.420 | 58412.0 |
148 | 2020-10-22 20:36:34 | sparkily | 1 | 82945 | 3 | 1.453 | 57085.3 |
147 | 2020-10-22 07:19:24 | sparkily | 1 | 82945 | 3 | 1.626 | 51011.7 |
146 | 2020-09-25 15:49:51 | sparkily | 1 | 82945 | 3 | 1.330 | 62364.7 |
145 | 2020-08-19 15:04:26 | sparkily | 1 | 82945 | 3 | 1.326 | 62552.8 |
144 | 2020-07-24 19:18:18 | sparkily | 1 | 82945 | 3 | 1.376 | 60279.8 |
143 | 2020-06-02 01:45:59 | sparkily | 1 | 82945 | 3 | 1.390 | 59672.7 |
142 | 2020-04-29 17:15:17 | sparkily | 1 | 82945 | 3 | 1.300 | 63803.8 |
141 | 2020-03-22 04:33:43 | sparkily | 1 | 82945 | 3 | 2.250 | 36864.4 |
140 | 2020-02-26 17:11:29 | sparkily | 1 | 82945 | 3 | 1.283 | 64649.3 |
139 | 2020-02-25 06:43:12 | sparkily | 1 | 82945 | 3 | 2.356 | 35205.9 |
138 | 2020-02-25 01:26:40 | sparkily | 1 | 82945 | 3 | 1.440 | 57600.7 |
137 | 2020-02-20 17:27:53 | sparkily | 1 | 82945 | 3 | 1.313 | 63172.1 |
136 | 2020-02-19 14:52:46 | sparkily | 1 | 82945 | 3 | 3.250 | 25521.5 |
135 | 2020-02-17 12:02:17 | sparkily | 1 | 82945 | 3 | 1.470 | 56425.2 |
134 | 2020-02-15 13:13:22 | sparkily | 1 | 82945 | 3 | 2.203 | 37650.9 |
133 | 2020-02-12 23:33:58 | sparkily | 1 | 82945 | 3 | 4.983 | 16645.6 |
132 | 2020-01-26 18:36:27 | sparkily | 1 | 82945 | 3 | 4.753 | 17451.1 |
131 | 2020-01-23 00:59:08 | sparkily | 1 | 82945 | 3 | 1.673 | 49578.6 |
130 | 2020-01-22 14:12:20 | sparkily | 1 | 82945 | 3 | 1.593 | 52068.4 |
129 | 2020-01-22 00:11:07 | sparkily | 1 | 82945 | 3 | 3.580 | 23169.0 |
128 | 2020-01-21 22:34:55 | sparkily | 1 | 82945 | 3 | 3.516 | 23590.7 |
127 | 2020-01-16 01:32:04 | sparkily | 1 | 82945 | 3 | 1.563 | 53067.8 |
126 | 2020-01-05 04:23:07 | sparkily | 1 | 82945 | 3 | 1.516 | 54713.1 |
125 | 2019-12-30 18:59:14 | sparkily | 1 | 82945 | 3 | 1.640 | 50576.2 |
124 | 2019-12-30 05:04:27 | sparkily | 1 | 82945 | 3 | 1.453 | 57085.3 |
123 | 2019-12-26 06:33:04 | sparkily | 1 | 82945 | 3 | 3.173 | 26140.9 |
122 | 2019-11-24 19:38:56 | sparkily | 1 | 82945 | 3 | 1.310 | 63316.8 |
121 | 2019-08-22 22:54:48 | sparkily | 1 | 82945 | 3 | 1.503 | 55186.3 |