History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"madrigal"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
7271 | 2024-04-19 15:03:23 | madrigal | 4 | 161609 | 454 | 12.733 | 12692.1 |
7270 | 2024-04-19 02:23:09 | madrigal | 1 | 82945 | 2 | 1.470 | 56425.2 |
7269 | 2024-04-18 05:19:08 | madrigal | 1 | 82945 | 2 | 2.423 | 34232.4 |
7268 | 2024-04-18 05:18:59 | madrigal | 1 | 82945 | 2 | 4.170 | 19890.9 |
7267 | 2024-04-17 09:09:58 | madrigal | 4 | 161609 | 454 | 14.373 | 11243.9 |
7266 | 2024-04-17 09:09:51 | madrigal | 3 | 146162 | 61 | 7.203 | 20291.8 |
7265 | 2024-04-17 09:09:47 | madrigal | 2 | 121059 | 4 | 3.220 | 37596.0 |
7264 | 2024-04-17 08:35:58 | madrigal | 1 | 82945 | 2 | 1.470 | 56425.2 |
7263 | 2024-04-16 06:31:41 | madrigal | 2 | 121059 | 4 | 3.986 | 30371.0 |
7262 | 2024-04-16 06:30:10 | madrigal | 3 | 146162 | 61 | 9.250 | 15801.3 |
7261 | 2024-04-16 04:57:46 | madrigal | 1 | 82945 | 2 | 1.846 | 44932.3 |
7260 | 2024-04-15 08:19:53 | madrigal | 2 | 121059 | 4 | 3.813 | 31749.0 |
7259 | 2024-04-15 08:19:33 | madrigal | 3 | 146162 | 61 | 8.313 | 17582.3 |
7258 | 2024-04-14 18:07:04 | madrigal | 1 | 82945 | 2 | 3.250 | 25521.5 |
7257 | 2024-04-13 14:35:04 | madrigal | 4 | 161609 | 454 | 12.703 | 12722.1 |
7256 | 2024-04-13 14:34:56 | madrigal | 3 | 146162 | 61 | 6.923 | 21112.5 |
7255 | 2024-04-13 14:34:49 | madrigal | 2 | 121059 | 4 | 7.280 | 16629.0 |
7254 | 2024-04-13 14:05:16 | madrigal | 1 | 82945 | 2 | 2.923 | 28376.7 |
7253 | 2024-04-12 11:56:50 | madrigal | 1 | 82945 | 2 | 2.000 | 41472.5 |
7252 | 2024-04-12 11:39:23 | madrigal | 1 | 82945 | 2 | 3.596 | 23065.9 |
7251 | 2024-04-11 15:39:40 | madrigal | 1 | 82945 | 2 | 1.593 | 52068.4 |
7250 | 2024-04-11 09:16:22 | madrigal | 2 | 121059 | 4 | 3.780 | 32026.2 |
7249 | 2024-04-11 09:05:27 | madrigal | 3 | 146162 | 61 | 7.406 | 19735.6 |
7248 | 2024-04-11 06:21:05 | madrigal | 4 | 161609 | 454 | 14.250 | 11341.0 |
7247 | 2024-04-11 06:20:54 | madrigal | 3 | 146162 | 61 | 9.313 | 15694.4 |
7246 | 2024-04-11 06:20:48 | madrigal | 2 | 121059 | 4 | 4.423 | 27370.3 |
7245 | 2024-04-11 05:39:43 | madrigal | 1 | 82945 | 2 | 1.563 | 53067.8 |
7244 | 2024-04-10 01:57:37 | madrigal | 4 | 161609 | 454 | 12.623 | 12802.7 |
7243 | 2024-04-10 01:50:31 | madrigal | 4 | 161609 | 454 | 17.440 | 9266.6 |
7242 | 2024-04-09 18:43:30 | madrigal | 1 | 82945 | 2 | 2.690 | 30834.6 |
7241 | 2024-04-09 17:22:17 | madrigal | 1 | 82945 | 2 | 4.970 | 16689.1 |
7240 | 2024-04-09 16:51:17 | madrigal | 1 | 82945 | 2 | 1.436 | 57761.1 |
7239 | 2024-04-09 15:54:39 | madrigal | 1 | 82945 | 2 | 6.580 | 12605.6 |
7238 | 2024-04-01 14:48:24 | madrigal | 4 | 161609 | 454 | 20.096 | 8041.8 |
7237 | 2024-03-31 06:38:55 | madrigal | 4 | 161609 | 454 | 17.643 | 9160.0 |
7236 | 2024-03-31 03:25:45 | madrigal | 2 | 121059 | 4 | 13.360 | 9061.3 |
7235 | 2024-03-31 03:17:52 | madrigal | 1 | 82945 | 2 | 2.890 | 28700.7 |
7234 | 2024-03-30 00:34:25 | madrigal | 4 | 161609 | 454 | 35.796 | 4514.7 |
7233 | 2024-03-29 22:45:43 | madrigal | 3 | 146162 | 61 | 21.983 | 6648.9 |
7232 | 2024-03-29 18:48:22 | madrigal | 2 | 121059 | 4 | 4.203 | 28803.0 |
7231 | 2024-03-29 04:24:22 | madrigal | 2 | 121059 | 4 | 5.156 | 23479.2 |
7230 | 2024-03-28 23:25:19 | madrigal | 3 | 146162 | 61 | 8.893 | 16435.6 |
7229 | 2024-03-28 19:20:44 | madrigal | 4 | 161609 | 454 | 30.096 | 5369.8 |
7228 | 2024-03-28 15:05:06 | madrigal | 4 | 161609 | 454 | 14.656 | 11026.8 |
7227 | 2024-03-28 15:05:08 | madrigal | 2 | 121059 | 4 | 4.216 | 28714.2 |
7226 | 2024-03-28 15:05:01 | madrigal | 1 | 82945 | 2 | 1.533 | 54106.3 |
7225 | 2024-03-28 15:04:49 | madrigal | 3 | 146162 | 61 | 7.643 | 19123.6 |
7224 | 2024-03-28 05:11:10 | madrigal | 3 | 146162 | 61 | 6.640 | 22012.3 |
7223 | 2024-03-19 03:47:34 | madrigal | 1 | 82945 | 2 | 1.810 | 45826.0 |
7222 | 2024-03-18 07:30:35 | madrigal | 1 | 82945 | 2 | 1.420 | 58412.0 |
7221 | 2024-03-11 02:10:45 | madrigal | 3 | 146162 | 61 | 19.546 | 7477.8 |
7220 | 2024-03-11 02:10:41 | madrigal | 2 | 121059 | 4 | 6.720 | 18014.7 |
7219 | 2024-03-11 00:53:45 | madrigal | 3 | 146162 | 61 | 16.830 | 8684.6 |
7218 | 2024-03-08 10:26:06 | madrigal | 1 | 82945 | 2 | 3.626 | 22875.1 |
7217 | 2024-03-07 15:39:05 | madrigal | 4 | 161609 | 454 | 12.953 | 12476.6 |
7216 | 2024-03-06 10:02:43 | madrigal | 3 | 146162 | 61 | 17.800 | 8211.3 |
7215 | 2024-03-05 21:37:03 | madrigal | 4 | 161609 | 454 | 28.643 | 5642.2 |
7214 | 2024-03-05 09:28:16 | madrigal | 4 | 161609 | 454 | 13.453 | 12012.9 |
7213 | 2024-03-05 09:28:08 | madrigal | 3 | 146162 | 61 | 8.373 | 17456.3 |
7212 | 2024-03-05 09:28:04 | madrigal | 2 | 121059 | 4 | 4.033 | 30017.1 |
7211 | 2024-03-05 08:47:14 | madrigal | 1 | 82945 | 2 | 1.516 | 54713.1 |
7210 | 2024-03-02 10:35:58 | madrigal | 4 | 161609 | 454 | 14.266 | 11328.3 |
7209 | 2024-02-29 10:56:55 | madrigal | 1 | 82945 | 2 | 1.423 | 58288.8 |
7208 | 2024-02-27 13:33:13 | madrigal | 2 | 121059 | 4 | 3.250 | 37248.9 |
7207 | 2024-02-27 13:32:58 | madrigal | 3 | 146162 | 61 | 7.563 | 19325.9 |
7206 | 2024-02-26 03:44:53 | madrigal | 4 | 161609 | 454 | 30.753 | 5255.1 |
7205 | 2024-02-25 21:52:03 | madrigal | 2 | 121059 | 4 | 8.093 | 14958.5 |
7204 | 2024-02-25 16:02:35 | madrigal | 4 | 161609 | 454 | 11.966 | 13505.7 |
7203 | 2024-02-25 16:02:32 | madrigal | 3 | 146162 | 61 | 7.706 | 18967.3 |
7202 | 2024-02-25 16:02:31 | madrigal | 2 | 121059 | 4 | 3.860 | 31362.4 |
7201 | 2024-02-25 15:47:28 | madrigal | 1 | 82945 | 2 | 1.563 | 53067.8 |
7200 | 2024-02-21 07:08:00 | madrigal | 1 | 82945 | 2 | 1.513 | 54821.5 |
7199 | 2024-02-21 06:01:20 | madrigal | 1 | 82945 | 2 | 2.436 | 34049.7 |
7198 | 2024-02-20 06:24:58 | madrigal | 1 | 82945 | 2 | 3.313 | 25036.2 |
7197 | 2024-02-18 06:58:53 | madrigal | 2 | 121059 | 4 | 4.736 | 25561.4 |
7196 | 2024-02-17 22:56:59 | madrigal | 1 | 82945 | 2 | 3.233 | 25655.7 |
7195 | 2024-02-11 12:08:58 | madrigal | 1 | 82945 | 2 | 1.516 | 54713.1 |
7194 | 2024-02-07 22:06:17 | madrigal | 2 | 121059 | 4 | 8.580 | 14109.4 |
7193 | 2024-02-07 22:05:56 | madrigal | 3 | 146162 | 61 | 8.126 | 17987.0 |
7192 | 2024-02-07 19:43:51 | madrigal | 2 | 121059 | 4 | 10.843 | 11164.7 |
7191 | 2024-02-06 05:58:58 | madrigal | 2 | 121059 | 4 | 3.296 | 36729.1 |
7190 | 2024-02-06 05:58:46 | madrigal | 3 | 146162 | 61 | 7.250 | 20160.3 |
7189 | 2024-02-04 22:01:15 | madrigal | 4 | 161609 | 454 | 23.470 | 6885.8 |
7188 | 2024-02-04 11:39:47 | madrigal | 4 | 161609 | 454 | 20.486 | 7888.8 |
7187 | 2024-01-28 13:15:39 | madrigal | 3 | 146162 | 61 | 6.500 | 22486.5 |
7186 | 2024-01-28 13:15:35 | madrigal | 2 | 121059 | 4 | 3.236 | 37410.1 |
7185 | 2024-01-26 13:42:15 | madrigal | 4 | 161609 | 454 | 14.033 | 11516.4 |
7184 | 2024-01-26 13:42:07 | madrigal | 3 | 146162 | 61 | 7.686 | 19016.7 |
7183 | 2024-01-26 13:42:03 | madrigal | 2 | 121059 | 4 | 3.653 | 33139.6 |
7182 | 2024-01-26 13:09:55 | madrigal | 1 | 82945 | 2 | 1.656 | 50087.6 |
7181 | 2024-01-26 08:31:01 | madrigal | 3 | 146162 | 61 | 7.593 | 19249.6 |
7180 | 2024-01-25 22:27:12 | madrigal | 4 | 161609 | 454 | 20.533 | 7870.7 |
7179 | 2024-01-24 00:37:08 | madrigal | 4 | 161609 | 454 | 13.110 | 12327.2 |
7178 | 2024-01-24 00:37:01 | madrigal | 3 | 146162 | 61 | 7.393 | 19770.3 |
7177 | 2024-01-24 00:36:57 | madrigal | 2 | 121059 | 4 | 3.420 | 35397.4 |
7176 | 2024-01-24 00:02:33 | madrigal | 1 | 82945 | 2 | 1.453 | 57085.3 |
7175 | 2024-01-22 10:54:13 | madrigal | 4 | 161609 | 454 | 17.016 | 9497.5 |
7174 | 2024-01-22 00:31:56 | madrigal | 1 | 82945 | 2 | 2.670 | 31065.5 |
7173 | 2024-01-21 18:41:04 | madrigal | 1 | 82945 | 2 | 1.420 | 58412.0 |
7172 | 2024-01-21 16:11:48 | madrigal | 1 | 82945 | 2 | 1.296 | 64000.8 |