History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"earthworms"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 209 | 2024-04-15 21:31:16 | earthworms | 1 | 67641 | 3 | 2.623 | 25787.6 |
| 208 | 2024-04-14 07:03:09 | earthworms | 1 | 67641 | 3 | 1.360 | 49736.0 |
| 207 | 2024-04-11 23:17:50 | earthworms | 1 | 67641 | 3 | 2.516 | 26884.3 |
| 206 | 2024-03-11 23:27:15 | earthworms | 1 | 67641 | 3 | 4.033 | 16771.9 |
| 205 | 2024-03-10 22:51:16 | earthworms | 1 | 67641 | 3 | 1.080 | 62630.6 |
| 204 | 2024-03-07 15:27:17 | earthworms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 203 | 2024-03-07 07:39:48 | earthworms | 3 | 140603 | 15 | 15.733 | 8936.8 |
| 202 | 2024-03-05 23:36:40 | earthworms | 1 | 67641 | 3 | 3.516 | 19238.1 |
| 201 | 2024-03-03 03:06:12 | earthworms | 3 | 140603 | 15 | 7.343 | 19147.9 |
| 200 | 2024-02-25 13:51:22 | earthworms | 2 | 108824 | 7 | 2.716 | 40067.7 |
| 199 | 2024-02-11 04:35:57 | earthworms | 4 | 161450 | 91 | 14.516 | 11122.2 |
| 198 | 2024-02-09 19:41:36 | earthworms | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 197 | 2024-02-01 14:08:01 | earthworms | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 196 | 2024-01-30 23:42:11 | earthworms | 1 | 67641 | 3 | 2.420 | 27950.8 |
| 195 | 2024-01-28 19:56:03 | earthworms | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 194 | 2024-01-27 10:05:13 | earthworms | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 193 | 2024-01-26 15:35:59 | earthworms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 192 | 2024-01-02 05:31:06 | earthworms | 4 | 161450 | 91 | 11.156 | 14472.0 |
| 191 | 2023-12-11 23:30:45 | earthworms | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 190 | 2023-11-25 09:07:44 | earthworms | 3 | 140603 | 15 | 6.346 | 22156.2 |
| 189 | 2023-11-24 15:28:43 | earthworms | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 188 | 2023-11-20 00:20:50 | earthworms | 2 | 108824 | 7 | 2.970 | 36641.1 |
| 187 | 2023-11-02 08:19:42 | earthworms | 1 | 67641 | 3 | 1.156 | 58513.0 |
| 186 | 2023-10-08 07:57:46 | earthworms | 4 | 161450 | 91 | 10.046 | 16071.1 |
| 185 | 2023-09-26 16:38:22 | earthworms | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 184 | 2023-08-25 02:28:40 | earthworms | 3 | 140603 | 15 | 5.546 | 25352.1 |
| 183 | 2023-08-24 15:04:06 | earthworms | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 182 | 2023-08-20 04:24:11 | earthworms | 2 | 108824 | 7 | 3.080 | 35332.5 |
| 181 | 2023-07-24 09:15:37 | earthworms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 180 | 2023-07-19 09:29:22 | earthworms | 4 | 161450 | 91 | 10.546 | 15309.1 |
| 179 | 2023-05-11 19:46:55 | earthworms | 3 | 140603 | 15 | 5.623 | 25005.0 |
| 178 | 2023-05-02 21:15:13 | earthworms | 2 | 108824 | 7 | 2.720 | 40008.8 |
| 177 | 2023-04-22 21:15:26 | earthworms | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 176 | 2023-04-08 00:25:45 | earthworms | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 175 | 2023-04-02 22:44:19 | earthworms | 4 | 161450 | 91 | 9.580 | 16852.8 |
| 174 | 2023-02-14 23:29:13 | earthworms | 3 | 140603 | 15 | 7.013 | 20048.9 |
| 173 | 2023-02-11 17:55:41 | earthworms | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 172 | 2023-02-07 15:46:02 | earthworms | 2 | 108824 | 7 | 2.686 | 40515.3 |
| 171 | 2022-12-29 17:28:17 | earthworms | 4 | 161450 | 91 | 9.750 | 16559.0 |
| 170 | 2022-12-09 03:17:10 | earthworms | 1 | 67641 | 3 | 1.000 | 67641.0 |
| 169 | 2022-11-26 07:19:23 | earthworms | 3 | 140603 | 15 | 5.750 | 24452.7 |
| 168 | 2022-11-26 05:48:28 | earthworms | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 167 | 2022-11-22 20:48:50 | earthworms | 1 | 67641 | 3 | 2.326 | 29080.4 |
| 166 | 2022-11-19 11:30:59 | earthworms | 2 | 108824 | 7 | 2.720 | 40008.8 |
| 165 | 2022-09-05 11:56:11 | earthworms | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 164 | 2022-09-01 08:03:58 | earthworms | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 163 | 2022-09-01 02:59:15 | earthworms | 4 | 161450 | 91 | 9.766 | 16531.8 |
| 162 | 2022-08-08 22:56:18 | earthworms | 1 | 67641 | 3 | 1.030 | 65670.9 |
| 161 | 2022-07-03 22:18:03 | earthworms | 3 | 140603 | 15 | 5.706 | 24641.3 |
| 160 | 2022-07-01 22:26:17 | earthworms | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 159 | 2022-06-22 23:03:39 | earthworms | 2 | 108824 | 7 | 2.843 | 38277.9 |
| 158 | 2022-03-03 14:06:08 | earthworms | 1 | 67641 | 3 | 1.190 | 56841.2 |
| 157 | 2022-02-23 19:42:23 | earthworms | 2 | 108824 | 7 | 3.513 | 30977.5 |
| 156 | 2022-01-29 03:18:34 | earthworms | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 155 | 2021-12-31 01:11:14 | earthworms | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 154 | 2021-09-23 04:18:26 | earthworms | 1 | 67641 | 3 | 1.013 | 66773.0 |
| 153 | 2021-09-20 00:02:44 | earthworms | 1 | 67641 | 3 | 1.076 | 62863.4 |
| 152 | 2021-06-06 03:21:00 | earthworms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 151 | 2021-03-04 00:47:52 | earthworms | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 150 | 2020-11-09 06:53:30 | earthworms | 1 | 67641 | 3 | 1.093 | 61885.6 |
| 149 | 2020-08-05 08:59:40 | earthworms | 1 | 67641 | 3 | 1.016 | 66575.8 |
| 148 | 2020-07-21 18:31:06 | earthworms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 147 | 2020-04-13 16:08:22 | earthworms | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 146 | 2020-03-26 21:24:21 | earthworms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 145 | 2020-03-01 16:58:49 | earthworms | 1 | 67641 | 3 | 1.313 | 51516.4 |
| 144 | 2020-02-29 23:56:58 | earthworms | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 143 | 2020-02-07 13:26:24 | earthworms | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 142 | 2020-02-07 08:52:50 | earthworms | 1 | 67641 | 3 | 3.830 | 17660.8 |
| 141 | 2020-02-04 09:59:51 | earthworms | 1 | 67641 | 3 | 1.170 | 57812.8 |
| 140 | 2020-02-04 06:22:23 | earthworms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 139 | 2020-01-19 01:57:08 | earthworms | 1 | 67641 | 3 | 1.326 | 51011.3 |
| 138 | 2020-01-17 13:39:19 | earthworms | 1 | 67641 | 3 | 4.280 | 15804.0 |
| 137 | 2020-01-17 12:17:39 | earthworms | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 136 | 2020-01-10 15:18:07 | earthworms | 1 | 67641 | 3 | 1.140 | 59334.2 |
| 135 | 2020-01-01 17:39:56 | earthworms | 1 | 67641 | 3 | 1.420 | 47634.5 |
| 134 | 2019-12-29 05:44:25 | earthworms | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 133 | 2019-10-02 19:49:04 | earthworms | 1 | 67641 | 3 | 1.420 | 47634.5 |
| 132 | 2019-07-11 01:39:25 | earthworms | 1 | 67641 | 3 | 0.966 | 70021.7 |
| 131 | 2019-06-20 04:53:47 | earthworms | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 130 | 2019-02-26 14:38:24 | earthworms | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 129 | 2018-10-28 17:43:04 | earthworms | 1 | 67641 | 3 | 1.083 | 62457.1 |
| 128 | 2018-07-24 15:54:07 | earthworms | 1 | 67641 | 3 | 1.100 | 61491.8 |
| 127 | 2018-06-25 12:48:31 | earthworms | 1 | 67641 | 3 | 0.990 | 68324.2 |
| 126 | 2016-07-16 13:22:28 | earthworms | 5 | 173545 | 549 | 35.783 | 4849.9 |
| 125 | 2016-07-07 13:11:02 | earthworms | 4 | 161450 | 91 | 16.703 | 9665.9 |
| 124 | 2016-07-06 14:49:22 | earthworms | 3 | 140603 | 15 | 10.673 | 13173.7 |
| 123 | 2016-07-06 14:34:29 | earthworms | 2 | 108824 | 7 | 5.626 | 19343.1 |
| 122 | 2016-07-03 16:17:09 | earthworms | 4 | 161450 | 91 | 36.160 | 4464.9 |
| 121 | 2016-07-02 20:04:00 | earthworms | 1 | 67641 | 3 | 1.753 | 38585.9 |
| 120 | 2016-07-01 12:45:51 | earthworms | 4 | 161450 | 91 | 21.203 | 7614.5 |
| 119 | 2016-06-21 09:34:08 | earthworms | 1 | 67641 | 3 | 1.833 | 36901.8 |
| 118 | 2016-06-16 22:37:16 | earthworms | 1 | 67641 | 3 | 1.550 | 43639.4 |
| 117 | 2016-06-11 17:37:52 | earthworms | 1 | 67641 | 3 | 1.386 | 48803.0 |
| 116 | 2016-06-02 09:20:50 | earthworms | 4 | 161450 | 91 | 50.563 | 3193.0 |
| 115 | 2016-05-31 09:07:28 | earthworms | 4 | 161450 | 91 | 11.606 | 13910.9 |
| 114 | 2016-05-11 09:09:16 | earthworms | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 113 | 2016-04-25 21:20:00 | earthworms | 4 | 161450 | 91 | 13.953 | 11571.0 |
| 112 | 2016-04-22 13:14:56 | earthworms | 4 | 161450 | 91 | 47.660 | 3387.5 |
| 111 | 2016-04-12 02:42:46 | earthworms | 4 | 161450 | 91 | 40.330 | 4003.2 |
| 110 | 2016-04-10 17:12:40 | earthworms | 4 | 161450 | 91 | 26.866 | 6009.5 |