History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"squiffy"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 107 | 2024-05-06 09:04:11 | squiffy | 1 | 69583 | 1 | 1.330 | 52318.0 |
| 106 | 2024-04-28 02:18:09 | squiffy | 1 | 69583 | 1 | 3.046 | 22844.1 |
| 105 | 2024-04-06 04:14:34 | squiffy | 1 | 69583 | 1 | 4.940 | 14085.6 |
| 104 | 2024-02-28 00:50:09 | squiffy | 1 | 69583 | 1 | 1.263 | 55093.4 |
| 103 | 2024-01-21 05:42:24 | squiffy | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 102 | 2023-12-31 12:03:54 | squiffy | 2 | 107671 | 12 | 2.783 | 38688.8 |
| 101 | 2023-12-14 19:14:23 | squiffy | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 100 | 2023-12-02 22:56:06 | squiffy | 1 | 69583 | 1 | 1.080 | 64428.7 |
| 99 | 2023-11-19 21:00:16 | squiffy | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 98 | 2023-11-17 23:24:27 | squiffy | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 97 | 2023-11-04 12:57:25 | squiffy | 1 | 69583 | 1 | 1.140 | 61037.7 |
| 96 | 2023-10-13 08:48:12 | squiffy | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 95 | 2023-10-02 19:16:08 | squiffy | 2 | 107671 | 12 | 3.216 | 33479.8 |
| 94 | 2023-09-26 01:04:15 | squiffy | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 93 | 2023-09-13 13:46:52 | squiffy | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 92 | 2023-09-04 05:11:13 | squiffy | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 91 | 2023-07-14 12:25:14 | squiffy | 2 | 107671 | 12 | 3.030 | 35535.0 |
| 90 | 2023-03-31 10:46:01 | squiffy | 2 | 107671 | 12 | 2.703 | 39833.9 |
| 89 | 2023-01-09 07:50:39 | squiffy | 1 | 69583 | 1 | 1.046 | 66522.9 |
| 88 | 2022-12-28 06:50:48 | squiffy | 2 | 107671 | 12 | 3.046 | 35348.3 |
| 87 | 2022-10-20 07:29:43 | squiffy | 1 | 69583 | 1 | 1.190 | 58473.1 |
| 86 | 2022-08-29 04:48:18 | squiffy | 2 | 107671 | 12 | 3.300 | 32627.6 |
| 85 | 2022-06-11 01:22:11 | squiffy | 1 | 69583 | 1 | 1.156 | 60192.9 |
| 84 | 2022-06-08 20:00:48 | squiffy | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 83 | 2022-03-03 15:09:23 | squiffy | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 82 | 2021-07-18 00:24:57 | squiffy | 1 | 69583 | 1 | 1.093 | 63662.4 |
| 81 | 2021-05-07 12:00:19 | squiffy | 1 | 69583 | 1 | 1.110 | 62687.4 |
| 80 | 2021-01-21 05:33:10 | squiffy | 1 | 69583 | 1 | 1.153 | 60349.5 |
| 79 | 2020-11-01 07:58:49 | squiffy | 1 | 69583 | 1 | 1.076 | 64668.2 |
| 78 | 2020-03-28 15:57:32 | squiffy | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 77 | 2020-03-28 08:38:41 | squiffy | 1 | 69583 | 1 | 1.313 | 52995.4 |
| 76 | 2020-03-27 13:25:37 | squiffy | 1 | 69583 | 1 | 1.203 | 57841.2 |
| 75 | 2020-03-23 08:38:04 | squiffy | 1 | 69583 | 1 | 1.233 | 56433.9 |
| 74 | 2020-02-28 16:37:12 | squiffy | 1 | 69583 | 1 | 1.296 | 53690.6 |
| 73 | 2020-02-11 11:09:42 | squiffy | 1 | 69583 | 1 | 1.373 | 50679.5 |
| 72 | 2020-02-05 06:49:57 | squiffy | 1 | 69583 | 1 | 1.393 | 49951.9 |
| 71 | 2020-02-04 14:50:15 | squiffy | 1 | 69583 | 1 | 2.186 | 31831.2 |
| 70 | 2020-01-30 08:02:42 | squiffy | 1 | 69583 | 1 | 2.830 | 24587.6 |
| 69 | 2020-01-29 21:57:19 | squiffy | 1 | 69583 | 1 | 1.220 | 57035.2 |
| 68 | 2020-01-22 03:49:34 | squiffy | 1 | 69583 | 1 | 3.390 | 20526.0 |
| 67 | 2020-01-15 16:32:34 | squiffy | 1 | 69583 | 1 | 1.186 | 58670.3 |
| 66 | 2020-01-04 20:32:42 | squiffy | 1 | 69583 | 1 | 1.250 | 55666.4 |
| 65 | 2020-01-01 14:26:21 | squiffy | 1 | 69583 | 1 | 1.360 | 51164.0 |
| 64 | 2019-12-04 20:17:54 | squiffy | 1 | 69583 | 1 | 1.170 | 59472.6 |
| 63 | 2019-08-30 12:40:22 | squiffy | 1 | 69583 | 1 | 1.276 | 54532.1 |
| 62 | 2019-05-08 21:34:32 | squiffy | 1 | 69583 | 1 | 1.103 | 63085.2 |
| 61 | 2019-01-03 15:52:00 | squiffy | 1 | 69583 | 1 | 1.106 | 62914.1 |
| 60 | 2018-12-28 13:03:20 | squiffy | 1 | 69583 | 1 | 1.173 | 59320.5 |
| 59 | 2018-12-27 15:03:29 | squiffy | 1 | 69583 | 1 | 1.160 | 59985.3 |
| 58 | 2018-08-01 00:14:38 | squiffy | 1 | 69583 | 1 | 2.266 | 30707.4 |
| 57 | 2018-07-01 04:48:46 | squiffy | 1 | 69583 | 1 | 1.126 | 61796.6 |
| 56 | 2017-07-25 03:43:15 | squiffy | 1 | 69583 | 1 | 1.370 | 50790.5 |
| 55 | 2017-02-11 07:56:39 | squiffy | 1 | 69583 | 1 | 1.680 | 41418.5 |
| 54 | 2016-10-23 17:43:16 | squiffy | 1 | 69583 | 1 | 1.830 | 38023.5 |
| 53 | 2016-10-22 16:18:07 | squiffy | 4 | 151207 | 578 | 14.143 | 10691.3 |
| 52 | 2016-10-14 04:33:59 | squiffy | 1 | 69583 | 1 | 1.630 | 42689.0 |
| 51 | 2016-09-07 19:56:57 | squiffy | 1 | 69583 | 1 | 3.570 | 19491.0 |
| 50 | 2016-07-30 16:51:13 | squiffy | 1 | 69583 | 1 | 1.823 | 38169.5 |
| 49 | 2016-07-07 10:20:54 | squiffy | 1 | 69583 | 1 | 2.476 | 28103.0 |
| 48 | 2016-07-06 13:41:27 | squiffy | 1 | 69583 | 1 | 1.853 | 37551.5 |
| 47 | 2016-07-01 09:26:57 | squiffy | 1 | 69583 | 1 | 6.010 | 11577.9 |
| 46 | 2016-06-30 10:39:28 | squiffy | 1 | 69583 | 1 | 2.273 | 30612.8 |
| 45 | 2016-06-27 03:31:36 | squiffy | 4 | 151207 | 578 | 13.116 | 11528.4 |
| 44 | 2016-06-26 08:23:25 | squiffy | 1 | 69583 | 1 | 1.630 | 42689.0 |
| 43 | 2016-06-25 14:00:58 | squiffy | 1 | 69583 | 1 | 1.456 | 47790.5 |
| 42 | 2016-06-24 06:51:33 | squiffy | 2 | 107671 | 12 | 7.143 | 15073.6 |
| 41 | 2016-06-19 09:57:44 | squiffy | 3 | 134027 | 87 | 12.683 | 10567.5 |
| 40 | 2016-06-17 15:22:11 | squiffy | 4 | 151207 | 578 | 18.480 | 8182.2 |
| 39 | 2016-06-12 14:01:30 | squiffy | 4 | 151207 | 578 | 21.320 | 7092.3 |
| 38 | 2016-06-05 06:20:36 | squiffy | 4 | 151207 | 578 | 38.173 | 3961.1 |
| 37 | 2016-06-02 16:32:40 | squiffy | 4 | 151207 | 578 | 18.566 | 8144.3 |
| 36 | 2016-06-01 09:48:01 | squiffy | 4 | 151207 | 578 | 12.026 | 12573.3 |
| 35 | 2016-05-14 09:17:57 | squiffy | 1 | 69583 | 1 | 1.160 | 59985.3 |
| 34 | 2016-05-11 21:01:08 | squiffy | 4 | 151207 | 578 | 34.173 | 4424.8 |
| 33 | 2016-03-11 05:17:01 | squiffy | 1 | 69583 | 1 | 1.236 | 56296.9 |
| 32 | 2016-03-08 10:43:49 | squiffy | 1 | 69583 | 1 | 1.253 | 55533.1 |
| 31 | 2016-01-03 20:36:07 | squiffy | 4 | 151207 | 578 | 12.593 | 12007.2 |
| 30 | 2015-12-30 02:11:30 | squiffy | 4 | 151207 | 578 | 11.783 | 12832.6 |
| 29 | 2015-12-29 21:59:01 | squiffy | 4 | 151207 | 578 | 11.873 | 12735.4 |
| 28 | 2015-12-28 20:58:14 | squiffy | 4 | 151207 | 578 | 20.050 | 7541.5 |
| 27 | 2015-12-23 21:42:09 | squiffy | 4 | 151207 | 578 | 20.136 | 7509.3 |
| 26 | 2015-12-22 11:02:55 | squiffy | 4 | 151207 | 578 | 22.623 | 6683.8 |
| 25 | 2015-12-21 06:56:25 | squiffy | 4 | 151207 | 578 | 20.903 | 7233.7 |
| 24 | 2015-12-18 16:11:12 | squiffy | 4 | 151207 | 578 | 13.473 | 11223.0 |
| 23 | 2015-12-15 00:42:42 | squiffy | 4 | 151207 | 578 | 16.200 | 9333.8 |
| 22 | 2015-12-06 07:51:34 | squiffy | 4 | 151207 | 578 | 17.776 | 8506.2 |
| 21 | 2015-11-19 11:02:07 | squiffy | 4 | 151207 | 578 | 12.246 | 12347.5 |
| 20 | 2015-11-13 14:59:10 | squiffy | 4 | 151207 | 578 | 11.010 | 13733.6 |
| 19 | 2015-11-13 14:57:21 | squiffy | 4 | 151207 | 578 | 11.086 | 13639.5 |
| 18 | 2015-11-13 14:39:26 | squiffy | 1 | 69583 | 1 | 2.496 | 27877.8 |
| 17 | 2015-07-12 17:34:50 | squiffy | 3 | 134027 | 87 | 15.383 | 8712.7 |
| 16 | 2015-07-10 08:16:07 | squiffy | 2 | 107671 | 12 | 3.723 | 28920.5 |
| 15 | 2015-07-09 05:57:08 | squiffy | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 14 | 2015-06-10 22:39:55 | squiffy | 1 | 69583 | 1 | 1.730 | 40221.4 |
| 13 | 2015-05-08 16:47:45 | squiffy | 1 | 69583 | 1 | 1.423 | 48898.8 |
| 12 | 2015-05-04 20:55:32 | squiffy | 1 | 69583 | 1 | 1.466 | 47464.5 |
| 11 | 2015-04-13 23:16:53 | squiffy | 1 | 69583 | 1 | 2.940 | 23667.7 |
| 10 | 2015-03-19 06:52:42 | squiffy | 1 | 69583 | 1 | 2.673 | 26031.8 |
| 9 | 2015-01-17 20:18:03 | squiffy | 1 | 69583 | 1 | 2.930 | 23748.5 |
| 8 | 2014-11-01 07:43:44 | squiffy | 1 | 69583 | 1 | 1.906 | 36507.3 |