History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"favorites"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
207 | 2024-04-18 03:35:57 | favorites | 1 | 81242 | 2 | 3.076 | 26411.6 |
206 | 2024-04-12 17:48:04 | favorites | 1 | 81242 | 2 | 1.546 | 52549.8 |
205 | 2024-04-05 22:24:45 | favorites | 1 | 81242 | 2 | 1.500 | 54161.3 |
204 | 2024-04-03 05:14:09 | favorites | 4 | 165329 | 685 | 29.720 | 5562.9 |
203 | 2024-03-31 11:46:50 | favorites | 4 | 165329 | 685 | 41.893 | 3946.5 |
202 | 2024-03-31 11:46:48 | favorites | 3 | 148641 | 72 | 20.720 | 7173.8 |
201 | 2024-03-31 11:46:41 | favorites | 2 | 121436 | 7 | 12.546 | 9679.3 |
200 | 2024-03-31 11:24:58 | favorites | 1 | 81242 | 2 | 1.576 | 51549.5 |
199 | 2024-03-19 21:40:30 | favorites | 1 | 81242 | 2 | 1.423 | 57092.1 |
198 | 2024-03-18 05:51:09 | favorites | 1 | 81242 | 2 | 4.046 | 20079.6 |
197 | 2024-03-07 23:35:55 | favorites | 1 | 81242 | 2 | 1.420 | 57212.7 |
196 | 2024-03-06 13:39:50 | favorites | 1 | 81242 | 2 | 1.516 | 53589.7 |
195 | 2024-02-28 10:38:26 | favorites | 1 | 81242 | 2 | 3.063 | 26523.7 |
194 | 2024-02-16 02:42:48 | favorites | 1 | 81242 | 2 | 4.670 | 17396.6 |
193 | 2024-02-13 14:19:23 | favorites | 1 | 81242 | 2 | 1.470 | 55266.7 |
192 | 2024-02-11 04:27:23 | favorites | 4 | 165329 | 685 | 21.800 | 7583.9 |
191 | 2024-02-10 10:48:29 | favorites | 3 | 148641 | 72 | 24.003 | 6192.6 |
190 | 2024-02-06 16:55:31 | favorites | 4 | 165329 | 685 | 32.143 | 5143.5 |
189 | 2024-02-06 16:54:28 | favorites | 3 | 148641 | 72 | 24.423 | 6086.1 |
188 | 2024-02-06 13:48:23 | favorites | 3 | 148641 | 72 | 7.050 | 21083.8 |
187 | 2024-02-06 13:48:15 | favorites | 4 | 165329 | 685 | 13.220 | 12506.0 |
186 | 2024-02-06 13:48:19 | favorites | 2 | 121436 | 7 | 3.843 | 31599.3 |
185 | 2024-02-06 13:21:35 | favorites | 1 | 81242 | 2 | 1.200 | 67701.7 |
184 | 2024-01-28 23:06:51 | favorites | 1 | 81242 | 2 | 1.360 | 59736.8 |
183 | 2024-01-14 21:05:35 | favorites | 1 | 81242 | 2 | 1.216 | 66810.9 |
182 | 2024-01-07 07:39:28 | favorites | 1 | 81242 | 2 | 1.406 | 57782.4 |
181 | 2023-12-27 22:03:57 | favorites | 1 | 81242 | 2 | 1.343 | 60492.9 |
180 | 2023-12-01 03:03:47 | favorites | 1 | 81242 | 2 | 1.530 | 53099.3 |
179 | 2023-11-14 03:59:50 | favorites | 1 | 81242 | 2 | 1.220 | 66591.8 |
178 | 2023-10-13 13:47:08 | favorites | 1 | 81242 | 2 | 1.360 | 59736.8 |
177 | 2023-09-27 06:50:08 | favorites | 1 | 81242 | 2 | 1.936 | 41963.8 |
176 | 2023-09-15 10:12:54 | favorites | 1 | 81242 | 2 | 1.360 | 59736.8 |
175 | 2023-07-27 14:40:13 | favorites | 1 | 81242 | 2 | 1.280 | 63470.3 |
174 | 2023-07-23 19:18:40 | favorites | 1 | 81242 | 2 | 1.233 | 65889.7 |
173 | 2023-07-05 12:11:03 | favorites | 1 | 81242 | 2 | 1.296 | 62686.7 |
172 | 2023-04-12 07:16:49 | favorites | 1 | 81242 | 2 | 1.203 | 67532.8 |
171 | 2023-04-08 10:31:04 | favorites | 1 | 81242 | 2 | 1.203 | 67532.8 |
170 | 2023-02-05 05:17:50 | favorites | 1 | 81242 | 2 | 1.330 | 61084.2 |
169 | 2022-12-23 01:25:59 | favorites | 1 | 81242 | 2 | 1.220 | 66591.8 |
168 | 2022-12-04 05:57:00 | favorites | 1 | 81242 | 2 | 1.190 | 68270.6 |
167 | 2022-08-26 13:03:54 | favorites | 1 | 81242 | 2 | 1.343 | 60492.9 |
166 | 2022-07-30 02:50:13 | favorites | 1 | 81242 | 2 | 1.250 | 64993.6 |
165 | 2022-05-20 22:42:24 | favorites | 1 | 81242 | 2 | 1.343 | 60492.9 |
164 | 2022-04-29 12:25:12 | favorites | 1 | 81242 | 2 | 1.390 | 58447.5 |
163 | 2022-04-14 10:48:40 | favorites | 1 | 81242 | 2 | 1.313 | 61875.1 |
162 | 2022-02-15 22:25:39 | favorites | 1 | 81242 | 2 | 1.250 | 64993.6 |
161 | 2022-02-04 18:38:53 | favorites | 1 | 81242 | 2 | 1.250 | 64993.6 |
160 | 2022-01-12 13:41:56 | favorites | 1 | 81242 | 2 | 1.406 | 57782.4 |
159 | 2021-10-06 07:26:40 | favorites | 1 | 81242 | 2 | 1.643 | 49447.4 |
158 | 2021-09-22 08:23:14 | favorites | 1 | 81242 | 2 | 2.450 | 33160.0 |
157 | 2021-09-21 14:45:46 | favorites | 1 | 81242 | 2 | 1.516 | 53589.7 |
156 | 2021-09-15 02:52:51 | favorites | 1 | 81242 | 2 | 1.390 | 58447.5 |
155 | 2021-07-07 12:34:47 | favorites | 1 | 81242 | 2 | 1.236 | 65729.8 |
154 | 2021-05-06 15:57:30 | favorites | 3 | 148641 | 72 | 7.220 | 20587.4 |
153 | 2021-04-07 17:05:39 | favorites | 1 | 81242 | 2 | 1.266 | 64172.2 |
152 | 2021-04-04 20:33:46 | favorites | 3 | 148641 | 72 | 7.876 | 18872.7 |
151 | 2021-04-03 13:25:40 | favorites | 1 | 81242 | 2 | 1.250 | 64993.6 |
150 | 2021-03-09 07:36:59 | favorites | 3 | 148641 | 72 | 6.170 | 24090.9 |
149 | 2021-01-20 04:25:04 | favorites | 3 | 148641 | 72 | 6.140 | 24208.6 |
148 | 2020-12-11 09:26:16 | favorites | 1 | 81242 | 2 | 1.263 | 64324.6 |
147 | 2020-11-13 14:45:01 | favorites | 1 | 81242 | 2 | 1.343 | 60492.9 |
146 | 2020-11-02 13:28:18 | favorites | 4 | 165329 | 685 | 13.126 | 12595.5 |
145 | 2020-10-31 22:49:18 | favorites | 2 | 121436 | 7 | 3.046 | 39867.4 |
144 | 2020-10-31 08:44:56 | favorites | 3 | 148641 | 72 | 7.846 | 18944.8 |
143 | 2020-10-18 13:04:57 | favorites | 1 | 81242 | 2 | 1.236 | 65729.8 |
142 | 2020-09-01 04:30:03 | favorites | 1 | 81242 | 2 | 1.313 | 61875.1 |
141 | 2020-08-26 14:45:50 | favorites | 1 | 81242 | 2 | 1.436 | 56575.2 |
140 | 2020-07-29 17:59:13 | favorites | 1 | 81242 | 2 | 1.453 | 55913.3 |
139 | 2020-07-24 14:34:11 | favorites | 1 | 81242 | 2 | 1.326 | 61268.5 |
138 | 2020-06-09 09:13:02 | favorites | 1 | 81242 | 2 | 1.266 | 64172.2 |
137 | 2020-05-24 09:52:26 | favorites | 1 | 81242 | 2 | 1.250 | 64993.6 |
136 | 2020-03-24 02:30:47 | favorites | 1 | 81242 | 2 | 2.826 | 28748.1 |
135 | 2020-03-12 21:53:51 | favorites | 1 | 81242 | 2 | 1.233 | 65889.7 |
134 | 2020-02-29 05:47:28 | favorites | 1 | 81242 | 2 | 1.703 | 47705.2 |
133 | 2020-02-23 15:48:24 | favorites | 1 | 81242 | 2 | 1.453 | 55913.3 |
132 | 2020-02-22 11:49:01 | favorites | 1 | 81242 | 2 | 1.796 | 45235.0 |
131 | 2020-02-21 04:17:59 | favorites | 1 | 81242 | 2 | 3.046 | 26671.7 |
130 | 2020-02-16 17:45:04 | favorites | 1 | 81242 | 2 | 3.063 | 26523.7 |
129 | 2020-02-06 14:14:36 | favorites | 1 | 81242 | 2 | 1.483 | 54782.2 |
128 | 2020-02-03 09:46:46 | favorites | 1 | 81242 | 2 | 3.623 | 22424.0 |
127 | 2020-02-02 20:04:51 | favorites | 1 | 81242 | 2 | 3.110 | 26122.8 |
126 | 2020-01-24 03:58:35 | favorites | 1 | 81242 | 2 | 1.546 | 52549.8 |
125 | 2020-01-23 00:39:12 | favorites | 1 | 81242 | 2 | 1.453 | 55913.3 |
124 | 2020-01-17 20:46:32 | favorites | 1 | 81242 | 2 | 1.610 | 50460.9 |
123 | 2020-01-15 23:41:54 | favorites | 1 | 81242 | 2 | 2.813 | 28880.9 |
122 | 2020-01-11 14:48:45 | favorites | 1 | 81242 | 2 | 1.436 | 56575.2 |
121 | 2020-01-06 21:44:19 | favorites | 1 | 81242 | 2 | 2.000 | 40621.0 |
120 | 2020-01-01 14:06:21 | favorites | 1 | 81242 | 2 | 1.486 | 54671.6 |
119 | 2019-12-30 09:54:56 | favorites | 1 | 81242 | 2 | 1.580 | 51419.0 |
118 | 2019-11-18 20:47:08 | favorites | 1 | 81242 | 2 | 1.390 | 58447.5 |
117 | 2019-11-15 09:37:04 | favorites | 1 | 81242 | 2 | 1.220 | 66591.8 |
116 | 2019-09-09 19:41:44 | favorites | 1 | 81242 | 2 | 1.156 | 70278.5 |
115 | 2019-08-17 05:33:43 | favorites | 1 | 81242 | 2 | 1.156 | 70278.5 |
114 | 2019-05-17 11:36:28 | favorites | 1 | 81242 | 2 | 1.313 | 61875.1 |
113 | 2019-03-27 09:46:26 | favorites | 1 | 81242 | 2 | 1.203 | 67532.8 |
112 | 2019-02-04 23:07:22 | favorites | 1 | 81242 | 2 | 1.463 | 55531.1 |
111 | 2019-01-30 12:00:21 | favorites | 1 | 81242 | 2 | 1.240 | 65517.7 |
110 | 2018-11-06 11:10:59 | favorites | 1 | 81242 | 2 | 1.253 | 64838.0 |
109 | 2018-10-26 01:49:33 | favorites | 1 | 81242 | 2 | 1.690 | 48072.2 |
108 | 2018-09-23 11:02:30 | favorites | 1 | 81242 | 2 | 1.216 | 66810.9 |