History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lagnappes"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 158 | 2024-05-01 12:09:28 | lagnappes | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 157 | 2024-05-01 11:15:51 | lagnappes | 1 | 81242 | 3 | 2.983 | 27235.0 |
| 156 | 2024-05-01 11:14:51 | lagnappes | 1 | 81242 | 3 | 1.656 | 49059.2 |
| 155 | 2024-04-21 07:57:03 | lagnappes | 3 | 148641 | 16 | 11.483 | 12944.4 |
| 154 | 2024-04-20 16:45:19 | lagnappes | 3 | 148641 | 16 | 25.440 | 5842.8 |
| 153 | 2024-04-16 09:15:12 | lagnappes | 3 | 148641 | 16 | 42.643 | 3485.7 |
| 152 | 2024-04-16 09:15:09 | lagnappes | 2 | 121436 | 4 | 8.016 | 15149.2 |
| 151 | 2024-04-16 06:36:54 | lagnappes | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 150 | 2024-04-16 02:04:14 | lagnappes | 3 | 148641 | 16 | 25.516 | 5825.4 |
| 149 | 2024-04-14 21:52:48 | lagnappes | 3 | 148641 | 16 | 31.173 | 4768.3 |
| 148 | 2024-04-14 21:52:45 | lagnappes | 2 | 121436 | 4 | 15.440 | 7865.0 |
| 147 | 2024-04-14 21:52:20 | lagnappes | 1 | 81242 | 3 | 4.610 | 17623.0 |
| 146 | 2024-04-04 04:41:08 | lagnappes | 4 | 165329 | 173 | 39.016 | 4237.5 |
| 145 | 2024-04-03 12:22:56 | lagnappes | 4 | 165329 | 173 | 15.003 | 11019.7 |
| 144 | 2024-04-02 09:51:37 | lagnappes | 4 | 165329 | 173 | 18.533 | 8920.8 |
| 143 | 2024-04-01 05:54:17 | lagnappes | 4 | 165329 | 173 | 24.470 | 6756.4 |
| 142 | 2024-03-31 18:21:22 | lagnappes | 4 | 165329 | 173 | 46.336 | 3568.0 |
| 141 | 2024-03-31 18:21:24 | lagnappes | 3 | 148641 | 16 | 18.563 | 8007.4 |
| 140 | 2024-03-31 18:21:22 | lagnappes | 2 | 121436 | 4 | 4.250 | 28573.2 |
| 139 | 2024-03-31 18:16:33 | lagnappes | 1 | 81242 | 3 | 1.390 | 58447.5 |
| 138 | 2024-03-07 16:17:05 | lagnappes | 1 | 81242 | 3 | 1.393 | 58321.6 |
| 137 | 2024-02-29 20:39:13 | lagnappes | 1 | 81242 | 3 | 1.923 | 42247.5 |
| 136 | 2024-02-29 18:00:47 | lagnappes | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 135 | 2024-02-29 18:00:30 | lagnappes | 1 | 81242 | 3 | 1.546 | 52549.8 |
| 134 | 2024-02-20 03:00:15 | lagnappes | 1 | 81242 | 3 | 3.173 | 25604.2 |
| 133 | 2024-02-19 17:11:04 | lagnappes | 3 | 148641 | 16 | 14.640 | 10153.1 |
| 132 | 2024-02-16 18:00:02 | lagnappes | 1 | 81242 | 3 | 1.310 | 62016.8 |
| 131 | 2024-02-09 05:40:45 | lagnappes | 3 | 148641 | 16 | 12.033 | 12352.8 |
| 130 | 2024-02-09 05:40:44 | lagnappes | 2 | 121436 | 4 | 7.810 | 15548.8 |
| 129 | 2024-02-09 05:40:29 | lagnappes | 4 | 165329 | 173 | 15.596 | 10600.7 |
| 128 | 2024-02-09 05:37:45 | lagnappes | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 127 | 2024-01-31 21:17:07 | lagnappes | 1 | 81242 | 3 | 1.423 | 57092.1 |
| 126 | 2024-01-30 02:24:12 | lagnappes | 1 | 81242 | 3 | 2.796 | 29056.5 |
| 125 | 2024-01-30 02:23:38 | lagnappes | 1 | 81242 | 3 | 2.890 | 28111.4 |
| 124 | 2024-01-07 17:37:34 | lagnappes | 3 | 148641 | 16 | 6.720 | 22119.2 |
| 123 | 2023-12-10 02:14:27 | lagnappes | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 122 | 2023-12-02 01:20:45 | lagnappes | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 121 | 2023-10-14 00:47:52 | lagnappes | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 120 | 2023-10-13 07:43:46 | lagnappes | 3 | 148641 | 16 | 5.983 | 24843.9 |
| 119 | 2023-10-09 15:51:04 | lagnappes | 1 | 81242 | 3 | 1.236 | 65729.8 |
| 118 | 2023-09-17 00:44:48 | lagnappes | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 117 | 2023-09-12 15:13:43 | lagnappes | 1 | 81242 | 3 | 1.263 | 64324.6 |
| 116 | 2023-07-24 04:03:05 | lagnappes | 3 | 148641 | 16 | 6.170 | 24090.9 |
| 115 | 2023-07-06 04:13:46 | lagnappes | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 114 | 2023-04-09 21:28:17 | lagnappes | 1 | 81242 | 3 | 1.376 | 59042.2 |
| 113 | 2023-04-05 00:46:11 | lagnappes | 3 | 148641 | 16 | 6.593 | 22545.3 |
| 112 | 2023-01-30 20:59:45 | lagnappes | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 111 | 2023-01-01 23:28:00 | lagnappes | 3 | 148641 | 16 | 6.266 | 23721.8 |
| 110 | 2022-11-28 15:17:36 | lagnappes | 1 | 81242 | 3 | 1.296 | 62686.7 |
| 109 | 2022-09-06 01:42:03 | lagnappes | 3 | 148641 | 16 | 5.873 | 25309.2 |
| 108 | 2022-07-22 18:46:40 | lagnappes | 1 | 81242 | 3 | 1.203 | 67532.8 |
| 107 | 2022-05-15 14:24:07 | lagnappes | 3 | 148641 | 16 | 6.033 | 24638.0 |
| 106 | 2022-04-06 03:00:16 | lagnappes | 1 | 81242 | 3 | 1.500 | 54161.3 |
| 105 | 2021-11-15 19:15:58 | lagnappes | 1 | 81242 | 3 | 1.453 | 55913.3 |
| 104 | 2021-11-15 07:35:51 | lagnappes | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 103 | 2021-11-14 16:32:06 | lagnappes | 1 | 81242 | 3 | 1.360 | 59736.8 |
| 102 | 2021-11-14 06:50:55 | lagnappes | 1 | 81242 | 3 | 1.516 | 53589.7 |
| 101 | 2021-11-13 15:54:10 | lagnappes | 1 | 81242 | 3 | 1.283 | 63321.9 |
| 100 | 2021-11-13 08:36:04 | lagnappes | 1 | 81242 | 3 | 2.860 | 28406.3 |
| 99 | 2021-11-12 18:22:40 | lagnappes | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 98 | 2021-11-12 05:01:46 | lagnappes | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 97 | 2021-11-11 11:18:53 | lagnappes | 1 | 81242 | 3 | 2.733 | 29726.3 |
| 96 | 2021-10-30 16:26:33 | lagnappes | 1 | 81242 | 3 | 1.610 | 50460.9 |
| 95 | 2021-10-29 15:05:46 | lagnappes | 1 | 81242 | 3 | 1.466 | 55417.5 |
| 94 | 2021-10-27 23:34:22 | lagnappes | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 93 | 2021-09-21 07:16:41 | lagnappes | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 92 | 2021-09-20 21:27:00 | lagnappes | 1 | 81242 | 3 | 1.406 | 57782.4 |
| 91 | 2021-09-20 04:21:59 | lagnappes | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 90 | 2021-09-14 06:15:43 | lagnappes | 1 | 81242 | 3 | 1.220 | 66591.8 |
| 89 | 2021-04-11 13:28:28 | lagnappes | 3 | 148641 | 16 | 6.203 | 23962.8 |
| 88 | 2021-01-31 02:42:17 | lagnappes | 3 | 148641 | 16 | 7.360 | 20195.8 |
| 87 | 2021-01-28 22:44:08 | lagnappes | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 86 | 2020-12-31 06:53:58 | lagnappes | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 85 | 2020-11-08 03:11:02 | lagnappes | 1 | 81242 | 3 | 1.533 | 52995.4 |
| 84 | 2020-11-07 18:15:55 | lagnappes | 1 | 81242 | 3 | 1.343 | 60492.9 |
| 83 | 2020-11-07 17:21:57 | lagnappes | 3 | 148641 | 16 | 7.060 | 21054.0 |
| 82 | 2020-10-30 18:13:25 | lagnappes | 1 | 81242 | 3 | 1.890 | 42985.2 |
| 81 | 2020-10-25 22:23:37 | lagnappes | 1 | 81242 | 3 | 1.233 | 65889.7 |
| 80 | 2020-10-15 11:07:00 | lagnappes | 1 | 81242 | 3 | 1.266 | 64172.2 |
| 79 | 2020-09-24 15:37:27 | lagnappes | 3 | 148641 | 16 | 6.220 | 23897.3 |
| 78 | 2020-08-03 15:22:50 | lagnappes | 3 | 148641 | 16 | 6.326 | 23496.8 |
| 77 | 2020-04-01 03:19:22 | lagnappes | 1 | 81242 | 3 | 1.326 | 61268.5 |
| 76 | 2020-03-26 22:17:40 | lagnappes | 1 | 81242 | 3 | 1.766 | 46003.4 |
| 75 | 2020-02-19 01:03:03 | lagnappes | 1 | 81242 | 3 | 3.560 | 22820.8 |
| 74 | 2020-02-10 15:05:56 | lagnappes | 4 | 165329 | 173 | 16.766 | 9861.0 |
| 73 | 2020-02-10 03:16:37 | lagnappes | 1 | 81242 | 3 | 3.093 | 26266.4 |
| 72 | 2020-02-09 18:58:53 | lagnappes | 1 | 81242 | 3 | 1.436 | 56575.2 |
| 71 | 2020-02-08 19:50:53 | lagnappes | 4 | 165329 | 173 | 14.970 | 11044.0 |
| 70 | 2020-02-08 17:11:37 | lagnappes | 4 | 165329 | 173 | 17.783 | 9297.0 |
| 69 | 2020-02-08 06:55:09 | lagnappes | 3 | 148641 | 16 | 12.360 | 12026.0 |
| 68 | 2020-02-07 23:13:19 | lagnappes | 4 | 165329 | 173 | 16.126 | 10252.3 |
| 67 | 2020-02-07 10:47:28 | lagnappes | 4 | 165329 | 173 | 15.016 | 11010.2 |
| 66 | 2020-02-06 14:27:16 | lagnappes | 3 | 148641 | 16 | 15.643 | 9502.1 |
| 65 | 2020-02-06 14:25:59 | lagnappes | 4 | 165329 | 173 | 15.530 | 10645.8 |
| 64 | 2020-02-06 14:21:25 | lagnappes | 2 | 121436 | 4 | 4.436 | 27375.1 |
| 63 | 2020-02-06 10:33:35 | lagnappes | 1 | 81242 | 3 | 2.906 | 27956.6 |
| 62 | 2020-02-05 20:25:19 | lagnappes | 1 | 81242 | 3 | 1.576 | 51549.5 |
| 61 | 2020-02-01 08:06:16 | lagnappes | 1 | 81242 | 3 | 2.156 | 37681.8 |
| 60 | 2020-01-19 08:00:42 | lagnappes | 1 | 81242 | 3 | 3.140 | 25873.2 |
| 59 | 2020-01-11 05:34:53 | lagnappes | 1 | 81242 | 3 | 1.470 | 55266.7 |