History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trollopy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 196 | 2024-04-19 17:08:35 | trollopy | 1 | 82945 | 3 | 4.373 | 18967.5 |
| 195 | 2024-04-14 05:54:09 | trollopy | 2 | 121059 | 6 | 8.843 | 13689.8 |
| 194 | 2024-04-14 05:54:02 | trollopy | 1 | 82945 | 3 | 2.313 | 35860.4 |
| 193 | 2024-04-10 04:38:04 | trollopy | 3 | 146162 | 41 | 12.470 | 11721.1 |
| 192 | 2024-04-08 09:14:30 | trollopy | 1 | 82945 | 3 | 3.283 | 25265.0 |
| 191 | 2024-04-07 09:01:02 | trollopy | 4 | 161609 | 293 | 57.363 | 2817.3 |
| 190 | 2024-04-07 09:00:38 | trollopy | 3 | 146162 | 41 | 33.000 | 4429.2 |
| 189 | 2024-04-06 14:28:44 | trollopy | 4 | 161609 | 293 | 26.296 | 6145.8 |
| 188 | 2024-04-05 05:38:35 | trollopy | 3 | 146162 | 41 | 10.766 | 13576.3 |
| 187 | 2024-04-04 19:45:55 | trollopy | 4 | 161609 | 293 | 33.550 | 4817.0 |
| 186 | 2024-04-04 12:23:15 | trollopy | 1 | 82945 | 3 | 3.703 | 22399.4 |
| 185 | 2024-04-04 12:21:04 | trollopy | 4 | 161609 | 293 | 21.906 | 7377.4 |
| 184 | 2024-04-04 12:21:06 | trollopy | 3 | 146162 | 41 | 16.470 | 8874.4 |
| 183 | 2024-04-04 12:20:54 | trollopy | 3 | 146162 | 41 | 18.063 | 8091.8 |
| 182 | 2024-04-04 12:21:07 | trollopy | 2 | 121059 | 6 | 4.593 | 26357.3 |
| 181 | 2024-04-04 12:20:55 | trollopy | 4 | 161609 | 293 | 15.313 | 10553.7 |
| 180 | 2024-04-04 12:21:00 | trollopy | 1 | 82945 | 3 | 1.593 | 52068.4 |
| 179 | 2024-04-04 12:20:54 | trollopy | 2 | 121059 | 6 | 4.720 | 25648.1 |
| 178 | 2024-03-31 00:39:29 | trollopy | 1 | 82945 | 3 | 3.343 | 24811.5 |
| 177 | 2024-03-12 23:44:32 | trollopy | 1 | 82945 | 3 | 1.700 | 48791.2 |
| 176 | 2024-03-05 21:50:49 | trollopy | 1 | 82945 | 3 | 3.063 | 27079.7 |
| 175 | 2024-03-04 20:49:48 | trollopy | 1 | 82945 | 3 | 2.110 | 39310.4 |
| 174 | 2024-03-04 03:48:52 | trollopy | 4 | 161609 | 293 | 14.173 | 11402.6 |
| 173 | 2024-03-04 03:48:54 | trollopy | 2 | 121059 | 6 | 7.860 | 15401.9 |
| 172 | 2024-03-04 03:48:40 | trollopy | 3 | 146162 | 41 | 7.703 | 18974.7 |
| 171 | 2024-03-03 15:28:58 | trollopy | 3 | 146162 | 41 | 17.613 | 8298.5 |
| 170 | 2024-03-02 12:17:41 | trollopy | 2 | 121059 | 6 | 7.813 | 15494.6 |
| 169 | 2024-03-02 12:17:18 | trollopy | 3 | 146162 | 41 | 9.313 | 15694.4 |
| 168 | 2024-03-01 08:39:26 | trollopy | 4 | 161609 | 293 | 12.876 | 12551.2 |
| 167 | 2024-02-29 02:31:54 | trollopy | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 166 | 2024-02-27 14:36:09 | trollopy | 2 | 121059 | 6 | 5.376 | 22518.4 |
| 165 | 2024-02-27 14:35:56 | trollopy | 3 | 146162 | 41 | 7.720 | 18932.9 |
| 164 | 2024-02-27 05:31:04 | trollopy | 4 | 161609 | 293 | 14.893 | 10851.3 |
| 163 | 2024-02-26 13:22:12 | trollopy | 1 | 82945 | 3 | 1.546 | 53651.4 |
| 162 | 2024-02-26 13:17:14 | trollopy | 4 | 161609 | 293 | 14.203 | 11378.5 |
| 161 | 2024-02-26 13:17:17 | trollopy | 3 | 146162 | 41 | 8.250 | 17716.6 |
| 160 | 2024-02-26 13:17:15 | trollopy | 2 | 121059 | 6 | 6.123 | 19771.2 |
| 159 | 2024-02-10 01:36:20 | trollopy | 1 | 82945 | 3 | 1.780 | 46598.3 |
| 158 | 2024-01-31 18:00:44 | trollopy | 1 | 82945 | 3 | 2.516 | 32967.0 |
| 157 | 2023-12-01 10:10:37 | trollopy | 1 | 82945 | 3 | 1.500 | 55296.7 |
| 156 | 2023-11-29 09:24:31 | trollopy | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 155 | 2023-11-19 15:14:58 | trollopy | 1 | 82945 | 3 | 1.233 | 67270.9 |
| 154 | 2023-11-02 04:14:25 | trollopy | 1 | 82945 | 3 | 2.436 | 34049.7 |
| 153 | 2023-10-16 15:35:45 | trollopy | 1 | 82945 | 3 | 1.343 | 61761.0 |
| 152 | 2023-09-14 03:39:28 | trollopy | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 151 | 2023-09-13 16:32:22 | trollopy | 1 | 82945 | 3 | 1.293 | 64149.3 |
| 150 | 2023-06-24 15:51:50 | trollopy | 1 | 82945 | 3 | 1.670 | 49667.7 |
| 149 | 2023-04-06 04:50:03 | trollopy | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 148 | 2023-01-23 00:35:38 | trollopy | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 147 | 2022-11-20 11:36:41 | trollopy | 1 | 82945 | 3 | 1.263 | 65673.0 |
| 146 | 2022-07-11 07:29:23 | trollopy | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 145 | 2022-07-09 02:28:38 | trollopy | 1 | 82945 | 3 | 1.236 | 67107.6 |
| 144 | 2022-06-18 12:29:35 | trollopy | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 143 | 2022-06-17 10:25:35 | trollopy | 1 | 82945 | 3 | 1.376 | 60279.8 |
| 142 | 2022-06-13 07:55:34 | trollopy | 1 | 82945 | 3 | 1.373 | 60411.5 |
| 141 | 2022-06-10 04:56:29 | trollopy | 1 | 82945 | 3 | 1.283 | 64649.3 |
| 140 | 2021-02-17 21:43:31 | trollopy | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 139 | 2020-10-22 23:33:46 | trollopy | 1 | 82945 | 3 | 2.893 | 28670.9 |
| 138 | 2020-10-12 01:27:36 | trollopy | 1 | 82945 | 3 | 1.266 | 65517.4 |
| 137 | 2020-03-29 17:57:00 | trollopy | 1 | 82945 | 3 | 1.420 | 58412.0 |
| 136 | 2020-03-23 15:02:11 | trollopy | 1 | 82945 | 3 | 2.013 | 41204.7 |
| 135 | 2020-03-23 00:01:02 | trollopy | 1 | 82945 | 3 | 1.906 | 43517.8 |
| 134 | 2020-03-01 10:18:42 | trollopy | 1 | 82945 | 3 | 1.596 | 51970.6 |
| 133 | 2020-02-27 13:59:15 | trollopy | 1 | 82945 | 3 | 1.720 | 48223.8 |
| 132 | 2020-02-24 11:14:12 | trollopy | 1 | 82945 | 3 | 1.580 | 52496.8 |
| 131 | 2020-02-09 21:38:26 | trollopy | 1 | 82945 | 3 | 1.326 | 62552.8 |
| 130 | 2020-02-04 06:17:10 | trollopy | 1 | 82945 | 3 | 3.283 | 25265.0 |
| 129 | 2020-02-04 04:00:02 | trollopy | 1 | 82945 | 3 | 1.390 | 59672.7 |
| 128 | 2020-01-27 14:22:58 | trollopy | 1 | 82945 | 3 | 3.280 | 25288.1 |
| 127 | 2020-01-26 12:29:10 | trollopy | 1 | 82945 | 3 | 3.220 | 25759.3 |
| 126 | 2020-01-18 22:42:04 | trollopy | 1 | 82945 | 3 | 4.890 | 16962.2 |
| 125 | 2020-01-13 21:07:52 | trollopy | 1 | 82945 | 3 | 1.626 | 51011.7 |
| 124 | 2020-01-01 18:13:42 | trollopy | 1 | 82945 | 3 | 1.560 | 53169.9 |
| 123 | 2019-12-30 23:13:20 | trollopy | 1 | 82945 | 3 | 1.450 | 57203.4 |
| 122 | 2019-12-05 22:34:39 | trollopy | 1 | 82945 | 3 | 1.313 | 63172.1 |
| 121 | 2019-09-03 19:29:51 | trollopy | 1 | 82945 | 3 | 1.203 | 68948.5 |
| 120 | 2019-05-16 10:44:48 | trollopy | 1 | 82945 | 3 | 1.303 | 63656.9 |
| 119 | 2019-01-09 03:52:28 | trollopy | 1 | 82945 | 3 | 1.240 | 66891.1 |
| 118 | 2019-01-04 13:19:27 | trollopy | 1 | 82945 | 3 | 1.226 | 67655.0 |
| 117 | 2019-01-01 05:30:28 | trollopy | 1 | 82945 | 3 | 1.223 | 67820.9 |
| 116 | 2018-10-02 21:11:45 | trollopy | 1 | 82945 | 3 | 1.573 | 52730.5 |
| 115 | 2018-08-17 08:54:54 | trollopy | 1 | 82945 | 3 | 1.636 | 50699.9 |
| 114 | 2018-05-20 07:27:33 | trollopy | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 113 | 2018-05-20 07:09:42 | trollopy | 1 | 82945 | 3 | 1.416 | 58577.0 |
| 112 | 2018-05-18 00:48:40 | trollopy | 1 | 82945 | 3 | 1.280 | 64800.8 |
| 111 | 2018-05-10 07:12:44 | trollopy | 1 | 82945 | 3 | 1.220 | 67987.7 |
| 110 | 2018-05-02 06:01:27 | trollopy | 1 | 82945 | 3 | 1.286 | 64498.4 |
| 109 | 2018-04-21 16:17:30 | trollopy | 1 | 82945 | 3 | 1.260 | 65829.4 |
| 108 | 2017-11-08 14:07:38 | trollopy | 1 | 82945 | 3 | 1.920 | 43200.5 |
| 107 | 2017-10-16 22:29:12 | trollopy | 1 | 82945 | 3 | 1.773 | 46782.3 |
| 106 | 2017-07-31 23:29:48 | trollopy | 1 | 82945 | 3 | 1.746 | 47505.7 |
| 105 | 2017-07-14 14:56:36 | trollopy | 1 | 82945 | 3 | 1.676 | 49489.9 |
| 104 | 2017-02-05 04:36:53 | trollopy | 1 | 82945 | 3 | 1.576 | 52630.1 |
| 103 | 2016-11-12 22:44:03 | trollopy | 1 | 82945 | 3 | 1.930 | 42976.7 |
| 102 | 2016-11-04 18:49:57 | trollopy | 1 | 82945 | 3 | 1.873 | 44284.6 |
| 101 | 2016-11-02 00:35:48 | trollopy | 1 | 82945 | 3 | 1.806 | 45927.5 |
| 100 | 2016-10-09 17:58:22 | trollopy | 1 | 82945 | 3 | 1.773 | 46782.3 |
| 99 | 2016-09-10 12:32:33 | trollopy | 1 | 82945 | 3 | 1.666 | 49786.9 |
| 98 | 2016-09-04 23:15:24 | trollopy | 1 | 82945 | 3 | 1.713 | 48420.9 |
| 97 | 2016-08-30 09:42:02 | trollopy | 1 | 82945 | 3 | 1.993 | 41618.2 |