History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fishable"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 207 | 2024-04-09 12:21:22 | fishable | 3 | 146162 | 160 | 26.140 | 5591.5 |
| 206 | 2024-04-07 22:48:32 | fishable | 3 | 146162 | 160 | 14.923 | 9794.4 |
| 205 | 2024-04-07 10:06:40 | fishable | 3 | 146162 | 160 | 24.940 | 5860.5 |
| 204 | 2024-04-07 10:04:43 | fishable | 1 | 82945 | 1 | 5.076 | 16340.6 |
| 203 | 2024-04-05 09:32:45 | fishable | 1 | 82945 | 1 | 2.450 | 33855.1 |
| 202 | 2024-04-05 04:05:33 | fishable | 3 | 146162 | 160 | 8.486 | 17223.9 |
| 201 | 2024-04-01 04:17:10 | fishable | 3 | 146162 | 160 | 8.920 | 16385.9 |
| 200 | 2024-04-01 04:17:09 | fishable | 2 | 121059 | 20 | 4.013 | 30166.7 |
| 199 | 2024-04-01 04:17:01 | fishable | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 198 | 2024-04-01 04:16:51 | fishable | 3 | 146162 | 160 | 11.296 | 12939.3 |
| 197 | 2024-04-01 04:16:51 | fishable | 2 | 121059 | 20 | 3.983 | 30393.9 |
| 196 | 2024-04-01 04:16:43 | fishable | 1 | 82945 | 1 | 2.940 | 28212.6 |
| 195 | 2024-03-30 03:57:49 | fishable | 1 | 82945 | 1 | 4.780 | 17352.5 |
| 194 | 2024-03-29 21:46:17 | fishable | 1 | 82945 | 1 | 4.000 | 20736.3 |
| 193 | 2024-03-06 05:25:23 | fishable | 1 | 82945 | 1 | 3.250 | 25521.5 |
| 192 | 2024-01-21 23:18:06 | fishable | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 191 | 2024-01-13 10:46:09 | fishable | 1 | 82945 | 1 | 1.263 | 65673.0 |
| 190 | 2023-12-17 04:38:38 | fishable | 1 | 82945 | 1 | 1.376 | 60279.8 |
| 189 | 2023-11-21 00:59:43 | fishable | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 188 | 2023-11-12 06:36:10 | fishable | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 187 | 2023-11-06 10:41:30 | fishable | 1 | 82945 | 1 | 1.440 | 57600.7 |
| 186 | 2023-09-21 07:12:04 | fishable | 1 | 82945 | 1 | 1.263 | 65673.0 |
| 185 | 2023-08-28 06:41:57 | fishable | 1 | 82945 | 1 | 1.283 | 64649.3 |
| 184 | 2023-06-04 04:28:21 | fishable | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 183 | 2023-06-01 20:29:14 | fishable | 1 | 82945 | 1 | 1.216 | 68211.3 |
| 182 | 2023-03-23 21:13:23 | fishable | 1 | 82945 | 1 | 1.220 | 67987.7 |
| 181 | 2023-02-19 07:30:39 | fishable | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 180 | 2023-01-09 22:56:11 | fishable | 1 | 82945 | 1 | 1.236 | 67107.6 |
| 179 | 2022-11-02 05:21:47 | fishable | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 178 | 2022-10-10 21:45:21 | fishable | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 177 | 2022-09-03 13:54:38 | fishable | 2 | 121059 | 20 | 3.030 | 39953.5 |
| 176 | 2022-09-01 00:26:32 | fishable | 2 | 121059 | 20 | 3.263 | 37100.5 |
| 175 | 2022-07-16 04:04:32 | fishable | 1 | 82945 | 1 | 1.236 | 67107.6 |
| 174 | 2022-07-11 12:26:59 | fishable | 1 | 82945 | 1 | 1.376 | 60279.8 |
| 173 | 2022-07-01 04:15:58 | fishable | 2 | 121059 | 20 | 5.343 | 22657.5 |
| 172 | 2022-06-02 03:08:26 | fishable | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 171 | 2022-05-28 11:13:38 | fishable | 1 | 82945 | 1 | 1.236 | 67107.6 |
| 170 | 2022-04-25 00:21:25 | fishable | 1 | 82945 | 1 | 1.280 | 64800.8 |
| 169 | 2022-04-01 16:01:45 | fishable | 1 | 82945 | 1 | 1.233 | 67270.9 |
| 168 | 2022-03-06 02:06:19 | fishable | 1 | 82945 | 1 | 2.873 | 28870.5 |
| 167 | 2022-02-26 23:16:55 | fishable | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 166 | 2021-12-21 06:46:21 | fishable | 1 | 82945 | 1 | 1.673 | 49578.6 |
| 165 | 2021-12-15 03:27:34 | fishable | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 164 | 2021-09-20 12:29:19 | fishable | 1 | 82945 | 1 | 1.563 | 53067.8 |
| 163 | 2021-06-17 09:17:16 | fishable | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 162 | 2021-06-13 21:40:32 | fishable | 1 | 82945 | 1 | 1.376 | 60279.8 |
| 161 | 2021-03-11 01:41:07 | fishable | 1 | 82945 | 1 | 1.373 | 60411.5 |
| 160 | 2020-12-03 17:00:47 | fishable | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 159 | 2020-11-19 18:13:19 | fishable | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 158 | 2020-09-01 08:29:34 | fishable | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 157 | 2020-05-30 15:28:54 | fishable | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 156 | 2020-03-22 01:18:18 | fishable | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 155 | 2020-02-29 14:11:28 | fishable | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 154 | 2020-02-27 08:06:57 | fishable | 1 | 82945 | 1 | 1.610 | 51518.6 |
| 153 | 2020-02-23 11:28:24 | fishable | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 152 | 2020-02-14 22:44:42 | fishable | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 151 | 2020-02-12 18:49:16 | fishable | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 150 | 2020-02-03 23:25:35 | fishable | 1 | 82945 | 1 | 1.750 | 47397.1 |
| 149 | 2020-02-03 21:53:40 | fishable | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 148 | 2020-02-03 14:47:30 | fishable | 1 | 82945 | 1 | 3.673 | 22582.4 |
| 147 | 2020-01-23 08:04:22 | fishable | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 146 | 2020-01-22 18:27:01 | fishable | 1 | 82945 | 1 | 4.970 | 16689.1 |
| 145 | 2020-01-17 12:03:44 | fishable | 3 | 146162 | 160 | 8.700 | 16800.2 |
| 144 | 2020-01-17 12:03:43 | fishable | 2 | 121059 | 20 | 8.483 | 14270.8 |
| 143 | 2020-01-17 05:47:50 | fishable | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 142 | 2020-01-11 13:35:35 | fishable | 1 | 82945 | 1 | 3.110 | 26670.4 |
| 141 | 2020-01-03 02:03:58 | fishable | 1 | 82945 | 1 | 1.626 | 51011.7 |
| 140 | 2020-01-01 08:27:03 | fishable | 1 | 82945 | 1 | 1.563 | 53067.8 |
| 139 | 2019-12-31 17:02:23 | fishable | 1 | 82945 | 1 | 1.580 | 52496.8 |
| 138 | 2019-11-25 10:06:20 | fishable | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 137 | 2019-11-21 18:07:35 | fishable | 3 | 146162 | 160 | 6.640 | 22012.3 |
| 136 | 2019-08-26 16:38:21 | fishable | 1 | 82945 | 1 | 1.190 | 69701.7 |
| 135 | 2019-06-10 14:55:35 | fishable | 1 | 82945 | 1 | 1.256 | 66039.0 |
| 134 | 2019-06-05 00:37:10 | fishable | 1 | 82945 | 1 | 1.246 | 66569.0 |
| 133 | 2019-05-27 00:45:47 | fishable | 1 | 82945 | 1 | 1.400 | 59246.4 |
| 132 | 2019-02-20 21:12:38 | fishable | 1 | 82945 | 1 | 1.506 | 55076.4 |
| 131 | 2019-02-20 12:38:47 | fishable | 1 | 82945 | 1 | 1.230 | 67435.0 |
| 130 | 2019-02-13 19:40:59 | fishable | 1 | 82945 | 1 | 1.410 | 58826.2 |
| 129 | 2019-01-29 01:52:27 | fishable | 1 | 82945 | 1 | 1.396 | 59416.2 |
| 128 | 2018-11-24 17:25:13 | fishable | 1 | 82945 | 1 | 1.203 | 68948.5 |
| 127 | 2018-11-16 07:31:21 | fishable | 1 | 82945 | 1 | 1.396 | 59416.2 |
| 126 | 2018-09-20 07:27:57 | fishable | 1 | 82945 | 1 | 1.200 | 69120.8 |
| 125 | 2018-09-16 14:44:29 | fishable | 1 | 82945 | 1 | 1.223 | 67820.9 |
| 124 | 2018-08-15 11:27:56 | fishable | 1 | 82945 | 1 | 1.673 | 49578.6 |
| 123 | 2018-07-19 07:19:04 | fishable | 1 | 82945 | 1 | 1.230 | 67435.0 |
| 122 | 2018-07-15 19:50:26 | fishable | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 121 | 2018-07-15 05:09:09 | fishable | 3 | 146162 | 160 | 7.336 | 19923.9 |
| 120 | 2018-06-28 11:41:59 | fishable | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 119 | 2018-06-27 00:33:28 | fishable | 1 | 82945 | 1 | 1.556 | 53306.6 |
| 118 | 2018-06-27 00:06:21 | fishable | 1 | 82945 | 1 | 1.626 | 51011.7 |
| 117 | 2018-06-26 15:17:57 | fishable | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 116 | 2018-06-20 00:16:10 | fishable | 1 | 82945 | 1 | 1.456 | 56967.7 |
| 115 | 2018-06-19 20:02:15 | fishable | 1 | 82945 | 1 | 1.270 | 65311.0 |
| 114 | 2018-06-16 03:14:38 | fishable | 1 | 82945 | 1 | 1.413 | 58701.3 |
| 113 | 2018-05-13 19:29:24 | fishable | 1 | 82945 | 1 | 1.463 | 56695.1 |
| 112 | 2018-03-30 09:00:09 | fishable | 1 | 82945 | 1 | 4.010 | 20684.5 |
| 111 | 2017-12-16 22:17:30 | fishable | 1 | 82945 | 1 | 1.700 | 48791.2 |
| 110 | 2017-12-04 04:13:33 | fishable | 1 | 82945 | 1 | 2.143 | 38705.1 |
| 109 | 2017-12-04 04:08:11 | fishable | 1 | 82945 | 1 | 2.100 | 39497.6 |
| 108 | 2017-12-02 00:36:42 | fishable | 1 | 82945 | 1 | 2.370 | 34997.9 |