History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"serranid"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
214 | 2024-04-22 05:53:19 | serranid | 4 | 161609 | 639 | 30.456 | 5306.3 |
213 | 2024-04-20 21:59:55 | serranid | 4 | 161609 | 639 | 43.766 | 3692.6 |
212 | 2024-04-20 15:02:53 | serranid | 4 | 161609 | 639 | 20.063 | 8055.1 |
211 | 2024-04-20 07:46:55 | serranid | 4 | 161609 | 639 | 25.016 | 6460.2 |
210 | 2024-04-20 05:36:13 | serranid | 4 | 161609 | 639 | 18.643 | 8668.6 |
209 | 2024-04-19 03:57:23 | serranid | 4 | 161609 | 639 | 40.016 | 4038.6 |
208 | 2024-04-19 03:57:24 | serranid | 3 | 146162 | 46 | 27.126 | 5388.3 |
207 | 2024-04-19 03:57:28 | serranid | 2 | 121059 | 7 | 9.860 | 12277.8 |
206 | 2024-04-19 03:32:46 | serranid | 1 | 82945 | 3 | 1.453 | 57085.3 |
205 | 2024-04-05 09:01:32 | serranid | 1 | 82945 | 3 | 2.596 | 31951.1 |
204 | 2024-03-13 16:02:01 | serranid | 2 | 121059 | 7 | 10.783 | 11226.8 |
203 | 2024-03-13 16:01:42 | serranid | 3 | 146162 | 46 | 8.733 | 16736.7 |
202 | 2024-03-12 21:36:51 | serranid | 4 | 161609 | 639 | 32.173 | 5023.1 |
201 | 2024-03-12 06:07:52 | serranid | 2 | 121059 | 7 | 3.873 | 31257.2 |
200 | 2024-03-11 07:15:04 | serranid | 3 | 146162 | 46 | 17.876 | 8176.4 |
199 | 2024-03-10 23:31:47 | serranid | 2 | 121059 | 7 | 4.063 | 29795.5 |
198 | 2024-03-10 23:31:19 | serranid | 3 | 146162 | 46 | 8.546 | 17103.0 |
197 | 2024-03-10 14:56:23 | serranid | 4 | 161609 | 639 | 40.363 | 4003.9 |
196 | 2024-03-09 23:27:25 | serranid | 4 | 161609 | 639 | 46.503 | 3475.2 |
195 | 2024-03-08 22:16:56 | serranid | 4 | 161609 | 639 | 29.580 | 5463.5 |
194 | 2024-03-08 18:32:00 | serranid | 3 | 146162 | 46 | 24.330 | 6007.5 |
193 | 2024-03-08 18:31:43 | serranid | 4 | 161609 | 639 | 27.423 | 5893.2 |
192 | 2024-03-08 18:31:54 | serranid | 2 | 121059 | 7 | 8.656 | 13985.6 |
191 | 2024-03-08 18:31:32 | serranid | 1 | 82945 | 3 | 5.143 | 16127.7 |
190 | 2024-02-24 21:08:26 | serranid | 1 | 82945 | 3 | 1.580 | 52496.8 |
189 | 2024-02-05 01:30:50 | serranid | 3 | 146162 | 46 | 8.513 | 17169.3 |
188 | 2024-02-04 16:16:59 | serranid | 2 | 121059 | 7 | 4.406 | 27475.9 |
187 | 2024-02-04 16:16:47 | serranid | 3 | 146162 | 46 | 8.766 | 16673.7 |
186 | 2024-02-04 11:23:50 | serranid | 4 | 161609 | 639 | 36.143 | 4471.4 |
185 | 2024-02-03 21:40:03 | serranid | 4 | 161609 | 639 | 12.876 | 12551.2 |
184 | 2024-02-01 12:17:20 | serranid | 1 | 82945 | 3 | 1.313 | 63172.1 |
183 | 2024-02-01 03:25:40 | serranid | 2 | 121059 | 7 | 4.373 | 27683.3 |
182 | 2024-02-01 03:25:36 | serranid | 3 | 146162 | 46 | 8.250 | 17716.6 |
181 | 2024-01-31 18:49:20 | serranid | 4 | 161609 | 639 | 20.423 | 7913.1 |
180 | 2024-01-31 17:44:44 | serranid | 4 | 161609 | 639 | 12.736 | 12689.1 |
179 | 2024-01-31 17:32:44 | serranid | 4 | 161609 | 639 | 14.830 | 10897.4 |
178 | 2024-01-31 17:32:48 | serranid | 3 | 146162 | 46 | 8.343 | 17519.1 |
177 | 2024-01-31 17:32:52 | serranid | 2 | 121059 | 7 | 4.263 | 28397.6 |
176 | 2024-01-31 17:32:40 | serranid | 1 | 82945 | 3 | 1.563 | 53067.8 |
175 | 2024-01-14 14:00:30 | serranid | 1 | 82945 | 3 | 1.313 | 63172.1 |
174 | 2023-12-11 00:02:35 | serranid | 1 | 82945 | 3 | 1.486 | 55817.6 |
173 | 2023-11-11 10:55:47 | serranid | 1 | 82945 | 3 | 1.453 | 57085.3 |
172 | 2023-10-10 08:12:36 | serranid | 1 | 82945 | 3 | 1.330 | 62364.7 |
171 | 2023-10-04 01:48:06 | serranid | 1 | 82945 | 3 | 1.296 | 64000.8 |
170 | 2023-09-14 09:12:12 | serranid | 1 | 82945 | 3 | 1.423 | 58288.8 |
169 | 2023-08-30 23:08:08 | serranid | 1 | 82945 | 3 | 1.330 | 62364.7 |
168 | 2023-06-05 06:04:44 | serranid | 1 | 82945 | 3 | 1.296 | 64000.8 |
167 | 2023-06-03 17:22:58 | serranid | 1 | 82945 | 3 | 1.300 | 63803.8 |
166 | 2023-03-29 16:29:14 | serranid | 1 | 82945 | 3 | 1.486 | 55817.6 |
165 | 2023-01-21 13:57:10 | serranid | 1 | 82945 | 3 | 1.296 | 64000.8 |
164 | 2023-01-12 08:24:56 | serranid | 1 | 82945 | 3 | 1.296 | 64000.8 |
163 | 2022-10-26 14:25:38 | serranid | 1 | 82945 | 3 | 1.470 | 56425.2 |
162 | 2022-09-15 17:08:42 | serranid | 1 | 82945 | 3 | 1.546 | 53651.4 |
161 | 2022-09-12 02:27:54 | serranid | 1 | 82945 | 3 | 1.626 | 51011.7 |
160 | 2022-09-02 01:01:29 | serranid | 1 | 82945 | 3 | 1.360 | 60989.0 |
159 | 2022-06-13 16:54:09 | serranid | 1 | 82945 | 3 | 1.326 | 62552.8 |
158 | 2022-06-11 12:40:40 | serranid | 1 | 82945 | 3 | 1.313 | 63172.1 |
157 | 2022-04-25 11:00:33 | serranid | 1 | 82945 | 3 | 1.780 | 46598.3 |
156 | 2021-12-17 14:51:02 | serranid | 1 | 82945 | 3 | 1.546 | 53651.4 |
155 | 2021-11-27 01:20:16 | serranid | 1 | 82945 | 3 | 1.376 | 60279.8 |
154 | 2021-11-26 15:08:37 | serranid | 1 | 82945 | 3 | 1.343 | 61761.0 |
153 | 2021-11-25 08:57:32 | serranid | 1 | 82945 | 3 | 1.453 | 57085.3 |
152 | 2021-10-14 23:55:02 | serranid | 1 | 82945 | 3 | 1.516 | 54713.1 |
151 | 2021-10-12 19:40:55 | serranid | 1 | 82945 | 3 | 1.516 | 54713.1 |
150 | 2021-10-11 22:47:05 | serranid | 1 | 82945 | 3 | 1.483 | 55930.5 |
149 | 2021-10-10 19:33:13 | serranid | 1 | 82945 | 3 | 1.470 | 56425.2 |
148 | 2021-09-19 21:10:33 | serranid | 1 | 82945 | 3 | 1.343 | 61761.0 |
147 | 2021-09-18 16:55:06 | serranid | 1 | 82945 | 3 | 1.470 | 56425.2 |
146 | 2021-09-11 19:58:57 | serranid | 1 | 82945 | 3 | 1.466 | 56579.1 |
145 | 2021-08-21 13:35:38 | serranid | 1 | 82945 | 3 | 1.296 | 64000.8 |
144 | 2021-05-07 09:30:45 | serranid | 1 | 82945 | 3 | 1.596 | 51970.6 |
143 | 2021-04-27 03:19:36 | serranid | 1 | 82945 | 3 | 1.530 | 54212.4 |
142 | 2021-03-27 07:08:23 | serranid | 1 | 82945 | 3 | 1.546 | 53651.4 |
141 | 2021-03-01 10:12:09 | serranid | 4 | 161609 | 639 | 12.033 | 13430.5 |
140 | 2021-01-14 14:05:07 | serranid | 1 | 82945 | 3 | 2.936 | 28251.0 |
139 | 2021-01-10 15:45:43 | serranid | 1 | 82945 | 3 | 1.470 | 56425.2 |
138 | 2020-10-31 22:22:58 | serranid | 4 | 161609 | 639 | 14.236 | 11352.1 |
137 | 2020-10-22 13:59:28 | serranid | 1 | 82945 | 3 | 1.330 | 62364.7 |
136 | 2020-10-09 11:12:45 | serranid | 1 | 82945 | 3 | 1.376 | 60279.8 |
135 | 2020-10-05 15:01:50 | serranid | 1 | 82945 | 3 | 1.390 | 59672.7 |
134 | 2020-09-07 15:29:17 | serranid | 1 | 82945 | 3 | 1.313 | 63172.1 |
133 | 2020-07-22 16:36:00 | serranid | 1 | 82945 | 3 | 1.436 | 57761.1 |
132 | 2020-06-20 08:14:51 | serranid | 1 | 82945 | 3 | 1.486 | 55817.6 |
131 | 2020-03-29 11:52:26 | serranid | 1 | 82945 | 3 | 1.546 | 53651.4 |
130 | 2020-03-26 13:41:16 | serranid | 1 | 82945 | 3 | 3.266 | 25396.5 |
129 | 2020-03-22 04:20:30 | serranid | 1 | 82945 | 3 | 1.530 | 54212.4 |
128 | 2020-03-12 10:40:35 | serranid | 1 | 82945 | 3 | 1.406 | 58993.6 |
127 | 2020-03-04 21:54:13 | serranid | 1 | 82945 | 3 | 1.453 | 57085.3 |
126 | 2020-02-25 03:33:37 | serranid | 1 | 82945 | 3 | 4.393 | 18881.2 |
125 | 2020-02-23 01:37:28 | serranid | 1 | 82945 | 3 | 3.156 | 26281.7 |
124 | 2020-02-20 13:09:50 | serranid | 1 | 82945 | 3 | 1.563 | 53067.8 |
123 | 2020-02-14 10:51:24 | serranid | 1 | 82945 | 3 | 1.610 | 51518.6 |
122 | 2020-02-01 13:08:47 | serranid | 1 | 82945 | 3 | 1.703 | 48705.2 |
121 | 2020-01-26 19:36:09 | serranid | 1 | 82945 | 3 | 1.936 | 42843.5 |
120 | 2020-01-23 17:58:54 | serranid | 1 | 82945 | 3 | 3.403 | 24374.1 |
119 | 2020-01-23 08:24:56 | serranid | 1 | 82945 | 3 | 5.000 | 16589.0 |
118 | 2020-01-22 01:49:29 | serranid | 1 | 82945 | 3 | 2.220 | 37362.6 |
117 | 2020-01-17 09:39:00 | serranid | 1 | 82945 | 3 | 3.546 | 23391.1 |
116 | 2020-01-12 18:40:27 | serranid | 1 | 82945 | 3 | 1.563 | 53067.8 |
115 | 2020-01-01 10:31:57 | serranid | 1 | 82945 | 3 | 3.000 | 27648.3 |