History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"skittles"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
207 | 2024-04-25 03:08:32 | skittles | 1 | 82945 | 4 | 3.313 | 25036.2 |
206 | 2024-04-06 08:47:06 | skittles | 1 | 82945 | 4 | 4.123 | 20117.6 |
205 | 2024-03-30 02:43:02 | skittles | 1 | 82945 | 4 | 4.966 | 16702.6 |
204 | 2024-03-30 02:11:01 | skittles | 1 | 82945 | 4 | 4.813 | 17233.5 |
203 | 2024-03-14 10:25:07 | skittles | 2 | 121059 | 27 | 7.733 | 15654.9 |
202 | 2024-03-14 10:24:52 | skittles | 3 | 146162 | 206 | 8.500 | 17195.5 |
201 | 2024-03-08 21:41:29 | skittles | 3 | 146162 | 206 | 14.783 | 9887.2 |
200 | 2024-03-07 22:23:44 | skittles | 3 | 146162 | 206 | 7.970 | 18339.0 |
199 | 2024-03-07 08:53:46 | skittles | 3 | 146162 | 206 | 13.033 | 11214.8 |
198 | 2024-03-07 08:53:46 | skittles | 2 | 121059 | 27 | 8.813 | 13736.4 |
197 | 2024-03-07 06:28:42 | skittles | 1 | 82945 | 4 | 4.983 | 16645.6 |
196 | 2024-03-01 20:53:57 | skittles | 1 | 82945 | 4 | 4.093 | 20265.1 |
195 | 2024-02-28 12:44:22 | skittles | 1 | 82945 | 4 | 1.576 | 52630.1 |
194 | 2024-02-26 21:20:59 | skittles | 1 | 82945 | 4 | 1.486 | 55817.6 |
193 | 2024-01-14 04:41:31 | skittles | 1 | 82945 | 4 | 1.483 | 55930.5 |
192 | 2024-01-12 23:35:16 | skittles | 3 | 146162 | 206 | 7.376 | 19815.9 |
191 | 2024-01-12 23:35:15 | skittles | 2 | 121059 | 27 | 3.860 | 31362.4 |
190 | 2023-12-09 16:43:33 | skittles | 1 | 82945 | 4 | 1.373 | 60411.5 |
189 | 2023-11-23 00:02:05 | skittles | 1 | 82945 | 4 | 1.310 | 63316.8 |
188 | 2023-11-22 19:42:55 | skittles | 1 | 82945 | 4 | 1.500 | 55296.7 |
187 | 2023-11-15 23:22:54 | skittles | 1 | 82945 | 4 | 1.280 | 64800.8 |
186 | 2023-11-03 22:52:25 | skittles | 1 | 82945 | 4 | 1.296 | 64000.8 |
185 | 2023-10-28 13:24:55 | skittles | 1 | 82945 | 4 | 1.313 | 63172.1 |
184 | 2023-10-06 08:16:37 | skittles | 3 | 146162 | 206 | 7.546 | 19369.5 |
183 | 2023-10-06 08:16:38 | skittles | 2 | 121059 | 27 | 3.780 | 32026.2 |
182 | 2023-10-03 11:06:31 | skittles | 1 | 82945 | 4 | 1.283 | 64649.3 |
181 | 2023-09-29 18:38:49 | skittles | 1 | 82945 | 4 | 1.390 | 59672.7 |
180 | 2023-09-26 01:38:42 | skittles | 1 | 82945 | 4 | 1.330 | 62364.7 |
179 | 2023-09-25 20:12:09 | skittles | 1 | 82945 | 4 | 1.250 | 66356.0 |
178 | 2023-08-24 21:31:35 | skittles | 1 | 82945 | 4 | 1.266 | 65517.4 |
177 | 2023-04-26 15:29:35 | skittles | 1 | 82945 | 4 | 1.283 | 64649.3 |
176 | 2022-12-26 15:34:42 | skittles | 1 | 82945 | 4 | 1.313 | 63172.1 |
175 | 2022-10-30 17:08:09 | skittles | 1 | 82945 | 4 | 1.280 | 64800.8 |
174 | 2022-08-19 05:11:38 | skittles | 1 | 82945 | 4 | 1.296 | 64000.8 |
173 | 2022-06-19 07:38:57 | skittles | 1 | 82945 | 4 | 1.263 | 65673.0 |
172 | 2022-04-01 09:17:10 | skittles | 1 | 82945 | 4 | 1.250 | 66356.0 |
171 | 2022-02-24 14:54:21 | skittles | 1 | 82945 | 4 | 1.813 | 45750.1 |
170 | 2021-12-15 17:44:40 | skittles | 1 | 82945 | 4 | 1.280 | 64800.8 |
169 | 2021-12-01 12:41:21 | skittles | 1 | 82945 | 4 | 1.466 | 56579.1 |
168 | 2021-10-24 22:55:17 | skittles | 1 | 82945 | 4 | 1.470 | 56425.2 |
167 | 2021-10-22 22:41:14 | skittles | 1 | 82945 | 4 | 1.406 | 58993.6 |
166 | 2021-09-25 20:36:01 | skittles | 1 | 82945 | 4 | 1.406 | 58993.6 |
165 | 2021-08-08 09:40:45 | skittles | 1 | 82945 | 4 | 1.250 | 66356.0 |
164 | 2021-07-09 23:41:33 | skittles | 2 | 121059 | 27 | 3.796 | 31891.2 |
163 | 2021-05-21 00:38:49 | skittles | 2 | 121059 | 27 | 3.596 | 33664.9 |
162 | 2021-05-06 12:25:58 | skittles | 2 | 121059 | 27 | 3.753 | 32256.6 |
161 | 2021-04-23 05:24:06 | skittles | 1 | 82945 | 4 | 1.513 | 54821.5 |
160 | 2021-03-19 05:51:39 | skittles | 3 | 146162 | 206 | 6.156 | 23743.0 |
159 | 2021-02-02 09:00:30 | skittles | 2 | 121059 | 27 | 3.203 | 37795.5 |
158 | 2020-12-26 00:01:30 | skittles | 1 | 82945 | 4 | 1.266 | 65517.4 |
157 | 2020-11-13 22:13:37 | skittles | 2 | 121059 | 27 | 3.986 | 30371.0 |
156 | 2020-11-09 12:40:23 | skittles | 3 | 146162 | 206 | 7.000 | 20880.3 |
155 | 2020-10-21 22:12:14 | skittles | 1 | 82945 | 4 | 2.423 | 34232.4 |
154 | 2020-10-19 07:07:30 | skittles | 1 | 82945 | 4 | 1.420 | 58412.0 |
153 | 2020-09-22 04:52:51 | skittles | 1 | 82945 | 4 | 1.266 | 65517.4 |
152 | 2020-06-05 11:26:04 | skittles | 1 | 82945 | 4 | 1.266 | 65517.4 |
151 | 2020-04-06 03:17:18 | skittles | 1 | 82945 | 4 | 1.486 | 55817.6 |
150 | 2020-03-23 21:16:42 | skittles | 1 | 82945 | 4 | 2.516 | 32967.0 |
149 | 2020-02-29 18:47:24 | skittles | 1 | 82945 | 4 | 1.500 | 55296.7 |
148 | 2020-02-27 02:38:27 | skittles | 1 | 82945 | 4 | 1.750 | 47397.1 |
147 | 2020-02-22 19:13:36 | skittles | 1 | 82945 | 4 | 1.686 | 49196.3 |
146 | 2020-02-18 12:03:27 | skittles | 1 | 82945 | 4 | 1.783 | 46519.9 |
145 | 2020-02-16 18:17:24 | skittles | 1 | 82945 | 4 | 1.390 | 59672.7 |
144 | 2020-02-02 09:24:42 | skittles | 1 | 82945 | 4 | 1.343 | 61761.0 |
143 | 2020-02-02 05:45:20 | skittles | 1 | 82945 | 4 | 1.360 | 60989.0 |
142 | 2020-01-29 18:28:00 | skittles | 1 | 82945 | 4 | 1.640 | 50576.2 |
141 | 2020-01-23 12:04:16 | skittles | 1 | 82945 | 4 | 5.546 | 14955.8 |
140 | 2020-01-22 17:51:13 | skittles | 1 | 82945 | 4 | 5.033 | 16480.2 |
139 | 2020-01-22 16:11:19 | skittles | 1 | 82945 | 4 | 3.266 | 25396.5 |
138 | 2020-01-16 05:52:22 | skittles | 1 | 82945 | 4 | 1.530 | 54212.4 |
137 | 2020-01-11 15:14:56 | skittles | 1 | 82945 | 4 | 1.516 | 54713.1 |
136 | 2020-01-09 20:47:26 | skittles | 1 | 82945 | 4 | 4.140 | 20035.0 |
135 | 2020-01-07 00:32:52 | skittles | 1 | 82945 | 4 | 3.796 | 21850.6 |
134 | 2019-12-30 01:18:26 | skittles | 1 | 82945 | 4 | 1.423 | 58288.8 |
133 | 2019-11-25 04:41:19 | skittles | 1 | 82945 | 4 | 1.326 | 62552.8 |
132 | 2019-08-23 08:26:53 | skittles | 1 | 82945 | 4 | 1.350 | 61440.7 |
131 | 2019-06-03 19:00:55 | skittles | 1 | 82945 | 4 | 1.290 | 64298.4 |
130 | 2019-05-28 11:50:23 | skittles | 1 | 82945 | 4 | 1.270 | 65311.0 |
129 | 2019-05-11 01:28:37 | skittles | 1 | 82945 | 4 | 1.343 | 61761.0 |
128 | 2019-04-02 11:49:06 | skittles | 1 | 82945 | 4 | 1.296 | 64000.8 |
127 | 2019-02-12 10:00:52 | skittles | 1 | 82945 | 4 | 1.256 | 66039.0 |
126 | 2019-01-27 16:54:49 | skittles | 1 | 82945 | 4 | 1.356 | 61168.9 |
125 | 2019-01-24 04:00:18 | skittles | 1 | 82945 | 4 | 1.366 | 60721.1 |
124 | 2019-01-22 08:51:51 | skittles | 1 | 82945 | 4 | 2.950 | 28116.9 |
123 | 2019-01-20 14:54:11 | skittles | 1 | 82945 | 4 | 1.253 | 66197.1 |
122 | 2019-01-19 22:27:29 | skittles | 1 | 82945 | 4 | 1.483 | 55930.5 |
121 | 2018-12-05 16:22:42 | skittles | 1 | 82945 | 4 | 1.206 | 68776.9 |
120 | 2018-12-01 20:13:51 | skittles | 1 | 82945 | 4 | 1.220 | 67987.7 |
119 | 2018-09-23 08:57:19 | skittles | 1 | 82945 | 4 | 1.483 | 55930.5 |
118 | 2018-07-15 21:37:40 | skittles | 1 | 82945 | 4 | 1.260 | 65829.4 |
117 | 2018-06-27 02:59:55 | skittles | 1 | 82945 | 4 | 1.693 | 48992.9 |
116 | 2018-06-23 08:16:10 | skittles | 1 | 82945 | 4 | 1.400 | 59246.4 |
115 | 2018-06-14 01:06:33 | skittles | 1 | 82945 | 4 | 1.416 | 58577.0 |
114 | 2018-06-06 21:48:52 | skittles | 1 | 82945 | 4 | 1.266 | 65517.4 |
113 | 2018-06-04 10:29:08 | skittles | 1 | 82945 | 4 | 1.596 | 51970.6 |
112 | 2018-04-17 07:10:15 | skittles | 1 | 82945 | 4 | 1.246 | 66569.0 |
111 | 2017-11-21 07:05:31 | skittles | 1 | 82945 | 4 | 1.753 | 47316.0 |
110 | 2017-10-28 13:59:10 | skittles | 1 | 82945 | 4 | 2.010 | 41266.2 |
109 | 2017-10-22 15:22:23 | skittles | 1 | 82945 | 4 | 1.810 | 45826.0 |
108 | 2017-10-20 15:08:47 | skittles | 1 | 82945 | 4 | 2.920 | 28405.8 |