History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"textbooks"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 175 | 2025-09-09 03:26:55 | textbooks | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 174 | 2025-09-08 23:21:49 | textbooks | 1 | 81242 | 2 | 1.360 | 59736.8 |
| 173 | 2025-09-03 04:34:15 | textbooks | 1 | 81242 | 2 | 2.283 | 35585.6 |
| 172 | 2025-07-27 00:42:48 | textbooks | 1 | 81242 | 2 | 2.970 | 27354.2 |
| 171 | 2025-07-24 07:18:48 | textbooks | 1 | 81242 | 2 | 4.626 | 17562.0 |
| 170 | 2025-07-24 05:53:29 | textbooks | 1 | 81242 | 2 | 7.593 | 10699.6 |
| 169 | 2025-07-19 10:21:43 | textbooks | 1 | 81242 | 2 | 5.783 | 14048.4 |
| 168 | 2025-07-17 12:09:40 | textbooks | 1 | 81242 | 2 | 3.580 | 22693.3 |
| 167 | 2025-07-14 09:56:52 | textbooks | 1 | 81242 | 2 | 3.406 | 23852.6 |
| 166 | 2025-05-16 12:50:35 | textbooks | 1 | 81242 | 2 | 5.783 | 14048.4 |
| 165 | 2025-05-12 09:09:22 | textbooks | 1 | 81242 | 2 | 7.000 | 11606.0 |
| 164 | 2025-03-07 11:14:27 | textbooks | 1 | 81242 | 2 | 3.233 | 25129.0 |
| 163 | 2025-03-04 11:49:14 | textbooks | 1 | 81242 | 2 | 9.953 | 8162.6 |
| 162 | 2025-02-25 02:11:16 | textbooks | 2 | 121436 | 3 | 16.470 | 7373.2 |
| 161 | 2025-02-25 02:08:43 | textbooks | 1 | 81242 | 2 | 3.516 | 23106.4 |
| 160 | 2025-02-15 20:49:14 | textbooks | 3 | 148641 | 8 | 53.240 | 2791.9 |
| 159 | 2025-02-10 13:27:32 | textbooks | 3 | 148641 | 8 | 37.113 | 4005.1 |
| 158 | 2025-02-04 21:17:02 | textbooks | 1 | 81242 | 2 | 2.890 | 28111.4 |
| 157 | 2025-01-23 15:42:54 | textbooks | 1 | 81242 | 2 | 4.623 | 17573.4 |
| 156 | 2025-01-18 14:32:18 | textbooks | 1 | 81242 | 2 | 6.343 | 12808.1 |
| 155 | 2024-12-30 01:31:39 | textbooks | 4 | 165329 | 105 | 67.236 | 2458.9 |
| 154 | 2024-12-30 01:31:41 | textbooks | 3 | 148641 | 8 | 55.426 | 2681.8 |
| 153 | 2024-12-30 01:31:39 | textbooks | 2 | 121436 | 3 | 18.406 | 6597.6 |
| 152 | 2024-12-30 01:26:24 | textbooks | 1 | 81242 | 2 | 5.186 | 15665.6 |
| 151 | 2024-12-26 22:28:24 | textbooks | 3 | 148641 | 8 | 28.706 | 5178.0 |
| 150 | 2024-12-25 02:34:37 | textbooks | 3 | 148641 | 8 | 36.070 | 4120.9 |
| 149 | 2024-12-25 02:34:25 | textbooks | 3 | 148641 | 8 | 37.893 | 3922.7 |
| 148 | 2024-12-25 02:34:33 | textbooks | 2 | 121436 | 3 | 15.126 | 8028.3 |
| 147 | 2024-12-21 21:11:05 | textbooks | 3 | 148641 | 8 | 44.003 | 3378.0 |
| 146 | 2024-12-21 21:11:07 | textbooks | 3 | 148641 | 8 | 37.690 | 3943.8 |
| 145 | 2024-12-21 21:11:12 | textbooks | 2 | 121436 | 3 | 23.580 | 5150.0 |
| 144 | 2024-12-21 21:09:35 | textbooks | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 143 | 2024-12-06 00:13:18 | textbooks | 1 | 81242 | 2 | 7.343 | 11063.9 |
| 142 | 2024-11-29 05:44:30 | textbooks | 1 | 81242 | 2 | 1.826 | 44491.8 |
| 141 | 2024-10-31 02:45:10 | textbooks | 1 | 81242 | 2 | 7.783 | 10438.4 |
| 140 | 2024-10-30 08:42:40 | textbooks | 1 | 81242 | 2 | 6.376 | 12741.8 |
| 139 | 2024-10-27 15:59:51 | textbooks | 1 | 81242 | 2 | 7.093 | 11453.8 |
| 138 | 2024-10-23 02:54:15 | textbooks | 3 | 148641 | 8 | 41.643 | 3569.4 |
| 137 | 2024-10-23 02:54:17 | textbooks | 3 | 148641 | 8 | 35.660 | 4168.3 |
| 136 | 2024-10-23 02:54:14 | textbooks | 2 | 121436 | 3 | 11.126 | 10914.6 |
| 135 | 2024-10-16 22:21:19 | textbooks | 3 | 148641 | 8 | 35.126 | 4231.7 |
| 134 | 2024-10-16 01:07:42 | textbooks | 3 | 148641 | 8 | 33.703 | 4410.3 |
| 133 | 2024-10-12 01:19:59 | textbooks | 3 | 148641 | 8 | 27.203 | 5464.1 |
| 132 | 2024-10-09 13:46:43 | textbooks | 3 | 148641 | 8 | 29.470 | 5043.8 |
| 131 | 2024-09-06 11:47:02 | textbooks | 3 | 148641 | 8 | 82.723 | 1796.9 |
| 130 | 2024-09-04 01:24:54 | textbooks | 3 | 148641 | 8 | 47.363 | 3138.3 |
| 129 | 2024-09-01 09:35:59 | textbooks | 3 | 148641 | 8 | 30.736 | 4836.1 |
| 128 | 2024-08-31 15:46:45 | textbooks | 3 | 148641 | 8 | 67.423 | 2204.6 |
| 127 | 2024-08-31 15:46:40 | textbooks | 4 | 165329 | 105 | 61.783 | 2676.0 |
| 126 | 2024-08-31 15:46:45 | textbooks | 2 | 121436 | 3 | 27.656 | 4390.9 |
| 125 | 2024-08-10 01:59:32 | textbooks | 1 | 81242 | 2 | 6.656 | 12205.8 |
| 124 | 2024-08-08 19:40:32 | textbooks | 1 | 81242 | 2 | 2.720 | 29868.4 |
| 123 | 2024-08-05 00:39:39 | textbooks | 1 | 81242 | 2 | 3.186 | 25499.7 |
| 122 | 2024-07-31 01:41:24 | textbooks | 2 | 121436 | 3 | 13.000 | 9341.2 |
| 121 | 2024-07-31 01:41:22 | textbooks | 3 | 148641 | 8 | 14.266 | 10419.2 |
| 120 | 2024-07-31 01:41:09 | textbooks | 3 | 148641 | 8 | 25.420 | 5847.4 |
| 119 | 2024-07-31 00:35:46 | textbooks | 1 | 81242 | 2 | 1.826 | 44491.8 |
| 118 | 2024-07-22 04:56:15 | textbooks | 1 | 81242 | 2 | 7.640 | 10633.8 |
| 117 | 2024-07-04 17:53:02 | textbooks | 2 | 121436 | 3 | 13.533 | 8973.3 |
| 116 | 2024-07-04 17:52:13 | textbooks | 1 | 81242 | 2 | 3.766 | 21572.5 |
| 115 | 2024-06-24 00:47:43 | textbooks | 3 | 148641 | 8 | 32.843 | 4525.8 |
| 114 | 2024-06-24 00:47:47 | textbooks | 3 | 148641 | 8 | 24.640 | 6032.5 |
| 113 | 2024-06-20 04:38:43 | textbooks | 3 | 148641 | 8 | 30.016 | 4952.1 |
| 112 | 2024-06-14 15:19:42 | textbooks | 3 | 148641 | 8 | 35.690 | 4164.8 |
| 111 | 2024-06-10 12:56:46 | textbooks | 3 | 148641 | 8 | 28.456 | 5223.5 |
| 110 | 2024-06-10 12:56:53 | textbooks | 2 | 121436 | 3 | 7.033 | 17266.6 |
| 109 | 2024-06-10 12:55:15 | textbooks | 1 | 81242 | 2 | 3.330 | 24397.0 |
| 108 | 2024-06-07 22:11:37 | textbooks | 1 | 81242 | 2 | 9.376 | 8664.9 |
| 107 | 2024-05-26 08:23:00 | textbooks | 4 | 165329 | 105 | 31.030 | 5328.0 |
| 106 | 2024-05-26 08:23:05 | textbooks | 3 | 148641 | 8 | 19.720 | 7537.6 |
| 105 | 2024-05-26 08:22:51 | textbooks | 2 | 121436 | 3 | 12.643 | 9605.0 |
| 104 | 2024-05-05 10:06:57 | textbooks | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 103 | 2024-04-29 14:58:34 | textbooks | 1 | 81242 | 2 | 2.656 | 30588.1 |
| 102 | 2024-04-29 14:58:29 | textbooks | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 101 | 2024-04-25 19:27:27 | textbooks | 1 | 81242 | 2 | 1.470 | 55266.7 |
| 100 | 2024-04-19 18:41:00 | textbooks | 3 | 148641 | 8 | 27.123 | 5480.3 |
| 99 | 2024-04-15 20:57:34 | textbooks | 3 | 148641 | 8 | 17.440 | 8523.0 |
| 98 | 2024-04-08 08:39:57 | textbooks | 3 | 148641 | 8 | 21.296 | 6979.8 |
| 97 | 2024-04-07 07:35:09 | textbooks | 4 | 165329 | 105 | 45.346 | 3645.9 |
| 96 | 2024-04-07 07:35:10 | textbooks | 3 | 148641 | 8 | 16.640 | 8932.8 |
| 95 | 2024-04-07 07:35:14 | textbooks | 2 | 121436 | 3 | 12.046 | 10081.0 |
| 94 | 2024-04-07 07:24:05 | textbooks | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 93 | 2024-04-05 08:16:56 | textbooks | 1 | 81242 | 2 | 3.156 | 25742.1 |
| 92 | 2024-03-28 17:53:32 | textbooks | 1 | 81242 | 2 | 1.560 | 52078.2 |
| 91 | 2024-03-04 16:26:51 | textbooks | 2 | 121436 | 3 | 4.330 | 28045.3 |
| 90 | 2024-03-04 16:24:44 | textbooks | 1 | 81242 | 2 | 1.563 | 51978.2 |
| 89 | 2024-02-29 09:57:01 | textbooks | 4 | 165329 | 105 | 12.796 | 12920.4 |
| 88 | 2024-02-29 09:56:57 | textbooks | 3 | 148641 | 8 | 12.266 | 12118.1 |
| 87 | 2024-02-29 09:57:04 | textbooks | 2 | 121436 | 3 | 3.643 | 33334.1 |
| 86 | 2024-02-29 04:45:45 | textbooks | 1 | 81242 | 2 | 1.330 | 61084.2 |
| 85 | 2024-02-27 16:47:16 | textbooks | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 84 | 2024-02-17 18:45:23 | textbooks | 1 | 81242 | 2 | 1.546 | 52549.8 |
| 83 | 2024-02-10 05:32:56 | textbooks | 2 | 121436 | 3 | 10.110 | 12011.5 |
| 82 | 2024-01-31 20:38:32 | textbooks | 1 | 81242 | 2 | 1.406 | 57782.4 |
| 81 | 2024-01-26 01:16:35 | textbooks | 1 | 81242 | 2 | 3.076 | 26411.6 |
| 80 | 2024-01-26 01:16:27 | textbooks | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 79 | 2024-01-12 06:35:10 | textbooks | 1 | 81242 | 2 | 1.390 | 58447.5 |
| 78 | 2023-11-04 14:53:54 | textbooks | 4 | 165329 | 105 | 11.000 | 15029.9 |
| 77 | 2023-11-04 14:53:44 | textbooks | 4 | 165329 | 105 | 12.720 | 12997.6 |
| 76 | 2023-11-04 14:53:43 | textbooks | 3 | 148641 | 8 | 9.190 | 16174.2 |