History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"passengers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
144 | 2024-05-11 19:57:42 | passengers | 1 | 67641 | 2 | 2.593 | 26086.0 |
143 | 2024-05-04 05:08:29 | passengers | 1 | 67641 | 2 | 1.030 | 65670.9 |
142 | 2024-05-01 01:15:17 | passengers | 1 | 67641 | 2 | 1.203 | 56226.9 |
141 | 2024-04-26 17:45:14 | passengers | 1 | 67641 | 2 | 1.143 | 59178.5 |
140 | 2024-04-26 17:45:12 | passengers | 1 | 67641 | 2 | 1.140 | 59334.2 |
139 | 2024-04-09 06:19:14 | passengers | 1 | 67641 | 2 | 1.046 | 64666.3 |
138 | 2024-03-28 21:43:37 | passengers | 1 | 67641 | 2 | 1.360 | 49736.0 |
137 | 2024-03-28 01:28:35 | passengers | 1 | 67641 | 2 | 2.593 | 26086.0 |
136 | 2024-03-27 13:31:14 | passengers | 2 | 108824 | 4 | 11.170 | 9742.5 |
135 | 2024-03-27 07:54:21 | passengers | 1 | 67641 | 2 | 1.173 | 57665.0 |
134 | 2024-03-27 07:53:29 | passengers | 1 | 67641 | 2 | 1.170 | 57812.8 |
133 | 2024-03-21 01:44:21 | passengers | 4 | 161450 | 233 | 33.910 | 4761.1 |
132 | 2024-03-20 21:01:19 | passengers | 2 | 108824 | 4 | 7.843 | 13875.3 |
131 | 2024-03-20 21:01:00 | passengers | 3 | 140603 | 27 | 16.110 | 8727.7 |
130 | 2024-03-20 18:44:53 | passengers | 1 | 67641 | 2 | 1.140 | 59334.2 |
129 | 2024-03-18 13:08:17 | passengers | 4 | 161450 | 233 | 22.796 | 7082.4 |
128 | 2024-03-18 13:08:17 | passengers | 3 | 140603 | 27 | 20.203 | 6959.5 |
127 | 2024-03-18 13:08:16 | passengers | 2 | 108824 | 4 | 7.623 | 14275.7 |
126 | 2024-03-18 11:06:53 | passengers | 1 | 67641 | 2 | 2.500 | 27056.4 |
125 | 2024-02-26 20:19:18 | passengers | 1 | 67641 | 2 | 1.186 | 57032.9 |
124 | 2024-02-25 21:23:38 | passengers | 4 | 161450 | 233 | 30.096 | 5364.5 |
123 | 2024-02-25 21:23:33 | passengers | 3 | 140603 | 27 | 23.783 | 5911.9 |
122 | 2024-02-25 21:23:30 | passengers | 2 | 108824 | 4 | 11.173 | 9739.9 |
121 | 2024-02-25 21:03:46 | passengers | 1 | 67641 | 2 | 1.310 | 51634.4 |
120 | 2024-02-21 01:00:52 | passengers | 4 | 161450 | 233 | 14.796 | 10911.7 |
119 | 2024-02-19 04:42:47 | passengers | 4 | 161450 | 233 | 28.986 | 5569.9 |
118 | 2024-02-19 04:42:48 | passengers | 3 | 140603 | 27 | 16.203 | 8677.6 |
117 | 2024-02-19 04:42:47 | passengers | 2 | 108824 | 4 | 11.063 | 9836.8 |
116 | 2024-02-18 20:11:02 | passengers | 1 | 67641 | 2 | 2.530 | 26735.6 |
115 | 2024-02-13 12:16:11 | passengers | 1 | 67641 | 2 | 2.170 | 31171.0 |
114 | 2024-02-07 13:47:30 | passengers | 1 | 67641 | 2 | 1.233 | 54858.9 |
113 | 2024-02-05 09:34:47 | passengers | 1 | 67641 | 2 | 1.236 | 54725.7 |
112 | 2024-01-26 07:48:31 | passengers | 1 | 67641 | 2 | 1.250 | 54112.8 |
111 | 2024-01-22 08:13:43 | passengers | 1 | 67641 | 2 | 1.123 | 60232.4 |
110 | 2023-12-26 00:01:23 | passengers | 1 | 67641 | 2 | 1.156 | 58513.0 |
109 | 2023-12-25 06:21:01 | passengers | 1 | 67641 | 2 | 1.063 | 63632.2 |
108 | 2023-10-15 13:26:54 | passengers | 1 | 67641 | 2 | 1.046 | 64666.3 |
107 | 2023-08-11 15:06:19 | passengers | 1 | 67641 | 2 | 1.156 | 58513.0 |
106 | 2023-07-23 16:45:05 | passengers | 1 | 67641 | 2 | 1.170 | 57812.8 |
105 | 2023-05-13 23:26:48 | passengers | 1 | 67641 | 2 | 1.063 | 63632.2 |
104 | 2023-03-10 00:28:03 | passengers | 1 | 67641 | 2 | 1.000 | 67641.0 |
103 | 2023-01-26 18:07:40 | passengers | 1 | 67641 | 2 | 1.126 | 60071.9 |
102 | 2021-01-29 12:11:26 | passengers | 1 | 67641 | 2 | 1.453 | 46552.6 |
101 | 2020-11-09 23:56:08 | passengers | 1 | 67641 | 2 | 1.330 | 50857.9 |
100 | 2020-10-31 06:39:54 | passengers | 1 | 67641 | 2 | 1.186 | 57032.9 |
99 | 2020-09-15 03:23:05 | passengers | 1 | 67641 | 2 | 1.030 | 65670.9 |
98 | 2020-07-23 17:33:58 | passengers | 1 | 67641 | 2 | 1.110 | 60937.8 |
97 | 2020-04-01 00:27:24 | passengers | 1 | 67641 | 2 | 1.156 | 58513.0 |
96 | 2020-03-26 03:50:05 | passengers | 1 | 67641 | 2 | 1.233 | 54858.9 |
95 | 2020-02-21 21:31:37 | passengers | 4 | 161450 | 233 | 9.546 | 16912.8 |
94 | 2020-02-17 17:30:34 | passengers | 1 | 67641 | 2 | 1.343 | 50365.6 |
93 | 2020-02-10 09:21:05 | passengers | 4 | 161450 | 233 | 18.876 | 8553.2 |
92 | 2020-02-09 20:58:53 | passengers | 4 | 161450 | 233 | 13.690 | 11793.3 |
91 | 2020-02-08 04:52:37 | passengers | 4 | 161450 | 233 | 19.483 | 8286.7 |
90 | 2020-02-07 04:44:28 | passengers | 4 | 161450 | 233 | 24.800 | 6510.1 |
89 | 2020-02-06 08:46:22 | passengers | 1 | 67641 | 2 | 2.593 | 26086.0 |
88 | 2020-02-06 08:33:00 | passengers | 4 | 161450 | 233 | 27.796 | 5808.4 |
87 | 2020-02-06 01:54:27 | passengers | 3 | 140603 | 27 | 7.860 | 17888.4 |
86 | 2020-02-06 01:53:50 | passengers | 4 | 161450 | 233 | 12.906 | 12509.7 |
85 | 2020-02-06 01:53:38 | passengers | 2 | 108824 | 4 | 4.250 | 25605.6 |
84 | 2020-02-05 22:36:14 | passengers | 1 | 67641 | 2 | 1.296 | 52192.1 |
83 | 2020-01-30 10:11:36 | passengers | 1 | 67641 | 2 | 1.220 | 55443.4 |
82 | 2020-01-28 00:18:32 | passengers | 1 | 67641 | 2 | 1.250 | 54112.8 |
81 | 2020-01-23 04:27:42 | passengers | 1 | 67641 | 2 | 1.640 | 41244.5 |
80 | 2020-01-21 20:31:17 | passengers | 1 | 67641 | 2 | 3.500 | 19326.0 |
79 | 2020-01-13 10:10:46 | passengers | 1 | 67641 | 2 | 2.440 | 27721.7 |
78 | 2020-01-03 01:43:41 | passengers | 1 | 67641 | 2 | 2.063 | 32787.7 |
77 | 2020-01-02 23:38:03 | passengers | 1 | 67641 | 2 | 1.283 | 52721.0 |
76 | 2019-12-21 00:43:43 | passengers | 1 | 67641 | 2 | 1.046 | 64666.3 |
75 | 2019-09-19 20:43:55 | passengers | 1 | 67641 | 2 | 0.940 | 71958.5 |
74 | 2019-07-22 19:20:50 | passengers | 1 | 67641 | 2 | 0.983 | 68810.8 |
73 | 2019-06-14 00:04:05 | passengers | 1 | 67641 | 2 | 1.000 | 67641.0 |
72 | 2019-03-14 03:24:38 | passengers | 1 | 67641 | 2 | 1.076 | 62863.4 |
71 | 2019-03-10 22:28:40 | passengers | 1 | 67641 | 2 | 1.066 | 63453.1 |
70 | 2019-02-23 10:35:27 | passengers | 1 | 67641 | 2 | 1.150 | 58818.3 |
69 | 2018-10-28 16:20:21 | passengers | 1 | 67641 | 2 | 1.273 | 53135.1 |
68 | 2018-07-24 14:26:59 | passengers | 1 | 67641 | 2 | 1.110 | 60937.8 |
67 | 2018-06-23 21:23:15 | passengers | 1 | 67641 | 2 | 1.220 | 55443.4 |
66 | 2018-06-12 05:05:31 | passengers | 1 | 67641 | 2 | 1.013 | 66773.0 |
65 | 2018-05-11 20:53:07 | passengers | 1 | 67641 | 2 | 1.050 | 64420.0 |
64 | 2018-04-22 05:09:53 | passengers | 1 | 67641 | 2 | 1.130 | 59859.3 |
63 | 2018-02-08 00:31:44 | passengers | 1 | 67641 | 2 | 1.410 | 47972.3 |
62 | 2017-08-08 03:28:15 | passengers | 1 | 67641 | 2 | 1.990 | 33990.5 |
61 | 2017-06-22 16:33:13 | passengers | 1 | 67641 | 2 | 2.073 | 32629.5 |
60 | 2016-12-14 01:06:08 | passengers | 1 | 67641 | 2 | 1.526 | 44325.7 |
59 | 2016-09-07 20:16:21 | passengers | 1 | 67641 | 2 | 3.166 | 21364.8 |
58 | 2016-08-22 20:09:37 | passengers | 1 | 67641 | 2 | 1.363 | 49626.6 |
57 | 2016-08-19 23:07:26 | passengers | 1 | 67641 | 2 | 1.880 | 35979.3 |
56 | 2016-08-15 07:34:14 | passengers | 1 | 67641 | 2 | 1.446 | 46778.0 |
55 | 2016-08-06 18:41:30 | passengers | 1 | 67641 | 2 | 1.923 | 35174.7 |
54 | 2016-08-01 04:46:17 | passengers | 1 | 67641 | 2 | 1.303 | 51911.7 |
53 | 2016-07-03 07:26:41 | passengers | 1 | 67641 | 2 | 3.320 | 20373.8 |
52 | 2016-07-01 04:34:39 | passengers | 1 | 67641 | 2 | 1.816 | 37247.2 |
51 | 2016-06-29 02:59:46 | passengers | 2 | 108824 | 4 | 12.110 | 8986.3 |
50 | 2016-06-28 08:25:48 | passengers | 4 | 161450 | 233 | 59.486 | 2714.1 |
49 | 2016-06-25 21:55:01 | passengers | 3 | 140603 | 27 | 10.850 | 12958.8 |
48 | 2016-06-20 14:47:55 | passengers | 1 | 67641 | 2 | 1.796 | 37662.0 |
47 | 2016-04-13 08:25:30 | passengers | 1 | 67641 | 2 | 3.536 | 19129.2 |
46 | 2015-12-27 09:03:48 | passengers | 1 | 67641 | 2 | 3.260 | 20748.8 |
45 | 2015-11-22 03:16:53 | passengers | 1 | 67641 | 2 | 1.090 | 62056.0 |