History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"truanted"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 167 | 2024-05-12 11:03:24 | truanted | 3 | 146162 | 194 | 15.783 | 9260.7 |
| 166 | 2024-05-12 11:03:24 | truanted | 2 | 121059 | 16 | 4.360 | 27765.8 |
| 165 | 2024-05-12 10:12:31 | truanted | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 164 | 2024-05-08 00:44:04 | truanted | 3 | 146162 | 194 | 17.613 | 8298.5 |
| 163 | 2024-05-07 13:42:00 | truanted | 2 | 121059 | 16 | 9.580 | 12636.6 |
| 162 | 2024-05-07 13:41:56 | truanted | 3 | 146162 | 194 | 10.423 | 14023.0 |
| 161 | 2024-05-07 13:41:52 | truanted | 1 | 82945 | 1 | 1.546 | 53651.4 |
| 160 | 2024-05-07 13:41:41 | truanted | 2 | 121059 | 16 | 4.453 | 27185.9 |
| 159 | 2024-05-07 01:01:22 | truanted | 2 | 121059 | 16 | 13.313 | 9093.3 |
| 158 | 2024-05-06 04:37:54 | truanted | 3 | 146162 | 194 | 15.670 | 9327.5 |
| 157 | 2024-05-06 03:05:32 | truanted | 3 | 146162 | 194 | 18.753 | 7794.1 |
| 156 | 2024-05-06 03:05:36 | truanted | 2 | 121059 | 16 | 10.203 | 11865.0 |
| 155 | 2024-05-06 03:05:39 | truanted | 1 | 82945 | 1 | 4.686 | 17700.6 |
| 154 | 2024-04-08 12:55:16 | truanted | 2 | 121059 | 16 | 11.533 | 10496.7 |
| 153 | 2024-04-08 12:52:04 | truanted | 1 | 82945 | 1 | 1.856 | 44690.2 |
| 152 | 2024-04-07 17:17:57 | truanted | 3 | 146162 | 194 | 13.706 | 10664.1 |
| 151 | 2024-04-06 04:04:33 | truanted | 2 | 121059 | 16 | 11.410 | 10609.9 |
| 150 | 2024-04-06 03:56:14 | truanted | 3 | 146162 | 194 | 7.673 | 19048.9 |
| 149 | 2024-04-06 00:46:11 | truanted | 3 | 146162 | 194 | 25.140 | 5813.9 |
| 148 | 2024-04-06 00:46:12 | truanted | 2 | 121059 | 16 | 13.906 | 8705.5 |
| 147 | 2024-04-06 00:46:01 | truanted | 1 | 82945 | 1 | 4.783 | 17341.6 |
| 146 | 2024-04-01 18:18:32 | truanted | 1 | 82945 | 1 | 3.456 | 24000.3 |
| 145 | 2024-03-30 04:14:51 | truanted | 1 | 82945 | 1 | 2.203 | 37650.9 |
| 144 | 2024-03-06 16:04:55 | truanted | 1 | 82945 | 1 | 4.706 | 17625.4 |
| 143 | 2024-03-05 06:31:55 | truanted | 2 | 121059 | 16 | 4.453 | 27185.9 |
| 142 | 2024-03-05 03:47:08 | truanted | 3 | 146162 | 194 | 29.003 | 5039.5 |
| 141 | 2024-03-04 09:58:58 | truanted | 3 | 146162 | 194 | 10.233 | 14283.4 |
| 140 | 2024-03-04 07:34:55 | truanted | 1 | 82945 | 1 | 3.206 | 25871.8 |
| 139 | 2024-03-02 05:18:29 | truanted | 2 | 121059 | 16 | 8.593 | 14088.1 |
| 138 | 2024-03-02 05:18:12 | truanted | 3 | 146162 | 194 | 8.920 | 16385.9 |
| 137 | 2024-03-02 03:12:24 | truanted | 2 | 121059 | 16 | 4.280 | 28284.8 |
| 136 | 2024-03-01 10:00:58 | truanted | 3 | 146162 | 194 | 28.063 | 5208.4 |
| 135 | 2024-03-01 10:01:02 | truanted | 2 | 121059 | 16 | 4.330 | 27958.2 |
| 134 | 2024-03-01 08:40:57 | truanted | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 133 | 2024-02-07 19:39:26 | truanted | 1 | 82945 | 1 | 3.186 | 26034.2 |
| 132 | 2024-02-07 19:39:16 | truanted | 1 | 82945 | 1 | 3.216 | 25791.4 |
| 131 | 2024-02-07 01:19:54 | truanted | 2 | 121059 | 16 | 3.656 | 33112.4 |
| 130 | 2024-02-07 00:35:38 | truanted | 3 | 146162 | 194 | 6.860 | 21306.4 |
| 129 | 2024-01-31 07:05:07 | truanted | 2 | 121059 | 16 | 3.656 | 33112.4 |
| 128 | 2024-01-29 22:44:14 | truanted | 1 | 82945 | 1 | 1.420 | 58412.0 |
| 127 | 2024-01-27 10:36:59 | truanted | 3 | 146162 | 194 | 8.376 | 17450.1 |
| 126 | 2024-01-27 00:58:47 | truanted | 2 | 121059 | 16 | 3.530 | 34294.3 |
| 125 | 2024-01-26 23:48:03 | truanted | 3 | 146162 | 194 | 7.423 | 19690.4 |
| 124 | 2024-01-17 20:29:13 | truanted | 3 | 146162 | 194 | 15.673 | 9325.7 |
| 123 | 2024-01-17 20:29:14 | truanted | 2 | 121059 | 16 | 4.076 | 29700.4 |
| 122 | 2023-12-01 13:11:49 | truanted | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 121 | 2023-11-20 16:45:48 | truanted | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 120 | 2023-11-20 12:51:51 | truanted | 1 | 82945 | 1 | 1.296 | 64000.8 |
| 119 | 2023-11-17 02:52:36 | truanted | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 118 | 2023-10-23 03:18:17 | truanted | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 117 | 2023-09-17 04:52:27 | truanted | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 116 | 2023-06-28 11:46:31 | truanted | 1 | 82945 | 1 | 1.236 | 67107.6 |
| 115 | 2023-04-09 17:32:15 | truanted | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 114 | 2023-02-01 15:01:45 | truanted | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 113 | 2022-11-29 21:40:10 | truanted | 1 | 82945 | 1 | 1.373 | 60411.5 |
| 112 | 2022-07-23 23:15:58 | truanted | 1 | 82945 | 1 | 1.233 | 67270.9 |
| 111 | 2022-06-08 22:16:12 | truanted | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 110 | 2022-05-09 01:50:45 | truanted | 1 | 82945 | 1 | 1.283 | 64649.3 |
| 109 | 2021-04-28 23:21:18 | truanted | 1 | 82945 | 1 | 1.623 | 51106.0 |
| 108 | 2021-01-11 21:03:54 | truanted | 1 | 82945 | 1 | 2.140 | 38759.3 |
| 107 | 2020-12-13 09:45:28 | truanted | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 106 | 2020-11-07 19:27:02 | truanted | 1 | 82945 | 1 | 1.983 | 41828.0 |
| 105 | 2020-10-28 09:59:11 | truanted | 1 | 82945 | 1 | 1.313 | 63172.1 |
| 104 | 2020-09-02 09:51:21 | truanted | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 103 | 2020-08-28 10:53:11 | truanted | 1 | 82945 | 1 | 1.330 | 62364.7 |
| 102 | 2020-08-17 03:42:29 | truanted | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 101 | 2020-04-01 10:59:02 | truanted | 1 | 82945 | 1 | 1.266 | 65517.4 |
| 100 | 2020-03-25 04:48:57 | truanted | 1 | 82945 | 1 | 1.470 | 56425.2 |
| 99 | 2020-02-23 20:22:05 | truanted | 1 | 82945 | 1 | 2.970 | 27927.6 |
| 98 | 2020-02-19 19:22:33 | truanted | 1 | 82945 | 1 | 1.670 | 49667.7 |
| 97 | 2020-02-18 19:36:43 | truanted | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 96 | 2020-02-17 21:45:26 | truanted | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 95 | 2020-02-04 05:12:07 | truanted | 1 | 82945 | 1 | 1.890 | 43886.2 |
| 94 | 2020-02-03 23:35:37 | truanted | 1 | 82945 | 1 | 3.280 | 25288.1 |
| 93 | 2020-02-03 17:33:14 | truanted | 1 | 82945 | 1 | 1.500 | 55296.7 |
| 92 | 2020-01-26 12:02:38 | truanted | 1 | 82945 | 1 | 3.266 | 25396.5 |
| 91 | 2020-01-23 03:42:46 | truanted | 1 | 82945 | 1 | 3.296 | 25165.4 |
| 90 | 2020-01-22 23:44:19 | truanted | 1 | 82945 | 1 | 3.156 | 26281.7 |
| 89 | 2020-01-18 00:18:45 | truanted | 1 | 82945 | 1 | 3.516 | 23590.7 |
| 88 | 2020-01-13 01:37:57 | truanted | 1 | 82945 | 1 | 1.580 | 52496.8 |
| 87 | 2019-12-31 22:12:08 | truanted | 1 | 82945 | 1 | 1.436 | 57761.1 |
| 86 | 2019-12-31 05:38:31 | truanted | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 85 | 2019-12-21 11:11:13 | truanted | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 84 | 2019-09-20 07:39:53 | truanted | 1 | 82945 | 1 | 2.706 | 30652.3 |
| 83 | 2019-06-11 09:30:09 | truanted | 1 | 82945 | 1 | 1.523 | 54461.6 |
| 82 | 2019-03-17 16:55:36 | truanted | 1 | 82945 | 1 | 1.386 | 59844.9 |
| 81 | 2019-03-12 13:15:57 | truanted | 1 | 82945 | 1 | 1.423 | 58288.8 |
| 80 | 2019-02-20 19:01:41 | truanted | 1 | 82945 | 1 | 1.426 | 58166.2 |
| 79 | 2019-02-16 06:56:53 | truanted | 1 | 82945 | 1 | 1.390 | 59672.7 |
| 78 | 2019-01-26 14:06:50 | truanted | 1 | 82945 | 1 | 1.223 | 67820.9 |
| 77 | 2018-10-29 02:56:56 | truanted | 1 | 82945 | 1 | 1.530 | 54212.4 |
| 76 | 2018-07-27 02:49:09 | truanted | 1 | 82945 | 1 | 1.250 | 66356.0 |
| 75 | 2018-07-18 20:45:00 | truanted | 1 | 82945 | 1 | 1.550 | 53512.9 |
| 74 | 2018-07-06 02:23:29 | truanted | 1 | 82945 | 1 | 1.210 | 68549.6 |
| 73 | 2018-06-23 20:02:10 | truanted | 1 | 82945 | 1 | 1.493 | 55555.9 |
| 72 | 2018-04-23 14:37:14 | truanted | 1 | 82945 | 1 | 1.330 | 62364.7 |
| 71 | 2017-10-17 16:03:13 | truanted | 1 | 82945 | 1 | 2.096 | 39573.0 |
| 70 | 2017-09-01 05:50:49 | truanted | 1 | 82945 | 1 | 1.706 | 48619.6 |
| 69 | 2017-07-08 06:21:46 | truanted | 1 | 82945 | 1 | 2.130 | 38941.3 |
| 68 | 2017-01-21 03:27:20 | truanted | 1 | 82945 | 1 | 3.076 | 26965.2 |