History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"photog"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 3122 | 2024-04-27 15:51:06 | photog | 1 | 48755 | 5 | 2.190 | 22262.6 |
| 3121 | 2024-04-27 03:09:13 | photog | 1 | 48755 | 5 | 1.860 | 26212.4 |
| 3120 | 2024-04-02 03:29:49 | photog | 2 | 82551 | 19 | 2.783 | 29662.6 |
| 3119 | 2024-04-02 03:29:37 | photog | 3 | 112716 | 213 | 5.610 | 20092.0 |
| 3118 | 2024-03-31 21:06:04 | photog | 2 | 82551 | 19 | 3.000 | 27517.0 |
| 3117 | 2024-03-31 21:05:59 | photog | 3 | 112716 | 213 | 5.983 | 18839.4 |
| 3116 | 2024-03-05 15:08:30 | photog | 2 | 82551 | 19 | 2.546 | 32423.8 |
| 3115 | 2024-03-05 15:08:14 | photog | 3 | 112716 | 213 | 5.393 | 20900.4 |
| 3114 | 2024-03-02 18:17:25 | photog | 2 | 82551 | 19 | 6.360 | 12979.7 |
| 3113 | 2024-03-02 06:51:37 | photog | 2 | 82551 | 19 | 6.813 | 12116.7 |
| 3112 | 2024-03-02 06:51:24 | photog | 3 | 112716 | 213 | 6.063 | 18590.8 |
| 3111 | 2024-03-01 19:27:01 | photog | 3 | 112716 | 213 | 6.216 | 18133.2 |
| 3110 | 2024-03-01 19:27:02 | photog | 2 | 82551 | 19 | 2.893 | 28534.7 |
| 3109 | 2024-03-01 19:26:59 | photog | 1 | 48755 | 5 | 0.923 | 52822.3 |
| 3108 | 2024-02-27 21:23:30 | photog | 1 | 48755 | 5 | 1.546 | 31536.2 |
| 3107 | 2024-02-04 11:26:02 | photog | 2 | 82551 | 19 | 5.126 | 16104.4 |
| 3106 | 2024-02-03 22:32:38 | photog | 2 | 82551 | 19 | 5.360 | 15401.3 |
| 3105 | 2024-02-03 22:32:06 | photog | 3 | 112716 | 213 | 5.216 | 21609.7 |
| 3104 | 2024-01-31 23:02:24 | photog | 2 | 82551 | 19 | 2.343 | 35233.0 |
| 3103 | 2024-01-31 23:02:12 | photog | 3 | 112716 | 213 | 5.890 | 19136.8 |
| 3102 | 2024-01-31 10:07:51 | photog | 3 | 112716 | 213 | 5.266 | 21404.5 |
| 3101 | 2024-01-31 10:07:47 | photog | 2 | 82551 | 19 | 2.466 | 33475.7 |
| 3100 | 2024-01-03 20:49:45 | photog | 1 | 48755 | 5 | 0.873 | 55847.7 |
| 3099 | 2023-12-10 05:54:06 | photog | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 3098 | 2023-11-26 21:05:07 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3097 | 2023-11-23 12:57:49 | photog | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 3096 | 2023-11-05 04:59:27 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3095 | 2023-10-27 00:00:13 | photog | 1 | 48755 | 5 | 0.846 | 57630.0 |
| 3094 | 2023-10-13 19:31:50 | photog | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 3093 | 2023-10-13 15:59:20 | photog | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 3092 | 2023-10-07 08:13:36 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3091 | 2023-09-24 12:25:04 | photog | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 3090 | 2023-09-14 09:53:53 | photog | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 3089 | 2023-08-22 08:44:56 | photog | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 3088 | 2023-06-16 18:14:20 | photog | 1 | 48755 | 5 | 0.796 | 61250.0 |
| 3087 | 2023-05-22 13:11:23 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3086 | 2023-03-18 01:56:34 | photog | 1 | 48755 | 5 | 0.893 | 54596.9 |
| 3085 | 2023-02-15 06:49:20 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3084 | 2023-02-11 21:12:13 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3083 | 2023-01-07 12:06:33 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3082 | 2022-12-11 19:55:31 | photog | 2 | 82551 | 19 | 2.093 | 39441.5 |
| 3081 | 2022-10-14 13:24:04 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3080 | 2022-10-02 14:21:47 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3079 | 2022-07-28 22:35:28 | photog | 2 | 82551 | 19 | 2.093 | 39441.5 |
| 3078 | 2022-07-01 12:11:34 | photog | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 3077 | 2022-06-18 05:24:25 | photog | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 3076 | 2022-06-13 00:59:11 | photog | 1 | 48755 | 5 | 0.766 | 63648.8 |
| 3075 | 2022-05-21 07:11:59 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3074 | 2022-02-07 00:12:52 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3073 | 2022-01-29 03:23:59 | photog | 1 | 48755 | 5 | 0.856 | 56956.8 |
| 3072 | 2021-11-26 16:37:04 | photog | 1 | 48755 | 5 | 0.860 | 56691.9 |
| 3071 | 2021-10-12 09:06:07 | photog | 1 | 48755 | 5 | 0.733 | 66514.3 |
| 3070 | 2021-10-06 04:37:24 | photog | 1 | 48755 | 5 | 0.780 | 62506.4 |
| 3069 | 2021-10-04 01:13:45 | photog | 1 | 48755 | 5 | 0.830 | 58741.0 |
| 3068 | 2021-09-22 06:18:41 | photog | 1 | 48755 | 5 | 0.750 | 65006.7 |
| 3067 | 2021-09-15 05:56:33 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3066 | 2021-09-14 20:43:05 | photog | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 3065 | 2021-07-11 04:27:57 | photog | 1 | 48755 | 5 | 0.890 | 54780.9 |
| 3064 | 2021-07-09 15:08:56 | photog | 3 | 112716 | 213 | 5.640 | 19985.1 |
| 3063 | 2021-05-28 22:27:48 | photog | 3 | 112716 | 213 | 4.843 | 23274.0 |
| 3062 | 2021-05-27 12:07:48 | photog | 1 | 48755 | 5 | 0.843 | 57835.1 |
| 3061 | 2021-05-03 06:10:12 | photog | 3 | 112716 | 213 | 4.830 | 23336.6 |
| 3060 | 2021-05-02 14:39:26 | photog | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 3059 | 2021-05-01 17:06:13 | photog | 1 | 48755 | 5 | 0.826 | 59025.4 |
| 3058 | 2021-04-26 10:42:03 | photog | 3 | 112716 | 213 | 4.623 | 24381.6 |
| 3057 | 2021-04-26 10:08:19 | photog | 3 | 112716 | 213 | 6.580 | 17130.1 |
| 3056 | 2021-04-26 09:09:51 | photog | 3 | 112716 | 213 | 4.530 | 24882.1 |
| 3055 | 2021-04-26 08:38:22 | photog | 3 | 112716 | 213 | 4.830 | 23336.6 |
| 3054 | 2021-04-26 08:04:38 | photog | 3 | 112716 | 213 | 4.596 | 24524.8 |
| 3053 | 2021-04-26 06:02:57 | photog | 3 | 112716 | 213 | 4.580 | 24610.5 |
| 3052 | 2021-04-26 05:02:24 | photog | 3 | 112716 | 213 | 4.703 | 23966.8 |
| 3051 | 2021-04-26 03:31:08 | photog | 3 | 112716 | 213 | 4.703 | 23966.8 |
| 3050 | 2021-04-26 02:59:15 | photog | 3 | 112716 | 213 | 4.576 | 24632.0 |
| 3049 | 2021-04-26 02:26:35 | photog | 3 | 112716 | 213 | 5.673 | 19868.9 |
| 3048 | 2021-04-26 01:22:57 | photog | 3 | 112716 | 213 | 10.596 | 10637.6 |
| 3047 | 2021-04-25 23:18:56 | photog | 3 | 112716 | 213 | 5.563 | 20261.7 |
| 3046 | 2021-04-25 21:16:42 | photog | 3 | 112716 | 213 | 5.203 | 21663.7 |
| 3045 | 2021-04-20 23:44:38 | photog | 3 | 112716 | 213 | 5.546 | 20323.8 |
| 3044 | 2021-04-11 15:45:18 | photog | 1 | 48755 | 5 | 0.813 | 59969.2 |
| 3043 | 2021-04-05 18:41:04 | photog | 3 | 112716 | 213 | 4.720 | 23880.5 |
| 3042 | 2021-04-01 14:33:58 | photog | 3 | 112716 | 213 | 5.076 | 22205.7 |
| 3041 | 2021-03-31 01:10:36 | photog | 1 | 48755 | 5 | 1.640 | 29728.7 |
| 3040 | 2021-03-19 15:15:32 | photog | 3 | 112716 | 213 | 5.406 | 20850.2 |
| 3039 | 2021-03-19 14:46:08 | photog | 3 | 112716 | 213 | 4.703 | 23966.8 |
| 3038 | 2021-03-19 13:46:13 | photog | 3 | 112716 | 213 | 11.470 | 9827.0 |
| 3037 | 2021-03-19 13:15:23 | photog | 3 | 112716 | 213 | 6.233 | 18083.7 |
| 3036 | 2021-03-19 12:43:44 | photog | 3 | 112716 | 213 | 4.766 | 23650.0 |
| 3035 | 2021-03-19 12:43:39 | photog | 3 | 112716 | 213 | 5.000 | 22543.2 |
| 3034 | 2021-03-19 11:43:45 | photog | 3 | 112716 | 213 | 6.266 | 17988.5 |
| 3033 | 2021-03-19 11:10:59 | photog | 3 | 112716 | 213 | 5.703 | 19764.3 |
| 3032 | 2021-03-19 10:40:46 | photog | 3 | 112716 | 213 | 5.610 | 20092.0 |
| 3031 | 2021-03-19 10:08:02 | photog | 3 | 112716 | 213 | 8.250 | 13662.5 |
| 3030 | 2021-03-19 09:39:17 | photog | 3 | 112716 | 213 | 4.950 | 22770.9 |
| 3029 | 2021-03-19 09:06:38 | photog | 3 | 112716 | 213 | 6.110 | 18447.8 |
| 3028 | 2021-03-19 08:35:44 | photog | 3 | 112716 | 213 | 5.440 | 20719.9 |
| 3027 | 2021-03-19 08:04:14 | photog | 3 | 112716 | 213 | 6.046 | 18643.1 |
| 3026 | 2021-03-19 07:33:36 | photog | 3 | 112716 | 213 | 5.830 | 19333.8 |
| 3025 | 2021-03-19 07:01:44 | photog | 3 | 112716 | 213 | 5.610 | 20092.0 |
| 3024 | 2021-03-19 06:29:50 | photog | 3 | 112716 | 213 | 5.343 | 21096.0 |
| 3023 | 2021-03-19 05:57:48 | photog | 3 | 112716 | 213 | 5.500 | 20493.8 |