History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparables"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
217 | 2024-04-21 08:04:06 | sparables | 3 | 148641 | 106 | 24.860 | 5979.1 |
216 | 2024-04-19 04:15:28 | sparables | 3 | 148641 | 106 | 26.283 | 5655.4 |
215 | 2024-04-19 04:15:16 | sparables | 2 | 121436 | 13 | 10.296 | 11794.5 |
214 | 2024-04-19 03:28:22 | sparables | 1 | 81242 | 3 | 1.750 | 46424.0 |
213 | 2024-04-10 08:01:22 | sparables | 1 | 81242 | 3 | 1.500 | 54161.3 |
212 | 2024-04-07 18:42:09 | sparables | 1 | 81242 | 3 | 1.546 | 52549.8 |
211 | 2024-04-05 06:16:44 | sparables | 1 | 81242 | 3 | 1.546 | 52549.8 |
210 | 2024-03-28 21:26:43 | sparables | 1 | 81242 | 3 | 2.906 | 27956.6 |
209 | 2024-03-12 21:37:03 | sparables | 3 | 148641 | 106 | 27.016 | 5502.0 |
208 | 2024-03-10 21:54:13 | sparables | 1 | 81242 | 3 | 1.610 | 50460.9 |
207 | 2024-03-10 08:33:53 | sparables | 1 | 81242 | 3 | 2.893 | 28082.3 |
206 | 2024-03-05 20:31:00 | sparables | 3 | 148641 | 106 | 21.360 | 6958.8 |
205 | 2024-03-05 20:24:00 | sparables | 2 | 121436 | 13 | 4.436 | 27375.1 |
204 | 2024-03-05 18:01:26 | sparables | 3 | 148641 | 106 | 27.956 | 5317.0 |
203 | 2024-03-05 18:01:20 | sparables | 2 | 121436 | 13 | 10.576 | 11482.2 |
202 | 2024-03-05 16:19:16 | sparables | 1 | 81242 | 3 | 1.860 | 43678.5 |
201 | 2024-02-27 09:30:16 | sparables | 1 | 81242 | 3 | 1.550 | 52414.2 |
200 | 2024-02-17 21:21:01 | sparables | 1 | 81242 | 3 | 1.563 | 51978.2 |
199 | 2024-02-01 18:40:21 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
198 | 2024-01-21 00:40:39 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
197 | 2024-01-14 09:16:44 | sparables | 3 | 148641 | 106 | 6.343 | 23433.9 |
196 | 2023-12-26 09:42:39 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
195 | 2023-12-22 02:43:57 | sparables | 1 | 81242 | 3 | 1.470 | 55266.7 |
194 | 2023-12-04 07:54:19 | sparables | 1 | 81242 | 3 | 1.423 | 57092.1 |
193 | 2023-11-16 08:39:11 | sparables | 1 | 81242 | 3 | 1.283 | 63321.9 |
192 | 2023-10-19 19:31:04 | sparables | 3 | 148641 | 106 | 6.390 | 23261.5 |
191 | 2023-10-06 04:44:56 | sparables | 1 | 81242 | 3 | 1.266 | 64172.2 |
190 | 2023-09-22 17:54:51 | sparables | 1 | 81242 | 3 | 1.283 | 63321.9 |
189 | 2023-09-02 22:38:53 | sparables | 1 | 81242 | 3 | 1.266 | 64172.2 |
188 | 2023-07-31 02:26:27 | sparables | 3 | 148641 | 106 | 6.313 | 23545.2 |
187 | 2023-07-13 01:24:51 | sparables | 1 | 81242 | 3 | 1.313 | 61875.1 |
186 | 2023-06-09 02:39:20 | sparables | 1 | 81242 | 3 | 1.390 | 58447.5 |
185 | 2023-05-09 14:05:36 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
184 | 2023-04-08 08:29:39 | sparables | 3 | 148641 | 106 | 6.233 | 23847.4 |
183 | 2023-03-28 15:10:16 | sparables | 1 | 81242 | 3 | 1.373 | 59171.2 |
182 | 2023-01-17 12:44:02 | sparables | 3 | 148641 | 106 | 6.610 | 22487.3 |
181 | 2023-01-13 14:11:41 | sparables | 1 | 81242 | 3 | 1.453 | 55913.3 |
180 | 2023-01-05 20:21:05 | sparables | 3 | 148641 | 106 | 7.936 | 18730.0 |
179 | 2023-01-05 01:19:14 | sparables | 1 | 81242 | 3 | 1.360 | 59736.8 |
178 | 2022-12-03 15:41:48 | sparables | 3 | 148641 | 106 | 6.373 | 23323.6 |
177 | 2022-10-31 04:57:48 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
176 | 2022-10-29 19:30:22 | sparables | 3 | 148641 | 106 | 7.093 | 20956.0 |
175 | 2022-09-10 10:47:25 | sparables | 3 | 148641 | 106 | 6.343 | 23433.9 |
174 | 2022-08-24 17:12:20 | sparables | 1 | 81242 | 3 | 1.266 | 64172.2 |
173 | 2022-06-19 09:46:03 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
172 | 2022-06-17 05:30:18 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
171 | 2022-06-14 11:19:14 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
170 | 2022-04-06 16:09:30 | sparables | 1 | 81242 | 3 | 1.763 | 46081.7 |
169 | 2022-02-20 09:23:32 | sparables | 1 | 81242 | 3 | 1.393 | 58321.6 |
168 | 2022-02-18 04:55:04 | sparables | 1 | 81242 | 3 | 1.500 | 54161.3 |
167 | 2021-12-20 00:58:25 | sparables | 1 | 81242 | 3 | 1.296 | 62686.7 |
166 | 2021-12-03 08:09:40 | sparables | 1 | 81242 | 3 | 1.406 | 57782.4 |
165 | 2021-10-05 02:01:21 | sparables | 2 | 121436 | 13 | 3.406 | 35653.6 |
164 | 2021-10-02 06:01:46 | sparables | 3 | 148641 | 106 | 13.423 | 11073.6 |
163 | 2021-09-22 16:13:12 | sparables | 1 | 81242 | 3 | 1.466 | 55417.5 |
162 | 2021-09-21 23:56:50 | sparables | 1 | 81242 | 3 | 1.486 | 54671.6 |
161 | 2021-09-21 13:54:55 | sparables | 2 | 121436 | 13 | 3.563 | 34082.5 |
160 | 2021-09-21 13:54:51 | sparables | 3 | 148641 | 106 | 6.406 | 23203.4 |
159 | 2021-09-21 13:52:50 | sparables | 1 | 81242 | 3 | 1.393 | 58321.6 |
158 | 2021-09-15 04:56:13 | sparables | 1 | 81242 | 3 | 1.313 | 61875.1 |
157 | 2021-08-13 13:54:40 | sparables | 1 | 81242 | 3 | 1.263 | 64324.6 |
156 | 2021-05-13 22:40:15 | sparables | 1 | 81242 | 3 | 1.450 | 56029.0 |
155 | 2021-05-02 16:44:07 | sparables | 1 | 81242 | 3 | 1.343 | 60492.9 |
154 | 2021-04-12 21:34:27 | sparables | 1 | 81242 | 3 | 1.296 | 62686.7 |
153 | 2021-02-19 16:08:05 | sparables | 1 | 81242 | 3 | 1.420 | 57212.7 |
152 | 2021-01-08 06:51:27 | sparables | 1 | 81242 | 3 | 1.326 | 61268.5 |
151 | 2020-12-01 09:00:28 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |
150 | 2020-11-30 19:15:25 | sparables | 1 | 81242 | 3 | 1.373 | 59171.2 |
149 | 2020-11-04 10:33:28 | sparables | 1 | 81242 | 3 | 1.313 | 61875.1 |
148 | 2020-10-16 00:48:45 | sparables | 1 | 81242 | 3 | 1.263 | 64324.6 |
147 | 2020-10-14 22:08:25 | sparables | 1 | 81242 | 3 | 1.453 | 55913.3 |
146 | 2020-10-03 07:05:14 | sparables | 1 | 81242 | 3 | 1.266 | 64172.2 |
145 | 2020-09-24 07:24:04 | sparables | 1 | 81242 | 3 | 1.263 | 64324.6 |
144 | 2020-09-21 07:02:30 | sparables | 1 | 81242 | 3 | 2.533 | 32073.4 |
143 | 2020-07-18 19:33:21 | sparables | 1 | 81242 | 3 | 1.343 | 60492.9 |
142 | 2020-06-04 03:28:45 | sparables | 1 | 81242 | 3 | 1.280 | 63470.3 |
141 | 2020-03-22 06:15:40 | sparables | 3 | 148641 | 106 | 7.923 | 18760.7 |
140 | 2020-03-21 15:49:07 | sparables | 1 | 81242 | 3 | 1.376 | 59042.2 |
139 | 2020-03-04 20:46:05 | sparables | 3 | 148641 | 106 | 7.156 | 20771.5 |
138 | 2020-03-04 12:09:07 | sparables | 3 | 148641 | 106 | 7.403 | 20078.5 |
137 | 2020-03-04 10:43:50 | sparables | 3 | 148641 | 106 | 11.203 | 13268.0 |
136 | 2020-02-29 17:06:57 | sparables | 1 | 81242 | 3 | 1.563 | 51978.2 |
135 | 2020-02-23 09:17:49 | sparables | 1 | 81242 | 3 | 1.733 | 46879.4 |
134 | 2020-02-22 15:47:49 | sparables | 1 | 81242 | 3 | 3.250 | 24997.5 |
133 | 2020-02-14 09:06:05 | sparables | 1 | 81242 | 3 | 3.266 | 24875.1 |
132 | 2020-02-12 19:42:37 | sparables | 1 | 81242 | 3 | 4.313 | 18836.5 |
131 | 2020-02-06 02:43:37 | sparables | 1 | 81242 | 3 | 1.516 | 53589.7 |
130 | 2020-02-02 23:19:31 | sparables | 1 | 81242 | 3 | 1.593 | 50999.4 |
129 | 2020-02-02 11:32:34 | sparables | 1 | 81242 | 3 | 1.576 | 51549.5 |
128 | 2020-01-29 01:40:09 | sparables | 1 | 81242 | 3 | 1.653 | 49148.2 |
127 | 2020-01-22 22:27:53 | sparables | 1 | 81242 | 3 | 1.686 | 48186.2 |
126 | 2020-01-22 16:36:52 | sparables | 1 | 81242 | 3 | 1.596 | 50903.5 |
125 | 2020-01-16 11:16:33 | sparables | 3 | 148641 | 106 | 20.826 | 7137.3 |
124 | 2020-01-16 11:15:46 | sparables | 2 | 121436 | 13 | 4.033 | 30110.6 |
123 | 2020-01-16 04:58:25 | sparables | 1 | 81242 | 3 | 3.153 | 25766.6 |
122 | 2020-01-10 18:08:46 | sparables | 1 | 81242 | 3 | 1.626 | 49964.3 |
121 | 2020-01-06 18:15:04 | sparables | 1 | 81242 | 3 | 2.436 | 33350.6 |
120 | 2019-12-31 22:11:43 | sparables | 1 | 81242 | 3 | 2.890 | 28111.4 |
119 | 2019-12-30 11:36:48 | sparables | 1 | 81242 | 3 | 1.470 | 55266.7 |
118 | 2019-11-23 19:43:12 | sparables | 1 | 81242 | 3 | 1.250 | 64993.6 |