History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"chaffinch"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 174 | 2024-04-30 22:41:38 | chaffinch | 1 | 81242 | 1 | 1.550 | 52414.2 |
| 173 | 2024-04-16 05:15:48 | chaffinch | 3 | 148641 | 10 | 20.206 | 7356.3 |
| 172 | 2024-04-16 05:15:47 | chaffinch | 2 | 121436 | 4 | 8.626 | 14077.9 |
| 171 | 2024-04-16 04:49:22 | chaffinch | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 170 | 2024-04-13 21:26:36 | chaffinch | 4 | 165329 | 118 | 41.893 | 3946.5 |
| 169 | 2024-04-13 12:51:41 | chaffinch | 1 | 81242 | 1 | 1.626 | 49964.3 |
| 168 | 2024-04-12 21:52:49 | chaffinch | 1 | 81242 | 1 | 1.606 | 50586.6 |
| 167 | 2024-04-12 10:43:11 | chaffinch | 4 | 165329 | 118 | 32.766 | 5045.7 |
| 166 | 2024-04-12 10:43:04 | chaffinch | 3 | 148641 | 10 | 20.330 | 7311.4 |
| 165 | 2024-04-12 10:43:06 | chaffinch | 2 | 121436 | 4 | 13.610 | 8922.6 |
| 164 | 2024-04-12 10:42:16 | chaffinch | 1 | 81242 | 1 | 2.423 | 33529.5 |
| 163 | 2024-04-11 15:05:58 | chaffinch | 4 | 165329 | 118 | 43.286 | 3819.5 |
| 162 | 2024-04-11 15:06:10 | chaffinch | 2 | 121436 | 4 | 4.890 | 24833.5 |
| 161 | 2024-04-11 15:05:53 | chaffinch | 3 | 148641 | 10 | 14.956 | 9938.6 |
| 160 | 2024-04-11 14:06:27 | chaffinch | 1 | 81242 | 1 | 1.250 | 64993.6 |
| 159 | 2024-04-05 03:07:33 | chaffinch | 2 | 121436 | 4 | 4.030 | 30133.0 |
| 158 | 2024-03-30 18:55:17 | chaffinch | 1 | 81242 | 1 | 1.580 | 51419.0 |
| 157 | 2024-03-10 07:12:46 | chaffinch | 4 | 165329 | 118 | 27.470 | 6018.5 |
| 156 | 2024-03-08 16:09:07 | chaffinch | 3 | 148641 | 10 | 12.483 | 11907.5 |
| 155 | 2024-03-08 16:09:08 | chaffinch | 2 | 121436 | 4 | 8.580 | 14153.4 |
| 154 | 2024-03-08 12:12:21 | chaffinch | 1 | 81242 | 1 | 3.186 | 25499.7 |
| 153 | 2024-03-08 12:11:41 | chaffinch | 3 | 148641 | 10 | 27.236 | 5457.5 |
| 152 | 2024-03-08 12:11:40 | chaffinch | 4 | 165329 | 118 | 20.986 | 7878.1 |
| 151 | 2024-03-08 12:11:42 | chaffinch | 2 | 121436 | 4 | 6.860 | 17702.0 |
| 150 | 2024-03-08 12:11:27 | chaffinch | 1 | 81242 | 1 | 4.843 | 16775.1 |
| 149 | 2024-03-04 15:02:39 | chaffinch | 4 | 165329 | 118 | 32.986 | 5012.1 |
| 148 | 2024-03-03 11:50:52 | chaffinch | 4 | 165329 | 118 | 21.266 | 7774.3 |
| 147 | 2024-03-03 11:50:55 | chaffinch | 3 | 148641 | 10 | 8.936 | 16634.0 |
| 146 | 2024-03-03 11:50:52 | chaffinch | 2 | 121436 | 4 | 8.110 | 14973.6 |
| 145 | 2024-03-03 09:49:24 | chaffinch | 1 | 81242 | 1 | 1.440 | 56418.1 |
| 144 | 2024-02-29 21:24:56 | chaffinch | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 143 | 2024-02-29 11:05:26 | chaffinch | 3 | 148641 | 10 | 7.330 | 20278.4 |
| 142 | 2024-02-29 05:42:06 | chaffinch | 1 | 81242 | 1 | 1.500 | 54161.3 |
| 141 | 2024-02-05 09:07:19 | chaffinch | 1 | 81242 | 1 | 1.513 | 53696.0 |
| 140 | 2024-01-29 02:35:47 | chaffinch | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 139 | 2024-01-22 21:28:56 | chaffinch | 4 | 165329 | 118 | 13.593 | 12162.8 |
| 138 | 2023-12-30 03:32:51 | chaffinch | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 137 | 2023-12-07 11:40:39 | chaffinch | 2 | 121436 | 4 | 3.470 | 34996.0 |
| 136 | 2023-11-27 17:36:25 | chaffinch | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 135 | 2023-11-20 22:48:39 | chaffinch | 3 | 148641 | 10 | 7.046 | 21095.8 |
| 134 | 2023-11-19 04:49:08 | chaffinch | 4 | 165329 | 118 | 16.690 | 9905.9 |
| 133 | 2023-11-18 11:05:23 | chaffinch | 1 | 81242 | 1 | 1.453 | 55913.3 |
| 132 | 2023-11-11 00:56:22 | chaffinch | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 131 | 2023-11-03 12:41:20 | chaffinch | 4 | 165329 | 118 | 10.033 | 16478.5 |
| 130 | 2023-10-20 17:51:44 | chaffinch | 1 | 81242 | 1 | 1.346 | 60358.1 |
| 129 | 2023-09-26 05:52:26 | chaffinch | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 128 | 2023-09-23 03:01:17 | chaffinch | 1 | 81242 | 1 | 1.516 | 53589.7 |
| 127 | 2023-09-04 21:03:45 | chaffinch | 2 | 121436 | 4 | 3.733 | 32530.4 |
| 126 | 2023-08-22 07:14:00 | chaffinch | 3 | 148641 | 10 | 5.936 | 25040.6 |
| 125 | 2023-08-17 03:05:15 | chaffinch | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 124 | 2023-08-09 16:56:07 | chaffinch | 4 | 165329 | 118 | 11.593 | 14261.1 |
| 123 | 2023-05-20 21:02:40 | chaffinch | 2 | 121436 | 4 | 3.063 | 39646.1 |
| 122 | 2023-05-17 09:48:53 | chaffinch | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 121 | 2023-05-06 06:20:43 | chaffinch | 3 | 148641 | 10 | 5.890 | 25236.2 |
| 120 | 2023-04-28 21:44:00 | chaffinch | 1 | 81242 | 1 | 1.406 | 57782.4 |
| 119 | 2023-04-19 13:23:24 | chaffinch | 4 | 165329 | 118 | 10.046 | 16457.2 |
| 118 | 2023-03-13 04:31:30 | chaffinch | 1 | 81242 | 1 | 1.343 | 60492.9 |
| 117 | 2023-02-25 23:00:20 | chaffinch | 2 | 121436 | 4 | 3.406 | 35653.6 |
| 116 | 2023-02-12 07:58:22 | chaffinch | 3 | 148641 | 10 | 6.360 | 23371.2 |
| 115 | 2023-01-21 18:50:05 | chaffinch | 4 | 165329 | 118 | 9.936 | 16639.4 |
| 114 | 2023-01-02 07:54:07 | chaffinch | 1 | 81242 | 1 | 1.393 | 58321.6 |
| 113 | 2022-12-08 10:09:39 | chaffinch | 1 | 81242 | 1 | 1.376 | 59042.2 |
| 112 | 2022-12-08 04:48:46 | chaffinch | 2 | 121436 | 4 | 3.843 | 31599.3 |
| 111 | 2022-12-05 03:02:47 | chaffinch | 1 | 81242 | 1 | 1.390 | 58447.5 |
| 110 | 2022-11-22 22:06:32 | chaffinch | 3 | 148641 | 10 | 6.063 | 24516.1 |
| 109 | 2022-11-01 10:06:25 | chaffinch | 4 | 165329 | 118 | 10.156 | 16278.9 |
| 108 | 2022-09-23 08:49:03 | chaffinch | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 107 | 2022-07-22 15:20:37 | chaffinch | 2 | 121436 | 4 | 3.016 | 40263.9 |
| 106 | 2022-07-04 14:56:26 | chaffinch | 1 | 81242 | 1 | 2.796 | 29056.5 |
| 105 | 2022-06-02 20:03:40 | chaffinch | 4 | 165329 | 118 | 10.156 | 16278.9 |
| 104 | 2022-05-07 09:15:36 | chaffinch | 3 | 148641 | 10 | 6.610 | 22487.3 |
| 103 | 2022-05-04 19:05:54 | chaffinch | 1 | 81242 | 1 | 1.280 | 63470.3 |
| 102 | 2022-05-02 13:48:42 | chaffinch | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 101 | 2022-02-07 14:56:10 | chaffinch | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 100 | 2021-09-22 06:06:43 | chaffinch | 1 | 81242 | 1 | 2.393 | 33949.9 |
| 99 | 2021-06-08 09:01:00 | chaffinch | 1 | 81242 | 1 | 1.420 | 57212.7 |
| 98 | 2021-06-05 03:54:30 | chaffinch | 1 | 81242 | 1 | 1.373 | 59171.2 |
| 97 | 2021-03-02 20:59:43 | chaffinch | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 96 | 2020-11-22 10:23:22 | chaffinch | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 95 | 2020-11-07 18:30:09 | chaffinch | 4 | 165329 | 118 | 10.673 | 15490.4 |
| 94 | 2020-07-24 01:40:16 | chaffinch | 1 | 81242 | 1 | 1.310 | 62016.8 |
| 93 | 2020-07-20 19:05:19 | chaffinch | 1 | 81242 | 1 | 1.530 | 53099.3 |
| 92 | 2020-04-06 07:54:32 | chaffinch | 1 | 81242 | 1 | 1.330 | 61084.2 |
| 91 | 2020-03-27 05:46:04 | chaffinch | 1 | 81242 | 1 | 1.326 | 61268.5 |
| 90 | 2020-02-15 00:38:45 | chaffinch | 1 | 81242 | 1 | 1.576 | 51549.5 |
| 89 | 2020-02-14 12:01:54 | chaffinch | 1 | 81242 | 1 | 3.030 | 26812.5 |
| 88 | 2020-01-20 17:52:05 | chaffinch | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 87 | 2020-01-16 19:26:10 | chaffinch | 1 | 81242 | 1 | 3.063 | 26523.7 |
| 86 | 2020-01-13 13:33:21 | chaffinch | 1 | 81242 | 1 | 3.030 | 26812.5 |
| 85 | 2019-12-11 12:19:11 | chaffinch | 1 | 81242 | 1 | 1.233 | 65889.7 |
| 84 | 2019-09-09 17:48:23 | chaffinch | 1 | 81242 | 1 | 1.273 | 63819.3 |
| 83 | 2019-05-19 08:19:42 | chaffinch | 1 | 81242 | 1 | 1.466 | 55417.5 |
| 82 | 2019-03-04 21:28:13 | chaffinch | 1 | 81242 | 1 | 1.190 | 68270.6 |
| 81 | 2019-01-08 21:27:51 | chaffinch | 1 | 81242 | 1 | 1.423 | 57092.1 |
| 80 | 2019-01-04 07:01:05 | chaffinch | 1 | 81242 | 1 | 1.486 | 54671.6 |
| 79 | 2018-12-31 23:00:37 | chaffinch | 1 | 81242 | 1 | 1.480 | 54893.2 |
| 78 | 2018-08-04 22:20:57 | chaffinch | 1 | 81242 | 1 | 1.370 | 59300.7 |
| 77 | 2018-05-10 18:19:07 | chaffinch | 1 | 81242 | 1 | 1.413 | 57496.1 |
| 76 | 2018-03-25 22:50:21 | chaffinch | 1 | 81242 | 1 | 2.160 | 37612.0 |
| 75 | 2017-12-16 11:38:01 | chaffinch | 1 | 81242 | 1 | 1.723 | 47151.5 |