History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piscivorous"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 205 | 2024-03-31 11:05:35 | piscivorous | 4 | 148819 | 18 | 36.033 | 4130.1 |
| 204 | 2024-03-31 11:05:35 | piscivorous | 3 | 121633 | 3 | 18.876 | 6443.8 |
| 203 | 2024-03-31 11:05:33 | piscivorous | 2 | 86808 | 2 | 5.186 | 16738.9 |
| 202 | 2024-03-30 17:48:28 | piscivorous | 1 | 49908 | 1 | 2.033 | 24548.9 |
| 201 | 2024-03-30 17:46:09 | piscivorous | 4 | 148819 | 18 | 22.266 | 6683.7 |
| 200 | 2024-03-30 17:46:09 | piscivorous | 3 | 121633 | 3 | 19.000 | 6401.7 |
| 199 | 2024-03-30 17:46:11 | piscivorous | 2 | 86808 | 2 | 7.780 | 11157.8 |
| 198 | 2024-03-30 17:45:48 | piscivorous | 1 | 49908 | 1 | 1.953 | 25554.5 |
| 197 | 2024-03-22 19:10:32 | piscivorous | 5 | 164607 | 105 | 49.223 | 3344.1 |
| 196 | 2024-03-22 01:37:06 | piscivorous | 5 | 164607 | 105 | 39.113 | 4208.5 |
| 195 | 2024-03-06 20:37:15 | piscivorous | 3 | 121633 | 3 | 8.346 | 14573.8 |
| 194 | 2024-03-06 20:35:09 | piscivorous | 4 | 148819 | 18 | 22.893 | 6500.6 |
| 193 | 2024-03-03 07:34:00 | piscivorous | 5 | 164607 | 105 | 30.783 | 5347.3 |
| 192 | 2024-03-03 07:16:00 | piscivorous | 4 | 148819 | 18 | 26.643 | 5585.7 |
| 191 | 2024-03-03 07:16:04 | piscivorous | 3 | 121633 | 3 | 6.546 | 18581.3 |
| 190 | 2024-03-03 07:16:01 | piscivorous | 2 | 86808 | 2 | 8.576 | 10122.2 |
| 189 | 2024-03-03 05:47:58 | piscivorous | 1 | 49908 | 1 | 0.733 | 68087.3 |
| 188 | 2024-02-26 12:31:12 | piscivorous | 4 | 148819 | 18 | 22.143 | 6720.8 |
| 187 | 2024-02-22 17:02:29 | piscivorous | 5 | 164607 | 105 | 22.160 | 7428.1 |
| 186 | 2024-02-21 08:31:20 | piscivorous | 1 | 49908 | 1 | 1.936 | 25778.9 |
| 185 | 2024-02-21 05:25:21 | piscivorous | 5 | 164607 | 105 | 23.173 | 7103.4 |
| 184 | 2024-02-21 00:23:02 | piscivorous | 5 | 164607 | 105 | 16.236 | 10138.4 |
| 183 | 2024-02-20 03:33:53 | piscivorous | 5 | 164607 | 105 | 45.296 | 3634.0 |
| 182 | 2024-02-20 03:33:50 | piscivorous | 4 | 148819 | 18 | 14.533 | 10240.1 |
| 181 | 2024-02-20 03:33:51 | piscivorous | 3 | 121633 | 3 | 13.093 | 9289.9 |
| 180 | 2024-02-20 03:33:48 | piscivorous | 2 | 86808 | 2 | 2.750 | 31566.5 |
| 179 | 2024-02-19 16:58:36 | piscivorous | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 178 | 2024-02-19 01:40:01 | piscivorous | 1 | 49908 | 1 | 1.876 | 26603.4 |
| 177 | 2024-01-20 00:05:01 | piscivorous | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 176 | 2024-01-01 03:12:29 | piscivorous | 1 | 49908 | 1 | 0.826 | 60421.3 |
| 175 | 2023-12-19 09:01:48 | piscivorous | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 174 | 2023-11-16 20:27:47 | piscivorous | 1 | 49908 | 1 | 0.873 | 57168.4 |
| 173 | 2023-10-31 13:20:33 | piscivorous | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 172 | 2023-10-17 00:26:55 | piscivorous | 1 | 49908 | 1 | 0.936 | 53320.5 |
| 171 | 2023-09-03 12:35:21 | piscivorous | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 170 | 2023-06-21 18:44:18 | piscivorous | 1 | 49908 | 1 | 0.780 | 63984.6 |
| 169 | 2023-01-28 18:40:50 | piscivorous | 1 | 49908 | 1 | 0.830 | 60130.1 |
| 168 | 2023-01-16 02:35:19 | piscivorous | 1 | 49908 | 1 | 1.500 | 33272.0 |
| 167 | 2022-11-26 19:25:25 | piscivorous | 1 | 49908 | 1 | 0.750 | 66544.0 |
| 166 | 2022-07-25 02:40:32 | piscivorous | 1 | 49908 | 1 | 0.783 | 63739.5 |
| 165 | 2022-07-21 20:38:03 | piscivorous | 1 | 49908 | 1 | 0.750 | 66544.0 |
| 164 | 2022-01-31 02:29:05 | piscivorous | 1 | 49908 | 1 | 0.860 | 58032.6 |
| 163 | 2021-08-23 12:18:39 | piscivorous | 1 | 49908 | 1 | 0.766 | 65154.0 |
| 162 | 2021-04-25 07:43:26 | piscivorous | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 161 | 2020-12-31 08:44:43 | piscivorous | 1 | 49908 | 1 | 0.830 | 60130.1 |
| 160 | 2020-10-04 09:22:21 | piscivorous | 1 | 49908 | 1 | 0.750 | 66544.0 |
| 159 | 2020-09-12 17:48:29 | piscivorous | 1 | 49908 | 1 | 0.763 | 65410.2 |
| 158 | 2020-08-01 02:50:01 | piscivorous | 1 | 49908 | 1 | 0.813 | 61387.5 |
| 157 | 2020-05-07 10:50:55 | piscivorous | 1 | 49908 | 1 | 0.796 | 62698.5 |
| 156 | 2020-03-04 14:06:54 | piscivorous | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 155 | 2020-02-15 05:23:53 | piscivorous | 1 | 49908 | 1 | 0.953 | 52369.4 |
| 154 | 2020-02-14 11:58:41 | piscivorous | 1 | 49908 | 1 | 0.893 | 55888.0 |
| 153 | 2020-01-19 04:53:21 | piscivorous | 1 | 49908 | 1 | 1.906 | 26184.7 |
| 152 | 2020-01-15 10:51:01 | piscivorous | 1 | 49908 | 1 | 0.906 | 55086.1 |
| 151 | 2020-01-15 07:01:08 | piscivorous | 1 | 49908 | 1 | 0.950 | 52534.7 |
| 150 | 2019-12-19 20:17:00 | piscivorous | 1 | 49908 | 1 | 0.843 | 59202.8 |
| 149 | 2019-12-06 00:40:52 | piscivorous | 1 | 49908 | 1 | 0.763 | 65410.2 |
| 148 | 2018-05-05 21:13:29 | piscivorous | 1 | 49908 | 1 | 0.743 | 67170.9 |
| 147 | 2017-12-13 19:42:18 | piscivorous | 1 | 49908 | 1 | 1.500 | 33272.0 |
| 146 | 2017-08-13 07:38:36 | piscivorous | 1 | 49908 | 1 | 0.993 | 50259.8 |
| 145 | 2017-02-18 17:44:03 | piscivorous | 1 | 49908 | 1 | 1.000 | 49908.0 |
| 144 | 2016-12-02 06:47:13 | piscivorous | 1 | 49908 | 1 | 1.276 | 39112.9 |
| 143 | 2016-11-20 22:11:08 | piscivorous | 2 | 86808 | 2 | 3.440 | 25234.9 |
| 142 | 2016-11-13 18:48:46 | piscivorous | 1 | 49908 | 1 | 1.003 | 49758.7 |
| 141 | 2016-10-21 16:13:22 | piscivorous | 1 | 49908 | 1 | 1.056 | 47261.4 |
| 140 | 2016-09-25 16:42:49 | piscivorous | 1 | 49908 | 1 | 1.070 | 46643.0 |
| 139 | 2016-07-04 03:10:21 | piscivorous | 5 | 164607 | 105 | 89.816 | 1832.7 |
| 138 | 2016-07-03 19:54:01 | piscivorous | 4 | 148819 | 18 | 14.873 | 10006.0 |
| 137 | 2016-07-02 17:04:07 | piscivorous | 2 | 86808 | 2 | 4.133 | 21003.6 |
| 136 | 2016-07-02 08:24:52 | piscivorous | 3 | 121633 | 3 | 9.003 | 13510.3 |
| 135 | 2016-04-23 10:43:06 | piscivorous | 1 | 49908 | 1 | 3.600 | 13863.3 |
| 134 | 2016-04-15 07:02:22 | piscivorous | 1 | 49908 | 1 | 2.470 | 20205.7 |
| 133 | 2016-04-12 15:04:00 | piscivorous | 1 | 49908 | 1 | 2.350 | 21237.4 |
| 132 | 2016-04-09 17:44:10 | piscivorous | 1 | 49908 | 1 | 0.866 | 57630.5 |
| 131 | 2016-04-03 12:14:12 | piscivorous | 1 | 49908 | 1 | 0.890 | 56076.4 |
| 130 | 2016-03-07 12:06:27 | piscivorous | 1 | 49908 | 1 | 0.866 | 57630.5 |
| 129 | 2016-01-04 10:27:24 | piscivorous | 1 | 49908 | 1 | 0.866 | 57630.5 |
| 128 | 2015-12-25 10:00:41 | piscivorous | 1 | 49908 | 1 | 0.903 | 55269.1 |
| 127 | 2015-11-28 12:33:09 | piscivorous | 1 | 49908 | 1 | 0.866 | 57630.5 |
| 126 | 2015-11-01 04:47:54 | piscivorous | 1 | 49908 | 1 | 0.846 | 58992.9 |
| 125 | 2015-09-26 11:22:22 | piscivorous | 5 | 164607 | 105 | 18.980 | 8672.7 |
| 124 | 2015-09-26 11:15:25 | piscivorous | 2 | 86808 | 2 | 2.486 | 34918.7 |
| 123 | 2015-09-26 11:08:35 | piscivorous | 4 | 148819 | 18 | 12.930 | 11509.6 |
| 122 | 2015-09-26 11:07:13 | piscivorous | 3 | 121633 | 3 | 10.676 | 11393.1 |
| 121 | 2015-09-16 11:00:45 | piscivorous | 5 | 164607 | 105 | 21.513 | 7651.5 |
| 120 | 2015-08-27 10:37:49 | piscivorous | 1 | 49908 | 1 | 0.880 | 56713.6 |
| 119 | 2015-03-13 05:29:33 | piscivorous | 5 | 164607 | 105 | 17.923 | 9184.1 |
| 118 | 2015-03-10 16:54:57 | piscivorous | 5 | 164607 | 105 | 19.196 | 8575.1 |
| 117 | 2015-03-10 16:54:45 | piscivorous | 2 | 86808 | 2 | 3.723 | 23316.7 |
| 116 | 2015-03-10 16:53:31 | piscivorous | 3 | 121633 | 3 | 7.663 | 15872.8 |
| 115 | 2015-03-10 16:50:56 | piscivorous | 1 | 49908 | 1 | 1.980 | 25206.1 |
| 114 | 2015-02-25 23:43:15 | piscivorous | 4 | 148819 | 18 | 16.303 | 9128.3 |
| 113 | 2015-01-25 04:32:00 | piscivorous | 4 | 148819 | 18 | 15.153 | 9821.1 |
| 112 | 2015-01-03 08:49:43 | piscivorous | 4 | 148819 | 18 | 11.583 | 12848.1 |
| 111 | 2014-12-11 00:28:30 | piscivorous | 1 | 49908 | 1 | 1.216 | 41042.8 |
| 110 | 2014-11-16 05:04:46 | piscivorous | 2 | 86808 | 2 | 4.120 | 21069.9 |
| 109 | 2014-11-16 05:04:31 | piscivorous | 3 | 121633 | 3 | 14.056 | 8653.5 |
| 108 | 2014-11-16 04:55:59 | piscivorous | 3 | 121633 | 3 | 6.576 | 18496.5 |
| 107 | 2014-11-16 04:55:45 | piscivorous | 4 | 148819 | 18 | 12.596 | 11814.8 |
| 106 | 2014-11-16 04:55:29 | piscivorous | 2 | 86808 | 2 | 3.280 | 26465.9 |