History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pedigreed"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 246 | 2025-10-31 19:18:07 | pedigreed | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 245 | 2025-09-26 05:37:14 | pedigreed | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 244 | 2025-09-08 17:19:30 | pedigreed | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 243 | 2025-08-28 18:50:02 | pedigreed | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 242 | 2025-08-01 07:00:22 | pedigreed | 1 | 81242 | 3 | 4.093 | 19849.0 |
| 241 | 2025-07-29 02:51:03 | pedigreed | 2 | 121436 | 3 | 12.123 | 10017.0 |
| 240 | 2025-07-27 02:03:28 | pedigreed | 1 | 81242 | 3 | 3.436 | 23644.4 |
| 239 | 2025-07-26 08:16:24 | pedigreed | 1 | 81242 | 3 | 5.423 | 14981.0 |
| 238 | 2025-05-31 14:24:00 | pedigreed | 1 | 81242 | 3 | 6.376 | 12741.8 |
| 237 | 2025-05-08 12:07:18 | pedigreed | 1 | 81242 | 3 | 5.970 | 13608.4 |
| 236 | 2025-04-02 11:27:31 | pedigreed | 1 | 81242 | 3 | 6.860 | 11842.9 |
| 235 | 2025-03-27 00:07:01 | pedigreed | 3 | 148641 | 13 | 37.253 | 3990.0 |
| 234 | 2025-03-25 17:59:15 | pedigreed | 1 | 81242 | 3 | 7.016 | 11579.5 |
| 233 | 2025-03-15 05:48:52 | pedigreed | 3 | 148641 | 13 | 38.316 | 3879.3 |
| 232 | 2025-03-11 18:00:34 | pedigreed | 1 | 81242 | 3 | 6.640 | 12235.2 |
| 231 | 2025-03-10 13:48:33 | pedigreed | 1 | 81242 | 3 | 6.080 | 13362.2 |
| 230 | 2025-03-05 17:03:01 | pedigreed | 1 | 81242 | 3 | 9.390 | 8652.0 |
| 229 | 2025-02-19 03:47:26 | pedigreed | 1 | 81242 | 3 | 10.453 | 7772.1 |
| 228 | 2025-02-18 03:46:45 | pedigreed | 3 | 148641 | 13 | 35.313 | 4209.2 |
| 227 | 2025-02-18 03:46:31 | pedigreed | 3 | 148641 | 13 | 42.096 | 3531.0 |
| 226 | 2025-02-18 03:46:26 | pedigreed | 2 | 121436 | 3 | 18.546 | 6547.8 |
| 225 | 2025-02-18 03:45:35 | pedigreed | 1 | 81242 | 3 | 6.720 | 12089.6 |
| 224 | 2025-01-16 18:58:51 | pedigreed | 3 | 148641 | 13 | 47.063 | 3158.3 |
| 223 | 2025-01-16 18:58:56 | pedigreed | 2 | 121436 | 3 | 15.343 | 7914.7 |
| 222 | 2025-01-16 18:58:05 | pedigreed | 1 | 81242 | 3 | 5.843 | 13904.2 |
| 221 | 2025-01-14 10:06:01 | pedigreed | 3 | 148641 | 13 | 36.503 | 4072.0 |
| 220 | 2025-01-10 18:31:55 | pedigreed | 3 | 148641 | 13 | 52.330 | 2840.5 |
| 219 | 2025-01-10 18:31:58 | pedigreed | 2 | 121436 | 3 | 13.143 | 9239.6 |
| 218 | 2025-01-10 18:29:33 | pedigreed | 1 | 81242 | 3 | 7.140 | 11378.4 |
| 217 | 2025-01-09 06:44:02 | pedigreed | 3 | 148641 | 13 | 33.753 | 4403.8 |
| 216 | 2025-01-09 06:44:08 | pedigreed | 2 | 121436 | 3 | 15.486 | 7841.7 |
| 215 | 2025-01-09 06:43:25 | pedigreed | 3 | 148641 | 13 | 36.173 | 4109.2 |
| 214 | 2025-01-09 06:42:21 | pedigreed | 1 | 81242 | 3 | 6.063 | 13399.6 |
| 213 | 2024-12-15 19:20:38 | pedigreed | 1 | 81242 | 3 | 5.096 | 15942.3 |
| 212 | 2024-12-11 09:32:44 | pedigreed | 3 | 148641 | 13 | 38.783 | 3832.6 |
| 211 | 2024-12-11 09:32:46 | pedigreed | 3 | 148641 | 13 | 25.470 | 5835.9 |
| 210 | 2024-12-11 09:32:45 | pedigreed | 2 | 121436 | 3 | 25.656 | 4733.2 |
| 209 | 2024-12-11 09:31:34 | pedigreed | 1 | 81242 | 3 | 6.923 | 11735.1 |
| 208 | 2024-12-09 20:53:51 | pedigreed | 1 | 81242 | 3 | 6.753 | 12030.5 |
| 207 | 2024-12-02 00:40:58 | pedigreed | 1 | 81242 | 3 | 6.766 | 12007.4 |
| 206 | 2024-11-08 20:49:18 | pedigreed | 1 | 81242 | 3 | 3.280 | 24768.9 |
| 205 | 2024-11-07 21:07:06 | pedigreed | 1 | 81242 | 3 | 3.546 | 22910.9 |
| 204 | 2024-11-03 23:22:26 | pedigreed | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 203 | 2024-10-30 10:15:36 | pedigreed | 1 | 81242 | 3 | 5.390 | 15072.7 |
| 202 | 2024-10-13 05:39:40 | pedigreed | 3 | 148641 | 13 | 47.373 | 3137.7 |
| 201 | 2024-10-08 12:52:48 | pedigreed | 1 | 81242 | 3 | 7.500 | 10832.3 |
| 200 | 2024-09-18 22:49:23 | pedigreed | 1 | 81242 | 3 | 15.173 | 5354.4 |
| 199 | 2024-09-17 22:44:27 | pedigreed | 3 | 148641 | 13 | 43.643 | 3405.8 |
| 198 | 2024-09-15 01:36:35 | pedigreed | 3 | 148641 | 13 | 26.140 | 5686.3 |
| 197 | 2024-09-11 11:23:55 | pedigreed | 3 | 148641 | 13 | 75.460 | 1969.8 |
| 196 | 2024-09-10 01:18:51 | pedigreed | 3 | 148641 | 13 | 74.160 | 2004.3 |
| 195 | 2024-09-06 22:03:16 | pedigreed | 1 | 81242 | 3 | 1.470 | 55266.7 |
| 194 | 2024-08-26 11:42:15 | pedigreed | 1 | 81242 | 3 | 16.563 | 4905.0 |
| 193 | 2024-08-24 20:24:40 | pedigreed | 3 | 148641 | 13 | 52.676 | 2821.8 |
| 192 | 2024-08-24 20:24:40 | pedigreed | 3 | 148641 | 13 | 39.550 | 3758.3 |
| 191 | 2024-08-24 20:24:21 | pedigreed | 2 | 121436 | 3 | 14.516 | 8365.7 |
| 190 | 2024-08-24 16:02:04 | pedigreed | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 189 | 2024-07-19 06:15:46 | pedigreed | 1 | 81242 | 3 | 7.033 | 11551.5 |
| 188 | 2024-07-18 16:05:34 | pedigreed | 3 | 148641 | 13 | 29.576 | 5025.7 |
| 187 | 2024-07-18 02:19:43 | pedigreed | 4 | 165329 | 177 | 60.156 | 2748.3 |
| 186 | 2024-07-18 02:19:42 | pedigreed | 3 | 148641 | 13 | 41.723 | 3562.6 |
| 185 | 2024-07-17 06:25:25 | pedigreed | 4 | 165329 | 177 | 68.770 | 2404.1 |
| 184 | 2024-07-17 06:25:36 | pedigreed | 3 | 148641 | 13 | 27.876 | 5332.2 |
| 183 | 2024-07-17 06:25:33 | pedigreed | 2 | 121436 | 3 | 16.563 | 7331.8 |
| 182 | 2024-07-17 06:24:08 | pedigreed | 1 | 81242 | 3 | 4.920 | 16512.6 |
| 181 | 2024-07-16 14:15:13 | pedigreed | 3 | 148641 | 13 | 28.770 | 5166.5 |
| 180 | 2024-07-16 14:14:59 | pedigreed | 3 | 148641 | 13 | 35.376 | 4201.7 |
| 179 | 2024-07-16 14:15:09 | pedigreed | 2 | 121436 | 3 | 15.796 | 7687.8 |
| 178 | 2024-07-16 14:13:51 | pedigreed | 1 | 81242 | 3 | 5.686 | 14288.1 |
| 177 | 2024-07-11 20:43:29 | pedigreed | 3 | 148641 | 13 | 40.123 | 3704.6 |
| 176 | 2024-07-11 20:43:26 | pedigreed | 3 | 148641 | 13 | 40.250 | 3692.9 |
| 175 | 2024-07-11 20:43:37 | pedigreed | 2 | 121436 | 3 | 13.240 | 9171.9 |
| 174 | 2024-07-11 20:41:46 | pedigreed | 1 | 81242 | 3 | 2.390 | 33992.5 |
| 173 | 2024-06-25 00:51:56 | pedigreed | 2 | 121436 | 3 | 6.826 | 17790.2 |
| 172 | 2024-06-25 00:51:13 | pedigreed | 3 | 148641 | 13 | 36.690 | 4051.3 |
| 171 | 2024-06-25 00:51:09 | pedigreed | 1 | 81242 | 3 | 6.360 | 12773.9 |
| 170 | 2024-06-23 20:57:40 | pedigreed | 3 | 148641 | 13 | 36.643 | 4056.5 |
| 169 | 2024-06-23 20:09:13 | pedigreed | 3 | 148641 | 13 | 39.986 | 3717.3 |
| 168 | 2024-06-23 20:09:08 | pedigreed | 2 | 121436 | 3 | 25.736 | 4718.5 |
| 167 | 2024-06-07 13:29:44 | pedigreed | 3 | 148641 | 13 | 16.486 | 9016.2 |
| 166 | 2024-06-07 11:28:33 | pedigreed | 3 | 148641 | 13 | 39.690 | 3745.0 |
| 165 | 2024-06-07 11:28:21 | pedigreed | 2 | 121436 | 3 | 16.390 | 7409.2 |
| 164 | 2024-06-07 11:06:14 | pedigreed | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 163 | 2024-05-31 21:53:41 | pedigreed | 1 | 81242 | 3 | 2.623 | 30972.9 |
| 162 | 2024-05-16 17:05:19 | pedigreed | 3 | 148641 | 13 | 24.236 | 6133.1 |
| 161 | 2024-05-16 17:05:04 | pedigreed | 2 | 121436 | 3 | 8.720 | 13926.1 |
| 160 | 2024-05-15 23:08:19 | pedigreed | 1 | 81242 | 3 | 3.313 | 24522.2 |
| 159 | 2024-05-14 22:51:36 | pedigreed | 4 | 165329 | 177 | 28.863 | 5728.1 |
| 158 | 2024-05-14 16:58:47 | pedigreed | 4 | 165329 | 177 | 39.063 | 4232.4 |
| 157 | 2024-05-14 10:13:06 | pedigreed | 4 | 165329 | 177 | 49.173 | 3362.2 |
| 156 | 2024-05-14 10:13:07 | pedigreed | 3 | 148641 | 13 | 24.346 | 6105.4 |
| 155 | 2024-05-14 10:13:09 | pedigreed | 2 | 121436 | 3 | 9.953 | 12200.9 |
| 154 | 2024-05-14 07:46:45 | pedigreed | 1 | 81242 | 3 | 3.140 | 25873.2 |
| 153 | 2024-05-13 17:13:06 | pedigreed | 1 | 81242 | 3 | 4.063 | 19995.6 |
| 152 | 2024-05-13 09:10:06 | pedigreed | 1 | 81242 | 3 | 1.826 | 44491.8 |
| 151 | 2024-04-26 16:01:23 | pedigreed | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 150 | 2024-04-25 16:59:36 | pedigreed | 1 | 81242 | 3 | 1.796 | 45235.0 |
| 149 | 2024-04-25 09:35:52 | pedigreed | 3 | 148641 | 13 | 18.843 | 7888.4 |
| 148 | 2024-04-25 09:35:52 | pedigreed | 2 | 121436 | 3 | 9.280 | 13085.8 |
| 147 | 2024-04-25 09:19:46 | pedigreed | 1 | 81242 | 3 | 1.470 | 55266.7 |