History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"catalogue"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
213 | 2024-05-01 01:08:27 | catalogue | 1 | 81242 | 4 | 1.453 | 55913.3 |
212 | 2024-04-30 14:09:53 | catalogue | 1 | 81242 | 4 | 2.190 | 37096.8 |
211 | 2024-04-30 00:50:26 | catalogue | 1 | 81242 | 4 | 2.826 | 28748.1 |
210 | 2024-04-21 08:53:46 | catalogue | 1 | 81242 | 4 | 5.313 | 15291.2 |
209 | 2024-04-21 08:52:18 | catalogue | 2 | 121436 | 12 | 6.610 | 18371.6 |
208 | 2024-04-21 08:52:12 | catalogue | 1 | 81242 | 4 | 1.500 | 54161.3 |
207 | 2024-04-21 08:51:16 | catalogue | 3 | 148641 | 30 | 10.266 | 14479.0 |
206 | 2024-04-19 16:53:42 | catalogue | 4 | 165329 | 140 | 50.146 | 3297.0 |
205 | 2024-04-18 00:02:35 | catalogue | 3 | 148641 | 30 | 19.580 | 7591.5 |
204 | 2024-04-17 14:13:21 | catalogue | 3 | 148641 | 30 | 14.063 | 10569.7 |
203 | 2024-04-16 12:02:13 | catalogue | 3 | 148641 | 30 | 32.220 | 4613.3 |
202 | 2024-04-16 08:39:25 | catalogue | 4 | 165329 | 140 | 36.610 | 4516.0 |
201 | 2024-04-15 07:30:25 | catalogue | 4 | 165329 | 140 | 28.753 | 5750.0 |
200 | 2024-04-15 07:30:31 | catalogue | 3 | 148641 | 30 | 18.113 | 8206.3 |
199 | 2024-04-15 07:30:31 | catalogue | 2 | 121436 | 12 | 8.563 | 14181.5 |
198 | 2024-04-15 07:29:00 | catalogue | 1 | 81242 | 4 | 2.826 | 28748.1 |
197 | 2024-04-12 12:19:04 | catalogue | 3 | 148641 | 30 | 25.423 | 5846.7 |
196 | 2024-04-12 12:19:05 | catalogue | 2 | 121436 | 12 | 13.766 | 8821.4 |
195 | 2024-04-12 12:18:12 | catalogue | 1 | 81242 | 4 | 5.110 | 15898.6 |
194 | 2024-03-29 10:52:55 | catalogue | 1 | 81242 | 4 | 3.610 | 22504.7 |
193 | 2024-03-19 20:25:25 | catalogue | 1 | 81242 | 4 | 1.326 | 61268.5 |
192 | 2024-03-16 00:46:25 | catalogue | 3 | 148641 | 30 | 26.486 | 5612.1 |
191 | 2024-03-14 03:42:43 | catalogue | 3 | 148641 | 30 | 10.250 | 14501.6 |
190 | 2024-03-11 10:36:06 | catalogue | 1 | 81242 | 4 | 1.876 | 43306.0 |
189 | 2024-03-11 01:34:38 | catalogue | 3 | 148641 | 30 | 14.876 | 9992.0 |
188 | 2024-03-11 01:34:35 | catalogue | 2 | 121436 | 12 | 6.313 | 19235.9 |
187 | 2024-03-10 16:40:57 | catalogue | 3 | 148641 | 30 | 24.550 | 6054.6 |
186 | 2024-03-10 16:40:56 | catalogue | 2 | 121436 | 12 | 4.403 | 27580.3 |
185 | 2024-03-10 15:42:53 | catalogue | 1 | 81242 | 4 | 3.016 | 26937.0 |
184 | 2024-03-10 08:12:10 | catalogue | 1 | 81242 | 4 | 1.656 | 49059.2 |
183 | 2024-03-02 13:00:39 | catalogue | 1 | 81242 | 4 | 1.703 | 47705.2 |
182 | 2024-02-27 21:54:55 | catalogue | 1 | 81242 | 4 | 1.660 | 48941.0 |
181 | 2024-02-19 15:48:47 | catalogue | 4 | 165329 | 140 | 14.126 | 11703.9 |
180 | 2024-02-09 22:41:32 | catalogue | 3 | 148641 | 30 | 8.890 | 16720.0 |
179 | 2024-02-07 05:53:07 | catalogue | 3 | 148641 | 30 | 7.940 | 18720.5 |
178 | 2024-02-07 05:53:11 | catalogue | 2 | 121436 | 12 | 3.876 | 31330.2 |
177 | 2024-02-07 05:12:31 | catalogue | 1 | 81242 | 4 | 1.436 | 56575.2 |
176 | 2024-01-29 06:02:34 | catalogue | 1 | 81242 | 4 | 2.890 | 28111.4 |
175 | 2024-01-18 12:24:12 | catalogue | 4 | 165329 | 140 | 11.063 | 14944.3 |
174 | 2024-01-06 17:00:25 | catalogue | 4 | 165329 | 140 | 12.720 | 12997.6 |
173 | 2024-01-04 19:09:37 | catalogue | 1 | 81242 | 4 | 1.420 | 57212.7 |
172 | 2023-12-15 11:00:24 | catalogue | 1 | 81242 | 4 | 3.140 | 25873.2 |
171 | 2023-12-12 01:31:51 | catalogue | 1 | 81242 | 4 | 1.326 | 61268.5 |
170 | 2023-12-10 19:33:29 | catalogue | 4 | 165329 | 140 | 16.733 | 9880.4 |
169 | 2023-12-10 14:08:39 | catalogue | 1 | 81242 | 4 | 1.500 | 54161.3 |
168 | 2023-10-30 20:31:34 | catalogue | 4 | 165329 | 140 | 12.640 | 13079.8 |
167 | 2023-09-24 09:06:03 | catalogue | 1 | 81242 | 4 | 1.610 | 50460.9 |
166 | 2023-08-08 01:16:57 | catalogue | 4 | 165329 | 140 | 10.610 | 15582.4 |
165 | 2023-07-18 07:31:25 | catalogue | 1 | 81242 | 4 | 1.280 | 63470.3 |
164 | 2023-07-09 11:29:02 | catalogue | 1 | 81242 | 4 | 1.420 | 57212.7 |
163 | 2023-07-05 17:25:58 | catalogue | 1 | 81242 | 4 | 1.266 | 64172.2 |
162 | 2023-04-20 01:35:47 | catalogue | 4 | 165329 | 140 | 11.326 | 14597.3 |
161 | 2023-04-17 16:50:59 | catalogue | 1 | 81242 | 4 | 1.296 | 62686.7 |
160 | 2023-02-09 18:16:27 | catalogue | 1 | 81242 | 4 | 1.250 | 64993.6 |
159 | 2023-02-07 14:53:23 | catalogue | 1 | 81242 | 4 | 1.393 | 58321.6 |
158 | 2023-01-20 17:23:04 | catalogue | 4 | 165329 | 140 | 12.923 | 12793.4 |
157 | 2022-12-04 15:59:39 | catalogue | 1 | 81242 | 4 | 1.233 | 65889.7 |
156 | 2022-10-30 13:04:27 | catalogue | 4 | 165329 | 140 | 11.126 | 14859.7 |
155 | 2022-09-24 03:42:55 | catalogue | 1 | 81242 | 4 | 1.250 | 64993.6 |
154 | 2022-08-03 19:37:58 | catalogue | 1 | 81242 | 4 | 1.296 | 62686.7 |
153 | 2022-05-31 23:16:44 | catalogue | 4 | 165329 | 140 | 10.813 | 15289.8 |
152 | 2022-04-16 07:58:43 | catalogue | 1 | 81242 | 4 | 1.280 | 63470.3 |
151 | 2022-03-22 12:30:26 | catalogue | 1 | 81242 | 4 | 1.780 | 45641.6 |
150 | 2022-03-20 09:06:00 | catalogue | 1 | 81242 | 4 | 1.266 | 64172.2 |
149 | 2022-01-10 06:13:17 | catalogue | 1 | 81242 | 4 | 1.390 | 58447.5 |
148 | 2021-11-29 02:40:26 | catalogue | 1 | 81242 | 4 | 1.326 | 61268.5 |
147 | 2021-07-29 23:13:13 | catalogue | 1 | 81242 | 4 | 1.436 | 56575.2 |
146 | 2021-05-08 19:04:01 | catalogue | 1 | 81242 | 4 | 1.500 | 54161.3 |
145 | 2021-04-07 07:15:24 | catalogue | 1 | 81242 | 4 | 2.546 | 31909.7 |
144 | 2021-03-11 12:54:47 | catalogue | 1 | 81242 | 4 | 1.310 | 62016.8 |
143 | 2021-02-15 02:57:23 | catalogue | 1 | 81242 | 4 | 1.280 | 63470.3 |
142 | 2020-04-02 03:51:04 | catalogue | 1 | 81242 | 4 | 1.360 | 59736.8 |
141 | 2020-03-23 10:40:37 | catalogue | 1 | 81242 | 4 | 3.080 | 26377.3 |
140 | 2020-03-01 01:01:03 | catalogue | 4 | 165329 | 140 | 13.030 | 12688.3 |
139 | 2020-02-28 17:41:11 | catalogue | 4 | 165329 | 140 | 23.253 | 7110.0 |
138 | 2020-02-24 21:06:05 | catalogue | 4 | 165329 | 140 | 14.143 | 11689.8 |
137 | 2020-02-19 08:03:45 | catalogue | 4 | 165329 | 140 | 28.440 | 5813.3 |
136 | 2020-02-19 08:01:17 | catalogue | 1 | 81242 | 4 | 3.233 | 25129.0 |
135 | 2020-02-07 23:36:00 | catalogue | 1 | 81242 | 4 | 4.893 | 16603.7 |
134 | 2020-02-05 12:18:19 | catalogue | 1 | 81242 | 4 | 1.516 | 53589.7 |
133 | 2020-02-04 06:55:52 | catalogue | 4 | 165329 | 140 | 22.876 | 7227.2 |
132 | 2020-02-03 22:00:13 | catalogue | 1 | 81242 | 4 | 1.563 | 51978.2 |
131 | 2020-02-01 10:22:40 | catalogue | 4 | 165329 | 140 | 15.313 | 10796.6 |
130 | 2020-01-31 15:26:28 | catalogue | 4 | 165329 | 140 | 39.706 | 4163.8 |
129 | 2020-01-30 20:26:33 | catalogue | 1 | 81242 | 4 | 3.470 | 23412.7 |
128 | 2020-01-24 23:51:35 | catalogue | 2 | 121436 | 12 | 4.513 | 26908.0 |
127 | 2020-01-24 20:52:15 | catalogue | 3 | 148641 | 30 | 27.016 | 5502.0 |
126 | 2020-01-22 00:13:52 | catalogue | 1 | 81242 | 4 | 2.813 | 28880.9 |
125 | 2020-01-17 01:27:54 | catalogue | 4 | 165329 | 140 | 13.560 | 12192.4 |
124 | 2020-01-16 13:29:58 | catalogue | 1 | 81242 | 4 | 1.516 | 53589.7 |
123 | 2020-01-14 21:25:42 | catalogue | 4 | 165329 | 140 | 15.363 | 10761.5 |
122 | 2020-01-06 16:09:44 | catalogue | 3 | 148641 | 30 | 11.296 | 13158.7 |
121 | 2020-01-06 13:24:13 | catalogue | 2 | 121436 | 12 | 8.186 | 14834.6 |
120 | 2020-01-06 13:23:52 | catalogue | 4 | 165329 | 140 | 26.143 | 6324.0 |
119 | 2020-01-06 09:08:13 | catalogue | 1 | 81242 | 4 | 3.250 | 24997.5 |
118 | 2020-01-01 19:56:01 | catalogue | 1 | 81242 | 4 | 1.640 | 49537.8 |
117 | 2019-12-22 04:34:44 | catalogue | 1 | 81242 | 4 | 1.326 | 61268.5 |
116 | 2019-09-21 02:09:29 | catalogue | 1 | 81242 | 4 | 1.443 | 56300.8 |
115 | 2019-06-09 01:45:01 | catalogue | 1 | 81242 | 4 | 1.410 | 57618.4 |
114 | 2019-03-07 15:18:46 | catalogue | 1 | 81242 | 4 | 1.236 | 65729.8 |