History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"overfish"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 198 | 2024-05-22 08:41:31 | overfish | 1 | 82945 | 1 | 1.876 | 44213.8 |
| 197 | 2024-05-06 21:28:01 | overfish | 2 | 121059 | 13 | 6.000 | 20176.5 |
| 196 | 2024-05-06 21:28:05 | overfish | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 195 | 2024-05-03 19:17:01 | overfish | 3 | 146162 | 118 | 12.063 | 12116.6 |
| 194 | 2024-05-02 10:10:32 | overfish | 1 | 82945 | 1 | 1.530 | 54212.4 |
| 193 | 2024-05-02 10:09:36 | overfish | 1 | 82945 | 1 | 2.063 | 40206.0 |
| 192 | 2024-05-02 08:35:35 | overfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 191 | 2024-04-30 16:41:33 | overfish | 3 | 146162 | 118 | 7.580 | 19282.6 |
| 190 | 2024-04-25 16:58:21 | overfish | 3 | 146162 | 118 | 9.296 | 15723.1 |
| 189 | 2024-04-25 16:58:24 | overfish | 1 | 82945 | 1 | 2.453 | 33813.7 |
| 188 | 2024-04-25 16:58:16 | overfish | 2 | 121059 | 13 | 3.800 | 31857.6 |
| 187 | 2024-04-24 05:12:05 | overfish | 3 | 146162 | 118 | 10.453 | 13982.8 |
| 186 | 2024-04-24 05:12:05 | overfish | 2 | 121059 | 13 | 5.013 | 24149.0 |
| 185 | 2024-04-23 09:27:29 | overfish | 3 | 146162 | 118 | 29.033 | 5034.3 |
| 184 | 2024-04-23 09:02:21 | overfish | 2 | 121059 | 13 | 10.406 | 11633.6 |
| 183 | 2024-04-23 09:00:25 | overfish | 3 | 146162 | 118 | 9.203 | 15882.0 |
| 182 | 2024-04-23 09:00:28 | overfish | 2 | 121059 | 13 | 5.313 | 22785.4 |
| 181 | 2024-04-23 09:00:07 | overfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 180 | 2024-04-23 08:59:36 | overfish | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 179 | 2024-04-16 10:35:33 | overfish | 3 | 146162 | 118 | 19.720 | 7411.9 |
| 178 | 2024-04-16 10:35:34 | overfish | 2 | 121059 | 13 | 10.906 | 11100.2 |
| 177 | 2024-04-16 10:04:17 | overfish | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 176 | 2024-04-12 20:36:09 | overfish | 1 | 82945 | 1 | 3.530 | 23497.2 |
| 175 | 2024-04-10 21:25:04 | overfish | 1 | 82945 | 1 | 3.653 | 22706.0 |
| 174 | 2024-03-29 00:33:03 | overfish | 1 | 82945 | 1 | 1.860 | 44594.1 |
| 173 | 2024-03-28 22:23:54 | overfish | 3 | 146162 | 118 | 25.846 | 5655.1 |
| 172 | 2024-03-26 02:47:21 | overfish | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 171 | 2024-03-26 02:45:38 | overfish | 1 | 82945 | 1 | 2.263 | 36652.7 |
| 170 | 2024-03-26 02:44:37 | overfish | 3 | 146162 | 118 | 7.076 | 20656.0 |
| 169 | 2024-03-26 02:44:33 | overfish | 2 | 121059 | 13 | 3.560 | 34005.3 |
| 168 | 2024-03-07 21:33:00 | overfish | 3 | 146162 | 118 | 12.233 | 11948.2 |
| 167 | 2024-03-04 20:25:04 | overfish | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 166 | 2024-02-29 07:40:51 | overfish | 2 | 121059 | 13 | 3.686 | 32842.9 |
| 165 | 2024-02-29 07:40:36 | overfish | 3 | 146162 | 118 | 8.453 | 17291.1 |
| 164 | 2024-02-26 11:20:47 | overfish | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 163 | 2024-02-26 11:20:32 | overfish | 2 | 121059 | 13 | 3.110 | 38925.7 |
| 162 | 2024-02-26 03:47:03 | overfish | 3 | 146162 | 118 | 14.816 | 9865.1 |
| 161 | 2024-02-24 21:21:29 | overfish | 3 | 146162 | 118 | 6.513 | 22441.6 |
| 160 | 2024-02-24 21:21:27 | overfish | 2 | 121059 | 13 | 3.530 | 34294.3 |
| 159 | 2024-02-24 21:21:26 | overfish | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 158 | 2024-01-31 16:59:56 | overfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 157 | 2024-01-25 18:18:23 | overfish | 3 | 146162 | 118 | 6.906 | 21164.5 |
| 156 | 2024-01-25 18:18:00 | overfish | 2 | 121059 | 13 | 3.486 | 34727.2 |
| 155 | 2024-01-25 18:17:55 | overfish | 3 | 146162 | 118 | 8.063 | 18127.5 |
| 154 | 2023-12-28 03:44:16 | overfish | 1 | 82945 | 1 | 1.393 | 59544.1 |
| 153 | 2023-12-27 02:16:45 | overfish | 1 | 82945 | 1 | 1.440 | 57600.7 |
| 152 | 2023-12-25 22:59:00 | overfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 151 | 2023-10-17 02:12:14 | overfish | 1 | 82945 | 1 | 3.000 | 27648.3 |
| 150 | 2023-08-20 02:58:02 | overfish | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 149 | 2023-08-16 18:07:56 | overfish | 1 | 82945 | 1 | 1.376 | 60279.8 |
| 148 | 2023-08-14 14:45:32 | overfish | 1 | 82945 | 1 | 1.236 | 67107.6 |
| 147 | 2023-05-17 20:27:12 | overfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 146 | 2023-04-25 00:06:03 | overfish | 1 | 82945 | 1 | 1.233 | 67270.9 |
| 145 | 2023-03-16 00:07:18 | overfish | 1 | 82945 | 1 | 1.220 | 67987.7 |
| 144 | 2023-01-04 16:34:29 | overfish | 1 | 82945 | 1 | 1.216 | 68211.3 |
| 143 | 2022-12-25 00:52:38 | overfish | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 142 | 2022-10-01 22:06:35 | overfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 141 | 2022-08-14 12:43:52 | overfish | 1 | 82945 | 1 | 1.420 | 58412.0 |
| 140 | 2022-05-16 10:46:42 | overfish | 1 | 82945 | 1 | 1.733 | 47862.1 |
| 139 | 2022-04-10 05:11:53 | overfish | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 138 | 2021-12-16 09:45:00 | overfish | 1 | 82945 | 1 | 1.236 | 67107.6 |
| 137 | 2021-12-13 04:35:36 | overfish | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 136 | 2021-11-04 22:15:09 | overfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 135 | 2021-08-27 00:32:04 | overfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 134 | 2021-08-23 17:42:56 | overfish | 1 | 82945 | 1 | 1.420 | 58412.0 |
| 133 | 2021-05-16 08:02:45 | overfish | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 132 | 2021-05-12 23:12:07 | overfish | 1 | 82945 | 1 | 1.486 | 55817.6 |
| 131 | 2021-02-13 00:07:24 | overfish | 1 | 82945 | 1 | 2.580 | 32149.2 |
| 130 | 2021-02-09 04:02:35 | overfish | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 129 | 2021-02-03 21:01:09 | overfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 128 | 2020-12-20 17:09:54 | overfish | 1 | 82945 | 1 | 1.263 | 65673.0 |
| 127 | 2020-11-02 07:22:43 | overfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 126 | 2020-11-02 04:54:52 | overfish | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 125 | 2020-10-31 23:19:12 | overfish | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 124 | 2020-10-26 14:14:34 | overfish | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 123 | 2020-10-25 13:00:56 | overfish | 1 | 82945 | 1 | 1.373 | 60411.5 |
| 122 | 2020-10-12 10:35:54 | overfish | 1 | 82945 | 1 | 1.283 | 64649.3 |
| 121 | 2020-08-26 20:20:00 | overfish | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 120 | 2020-08-23 21:45:04 | overfish | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 119 | 2020-07-27 03:54:48 | overfish | 1 | 82945 | 1 | 1.686 | 49196.3 |
| 118 | 2020-05-25 07:03:08 | overfish | 1 | 82945 | 1 | 1.233 | 67270.9 |
| 117 | 2020-04-24 22:11:26 | overfish | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 116 | 2020-03-24 02:46:19 | overfish | 1 | 82945 | 1 | 1.550 | 53512.9 |
| 115 | 2020-02-26 09:11:01 | overfish | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 114 | 2020-02-26 07:38:55 | overfish | 1 | 82945 | 1 | 2.970 | 27927.6 |
| 113 | 2020-02-18 18:24:53 | overfish | 1 | 82945 | 1 | 2.000 | 41472.5 |
| 112 | 2020-02-16 18:57:01 | overfish | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 111 | 2020-02-13 01:56:40 | overfish | 1 | 82945 | 1 | 3.173 | 26140.9 |
| 110 | 2020-02-09 17:30:33 | overfish | 1 | 82945 | 1 | 1.610 | 51518.6 |
| 109 | 2020-02-09 12:47:34 | overfish | 1 | 82945 | 1 | 1.626 | 51011.7 |
| 108 | 2020-02-03 16:22:24 | overfish | 1 | 82945 | 1 | 1.606 | 51646.9 |
| 107 | 2020-01-23 20:26:47 | overfish | 1 | 82945 | 1 | 4.610 | 17992.4 |
| 106 | 2020-01-23 18:02:30 | overfish | 1 | 82945 | 1 | 3.110 | 26670.4 |
| 105 | 2020-01-23 16:21:47 | overfish | 1 | 82945 | 1 | 1.530 | 54212.4 |
| 104 | 2020-01-21 08:00:31 | overfish | 1 | 82945 | 1 | 1.233 | 67270.9 |
| 103 | 2020-01-15 23:35:33 | overfish | 1 | 82945 | 1 | 1.656 | 50087.6 |
| 102 | 2020-01-15 19:41:31 | overfish | 1 | 82945 | 1 | 1.263 | 65673.0 |
| 101 | 2020-01-02 00:59:39 | overfish | 1 | 82945 | 1 | 1.546 | 53651.4 |
| 100 | 2019-12-29 15:47:56 | overfish | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 99 | 2019-10-22 15:06:25 | overfish | 1 | 82945 | 1 | 1.376 | 60279.8 |