History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"supersale"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
197 | 2024-05-02 11:00:59 | supersale | 1 | 81242 | 5 | 4.313 | 18836.5 |
196 | 2024-04-29 18:25:18 | supersale | 1 | 81242 | 5 | 1.330 | 61084.2 |
195 | 2024-04-19 04:07:48 | supersale | 3 | 148641 | 86 | 30.686 | 4843.9 |
194 | 2024-04-19 03:40:58 | supersale | 1 | 81242 | 5 | 1.466 | 55417.5 |
193 | 2024-04-18 06:24:31 | supersale | 4 | 165329 | 409 | 44.283 | 3733.5 |
192 | 2024-04-16 02:14:55 | supersale | 4 | 165329 | 409 | 38.050 | 4345.0 |
191 | 2024-04-12 22:22:57 | supersale | 1 | 81242 | 5 | 1.500 | 54161.3 |
190 | 2024-04-12 17:10:24 | supersale | 4 | 165329 | 409 | 39.360 | 4200.4 |
189 | 2024-04-05 20:16:50 | supersale | 1 | 81242 | 5 | 1.376 | 59042.2 |
188 | 2024-03-30 13:47:19 | supersale | 1 | 81242 | 5 | 1.483 | 54782.2 |
187 | 2024-03-27 23:26:44 | supersale | 1 | 81242 | 5 | 2.203 | 36877.9 |
186 | 2024-03-27 22:31:21 | supersale | 2 | 121436 | 17 | 7.376 | 16463.7 |
185 | 2024-03-26 19:22:55 | supersale | 2 | 121436 | 17 | 8.593 | 14132.0 |
184 | 2024-03-26 00:22:18 | supersale | 4 | 165329 | 409 | 28.893 | 5722.1 |
183 | 2024-03-26 00:22:09 | supersale | 3 | 148641 | 86 | 18.016 | 8250.5 |
182 | 2024-03-26 00:22:01 | supersale | 2 | 121436 | 17 | 13.030 | 9319.7 |
181 | 2024-03-19 14:13:58 | supersale | 1 | 81242 | 5 | 3.580 | 22693.3 |
180 | 2024-03-18 10:34:01 | supersale | 4 | 165329 | 409 | 41.690 | 3965.7 |
179 | 2024-03-15 04:10:38 | supersale | 4 | 165329 | 409 | 33.566 | 4925.5 |
178 | 2024-03-13 21:45:36 | supersale | 4 | 165329 | 409 | 20.456 | 8082.2 |
177 | 2024-03-11 19:29:54 | supersale | 4 | 165329 | 409 | 43.580 | 3793.7 |
176 | 2024-03-11 16:02:53 | supersale | 4 | 165329 | 409 | 41.516 | 3982.3 |
175 | 2024-03-10 07:22:18 | supersale | 3 | 148641 | 86 | 13.453 | 11048.9 |
174 | 2024-03-10 00:13:46 | supersale | 3 | 148641 | 86 | 20.236 | 7345.4 |
173 | 2024-03-08 15:08:42 | supersale | 3 | 148641 | 86 | 20.076 | 7403.9 |
172 | 2024-03-06 01:47:00 | supersale | 1 | 81242 | 5 | 4.940 | 16445.7 |
171 | 2024-03-02 02:20:49 | supersale | 1 | 81242 | 5 | 3.156 | 25742.1 |
170 | 2024-02-29 02:50:54 | supersale | 1 | 81242 | 5 | 1.376 | 59042.2 |
169 | 2024-02-24 21:36:42 | supersale | 4 | 165329 | 409 | 15.190 | 10884.1 |
168 | 2024-02-24 21:36:41 | supersale | 3 | 148641 | 86 | 10.533 | 14111.9 |
167 | 2024-02-24 21:36:40 | supersale | 2 | 121436 | 17 | 9.563 | 12698.5 |
166 | 2024-02-15 05:44:40 | supersale | 4 | 165329 | 409 | 19.940 | 8291.3 |
165 | 2024-02-06 10:23:13 | supersale | 4 | 165329 | 409 | 20.516 | 8058.5 |
164 | 2024-02-06 01:00:52 | supersale | 4 | 165329 | 409 | 18.860 | 8766.1 |
163 | 2024-02-06 01:00:45 | supersale | 3 | 148641 | 86 | 11.263 | 13197.3 |
162 | 2024-02-06 01:00:44 | supersale | 2 | 121436 | 17 | 9.516 | 12761.2 |
161 | 2024-02-06 00:46:18 | supersale | 1 | 81242 | 5 | 1.470 | 55266.7 |
160 | 2024-01-29 10:47:08 | supersale | 1 | 81242 | 5 | 1.513 | 53696.0 |
159 | 2024-01-10 03:49:57 | supersale | 1 | 81242 | 5 | 1.376 | 59042.2 |
158 | 2023-12-28 16:07:59 | supersale | 1 | 81242 | 5 | 1.406 | 57782.4 |
157 | 2023-12-15 13:52:04 | supersale | 1 | 81242 | 5 | 1.406 | 57782.4 |
156 | 2023-11-11 01:33:45 | supersale | 1 | 81242 | 5 | 1.376 | 59042.2 |
155 | 2023-11-04 18:32:07 | supersale | 1 | 81242 | 5 | 1.280 | 63470.3 |
154 | 2023-08-26 16:43:44 | supersale | 1 | 81242 | 5 | 1.280 | 63470.3 |
153 | 2023-06-27 11:53:30 | supersale | 1 | 81242 | 5 | 1.263 | 64324.6 |
152 | 2023-05-28 22:58:53 | supersale | 1 | 81242 | 5 | 1.220 | 66591.8 |
151 | 2023-03-24 07:43:19 | supersale | 1 | 81242 | 5 | 1.376 | 59042.2 |
150 | 2023-02-26 00:58:59 | supersale | 1 | 81242 | 5 | 1.250 | 64993.6 |
149 | 2023-01-09 01:48:25 | supersale | 1 | 81242 | 5 | 1.233 | 65889.7 |
148 | 2022-10-18 22:40:46 | supersale | 1 | 81242 | 5 | 1.250 | 64993.6 |
147 | 2022-10-13 02:11:23 | supersale | 1 | 81242 | 5 | 1.266 | 64172.2 |
146 | 2022-06-10 02:04:21 | supersale | 1 | 81242 | 5 | 1.280 | 63470.3 |
145 | 2022-06-02 12:17:28 | supersale | 1 | 81242 | 5 | 1.343 | 60492.9 |
144 | 2022-02-16 18:05:19 | supersale | 1 | 81242 | 5 | 1.500 | 54161.3 |
143 | 2022-02-14 14:09:19 | supersale | 1 | 81242 | 5 | 1.266 | 64172.2 |
142 | 2022-01-29 17:43:51 | supersale | 1 | 81242 | 5 | 1.296 | 62686.7 |
141 | 2021-09-30 03:27:17 | supersale | 1 | 81242 | 5 | 1.453 | 55913.3 |
140 | 2021-09-27 06:47:41 | supersale | 1 | 81242 | 5 | 1.326 | 61268.5 |
139 | 2021-09-26 19:01:02 | supersale | 1 | 81242 | 5 | 1.466 | 55417.5 |
138 | 2021-09-21 22:47:45 | supersale | 1 | 81242 | 5 | 1.250 | 64993.6 |
137 | 2021-06-13 23:23:19 | supersale | 1 | 81242 | 5 | 1.576 | 51549.5 |
136 | 2021-03-11 03:23:52 | supersale | 1 | 81242 | 5 | 1.280 | 63470.3 |
135 | 2020-12-07 21:10:18 | supersale | 1 | 81242 | 5 | 1.403 | 57905.9 |
134 | 2020-12-07 19:44:18 | supersale | 1 | 81242 | 5 | 1.266 | 64172.2 |
133 | 2020-10-22 01:45:43 | supersale | 1 | 81242 | 5 | 1.250 | 64993.6 |
132 | 2020-10-19 11:28:37 | supersale | 1 | 81242 | 5 | 1.263 | 64324.6 |
131 | 2020-10-10 05:30:26 | supersale | 1 | 81242 | 5 | 1.263 | 64324.6 |
130 | 2020-08-29 05:14:55 | supersale | 1 | 81242 | 5 | 1.283 | 63321.9 |
129 | 2020-08-22 13:40:18 | supersale | 1 | 81242 | 5 | 1.266 | 64172.2 |
128 | 2020-05-21 13:40:28 | supersale | 1 | 81242 | 5 | 1.376 | 59042.2 |
127 | 2020-03-22 08:11:00 | supersale | 1 | 81242 | 5 | 1.500 | 54161.3 |
126 | 2020-02-28 19:03:22 | supersale | 1 | 81242 | 5 | 1.686 | 48186.2 |
125 | 2020-02-27 12:57:33 | supersale | 1 | 81242 | 5 | 3.750 | 21664.5 |
124 | 2020-02-20 02:31:55 | supersale | 1 | 81242 | 5 | 1.656 | 49059.2 |
123 | 2020-02-19 22:22:45 | supersale | 1 | 81242 | 5 | 1.530 | 53099.3 |
122 | 2020-02-18 11:31:05 | supersale | 1 | 81242 | 5 | 1.466 | 55417.5 |
121 | 2020-02-13 04:49:18 | supersale | 1 | 81242 | 5 | 1.910 | 42535.1 |
120 | 2020-02-09 16:00:39 | supersale | 1 | 81242 | 5 | 3.123 | 26014.1 |
119 | 2020-02-03 14:02:02 | supersale | 1 | 81242 | 5 | 1.563 | 51978.2 |
118 | 2020-02-03 09:39:49 | supersale | 1 | 81242 | 5 | 1.626 | 49964.3 |
117 | 2020-01-28 07:44:30 | supersale | 1 | 81242 | 5 | 3.143 | 25848.6 |
116 | 2020-01-22 18:03:21 | supersale | 1 | 81242 | 5 | 2.890 | 28111.4 |
115 | 2020-01-22 02:46:23 | supersale | 1 | 81242 | 5 | 1.483 | 54782.2 |
114 | 2020-01-16 00:59:35 | supersale | 1 | 81242 | 5 | 3.060 | 26549.7 |
113 | 2020-01-15 23:59:01 | supersale | 1 | 81242 | 5 | 1.360 | 59736.8 |
112 | 2020-01-13 05:29:31 | supersale | 1 | 81242 | 5 | 1.393 | 58321.6 |
111 | 2020-01-01 09:41:29 | supersale | 1 | 81242 | 5 | 1.436 | 56575.2 |
110 | 2019-12-30 17:14:22 | supersale | 1 | 81242 | 5 | 1.516 | 53589.7 |
109 | 2019-11-19 02:38:31 | supersale | 1 | 81242 | 5 | 1.296 | 62686.7 |
108 | 2019-08-20 13:28:18 | supersale | 1 | 81242 | 5 | 1.210 | 67142.1 |
107 | 2019-07-25 08:17:59 | supersale | 1 | 81242 | 5 | 1.226 | 66265.9 |
106 | 2019-05-14 13:05:43 | supersale | 1 | 81242 | 5 | 1.426 | 56971.9 |
105 | 2019-02-26 16:53:53 | supersale | 1 | 81242 | 5 | 1.210 | 67142.1 |
104 | 2019-02-09 12:57:40 | supersale | 1 | 81242 | 5 | 1.226 | 66265.9 |
103 | 2019-01-26 15:51:03 | supersale | 1 | 81242 | 5 | 1.390 | 58447.5 |
102 | 2019-01-23 10:59:24 | supersale | 1 | 81242 | 5 | 1.386 | 58616.2 |
101 | 2018-12-22 22:12:10 | supersale | 1 | 81242 | 5 | 1.253 | 64838.0 |
100 | 2018-10-02 11:55:54 | supersale | 1 | 81242 | 5 | 1.733 | 46879.4 |
99 | 2018-08-09 12:38:00 | supersale | 1 | 81242 | 5 | 1.423 | 57092.1 |
98 | 2018-07-03 04:00:55 | supersale | 1 | 81242 | 5 | 1.556 | 52212.1 |