History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shtetls"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 207 | 2024-04-06 13:46:54 | shtetls | 1 | 69583 | 3 | 2.703 | 25742.9 |
| 206 | 2024-04-03 20:12:22 | shtetls | 1 | 69583 | 3 | 4.106 | 16946.7 |
| 205 | 2023-12-27 08:54:43 | shtetls | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 204 | 2023-12-25 00:44:31 | shtetls | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 203 | 2023-12-11 21:51:58 | shtetls | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 202 | 2023-12-01 05:41:07 | shtetls | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 201 | 2023-11-28 18:59:51 | shtetls | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 200 | 2023-10-16 22:24:24 | shtetls | 1 | 69583 | 3 | 1.346 | 51696.1 |
| 199 | 2023-09-29 09:26:12 | shtetls | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 198 | 2023-08-13 14:26:12 | shtetls | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 197 | 2023-05-16 07:54:15 | shtetls | 1 | 69583 | 3 | 1.126 | 61796.6 |
| 196 | 2023-05-11 09:35:56 | shtetls | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 195 | 2023-04-05 21:19:39 | shtetls | 1 | 69583 | 3 | 2.156 | 32274.1 |
| 194 | 2023-03-09 17:49:00 | shtetls | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 193 | 2023-01-02 04:49:17 | shtetls | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 192 | 2022-12-30 23:32:17 | shtetls | 1 | 69583 | 3 | 1.173 | 59320.5 |
| 191 | 2022-11-28 09:48:28 | shtetls | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 190 | 2022-11-25 18:24:13 | shtetls | 1 | 69583 | 3 | 1.236 | 56296.9 |
| 189 | 2021-04-29 14:23:37 | shtetls | 2 | 107671 | 12 | 2.813 | 38276.2 |
| 188 | 2021-02-02 16:31:08 | shtetls | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 187 | 2021-01-30 11:40:46 | shtetls | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 186 | 2021-01-12 20:56:04 | shtetls | 2 | 107671 | 12 | 2.830 | 38046.3 |
| 185 | 2021-01-09 18:56:06 | shtetls | 3 | 134027 | 198 | 5.860 | 22871.5 |
| 184 | 2021-01-06 22:17:34 | shtetls | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 183 | 2020-10-29 23:25:22 | shtetls | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 182 | 2020-10-25 13:02:04 | shtetls | 2 | 107671 | 12 | 2.796 | 38508.9 |
| 181 | 2020-10-22 02:42:56 | shtetls | 3 | 134027 | 198 | 6.063 | 22105.7 |
| 180 | 2020-10-09 11:00:25 | shtetls | 1 | 69583 | 3 | 1.153 | 60349.5 |
| 179 | 2020-09-26 13:02:41 | shtetls | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 178 | 2020-09-19 17:54:59 | shtetls | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 177 | 2020-09-16 17:38:48 | shtetls | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 176 | 2020-09-06 09:26:48 | shtetls | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 175 | 2020-07-21 14:03:38 | shtetls | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 174 | 2020-07-18 03:56:23 | shtetls | 1 | 69583 | 3 | 1.156 | 60192.9 |
| 173 | 2020-04-18 06:47:35 | shtetls | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 172 | 2020-03-29 11:52:52 | shtetls | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 171 | 2020-03-29 05:27:50 | shtetls | 1 | 69583 | 3 | 1.296 | 53690.6 |
| 170 | 2020-03-21 01:17:22 | shtetls | 1 | 69583 | 3 | 1.140 | 61037.7 |
| 169 | 2020-03-13 04:32:58 | shtetls | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 168 | 2020-02-25 11:14:56 | shtetls | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 167 | 2020-02-25 07:22:44 | shtetls | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 166 | 2020-02-25 03:07:34 | shtetls | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 165 | 2020-02-17 19:32:54 | shtetls | 1 | 69583 | 3 | 2.670 | 26061.0 |
| 164 | 2020-02-15 06:45:45 | shtetls | 1 | 69583 | 3 | 1.406 | 49490.0 |
| 163 | 2020-02-07 00:08:47 | shtetls | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 162 | 2020-02-06 16:52:01 | shtetls | 1 | 69583 | 3 | 1.346 | 51696.1 |
| 161 | 2020-02-02 06:21:39 | shtetls | 3 | 134027 | 198 | 7.626 | 17575.0 |
| 160 | 2020-02-01 09:21:38 | shtetls | 3 | 134027 | 198 | 13.890 | 9649.2 |
| 159 | 2020-01-26 23:05:12 | shtetls | 1 | 69583 | 3 | 1.436 | 48456.1 |
| 158 | 2020-01-26 18:36:18 | shtetls | 1 | 69583 | 3 | 2.733 | 25460.3 |
| 157 | 2020-01-23 11:35:33 | shtetls | 3 | 134027 | 198 | 13.233 | 10128.2 |
| 156 | 2020-01-23 11:08:09 | shtetls | 3 | 134027 | 198 | 10.546 | 12708.8 |
| 155 | 2020-01-23 05:51:02 | shtetls | 3 | 134027 | 198 | 6.923 | 19359.7 |
| 154 | 2020-01-22 19:20:11 | shtetls | 1 | 69583 | 3 | 5.516 | 12614.8 |
| 153 | 2020-01-22 04:37:24 | shtetls | 1 | 69583 | 3 | 4.890 | 14229.7 |
| 152 | 2020-01-16 20:03:37 | shtetls | 3 | 134027 | 198 | 7.453 | 17983.0 |
| 151 | 2020-01-16 20:02:35 | shtetls | 2 | 107671 | 12 | 5.703 | 18879.7 |
| 150 | 2020-01-16 15:30:27 | shtetls | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 149 | 2020-01-08 00:18:51 | shtetls | 1 | 69583 | 3 | 1.843 | 37755.3 |
| 148 | 2020-01-06 18:15:01 | shtetls | 1 | 69583 | 3 | 2.953 | 23563.5 |
| 147 | 2019-12-30 02:03:31 | shtetls | 1 | 69583 | 3 | 1.250 | 55666.4 |
| 146 | 2019-12-30 01:39:10 | shtetls | 1 | 69583 | 3 | 1.343 | 51811.6 |
| 145 | 2019-12-12 12:25:08 | shtetls | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 144 | 2019-11-28 16:35:18 | shtetls | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 143 | 2019-08-27 01:40:25 | shtetls | 1 | 69583 | 3 | 1.210 | 57506.6 |
| 142 | 2019-08-26 09:43:01 | shtetls | 2 | 107671 | 12 | 3.010 | 35771.1 |
| 141 | 2019-08-07 15:04:21 | shtetls | 1 | 69583 | 3 | 1.133 | 61414.8 |
| 140 | 2019-06-12 20:25:21 | shtetls | 1 | 69583 | 3 | 1.113 | 62518.4 |
| 139 | 2019-06-03 13:41:56 | shtetls | 1 | 69583 | 3 | 1.210 | 57506.6 |
| 138 | 2019-05-29 02:08:48 | shtetls | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 137 | 2019-05-14 20:40:32 | shtetls | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 136 | 2019-03-14 22:06:45 | shtetls | 1 | 69583 | 3 | 1.083 | 64250.2 |
| 135 | 2019-02-24 22:11:06 | shtetls | 1 | 69583 | 3 | 1.193 | 58326.1 |
| 134 | 2019-02-21 09:53:30 | shtetls | 1 | 69583 | 3 | 1.196 | 58179.8 |
| 133 | 2019-02-16 08:52:06 | shtetls | 1 | 69583 | 3 | 1.076 | 64668.2 |
| 132 | 2019-02-16 08:43:44 | shtetls | 1 | 69583 | 3 | 1.380 | 50422.5 |
| 131 | 2019-02-11 07:31:17 | shtetls | 1 | 69583 | 3 | 1.070 | 65030.8 |
| 130 | 2019-01-21 05:27:10 | shtetls | 1 | 69583 | 3 | 1.053 | 66080.7 |
| 129 | 2019-01-18 05:27:40 | shtetls | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 128 | 2019-01-17 08:25:34 | shtetls | 1 | 69583 | 3 | 1.420 | 49002.1 |
| 127 | 2019-01-11 01:48:25 | shtetls | 1 | 69583 | 3 | 1.063 | 65459.1 |
| 126 | 2018-12-20 19:03:32 | shtetls | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 125 | 2018-12-15 08:28:43 | shtetls | 1 | 69583 | 3 | 1.160 | 59985.3 |
| 124 | 2018-11-24 14:46:54 | shtetls | 1 | 69583 | 3 | 1.200 | 57985.8 |
| 123 | 2018-11-13 01:46:12 | shtetls | 1 | 69583 | 3 | 1.340 | 51927.6 |
| 122 | 2018-11-11 03:12:14 | shtetls | 1 | 69583 | 3 | 1.040 | 66906.7 |
| 121 | 2018-10-02 22:33:58 | shtetls | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 120 | 2018-10-01 04:48:59 | shtetls | 1 | 69583 | 3 | 1.196 | 58179.8 |
| 119 | 2018-09-18 01:43:45 | shtetls | 1 | 69583 | 3 | 1.206 | 57697.3 |
| 118 | 2018-08-02 18:13:07 | shtetls | 1 | 69583 | 3 | 1.123 | 61961.7 |
| 117 | 2018-08-02 18:12:32 | shtetls | 1 | 69583 | 3 | 1.150 | 60507.0 |
| 116 | 2018-07-13 15:22:57 | shtetls | 1 | 69583 | 3 | 1.073 | 64849.0 |
| 115 | 2018-07-09 02:04:48 | shtetls | 1 | 69583 | 3 | 1.060 | 65644.3 |
| 114 | 2018-06-22 12:33:53 | shtetls | 1 | 69583 | 3 | 1.226 | 56756.1 |
| 113 | 2018-06-18 10:20:51 | shtetls | 1 | 69583 | 3 | 1.066 | 65274.9 |
| 112 | 2018-06-16 17:54:10 | shtetls | 1 | 69583 | 3 | 1.306 | 53279.5 |
| 111 | 2018-05-23 10:28:36 | shtetls | 1 | 69583 | 3 | 1.100 | 63257.3 |
| 110 | 2018-03-26 23:13:55 | shtetls | 1 | 69583 | 3 | 1.496 | 46512.7 |
| 109 | 2018-03-16 14:10:22 | shtetls | 1 | 69583 | 3 | 1.610 | 43219.3 |
| 108 | 2018-01-06 03:45:40 | shtetls | 1 | 69583 | 3 | 1.550 | 44892.3 |