History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nightlong"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
151 | 2024-05-06 18:18:26 | nightlong | 1 | 81242 | 1 | 1.516 | 53589.7 |
150 | 2024-05-06 03:34:08 | nightlong | 1 | 81242 | 1 | 1.516 | 53589.7 |
149 | 2024-05-03 11:10:51 | nightlong | 1 | 81242 | 1 | 1.343 | 60492.9 |
148 | 2024-04-29 18:03:05 | nightlong | 3 | 148641 | 21 | 6.873 | 21626.8 |
147 | 2024-04-29 18:03:02 | nightlong | 2 | 121436 | 1 | 6.750 | 17990.5 |
146 | 2024-04-29 18:01:14 | nightlong | 1 | 81242 | 1 | 1.940 | 41877.3 |
145 | 2024-04-28 15:20:16 | nightlong | 1 | 81242 | 1 | 1.483 | 54782.2 |
144 | 2024-04-03 17:28:27 | nightlong | 4 | 165329 | 153 | 23.876 | 6924.5 |
143 | 2024-04-01 18:03:29 | nightlong | 3 | 148641 | 21 | 22.440 | 6623.9 |
142 | 2024-04-01 18:03:24 | nightlong | 4 | 165329 | 153 | 21.140 | 7820.7 |
141 | 2024-04-01 18:03:30 | nightlong | 2 | 121436 | 1 | 8.280 | 14666.2 |
140 | 2024-04-01 14:12:07 | nightlong | 1 | 81242 | 1 | 1.500 | 54161.3 |
139 | 2024-03-28 10:18:49 | nightlong | 1 | 81242 | 1 | 1.233 | 65889.7 |
138 | 2024-03-25 22:51:59 | nightlong | 3 | 148641 | 21 | 18.626 | 7980.3 |
137 | 2024-03-25 22:51:55 | nightlong | 2 | 121436 | 1 | 12.346 | 9836.1 |
136 | 2024-03-25 21:57:34 | nightlong | 1 | 81242 | 1 | 1.373 | 59171.2 |
135 | 2024-03-25 06:12:35 | nightlong | 1 | 81242 | 1 | 1.453 | 55913.3 |
134 | 2024-03-02 06:37:08 | nightlong | 1 | 81242 | 1 | 3.033 | 26786.0 |
133 | 2024-03-02 01:04:13 | nightlong | 4 | 165329 | 153 | 13.686 | 12080.2 |
132 | 2024-02-29 12:27:27 | nightlong | 4 | 165329 | 153 | 14.110 | 11717.2 |
131 | 2024-02-29 12:27:29 | nightlong | 3 | 148641 | 21 | 11.406 | 13031.8 |
130 | 2024-02-29 12:27:21 | nightlong | 2 | 121436 | 1 | 3.453 | 35168.3 |
129 | 2024-02-29 12:27:09 | nightlong | 1 | 81242 | 1 | 1.576 | 51549.5 |
128 | 2024-02-27 05:29:14 | nightlong | 1 | 81242 | 1 | 1.486 | 54671.6 |
127 | 2024-02-20 01:28:35 | nightlong | 1 | 81242 | 1 | 3.000 | 27080.7 |
126 | 2024-01-19 19:04:39 | nightlong | 1 | 81242 | 1 | 1.343 | 60492.9 |
125 | 2024-01-17 21:55:04 | nightlong | 1 | 81242 | 1 | 1.390 | 58447.5 |
124 | 2024-01-05 12:17:06 | nightlong | 3 | 148641 | 21 | 6.093 | 24395.4 |
123 | 2023-11-22 10:42:00 | nightlong | 4 | 165329 | 153 | 13.563 | 12189.7 |
122 | 2023-11-12 00:57:32 | nightlong | 1 | 81242 | 1 | 1.343 | 60492.9 |
121 | 2023-10-13 15:55:40 | nightlong | 3 | 148641 | 21 | 7.060 | 21054.0 |
120 | 2023-08-31 10:37:00 | nightlong | 1 | 81242 | 1 | 1.203 | 67532.8 |
119 | 2023-08-22 22:25:11 | nightlong | 4 | 165329 | 153 | 10.063 | 16429.4 |
118 | 2023-07-24 22:01:32 | nightlong | 3 | 148641 | 21 | 5.936 | 25040.6 |
117 | 2023-06-05 11:01:55 | nightlong | 1 | 81242 | 1 | 1.330 | 61084.2 |
116 | 2023-05-09 04:23:00 | nightlong | 4 | 165329 | 153 | 9.906 | 16689.8 |
115 | 2023-04-07 13:59:25 | nightlong | 3 | 148641 | 21 | 5.966 | 24914.7 |
114 | 2023-03-27 09:20:20 | nightlong | 1 | 81242 | 1 | 1.186 | 68500.8 |
113 | 2023-02-09 04:02:36 | nightlong | 4 | 165329 | 153 | 14.923 | 11078.8 |
112 | 2023-01-12 12:06:26 | nightlong | 1 | 81242 | 1 | 1.233 | 65889.7 |
111 | 2023-01-05 12:27:55 | nightlong | 3 | 148641 | 21 | 6.233 | 23847.4 |
110 | 2022-11-22 10:32:45 | nightlong | 4 | 165329 | 153 | 10.220 | 16177.0 |
109 | 2022-10-25 16:40:10 | nightlong | 1 | 81242 | 1 | 1.280 | 63470.3 |
108 | 2022-09-16 14:09:37 | nightlong | 1 | 81242 | 1 | 1.220 | 66591.8 |
107 | 2022-09-11 11:48:06 | nightlong | 3 | 148641 | 21 | 5.843 | 25439.2 |
106 | 2022-06-25 20:16:34 | nightlong | 4 | 165329 | 153 | 10.016 | 16506.5 |
105 | 2022-06-15 15:50:53 | nightlong | 1 | 81242 | 1 | 1.200 | 67701.7 |
104 | 2022-06-13 10:24:11 | nightlong | 1 | 81242 | 1 | 1.330 | 61084.2 |
103 | 2022-04-20 14:28:40 | nightlong | 3 | 148641 | 21 | 7.643 | 19448.0 |
102 | 2022-03-08 03:28:43 | nightlong | 1 | 81242 | 1 | 1.623 | 50056.7 |
101 | 2022-03-06 00:02:59 | nightlong | 1 | 81242 | 1 | 1.593 | 50999.4 |
100 | 2021-04-08 07:54:57 | nightlong | 1 | 81242 | 1 | 1.236 | 65729.8 |
99 | 2021-02-15 23:29:31 | nightlong | 1 | 81242 | 1 | 1.283 | 63321.9 |
98 | 2020-11-11 02:09:56 | nightlong | 1 | 81242 | 1 | 1.516 | 53589.7 |
97 | 2020-03-24 18:17:23 | nightlong | 1 | 81242 | 1 | 1.376 | 59042.2 |
96 | 2020-03-12 14:17:46 | nightlong | 1 | 81242 | 1 | 1.203 | 67532.8 |
95 | 2020-02-15 03:08:03 | nightlong | 1 | 81242 | 1 | 2.923 | 27794.0 |
94 | 2020-02-06 10:48:46 | nightlong | 1 | 81242 | 1 | 1.390 | 58447.5 |
93 | 2020-02-05 20:30:06 | nightlong | 1 | 81242 | 1 | 1.466 | 55417.5 |
92 | 2020-02-04 14:32:45 | nightlong | 1 | 81242 | 1 | 3.160 | 25709.5 |
91 | 2020-01-30 19:35:11 | nightlong | 1 | 81242 | 1 | 2.343 | 34674.3 |
90 | 2020-01-23 13:51:20 | nightlong | 1 | 81242 | 1 | 3.910 | 20778.0 |
89 | 2020-01-17 17:55:29 | nightlong | 1 | 81242 | 1 | 1.423 | 57092.1 |
88 | 2020-01-04 23:47:06 | nightlong | 1 | 81242 | 1 | 1.280 | 63470.3 |
87 | 2020-01-02 11:16:23 | nightlong | 1 | 81242 | 1 | 1.436 | 56575.2 |
86 | 2019-11-30 23:52:56 | nightlong | 1 | 81242 | 1 | 1.250 | 64993.6 |
85 | 2019-09-01 14:40:47 | nightlong | 1 | 81242 | 1 | 1.476 | 55042.0 |
84 | 2019-05-17 08:43:58 | nightlong | 1 | 81242 | 1 | 1.336 | 60809.9 |
83 | 2019-02-15 04:18:29 | nightlong | 1 | 81242 | 1 | 1.180 | 68849.2 |
82 | 2019-01-10 03:03:30 | nightlong | 1 | 81242 | 1 | 1.310 | 62016.8 |
81 | 2018-12-26 12:53:15 | nightlong | 1 | 81242 | 1 | 1.156 | 70278.5 |
80 | 2018-10-22 18:45:50 | nightlong | 1 | 81242 | 1 | 1.226 | 66265.9 |
79 | 2018-08-21 06:06:38 | nightlong | 1 | 81242 | 1 | 1.540 | 52754.5 |
78 | 2018-03-27 20:56:34 | nightlong | 1 | 81242 | 1 | 1.903 | 42691.5 |
77 | 2018-03-26 00:46:04 | nightlong | 1 | 81242 | 1 | 1.903 | 42691.5 |
76 | 2018-01-25 02:39:24 | nightlong | 1 | 81242 | 1 | 1.616 | 50273.5 |
75 | 2018-01-06 05:33:55 | nightlong | 1 | 81242 | 1 | 1.700 | 47789.4 |
74 | 2018-01-04 06:27:15 | nightlong | 1 | 81242 | 1 | 1.836 | 44249.5 |
73 | 2017-12-16 15:01:24 | nightlong | 1 | 81242 | 1 | 1.880 | 43213.8 |
72 | 2017-11-11 10:54:22 | nightlong | 1 | 81242 | 1 | 1.813 | 44810.8 |
71 | 2017-10-22 08:03:07 | nightlong | 1 | 81242 | 1 | 2.123 | 38267.5 |
70 | 2017-10-22 07:57:29 | nightlong | 1 | 81242 | 1 | 3.330 | 24397.0 |
69 | 2017-08-20 19:40:07 | nightlong | 1 | 81242 | 1 | 1.676 | 48473.7 |
68 | 2017-08-20 19:36:51 | nightlong | 1 | 81242 | 1 | 1.616 | 50273.5 |
67 | 2017-05-18 15:02:29 | nightlong | 1 | 81242 | 1 | 2.300 | 35322.6 |
66 | 2017-04-28 18:31:42 | nightlong | 1 | 81242 | 1 | 3.236 | 25105.7 |
65 | 2017-04-09 08:15:07 | nightlong | 1 | 81242 | 1 | 1.683 | 48272.1 |
64 | 2017-02-02 07:57:20 | nightlong | 1 | 81242 | 1 | 1.480 | 54893.2 |
63 | 2017-01-01 14:28:30 | nightlong | 1 | 81242 | 1 | 1.460 | 55645.2 |
62 | 2016-09-18 17:41:33 | nightlong | 1 | 81242 | 1 | 1.683 | 48272.1 |
61 | 2016-09-16 00:34:59 | nightlong | 1 | 81242 | 1 | 1.913 | 42468.4 |
60 | 2016-09-01 05:50:12 | nightlong | 1 | 81242 | 1 | 1.590 | 51095.6 |
59 | 2016-08-22 11:46:08 | nightlong | 3 | 148641 | 21 | 11.250 | 13212.5 |
58 | 2016-08-20 00:40:23 | nightlong | 4 | 165329 | 153 | 19.420 | 8513.3 |
57 | 2016-08-18 16:22:39 | nightlong | 1 | 81242 | 1 | 2.076 | 39133.9 |
56 | 2016-07-23 15:01:58 | nightlong | 1 | 81242 | 1 | 2.020 | 40218.8 |
55 | 2016-07-19 00:01:49 | nightlong | 2 | 121436 | 1 | 5.763 | 21071.7 |
54 | 2016-06-22 04:26:59 | nightlong | 1 | 81242 | 1 | 2.016 | 40298.6 |
53 | 2016-05-14 07:58:59 | nightlong | 1 | 81242 | 1 | 1.423 | 57092.1 |
52 | 2016-03-01 00:13:48 | nightlong | 1 | 81242 | 1 | 1.426 | 56971.9 |