History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pice"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
2234 | 2024-12-26 12:22:19 | pice | 1 | 13983 | 25 | 2.123 | 6586.4 |
2233 | 2024-12-25 16:24:55 | pice | 2 | 29872 | 364 | 2.200 | 13578.2 |
2232 | 2024-12-25 16:09:55 | pice | 2 | 29872 | 364 | 4.203 | 7107.3 |
2231 | 2024-12-25 16:09:49 | pice | 1 | 13983 | 25 | 0.313 | 44674.1 |
2230 | 2024-12-11 14:23:04 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2229 | 2024-12-09 21:28:19 | pice | 1 | 13983 | 25 | 1.203 | 11623.4 |
2228 | 2024-12-06 20:05:05 | pice | 2 | 29872 | 364 | 6.376 | 4685.1 |
2227 | 2024-12-06 13:26:48 | pice | 2 | 29872 | 364 | 6.483 | 4607.7 |
2226 | 2024-12-06 12:25:15 | pice | 1 | 13983 | 25 | 0.966 | 14475.2 |
2225 | 2024-11-27 08:40:47 | pice | 1 | 13983 | 25 | 0.936 | 14939.1 |
2224 | 2024-11-26 07:57:54 | pice | 1 | 13983 | 25 | 0.200 | 69915.0 |
2223 | 2024-11-25 13:50:24 | pice | 1 | 13983 | 25 | 1.030 | 13575.7 |
2222 | 2024-11-22 12:01:29 | pice | 1 | 13983 | 25 | 0.236 | 59250.0 |
2221 | 2024-11-12 00:16:48 | pice | 1 | 13983 | 25 | 1.173 | 11920.7 |
2220 | 2024-11-06 08:56:59 | pice | 2 | 29872 | 364 | 4.563 | 6546.6 |
2219 | 2024-11-06 08:55:31 | pice | 1 | 13983 | 25 | 0.263 | 53167.3 |
2218 | 2024-10-28 05:41:22 | pice | 2 | 29872 | 364 | 2.826 | 10570.4 |
2217 | 2024-10-28 03:41:07 | pice | 2 | 29872 | 364 | 6.406 | 4663.1 |
2216 | 2024-10-28 01:41:52 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2215 | 2024-10-27 04:53:33 | pice | 1 | 13983 | 25 | 1.343 | 10411.8 |
2214 | 2024-10-26 11:58:39 | pice | 1 | 13983 | 25 | 0.296 | 47239.9 |
2213 | 2024-10-26 00:04:35 | pice | 1 | 13983 | 25 | 0.560 | 24969.6 |
2212 | 2024-10-20 17:44:29 | pice | 1 | 13983 | 25 | 0.733 | 19076.4 |
2211 | 2024-10-20 17:22:12 | pice | 1 | 13983 | 25 | 0.670 | 20870.1 |
2210 | 2024-10-07 05:32:15 | pice | 2 | 29872 | 364 | 6.500 | 4595.7 |
2209 | 2024-10-07 05:15:25 | pice | 1 | 13983 | 25 | 1.750 | 7990.3 |
2208 | 2024-09-27 21:34:52 | pice | 1 | 13983 | 25 | 0.670 | 20870.1 |
2207 | 2024-09-27 00:49:51 | pice | 2 | 29872 | 364 | 3.906 | 7647.7 |
2206 | 2024-09-26 22:47:16 | pice | 2 | 29872 | 364 | 5.576 | 5357.2 |
2205 | 2024-09-26 22:07:37 | pice | 2 | 29872 | 364 | 10.220 | 2922.9 |
2204 | 2024-09-26 22:06:27 | pice | 1 | 13983 | 25 | 1.936 | 7222.6 |
2203 | 2024-09-26 08:58:16 | pice | 1 | 13983 | 25 | 0.686 | 20383.4 |
2202 | 2024-09-07 04:00:30 | pice | 1 | 13983 | 25 | 0.766 | 18254.6 |
2201 | 2024-08-30 08:21:30 | pice | 1 | 13983 | 25 | 2.453 | 5700.4 |
2200 | 2024-08-28 16:15:43 | pice | 1 | 13983 | 25 | 1.060 | 13191.5 |
2199 | 2024-08-27 21:58:18 | pice | 1 | 13983 | 25 | 2.656 | 5264.7 |
2198 | 2024-08-27 06:46:10 | pice | 2 | 29872 | 364 | 8.016 | 3726.5 |
2197 | 2024-08-26 17:12:53 | pice | 2 | 29872 | 364 | 6.186 | 4829.0 |
2196 | 2024-08-26 17:12:44 | pice | 1 | 13983 | 25 | 1.093 | 12793.2 |
2195 | 2024-08-24 15:57:44 | pice | 1 | 13983 | 25 | 0.453 | 30867.5 |
2194 | 2024-08-12 03:43:21 | pice | 1 | 13983 | 25 | 1.250 | 11186.4 |
2193 | 2024-08-11 03:09:17 | pice | 1 | 13983 | 25 | 0.266 | 52567.7 |
2192 | 2024-08-07 20:09:56 | pice | 1 | 13983 | 25 | 1.360 | 10281.6 |
2191 | 2024-08-05 11:27:21 | pice | 1 | 13983 | 25 | 0.280 | 49939.3 |
2190 | 2024-08-04 06:55:26 | pice | 1 | 13983 | 25 | 0.953 | 14672.6 |
2189 | 2024-08-02 02:30:14 | pice | 2 | 29872 | 364 | 3.936 | 7589.4 |
2188 | 2024-08-02 02:09:40 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2187 | 2024-07-29 15:13:48 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2186 | 2024-07-28 21:33:14 | pice | 1 | 13983 | 25 | 1.126 | 12418.3 |
2185 | 2024-07-27 16:37:48 | pice | 1 | 13983 | 25 | 1.186 | 11790.1 |
2184 | 2024-07-20 07:50:31 | pice | 1 | 13983 | 25 | 0.343 | 40766.8 |
2183 | 2024-07-11 13:48:53 | pice | 1 | 13983 | 25 | 1.016 | 13762.8 |
2182 | 2024-07-07 09:57:26 | pice | 1 | 13983 | 25 | 0.373 | 37487.9 |
2181 | 2024-07-06 08:36:42 | pice | 2 | 29872 | 364 | 4.126 | 7239.9 |
2180 | 2024-07-02 22:41:59 | pice | 1 | 13983 | 25 | 0.280 | 49939.3 |
2179 | 2024-06-30 20:59:39 | pice | 2 | 29872 | 364 | 2.686 | 11121.4 |
2178 | 2024-06-30 19:18:23 | pice | 2 | 29872 | 364 | 1.610 | 18554.0 |
2177 | 2024-06-30 03:55:44 | pice | 1 | 13983 | 25 | 0.686 | 20383.4 |
2176 | 2024-06-29 09:29:07 | pice | 1 | 13983 | 25 | 0.873 | 16017.2 |
2175 | 2024-06-28 19:35:33 | pice | 1 | 13983 | 25 | 1.640 | 8526.2 |
2174 | 2024-06-27 14:20:37 | pice | 1 | 13983 | 25 | 0.983 | 14224.8 |
2173 | 2024-06-20 17:51:25 | pice | 1 | 13983 | 25 | 0.970 | 14415.5 |
2172 | 2024-06-13 03:27:14 | pice | 1 | 13983 | 25 | 0.936 | 14939.1 |
2171 | 2024-06-13 02:42:46 | pice | 2 | 29872 | 364 | 3.263 | 9154.8 |
2170 | 2024-06-12 23:12:24 | pice | 1 | 13983 | 25 | 1.546 | 9044.6 |
2169 | 2024-06-12 00:27:12 | pice | 2 | 29872 | 364 | 3.250 | 9191.4 |
2168 | 2024-06-06 03:14:28 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2167 | 2024-06-04 11:10:25 | pice | 1 | 13983 | 25 | 1.000 | 13983.0 |
2166 | 2024-06-04 06:48:52 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2165 | 2024-06-02 23:43:09 | pice | 2 | 29872 | 364 | 4.126 | 7239.9 |
2164 | 2024-06-02 11:29:09 | pice | 2 | 29872 | 364 | 2.016 | 14817.5 |
2163 | 2024-05-30 07:09:50 | pice | 1 | 13983 | 25 | 1.533 | 9121.3 |
2162 | 2024-05-29 06:37:54 | pice | 2 | 29872 | 364 | 1.783 | 16753.8 |
2161 | 2024-05-29 03:45:11 | pice | 2 | 29872 | 364 | 2.703 | 11051.4 |
2160 | 2024-05-29 03:36:48 | pice | 1 | 13983 | 25 | 1.046 | 13368.1 |
2159 | 2024-05-26 10:22:23 | pice | 1 | 13983 | 25 | 0.843 | 16587.2 |
2158 | 2024-05-10 17:11:51 | pice | 1 | 13983 | 25 | 0.216 | 64736.1 |
2157 | 2024-05-10 01:04:14 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2156 | 2024-05-08 17:25:51 | pice | 2 | 29872 | 364 | 1.126 | 26529.3 |
2155 | 2024-05-08 16:24:52 | pice | 2 | 29872 | 364 | 1.000 | 29872.0 |
2154 | 2024-05-05 09:49:24 | pice | 1 | 13983 | 25 | 0.546 | 25609.9 |
2153 | 2024-05-05 02:41:17 | pice | 1 | 13983 | 25 | 0.516 | 27098.8 |
2152 | 2024-05-02 12:19:08 | pice | 1 | 13983 | 25 | 0.796 | 17566.6 |
2151 | 2024-04-30 00:20:10 | pice | 1 | 13983 | 25 | 0.266 | 52567.7 |
2150 | 2024-04-26 04:50:06 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2149 | 2024-04-09 20:59:57 | pice | 1 | 13983 | 25 | 0.250 | 55932.0 |
2148 | 2024-04-09 19:51:19 | pice | 1 | 13983 | 25 | 0.326 | 42892.6 |
2147 | 2024-04-04 22:52:02 | pice | 1 | 13983 | 25 | 0.563 | 24836.6 |
2146 | 2024-03-30 19:52:14 | pice | 2 | 29872 | 364 | 2.690 | 11104.8 |
2145 | 2024-03-30 18:41:28 | pice | 1 | 13983 | 25 | 0.283 | 49409.9 |
2144 | 2024-03-05 20:31:57 | pice | 1 | 13983 | 25 | 0.830 | 16847.0 |
2143 | 2024-03-05 10:30:58 | pice | 1 | 13983 | 25 | 0.263 | 53167.3 |
2142 | 2024-02-25 16:24:58 | pice | 1 | 13983 | 25 | 0.356 | 39278.1 |
2141 | 2024-02-24 08:04:29 | pice | 1 | 13983 | 25 | 0.220 | 63559.1 |
2140 | 2024-01-21 10:45:27 | pice | 1 | 13983 | 25 | 0.203 | 68881.8 |
2139 | 2024-01-17 02:40:01 | pice | 2 | 29872 | 364 | 0.766 | 38997.4 |
2138 | 2024-01-15 22:03:48 | pice | 2 | 29872 | 364 | 0.736 | 40587.0 |
2137 | 2024-01-14 18:13:03 | pice | 2 | 29872 | 364 | 0.750 | 39829.3 |
2136 | 2024-01-14 00:40:19 | pice | 2 | 29872 | 364 | 0.750 | 39829.3 |
2135 | 2024-01-13 04:49:20 | pice | 2 | 29872 | 364 | 0.983 | 30388.6 |