History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparrows"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
226 | 2024-05-12 15:36:26 | sparrows | 1 | 82945 | 2 | 5.610 | 14785.2 |
225 | 2024-05-12 08:09:49 | sparrows | 3 | 146162 | 98 | 22.423 | 6518.4 |
224 | 2024-05-11 20:54:51 | sparrows | 2 | 121059 | 11 | 5.530 | 21891.3 |
223 | 2024-05-11 20:54:48 | sparrows | 1 | 82945 | 2 | 1.750 | 47397.1 |
222 | 2024-05-11 15:49:17 | sparrows | 3 | 146162 | 98 | 25.970 | 5628.1 |
221 | 2024-05-10 01:22:12 | sparrows | 2 | 121059 | 11 | 8.936 | 13547.3 |
220 | 2024-05-09 21:31:32 | sparrows | 3 | 146162 | 98 | 8.126 | 17987.0 |
219 | 2024-05-09 15:48:39 | sparrows | 3 | 146162 | 98 | 27.533 | 5308.6 |
218 | 2024-05-09 04:44:43 | sparrows | 3 | 146162 | 98 | 8.406 | 17387.8 |
217 | 2024-05-08 06:09:00 | sparrows | 2 | 121059 | 11 | 7.140 | 16955.0 |
216 | 2024-05-08 06:08:56 | sparrows | 1 | 82945 | 2 | 1.610 | 51518.6 |
215 | 2024-05-08 06:08:49 | sparrows | 3 | 146162 | 98 | 8.716 | 16769.4 |
214 | 2024-05-08 06:08:48 | sparrows | 2 | 121059 | 11 | 4.233 | 28598.9 |
213 | 2024-05-08 06:08:48 | sparrows | 1 | 82945 | 2 | 1.640 | 50576.2 |
212 | 2024-05-07 11:47:51 | sparrows | 1 | 82945 | 2 | 1.610 | 51518.6 |
211 | 2024-05-07 03:19:36 | sparrows | 4 | 161609 | 903 | 23.890 | 6764.7 |
210 | 2024-05-06 09:08:39 | sparrows | 1 | 82945 | 2 | 1.640 | 50576.2 |
209 | 2024-05-06 08:17:56 | sparrows | 4 | 161609 | 903 | 16.733 | 9658.1 |
208 | 2024-05-06 07:44:27 | sparrows | 4 | 161609 | 903 | 13.576 | 11904.0 |
207 | 2024-05-06 07:09:44 | sparrows | 4 | 161609 | 903 | 22.250 | 7263.3 |
206 | 2024-04-21 06:43:32 | sparrows | 1 | 82945 | 2 | 1.596 | 51970.6 |
205 | 2024-04-21 06:34:58 | sparrows | 1 | 82945 | 2 | 1.576 | 52630.1 |
204 | 2024-04-10 22:46:19 | sparrows | 3 | 146162 | 98 | 8.673 | 16852.5 |
203 | 2024-04-10 22:46:16 | sparrows | 2 | 121059 | 11 | 4.356 | 27791.3 |
202 | 2024-04-10 22:46:14 | sparrows | 1 | 82945 | 2 | 3.206 | 25871.8 |
201 | 2024-04-10 09:07:29 | sparrows | 4 | 161609 | 903 | 20.736 | 7793.6 |
200 | 2024-04-10 04:52:09 | sparrows | 3 | 146162 | 98 | 8.406 | 17387.8 |
199 | 2024-04-08 23:29:37 | sparrows | 3 | 146162 | 98 | 9.300 | 15716.3 |
198 | 2024-04-08 06:37:51 | sparrows | 3 | 146162 | 98 | 9.780 | 14945.0 |
197 | 2024-04-08 06:06:17 | sparrows | 1 | 82945 | 2 | 1.606 | 51646.9 |
196 | 2024-04-07 18:16:10 | sparrows | 3 | 146162 | 98 | 15.063 | 9703.4 |
195 | 2024-04-07 18:16:11 | sparrows | 2 | 121059 | 11 | 4.393 | 27557.3 |
194 | 2024-04-07 18:16:09 | sparrows | 1 | 82945 | 2 | 1.640 | 50576.2 |
193 | 2024-04-03 19:34:18 | sparrows | 4 | 161609 | 903 | 27.143 | 5954.0 |
192 | 2024-04-01 20:22:12 | sparrows | 4 | 161609 | 903 | 30.300 | 5333.6 |
191 | 2024-03-31 12:22:39 | sparrows | 2 | 121059 | 11 | 4.220 | 28687.0 |
190 | 2024-03-28 21:00:27 | sparrows | 4 | 161609 | 903 | 38.753 | 4170.2 |
189 | 2024-03-28 20:55:21 | sparrows | 4 | 161609 | 903 | 28.656 | 5639.6 |
188 | 2024-03-28 20:55:21 | sparrows | 2 | 121059 | 11 | 4.483 | 27004.0 |
187 | 2024-03-28 20:55:14 | sparrows | 1 | 82945 | 2 | 3.343 | 24811.5 |
186 | 2024-03-07 04:11:36 | sparrows | 3 | 146162 | 98 | 19.346 | 7555.2 |
185 | 2024-03-06 13:11:13 | sparrows | 3 | 146162 | 98 | 22.550 | 6481.7 |
184 | 2024-03-05 11:06:56 | sparrows | 3 | 146162 | 98 | 8.360 | 17483.5 |
183 | 2024-03-05 11:06:57 | sparrows | 2 | 121059 | 11 | 7.623 | 15880.8 |
182 | 2024-03-05 11:06:55 | sparrows | 1 | 82945 | 2 | 1.606 | 51646.9 |
181 | 2024-03-04 23:28:01 | sparrows | 1 | 82945 | 2 | 3.156 | 26281.7 |
180 | 2024-02-16 10:37:51 | sparrows | 4 | 161609 | 903 | 44.613 | 3622.5 |
179 | 2024-02-08 08:34:28 | sparrows | 4 | 161609 | 903 | 16.140 | 10012.9 |
178 | 2024-02-06 04:37:49 | sparrows | 4 | 161609 | 903 | 22.016 | 7340.5 |
177 | 2024-02-06 00:09:02 | sparrows | 4 | 161609 | 903 | 13.970 | 11568.3 |
176 | 2024-02-05 23:36:18 | sparrows | 4 | 161609 | 903 | 12.983 | 12447.7 |
175 | 2024-01-30 13:47:28 | sparrows | 1 | 82945 | 2 | 3.110 | 26670.4 |
174 | 2024-01-03 08:46:49 | sparrows | 1 | 82945 | 2 | 1.483 | 55930.5 |
173 | 2023-12-26 18:50:18 | sparrows | 1 | 82945 | 2 | 1.920 | 43200.5 |
172 | 2023-12-11 22:47:11 | sparrows | 4 | 161609 | 903 | 11.033 | 14647.8 |
171 | 2023-12-04 05:02:16 | sparrows | 2 | 121059 | 11 | 3.580 | 33815.4 |
170 | 2023-11-26 10:48:42 | sparrows | 1 | 82945 | 2 | 1.403 | 59119.7 |
169 | 2023-11-15 07:19:19 | sparrows | 1 | 82945 | 2 | 1.360 | 60989.0 |
168 | 2023-10-31 21:51:58 | sparrows | 1 | 82945 | 2 | 1.546 | 53651.4 |
167 | 2023-10-24 18:38:17 | sparrows | 1 | 82945 | 2 | 1.516 | 54713.1 |
166 | 2023-10-16 13:23:57 | sparrows | 1 | 82945 | 2 | 1.486 | 55817.6 |
165 | 2023-09-14 13:01:33 | sparrows | 1 | 82945 | 2 | 1.466 | 56579.1 |
164 | 2023-09-12 20:36:04 | sparrows | 4 | 161609 | 903 | 11.530 | 14016.4 |
163 | 2023-09-01 15:25:24 | sparrows | 2 | 121059 | 11 | 3.203 | 37795.5 |
162 | 2023-08-20 18:51:54 | sparrows | 1 | 82945 | 2 | 2.860 | 29001.7 |
161 | 2023-08-12 16:15:45 | sparrows | 4 | 161609 | 903 | 10.673 | 15141.9 |
160 | 2023-06-12 06:05:24 | sparrows | 4 | 161609 | 903 | 10.673 | 15141.9 |
159 | 2023-05-22 06:07:25 | sparrows | 1 | 82945 | 2 | 1.266 | 65517.4 |
158 | 2023-05-19 02:58:22 | sparrows | 2 | 121059 | 11 | 3.656 | 33112.4 |
157 | 2023-05-17 19:11:13 | sparrows | 4 | 161609 | 903 | 11.436 | 14131.6 |
156 | 2023-04-22 22:38:22 | sparrows | 4 | 161609 | 903 | 11.343 | 14247.5 |
155 | 2023-04-20 08:47:48 | sparrows | 4 | 161609 | 903 | 12.296 | 13143.2 |
154 | 2023-04-06 09:39:15 | sparrows | 4 | 161609 | 903 | 11.500 | 14053.0 |
153 | 2023-03-19 16:02:29 | sparrows | 1 | 82945 | 2 | 2.533 | 32745.8 |
152 | 2023-03-13 02:27:19 | sparrows | 4 | 161609 | 903 | 10.530 | 15347.5 |
151 | 2023-02-28 18:46:00 | sparrows | 4 | 161609 | 903 | 10.610 | 15231.8 |
150 | 2023-02-24 08:03:56 | sparrows | 2 | 121059 | 11 | 3.143 | 38517.0 |
149 | 2023-01-16 09:35:46 | sparrows | 4 | 161609 | 903 | 10.423 | 15505.0 |
148 | 2023-01-06 20:14:04 | sparrows | 1 | 82945 | 2 | 1.283 | 64649.3 |
147 | 2023-01-05 16:18:31 | sparrows | 4 | 161609 | 903 | 13.030 | 12402.8 |
146 | 2022-12-16 03:30:19 | sparrows | 4 | 161609 | 903 | 11.313 | 14285.2 |
145 | 2022-12-04 04:00:39 | sparrows | 2 | 121059 | 11 | 3.580 | 33815.4 |
144 | 2022-10-04 21:43:17 | sparrows | 1 | 82945 | 2 | 1.373 | 60411.5 |
143 | 2022-09-17 20:09:26 | sparrows | 4 | 161609 | 903 | 12.033 | 13430.5 |
142 | 2022-08-07 20:16:37 | sparrows | 4 | 161609 | 903 | 10.796 | 14969.3 |
141 | 2022-07-11 09:16:59 | sparrows | 2 | 121059 | 11 | 4.080 | 29671.3 |
140 | 2022-05-21 22:18:45 | sparrows | 1 | 82945 | 2 | 1.280 | 64800.8 |
139 | 2021-08-05 06:43:53 | sparrows | 4 | 161609 | 903 | 10.766 | 15011.1 |
138 | 2020-03-29 20:37:47 | sparrows | 1 | 82945 | 2 | 1.390 | 59672.7 |
137 | 2020-03-29 02:11:57 | sparrows | 4 | 161609 | 903 | 14.733 | 10969.2 |
136 | 2020-03-28 19:06:27 | sparrows | 4 | 161609 | 903 | 18.423 | 8772.1 |
135 | 2020-03-28 17:54:36 | sparrows | 4 | 161609 | 903 | 23.613 | 6844.1 |
134 | 2020-03-28 03:12:38 | sparrows | 4 | 161609 | 903 | 15.640 | 10333.1 |
133 | 2020-03-22 09:26:55 | sparrows | 1 | 82945 | 2 | 1.500 | 55296.7 |
132 | 2020-03-17 23:56:53 | sparrows | 1 | 82945 | 2 | 1.343 | 61761.0 |
131 | 2020-02-29 12:27:27 | sparrows | 4 | 161609 | 903 | 21.673 | 7456.7 |
130 | 2020-02-29 11:01:27 | sparrows | 4 | 161609 | 903 | 19.983 | 8087.3 |
129 | 2020-02-28 18:10:47 | sparrows | 1 | 82945 | 2 | 1.826 | 45424.4 |
128 | 2020-02-25 11:21:05 | sparrows | 1 | 82945 | 2 | 1.936 | 42843.5 |
127 | 2020-02-21 04:51:52 | sparrows | 1 | 82945 | 2 | 1.783 | 46519.9 |