History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"viewed"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
228 | 2024-04-15 21:35:39 | viewed | 1 | 48755 | 2 | 1.326 | 36768.5 |
227 | 2024-04-01 18:21:09 | viewed | 1 | 48755 | 2 | 2.016 | 24184.0 |
226 | 2024-02-23 08:46:25 | viewed | 1 | 48755 | 2 | 0.860 | 56691.9 |
225 | 2024-01-12 02:10:29 | viewed | 3 | 112716 | 662 | 5.513 | 20445.5 |
224 | 2024-01-12 02:10:25 | viewed | 2 | 82551 | 42 | 2.453 | 33653.1 |
223 | 2024-01-11 04:23:33 | viewed | 2 | 82551 | 42 | 2.110 | 39123.7 |
222 | 2024-01-09 08:15:58 | viewed | 3 | 112716 | 662 | 4.753 | 23714.7 |
221 | 2024-01-04 07:42:32 | viewed | 3 | 112716 | 662 | 5.970 | 18880.4 |
220 | 2024-01-04 07:42:31 | viewed | 2 | 82551 | 42 | 3.703 | 22293.0 |
219 | 2023-12-23 20:11:41 | viewed | 3 | 112716 | 662 | 5.173 | 21789.3 |
218 | 2023-12-07 09:37:25 | viewed | 1 | 48755 | 2 | 0.733 | 66514.3 |
217 | 2023-11-20 09:25:23 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
216 | 2023-11-17 02:52:17 | viewed | 1 | 48755 | 2 | 0.703 | 69352.8 |
215 | 2023-11-14 07:37:56 | viewed | 1 | 48755 | 2 | 0.843 | 57835.1 |
214 | 2023-10-30 09:58:39 | viewed | 2 | 82551 | 42 | 2.483 | 33246.5 |
213 | 2023-10-29 11:46:36 | viewed | 3 | 112716 | 662 | 6.173 | 18259.5 |
212 | 2023-10-21 12:32:40 | viewed | 1 | 48755 | 2 | 0.783 | 62266.9 |
211 | 2023-10-21 02:35:32 | viewed | 3 | 112716 | 662 | 5.673 | 19868.9 |
210 | 2023-10-20 02:42:27 | viewed | 2 | 82551 | 42 | 2.063 | 40015.0 |
209 | 2023-10-19 02:42:03 | viewed | 1 | 48755 | 2 | 0.703 | 69352.8 |
208 | 2023-10-18 06:19:18 | viewed | 3 | 112716 | 662 | 5.076 | 22205.7 |
207 | 2023-09-23 02:47:26 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
206 | 2023-09-22 02:47:36 | viewed | 1 | 48755 | 2 | 0.750 | 65006.7 |
205 | 2023-09-13 12:24:09 | viewed | 1 | 48755 | 2 | 0.766 | 63648.8 |
204 | 2023-07-31 00:36:57 | viewed | 2 | 82551 | 42 | 2.063 | 40015.0 |
203 | 2023-07-29 04:44:19 | viewed | 3 | 112716 | 662 | 4.516 | 24959.3 |
202 | 2023-07-18 17:35:41 | viewed | 1 | 48755 | 2 | 0.830 | 58741.0 |
201 | 2023-06-18 02:57:50 | viewed | 3 | 112716 | 662 | 4.500 | 25048.0 |
200 | 2023-04-29 19:49:37 | viewed | 3 | 112716 | 662 | 4.500 | 25048.0 |
199 | 2023-04-21 09:56:16 | viewed | 1 | 48755 | 2 | 0.843 | 57835.1 |
198 | 2023-04-18 12:36:30 | viewed | 3 | 112716 | 662 | 4.500 | 25048.0 |
197 | 2023-04-07 23:47:44 | viewed | 2 | 82551 | 42 | 2.250 | 36689.3 |
196 | 2023-04-06 00:14:50 | viewed | 3 | 112716 | 662 | 4.453 | 25312.4 |
195 | 2023-03-08 11:42:36 | viewed | 3 | 112716 | 662 | 5.046 | 22337.7 |
194 | 2023-02-12 00:20:00 | viewed | 1 | 48755 | 2 | 0.800 | 60943.8 |
193 | 2023-01-15 11:11:08 | viewed | 3 | 112716 | 662 | 4.453 | 25312.4 |
192 | 2023-01-05 07:08:11 | viewed | 2 | 82551 | 42 | 2.016 | 40947.9 |
191 | 2023-01-03 23:51:54 | viewed | 3 | 112716 | 662 | 5.356 | 21044.8 |
190 | 2022-12-23 10:53:08 | viewed | 3 | 112716 | 662 | 4.516 | 24959.3 |
189 | 2022-12-09 03:28:20 | viewed | 1 | 48755 | 2 | 0.716 | 68093.6 |
188 | 2022-11-20 01:59:51 | viewed | 3 | 112716 | 662 | 4.906 | 22975.1 |
187 | 2022-09-10 17:04:11 | viewed | 3 | 112716 | 662 | 4.910 | 22956.4 |
186 | 2022-09-10 14:47:11 | viewed | 2 | 82551 | 42 | 4.143 | 19925.4 |
185 | 2022-08-11 09:56:02 | viewed | 1 | 48755 | 2 | 0.736 | 66243.2 |
184 | 2021-05-21 07:01:45 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
183 | 2021-04-21 19:16:30 | viewed | 1 | 48755 | 2 | 0.750 | 65006.7 |
182 | 2021-02-02 13:55:25 | viewed | 1 | 48755 | 2 | 0.716 | 68093.6 |
181 | 2021-01-06 20:32:41 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
180 | 2020-11-15 10:44:09 | viewed | 1 | 48755 | 2 | 0.906 | 53813.5 |
179 | 2020-11-14 03:16:55 | viewed | 1 | 48755 | 2 | 0.733 | 66514.3 |
178 | 2020-10-31 08:01:33 | viewed | 1 | 48755 | 2 | 1.563 | 31193.2 |
177 | 2020-10-30 08:46:19 | viewed | 1 | 48755 | 2 | 0.890 | 54780.9 |
176 | 2020-10-28 13:39:56 | viewed | 1 | 48755 | 2 | 0.843 | 57835.1 |
175 | 2020-10-20 16:16:16 | viewed | 1 | 48755 | 2 | 1.190 | 40970.6 |
174 | 2020-10-09 10:25:18 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
173 | 2020-09-01 21:04:13 | viewed | 1 | 48755 | 2 | 0.750 | 65006.7 |
172 | 2020-08-26 11:09:45 | viewed | 1 | 48755 | 2 | 0.796 | 61250.0 |
171 | 2020-08-19 20:28:14 | viewed | 1 | 48755 | 2 | 0.766 | 63648.8 |
170 | 2020-08-16 23:09:00 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
169 | 2020-05-22 03:16:01 | viewed | 1 | 48755 | 2 | 0.813 | 59969.2 |
168 | 2020-04-06 04:36:41 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
167 | 2020-04-03 01:45:56 | viewed | 1 | 48755 | 2 | 0.826 | 59025.4 |
166 | 2020-03-29 20:29:44 | viewed | 1 | 48755 | 2 | 0.846 | 57630.0 |
165 | 2020-03-24 22:13:20 | viewed | 1 | 48755 | 2 | 0.796 | 61250.0 |
164 | 2020-03-24 14:57:39 | viewed | 1 | 48755 | 2 | 0.873 | 55847.7 |
163 | 2020-03-20 23:16:30 | viewed | 1 | 48755 | 2 | 0.813 | 59969.2 |
162 | 2020-02-23 01:40:39 | viewed | 1 | 48755 | 2 | 2.766 | 17626.5 |
161 | 2020-02-16 19:30:45 | viewed | 1 | 48755 | 2 | 0.860 | 56691.9 |
160 | 2020-02-13 16:03:51 | viewed | 1 | 48755 | 2 | 1.563 | 31193.2 |
159 | 2020-02-11 15:31:14 | viewed | 1 | 48755 | 2 | 1.826 | 26700.4 |
158 | 2020-02-11 00:27:05 | viewed | 1 | 48755 | 2 | 0.843 | 57835.1 |
157 | 2020-02-09 21:44:18 | viewed | 1 | 48755 | 2 | 0.873 | 55847.7 |
156 | 2020-02-03 10:02:59 | viewed | 1 | 48755 | 2 | 2.720 | 17924.6 |
155 | 2020-01-25 14:44:58 | viewed | 1 | 48755 | 2 | 1.970 | 24748.7 |
154 | 2020-01-20 17:33:08 | viewed | 1 | 48755 | 2 | 0.890 | 54780.9 |
153 | 2020-01-20 16:12:09 | viewed | 1 | 48755 | 2 | 2.250 | 21668.9 |
152 | 2020-01-18 22:37:06 | viewed | 1 | 48755 | 2 | 1.923 | 25353.6 |
151 | 2020-01-14 21:12:39 | viewed | 1 | 48755 | 2 | 0.920 | 52994.6 |
150 | 2020-01-01 22:29:20 | viewed | 1 | 48755 | 2 | 0.860 | 56691.9 |
149 | 2019-12-29 02:56:20 | viewed | 1 | 48755 | 2 | 0.903 | 53992.2 |
148 | 2019-12-28 21:05:20 | viewed | 1 | 48755 | 2 | 0.860 | 56691.9 |
147 | 2019-12-28 03:23:07 | viewed | 1 | 48755 | 2 | 0.876 | 55656.4 |
146 | 2019-12-17 07:00:54 | viewed | 1 | 48755 | 2 | 0.813 | 59969.2 |
145 | 2019-11-23 10:13:59 | viewed | 1 | 48755 | 2 | 0.936 | 52088.7 |
144 | 2019-11-22 02:08:35 | viewed | 1 | 48755 | 2 | 0.826 | 59025.4 |
143 | 2019-10-12 07:22:17 | viewed | 1 | 48755 | 2 | 1.610 | 30282.6 |
142 | 2019-09-23 19:10:47 | viewed | 1 | 48755 | 2 | 0.676 | 72122.8 |
141 | 2019-09-15 21:30:28 | viewed | 1 | 48755 | 2 | 0.756 | 64490.7 |
140 | 2019-09-14 02:44:34 | viewed | 1 | 48755 | 2 | 0.736 | 66243.2 |
139 | 2019-09-06 14:43:16 | viewed | 1 | 48755 | 2 | 0.670 | 72768.7 |
138 | 2019-08-31 16:40:30 | viewed | 1 | 48755 | 2 | 0.676 | 72122.8 |
137 | 2019-06-07 13:45:27 | viewed | 1 | 48755 | 2 | 0.830 | 58741.0 |
136 | 2019-06-06 22:55:55 | viewed | 1 | 48755 | 2 | 0.736 | 66243.2 |
135 | 2019-03-18 19:22:42 | viewed | 1 | 48755 | 2 | 0.720 | 67715.3 |
134 | 2019-02-13 03:18:33 | viewed | 1 | 48755 | 2 | 0.813 | 59969.2 |
133 | 2019-01-07 20:17:56 | viewed | 1 | 48755 | 2 | 0.750 | 65006.7 |
132 | 2018-10-12 21:49:52 | viewed | 1 | 48755 | 2 | 0.770 | 63318.2 |
131 | 2018-09-16 15:54:56 | viewed | 1 | 48755 | 2 | 0.716 | 68093.6 |
130 | 2018-09-13 00:28:59 | viewed | 1 | 48755 | 2 | 0.700 | 69650.0 |
129 | 2018-09-06 08:52:36 | viewed | 1 | 48755 | 2 | 0.906 | 53813.5 |